CSV Export File Malformed Issue

grumpy1948
grumpy1948
Offline
0
Issues with Payments CSV Export File shown here are detailed below:

Invoice #;Contact;E-mail;Joomla user;Due date;Payment datetime;Payment amount;Payment type;Status;
2017-000004;;;;2017-10-20 00:00:00;;896 70;;;
2017-000003;;;;2017-10-20 00:00:00;;896 70;;;
2017-000002;;;;2017-10-20 00:00:00;;897 45;;;
2017-000001;;;;2017-10-20 00:00:00;;897 45;;;

NB Actual Details have been replaced by <...> in the above.

Issues

The Payments CSV File is separated with semi-colons instead of Comma's.
Is this intentional? If so is it possible to change it ? It is confusing to non-technical users who do not know how to change the separator in Excel or OpenOffice etc.

The currency separator is a comma despite it being set to a period in the settings (hence the only column separation in the above)

Is it possible to customise the layout and content using an override? If so where is the code?

Accepted Answer

Tuesday, April 18 2017, 10:06 AM - #Permalink
0
well, you are right about the payments CSV export.

Please find attached a file to solve this issue.
You must unzip this file, and place it in

/administrator/components/com_invoices/views/payments/tmpl/default_csv.php
Attachments:
The reply is currently minimized Show
Responses (5)
  • Accepted Answer

    grumpy1948
    grumpy1948
    Offline
    Friday, April 14 2017, 07:38 AM - #Permalink
    0
    grumpy1948 wrote:
    Original Post stripped out some of the data due to use of <..> now correct.

    Issues with Payments CSV Export File shown here are detailed below:

    Invoice #;Contact;E-mail;Joomla user;Due date;Payment datetime;Payment amount;Payment type;Status;
    2017-000004;xxxxxxxxxx;xxxxxxxxxx;xxxxxxxxxx;2017-10-20 00:00:00;;896 70;;;
    2017-000003;xxxxxxxxxx;xxxxxxxxxx;xxxxxxxxxx;2017-10-20 00:00:00;;896 70;;;
    2017-000002;xxxxxxxxxx;xxxxxxxxxx;xxxxxxxxxx;2017-10-20 00:00:00;;897 45;;;
    2017-000001;xxxxxxxxxx;xxxxxxxxxx;xxxxxxxxxx;2017-10-20 00:00:00;;897 45;;;

    NB Actual Details have been replaced by xxxxxxxxxx in the above.

    Issues

    The Payments CSV File is separated with semi-colons instead of Comma's.
    Is this intentional? If so is it possible to change it ? It is confusing to non-technical users who do not know how to change the separator in Excel or OpenOffice etc.

    The currency separator is a comma despite it being set to a period in the settings (hence the only column separation in the above)

    Is it possible to customise the layout and content using an override? If so where is the code?
    The reply is currently minimized Show
  • Accepted Answer

    Friday, April 14 2017, 08:29 AM - #Permalink
    0
    hello,

    in Invoice Manager configuration options you have a setting specifically for this, called "CSV column separator".
    The reply is currently minimized Show
  • Accepted Answer

    grumpy1948
    grumpy1948
    Offline
    Sunday, April 16 2017, 11:39 AM - #Permalink
    0
    Hi Germinal

    Sorry for delay. Other problems with live Invoicing so final output not an immediate issue. However just tried again after checking that it is set to , (comma)!! and it works fine :( no time to investigate the original cause now however.
    Supplementary question is it possible to customise the fields that are output in this report? Some of the fields are of no interest to a non-technical accounts user.
    F
    The reply is currently minimized Show
  • Accepted Answer

    grumpy1948
    grumpy1948
    Offline
    Sunday, April 16 2017, 10:14 PM - #Permalink
    0
    I spoke too soon. Yes the Invoice export works OK however the Payments export file which was the subject of the original post is as above. Colon separated not Comma. Please investigate.
    Regards
    The reply is currently minimized Show
  • Accepted Answer

    grumpy1948
    grumpy1948
    Offline
    Friday, April 28 2017, 04:41 PM - #Permalink
    0
    Yes Setting that Flag worked a treat.
    Tks
    The reply is currently minimized Show
Your Reply