Problem with displaying mixed datatype in DIAdem

[MimiKLM]

Hi,

I have a problem with displaying the data came from csv file.

My system produces the data in the form like below:

Timestamp,BlockID,AlertID,Block Name,Block State,Description,Trigger
556,0x4056,0x95,BlkSrvL2Alerts,OK,MOTOR_CURRENT_SENSOR1_FAULT,Unknown
560,0x4056,0x94,BlkSrvL2Alerts,STOP_UNDF,MOTOR_CURRENT_SENSOR2_FAULT,Unknown

etc.

So: denary number, hex number, hex number, string, string, string, string

So far only one parameter which is displaying is denary number, the legend of  the rest parameters is gray-out on the chart.

Is it possible to display the data from my csv files? How to do this?

[DanC12]

Hi MimiKLM,

I can't find a way to does this directly, I think the way around this would be to use the script to read the the channels and convert to a different format.  The steps i would do are:

• Import the CSV into the data portal
• in the Script view, import a hex channel from the data portal,
• convert all the hex data to decimal
• create a new channel and add the converted channel to it. 
• Then you can use that converted data on a chart. 

There maybe be a plugin that does that already, but I havent looked.  For the strings, I don't know. What information do you have in the strings?

For creating the script, these links should help: 

• Extracting data from channels https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000kFijSAE&l=en-GB
• create channel https://zone.ni.com/reference/en-XX/help/370858P-01/inavidata/methods/diacmpnt_method_add_idiademcha...
• Insert data into channels: https://zone.ni.com/reference/en-XX/help/370858P-01/dlgview/dlgview/view_generate_dialog/  or https://zone.ni.com/reference/en-XX/help/370858P-01/comoff/chnlingen/
• convert from hex: (2nd post gives an example): https://forums.ni.com/t5/DIAdem/convert-hex-text-to-number/td-p/169516 and https://zone.ni.com/reference/en-XX/help/370858P-01/vbs/methods/vbs_method_clng_globalobj/

[MimiKLM]

Fault statuses & fault sources

[Brad_Turpin]

Hi All,

If this file with the status values and the hex codes is actually a CAN log file, then you should use the Bus Log Converter in DIAdem to turn it into a TDM/TDX file of scaled and datetime-stamped channels, with each group containing all the data from one message.

Brad Turpin

Principal Technical Support Engineer

National Instruments