Small import issue

  • Resolved ehofstede

    (@ehofstede)


    12 years, 9 months ago

    Hi,

    I wanted to import a CSV file, columns delimited with semicolons, but that didn’t work. I ended up with 1 column, a lot of text en semicolons…

    I opened the CSV file with notepad and replaced the semicolon with a comma and that was accepted by the plugin.

    So it looks like the semicolon isn’t recognized as a delimiter.

    It would be easier though if we can use the semicolon as a delimiter as well, (like the manual promises…) because it would save one step in the process… (replace semicolon with comma using notepad)

    Hopefully you can help me fix this…

    Again, it’s a small thing, because we have a workaround.

    Besides that, I’m using your plugin for about one hour now and I’m really enthusiastic about it! Finally the tables can also be seen on iPad’s/iPhone’s… 🙂 Please keep up this good work!

    Thanks!

    http://ww.wp.xz.cn/plugins/tablepress/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 9 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The semicolon is actually supported by the import… The script will do an automatic detection of the most likely used separator character. Weird that the semicolon did not work in your case.

    Could you maybe send me the CSV file that is not working, so that I can take a look at that directly (my email address is in the main plugin file “tablepress.php”).

    Regards,
    Tobias

    Thread Starter ehofstede

    (@ehofstede)

    12 years, 9 months ago

    Hi Tobias,

    I have send you an email.

    Regards,
    Erwin.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 9 months ago

    Hi Erwin,

    thanks for the file!

    From what I can see, the reason for the problem is the first line. That only has two semicolons, while all the others have ten. Due to that, the automatic detection fails. In that case, the importer falls back to the comma, which is why that works. So, the real fix here would be to make sure that all lines have the same amount of semicolons. This usually happens automatically, if you are not using combined/merged cells in the table in Excel. I assume that your first row however has combined cells, right?

    TablePress 1.1 might even bring another nice feature here for you, but more on that in my reply to your email.

    Regards,
    Tobias

    Thread Starter ehofstede

    (@ehofstede)

    12 years, 9 months ago

    Hi Tobias,

    Thanks for your explaination, I understand where it goes wrong. The file actually is more of a copy/paste result than a CSV saved from Excel… There are no combined cells, but it went wrong in the copy/paste handeling…

    I have seen the new feature and I’m looking forward to TablePress 1.1!
    And with me, all the other users should too! 😉

    Thank you for this great plugin!

    Regards,
    Erwin.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 9 months ago

    Hi,

    ok, that explains it 🙂
    Good to hear that you will like the new features!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

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

The topic ‘Small import issue’ is closed to new replies.