Skip Navigation

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

This thread is resolved. Here is a description of the problem and solution.

Problem:

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

Solution:

You can use "WordPress Ultimate CSV Importer" plugin, here is the document about "Importing repeatable field groups when using the CSV Importer plugin in WordPress"

Relevant Documentation:

https://toolset.com/course-lesson/importing-repeatable-field-groups-when-using-the-csv-importer-plugin/

This support ticket is created 3 years, 6 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 4 replies, has 2 voices.

Last updated by jozsefG 3 years, 6 months ago.

Assisted by: Luo Yang.

Author
Posts
#2044381

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...

#2045519

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.

#2046107

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

#2047069

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

#2047145

My issue is resolved now. Thank you!