to update DB it is tep_db_query to be used instead tep_db_input
Many thanks.
Edited by xvoyance, 26 April 2012 - 11:33 PM.
Latest News: (loading..)
1
24 replies to this topic
#22
Posted 27 April 2012 - 08:15 AM
it looks like the wheel sometimes does need reinventing if it doesnt fit for a specific purpose. 
Ken
Ken
commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile).
over 20 years of computer programming experience.
over 20 years of computer programming experience.
#24
Posted 27 April 2012 - 08:07 PM
nope.
ken
ken
commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile).
over 20 years of computer programming experience.
over 20 years of computer programming experience.
#25
Posted 18 January 2013 - 11:56 AM
I did this ages ago with a bookstore site - I got a program called reader ware and a scanner - scanned all the books in and the program dragged all the images off the internet, then exported the full details of each book in a batch (in this case it was around 10,000-20,000 unique products) to excel and wrote a quick excel vba file to sort the exported file to easy populate format. I exported all the images to a folder, uploaded them all to the images directory ... I have already installed and modified an autothumb creator which worked on the fly. Then I ran easy populate and bingo the whole thing worked fine.
When the client wanted to add books, all he did was scan into reader ware adding the book to that database and run a script I had written to upload everything - he did this twice a day - mostly only making changes to the database for items sold, changed etc.
My advice - use easy populate and a proprietary library database - you can get them for you iPhone now and export them in delimited text - the images you already have so this is a really simple use of easy populate - all you do is copy and paste columns to the right place in a demo file which you download from your own server showing you which fields do what - its all column and line based so it would be easy to do manually for the first upload - you could do 100s of thousands of records like this in a few hours
Have fun
When the client wanted to add books, all he did was scan into reader ware adding the book to that database and run a script I had written to upload everything - he did this twice a day - mostly only making changes to the database for items sold, changed etc.
My advice - use easy populate and a proprietary library database - you can get them for you iPhone now and export them in delimited text - the images you already have so this is a really simple use of easy populate - all you do is copy and paste columns to the right place in a demo file which you download from your own server showing you which fields do what - its all column and line based so it would be easy to do manually for the first upload - you could do 100s of thousands of records like this in a few hours
Have fun
