I want to successfully import Category of collection type "Relation" from CSV

T_H · January 31, 2022, 5:44am

System Information

I am using “strapi-plugin-import-export-content”.

I want to set the category set in the collection type Relation to the category of the post collection.

I have succeeded in importing the values set for Post in CSV.

title,slug,description,thumbnail However, the import of category does not work.

On my screen, the first category name I set is set by itself.

The first image is the CSV information that I plan to import. The second image shows the information actually imported into Strapi.

Category is different.

jpizzle34 · January 31, 2022, 6:43am

Hi there!

What does your Category column look like in your csv? I believe the values in this column should be an integer mapping to the category id.

T_H · January 31, 2022, 6:46am

thanks!

I put the name of the category in the CSV that I import.

jpizzle34 · January 31, 2022, 6:48am

I think it should be the id of the category instead of the category name

T_H · January 31, 2022, 6:52am

Thanks!I have successfully set it up by entering my ID.
It would be useful to be able to set it up with a categoty name, is there a better way?

jpizzle34 · January 31, 2022, 7:00am

No worries!
Yes that would be useful! None out-of-the-box that I know of.

T_H · January 31, 2022, 7:32am

I am using a plugin called IMPORT / EXPORT CONTENT to import.

I put an ID item in the CSV.
I put the values from 0 to 48 in the header called “id”.
However, I could not import it.

Is it possible to set the ID by myself?

jpizzle34 · January 31, 2022, 7:35am

No, I don’t think so, as the id is auto-generated by the database / strapi database provider