Link to home
Start Free TrialLog in
Avatar of sudama
sudama

asked on

How to convert Folio Bound Views .nfo file to mysql database?

I have a file which is about 100MB in size.  It is a Folio Bound Views .nfo file.  Folio Bound Views is a legacy software which was used about 7-8 years ago for accessing and reading large databases.  The .nfo file is a flat database text file with numbers and letters as delimiters for each record.  

If you are not familiar with this type of file you might be able to find more information here:

http://folio.com/section.asp?f=toc§ion=Products&path=Products/additional%20products/folio/folio_views.xml

The folio software line was purchased by NextPage in 1999, they no longer support folio but offer a migration tool for people to upgrade their old .nfo files.

What I want to do is get all the info in the flat database file (the .nfo file) into a mysql database.

Anyone know how to do this?
ASKER CERTIFIED SOLUTION
Avatar of kelfink
kelfink

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sudama
sudama

ASKER

Hmm, I had a look at that it should work but I'm not sure if the delimiters in my files are set up correctly.  Anyway here's the 300 pts for ya.