Skip Navigation

[Resolved] import a lot of map address data and taxonomy terms using CSV

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

Problem:
import a lot of map address data and taxonomy terms using CSV

Solution:
The solution is to use the CSV importer plugin:
=> https://toolset.com/course-lesson/import-content-csv-importer-plugin/

You can find proposed solution in this case with the following reply:
https://toolset.com/forums/topic/import-a-lot-of-map-address-data/#post-2325179

Relevant Documentation:
=> https://toolset.com/course-lesson/import-content-csv-importer-plugin/

This support ticket is created 2 years, 9 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
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10: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/Kolkata (GMT+05:30)

This topic contains 8 replies, has 2 voices.

Last updated by chelhwanS 2 years, 9 months ago.

Assisted by: Minesh.

Author
Posts
#2321771

Tell us what you are trying to do?

have 23000 pharmacy address data.
I want to use it for the map, but I can't get it in Mapfield.

I used two plugins, wp all import pro and wp import export lite, but none of them could get an address in the map field.

Currently, the pharmacy address data is registered in the single line file.
The address field goes into the single line field and map field together.

Is there any documentation that you are following?
Is there a similar example that we can see?

What is the link to your site?

#2322795

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

As I understand, you have a csv file with you which holds the data for address field.

What you want is, you have a field 1 and field 2 and you want to copy the address field to both the fields - is that right? If yes, have you set the same field that you try to import from file to both of the fields?

If you can share sample file which holds the address field data and send me link to download it, I'm happy to review it either on a test site you share or I'll try to arrange a test site. Please mention that what field you want to copy to what field(s).

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

#2325021

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

These days, a similar phenomenon occurs again. Is this the main problem with the memory?
==>
If your content keeps increasing and you have more content than the your server of hosting company can handle then yes you will require to increase the memory but we can not pin point anything without actually checking it but as you said you get same issue as before then there could be a possibility of that. We can not control server resources as simply we do not have any control over it.

The duplicator file you shared is big, I'm downloading it and I'll get in touch with you as soon as possible.

#2325179

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

The conclusion is, importing 23k records using CSV is a resource intensive task and it really needs memory and great amount processing power. So, you will really require a good choice. Even without Toolset, if you try to import 23k records with only WordPress it will die.

WP ALL import offers a Toolset Types addon to import the Toolset content, it's a pro plugin and you will have to get in touch with them with your requirement and you should mention them that you will have to import 23k records and they may guide you with possible resolutions:
=> hidden link

I've alternate workaround if you like to use but again I do not guarantee it will work for 23k posts as acknowledge, importing that much content is really a big job even without Toolset.

The alternate solution is to use the CSV importer plugin:
=> https://toolset.com/course-lesson/import-content-csv-importer-plugin/

For that:
- you will have to install and activate the the CSV importer plugin: https://wordpress.org/plugins/csv-importer/
- Here is a sample file I've created with exact column titles which you will require to import the post:
=> hidden link
- You can download the above file and then try to import those two records from:
=> Toolset => CSV importer => Upload your file and import it
- Then check and verify that those two records are imported correctly with custom field and taxonomy.

Note:
- "csv_post_post" and "csv_post_excerpt" columns are for post body and excerpt and its required. please do not delete it.
- "csv_ctax_belong-group" column is for your taxonomy, please note that you will have to prefix 0 for order that is required so the format is 0,term-name, in your case for instance 0,부산사하구

#2326639

There is a problem that needs to be solved urgently, so I will upload it again here.

I have to solve it quickly.

Like the last time on the neture.co.kr site, I saw it on the editor, but I couldn't see the user screen.

There is also a problem with this site not having a lot of content.
I can't open the tickets at the same time, so I don't know what to do, so I'll post something else here.

#2326649

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

What you mean by:
Like the last time on the neture.co.kr site, I saw it on the editor, but I couldn't see the user screen.

Can you please share detailed explanation for your problem?

#2328433

There are two problems, but I'm worried about creating confusion.

1. The address of the pharmacy on the map is hidden link.
The post type of "pharmacies" in "yaksa.site" should contain data.

2. The second problem occurs in "wordpress archives", which is visible on the editor but not visible on the user screen.
This phenomenon occurs in both "hidden link" and "hidden link".

It's the same if I upgrade my hosting and increase the memory to 1G.

****
The second problem is a detailed description of the part where the data is not visible on the user screen.
When I edit and save in wordpress archives, the changes are not saved.

This phenomenon occurs when working with "Wordpress Archive in toolset".
It appears in Woocommerce's product Post Type, but I haven't found it in another Post Type yet.

If you want to test it out

Go to hidden link.
"toolset->Wordpress Archive->Archive for sales category" is available.

I thought it would be better to change Title from Korean to English.

In the editor, I changed the tile to "Archive for sales market" and saved it, but the title is still "Archive for 판매대상 분류"
The editor is not working properly.

The user screen address is
It's hidden link.

******
Youtube Video URL

yaksa.site
hidden link

neture.co.kr
hidden link

The two site IDs and passwords are the same.

ID : sohae21

#2328629

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

1. The address of the pharmacy on the map is hidden link.
The post type of "pharmacies" in "yaksa.site" should contain data.
==>
What you mean by "pharmacies" should contain data? Do you mean that you did not able to import the file? I did not import any content to your site yet.

You have to follow my previous reply and create the CSV file as per my sample CSV file. I shared the sample CSV with my previous reply:
=> https://toolset.com/forums/topic/import-a-lot-of-map-address-data/#post-2325179

Regarding #2:
2. The second problem occurs in "wordpress archives", which is visible on the editor but not visible on the user screen.
==>

The additional problems you shared are totally different then the original question about how you can import your content using CSV.

As per our support policy we entertain only one question per ticket. May I kindly ask you to open a new ticket with every new question you may have. This will help other users searching on the forum as well as help us to write correct problem resolution summery for the original issue reported.

#2329185

My issue is resolved now. Thank you!