csv round off error

[Igni]

I am getting all the values under the channel "calc G level" in the attached csv file as round off value when loaded in Table view in diadem.

Kindly help to solve this issue.

[RussellSenior]

The data under Calc G level is only accurate to 2 decimal points in the actual CSV data. Whatever you created the CSV with rounded it to two decimal points, not Diadem.  

[Igni]

Hello Russell,

The csv file does have the data rounded off to two decimal values but the diadem doesn't show me the Real values at all. All the values under the channel "cal G level" is found to be integer when loaded in diadem. For example if my csv file contain a data with the value 1.56, diadem load this particular data as 1 instead of 1.56.

Hope I am clear in what I am trying to explain.

Regards,

X. Ignatius

[ThomasWH]

Hello,

what is your DIAdem and USI version (see menu: Help | About...)?

Please check the following settings and in addition the min, max values of channel "Calc G Level".
1. The minimum value should be 0 and the maximum value 12.33
2. Please check the VIEW table settings. 
    a) Right mouse klick on the table row "Selected Channels"
    b) Choose "Display..." from context menu
    => Please check if a "numeric format" is set (for example "d" on sheet "Table Columns" or "Table Settings") 

Greetings

[Igni]

Thomas,

My diadem version is 11.1 and I dont know USI version. Help me to find the USI version.

1. Minimum value is 0 but the maximum value is only 12 not 12.33.

2. I have tried setting the display of the particular channel to numeric format with 2 decimal points but it only added two zeros to the value with decimal point.

Regards,

X. Ignatius

[Igni]

Thomas,

My diadem version is 11.1 and I dont know USI version. Help me to find the USI version.

1. Minimum value is 0 but the maximum value is only 12 not 12.33.

2. I have tried setting the display of the particular channel to numeric format with 2 decimal points but it only added two zeros to the value with decimal point.

Regards,

X. Ignatius

[AndreasK · Accepted solution]

The CSV loader tries to guess the datatype of you column. So in your case it looks at the first lines and guesses int.

in newer DIAdem versions this was changed to guess double instead of int.

For DIadem 11.1 dataplugin ight be a solution.

If you have a lot of those files you can use a dataplugin to access them. In them you can switch the channel type to double and it would work out. If I remember right 11.1 already had the dataplugin wizard that makes generating dataplugins easy.

Hope this helps a little

Andreas

[Igni]

Thank you Mr. Andreas, it worked.

Thanks a lot once again.

Regards,

X. Ignatius