Forum Home › Forums › Communicating with Devices › new csv file reder driver
Tagged: csv reader driver
- This topic has 32 replies, 5 voices, and was last updated 5 months, 3 weeks ago by
quintelosky.
-
AuthorPosts
-
July 2, 2024 at 11:36 am #14853
sperate
ParticipantAlso you can delete the existing file and create a new one. It should work.
Ok, maybe I’ll give it a try
This is possible to make a time difference as a parameter. I’ve made a note in the back log. If you need it in time, we can do that on paid basis.
Not in a hurry but it could be an interesting option anyway. Even an “unlimited time” difference coulb be possible as you already have the position counter and , as far as I understand, the driver only reads data that’s after the position counter. Wich means only new data, regardless of the time.
And about demo mode ? What’s the trick to make the driver read data ?
Many thanks !
-
This reply was modified 1 year, 1 month ago by
sperate.
July 3, 2024 at 10:56 am #14869Mikhail
ModeratorAnd about demo mode ? What’s the trick to make the driver read data ?
It is useful to simulate a device with your data.
July 4, 2024 at 7:08 pm #14888sperate
ParticipantI mean I can’t make it work.
I was asking if there’s something I’m missing to make it work.
I can’t find what is wrong in my .csv file.The same way as for the real time mode, what does the driver expect in order to to consider data valid and update the Tag values ?
You said earlier that for axample for the hour period the full hour data must be filled. Ok, I’ve tried with one minute data but nothing was read nor displayed on the communicator. Is there a specific time “step” to use between recordings ?
Thanks
July 5, 2024 at 10:11 am #14893Mikhail
ModeratorCould you make a screenshot of your CSV for demo mode?
July 8, 2024 at 10:51 am #14913sperate
ParticipantHere’s the content of the csv file
Timestamp,TagTest 2024-07-07 13:00:00,2000 2024-07-07 13:01:00,2000 2024-07-07 13:02:00,2000 2024-07-07 13:03:00,2000 2024-07-07 13:04:00,2000 2024-07-07 13:05:00,2000 2024-07-07 13:06:00,2000 2024-07-07 13:07:00,2000 2024-07-07 13:08:00,2000 2024-07-07 13:09:00,2000 2024-07-07 13:10:00,2000 2024-07-07 13:11:00,2000 2024-07-07 13:12:00,2000 2024-07-07 13:13:00,2000 2024-07-07 13:14:00,2000 2024-07-07 13:15:00,2000 2024-07-07 13:16:00,2000 2024-07-07 13:17:00,2000 2024-07-07 13:18:00,2000 2024-07-07 13:19:00,2000 2024-07-07 13:20:00,2000 2024-07-07 13:21:00,2000 2024-07-07 13:22:00,2000 2024-07-07 13:23:00,2000 2024-07-07 13:24:00,2000 2024-07-07 13:25:00,2000 2024-07-07 13:26:00,2000 2024-07-07 13:27:00,2000 2024-07-07 13:28:00,2000 2024-07-07 13:29:00,2000 2024-07-07 13:30:00,2000 2024-07-07 13:31:00,2000 2024-07-07 13:32:00,2000 2024-07-07 13:33:00,2000 2024-07-07 13:34:00,2000 2024-07-07 13:35:00,2000 2024-07-07 13:36:00,2000 2024-07-07 13:37:00,2000 2024-07-07 13:38:00,2000 2024-07-07 13:39:00,2000 2024-07-07 13:40:00,2000 2024-07-07 13:41:00,2000 2024-07-07 13:42:00,2000 2024-07-07 13:43:00,2000 2024-07-07 13:44:00,2000 2024-07-07 13:45:00,2000 2024-07-07 13:46:00,2000 2024-07-07 13:47:00,2000 2024-07-07 13:48:00,2000 2024-07-07 13:49:00,2000 2024-07-07 13:50:00,2000 2024-07-07 13:51:00,2000 2024-07-07 13:52:00,2000 2024-07-07 13:53:00,2000 2024-07-07 13:54:00,2000 2024-07-07 13:55:00,2000 2024-07-07 13:56:00,2000 2024-07-07 13:57:00,2000 2024-07-07 13:58:00,2000 2024-07-07 13:59:00,2000
Screen captures are here : https://imgur.com/a/nXhc4Dd
Thanks !
July 9, 2024 at 11:43 am #14914Mikhail
ModeratorIf DemoPeriod=OneHour, the 1st timestamp must be 2024-07-07 0:00:00 and the last 2024-07-07 0:59:00
July 9, 2024 at 2:00 pm #14915sperate
ParticipantHello,
I tried with this file but it didn’t work.
Nothing read by the driver except the tag name .Timestamp,Astro 2024-07-09 00:00:00,33 2024-07-09 00:01:00,33 2024-07-09 00:02:00,33 2024-07-09 00:03:00,33 2024-07-09 00:04:00,33 2024-07-09 00:05:00,33 2024-07-09 00:06:00,33 2024-07-09 00:07:00,33 2024-07-09 00:08:00,33 2024-07-09 00:09:00,33 2024-07-09 00:10:00,33 2024-07-09 00:11:00,33 2024-07-09 00:12:00,33 2024-07-09 00:13:00,33 2024-07-09 00:14:00,33 2024-07-09 00:15:00,33 2024-07-09 00:16:00,33 2024-07-09 00:17:00,33 2024-07-09 00:18:00,33 2024-07-09 00:19:00,33 2024-07-09 00:20:00,33 2024-07-09 00:21:00,33 2024-07-09 00:22:00,33 2024-07-09 00:23:00,33 2024-07-09 00:24:00,33 2024-07-09 00:25:00,33 2024-07-09 00:26:00,33 2024-07-09 00:27:00,33 2024-07-09 00:28:00,33 2024-07-09 00:29:00,33 2024-07-09 00:30:00,33 2024-07-09 00:31:00,33 2024-07-09 00:32:00,33 2024-07-09 00:33:00,33 2024-07-09 00:34:00,33 2024-07-09 00:35:00,33 2024-07-09 00:36:00,33 2024-07-09 00:37:00,33 2024-07-09 00:38:00,33 2024-07-09 00:39:00,33 2024-07-09 00:40:00,33 2024-07-09 00:41:00,33 2024-07-09 00:42:00,33 2024-07-09 00:43:00,33 2024-07-09 00:44:00,33 2024-07-09 00:45:00,33 2024-07-09 00:46:00,33 2024-07-09 00:47:00,33 2024-07-09 00:48:00,33 2024-07-09 00:49:00,33 2024-07-09 00:50:00,33 2024-07-09 00:51:00,33 2024-07-09 00:52:00,33 2024-07-09 00:53:00,33 2024-07-09 00:54:00,33 2024-07-09 00:55:00,33 2024-07-09 00:56:00,33 2024-07-09 00:57:00,33 2024-07-09 00:58:00,33 2024-07-09 00:59:00,33
July 10, 2024 at 9:26 am #14916Mikhail
Moderator1. Set FileName=Astro2.csv
2. Locate the file in SCADA\ScadaComm\Storage
3. Set date to 2001-01-01 instead of 2024-07-09July 15, 2024 at 7:38 am #14926sperate
ParticipantHi Mikhail,
It’s working with the date set to 2001.1.1.
No need to change the file location (Tag name was already read).
Just the driver didn’t like the timestamps.That’s what is reading now :
[4] Ephemerides Soleil 2 ------------------------ Driver : DrvCsvReader 6.0.0.0 Status : Normal Session time : 15/07/2024 09:34:10 Command time : Undefined Sessions (total / errors) : 4 / 0 Commands (total / errors) : 0 / 0 Requests (total / errors) : 4 / 0 Current Data +---+-----------+-----------+---------------------+---------+ | # | Code | Name | Value | Channel | +---+-----------+-----------+---------------------+---------+ | *********************** Main Data *********************** | +---+-----------+-----------+---------------------+---------+ | 1 | Tag1 | Astro | 60.000 | | +---+-----------+-----------+---------------------+---------+ | ******************** Reading Status ********************* | +---+-----------+-----------+---------------------+---------+ | 2 | Timestamp | Timestamp | 1/1/2001 1:35:00 AM | | +---+-----------+-----------+---------------------+---------+ | 3 | Position | Position | 1,024 | | +---+-----------+-----------+---------------------+---------+
I clearly don’t understant what’s the trick with the timestamps because the hours doesn’t correspond to anything (minutes arse sync. though) but it’s working right now, so i’m happy with that 🙂
July 15, 2024 at 10:04 am #14934Mikhail
ModeratorHi,
I checked, 2001-01-01 is a starting point in demo mode, specified in the source code.
July 17, 2024 at 4:22 pm #14978sperate
ParticipantI checked, 2001-01-01 is a starting point in demo mode, specified in the source code.
Ok, thanks !
November 5, 2024 at 2:20 pm #15585ScJib
ParticipantHello,
Apologies for jumping on an old thread but is there a possibility of having this functionality to ‘ignore timestamp’..?
“Not in a hurry but it could be an interesting option anyway. Even an “unlimited time” difference coulb be possible as you already have the position counter and , as far as I understand, the driver only reads data that’s after the position counter. Wich means only new data, regardless of the time.”
Thanks
November 6, 2024 at 11:48 am #15586Mikhail
ModeratorHello,
That issue has been added to the backlog. If it is needed by a certain time, we could implement it for some fee. Otherwise, we will do it ourselves, but it is not known by what date.
February 20, 2025 at 10:55 am #16179quintelosky
ParticipantHi
I don’t know the problem:
https://ibb.co/qFdQXGYzFebruary 20, 2025 at 12:59 pm #16183quintelosky
ParticipantOk, solved, in real time you need add a new line in your .csv
Now I’m testing demo mode but nothing
-
This reply was modified 1 year, 1 month ago by
-
AuthorPosts
- You must be logged in to reply to this topic.