How to use the Mapping Values ?

[soo]

Operating system used: Windows

I want to install this feature and use it, but the linked video didn't give me a proper python file.

In another response, an Archicad official said that there will be a way to use it without installing the Python file soon, but I'm wondering when that is and when it will be able to use this feature perfectly.

linked video : 

https://graphisoft.sharefile.com/share/view/s852df7d2f10f47708082f329e3cc32d8

[Barry Kelly]

My understanding is there is a python tool in the Library Developer Kit.

But where do we find the LDK for 28?

Barry.

[Barry Kelly]

Found it.

https://archicadapi.graphisoft.com/downloads/library-developer-kit

You have to sign in with your Graphisoft ID.

But now I have downloaded and opened it, I still have no idea what Python file was being run in that video.

Barry.

[Barry Kelly]

@Magdolna Marosvari 

Are you able to shed any light on the tool that is being run to convert the mapping table JSON file into the Excel spreadsheet?

And where to find it?

At 2.00 in the video.

Barry.

[Barry Kelly]

@soo 

Did you set my post as a solution or was it one of the other moderators?

If it was you, did you figure out what python script was run to convert the JSON file into a CSV file?

If not then I will un-mark this as a solution.

Barry.

[Lingwisyer]

Did anyone figure out how to get it into Excel? Or any better way of editting that find and select in notepad...

[Barry Kelly]

I just googled "can excel edit a jason file".

There is a resulting AI instruction and a video link of how to do it.

I managed to open a file then imported the data to Excel for editing.

But have not yet figured out how to export it back to a JSON file.

Barry.

[Lingwisyer]

I have figured out how to get is all into Excel using the Power Query Editor. Converted it to a table without delimiters. Expanded the features, then split first column that contains the parameter address using "/" as a delimiter. Now to see if there is a way to get it back into JSON...

Ling.

[Barry Kelly]

 

Once you have the date in power query, you need to 'close & load' the data into excel.

Where you can now edit it.

But you can't save back as a JSON file.

You must convert it as highlighted in step 4 above.

I haven't tried this yet.

Barry.

[Lingwisyer]

Hm. Might look into the VBA option, though from memory, that requires security permissions on the user side.