Differences

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

Link to this comparison view

Both sides previous revision Previous revision
vendors:cisco:uc:cms [2021/10/20 16:13] – [Verify JSON format of CDR file and correct if necessary] gerardorourkevendors:cisco:uc:cms [2021/10/20 16:15] (current) – [Verify JSON format of CDR file and correct if necessary] gerardorourke
Line 45: Line 45:
  
   * The File can have some corruption on it. Check it is valid JSON using JQ - https://stedolan.github.io/jq/download/   * The File can have some corruption on it. Check it is valid JSON using JQ - https://stedolan.github.io/jq/download/
-  * Even if the file is not corrupt - I found running it through JQ was necessary. 
 <code>  <code> 
 C:\X-Temp>jq-win64 -c . CDRs1.json > CDR12.json C:\X-Temp>jq-win64 -c . CDRs1.json > CDR12.json
Line 58: Line 57:
 fixes this issue. fixes this issue.
  
-Confirm all good by re-running with JQ. +  * Even if the file is not corrupt - I found running it through JQ was necessary. 
 +<code> son2csv -i CDR2021_1.json -o CDR2021_1_V2.csv </code> 
 +  * Use the output from this this as the input to the json2csv
 ==== JSON2CSV ==== ==== JSON2CSV ====
  
  • vendors/cisco/uc/cms.1634742829.txt.gz
  • Last modified: 2021/10/20 16:13
  • by gerardorourke