Support Forums
Format data in .CSV file

Dear Admin,

When i worked with data reported from dex in .csv. In the code, i config the channel variable, example with 10CV(FF3) but it only display with three digits after decimal point, in .csv still saved not format follow FF3, normally 6 digits. Please give me the solution for this.

Thank you so much.

Dear Admin, When i worked with data reported from dex in .csv. In the code, i config the channel variable, example with 10CV(FF3) but it only display with three digits after decimal point, in .csv still saved not format follow FF3, normally 6 digits. Please give me the solution for this. Thank you so much.

Hi Famiras,

FF3 option will alter decimal points on dataTaker display or as a return value to host PC.
It won't alter decimal format in database.

If you need to alter decimal points in database you have to use modulo.
Example:
1V(=1CV,W)
2CV("Data~V")=1CV-(1CV%0.001)

1CV%001 will give you the reminder after dividing the number with 0.001 or in other word the fourth (and more) decimal digit.

Best regards,
Rudy Gunawan

Hi Famiras, FF3 option will alter decimal points on dataTaker display or as a return value to host PC. It won't alter decimal format in database. If you need to alter decimal points in database you have to use modulo. Example: 1V(=1CV,W) 2CV("Data~V")=1CV-(1CV%0.001) 1CV%001 will give you the reminder after dividing the number with 0.001 or in other word the fourth (and more) decimal digit. Best regards, Rudy Gunawan

Dear Rudy Gunawan,

Thanks so much for support. Tip is very excellent.
By the way, i would like you guide me to config the history list mimic can show the history 30 minutes/row. In the config i only see the space for filling is "seconds", i set up to 1800 but not OK. only keep 1 row when i waiting after 3 hours. Because the operator want to see history in 1 day but don't need to report. i try but other mimic not show value on top if i don't move the cursor to it.
Thanks you for your solution.

Best regards,
Famiras.

Dear Rudy Gunawan, Thanks so much for support. Tip is very excellent. By the way, i would like you guide me to config the history list mimic can show the history 30 minutes/row. In the config i only see the space for filling is "seconds", i set up to 1800 but not OK. only keep 1 row when i waiting after 3 hours. Because the operator want to see history in 1 day but don't need to report. i try but other mimic not show value on top if i don't move the cursor to it. Thanks you for your solution. Best regards, Famiras.

Hi Famiras,

We do have history mimic issue and prepare some fix in the next release.
Please wait the next firmware release.

Best regards,
Rudy Gunawan

Hi Famiras, We do have history mimic issue and prepare some fix in the next release. Please wait the next firmware release. Best regards, Rudy Gunawan
13
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