search

ebroecker / canmatrix

Converting Can (Controller Area Network) Database Formats .arxml .dbc .dbf .kcd ...
BSD 2-Clause "Simplified" License
933 stars 401 forks source link

Exporting ARXML to XLSX (CanCluster vs. J1939Cluster) #772

Closed ganralf75 closed 6 months ago

ganralf75 commented 9 months ago

Hello,

thanks a lot for providing such a useful tool :-)

I have recognized a problem w/ a arxml file where I wanted to convert it to a more readable Excel document and I wanted to ask if that is in principal not possible or if it is a known/new issue.

I have converted a arxml that is defined as "CanCluster" and conversion looks pretty fine (xlsx document generated). grafik

And then I converted a arxml file that is defined as "J1939Cluster" and conversion succeeded but there was no xlsx document generated. grafik

Do you have an idea why the J1939 arxml does not generate any xlsx file?

thanks a lot in advance!

ebroecker commented 9 months ago

Hi @ganralf75 ,

I never had a J1939-ARXML - so quite possible that nothing works.

Maybe you have some example you could provide?

ganralf75 commented 8 months ago

Hi @ebroecker,

sorry, for late answer :-)

thanks for your feedback! I created an example where a CAN-CLUSTER is defined (Excel generation looks fine) and a J-1939-CLUSTER where Excel generation fails.

best regards, ganralf75

arxml.zip

ganralf75 commented 8 months ago

Hi @ebroecker,

wanted to ask if you already had the chance to analyze the problem? :-)

thanks! ganralf75

ebroecker commented 8 months ago

Hi @ganralf75

sorry - not yet - but not forgotten !

ebroecker commented 8 months ago

Hi @ganralf75,

I did a simple python3 -m canmatrix.cli.convert --arxmlIgnoreClusterInfo J1939ClusterExample.arxml aa.xlsx

which gave me at least this xlsx: aa.xlsx

Maybe this already helps you?

I'll have to dive deeper into it, to create some dedicated support for J1939,...

ganralf75 commented 7 months ago

Hi @ebroecker,

thanks a lot for your feedback. Solution seems to work and xlsx is now created!