General Discussions
Wrong header in csv-file

Hi.

I have recently bought a new DT80W-4 and started using the dEX-2 software for programming and downloading logged data.

I have one schedule running where signals from three load-cells and a thermocouple are recorded. The signals from the load cells are in mV and I convert it to kg by multiplying by a fixed factor.

The first columns in the csv-file become Timestamp and TZ as expected. However, all the remaining columns have the same heading namely Mass_1 (kg). The logged data below the headings are clearly from the other load cells and the thermocouple.

The display on the logger shows the correct name. Also when I load the Schedule Tree, the channel names are correct.

What have I missed?

Update: If I download the data as DBD-file and use DPlot to import and plot it, the column headings seems correct. And they remain correct after saving the file to csv-format in DPlot.

I feel this is not a proper way. There must be some error in the logger. But what? Is there anybody who have had similar experience?

Martin

Hi. I have recently bought a new DT80W-4 and started using the dEX-2 software for programming and downloading logged data. I have one schedule running where signals from three load-cells and a thermocouple are recorded. The signals from the load cells are in mV and I convert it to kg by multiplying by a fixed factor. The first columns in the csv-file become Timestamp and TZ as expected. However, all the remaining columns have the same heading namely Mass_1 (kg). The logged data below the headings are clearly from the other load cells and the thermocouple. The display on the logger shows the correct name. Also when I load the Schedule Tree, the channel names are correct. What have I missed? Update: If I download the data as DBD-file and use DPlot to import and plot it, the column headings seems correct. And they remain correct after saving the file to csv-format in DPlot. I feel this is not a proper way. There must be some error in the logger. But what? Is there anybody who have had similar experience? Martin
edited Feb 16 '21 at 3:04 pm

Hi Martin,

I am not 100% sure with your case, did you try to download multiple schedules into a single file? If yes, perhaps you can read this explanation.

When you download the logger data, the default setting will put all schedule data into one CSV file. Normally each schedule will have their own separate interval thus must be downloaded separately.

When you download in one file, you will see header from all schedules but the data itself will appear according schedule sequence from A to K.

Example:
In this example I took 3 data from each schedule.

"Timestamp","TZ","PPA (L/sec)","CalcPPA (L/sec)","CalcPPA_10 (L/sec)","PPFlume AV (m)","PPO AV (l/min)","PPA AV (L/sec)","PPF AV (L/sec)","Dam AV (L/sec)","PPFlume AV_10min (m)","PPO AV_10min (l/min)","PPA AV_10 (l/min)","PPF AV_10 (l/min)","Dam AV_10 (l/min)","PPF (L/sec)","CalcPPF (L/sec)","CalcPPF_10 (L/sec)","Dam (L/sec)","CalcDam (L/sec)","CalcDam_10 (L/sec)"
2017/02/01 00:00:00.227,n,0.033284,1.940745,0.261686
2017/02/01 00:01:00.213,n,0.033198,0.033198,0.033198
2017/02/01 00:02:00.211,n,0.033548,0.066747,0.066747
2017/02/01 00:00:00.328,n,,,,4.231599e-06,-14.098826,0.032346,-0.010709,-2.242818
2017/02/01 01:00:00.322,n,,,,3.527436e-06,-24.004148,0.033442,-0.010808,-2.242484
2017/02/01 02:00:00.318,n,,,,0.000458,-25.782008,0.033862,-0.011886,-2.24211
2017/02/01 00:00:00.358,n,,,,,,,,,0,-12.840708,0.026169,-0.010899,-2.242524
2017/02/01 00:10:00.313,n,,,,,,,,,0,-18.331896,0.033215,-0.011075,-2.242637
2017/02/01 00:20:00.313,n,,,,,,,,,4.423658e-06,-20.184588,0.032996,-0.011197,-2.242926
2017/02/01 00:00:00.401,n,,,,,,,,,,,,,,-0.010968,-0.010968,-0.010968
2017/02/01 00:01:00.316,n,,,,,,,,,,,,,,-0.011233,-0.022201,-0.022201
2017/02/01 00:02:00.315,n,,,,,,,,,,,,,,-0.011059,-0.03326,-0.03326
2017/02/01 00:00:00.530,n,,,,,,,,,,,,,,,,,-2.242648,-2.242648,-2.242648
2017/02/01 00:01:00.424,n,,,,,,,,,,,,,,,,,-2.242648,-4.485296,-4.485296
2017/02/01 00:02:00.426,n,,,,,,,,,,,,,,,,,-2.242554,-6.72785,-6.72785

But if my assumption was not correct can you send me some data sample?

Best regards,
Rudy Gunawan

Hi Martin, I am not 100% sure with your case, did you try to download multiple schedules into a single file? If yes, perhaps you can read this explanation. When you download the logger data, the default setting will put all schedule data into one CSV file. Normally each schedule will have their own separate interval thus must be downloaded separately. When you download in one file, you will see header from all schedules but the data itself will appear according schedule sequence from A to K. Example: In this example I took 3 data from each schedule. ```` "Timestamp","TZ","PPA (L/sec)","CalcPPA (L/sec)","CalcPPA_10 (L/sec)","PPFlume AV (m)","PPO AV (l/min)","PPA AV (L/sec)","PPF AV (L/sec)","Dam AV (L/sec)","PPFlume AV_10min (m)","PPO AV_10min (l/min)","PPA AV_10 (l/min)","PPF AV_10 (l/min)","Dam AV_10 (l/min)","PPF (L/sec)","CalcPPF (L/sec)","CalcPPF_10 (L/sec)","Dam (L/sec)","CalcDam (L/sec)","CalcDam_10 (L/sec)" 2017/02/01 00:00:00.227,n,0.033284,1.940745,0.261686 2017/02/01 00:01:00.213,n,0.033198,0.033198,0.033198 2017/02/01 00:02:00.211,n,0.033548,0.066747,0.066747 2017/02/01 00:00:00.328,n,,,,4.231599e-06,-14.098826,0.032346,-0.010709,-2.242818 2017/02/01 01:00:00.322,n,,,,3.527436e-06,-24.004148,0.033442,-0.010808,-2.242484 2017/02/01 02:00:00.318,n,,,,0.000458,-25.782008,0.033862,-0.011886,-2.24211 2017/02/01 00:00:00.358,n,,,,,,,,,0,-12.840708,0.026169,-0.010899,-2.242524 2017/02/01 00:10:00.313,n,,,,,,,,,0,-18.331896,0.033215,-0.011075,-2.242637 2017/02/01 00:20:00.313,n,,,,,,,,,4.423658e-06,-20.184588,0.032996,-0.011197,-2.242926 2017/02/01 00:00:00.401,n,,,,,,,,,,,,,,-0.010968,-0.010968,-0.010968 2017/02/01 00:01:00.316,n,,,,,,,,,,,,,,-0.011233,-0.022201,-0.022201 2017/02/01 00:02:00.315,n,,,,,,,,,,,,,,-0.011059,-0.03326,-0.03326 2017/02/01 00:00:00.530,n,,,,,,,,,,,,,,,,,-2.242648,-2.242648,-2.242648 2017/02/01 00:01:00.424,n,,,,,,,,,,,,,,,,,-2.242648,-4.485296,-4.485296 2017/02/01 00:02:00.426,n,,,,,,,,,,,,,,,,,-2.242554,-6.72785,-6.72785 ```` But if my assumption was not correct can you send me some data sample? Best regards, Rudy Gunawan
edited Feb 22 '21 at 4:51 am

Hi Rudy.

Thank you for the reply.

The data is generated from a single schedule.

I think the problem is in that specific Datataker (hardware, or firmware). When I use the same dxc-file in an other DT80-4 logger (mine is a DT80W-4), the headings in the csv-file are correct.

Regards
Martin

Hi Rudy. Thank you for the reply. The data is generated from a single schedule. I think the problem is in that specific Datataker (hardware, or firmware). When I use the same dxc-file in an other DT80-4 logger (mine is a DT80W-4), the headings in the csv-file are correct. Regards Martin

Hi Martin,

The logger setting may affect the appearance of header, can you please try to reset all logger setting to default by sending FACTORYDEFAULTS and try it again?

Best regards,
Rudy Gunawan

Hi Martin, The logger setting may affect the appearance of header, can you please try to reset all logger setting to default by sending FACTORYDEFAULTS and try it again? Best regards, Rudy Gunawan
79
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