Import / Export

This topic contains 24 replies, has 3 voices, and was last updated by  Paolo 8 years ago.

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

Open Support Ticket
  • Author
    Posts
  • February 22, 2017 at 1:46 pm #363143

    Joanne Lord
    Expired Member
    Post count: 85

    in the csv file category will only accept a capital E and in default category it will only accept a lower case e, so editing the CPT name isn’t an option. Or is it?

    February 22, 2017 at 2:17 pm #363149

    Guust
    Moderator
    Post count: 29970

    I am confused now. Why would you edit the CPT name? We are only talking categories, right?
    If you are worried about the upper and lower case, you can just use the slug of the category instead. So make sure the categories are created first, and copy and paste the slug into the CSV file.

    February 22, 2017 at 4:15 pm #363163

    Joanne Lord
    Expired Member
    Post count: 85

    Can’t use the slug either as it’s all lower case and the cover file converts all entries to upper case first letter

    I tried uploading it as is, with the lower case e but got a http error

    February 22, 2017 at 4:32 pm #363165

    Paolo
    Site Admin
    Post count: 31211

    Are you using open office or libreoffice as recommended?

    I’ve never seen any of them changing text format automatically, nor any members having similar problems.

    You must be doing something wrong.

    Let us know,

    Thanks

    February 22, 2017 at 4:33 pm #363166

    Joanne Lord
    Expired Member
    Post count: 85
    This reply has been marked as private.
    February 22, 2017 at 4:45 pm #363169

    Paolo
    Site Admin
    Post count: 31211

    I just changed :

    line 57 both with lowercase e: Places To eat
    line 58 and 59 both with uppercase E: Places To Eat

    Just place the cursor over the cell with the content that you want and press ctrl+c, then move into the cell that you want to edit and press ctrl+v and enter.

    You can also do a search and replace, which would be faster.

    Thanks

    February 22, 2017 at 5:44 pm #363182

    Joanne Lord
    Expired Member
    Post count: 85
    This reply has been marked as private.
    February 22, 2017 at 6:26 pm #363186

    Joanne Lord
    Expired Member
    Post count: 85

    im using wordpress 4.7.2
    does this bug apply?
    https://wpgeodirectory.com/support/topic/the-uploaded-file-is-not-a-valid-csv-file-please-try-again/

    February 22, 2017 at 7:21 pm #363193

    Joanne Lord
    Expired Member
    Post count: 85

    fyi it was the wordpress bug and installing the plugin fix (in the link above) sorted it and I was able to import data

    Thanks for all your help : )

    February 22, 2017 at 8:06 pm #363210

    Paolo
    Site Admin
    Post count: 31211

    You are welcome 🙂

  • Author
    Posts
Viewing 10 posts - 16 through 25 (of 25 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