Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kenny Burns 173 posts 305 karma points
    Apr 21, 2014 @ 10:33
    Kenny Burns
    0

    Wrong Local header signature

    Hello,

    I purchased the CMS Import license last night as I was having issues trying to import with CSV files and thought I would be able to import straight from Excel without exporting to CSV first. When I try and do this I get the error:

    Error validating the Data source: Wrong Local header signature: 0xE011CFD0

    I have tried this on several spreadsheets, even one that simply has 3 columns, with headers and 2 rows with very little data in it and still get the issue. 

    Any ideas?

    Thanks,

    Kenny

    Copy Link
  • Dan 1288 posts 3921 karma points c-trib
    Apr 21, 2014 @ 12:03
    Dan
    0

    Hi Kenny,

    Does the Excel file have frozen panes or anything like that? If so, try just a plain Excel file without any advanced stuff and see if that works.

    Copy Link
  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Apr 22, 2014 @ 08:43
    Richard Soeteman
    0

    Hi Kenny,

    What Dan says and I had an issue reported last week where xls had issues and xlsx didn't. Can you save as xslx and see if that helps?

    Thanks and sorry for having the difficult start.

    Best,

    Richard

    Copy Link
  • Kenny Burns 173 posts 305 karma points
    Apr 22, 2014 @ 10:47
    Kenny Burns
    0

    Hi Guys,

    Thanks for the reply. I tried everything,no frozen panes or anything like that and tried xls and xlsx but nothing seemed to work, even with a simple spreadsheet. Not sure what the issue was.

    After a while of trying I was eventually was able to get it all exported to CSV though and imported that way.

    Can try again tonight and let you know the results -

    Kenny

    Copy Link
  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Apr 22, 2014 @ 10:50
    Richard Soeteman
    0

    Hi Kenny,

    In that case I am very interested in the excel sheet. If you like to share it [email protected] please.

    Thanks,

    Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft