No Items imported!

[vyasjigsm]

When I was trying to import one complex model with some json fields, It is saying me like No Items Imported! and also not showing any errors why its not importing or anything.

[EdisonPeM]

hi @vyasjigsm, verify that the values you want to enter are in the correct format and do not have missing values that are marked as required.

Additionally, the server console should show if there is an error uploading the data to the database.

[vyasjigsm]

Okay thank for the clarification. One more thing which I see, I have city and state as relational fields into the collection.for this collection I am trying to import data but the relational fields are taking value random not the actual match values. Also I have one more relation one to many, for that field also data is not importing so how can I do that? Thanks in advance. Please let me know if need any further details. Thanks & Regards Jignesh vyas

…

On Wed, 4 Aug 2021, 09:39 Edison Peñuela, ***@***.***> wrote: hi @vyasjigsm <https://github.com/vyasjigsm>, verify that the values you want to enter are in the correct format and do not have missing values that are marked as required. Additionally, the server console should show if there is an error uploading the data to the database. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#30 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALXDL6V6O2BGQVW5LCLY2U3T3C4ONANCNFSM5BOZRZ5A> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email> .

[easydrops]

hi @vyasjigsm, verify that the values you want to enter are in the correct format and do not have missing values that are marked as required.

Additionally, the server console should show if there is an error uploading the data to the database.

I had a similar issue. In my case it was also due to the format: The value to import was set as a number (a numeric value without quotes in the csv) and the field in strapi was a string. I had to change the field in strapi to a number to make it work.
For this case, it would be great to have a more specific error message than 'No Items Imported' :)
Thanks for the work on this plugin!

[wellspun]

@EdisonPeM We are having this issue, as well. The field in Strapi is a String but sometimes the information in the field is purely numeric (think a room number in a building, sometimes it's W101 to indicate the west room 101 and sometimes it's just 101 as there's only one in the building.
Is there a way you can think of to support this use case for importing? I've looked through the code, coming to services/contentParser/csvParser.js and am trying to think of a method to ensure proper mutation into a string for the data received, but it seems like the data is already stripped of quotes by the time it gets here, so will always convert string numbers into a Number.
A better solution would be for the Strapi back-end to automatically coerce a Number into a String type when trying to import. Is there an option we can set for the strapi.entityService.create call at services/importer/importUtils.js:3?