{"id":1807,"date":"2020-12-09T16:57:18","date_gmt":"2020-12-09T15:57:18","guid":{"rendered":"http:\/\/www.aleroma.it\/fmmontano\/?page_id=1807"},"modified":"2025-01-15T14:24:55","modified_gmt":"2025-01-15T13:24:55","slug":"crea-file-csv-per-sota","status":"publish","type":"page","link":"https:\/\/www.aleroma.it\/fmmontano\/crea-file-csv-per-sota\/","title":{"rendered":"Crea file CSV per SOTA"},"content":{"rendered":"<p>Questa utility \u00e8 stata realizzata per agevolare gli attivatori che partecipano anche al SOTA in FM ; per risparmiare tempo e non dover inserire pi\u00f9 volte i propri QSO in diverse piattaforme, dopo aver inserito i vostri QSO in RadioEscursioni, questa funzione crea un file CSV nel formato SOTA, contenente tutti i QSO che avete effettuato nel corso dell&#8217;attivazione.<br \/>\nPotete successivamente utilizzare questo file CSV per caricare i QSO nel database SOTA; abbiamo lasciato la possibilit\u00e0 di inserire due dati che il sito RadioEscursioni non gestisce:<\/p>\n<ul>\n<li> In caso di QSO S2S potete inserire il summit del corrispondente<\/li>\n<li> Potete inserire un commento per ogni QSO<\/>\n<\/ul>\n<p>Per vostra informazione potete consultare qui <a href=\"https:\/\/www.aleroma.it\/fmmontano\/formattazione-del-file-csv-per-caricare-qso-nel-database-sota\/\">il manuale SOTA per il formato di questo file CSV.<\/a><br \/>\nQui sotto potete esaminare il file creato, e se non rilevate errori cliccate su Download CSV per scaricare il file sul vostro PC.<\/p>\n<form target='_new' action='https:\/\/www.aleroma.it\/fmmontano\/wp-content\/scripts_php\/download_CSV_per_SOTA.php' method='post'><table><tr><th>Selezionare per creare un CSV compatibile con OM_log<\/th><td colspan=2><input type='checkbox' name='OM_log' value='SI' checked><\/td><\/tr><tr><th>V2,Mio Call,Referenza,Data,Ora,Banda,Modo,Corrispondente<\/th><th>Ref. S2S<\/th><th>Commenti<\/th><\/tr><input type='hidden' name='data' value=''><input type='hidden' name='call' value=''><input type='hidden' name='ref' value=''><input type='hidden' name='locator[]' value='JN35UB'><input type='hidden' name='qrb[]' value='51'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IU1GFO<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IU1GFO'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN34SJ'><input type='hidden' name='qrb[]' value='61'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IK1YUX<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IK1YUX'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN45OL'><input type='hidden' name='qrb[]' value='177'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IK2ILH<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IK2ILH'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35TB'><input type='hidden' name='qrb[]' value='45'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IZ1JFT<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IZ1JFT'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN45MM'><input type='hidden' name='qrb[]' value='167'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IU2GDU<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IU2GDU'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN34SH'><input type='hidden' name='qrb[]' value='69'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IW1DTU<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IW1DTU'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35SF'><input type='hidden' name='qrb[]' value='52'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IZ1HVD<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IZ1HVD'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN34XF'><input type='hidden' name='qrb[]' value='96'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IZ1GDB<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IZ1GDB'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35TB'><input type='hidden' name='qrb[]' value='45'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,IK1WEG<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,IK1WEG'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35TB'><input type='hidden' name='qrb[]' value='45'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,00:00,144MHz,FM,I1WKN<\/td><input type='hidden' name='qso[]' value='V2 ,,,,00:00,144MHz,FM,I1WKN'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN34VJ'><input type='hidden' name='qrb[]' value='74'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:00,144MHz,FM,IK1GPG<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:00,144MHz,FM,IK1GPG'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35TB'><input type='hidden' name='qrb[]' value='45'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:00,144MHz,FM,IZ1JMV<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:00,144MHz,FM,IZ1JMV'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35UF'><input type='hidden' name='qrb[]' value='61'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:01,144MHz,FM,IK1EGC<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:01,144MHz,FM,IK1EGC'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN45AN'><input type='hidden' name='qrb[]' value='105'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:01,144MHz,FM,IW1ARE<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:01,144MHz,FM,IW1ARE'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN44GQ'><input type='hidden' name='qrb[]' value='113'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:02,144MHz,FM,IZ1TNA<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:02,144MHz,FM,IZ1TNA'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN44FQ'><input type='hidden' name='qrb[]' value='106'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:03,144MHz,FM,IQ1CQ<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:03,144MHz,FM,IQ1CQ'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN45LO'><input type='hidden' name='qrb[]' value='166'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:04,144MHz,FM,IU2NCJ<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:04,144MHz,FM,IU2NCJ'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN45FH'><input type='hidden' name='qrb[]' value='116'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:04,144MHz,FM,IU1CYQ<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:04,144MHz,FM,IU1CYQ'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35UF'><input type='hidden' name='qrb[]' value='61'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:27,432MHz,FM,IK1EGC<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:27,432MHz,FM,IK1EGC'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN34SH'><input type='hidden' name='qrb[]' value='69'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:28,432MHz,FM,IW1DTU<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:28,432MHz,FM,IW1DTU'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><input type='hidden' name='locator[]' value='JN35TB'><input type='hidden' name='qrb[]' value='45'><input type='hidden' name='referenza[]' value=''><tr><td>V2 ,,,,10:35,432MHz,FM,I1WKN<\/td><input type='hidden' name='qso[]' value='V2 ,,,,10:35,432MHz,FM,I1WKN'><td><input type='text' name='pippo[]' value='' placeholder='S2S' style='width: 70px;'><\/td><td><input type='text' name='note[]' value='' placeholder='Commenti'  style='width: 160px;'><\/td><\/tr><\/table>Il file che riceverai cliccando sul bottone <b>Download CSV<\/b> si trova nella cartella dove vengono messi di default i file scaricati; tale cartella si chiama <b>Scaricati<\/b> oppure <b>Download<\/b>.<br>\r\nIl nome del file scaricato \u00e8 <b>__.csv<\/b><br>\r\n\r\nATTENZIONE:leggere attentamente le note seguenti.\r\n<ul>\r\n<li>NOTA 1: SOTA non ammette i QSO con ponti ripetitori, per cui ricordarsi di rimuovere tali QSO dal file appena ricevuto.<\/li>\r\n<li>NOTA 2: SOTA non riconosce tutti i summit di FM Montano, per cui verificare sul sito SOTA che la attivazione da caricare sia stata effettivamente eseguita su un summit SOTA.<\/li>\r\n<\/ul>\r\nDopo aver cliccato sul bottone  puoi verificare il download del file sul tuo PC.<br><br><br><center><input type='submit' value='Download CSV'><\/center><\/form>\n","protected":false},"excerpt":{"rendered":"<p>Questa utility \u00e8 stata realizzata per agevolare gli attivatori che partecipano anche al SOTA in FM ; per risparmiare tempo e non dover inserire pi\u00f9 volte i propri QSO in diverse piattaforme, dopo aver inserito i vostri QSO in RadioEscursioni, questa funzione crea un file CSV nel formato SOTA, contenente tutti i QSO che avete &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.aleroma.it\/fmmontano\/crea-file-csv-per-sota\/\" class=\"more-link\">Leggi tutto<span class=\"screen-reader-text\"> &#8220;Crea file CSV per SOTA&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"_links":{"self":[{"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/pages\/1807"}],"collection":[{"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/comments?post=1807"}],"version-history":[{"count":10,"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/pages\/1807\/revisions"}],"predecessor-version":[{"id":3457,"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/pages\/1807\/revisions\/3457"}],"wp:attachment":[{"href":"https:\/\/www.aleroma.it\/fmmontano\/wp-json\/wp\/v2\/media?parent=1807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}