Error parsing key for this row; no value

Gharbali

Hello,

I am importing data from a saved view from Data-Hub into A2 Account>Product# list but i am facing this error "Error parsing key for this row; no value". Here is the way I mapped the import:

What am I doing wrong?

P.S, the data has been loaded to A2 Account>Product# but I am afraid if it is incomplete.

Thanks,

AjayM

Hi Farhad,
Most likely, your list is completely loaded, but the saved view is missing a filter, because of which the preview showed records where code lineitem is blank, and it threw error for those blank records.

The import saved view must be filtered using 'valid?' lineitem. That way, the saved view would only have records with values in 'code' lineitem, and then the import action wouldn't throw this error.

You may want to try deleting all leaf level items in the list and rerun the action after modifying & saving the view.

Cheers!

rob_marshall

@Gharbali

there is nothing in the code line item in the module yet you have it mapped.

Gharbali

@rob_marshall

In the source (the photo below), I have 3 component that I mapped accordingly in the import process.

even though, in the error page, the "Code" is empty but in the result page it is loaded with Data. And it seems it is all correct. Shall I just ignore the part the error?

rob_marshall

no, don’t ignore it…are all account flat, product flat, and code saved in your view?

Gharbali

@rob_marshall

Yes, the saved view have account flat, product flat, and code :

saved view:

rob_marshall

@Gharbali

Also, as an FYI, you don't need the "= TRUE" bit on the Code or Valid? line items.

Valid?= Data? or Manual

Code = If Valid? then ….

Gharbali

@rob_marshall and @AjayM

Thank you all, it worked like a charm.