Page 1 of 1

database uploads is it possible?

Posted: Tue Dec 18, 2007 9:08 pm
by ozzie
Hi guys,
I wanted to know if it is possible to upload a large number of database records to say for example the business registry module.
so that I don't have to type enter every single one of them [ 1800 records ]
Also as a general question regarding larger dbs of user names and passwords an ddetails etc.

Is there provision for uploading files through csms ms or do I have to go through the mysql server?
thanks.

Re: database uploads is it possible?

Posted: Wed Dec 19, 2007 1:41 pm
by Ted
There is nothing directly in CMSMS for this kind of thing.  Generally, any type of custom data import will be done directly with mysql.  You'll probably want to start researching how to get CSV data (like a export from Excel) into MySQL.  Using phpMyAdmin always helps make it a little less painful, but you'll still have a bit of work ahead of you to get it going.  It'll be a good learning experience.  :)

Good luck!