|
|
Rank: Advanced Member
Groups: Member
Joined: 1/11/2012
Posts: 45
Location: Belgium
|
okay we are almost up and running,
The buffering works and the data writing works.
I still got a little problem. Here are some lines of my log file:
30-Jan-2012 09:59:10 [PI_UFL] [Info] Write to PI : H037_S001 : time = 29-Jan-2012 02:48:00, value = H037, status = , flags = .
30-Jan-2012 09:59:10 [PI_UFL] [Info] Write to PI : H037_S002 : time = 29-Jan-2012 02:48:00, value = 0, status = , flags = .
30-Jan-2012 09:59:10 [PI_UFL] [Info] Write to PI : H037_S003 : time = 29-Jan-2012 02:48:00, value = 0, status = , flags = .
...
30-Jan-2012 09:59:14 [PI_UFL] [Info] Write to PI : H037_S001 : time = 29-Jan-2012 02:48:00, value = H037, status = , flags = .
30-Jan-2012 09:59:14 [PI_UFL] [Info] Write to PI : H037_S002 : time = 29-Jan-2012 02:48:00, value = 0, status = , flags = .
30-Jan-2012 09:59:14 [PI_UFL] [Info] Write to PI : H037_S003 : time = 29-Jan-2012 02:48:00, value = 0, status = , flags = .
As you see in the timestamp the seconds are not written right and don't change. It only changes per minute.
What could be the cause of this problem?
Also we have another problem, but are trying to figure it out with our IT department. If it doesn't work out, you will be hearing again from me.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
|
NIce to see you are progressing. First you need to check if your source (COM) is supplying the data in dd-mmm-yyyy hh:mm:ss format, if the source is indeed supplying this format then it is probably a setting in your ini file.
FIELD(x).NAME ="Timestamp"
FIELD(x).TYPE ="DateTime"
FIELD(x).FORMAT ="dd-MMM-yyyy hh:mm:ss"
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/11/2012
Posts: 45
Location: Belgium
|
Yes I checked my ini file already and the part about the date/time says the following:
FIELD(9).NAME="FIELD_9"
FIELD(9).TYPE="DateTime"
FIELD(9).FORMAT="yy-MM-dd"
FIELD(10).NAME="FIELD_10"
FIELD(10).TYPE="Time"
FIELD(10).FORMAT="hhmmss"
The data in data log file for the date/time part is the following (this is copied from the data log file, so I know that my serial ports are already working fine and sending the data correctly):
...,12-01-29,2:48:25,...
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
|
Try changing FIELD(10).FORMAT="hhmmss". Since the date and time are two "fields", how are you combining them to give you a time stamp.
FIELD(10).FORMAT="hh:mm:ss"
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/11/2012
Posts: 45
Location: Belgium
|
My ini file says:
FIELD(9).NAME="FIELD_9"
FIELD(9).TYPE="DateTime"
FIELD(9).FORMAT="yy-MM-dd"
FIELD(10).NAME="FIELD_10"
FIELD(10).TYPE="Time"
FIELD(10).FORMAT="hhmmss"
...
FIELD_9=FIELD_9+FIELD_10
...
if (FIELD_1 == "NaN") then StoreInPI(FIELD_1&"_S001",,FIELD_9,,-242,) else StoreInPI(FIELD_1&"_S001",,FIELD_9,FIELD_1,,) endif
if (FIELD_2 == "NaN") then StoreInPI(FIELD_1&"_S002",,FIELD_9,,-242,) else StoreInPI(FIELD_1&"_S002",,FIELD_9,FIELD_2,,) endif
if (FIELD_3 == "NaN") then StoreInPI(FIELD_1&"_S003",,FIELD_9,,-242,) else StoreInPI(FIELD_1&"_S003",,FIELD_9,FIELD_3,,) endif
...
I have do this in this manner because the data comes in through a standard string in which the time and date are separated with a comma.
I tried several combinations already:
HH:mm:ss
HHmmss
hh:mm:ss
but then I get an invalid time format report in my log file.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
|
This might be a far fetch but can you check your reqional settings on the client and make sure :ss is in your short and long time settings.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/11/2012
Posts: 45
Location: Belgium
|
I tried it, still no seconds appear in my log file.
This is very strange.
Still looking.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/11/2012
Posts: 45
Location: Belgium
|
Very strange.
I did the following in my ini file:
FIELD(9).NAME="FIELD_9"
FIELD(9).TYPE="DateTime"
FIELD(9).FORMAT="yy-MM-dd"
FIELD(10).NAME="FIELD_10"
FIELD(10).TYPE="Time"
FIELD(10).FORMAT="h:mm:ss"
The data coming through the serial ports is something like:
...,12-01-29,2:48:25,...
but it could also be:
...,12-01-29,23:23:25,...
I tested the ini file for the first one and the last one and I don't get any problems anymore. I was especially affright for the last one but this doesn't give any problems.
If I set the scan frequency at 00:00:05
The following lines appear in my log file:
...
30-Jan-2012 11:38:05 [PI_UFL] [Info] Write to PI : H037_S001 : time = 29-Jan-2012 23:48:40, value = H037, status = , flags = .
30-Jan-2012 11:38:05 [PI_UFL] [Info] Write to PI : H037_S002 : time = 29-Jan-2012 23:48:40, value = 0, status = , flags = .
30-Jan-2012 11:38:05 [PI_UFL] [Info] Write to PI : H037_S003 : time = 29-Jan-2012 23:48:40, value = 0, status = , flags = .
...
30-Jan-2012 11:38:08 [PI_UFL] [Info] Write to PI : H037_S001 : time = 29-Jan-2012 23:48:45, value = H037, status = , flags = .
30-Jan-2012 11:38:08 [PI_UFL] [Info] Write to PI : H037_S002 : time = 29-Jan-2012 23:48:45, value = 0, status = , flags = .
30-Jan-2012 11:38:08 [PI_UFL] [Info] Write to PI : H037_S003 : time = 29-Jan-2012 23:48:45, value = 0, status = , flags = .
...
Still I find this very strange.
Do you know what could be the cause of this, so that we never encounter this problem again.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
|
I've had a similiar problem a couple of years ago with the timestamp issue, mine was with the months and I also had to play around with the timestamps and eventually I had to use Timestamp.Format="dd-MMM-yy hh:mm:ss", _
"Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"
What did you do to solve your problem with the pibufss not connecting?
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/11/2012
Posts: 45
Location: Belgium
|
The problem was caused by the program we used for simulating the com ports.
This didn't send the data through so that the the buffer could receive anything. If the UFL, with or without buffer, isn't receiving anything it will not work (logic).
So the problem wasn't with the UFL, but with the com ports.
It didn't took much time to figure it out that this was the problem, but it took much time to make the simulation program working again.
Now we are busy making sure to have a good serial connection and how to set this up.
We also have some problems with the different networks we use and which computers are allowed on these networks. This causes problems for log in in the UFL and the buffer.
So that is also something we are looking at.
Thanks for the help through all of this.
|
|
|
|
Guest
|
