[Resolved] csv importer – recommended by toolset – not working

[Author]

Posts

[davidm-13]

Hi, I'm trying to upload a csv file to a types custom post, here's an example of heading and 1 record - which doesn't work:

csv_post_title,csv_post_post,csv_post_excerpt,csv_post_type,wpcf-species_id,wpcf-botanical_name,wpcf-species_family,wpcf-synonyms,wpcf-english_names,wpcf-hebrew_names,wpcf-hebrew-phonetic,wpcf-arabic_name,wpcf-arabic_phonetic,wpcf-life_form,wpcf-habitat,wpcf-local_distribution,wpcf-status,wpcf-scientific_studies,wpcf-cautions,wpcf-notes
"Aaronsonia faktosovskyi",,,"plant","23","Aaronsonia faktosovskyi","Asteraceae",,,"אהרונסונית פקטורובסקי",,,,,,,,,,

When I try to import I get
Skipped 19 posts (most likely due to empty title, body and excerpt).

Imported 0 posts and 0 comments in 0.02 seconds.

Really appreciate any help to get this working

Thanks
David

[Minesh]

Hello. Thank you for contacting the Toolset support.

First of all - I would like to know your current setup which Toolset plugin version you are using.

Could you please send me debug information that will help us to investigate your issue.
=> https://toolset.com/faq/provide-debug-information-faster-support/

Also, have you seen the following Doc:?
=> https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/

You can have example CSV file here:
=> https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/import-content-csv-importer-plugin/#case-example

[davidm-13]

Hi, received a request from Mohammed (only see it in my email, but not here) to disable all none toolset plugins which I did - apart from the "CSV Importer" plugin.
Also replaced my GeneratePress theme with the Twenty Fifteen theme. The csv importer still does not work.
I've uploaded the problem file to dropbox the link is
hidden link

I'm using Toolset Types version 2.2.22

Thanks for any help

[davidm-13]

I've also tried to import the minimum possible:
<CODE>
"csv_post_title","csv_post_post","csv_post_excerpt","csv_post_type"
</CODE>
with the same result - 0 records imported

[davidm-13]

Like to know if CSV Importer is still recommended by Toolset or if people are saying for whatever reason it no longer works?

If so, does that mean I now have to pay $99 for Ultimate CSV Importer to import csv files using toolset.

Are there any free solutions that you can recommend?

[Minesh]

I requested the debug info before but I think somehow you forget to share it with me. It will help me to can check which Toolset plugin version you are using.

Could you please send me debug information that will help us to investigate your issue.
=> https://toolset.com/faq/provide-debug-information-faster-support/

[davidm-13]

Hi Minesh, Here's the debug info you requested.

{"core":{"Wordpress":{"Multisite":"No","SiteURL":"http:\/\/localhost:8080\/florap","HomeURL":"http:\/\/localhost:8080\/florap","Version":"4.9.3","PermalinkStructure":"\/%year%\/%monthnum%\/%day%\/%postname%\/","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, wp-types-group, wp-types-user-group, wp-types-term-group, elementor_library, cred-form, cred-user-form, view, view-template, elementor-hf, plant, complaint","PostSatus":"publish, future, draft, pending, private, trash, auto-draft, inherit"},"Server":{"jQueryVersion":"1.12.4","PHPVersion":"5.6.30","MySQLVersion":"5.5.5","ServerSoftware":"Apache\/2.4.25 (Win32) OpenSSL\/1.0.2j PHP\/5.6.30"},"PHP":{"MemoryLimit":"256M","UploadMax":"250M","PostMax":"32M","TimeLimit":"0","MaxInputVars":"1000"}},"plugins":{"active_plugins":{"all-in-one-wp-migration\/all-in-one-wp-migration.php":{"Name":"All-in-One WP Migration","PluginURI":"https:\/\/servmask.com\/","Version":"6.62","Author":"ServMask","AuthorURI":"https:\/\/servmask.com\/","TextDomain":"all-in-one-wp-migration","DomainPath":"\/languages","Network":true,"Title":"All-in-One WP Migration","AuthorName":"ServMask"},"chosen\/chosen.php":{"Name":"Chosen for WordPress","PluginURI":"http:\/\/wordpress.org\/extend\/plugins\/chosen\/","Version":"0.3","Author":"Brent Shepherd","AuthorURI":"http:\/\/find.brentshepherd.com","TextDomain":"chosen","DomainPath":"","Network":false,"Title":"Chosen for WordPress","AuthorName":"Brent Shepherd"},"cred-frontend-editor\/plugin.php":{"Name":"Toolset CRED","PluginURI":"https:\/\/toolset.com\/home\/toolset-components\/#cred","Version":"1.9.5","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com\/","TextDomain":"cred-frontend-editor","DomainPath":"","Network":false,"Title":"Toolset CRED","AuthorName":"OnTheGoSystems"},"csv-importer\/csv_importer.php":{"Name":"CSV Importer","PluginURI":"","Version":"0.3.8","Author":"Denis Kobozev","AuthorURI":"","TextDomain":"csv-importer","DomainPath":"","Network":false,"Title":"CSV Importer","AuthorName":"Denis Kobozev"},"elementor\/elementor.php":{"Name":"Elementor","PluginURI":"https:\/\/elementor.com\/?utm_source=wp-plugins\u0026utm_campaign=plugin-uri\u0026utm_medium=wp-dash","Version":"1.9.4","Author":"Elementor.com","AuthorURI":"https:\/\/elementor.com\/?utm_source=wp-plugins\u0026utm_campaign=author-uri\u0026utm_medium=wp-dash","TextDomain":"elementor","DomainPath":"","Network":false,"Title":"Elementor","AuthorName":"Elementor.com"},"header-footer-elementor\/header-footer-elementor.php":{"Name":"Header Footer Elementor","PluginURI":"https:\/\/github.com\/Nikschavan\/header-footer-elementor","Version":"1.0.9","Author":"Brainstorm Force, Nikhil Chavan","AuthorURI":"https:\/\/www.brainstormforce.com\/","TextDomain":"header-footer-elementor","DomainPath":"\/languages","Network":false,"Title":"Header Footer Elementor","AuthorName":"Brainstorm Force, Nikhil Chavan"},"multi-column-tag-map\/mctagmap.php":{"Name":"Multi-column Tag Map","PluginURI":"https:\/\/wordpress.org\/plugins\/multi-column-tag-map\/","Version":"13.0.5","Author":"Alan Jackson","AuthorURI":"http:\/\/tugbucket.net","TextDomain":"multi-column-tag-map","DomainPath":"","Network":false,"Title":"Multi-column Tag Map","AuthorName":"Alan Jackson"},"sticky-menu-or-anything-on-scroll\/sticky-menu-or-anything.php":{"Name":"Sticky Menu (or Anything!) on Scroll","PluginURI":"http:\/\/www.senff.com\/plugins\/sticky-anything-wp","Version":"2.1.1","Author":"Mark Senff","AuthorURI":"http:\/\/www.senff.com","TextDomain":"sticky-menu-or-anything-on-scroll","DomainPath":"","Network":false,"Title":"Sticky Menu (or Anything!) on Scroll","AuthorName":"Mark Senff"},"types-access\/types-access.php":{"Name":"Toolset Access","PluginURI":"https:\/\/toolset.com\/home\/types-access\/?utm_source=accessplugin\u0026utm_campaign=access\u0026utm_medium=release-notes-plugins-list\u0026utm_term=Visit plugin site","Version":"2.4.3.5","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com\/","TextDomain":"types-access","DomainPath":"","Network":false,"Title":"Toolset Access","AuthorName":"OnTheGoSystems"},"types\/wpcf.php":{"Name":"Toolset Types","PluginURI":"http:\/\/wordpress.org\/extend\/plugins\/types\/","Version":"2.2.22","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com","TextDomain":"types","DomainPath":"","Network":false,"Title":"Toolset Types","AuthorName":"OnTheGoSystems"},"wp-all-import\/plugin.php":{"Name":"WP All Import","PluginURI":"http:\/\/www.wpallimport.com\/upgrade-to-pro?utm_source=wordpress.org\u0026utm_medium=plugins-page\u0026utm_campaign=free+plugin","Version":"3.4.7","Author":"Soflyy","AuthorURI":"","TextDomain":"wp-all-import","DomainPath":"","Network":false,"Title":"WP All Import","AuthorName":"Soflyy"},"wp-views\/wp-views.php":{"Name":"Toolset Views","PluginURI":"https:\/\/toolset.com\/?utm_source=viewsplugin\u0026utm_campaign=views\u0026utm_medium=plugins-list-full-version\u0026utm_term=Visit plugin site","Version":"2.5.2","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com","TextDomain":"wp-views","DomainPath":"","Network":false,"Title":"Toolset Views","AuthorName":"OnTheGoSystems"}},"mu_plugins":[],"dropins":[]},"theme":{"Name":"GeneratePress Child","ThemeURI":null,"Author":"\u003Ca href=\u0022https:\/\/tomusborne.com\u0022\u003ETom Usborne\u003C\/a\u003E","AuthorURI":null,"Template":"generatepress","Version":"0.1","TextDomain":null,"DomainPath":null},"extra-debug":{"access":{"rules":{"types":[],"taxonomies":[]},"debug":[],"settings":{"types":[],"tax":[],"third_party":[]},"errors":[]},"types":{"add_resized_images_to_library":0,"register_translations_on_import":1,"images_remote":0,"images_remote_cache_time":"36","help_box":"by_types","hide_standard_custom_fields_metabox":"show","postmeta_unfiltered_html":"on","usermeta_unfiltered_html":"on"},"CRED":{"wizard":1,"cache_notice":1,"export_settings":1,"export_custom_fields":1,"autogeneration_email":{"subject":"Welcome new user","body":"[username]Your username is: %cuf_username%[\/username]\\n[nickname]Your nickname is: %cuf_nickname%[\/nickname]\\n[password]Your password is: %cuf_password%[\/password]"},"dont_load_cred_css":1,"enable_post_expiration":0},"views":{"views_template_loop_blog":0,"wpv_bootstrap_version":1,"wpv_custom_conditional_functions":[],"wpv_custom_inner_shortcodes":[],"wpv_debug_mode":"","wpv_debug_mode_type":"compact","wpv_map_plugin":0,"wpv_show_edit_view_link":1,"wpv_show_hidden_fields":"","wpv_saved_auto_detected_framework":"","wpv_codemirror_autoresize":"","wpv_enable_pagination_manage_history":true,"wpv_enable_parametric_search_manage_history":true}}}

Please could you tell me if this plugin is still working, or other users are experiencing the same problems?

Thanks
David

[Luo Yang]

Hello,

Minesh isn't available currently, you will get the answers soon when he is back, and I just checked it with our developers, we will make it work out-of-the-box with existing CSV importer plugins, including the free version:
https://wordpress.org/plugins/wp-ultimate-csv-importer/

[davidm-13]

Thanks Luo,
That's great news, you say "we will make it work out-of-the-box" does that mean in the future or will wp-ultimate-csv-importer free version work now?

Thanks for your help
David

[davidm-13]

To import from CSV file to Types Custom fields "Ultimate csv Importer" plugin requires the Pro (paid) version. How do I import to Types Custom Fields with the free version?

Thanks
David

[Minesh]

Well - we already mentioned this with our Docs:
=> https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/

To import Types fields - you need pro version and that is why pro version needed.

[davidm-13]

Hi Minesh,
I understand that, but in the past I've successfully used the free CSV Importer. I'm not sure why it's not working now, so I don't want to pay $100 without knowing the reason CSV Importer is not working, which is why I ask if there's now a known problem with CSV Importer or if the problem is something I'm doing wrong.
You recommend both plugins, so I assume it's something I'm doing wrong, therefore there's no point in me paying $100 for the Pro version of Ultimate CSV Importer.

Thanks
David

[davidm-13]

Hi Minesh, After much googling, I'm making progress with the CSV importer plugin - I found this article:
hidden link

I'm including it here in the hope it'll help others:

Many people (including me) are searching for, and asking how you can use custom fields in the WordPress CSV importer. The plugin page says:

Any column that doesn’t start with csv_ is considered to be a custom field name. The data in that column will be imported as the custom fields value.

So I made an excel spreadsheet with 2 columns:

csv_post_title
(example) my_custom_field
And by importing this CSV file WordPress gave me the following error:

Skipped 3 posts (most likely due to empty title, body and excerpt). Imported 0 posts and 0 comments in 0.23 seconds

But after trying different combinations of column names as: csv_post_post and csv_post_type nothing worked and every time WordPress gave me the error. So maybe it was my CSV file that isn’t saved the right way. Then I went to Google Drive where you can make spreadsheets. I made a Spreadsheet in Google (the same as my old one, with the 2 columns), Saved it as CSV file, imported it with WordPress CSV importer and it Worked!

So my solution for importing Custom fields in WordPress CSV importer is to use CSV files from Google Spreadsheet.

My problem now (see screenshots) is I have several custom fields, which have a field type: select these fields appear in the plant-list.jpg screenshot, but when I open the post, I only see "not set". Can you tell me the format of the select field in a csv file - do the items in the select list need to be comma separated?, does each item need to appear on a separate line in the cell?

Thanks for any help
David

[Minesh]

Do you mean that you want to import dropdown selectbox options? If yes:

As Types custom select fields options setting is stored in your database table wp_options, option_name is wpcf-fields. You need to add those dropdown options.

To import the select field options - following link may help you:
=> https://toolset.com/forums/topic/how-to-import-states-and-countries-into-selects-for-fields/#post-204414

[davidm-13]

Hi Minesh,
I have a Post Field called English Names, I've attached a screenshot.

The slug name is english_names
Field Type: Select

Column header name in csv file: wpcf-english_names
Cell content: Eng. Name1, Eng. Name2

When I upload the csv file (using CSV Importer plugin) , in the list of plant posts under the

English Names

column I see: Eng.Name1, Eng.Name2
but when I click edit post I see English Names --- not set --- (see above screenshot)

What I expected to see instead of --- not set --- was the list:
Eng.Name1
Eng.Name2

What am I doing wrong? Why do I see "--- not set ---" instead of the list of english names?

Thanks for your help
David