Loosing URLs when migrating

  • Resolved Seph

    (@seph)


    12 years ago

    Hey there,

    I’m trying to migrate rather big tables from an old site to a new site. I got plain table html – which I can’t import because I’m getting several error messages.

    So what works though is both. I can open the HTML in excel, it shows fine, I save it as excel or csv and I import it in tablepress and it just loosk and works fine as it should. With just ONE exception…I’m lossing all links. 🙁 It’s a table with press releases and in every row there was a link to a PDF. The link is STILL there in excel, so importing it to excel from the html is not the problem. It gets somehow lost from excel to csv to tablepress.

    Any idea? Thanks a lot!

    https://wordpress.org/plugins/tablepress/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter Seph

    (@seph)

    12 years ago

    The errors I get when importing plain html are all similar. Something along:

    Error 68: htmlParseEntityRef: no name in line 54, column 45
    Error 68: htmlParseEntityRef: no name in line 74, column 30

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The reason for the missing URLs is that Excel is changing them from the HTML format to its custom format when opening the HTML file in Excel, but it doesn’t export them as HTML again 🙁
    The best way to proceed here should therefore be to fix the validation errors in the original HTML code.
    Have you tried running that through the validator at http://validator.w3.org/ ? With that, we could fix the HTML so that it should import fine.
    Also, can you please post a link to the page with the (old) table, so that I can take a direct look? Thanks!

    Regards,
    Tobias

    Thread Starter Seph

    (@seph)

    12 years ago

    I could send you the table as .txt if you give some sort of e-mail. The table I’m using is already modified with new URLs etc. – it’s not online yet.

    And thanks for your support! Certainly no reason to say “sorry”, your Plugin is great. I’d be interested if you are already working on responsive features, maybe for a premium price?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    sure. My email is in the main plugin file “tablepress.php”.

    For responsiveness, there’s an Extension (not perfect) at http://tablepress.org/extensions/responsive-tables/

    Regards,
    Tobias

    Thread Starter Seph

    (@seph)

    12 years ago

    Sent. Thanks a lot!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    thanks! I just replied with fixed versions of the files. Basically, there were just some validation errors that had to be fixed.

    Regards,
    Tobias

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

The topic ‘Loosing URLs when migrating’ is closed to new replies.