"error parsing key for this row no values" error while Importing a list from a list in another model

garima.rawat
Contributor

"error parsing key for this row no values" error while Importing a list from a list in another model

Hi 

I do not have a module setup for an import of the list from another list from other model. and I get this error 

'error parsing key for this row no values'. How can I get rid of this error. Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: "error parsing key for this row no values" error while Importing a list from a list in

@garima.rawat 

 

Create a Boolean line item which will be TRUE for all the items (if you don't want to filter it based on any logic). Use that Boolean as a filter to create a saved View. Keep the Summary of Boolean Filter Line item to "None"

 

Misbah_0-1616763497351.png

Hope that answers your question and Don't forget to close the query 

Misbah

 

View solution in original post

7 REPLIES 7
ashish.banka
Super Contributor

Re: "error parsing key for this row no values" error while Importing a list from a list in

@garima.rawat Not very sure from the error... however whenever you try to import from one model to another, I would always check the "Source Model" settings to check whether the source model from which we are importing is correct.

 

AB

Misbah
Moderator

Re: "error parsing key for this row no values" error while Importing a list from a list in

@garima.rawat 

 

Good Question!

 

"First of all It is not considered to be the Best Practices to Import List into another List. Below error is a typical example of why it is not considered to be the Best Practice. You could easily avoid all these silly errors by importing from saved view to the list"

 

Here is what I think might be happening. If you are importing from one list to another list and Importing is happening on the basis of "Code Only" then you get these error messages when the code is missing in few of the source list items

 

Source List

Misbah_1-1616736625556.png

Import Mapping

Misbah_2-1616736713932.png

 

 

Error message

Misbah_0-1616736588503.png

Target List

Misbah_3-1616736771230.png

Hope this helps

Misbah

 

garima.rawat
Contributor

Re: "error parsing key for this row no values" error while Importing a list from a list in

@ashish.banka thanks! I will check that

@Misbah Thanks for your reply. 

So the best practice would be creating a module and importing from its saved view u mean ?

Misbah
Moderator

Re: "error parsing key for this row no values" error while Importing a list from a list in

@garima.rawat 

 

Yes, Always Import from Saved View.

garima.rawat
Contributor

Re: "error parsing key for this row no values" error while Importing a list from a list in

@Misbah If I have a hierarchical list but its a balanced hierarchy how should I create the flat module for import?

Misbah
Moderator

Re: "error parsing key for this row no values" error while Importing a list from a list in

@garima.rawat 

 

Create a Boolean line item which will be TRUE for all the items (if you don't want to filter it based on any logic). Use that Boolean as a filter to create a saved View. Keep the Summary of Boolean Filter Line item to "None"

 

Misbah_0-1616763497351.png

Hope that answers your question and Don't forget to close the query 

Misbah

 

View solution in original post

garima.rawat
Contributor

Re: "error parsing key for this row no values" error while Importing a list from a list in

@Misbah Thank you! this makes sense