Solved

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

Posted on 2002-03-10
2
3,435 Views
Last Modified: 2009-11-09
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?
0
Comment
Question by:sudama
2 Comments
 
LVL 5

Accepted Solution

by:
kelfink earned 300 total points
ID: 6857368
Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html.


I think it's flexible enough to handle what you're doing, although I'm not familiar with folio.

0
 

Author Comment

by:sudama
ID: 6915714
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.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question