Solved

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

Posted on 2002-03-10
2
3,459 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …

733 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