We have an auto-incrementing reference attribute defined as:
# RFC
Format RFC = 0,narrowattribname,narrowattribvalue,60,60
Preset RFC = RFC-######
Preset On Duplicate RFC = RFC-######
Tooltip RFC = A unique reference will be generated for this Request For Change
We also have a "Created by/when" attribute. Looking at the values this seems to be set when the user clicks "New" whereas the time stamp that appears on the line after the $@MID@$ seems to be set when the user clicks "Submit".
# Created
Format Created = 0,attribname,attribvalue,70,100
Preset Created = $long_name ($short_name) on $date
Preset On Duplicate Created = $long_name ($short_name) on $date
Every once in a while the incrementing stops working and the number 'sticks' or misses some out. It looks as if it might be because multiple people are adding entries concurrently. Could the occasion where there is a gap in the sequence (171-174) be where people abandoned changes (clicked on "Back") after having numbers allocated? Here is a list showing the discrepancies.
Date Item Time Stamp (from the line after $@MID@$) "Created" attribute time stamp
22/09/08 124 16:15:10 11:58
22/09/08 125 16:33:54 16:24
22/09/08 125 16:35:37 16:33 Should be 126
...
10/10/08 146 10:39:09 10:30 Correct
10/10/08 146 10:46:57 10:35 Should be 147
10/10/08 147 13:04:03 13:02 Should be 148
10/10/08 148 15:11:38 15:00 Should be 149
...
17/11/08 171 10:21 10:17 Correct
17/11/08 174 14:30 13:47 Should be 172
17/11/08 175 16:14 16:04 Should be 173
17/11/08 176 16:49 16:38 Should be 174
...
25/11/08 187 15:49:58 15:47 Correct
25/11/08 187 15:52:39 15:48 Should be 188
25/11/08 188 16:49:56 16:44 Should be 189
25/11/08 188 16:52:40 16:40 Should be 190
25/11/08 188 16:55:17 16:43 Should be 191
Let me know if you need any more information.
regards
Steve
|