demon2lima Posted November 15, 2005 Share Posted November 15, 2005 Anybody have a way to get easy populate to only update existing model numbers and not create new items if they don't exist? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2005 Share Posted November 15, 2005 Its ok i searched the forum and found out how to fix this problem! when downloading the txt file it added a extra " to my html then changed " & \" to something like #34 thats what was giving me the problem! now im having another problem with this mod! I have a download site when i upload the text file using easy populate it deletes the downloadable product information is there any way to stop this as its not going to help me out if i have to add ALL the 'downloadable product' info every time! Or is there some way maybe we could get the 3 boxes in downloadable product info ie filename, expiry days & max download count to be in the text file that gets downloaded?? any help with this please? :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2005 Share Posted November 15, 2005 Did you ever solve this problem? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2005 Share Posted November 15, 2005 Did you ever solve this problem? me? no its still unsolved! Quote Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2005 Share Posted November 15, 2005 if you are not updating the downloadable product info, then dont even include it in the upload, just leave those portions out of your spreadsheet. any help with this please? :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 Is there a way in EasyPopulate to upload one product in multiple categories? Example: Part Number: 445P99 in both categories: SHOES/BLUESHOES and SHOES/BLACKSHOES Thanks, 'T' Quote Link to comment Share on other sites More sharing options...
vondada Posted November 16, 2005 Share Posted November 16, 2005 I've installed Easy Populate correctly and it's uploading the tabbed file but it's only putting the last entry into the database. I've noticed that some other people are having the same problem, but there has been no solution posted. I've tried everything and the closest I've gotten it is that it updates the final record. Grrr. I feel like I'm wasting time with this program when I could be hand entering all my products. I've blown the better part of two days trying to debug this and searching for answers on the support forum and no luck. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 'Not So Easy Populate' I would call it... :) Quote Link to comment Share on other sites More sharing options...
vondada Posted November 16, 2005 Share Posted November 16, 2005 File uploaded. Temporary filename: /var/tmp/phpv3cXWf User filename: ep_upload_test.txt Size: 8311 | hhp | img001.jpg | Otto Premi | Otto Premi | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img002.jpg | Billy Wild | Billy Wild | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img003.jpg | Orson Well | Orson Well | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img004.jpg | Martin Sco | ?Taxi Driv | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img005.jpg | Francis Fo | ?Apocalyps | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img006.jpg | Francis Fo | ?The Godfa | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img007.jpg | John Cassa | John Cassa | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img008.jpg | George Luc | George Luc | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img009.jpg | Steven Spi | Steven Spi | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img010.jpg | Orson Well | Orson Well | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img011.jpg | Alfred Hit | ?Rear Wind | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img012.jpg | Alfred Hit | Alfred Hit | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img013.jpg | Stanley Ku | Stanley Ku | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img014.jpg | Stanley Ku | Stanley Ku | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img015.jpg | Frank Capr | Director F | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img021.jpg | Stanley Kr | Director S | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img033.jpg | Victor Fle | ?Gone With | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img045.jpg | Howard Haw | Columbia H | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img008.jpg | Billy Wild | ?Some Like | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 17 | 24x30 | | | 170 | 18 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported This is what I get upon upload and only the last record gets put into the db. It's driving me crazy. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 you need to give a bit more info rather than complaining. what do you mean about the last entry? how may records, etc are you talking about here? do you have eoreor after all the lines? I've installed Easy Populate correctly and it's uploading the tabbed file but it's only putting the last entry into the database. I've noticed that some other people are having the same problem, but there has been no solution posted. I've tried everything and the closest I've gotten it is that it updates the final record. Grrr. I feel like I'm wasting time with this program when I could be hand entering all my products. I've blown the better part of two days trying to debug this and searching for answers on the support forum and no luck. looking, everything has the same model #, which is hhp. everything needs to have a separate model #. File uploaded.Temporary filename: /var/tmp/phpv3cXWf User filename: ep_upload_test.txt Size: 8311 | hhp | img001.jpg | Otto Premi | Otto Premi | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img002.jpg | Billy Wild | Billy Wild | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img003.jpg | Orson Well | Orson Well | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img004.jpg | Martin Sco | ?Taxi Driv | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img005.jpg | Francis Fo | ?Apocalyps | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img006.jpg | Francis Fo | ?The Godfa | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img007.jpg | John Cassa | John Cassa | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img008.jpg | George Luc | George Luc | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img009.jpg | Steven Spi | Steven Spi | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img010.jpg | Orson Well | Orson Well | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img011.jpg | Alfred Hit | ?Rear Wind | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img012.jpg | Alfred Hit | Alfred Hit | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img013.jpg | Stanley Ku | Stanley Ku | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img014.jpg | Stanley Ku | Stanley Ku | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img015.jpg | Frank Capr | Director F | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img021.jpg | Stanley Kr | Director S | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img033.jpg | Victor Fle | ?Gone With | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img045.jpg | Howard Haw | Columbia H | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 18 | 24x30 | | | 170 | 19 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | hhp | img008.jpg | Billy Wild | ?Some Like | | | | | | | | 125 | 0 | | 11/15/2005 | 0 | 2 | Size | Gr??e | Talla | 15 | 11x14 | | | 0 | 16 | 16x20 | | | 75 | 17 | 20x24 | | | 125 | 17 | 24x30 | | | 170 | 18 | 30x40 | | | 270 | 20 | 36x48 | | | 470 | 21 | 48x56 | | | 670 | 22 | 8x10 | | | | 11 | 0 | 2 | Size | 0 | Talla | 22 | 8x10 | | | Directors | | | --none-- | Active Updated | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported This is what I get upon upload and only the last record gets put into the db. It's driving me crazy. Quote Link to comment Share on other sites More sharing options...
BoMan.de Posted November 16, 2005 Share Posted November 16, 2005 @vondada: Mibble already said it but I'll do once more: EP is only updating your product because it's always the same model # and it will be updated several times. Hello, I've got the following problem with EP: Export works, import, too. But when there is a ' in products_description it won't. | DVD-BLDRND | dvd/blade_ | Blade Runn | Regional C | www.blader | Blade Runn | Regional C | www.blader | Blade Runn | Regional C | www.blader | 38.51 | 7.00 | | 2005-11-15 | 17 | Warner | DVD Filme | Science Fi | | | | | | Taxable Go | Active Updated1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Cut', products_description='Regional Code: 2 (Japan, UPDATE products_description SET products_name='Blade Runner - Director's Cut', products_description='Regional Code: 2 (Japan, Europe, Middle East, South Africa). Languages: English, Deutsch. Subtitles: English, Deutsch, Spanish. Audio: Dolby Surround 5.1. Picture Format: 16:9 Wide-Screen. Length: (approx) 112 minutes. Other: Interactive Menus, Chapter Selection, Subtitles (more languages).', products_url='www.bladerunner.com' WHERE products_id = '5' AND language_id = '1' [TEP STOP] The error is the not escaped 's in "Director's Cut". I tried to solve the problem by using mysql_real_escape_string() - but maybe at wrong place. PHP Version 4.3.10-15 MySQL 4.0.24 osC 2.2 MS2 build 051112 EP 2.76b1 Can anybody help me? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 try Director\'s Quote Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 My Question???? Hi all. I wan't to have a default image for all my sub categories. Is there an extra field you can insert into the import that will make all the sub category images the same? Here is what I mean. Below you see Adapters has a image above it I want this image to appear at the top of ALL my sub headings only. I would really appreciate some help on this one. Thanks :) Quote Link to comment Share on other sites More sharing options...
vondada Posted November 16, 2005 Share Posted November 16, 2005 you need to give a bit more info rather than complaining. what do you mean about the last entry? how may records, etc are you talking about here? do you have eoreor after all the lines?looking, everything has the same model #, which is hhp. everything needs to have a separate model #. Sorry about voicing my frustration, but THANK YOU. The leading model number IS exactly what was messing things up. It works perfectly now. Thank you so much for taking the time to answer this. It's gonna save me a ton of time, even with wasting a day and a half on it. Thanks again. Quote Link to comment Share on other sites More sharing options...
redrum Posted November 17, 2005 Share Posted November 17, 2005 Can the import file be grabbed and imported from an extern URL? If anyone knows if it is possible, how can this be done? Also, how can it be imported automaticly by cron? Quote Link to comment Share on other sites More sharing options...
chantal7 Posted November 17, 2005 Share Posted November 17, 2005 Mibble, How does one empty the database? I need to do this and don't know how. I have my database backed up. :) Thanks in advance. Quote Link to comment Share on other sites More sharing options...
BoMan.de Posted November 17, 2005 Share Posted November 17, 2005 try Director\'s I know that it works that way but due to security reasons it SHOULD be checked in the EP script. It's also not very comfortable to do it in the import-file... Mibble, How does one empty the database? I need to do this and don't know how. I have my database backed up. :) Thanks in advance. what exactly do you want to empty? all userfiles, products (details), orders, etc.? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 17, 2005 Share Posted November 17, 2005 (edited) I have SPPC and Quantity Discount contribs I can update properly but not with v_customer_price_1 v_customer_group_id_1 if i do this error comes up 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 16.18, 48 ) [TEP STOP] sorry if this problem has been address already, i coundt find the fix for it Edited: This error only uccured after finish installing Quantity discount Contrib. Thank you Edited November 17, 2005 by technoboy Quote Link to comment Share on other sites More sharing options...
chantal7 Posted November 17, 2005 Share Posted November 17, 2005 I'm sorry, I didn't see this until now. I finally did a google search and found the right oscommerce forum for this problem and I figured out how to empty all the product information in the database. I just entered the below into my sql and ran it and it did it: CODE DELETE FROM `address_book`; DELETE FROM `banners`; DELETE FROM `banners_history`; DELETE FROM `categories`; DELETE FROM `categories_description`; DELETE FROM `counter`; DELETE FROM `customers`; DELETE FROM `customers_basket`; DELETE FROM `customers_info`; DELETE FROM `manufacturers`; DELETE FROM `manufacturers_info`; DELETE FROM `orders`; DELETE FROM `orders_products`; DELETE FROM `orders_status_history`; DELETE FROM `orders_total`; DELETE FROM `products`; DELETE FROM `products_attributes`; DELETE FROM `products_attributes_download`; DELETE FROM `products_description`; DELETE FROM `products_notifications`; DELETE FROM `products_options`; DELETE FROM `products_options_values`; DELETE FROM `products_options_values_to_products_options`; DELETE FROM `products_to_categories`; ALTER TABLE products AUTO_INCREMENT = 1; ALTER TABLE products_attributes AUTO_INCREMENT = 1; ALTER TABLE products_description AUTO_INCREMENT = 1; ALTER TABLE products_options_values_to_products_options AUTO_INCREMENT = 1; Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2005 Share Posted November 18, 2005 http://www.oscommerce.com/forums/index.php?showtopic=45037&hl= yes, this is correct, do not use the semicolon, causes tons of problems I have (sucessfully?) installed EP, downloaded the 'complete' file, and tried some editing... When saving as a tab-delimited file from Excel 2000, the fields have spaces between them, but no ; Is this correct? Thanks for looking. look at your products_groups table and count the # of fields, as you are inserting 3 values. if more than 3 or less then it ill not work I have SPPC and Quantity Discount contribs I can update properly but not with v_customer_price_1 v_customer_group_id_1 if i do this error comes up 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 16.18, 48 ) [TEP STOP] sorry if this problem has been address already, i coundt find the fix for it Edited: This error only uccured after finish installing Quantity discount Contrib. Thank you Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2005 Share Posted November 18, 2005 Thanks Mibble... i'll give it a try:) Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2005 Share Posted November 18, 2005 OK, I now have a txt file with 'even spaces', no commas, semi-colons or otherwise.. Next Problem When attempting to 'Upload EP File' in EP Admin, I get the following error: HTTP Error 406 - Not acceptable I'm keen to get this going, due to the fact of having 1300 products to upload! If I use the Backup in Admin, I am assuming it will work if I need to Restore? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2005 Share Posted November 18, 2005 why not try one product and see what happens with the upload, once you get that, you can start going up . . . Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2005 Share Posted November 18, 2005 When attempting to 'Upload EP File' in EP Admin, I get the following error: HTTP Error 406 - Not acceptable I'm still looking for the answer to the above. Anyone know what the solution is? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2005 Share Posted November 18, 2005 can you give us a bit more info? what is your temp file setting? what is your DOCUMENT_ROOT setting in the configure.php file? is the tempfile dir at 777 permissions? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.