Mass import

[qedao]

Hello everyone:

I need to import a large number of records from a database and turn them into form submissions.

Im thinking just coding a script that reads a csv or similar and directly queries the mysql table for writing the records, but I get the feeling that it must be a more elegant way.

Any ideas anyone?

Thanks in advance

[Ben]

Hi Qedao,

I'm afraid not! Developing some sort of Import Manager module has been on the list for years, but nothing concrete planned just yet.

Sorry about that - good luck with it!

- Ben

[qedao]

Ben,

Thanks for the reply, I guess i can always try to populate the appropriate table using the import facility of phpmyadmin?

You think that might cause some problem?

Thank you

[Ben]

Hi Qedao,

Yeah, that should work fine! However, make sure the form you're importing the data into just has textboxes or textareas for everything. Other field types (like selects, radios, checkboxes etc) store the info in different ways. If you keep it as basic as possible, you could import the data then try changing the data types later on.

Good luck!

- Ben