Hi.
I am trying to import data using piconfig. I formatted the data in excel and saved it as a text file. A single line looks like this:
Tag01,13-Dec-23 00:00:10,-3.461546519
The tag01 had no previous data at that timestamp and is currently existing on my DA as a float32 type.
I found some useful posts in the community and using the PI documentation (https://docs.aveva.com/bundle/pi-server-da-reference/page/1022136.html), I eventually managed to add to the archive using the following code:
* (Ls - ) PIconfig> @tabl piarc * (Ls - PIARC) PIconfig> @mode edit * (Ed - PIARC) PIconfig> @istr tag,time,value * (Ed - PIARC) PIconfig> @input C:\History\TagUpload.txt
The commands ran, however all negative and values below 1 are registering as either 0 or 1,
I ran the same code again and added "Replace" in my text file. I changed the code as follows:
* (Ls - ) PIconfig> @tabl piarc * (Ls - PIARC) PIconfig> @mode edit * (Ed - PIARC) PIconfig> @timf 9 * (Ed - PIARC) PIconfig> @istr tag,time,value,mode * (Ed - PIARC) PIconfig> @input C:\History\TagUpload.txt
I am still not getting the DA to register the negative/float values. The odd thing is that the current value (today's value) in the DA shows float values. Am I missing something in the above code? Would appreciate any insight. Thanks.
