ADD DateTime to Historic Upload Data | General | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
ADD DateTime to Historic Upload Data
No permission to create posts
May 31, 2013
8:58 am
Avatar
AFA58
New Member
Members
Forum Posts: 4
Member Since:
May 31, 2013
sp_UserOfflineSmall Offline

Hi,

Can you add a parameter when uploading historic data, so that when you upload eg. a csv file you can give the samples their correct moment in time?
Something like field1=2,34 stamp=2013-02-17T12:06:03Z

And it would be nice that the value is ignored when there is a sample at that moment already. (So no error situation)

June 15, 2013
4:52 am
Avatar
AFA58
New Member
Members
Forum Posts: 4
Member Since:
May 31, 2013
sp_UserOfflineSmall Offline

Historic data can be added by the .csv file upload.
There you can add a datetime and values in for all fields.
Mind you, ALL fields, so updating only one field is not possible.

When you do upload, the new data is just added. So that means that when you upload the csv file 3 times, you have 3 times the amount of data points: for every timestamp 3.

Sounds logical but is not really.
What I would like is an option to correct data of specific fields at a specific datetime stamp
- An option to overwrite datafields when one is present for that field at that datetime stamp. (Measured up to the second)
- When you can set that option at the field level, you have also made it possible to correct only one field. For a given timestamp, make one field overwrite: The field to correct, and the rest not overwrite: stay as they are. (And there is not another value added)

For example:
2013-06-15 08:03:00,4,5,4
Updates three fields, removes old values at that date time stamp

2013-06-15 08:03:00,#,5,#
Updates only Field2, Field1 and Field3 remain as they are (# is the code for that)

Also an option to delete single field values at a given datetime stamp would be nice
Example:
2013-06-15 08:03:00,#,@,#
Removes the value for Field2 at that DateTime stamo (the @ code) and leaves the rest unchanged (The # code)

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
36 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

JerilynDernnida, JaketripDernnida, KenterDernnida, AlisaMiz, AriurinDernnida, KabinaDernnida

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457