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?

hello,

in Invoice Manager configuration options you have a setting specifically for this, called "CSV column separator".

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

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

Yes Setting that Flag worked a treat.
Tks