Import SOTA CSV problems

Post Reply
WB8ICQ
Novice Class
Posts: 4
Joined: 27 Apr 2020, 19:15

Import SOTA CSV problems

Post by WB8ICQ »

I am a new Log4OM v2 (2.5.0.0) user. I have about 400 SOTA QSOs that are in the SOTA database that I would like to load into Log4OM. These QSOs currently are NOT in my Log4OM database. My main reason for this is to include the DX contacts, some of which are unique entities for me. I downloaded all my SOTA QSOs as a CSV file. I am following the process in the manual but it's not working for me. Here's what I am doing and seeing:
- Log4OM "View" tab - select "Award Statistics"
- Award Statistics window: in the Award box, pick SOTA from the drop-down menu
- For Predefined Configuration, select Activator
- Click "Import Data" tab. This opens the Batch Confirmation window, under the Parameters tab.
- select as import file the CSV file I downloaded.
- select "," as field separator.
- check the "File contains header" box.
- click "Preview" button. The preview box displays five lines: the header line, and four lines each with data for one QSO.
- click "Load config" and select the SOTA_IMPORT_CONFIRMATIONS configuration.The attached file WB8ICQ.batch1.JPG shows what I see in the Batch Confirmation window. I note that "YourCallsign" does not appear in the green boxes.
WB8ICQ.batch1.JPG
WB8ICQ.batch1.JPG (93.29 KiB) Viewed 1621 times
- click Execution tab.
- In The Execution tab, I clicked on the left-hand gear to simulate the import. Every time, the import fails. The attached file WB8ICQ.batch2.JPG shows the window.
WB8ICQ.batch2.JPG
WB8ICQ.batch2.JPG (177.79 KiB) Viewed 1621 times
[attachment=1]

I would appreciate some guidance on what I should do differently to make this work. Thanks!
73, Scott WB8ICQ
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Import SOTA CSV problems

Post by G4POP »

As stated on Page 104 of our user guide it is an import (Merge) - Merge means that imported data is merged with existing data to update it, not add to it

The purpose is to update QSO's that exist in Log4OM from the SOTA file, not add new QSO's - Thats what the error messages mean there is no QSO to 'Match' to.

The best way to add new SOTA QSO's is to use a CSV to ADIF converter, there are several on-line on the internet, and then import the ADIF file as normal.

Make sure the converted file contains all required information.

If you need help then let me know
73 Terry G4POP
User avatar
KI5IO
Moderator
Posts: 1948
Joined: 16 Aug 2015, 16:30
Location: Plano, TX

Re: Import SOTA CSV problems

Post by KI5IO »

Topic is about V2 ... thus has been moved to the Log4OM v2 portion of the Forum.
73 - Nolan Kienitz - KI5IO
Plano, TX
Post Reply