Import Export problem

  • Resolved wpreader

    (@wpreader)


    14 years, 9 months ago

    I’m running wp 3.2.1 and im having major issues with importing data from a csv file.

    It just doesnt seem to work – the columns and rows dont match at all.

    I’ve tried to import data in different ways and it’s not getting it right.

    I’ve tried importing the following in csv format and i’ve had no luck:
    – importing from excel
    – importing from google docs
    – importing files with blank cells
    – importing files without blank cell
    – exporting a table from wp-table reloaded and then importing it again
    – importing just a single row

    Even when importing a single row, all the values just go into 1 cell as opposed to multiple ones. I’ve tried ‘,’ and ‘;’ seperated csv files.

    Has anyone else had this problem?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Samuel B

    (@samboll)

    14 years, 9 months ago

    http://wordpress.org/extend/plugins/csv-importer/
    http://wordpress.org/extend/plugins/csv-user-import/

    Thread Starter wpreader

    (@wpreader)

    14 years, 9 months ago

    Thanks Sam, but that doesnt help too much as this is related to the WP-Table Reloaded plugin.

    Has anyone come across the problem im having?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    14 years, 9 months ago

    Hi,

    can you maybe upload the CSV file and the original source file (Excel?) somewhere, so that I can take a look at it?

    Regards,
    Tobias

    Thread Starter wpreader

    (@wpreader)

    14 years, 9 months ago

    Hi Tobias,

    this is the simplest form of a csv file as i described above.

    http://wpreader.com/test.csv

    All the fields just end up going into a single cell.

    What are your thoughts? do you have a working csv file?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    14 years, 9 months ago

    Hi,

    I think I found a possible reason. As it seems, the internally used CSV import library expects that the CSV file as an empty line at the end.

    So, with the file that is currently not working, please try this:
    Open it in a text editor, like Notepad, and move the cursor behind the very last character in the last row. Then press “Enter” there, to add a new empty line to the file and save the file. Try the import again with that file.

    Regards,
    Tobias

    Thread Starter wpreader

    (@wpreader)

    14 years, 9 months ago

    Hi Tobias,

    This still isn’t working for me. Do you have a working file that you are able to import successfully?

    Anton

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    14 years, 9 months ago

    Hi,

    yes, here’s a file that is working:
    http://tobias.baethge.com/download/plugins/additional/csv-test.csv

    That is the table that you can see in the “Demo” section on the plugin’s website.

    Regards,
    Tobias

    Thread Starter wpreader

    (@wpreader)

    14 years, 8 months ago

    Hi tobias, so i think i found a glitch.

    It seems that in the csv file that i was using had empty cells and in some cases this was the first cell in the row and that’s what made it not render properly – empty cells.

    The way i fixed it was by adding 1 row and 1 column at the beginning of the table and i made sure that all the cells had values, in my case, i just put an ‘x’ in all the cells in the first row and column. I then tried to import it and it worked as expected.

    e.g. if my table was this before

    A,B,C,D
    1,2,3,4
    ,6,,8
    ,10,11,12

    i changed to this so that it would import properly:
    X,X,X,X,X
    X,A,B,C,D
    X,1,2,3,4
    X,,6,,8
    X,,10,11,12

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    14 years, 8 months ago

    Hi,

    ah, very nice! Good catch!
    This must be a problem in the CSV import library than… Great that you found a solution!

    Best wishes,
    Tobias

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

The topic ‘Import Export problem’ is closed to new replies.