...
- The column headings in the first line of the data file must exactly match the concept id and the property id of the concept with which the data is associated (though order may vary).
- Each row must have exactly the same number of elements as the number of properties on the concept (even if the value is empty).
- Each value for the concept's id field (here, the country code) must be unique and non-empty (an empty field is one with zero or only whitespace characters).
- Values for properties that reference other concepts must either be empty or be a valid value of the referenced concept.
- Values that contain the comma character must be quoted.Quotation marks that appear in values must be escaped (i.e., preceded by )represented without comma; for example 23,400 must be represented as 23400.
Relevant Files
Two scripts have to be run for generating the data file in the format required by the google data explorer. First script is generate-metric-files-for-explorer.pl . This script takes metric values from prmout folder and transposes the data such that years are now incremented vertically and not horizontally. The files generated by generate-metric-files-for-explorer.pl are then given as an input to the script generate-alldata-for-pinger-data-explorer.pl, which outputs the data for all the metrics altogether in one file named file.csv. This file is in the format as required by the google data explorer.
...