Forum Discussion

ca le's avatar
ca le
Copper Contributor
Sep 20, 2017

CSV Downloads Not Working

Since yesterday (September 18, 2017), my financial report downloads (CSV files) have not worked properly.  Opening the downloaded file results in all the data appearing in a single cell (A1), in "mumbo jumbo" text form.  The alert about "preserving features" suggests saving the file as a .csv file, which is redundant since the file is already a .csv file.

Please advise what is causing this malfuction all of a sudden and how to fix it.

Thanks.

ca le

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 20, 2017

    Yes, that's not an Excel issue, it looks like the routine which export csv file doesn't perform HTML/XML decoding.

     

    If take beginning of your file

     

    Category%2CSymbol%2CDescription%2CAccount%2CQuantity%2CValue%2CMarket

    the HTML entity for "%" is "%", if substitute it the string will be like

    Category%2CSymbol%2CDescription%2CAccount%2CQuantity%2CValue%2CMarket

    and %2C is the HEX code for the comma. Finally it shall be

    Category,Symbol,Description,Account,Quantity,Value,Market

    So, if the report is decoded correctly you'll have no problems with Excel.

     

     

  • Deleted's avatar
    Deleted
    Sep 20, 2017

    Hi,

     

    I suggest to compare the CSV file (you have uploaded here) with a CSV file, which previously worked. For comparing, open both in a text editor (such as Notepad) and not in Excel. Are the format and structure of the CSV's the same? If not, then there may have been something changed in the system which creates the CSV files.

     

    Best,

    Mourad

Resources