CSV File misenterpreted

This topic contains 55 replies, has 3 voices, and was last updated by  Alex Rollin 6 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: 

  • Author
    Posts
  • February 5, 2019 at 6:16 pm #467244

    Andrea Davidson
    Expired Member
    Post count: 128

    Hi
    I have updated the categories using the template provided, the categories are all over.
    Parent types are missing, categories are listed in the parent option type.

    What can i do to correct this?

    there are 33 of your pages of this.

    Its as if the information has been jumbled up.
    Please advise.
    Andrea

    February 5, 2019 at 7:13 pm #467261

    Kor
    Moderator
    Post count: 16516

    Hi Andrea,

    Thanks for your reply. You’ll have to remove those that are not configured correctly manually. Then, use the “Update item if item with cat_id/cat_slug already exists.” option as shown in the screenshot to replace the existing categories when you reupload it.

    February 6, 2019 at 9:11 am #467378

    Andrea Davidson
    Expired Member
    Post count: 128

    hi

    thank you for above, quick pint, none of the parent categories have been created. To create the parent category i have included them i the upload csv. Is this correct?

    I will do as your response says until you respond to this query.

    Thanks
    Andrea

    February 6, 2019 at 9:52 am #467382

    Andrea Davidson
    Expired Member
    Post count: 128

    Hi
    I have chatted with WP support and they have advised that WP does not support CSV uploads. To assist they recommend the below.

    Woo commerce CSVs are compatible but GD isnt listed.
    Here are some details on what you can import directly through the WordPress.com import tools: https://en.support.wordpress.com/import/

    If you are looking to upload CSV files, I would suggust this plugin: https://wordpress.org/plugins/wp-ultimate-csv-importer/
    will this plugin benefit this process or not?
    Thanks
    Andrea

    February 6, 2019 at 5:19 pm #467439

    Alex Rollin
    Moderator
    Post count: 27815

    Yes, you can include new categories in the CSV.

    About uploading the CSV file, There is a bug in WordPress. Install this plugin so you can upload the CSV file.

    https://wordpress.org/plugins/disable-real-mime-check/

    February 6, 2019 at 6:14 pm #467461

    Andrea Davidson
    Expired Member
    Post count: 128

    Hi
    Thank you Alex. None of the parent categories have come through.
    If i delete all imported and start again. Then upload csv with parents and no categories to then upload categories matching the parents will that work. I
    have provided csv in previous communication if that helps. Let me know your thoughts.
    Thanks

    February 6, 2019 at 6:30 pm #467465

    Alex Rollin
    Moderator
    Post count: 27815

    I do not see the CSV file, can you reupload please?

    thanks

    February 6, 2019 at 7:27 pm #467477

    Andrea Davidson
    Expired Member
    Post count: 128

    Hi
    I checked previous posts on different ticket number and it said the csv file couldn’t be uploaded for security reasons.

    https://wpgeodirectory.com/support/topic/add-listing-template-2/#post-466072

    What can I do so it will be allowed for you to access?

    thanks
    Andrea

    February 6, 2019 at 7:28 pm #467478

    Alex Rollin
    Moderator
    Post count: 27815

    zip it first and then attach in a private reply

    Please also include your site URL and WP Admin credentials so we can look at the site settings

    February 6, 2019 at 7:39 pm #467479

    Andrea Davidson
    Expired Member
    Post count: 128
    This reply has been marked as private.
    February 6, 2019 at 7:50 pm #467482

    Alex Rollin
    Moderator
    Post count: 27815

    Have you already exported the current categories?
    Does your CSV match the same format?

    February 6, 2019 at 7:52 pm #467484

    Andrea Davidson
    Expired Member
    Post count: 128
    This reply has been marked as private.
    February 6, 2019 at 7:55 pm #467486

    Andrea Davidson
    Expired Member
    Post count: 128
    This reply has been marked as private.
    February 6, 2019 at 7:59 pm #467489

    Andrea Davidson
    Expired Member
    Post count: 128

    yes matches same format csv Comma delimited

    February 6, 2019 at 8:43 pm #467495

    Alex Rollin
    Moderator
    Post count: 27815

    OK, so you can see there are differences.
    I recommend you merge your data into the file you downloaded. Preserve the Cat ID for existing categories but make changes as you see fit. You don’t want there to be duplicates with the same name, so you would remove the new one.

    The column structure for import is very important. If you want to import they structure has to match exactly.

    Let us know how it goes

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 56 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount