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
Solved

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

Posted on 2002-03-10
2
3,447 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

840 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