Automation: Skip some rows in the imported file ( vendor data file)
E
Erno Vegh
started a topic
8 months ago
Hi,
we have some inventory data, XLS files, to import via the automation.
We set up the automation, and it runs with an error. We use the UPC field from the file to match agains the upc SureDone field.
The issue is with the file. In one of the rows, in the file, the UPC data is missing , with other words the cell in empty.
If I delete this row of the file, or type a dummy value into the cell where the UPC should be, then the import runs fine.
How do we go around this issue?
See full code below:
"file_configs":
[{
"regex":"/my file* 06-05-2020*-test.xls/",
"identifier":"upc",
"search":"guid:FCLH",
"diff_update": 1,
"diff_fields":["stock"],
"field_map":{
"stock":" Qty_Available"
},
"field_run":{
"BarCode":"BarCode"
},
"field_format":{
"upc":{
"combine":{
"fields":[
"BarCode",
""
],
"delimiter":""
}
}
},
"stock_field":"stock",
"stock_negative":true,
"update":"edit"
}]
Best Answer
S
SureDone Product Team
said
8 months ago
Hey Erno, we've addressed this issue on our end and have just released a patch to only log the failure on a per-item basis, instead of failing the entire automation. Hopefully this should fix your issue!
Hey Erno, we've addressed this issue on our end and have just released a patch to only log the failure on a per-item basis, instead of failing the entire automation. Hopefully this should fix your issue!
E
Erno Vegh
said
8 months ago
Update: I have tested it with automation again: #846
The automation still fails. This automation I will change it to use the guid, but use can still see the same issue with automation #1003.
S
SureDone Product Team
said
8 months ago
Hey Erno, could you try testing automation 1003 again? I just tried a debug run now and can see it succeeds. You may be able to see a log item like this: "Failed to make 'upc' from item", but this will only generate per-failed-item. The automation will still succeed overall and there should be a debug file successfully produced with the remaining 3 items and their corresponding stock updates.
Let me know if you're able to see this!
E
Erno Vegh
said
8 months ago
Yes, that seems to be working now, thanks!
E
Erno Vegh
said
8 months ago
it seems to be working now, but the "Failed to make 'upc' from item", error message threw me off; would be nice to actually see a report ( similar to the debug run file report)
S
SureDone Product Team
said
8 months ago
Hey Erno, glad it's working now! Thanks for the suggestion as well, and yes we're looking to continually improve logging and reporting!
Erno Vegh
Hi,
we have some inventory data, XLS files, to import via the automation.
We set up the automation, and it runs with an error. We use the UPC field from the file to match agains the upc SureDone field.
The issue is with the file. In one of the rows, in the file, the UPC data is missing , with other words the cell in empty.
If I delete this row of the file, or type a dummy value into the cell where the UPC should be, then the import runs fine.
How do we go around this issue?
See full code below:
"file_configs":
[{
"regex":"/my file* 06-05-2020*-test.xls/",
"identifier":"upc",
"search":"guid:FCLH",
"diff_update": 1,
"diff_fields":["stock"],
"field_map":{
"stock":" Qty_Available"
},
"field_run":{
"BarCode":"BarCode"
},
"field_format":{
"upc":{
"combine":{
"fields":[
"BarCode",
""
],
"delimiter":""
}
}
},
"stock_field":"stock",
"stock_negative":true,
"update":"edit"
}]
Hey Erno, we've addressed this issue on our end and have just released a patch to only log the failure on a per-item basis, instead of failing the entire automation. Hopefully this should fix your issue!
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstSureDone Product Team
Hey Erno, we've addressed this issue on our end and have just released a patch to only log the failure on a per-item basis, instead of failing the entire automation. Hopefully this should fix your issue!
Erno Vegh
Update: I have tested it with automation again: #846
The automation still fails. This automation I will change it to use the guid, but use can still see the same issue with automation #1003.
SureDone Product Team
Hey Erno, could you try testing automation 1003 again? I just tried a debug run now and can see it succeeds. You may be able to see a log item like this: "Failed to make 'upc' from item", but this will only generate per-failed-item. The automation will still succeed overall and there should be a debug file successfully produced with the remaining 3 items and their corresponding stock updates.
Let me know if you're able to see this!
Erno Vegh
Yes, that seems to be working now, thanks!
Erno Vegh
it seems to be working now, but the "Failed to make 'upc' from item", error message threw me off; would be nice to actually see a report ( similar to the debug run file report)
SureDone Product Team
Hey Erno, glad it's working now! Thanks for the suggestion as well, and yes we're looking to continually improve logging and reporting!
-
Print Inventory Bar Code Label
-
Amazon: Fitment Type
-
READ FIRST: Posting Guidelines and Rules
-
eBay PayPal related error
-
import my items from ebay
-
Walmart?
-
Motorstate data?
-
SureDone bulk headers
-
Data Scrubbed from Order Export
-
GUID 51 Error when doing Bulk Upload
See all 28 topics