Imported Data Cleaning

  • zerret

    (@zerret)


    5 years, 11 months ago

    Hi guys,
    When I import from CSV The data shows but it’s like it’s cleaning it. My column will say test and the imported data will say [“test”].
    Is this a CSV format error?
    Thanks,
    Meredith

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Javier Carazo

    (@carazo)

    5 years, 11 months ago

    Not sure what’s your problem.

    Could you try to explain better?

    Thread Starter zerret

    (@zerret)

    5 years, 11 months ago

    Sorry! So I want my imported field to show as just the word test but it is putting the brackets and double quotes in the field too even though they aren’t in the CSV sheet I am importing from.

    So I am trying to import just the word test but I’m actually importing [“test”]

    Does that make more sense?

    Plugin Author Javier Carazo

    (@carazo)

    5 years, 11 months ago

    It seems that your CSV is the problem.

    Have you edited it with a code editor?

    Thread Starter zerret

    (@zerret)

    5 years, 11 months ago

    It was just from excel, i’ve also tried opening it in Notepad++ to check its UTF-8 and even tried as ANSI just to see and it was the same.

    the fields are the ACF fields for the entries could that have an affect?

    Thread Starter zerret

    (@zerret)

    5 years, 11 months ago

    It’s even weirder than I first thought, when I import the csv and press ‘start importing’ the data displayed is correct on ‘Inserting and updating data’ but not when I click ‘view results’.
    One entry is updated and one is a new entry. Both have the [“”] issue

    Plugin Author Javier Carazo

    (@carazo)

    5 years, 11 months ago

    Are you importing ACF fields?

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

The topic ‘Imported Data Cleaning’ is closed to new replies.