Hello, I require help. I want to graph, in DAQFactory, existing data that DAQF collected in the past, logged as a CSV file. I want to load the data into the two (2) data channel tables named "mV" and "PV" with the corresponding DateTime stamp. This DT-Stamp was recorded "in XL format", i.g., "44693.39602" (General Fmt in Excel viewed CSV) or if saved as an XL file can be represented in a custom format as "5/12/2022 9:30:16 AM" (=TEXT(44693.3960185185, "m/d/yyyy h:mm:ss.000")). The timing is asynchronous, so I want to move the exact DateTime stamp to each channel table and each trend value.
I have reviewed the use of:
Var.FileHandle = File.Open("C:\MyBriefcase\Desktop\Boeing Data\FVSMdata_05007_220512_0932.csv",1,0,0,1)
Var.strIn = File.ReadDelim(FileHandle,-1,",",Chr(10),0,1)
//Looping code "For(Var.x = NoRsNoH, x>0, x--) ... Endfor" - Skip header when loading channel tables, load Channel Tables backwards for DAQFactory (FILO) as the 0th element is the most recent, NoRsNoH = Number of CSV Rows No Header included
File.Close(FileHandle)
-----------------------------------------------
strln = {{"TheTime","mV","PV"},{44693.39601,5377808,0}, ... {44693.40212,1450.296,1432.906}}
where this can be represented by
{Var.strIn[0][0,2], Var.strIn[1][0,2], ... Var.strIn[NoRsNoH-1][0,2]}
I can fill the "mV" and "PV" tables with the inverted list of values but I am stuck with the current DateTime Stamping when I want the exact historic stamps.
The User Guide suggests using the function "InsertTime(Value, Start, Increment)" but it is unclear how to use this with "MyChannel(mV/PV).AddValue(Value=Var.strIn[x][1/2]) and convert the XL time stamp back to DAQFactory format ( formatDateTIme("%Y%m%d%H%M%S.xxx", timeStamp)?)
Also, how do you get the channel tables to graph? When I load the values to the undesirable "current time," my graphs don't materialize on the 2D Graph Component like when the data is added to the mV/PV channels via Modbus using a communications module.
Thank you.