| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| procedures:monthly [2024/10/08 14:07] – corrected some syntax errors antonio.andriychuk | procedures:monthly [2024/11/04 13:35] (current) – Removed Sabrina Rispoli and Sabina Alpeggiani sysadm |
|---|
| ===== CDRs ===== | ===== CDRs ===== |
| This topic is rather important since it involves an economic value for the company. And guess what? I've developed a script for this part as well! :) \\ | This topic is rather important since it involves an economic value for the company. And guess what? I've developed a script for this part as well! :) \\ |
| | |
| | \\ |
| | Download links for all CDRs: |
| | * [[https://insights.voxbone.com/|Voxbone]] --> Click on "DOWNLOAD CSV" and select month time range |
| | * [[https://cdr.irideos.it/reserved/home|Irideos]] --> Click on the only folder, then select the interested month and click "download" |
| | * [[https://envision.gtt.net/billing-invoice|GTT]] --> download the .csv of the interested month |
| | * [[https://portal.telnyx.com/#/reporting/detailed-records|Telnyx]] --> TODO LORENZO |
| | * [[https://my.colt.net/billing/#/grid|Colt]] --> TODO LORENZO |
| | \\ |
| | |
| The required tools are the same as specified in the Concurrent Usage tab, thus you need the script in order to run the code, which can be downloaded from the following link: | The required tools are the same as specified in the Concurrent Usage tab, thus you need the script in order to run the code, which can be downloaded from the following link: |
| * CDRs code: [[cdrs:index]] \\ | * CDRs code: [[cdrs:index]] \\ |
| * In the Irideos folder: you have to create two files, one called "cdrs.csv" for outbound (the one that ends with ...38) and "cdrs_green.csv" for the toll-free traffic(the one that ends with ...39); | * In the Irideos folder: you have to create two files, one called "cdrs.csv" for outbound (the one that ends with ...38) and "cdrs_green.csv" for the toll-free traffic(the one that ends with ...39); |
| |
| Specifically for Irideos, I have a few tips: Once you've downloaded the file and extract them, you will obtain two folders as previously noted: | Specifically for Irideos, __I have a few tips__: \\ |
| | Once you've downloaded the file and extract them, you will obtain two folders as previously noted: |
| * if you use unix (MacOS or Linux) go inside the folder (for example the one that ends with ...38) and do this command: <code bash>cat 90* > cdrs.csv && mv cdrs.csv ../../ </code> to save the file in the correct folder; | * if you use unix (MacOS or Linux) go inside the folder (for example the one that ends with ...38) and do this command: <code bash>cat 90* > cdrs.csv && mv cdrs.csv ../../ </code> to save the file in the correct folder; |
| * if you use Windows (download [[https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.4#install-powershell-using-winget-recommended|Powershell 7]]) go inside the folder (for example the one that ends with ...38) and do this command: <code bash>cat 90* > cdrs.csv && mv cdrs.csv ../../ </code> to save the file in the correct folder; | * if you use Windows (download [[https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.4#install-powershell-using-winget-recommended|Powershell 7]]) go inside the folder (for example the one that ends with ...38) and do this command: <code bash>cat 90* > cdrs.csv && mv cdrs.csv ../../ </code> to save the file in the correct folder; |
| \\ | \\ |
| Then you can proceed with running the Python script, it will ask for an input regarding GTT to be extrapulated as well then you will receive in your terminal the values divided per each customer.\\ | Then you can proceed with running the Python script, it will ask for an input regarding GTT to be extrapulated as well then you will receive in your terminal the values divided per each customer.\\ |
| The next step is to store the "**Reselling Cost**" data in the [[https://docs.google.com/spreadsheets/d/1yTjXipu9NEHD21jLWteb6nDszzZonydV/edit?gid=692771078#gid=692771078|Master Traffico Ricariche]] spreadsheet, in the desired month and per each customer. After, you will have to repeat the same procedure on the monitor. \\ | The next step is to store the "**Reselling Cost**" data in the [[https://docs.google.com/spreadsheets/d/1yTjXipu9NEHD21jLWteb6nDszzZonydV/edit?gid=692771078#gid=692771078|Master Traffico Ricariche]] spreadsheet, in the desired month and per each customer.\\ |
| | After, you will have to follow this procedure on the monitor: |
| | - Go to the [[https://monitor.ccaas.becloudsolutions.com:3000/d/wMoz45sWz/traffic-situation?orgId=1|Monitor "Traffic Situation" page]] |
| | - Click on the interested tenant and select "Edit" |
| | - In the query editor you can see that there is a calculation: the first number is the recharge that Stefano will communicate to you (this is not monthly, a customer could be recharging every n month for example, you need to update this number **only if** it is communicated to you) and you also have to update it on the [[https://docs.google.com/spreadsheets/d/1yTjXipu9NEHD21jLWteb6nDszzZonydV/edit?gid=692771078#gid=692771078|shared spreadsheet]] and the second is the total traffic for the previous months. *BOTH NUMBERS ARE CUMULATIVE*, that means that at the start of the month (or 15 of the month for GTT) you need to add the total costs to the second number, and whenever Stefano communicate to you a recharge (it could be whenever during the month) you need to add the amount to the first number |
| \\ | \\ |
| In the [[https://monitor.ccaas.becloudsolutions.com:3000/d/wMoz45sWz/traffic-situation?orgId=1|monitor]], I strongly advise you to disable every [[https://monitor.ccaas.becloudsolutions.com:3000/alerting/list|alarm]] before performing any changes. Once you've secured that every alarm has been disabled you can proceed to open each window and change the first value of the query with the total gathered from the spreadsheet and save. \\ \\ | In the [[https://monitor.ccaas.becloudsolutions.com:3000/d/wMoz45sWz/traffic-situation?orgId=1|monitor]], I strongly advise you to disable every [[https://monitor.ccaas.becloudsolutions.com:3000/alerting/list|alarm]] before performing any changes. Once you've secured that every alarm has been disabled you can proceed to open each window and change the first value of the query with the total gathered from the spreadsheet and save. \\ \\ |
| The next step will be to access to the monitor machine and navigate to the __**monitorTraffic**__ folder and open the calculate.js file to change the month with the current one, then proceed with running the script with <code bash> node calculate.js </code> and wait until it finishes. \\ \\ | The next step will be to access (SSH) to the monitor machine and navigate to the __**/home/centos/monitorTraffic**__ folder and open the calculate.js file to change the month with the current one (variable "month" at line 25) in the format YYYY-MM-DD, then proceed with running the script with <code bash> node calculate.js </code> and wait until it finishes. \\ \\ |
| After, you will have to wait until you see that in the Traffic Situation monitor **__the values has been changed before restarting the alerts.__** \\ \\ | After, you will have to wait until you see that in the Traffic Situation monitor **__the values has been changed before restarting the alerts.__** \\ \\ |
| |
| The next steps will take you some time, which is to deliver the Carrier Costs and Reselling Costs to Admin... Feel free to use this E-Mail as an example: | The next steps will take you some time, which is to deliver the Carrier Costs and Reselling Costs to [[mailto:admin@becloudsolutions.com|Admin]] **for each customer**... Feel free to use this E-Mail as an example: |
| <code> | <code> |
| Ciao Stefano, | Ciao Stefano, |
| |
| The last step to do is to deliver an Email from Voicetraffic to these customers: | The last step to do is to deliver an Email from Voicetraffic to these customers: |
| * Farmacie Italiane; | * Farmacie Italiane ([[mailto:andrea.durante@gruppofarmacieitaliane.it|Andrea Durante]], [[mailto:umberto.gallo@gruppofarmacieitaliane.it|Umberto Gallo]]); |
| * Ingo-LRH; | * Ingo-LRH ([[mailto:davide.signorelli@ingogroup.it|Davide Signorelli]], [[mailto:luana.beni@ingogroup.it|Luana Beni]]); |
| * E80; | * E80 ([[mailto:fatture@elettric80.it|Fatture E80]]); |
| Only after you will receive the GTT file you have to send the CDR to this customer: | * BeEasy ([[mailto:m.rocchi@beeasy.cloud|Matteo Rocchi]]); |
| * RedSun; | Only after you will receive the GTT file you have to send the CDR (with our prices) to this customer: |
| | * RedSun ([[mailto:ict@arquati.it|ICT]]); |
| |
| You will find every data, as well as a template on the sent item of that same mailbox. | You will find every data, as well as a template on the sent item of that same mailbox. |
| |
| --- //[[antonio.andriychuk@becloudsolutions.com|Antonio Andriychuk]] 2024/10/08 13:28// | --- //[[antonio.andriychuk@becloudsolutions.com|Antonio Andriychuk]] 2024/10/08 13:28// |
