Differences

This shows you the differences between two versions of the page.

--- procedures:metanonord_autolettura [2026/05/29 10:04] – created luca.bottoli
+++ procedures:metanonord_autolettura [2026/05/29 10:11] (current) – luca.bottoli
@@ Line 1: / Line 1: @@
 ====== AUTOLETTURA METANONORD PROCEDURE ======
-== This procedure must be performed every 1st of the month ==
+==== This procedure must be performed every 1st of the month ====
-. EXPORT BETRACKER
+=== 1. EXPORT BETRACKER ===
   * Fare export delle anagrafiche da BeTracker e rinominare in export.csv
   * Fare una copia del file e rinominare in copia.csv
   * Spostare entrambi nella cartella dove c'è lo script metanonord_autolettura.ipynb
 ----
-. Create a downloadable report by clicking on Analizza -> Rapporti Finanziari -> Crea Rapporto
+=== 2. IMPORT FILE AUTOLETTURE DA SFTP METANONORD ===
-{{infobip_billing_wa_2.png}}
+  * Path: /MH2BE/Ultime_Letture.csv
+  * Rinominare in from_metano.csv
+  * Spostare nella cartella dove c'è lo script metanonord_autolettura.ipynb
 ----
-. Filters to apply:
+=== 3. LANCIARE LO SCRIPT ===
-- Channell: SMS
+{{ :procedures:metanonord_autolettura.zip |Script}}
-- Period and frequency: last month
-- Format of the file: .xlsx
-Then click to Crea Rapporto
-{{infobip_billing_sms_1.png}}
 ----
-. Once redirected in the previous page, wait the creation of the report. Once the download icon is visible, click on it to download the report. A .zip file will be downloaded
+=== 4. IMPORT IN BETRACKER ===
-{{infobip_billing_wa_4.png}}
+  * File to_betracker.csv
+  * Importarlo in BeTracker facendo attenzione a mapping e formato
 ----
-. Do the previous steps for all of the Infobip Whatsapp accounts, the result will be a list of .zip files. Move all the files in the same folder as the script {{infobip_billing_sms.zip}}
+=== 5. EXPORT SU SFTP METANONORD ===
+  * File to_metano.csv
+  * Caricare nell'SFTP di Metano alla path /BE2MH/to_metano.csv
 ----
-. Run the script, the result will be similar to the following.
+=== 6. TENERE TUTTI I FILE PER STORICO ===
-{{infobip_billing_sms_2.png}}
-----
-. Copy and paste the results into the shared Excel file (https://becloudsolutionssrl.sharepoint.com/:x:/r/sites/IT_Billing/_layouts/15/Doc.aspx?sourcedoc=%7BDCFE79C8-5510-4165-8A83-FA8313D62226%7D&file=Traffico-SMS_2026.xlsx&action=default&mobileredirect=true).
-----
-. For Estendo, you need to send an email via voice traffic with your previous month's spending/remaining balance (see previous correspondence for details). For Servicecredit, you need to calculate the division of the SMS packages into 4 (for details, ask Admin, Luca T., and Federico or see previous correspondence for details from Voicetraffic).