[Resolved] I need to create cusomfields from Imported posts

[Author]

Posts

[kristenM]

Hi Support.

I finally have managed to import 400+ posts via JSON.

all the data is in the post text and that means that I have to get it from a text to custom fields.

The 400+ posts also gets renewed every 24 hours. That means that the proces will have to run again every day.

Is there anyway to do that?

Kind regards

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - I still do not understand whats your exact requirement but if you are planning to use some CRON based work to update your posts every 24 hours - there is no such native feature available.

However - if you give me your requirements in details I may guide you in right direction.

You may try to find suitable plugin or write custom code as per your need as custom programming is beyond the scope of our support policy. Please feel free to contact our certified partners for your any custom programming needs:
=> https://toolset.com/contractors/

[kristenM]

Hi Minesh.
I have actually found a way to make a daily import of 400+ posts via JSON Content Importer.

But... the different data goes into the content of the post. Here I can find several data as you can see here:

"MemberID": 7849,
"MemberNumber": 10486,
"Company": "FIRMANAVN",
"Name": "PERSON NAVN",
"Address": "ADRESSE",
"Zip": "POSTNR",
"City": "BY",
"Email": "EMAIL",
"Phone": "TELEFON",
"CVR": "CVR",
"Web": "WEB",
"ProfileText": "PROFILTEKST",
"NewCustomers": "Ja/Nej",
"Started": "21.06.2017",
"KompetenceList": {
"Exams": [],
"Experience": [],
"EconomySystems": [
"C5",
"Dinero",
"e-conomic",
"NAV",
"Microsoft Dynamics",
"Billy",
"C5online"
],
"ModulesFeatures": [
"Abonnement",
"Indscanning",
"Lagerstyring",
"PBS",
"Projektstyring",
"Webshop"
],
"POS": [
"Hairtools"
],
"Salary": [
"Dataløn",
"Danløn",
"C5 Løn"
],
"Tax": [],
"Language": [],
"Other": [],
"Services": [],
"Knowledge": []

How do I get these data in to customfields named the same and where post title will be "Company" (Companyname)?

I have made this diagram to show which data should go in to which custom field:

Kind regards

[Minesh]

Well - Toolset offers CSV import to import the data to custom fields.

Please check the following Doc - there are couple of option and you should use one of them.
=> https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/

Here is the example, how you can format your CSV file to import:
=> https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/import-content-csv-importer-plugin/#formatting-of-the-provided-example

[kristenM]

Hi again Minesh.
I know this thread has been closed so I hope you will have the time to look at it anyway.

I have been around different approaches to see if I can get the data in to WordPress and to use it with Toolset - but to no avail.

Therefor I'm back to your solution. If I succeed in first getting the JSON-file transformed in to CSV and next is getting the CSV downloadet in to WordPress to pages - I'm almost at the finishline.

The last thing I need to know os that Toolset can remove those pages that doesn't import in a new CSV. To explain it in other words:

First I import 25 pages via CSV. The next import contains only 24 pages - and therefor 1 page is obsolete.
Can Toolset remove this page - or deactivate it?

I hope you have time to answer me on this question and I thank you very much in advance.

Kind regards

Kristen