summaryrefslogtreecommitdiff
path: root/scripts/metrics
diff options
context:
space:
mode:
authorMnikolenko Productengine <mnikolenko@productengine.com>2021-05-12 15:07:17 +0300
committerMnikolenko Productengine <mnikolenko@productengine.com>2021-05-12 15:07:17 +0300
commitfde4bd2cbc62fef1d3290aa86cbef615ad097bf6 (patch)
treec0cc75305a1d99f93ad9404e63592794f8f1faa5 /scripts/metrics
parent3392d5805e00cdbce1d269ee2da4f0c14b9a03c9 (diff)
SL-15177 Add slp-csv converting script
Diffstat (limited to 'scripts/metrics')
-rw-r--r--scripts/metrics/slp_conv.py55
1 files changed, 55 insertions, 0 deletions
diff --git a/scripts/metrics/slp_conv.py b/scripts/metrics/slp_conv.py
new file mode 100644
index 0000000000..46be2003d7
--- /dev/null
+++ b/scripts/metrics/slp_conv.py
@@ -0,0 +1,55 @@
+#!/usr/bin/python
+"""\
+@file slp_conv.py
+@author Callum Prentice
+@date 2021-01-26
+@brief Convert a Second Life Performance (SLP) file generated
+ by the Viewer into an comma separated value (CSV) file
+ for import into spreadsheets and other data analytics tools.
+
+$LicenseInfo:firstyear=2018&license=internal$
+Copyright (c) 2018, Linden Research, Inc.
+$/LicenseInfo$
+"""
+from llbase import llsd
+import argparse
+
+parser = argparse.ArgumentParser(
+ description="Converts Viewer SLP files into CSV for import into spreadsheets etc."
+)
+parser.add_argument(
+ "infilename",
+ help="Name of SLP file to read",
+)
+parser.add_argument(
+ "outfilename",
+ help="Name of CSV file to create",
+)
+args = parser.parse_args()
+
+with open(args.infilename, "r") as slp_file:
+ slps = slp_file.readlines()
+ print "Reading from %s - %d items" % (args.infilename, len(slps))
+
+ with open(args.outfilename, "w") as csv_file:
+
+ print "Writing to %s" % args.outfilename
+
+ for index, each_slp in enumerate(slps):
+ slp_entry = llsd.parse(each_slp)
+
+ first_key = slp_entry.keys()[0]
+
+ # first entry so write column headers
+ if index == 0:
+ line = ""
+ for key, value in slp_entry[first_key].iteritems():
+ line += key
+ line += ", "
+ csv_file.write("entry, %s, \n" % line)
+ # write line of data
+ line = ""
+ for key, value in slp_entry[first_key].iteritems():
+ line += str(value)
+ line += ", "
+ csv_file.write("%s, %s, \n" % (first_key, str(line)))