nec Posted May 29, 2004 Share Posted May 29, 2004 Hi all, Well, i try to be clear cause i m a poor french man :-) I have actually one massive products update to do and i try to find a way to do that automatically via a texe file who contain all the informations requiered by the database... I know how to write a small app for the insertion of the new record in my site dbase..what i don't know is the name of all the tables wich are modifed when we record a new products in the dbase... I have more the 14440 products to insert in the dbase... What my app have to do is: do until eof(1) read the text file(1) take the data from 1 and put the data in the correct database table and field, loop Someone can give me the name of ALL the tables altered by an update products ? In this way i can order my texte file with all the data needed for all the table and after write down an automatic update app... The products are the same: only the description and the title are different, the attributes are the same, the price are the same etc etc... If someone can give me more info about the new products insertion process i really appreciate that... If an sql guru know how to update the products in one magic command i really agree his help too... I hope wich i have been clear. Waiting for your answers, Sam Link to comment Share on other sites More sharing options...
Guest Posted May 29, 2004 Share Posted May 29, 2004 why reinvent the wheel. look in the contribution support area for easy populate. when you have questions, etc, then go into the contribution support area and search for the thread easy populate, and at the end of the thread, post your questions there, do not create a new thread. Link to comment Share on other sites More sharing options...
nec Posted May 30, 2004 Author Share Posted May 30, 2004 Well, thanks for your answer i have checked easy populate but i like to write down my specific app for this massive update purpose... Is only all the products table altered when we add products or any others table are include in the process ? I think i do some test and comparaison between to db before and after update to know actually the tables involved in the update new products process... After i write down a small app in vb via myodbc for this purpose... Thanks for your help Sam Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.