Import CSV to create Pod

  • Resolved mungbean

    (@mungbean)


    4 years, 1 month ago

    I am testing the import CSV function for my Pod post type. It is only a single row CSV, and it was created using Excel and saved as CSV, where each column is supposed to correspond to each field in the Pod.

    Upon import I am getting “This doesn’t look right, try manually selecting a different root element on the left. ” I don’t know how to resolve this or what exactly it means. See screenshot: https://ibb.co/TRZH0qn

    How should a CSV be structured for a Pod post type? Would an XML be better? If so how should it be formatted?

    Your documentation didn’t provide much in terms of formatting files to match post types: https://www.wpallimport.com/documentation/importing-an-xml-or-csv-file/

    Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author WP All Import

    (@wpallimport)

    4 years, 1 month ago

    Hi @mungbean,

    How should a CSV be structured for a Pod post type?

    There should be a header row (optional, but suggested), then each row after that should be posts. For example: https://d.pr/i/OSY3pZ.

    Upon import I am getting “This doesn’t look right, try manually selecting a different root element on the left. ” I don’t know how to resolve this or what exactly it means. See screenshot: https://ibb.co/TRZH0qn

    Please send a copy of your file and a description of this issue here: http://www.wpallimport.com/support/. We’ll have to see the data and run tests to understand why that’s happening.

    Would an XML be better? If so how should it be formatted?

    It wouldn’t necessarily be better unless you’re more comfortable with XML data. We have example files here: https://www.wpallimport.com/documentation/import/woocommerce/example-files/.

    Thread Starter mungbean

    (@mungbean)

    4 years, 1 month ago

    Thanks for the info. After I added a header column, it seems to have fixed the original issue! I think a header is actually required for Pods at least, not optional.

    For the CSV, should the header (column headers) match the field labels in the pod (I assume the machine name) or can they be anything?

    Does every field in the Pod need to have a corresponding column? Can cells be blank?

    How are Pod Relationship fields (both post relationships and radio-buttons) handled with imported CSVs? What data format in those columns is expected?

    Pod post types can also include “core” WP fields such as featured images, titles etc., how are those handled in the CSV?

    • This reply was modified 4 years, 1 month ago by mungbean.
    • This reply was modified 4 years, 1 month ago by mungbean.
    Thread Starter mungbean

    (@mungbean)

    4 years, 1 month ago

    I’ve been experimenting with CSV imports now that the import is reading my file. I have mapped the fields to the Pod custom fields including mapping categories and UID, but I am having an issue. All of the Pod form fields are blank after import, but the imported Pod title pattern is correct and the new terms are correctly being added to the categories.

    What would cause the mapped fields to all be blank after import? The field types of the custom Pod are WYSIWYG text areas, text fields, Pod relationship fields, radio buttons, and embed field.

    I am also noticing two fields referencing the same relationship field, one with “pods_” prepended to it, and the other being the field machine name. Which one should I use to map?

    • This reply was modified 4 years, 1 month ago by mungbean.
    Plugin Author WP All Import

    (@wpallimport)

    4 years, 1 month ago

    Hi @mungbean,

    For the CSV, should the header (column headers) match the field labels in the pod (I assume the machine name) or can they be anything?

    They can be anything.

    Does every field in the Pod need to have a corresponding column? Can cells be blank?

    They can be blank.

    How are Pod Relationship fields (both post relationships and radio-buttons) handled with imported CSVs? What data format in those columns is expected?

    You would have to use the CIO Custom Fields Add-On to import Pods relationship fields: https://docs.pods.io/plugins/cio-custom-fields/. I believe it requires the IDs of the related posts to be in the import file, but you can ask them if they support anything else.

    Pod post types can also include “core” WP fields such as featured images, titles etc., how are those handled in the CSV?

    You can see how regular fields are imported by reviewing our documentation at http://www.wpallimport.com/documentation/.

    What would cause the mapped fields to all be blank after import? I am also noticing two fields referencing the same relationship field, one with “pods_” prepended to it, and the other being the field machine name. Which one should I use to map?

    You should use the CIO Custom Fields Add-On to import this data since we don’t have direct support for importing into Pods without it (you’d have to write custom code to make it work). If you’re already using that, or if you run into issues when you try it, you’ll need to contact the developer of the add-on for assistance.

    Thread Starter mungbean

    (@mungbean)

    4 years ago

    Thanks, I’ll take a look at the suggested plugin. It does appear no longer maintained though.

    Regarding this plugin, are there plans to better support Pod creation via import/exports? I see you have several other plugins for specific plugin-import functions.

    Plugin Author WP All Import

    (@wpallimport)

    4 years ago

    Hi @mungbean,

    Regarding this plugin, are there plans to better support Pod creation via import/exports? I see you have several other plugins for specific plugin-import functions.

    There are currently no plans for it, but that could change in the future.

    Thread Starter mungbean

    (@mungbean)

    3 years, 11 months ago

    Thanks and understandable. I’ve found an alternative maintained plugin that seems to readily support Pods (https://ww.wp.xz.cn/plugins/wp-import-export-lite/)

    patsky

    (@patsky)

    3 years, 10 months ago

    I have had exactly the same experience as @mungbean. Disappointing that you haven’t been able to fully support Pods custom fields without another plugin and as he says, the one you are recommending has not had any updates for 4 years.

    In the meantime if anyone else is reading this post, the PRO version of this plugin will do the job and offers a demo to fully set up and test before you buy.

    WordPress Ultimate CSV – https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Import CSV to create Pod’ is closed to new replies.