Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

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? :'(

Share this post


Link to post
Share on other sites

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? :'(

John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

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'

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

@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 Updated

1064 - 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?

Share this post


Link to post
Share on other sites

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.

subcatimg.gif

 

I would really appreciate some help on this one.

Thanks :)

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.?

Share this post


Link to post
Share on other sites

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 by technoboy

Share this post


Link to post
Share on other sites

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;

Share this post


Link to post
Share on other sites

http://forums.oscommerce.com/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


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×