Tried format excel but configuration is not OK:

Options
BhaveshParikh
BhaveshParikh Registered Posts: 5

Hello Experts,

Trying to import the Excel dataset (Office 365) but getting an error "Tried format excel but configuration is not OK:". It just doesn't recognize the Excel file. I tried saving the excel file as csv and try to upload. The same issue, dataiku doesn't recognize the format.

What is missing here? Please find attached file am using to upload.

Please help.

Thanks...Bhavesh


Operating system used: Windows 10

Answers

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Options

    Hi,

    I managed to reproduce the error when using CSV or Excel format without xslx format.

    On the other hand, I was successful if the XSLX format box was checked. See 'Capture.PNG'.

    Saving the file as an xls or csv format and importing does also work automatically for me.

    What version of DSS do you use?

  • BhaveshParikh
    BhaveshParikh Registered Posts: 5
    Options

    Thanks Miguel for the swift response.

    I did tried checking with XLSX format and also with csv/xls format but unfortunately the same error.

    I'm using free version - 9.0.3.

    May be it is the version issue?

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
    Options

    Hi @BhaveshParikh
    are you able to upgrade to the latest version of Dataiku? For more information, Upgrading a DSS instance

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @BhaveshParikh
    ,

    welcome to the Dataiku community.

    if you are talking about the Dataiku DSS version, 9.0.3 is definitely getting a bit old now. Dataiku DSS is now up to at least 11.0.3.

  • BhaveshParikh
    BhaveshParikh Registered Posts: 5
    Options

    Thanks Corey for the response.

    Since am on a free version, not sure if i can upgrade. Let me check though.

  • BhaveshParikh
    BhaveshParikh Registered Posts: 5
    Options

    Thanks Tom for the reply.

    Well the file is a simple excel dataset with no special data (no VBA/no images/no encryption/no virus !) and you are right, in the past I could also upload other excel files but today seems to be a special day.

    Since am on a free (training) version, let me see how can i upgrade.

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Options

    Hi,

    I tried uploading the file in a 9.0.3 install and it still works, so the version does not seem to be the issue here.

    Is the uploaded Excel file exactly the same file being uploaded on your DSS? With that I mean, is the uploaded xslx file a copy of the original file or the original itself? I ask that because '.xlsx' files created by 3rd party softwares other than Microsoft Excel are not supported.

    Can you try a roundabout way, get the Excel file into DSS from a Download recipe, then connect that to a managed folder, and finally output that into a dataset.

    If that still does not work we would need to look at the backend.log. Yet, this is not the best location to upload it. We would need to move the discussion to a ticket. Instructions on how to create one are here

  • BhaveshParikh
    BhaveshParikh Registered Posts: 5
    Options

    The file is a native Excel file i.e. created in Excel. I tried the same file (with just 5 records)uploading and getting the same error.

    Will try using the Download recipe but was wondering what could be the issue for such a simple task !

    Thanks for the help.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @BhaveshParikh

    do I understand that importing files at one time worked?

    is the problem with just this one file? Or Is the problem now with any file import?

    as long as the software is unchanged have you looked at the file system volumes on the server? Had the server run out of disk space?

    also wondering how long it has been since the instance has been restarted?

    finally this feels like something that might be better handled in a support ticket.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @BhaveshParikh
    ,

    Regarding upgrade, Are you using Dataiku Data Science Studio (DSS) on your local computer or in the cloud as provided by Dataiku, or on your personal or company cloud account? If you are using locally you can upgrade, I’ve likely done it a dozen times. If you are on Macintosh this is fairly strait forward. If you are on Unix, or a Unix VM this is a bit more work but I’ve found the process fairly straight forward with the documentation.

  • hakverir
    hakverir Registered Posts: 2
    Options
  • bleclair
    bleclair Registered Posts: 3
    Options

    Not sure it'll help anyone but thought I'd add to this...

    We ran into the OLE problem only to find that the xlsm's that were being submitted were only xlsm because someone changed the file extension. They did not resave the file as xlsm. Upon forcing the file extension back to xls, opening the document then resaving as xlsm, the problem went away.

Setup Info
    Tags
      Help me…