JSPM – zsv@1.0.0

Package Exports

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (zsv) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

Zoom Meeting CSV Parser

A simple Zoom meeting csv parser.

(This software is considered alpha quality and is subject to change without notice)

Basic Usage

const {
  zoom,

  // transformations
  camelCase,
  compact,
  deDupeByName,
  deDupeByIP,
  flatten,
  group,
  minutesInMeeting,
  pluck,
  toArray,
} = require('./index');

// transformations are optional, you may supply your own or none at all
zoom('example.csv', deDupeByName, camelCase, flatten)
  .then(data => {
    const [hosts, participants] = data;

    // Do stuff with your hosts and participants
    console.log(hosts);
    console.log(participants);
  })
  .catch(error => {
    // Handle error
    console.log(error.message);
  });

Unaltered Meeting Participant

{
  participant: "archer",
  device: "Mac",
  ip_address: "192.168.241.19",
  location: "Milpitas (US )",
  network_type: "Wifi",
  join_time: "06:00 AM",
  leave_time: "06:03 AM",
  version: "3.5.64836.0908",
  audio__receiving_bitrate: "79 kbps",
  audio__sending_bitrate: "-",
  audio__receiving_latency: "77 ms",
  audio__sending_latency: "-",
  audio__receiving_jitter: "8 ms",
  audio__sending_jitter: "-",
  audio__receiving_packet_loss_avg_max: "0.15 %(0.65 %)",
  audio__sending_packet_loss_avg_max: "-(-)",
  video__receiving_bitrate: "-",
  video__sending_bitrate: "-",
  video__receiving_latency: "77 ms",
  video__sending_latency: "-",
  video__receiving_jitter: "9 ms",
  video__sending_jitter: "-",
  video__receiving_packet_loss_avg_max: "-(-)",
  video__sending_packet_loss_avg_max: "-(-)",
  video__receiving_resolution: "-",
  video__sending_resolution: "-",
  video__receiving_frame_rate: "-",
  video__sending_frame_rate: "-",
  screen_sharing__receiving_bitrate: "155 kbps",
  screen_sharing__sending_bitrate: "155 kbps",
  screen_sharing__receiving_latency: "78 ms",
  screen_sharing__sending_latency: "78 ms",
  screen_sharing__receiving_jitter: "11 ms",
  screen_sharing__sending_jitter: "9 ms",
  screen_sharing__receiving_packet_loss_avg_max: "-(-)",
  screen_sharing__sending_packet_loss_avg_max: "-(-)",
  screen_sharing__receiving_resolution: "2560*1440",
  screen_sharing__sending_resolution: "2560*1440",
  screen_sharing__receiving_frame_rate: "16 fps",
  screen_sharing__sending_frame_rate: "19 fps",
  zoom_min_cpu_usage: "4 %",
  zoom_avg_cpu_usage: "8 %",
  zoom_max_cpu_usage: "11 %",
  system_max_cpu_usage: "23 %"
}

Transformations

There are a number of included transformations that alter the structure of participant and host objects.

camelCase

Transforms fields to camel case

zoom('meeting.csv', camelCase)
  .then(...)

Output:

{
  participant: "archer",
  device: "Mac",
  ipAddress: "192.168.241.19",
  location: "Milpitas (US )",
  networkType: "Wifi",
  joinTime: "06:00 AM",
  leaveTime: "06:03 AM",
  ...
}

compact

Removes null and undefined values from webinar csv's

zoom('webinar.csv', compact)
  .then(...)

deDupeByName

Merge participants based on name (participant). May contain arrays of values.

zoom('meeting.csv', deDupeByName)
  .then(...)

Output:

{
  participant: "archer",
  device: "Mac",
  ip_address: "192.168.241.19",
  location: "Milpitas (US )",
  network_type: "Wifi",
  join_time: ["06:00 AM", "06:11 AM"],
  leave_time: ["06:03 AM", "06:37 AM"],
  ...
}

deDupeByIP

Merge participants based on IP. May contain arrays of values.

zoom('meeting.csv', deDupeByIP)
  .then(...)

Output:

{
  participant: ["archer", "Archer"],
  device: "Mac",
  ip_address: "192.168.241.19",
  location: "Milpitas (US )",
  network_type: "Wifi",
  join_time: ["06:00 AM", "06:11 AM"],
  leave_time: ["06:03 AM", "06:37 AM"],
  ...
}

flatten

Flatten array values after deDuping.

zoom('meeting.csv', deDupeByIP, flatten)
  .then(...)

Output:

{
  participant: "archer",
  device: "Mac",
  ip_address: "192.168.241.19",
  location: "Milpitas (US )",
  network_type: "Wifi",
  join_time: "06:00 AM",
  leave_time: "06:37 AM",
  ...
}

group

Group creates objects from similar field names, such as:

{
  screen_sharing__receiving_bitrate: "155 kbps",
  screen_sharing__sending_bitrate: "155 kbps"
}

zoom('meeting.csv', group)
  .then(...)

Output:

{
  screen_sharing: {
    receiving_bitrate: "155 kbps",
    sending_bitrate: "155 kbps",
    receiving_latency: "78 ms",
    sending_latency: "78 ms",
    receiving_jitter: "9 ms",
    sending_jitter: "9 ms",
    receiving_packet_loss_avg_max: "-(-)",
    sending_packet_loss_avg_max: "-(-)",
    receiving_resolution: "2560*1440",
    sending_resolution: "2560*1440",
    receiving_frame_rate: "16 fps",
    sending_frame_rate: "16 fps"
  },
  ...
}

minutesInMeeting

Attempts to calculate participant time spent in the meeting.
Adds new property minutes_in_meeting by default, or minutesInMeeting if camelCase transform has been utilized.

zoom('meeting.csv', minutesInMeeting)
  .then(...)

Output:

{
  participant: "archer",
  device: "Mac",
  ip_address: "192.168.241.19",
  location: "Milpitas (US )",
  ...
  minutes_in_meeting: 3
}

pluck

Pluck takes a list of field names to create a new object.

zoom('meeting.csv', pluck('participant', 'device', 'location', ['ip_address', 'network_type']))
  .then(...)

Output:

{
  participant: "archer",
  ip_address: "192.168.241.19",
  device: "Mac",
  network_type: "Wifi",
  location: "Milpitas (US )"
}

toArray

Creates an array of key value pairs.

Output:

[
  [ 'participant', 'archer' ],
  [ 'device', 'Mac' ],
  [ 'ip_address', '192.168.241.19' ],
  [ 'location', 'Milpitas (US )' ],
  [ 'network_type', 'Wifi' ],
  [ 'join_time', '06:00 AM' ],
  [ 'leave_time', '06:03 AM' ],
  ...
]

Transforming with group before toArray will create multiple nested arrays.

[
  ['participant', 'archer'],
  [
    'audio',
    [
      ['receiving_bitrate', '79 kbps'],
      ['sending_bitrate', '-'],
      ['receiving_latency', '77 ms'],
      ['sending_latency', '-'],
      ['receiving_jitter', '8 ms'],
      ['sending_jitter', '-'],
      ['receiving_packet_loss_avg_max', '0.15 %(0.65 %)'],
      ['sending_packet_loss_avg_max', '-(-)'],
    ],
  ],
];

Custom Transforms

You may create your own custom transformations by supplying a function with the following interfaces:

function doStuff(participants) {
  // do stuff with the participants array
  for (const participant of participants) {
    // things are happening
  }

  // return array of participants
  return participants;
}

or:

function transform(field, value, participant) {
  // do stuff with participant

  participant[field] = `modified ${value}`;

  // no return, directly manipulate passed objects
}

Caveats

Pluck attempts to transform both host and participant objects.
If you plan to work with the host object it might behoove you to utilize pluck after you receive the data objects.

zoom('meeting.csv').then(data => {
  const [hosts, participants] = data;

  const plucked = pluck('participant', 'location')(participants);
});

Parsing zoom webinar csv's mismatches fields after network_type.

This is a work in progress...