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...
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.
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
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
My issue is resolved now. Thank you!