[Resolved] Import posts and RFG images from non-wp database

[Author]

Posts

[jozsefG]

Hello

I need help in importing an old database to a Toolset site I'm creating. There is a very old 10+ years old news site with 7000+ articles that was created in codeigniter framework. I wouldn't have problem importing just the news posts but every post has a gallery too. Everything in separate table of course but I'll figure out how to join them in SQL. The galleries have only one or multiple images. I guess I can add the images for the galleries in Toolset as repeatable field group. I need help on how to prepare the CSV file for import. I've read the https://toolset.com/course-lesson/importing-repeatable-field-groups-when-using-the-csv-importer-plugin/ but I don't understand it fully.

I want to create for the posts a CSV with the following columns:
Title,Date of creation,Content,Excerpt,Thumbnail

For the images I need to add:
Image name, Gallery it belongs to, Image description

The images are all in one folder. I though that I set WP media to not save images in different folder so I'll have only one media folder. So I can just add the image name to it's path when I create the template.

But about the CSV, do I need two separate CSVs? One for the posts and one for the images in RFGs? And I don't understand how I would link the two...

[Luo Yang]

Hello,

The CSV Importer plugin does not support Toolset repeatable field groups, see our document:
https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/

You might consider to use "WordPress Ultimate CSV Importer" plugin, here is the document about "Importing repeatable field groups when using the CSV Importer plugin in WordPress"
https://toolset.com/course-lesson/importing-repeatable-field-groups-when-using-the-csv-importer-plugin/

For your reference.

[jozsefG]

Dear Luo

I'm planning to use Ultimate CSV Importer. But the only documentation I found about importing RFGs was the one I sent you. So my questions are the same. How should I prepare my CSV file for import. Do I need a single table for all the posts, I row/post, and in that one row I should put all the RFG values for one custom field in one cell? Like in case of images:
image1.jpg|image2.jpg|image3.jpg

[Luo Yang]

According to the document:
https://toolset.com/course-lesson/importing-repeatable-field-groups-when-using-the-csv-importer-plugin/
Screenshot:
https://toolset.com/wp-content/uploads/2018/11/example-of-csv-file-with-corresponding-field-group.png
It needs only one table.

One row one post
One column one field, if there are multiple instances in the repeatable field groups, you need to use separators "|" to combine them into field value, for example: hidden link|hidden link|hidden link

[jozsefG]

My issue is resolved now. Thank you!