Share
ReportIs there a way to convert csv files to JSON format?
I have tried searching for same question but no luck.
Please advise.
Categories:
You’re offline. This is a read only version of the page.
221
Is there a way to convert csv files to JSON format?
I have tried searching for same question but no luck.
Please advise.
In case you are interested, I have just produced a video using your example for how this flow was built:
Although you have already accepted the solution, here is an even more basic version which does the same thing:
Download it here:
https://www.tachytelic.net/wp-content/uploads/CSVtoJSON-Simple_20210121200115.zip
The flow below produces the following output:
All responses (
Answers (
[
{
"SSID": "test1",
"sessionCount": "90 (54.22%)",
"clientCount": "26 (48.15%)",
"duration": "1d:11h:35m (62.06%)",
"totalUsage": "939.09MB (50.69%)",
"usage": "814.94MB/124.15MB"
},
{
"SSID": "-",
"sessionCount": "36 (21.69%)",
"clientCount": "13 (24.07%)",
"duration": "0d:2h:55m (5.09%)",
"totalUsage": "0.00B (0.0%)",
"usage": "0.00B/0.00B"
},
{
"SSID": "test2",
"sessionCount": "21 (12.65%)",
"clientCount": "13 (24.07%)",
"duration": "0d:8h:35m (14.97%)",
"totalUsage": "538.12MB (29.05%)",
"usage": "500.54MB/37.58MB"
},
{
"SSID": "test3",
"sessionCount": "14 (8.43%)",
"clientCount": "8 (14.81%)",
"duration": "0d:8h:0m (13.95%)",
"totalUsage": "25.28MB (1.36%)",
"usage": "20.60MB/4.68MB"
},
{
"SSID": "test4",
"sessionCount": "3 (1.81%)",
"clientCount": "2 (3.7%)",
"duration": "0d:0h:20m (0.58%)",
"totalUsage": "55.76KB (0.0%)",
"usage": "26.93KB/28.84KB"
},
{
"SSID": "test5",
"sessionCount": "2 (1.2%)",
"clientCount": "1 (1.85%)",
"duration": "0d:1h:55m (3.34%)",
"totalUsage": "350.14MB (18.9%)",
"usage": "338.73MB/11.41MB"
}
]
Here is the flow (you can also view it here, https://ibb.co/DDG5z7F )
Because this flow may be difficult for you to copy, I have exported it so you can import it into your environment:
https://www.tachytelic.net/wp-content/uploads/CSVtoJSON_20210121194739.zip
No need to remove the first two lines, the flow handles it just the way it is.
Thank you so much.
here it is
Session Data by SSID,,,,,
SSID,Session Count (%),Client Count (%),Duration (%),Total Usage (%),Usage (In/Out)
test1,90 (54.22%),26 (48.15%),1d:11h:35m (62.06%),939.09MB (50.69%),814.94MB/124.15MB
-,36 (21.69%),13 (24.07%),0d:2h:55m (5.09%),0.00B (0.0%),0.00B/0.00B
test2,21 (12.65%),13 (24.07%),0d:8h:35m (14.97%),538.12MB (29.05%),500.54MB/37.58MB
test3,14 (8.43%),8 (14.81%),0d:8h:0m (13.95%),25.28MB (1.36%),20.60MB/4.68MB
test4,3 (1.81%),2 (3.7%),0d:0h:20m (0.58%),55.76KB (0.0%),26.93KB/28.84KB
test5,2 (1.2%),1 (1.85%),0d:1h:55m (3.34%),350.14MB (18.9%),338.73MB/11.41MB. Thanks for the instruction.
