WTH no KNX ets project import yet?

Archive Month of "What the heck?!" 2022
1

It would be really nice if we could import semantic data and group adresses via a ets project import. Or integration with KNX 3rd party API.

It’s such a pain to manually integrate all group adresses :confounded:

2

It’s actually being worked on :wink: any help appreciated

1 Like
3

o nice, I wasn’t aware of that. Thanks.

How can I help? I have no experience with developing such integration.

4

Hm… I don’t know :person_shrugging: :rofl:

1 Like
5

I would love to have this option from within HA, but until this dream come true, you have to do it some sort of manually, but SURELY not typing everything. Below how I did it:

It is not the easiest way, but you can use Excel with Power Query to generate all entities for Home Assistant.

Export CSV from ETS, Open it with Excel and use Power Query to generate as you wish. You might need to have some systematic naming conventions in KNX though.

Once the final column is generated, just select the column and paste in HA VB Code. check the file. You can have proper code formats and separators as well

00 Index
00 Index651×753 73.7 KB

01 Covers
01 Covers562×798 68 KB

02 Temp Sensor
02 Temp Sensor474×771 62.6 KB

5 Likes
6

@RASBR would you be able to detail this approach more?

7

Hi @imaginator,
I can’t list all the steps required, but below are the summarized headlines:

You can download my files from here to check the Power Query steps.
One .rar file containing the following files:

  1. 001 All GAs from KNX ETS.csv
    Exported from ETS5

  2. KNX ETS to HA.xlsx
    Imports the .csv file and performs data processing via Excel Power Query

    NOTE: Give the .xlsm some time to load and refresh as it has many queries.

IMPORTANT: All this process relies on having your GAs named in a systematic way to be able to use keywords in filtering and formatting.

STEPS

  1. Export KNX Group Addresses from ETS to a TAB separated CSV file like ’
  2. Open Excel → Data → From Text/CSV → Choose file → Load
  3. Data → Show Queries: will display the import query in the right panel
  4. Right-click the query → Edit

From there you can start filtering, cleansing, and reformatting your data to get a clean result that you make it the base from where you generate your HA code

Useful Excel Pages & Channels:

I hope you and others find this useful.
Rami

3 Likes
8

thanks @RASBR! Will try out this evening.

9

Hi,
is there any information when the feature with the automatic import of Group Adresses will be available?
On Github I didn’t found anything.

Thanks.

10

No, there are no ETAs or promises.

Have a look here for the idea-gathering process XKNX/knx-frontend · Discussions · GitHub