CSV export

Post Reply
Iu2nub
Novice Class
Posts: 9
Joined: 13 Dec 2020, 06:24

CSV export

Post 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
Attachments
Cattura.JPG
Cattura.JPG (238.93 KiB) Viewed 1706 times
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: CSV export

Post 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!
73 Terry G4POP
Iu2nub
Novice Class
Posts: 9
Joined: 13 Dec 2020, 06:24

Re: CSV export

Post 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
Attachments
some fields.csv
(1.66 KiB) Downloaded 95 times
all fields.csv
(27.99 KiB) Downloaded 95 times
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: CSV export

Post by G4POP »

You still failed to say where and how in Log4OM you are exporting the CSV from?
73 Terry G4POP
Iu2nub
Novice Class
Posts: 9
Joined: 13 Dec 2020, 06:24

Re: CSV export

Post 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
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: CSV export

Post 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?
73 Terry G4POP
Iu2nub
Novice Class
Posts: 9
Joined: 13 Dec 2020, 06:24

Re: CSV export

Post 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
Iu2nub
Novice Class
Posts: 9
Joined: 13 Dec 2020, 06:24

Re: CSV export

Post 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
Post Reply