WordPress.org

Support

Support » Plugins and Hacks » HTML upload garbled

HTML upload garbled

  • I saved an excel xlxs as html, and then uploaded. The result is garbled: the row/column mapping is completely off.

    Please advise.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author TobiasBg
    Participant

    @tobiasbg

    Hi,

    it is hard to tell what caused this, without seeing the HTML file.

    So, it would be great, if you could upload that somewhere.

    Also, please try saving to CSV and importing that. That’s actually a “more recommended” way for Excel files.

    Regards,
    Tobias

    Here’s a link to page with the garbled table.
    http://www.robertvbinder.com/home/thought-leadership/articles/biblography/

    You should be able to view/download the html file from
    http://www.robertvbinder.com/pubs-list.html

    Thanks
    Bob

    PS — the file has commas in many fields, and I want to preserve the links where they exist. Excel doesn’t support setting a non-comma csv delimiter on output, afiak.

    Plugin Author TobiasBg
    Participant

    @tobiasbg

    Hi,

    thanks for the link!
    I assume that the reason for this problem is the not really valid HTML in the file. Excel does a bad job there, as it adds attributes to the tags without properly wrapping them in quotation marks. That likely throws the import library off.

    For the CSV: You are correct that Excel uses commas as the delimiter, it does however correctly escape commas in cells. This is detected by the import library, so you should actually have no problems with the CSV file.

    Regards,
    Tobias

    The csv export is correctly parsed for rows/columns.

    But, none of the hyperlinks are transfered, so I think I’ll hand hack the Excel output and just paste that in. Also there are some unicode (Chinese) characters that are dropped.

    Anyway, thanks for the prompt follow up — these limitations aside, this is a very nice tool with great documentation.

    Bob

    Plugin Author TobiasBg
    Participant

    @tobiasbg

    Hi Bob,

    yes, the hyperlinks seem not to be exported to CSV by Excel 🙁

    And those Unicode characters likely get lost during some kind of character encoding conversion… :-/

    Best wishes,
    Tobias

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘HTML upload garbled’ is closed to new replies.