AnsweredAssumed Answered

Generating test data for a PI Data Archive

Question asked by dkennedy on Apr 11, 2019
Latest reply on Apr 23, 2019 by gregor

Hey guys,

 

I'm using a local OSIPI server to attempt to replicate a client's environment. I'm looking to generate some data to test my AF SDK scripts with. I have a formatted CSV file from the client with representative data attached, but I'm not sure how challenging it would be to convert that back into the data archive. I'd also be happy with generating fake or custom data. Any guidelines for how to do this?

 

I'm viewing my CSV file in excel, here's roughly how its structured

 

Header 1Header 2Header 3Header 4
DescriptionTom's WeightJoe's WeightSarah's Weight
Unit TypekgPoundkg
Name1TomJoe Sarah
Name2BombadilRoganSalazar
1/1/199023190124
2/2/199024187123
3/3/199022225125

 

The kicker here is I don't need all of this detail, the name of the column (Tom's weight) and the numeric values inside of it are enough. Times are uniform for all measurement's so that could be extrapolated. So this could be as easy as copying all of my numeric values to a new spreadsheet and leading them with column information. However, I don't know much about uploading data to a data archive, any advice you have would be awesome!

Outcomes