Page 1 of 1

CSV export

Posted: 06 Oct 2021, 13:14
by Iu2nub
Good morning,
i tried to export all my logbook (less than 1000 qso), but i get a totally wrong data at least in the first lines.
Attached screen shot I see.
Maybe am I wrong something?
Thanks
73
Roberto

Re: CSV export

Posted: 06 Oct 2021, 13:31
by G4POP
Where/how are you exporting the file from and what is incorrect - your screen shot is too small for me to read even on my 32 inch monitor!

Re: CSV export

Posted: 09 Oct 2021, 08:08
by Iu2nub
Sorry I'm late in replying Terry
So the problem is in the Carriage return-Line feed (CR-LF) characters found at the end of the first two lines of each exported record.
The csv file should have only one cr-lf at the end of the record as its component fields must be separated by;
This "error" only happens if I export the file asking for all the data base fields, if I ask for only a part of the fields the file is correct.
I am attaching the two files:
1- all the fields of the database of some records
2- only some fields of the database of the same records
where you can see the difference in the formatting of the two files
Thanks for the attention
Roberto
Iu2nub

Re: CSV export

Posted: 09 Oct 2021, 08:24
by G4POP
You still failed to say where and how in Log4OM you are exporting the CSV from?

Re: CSV export

Posted: 09 Oct 2021, 08:59
by Iu2nub
Sorry I thought it was clear from the title of the subject.
both from:
File - Export to CSV
that from Utilities - qso manager - Export to CSV

Thanks
Roberto

Re: CSV export

Posted: 09 Oct 2021, 14:13
by G4POP
Iu2nub wrote: 09 Oct 2021, 08:59 Sorry I thought it was clear from the title of the subject.
both from:
File - Export to CSV
that from Utilities - qso manager - Export to CSV

Thanks
Roberto
No it was not obvious because there are a few places the export can be done, However I am refereeing this to Lele because clearly something is not working for you although I dont have an issue using the latest version of Excel.

What software are you opening the file with, notepad?

Re: CSV export

Posted: 10 Oct 2021, 06:34
by Iu2nub
Thanks,
I use the "notepad++" program to view the cvs (an advanced editor that I started using in the office when I was writing programs) and the latest release libreoffice program to create the excel file.
I also brought the file to a pc that has office 2019, but the excel sheet is created exactly the same as that of libreoffice
Thanks
73
Roberto IU2NUB

Re: CSV export

Posted: 14 Nov 2021, 07:40
by Iu2nub
Thanks Terry
thanks Daniele too, I saw that in the new version of Log4om the problem of the error in the cvs fields formatting has been corrected.
Thank you again
Robeto
IU2NUB