Import a CSV to CMSMS database through admin panel
Posted: Thu Jun 13, 2013 3:22 am
Hi Guys, hope you can help me out here.
Im on CMSMS 1.9.1 "Toopua", Running php5 on a linux server
I created a new table called 'products' with about 30 fields in it. It's for a custom modification I did to a client's website. I have a CSV file with 200 products in it (with locally hosted image links) and currently I go to phpMyAdmin then delete existing rows and import the CSV and everything works fine.
Now my client wants to update the product list by him self and upload it to the database. He can update the CSV easily but is there a way I can let him upload it to that particular table through CMSMS admin panel so he doesn't have to mess with phpMyAdmin ? Thanks a lot.
Im on CMSMS 1.9.1 "Toopua", Running php5 on a linux server
I created a new table called 'products' with about 30 fields in it. It's for a custom modification I did to a client's website. I have a CSV file with 200 products in it (with locally hosted image links) and currently I go to phpMyAdmin then delete existing rows and import the CSV and everything works fine.
Now my client wants to update the product list by him self and upload it to the database. He can update the CSV easily but is there a way I can let him upload it to that particular table through CMSMS admin panel so he doesn't have to mess with phpMyAdmin ? Thanks a lot.