Flat File to Database Conversion

[phpkemist]

I need help migrating data from an existing flat file to a new database table.

I have an installation of Easy PHP Calendar that has an existing flat file for existing data records. The data file was easy to move to the new server and enable, but I'd like to start using a database. Is there an easy way (or EPC tool) to move the data from the flat file to the database table? Thanks for any feedback I can get!

[Brian]

We don't have a tool to do this. I'm not sure, but our moderator ve9gra over at www.epctutorials.com may be able to do it.

[phpkemist]

Since there is no tool, I'll leave the flat file system intact for the moment and develop a migration tool. Really just a case of reversing the flat file process then forming a clean SQL file to import, unless there's something I am missing. I presume no encryption and that the flat file is grepable? Thanks for your feedback! If I finish the tool and it works well, I'll post for review and distribution if it helps someone else.

[ve9gra]

Like Brian said, there's no tool available, but I will convert your file for you.

My original goal was to create the tool and to give it to Brian for inclusion in the calendar, but since Version 7 will not support a flat-file at all, I didn't see the need to work any further on the tool to make it end-user friendly. But I do have a private tool that works very well and had been tested with lots of end-user databases, even some very huge databases.

[phpkemist]

Gervais, that's a great offer, thank you. Seems like an cool automated service you could put Online for people to upload files for SQL conversion. Where may I deliver the flat file to for conversion, please? VERY cool of you to help me, thanks!!

[ve9gra]

You can zip and post your file right here, or if you want to keep your database private, use the link in my signature to get to my Contact Me form. I'll reply via email and then you can send it to me that way.

[Shumaker212]

Not Sure that it will work for you but i use dbload to for such aim.

Find Here : [admin removed]

[ve9gra]

The calendar's flat-file database is in a proprietary format that common utilities cannot work with.