Thursday, January 17, 2019 11:32:10 PM

Success Updated 0 Rows

2 months ago
#8506 Quote
Not sure why I am not getting updated rows. I have a simple two-column spreadsheet with Category ID in column 0 and Picture URL in Column 1. I have it mapped like that too. I verified the URL is good by pasting in a browser and image displays. Checked the debugging output and I see it is reading the name of the categories which I do not provide in the spreadsheet. It reports a correct row count but 0 updated. Is there something I am missing? Worked fine for products when I did those a few weeks ago.

Job Output
Import file 'C:\Inetpub\vhosts\**redacted**\httpdocs\import\idsubcat.xlsx'
- The file has 60 rows.
- Success Updated 0 rows.

Samples from the debug log
ReadOneRowItemsFromList. step 3. importTemplate.Id=2, file=C:\Inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx, row.Count=2, rowNumber=62
2018.11.08 07:19:18:5237*******
ReadCategoryValue. importTemplate.Id=2, file=C:\Inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx, rowCount=62, value=http://**redacted**/products/6x26IWRC.gif, columnDestination=Picture
2018.11.08 07:19:18:5863*******


ImportManagerProcessing.XML. importTemplate.Id=2, file=C:\Inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx, byteArray.count()=11487
  - MemoryStream was created
  - step 1
  - rowNumber=1
  - rowNumber=2

ImportImportTemplate. Start update product using data from the file 'C:\inetpub\vhosts\**redacted**\httpdocs\import\catpics.xlsx'
2018.11.08 07:19:18:6487*******
ImportCategoryService. ImportEntity. Id=3, Name=Binder Chains
2018.11.08 07:19:18:6487*******


2 months ago
#8508 Quote
Send me your import file and make print screen
the second tab with mappings. Send me it too.
I want to see it.