Legacy Hardware and Apps
Data output format

Hi,

I am using the datataker to record 10 schedules. I notice the default data output is not very user friendly to bring into excel. The data is of the format:

2011/05/06 16:16:14 0.027099    1L    -198.3888 ppm 
2011/05/06 16:16:14 0.027099    2L    -11.53183    ppm 
2011/05/06 16:16:14 0.027099    3L    -204.0634 ppm 
2011/05/06 16:16:14 0.290405    1L    -199.2348    ppm 
2011/05/06 16:16:14 0.290405    2L    -9.45050 ppm 
2011/05/06 16:16:14 0.290405    3L    -204.3279    ppm

Is there a way to change the data output to something more user friendly i.e.

Time Stamp1 1L -198.3888 2L -11.531 3L -204.3279 
Time Stamp2 1L -199.2348 2L -9.45 3L -204.3279

It is just really difficult to get a trend graph in excel with the default output. Sort of need a macro otherwise. Also, does anyone have issues with the time stamp being separated, I'm looking to determine the time step between readings which is hard given the space between the time value and remainder of seconds.

Thanks

Hi, I am using the datataker to record 10 schedules. I notice the default data output is not very user friendly to bring into excel. The data is of the format: ```` 2011/05/06 16:16:14 0.027099 1L -198.3888 ppm 2011/05/06 16:16:14 0.027099 2L -11.53183 ppm 2011/05/06 16:16:14 0.027099 3L -204.0634 ppm 2011/05/06 16:16:14 0.290405 1L -199.2348 ppm 2011/05/06 16:16:14 0.290405 2L -9.45050 ppm 2011/05/06 16:16:14 0.290405 3L -204.3279 ppm ```` Is there a way to change the data output to something more user friendly i.e. ```` Time Stamp1 1L -198.3888 2L -11.531 3L -204.3279 Time Stamp2 1L -199.2348 2L -9.45 3L -204.3279 ```` It is just really difficult to get a trend graph in excel with the default output. Sort of need a macro otherwise. Also, does anyone have issues with the time stamp being separated, I'm looking to determine the time step between readings which is hard given the space between the time value and remainder of seconds. Thanks

Good morning jlaird,

Add this to your code, set these switches off

/h
/R
/n
/c
/u

And set these parameters to.

P22=44
P24=13
P33=0

Cheers.
Roger

Good morning jlaird, Add this to your code, set these switches off ```` /h /R /n /c /u ```` And set these parameters to. ```` P22=44 P24=13 P33=0 ```` Cheers. Roger

Thanks for the reply Roger. I presume that is the code for DeTransfer? Is there a similar method for use with Delogger?

Cheers

Thanks for the reply Roger. I presume that is the code for DeTransfer? Is there a similar method for use with Delogger? Cheers

Good morning jlaird,

You can't change the data format if you are using DeLogger. As DeLogger is a computer program if the data isn't in exactly the right format then it can't read the data.

That's why it uses fixed format mode. In fixed format mode the data is assured to be in exactly the same format every time.

Cheers,
Roger

Good morning jlaird, You can't change the data format if you are using DeLogger. As DeLogger is a computer program if the data isn't in exactly the right format then it can't read the data. That's why it uses fixed format mode. In fixed format mode the data is assured to be in exactly the same format every time. Cheers, Roger
33
3
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft