Modbus profile generator

[Daniel]

If somebody struggle to play directly with json file here is Excel file where you can just fill it in and generate the profile.

  Modbus-Profile-Generator.xlsm (Size: 78.84 KB / Downloads: 699)

The json file will be created in the same folder where the Profile generator is and it will have the same name, you can change the name as you want.
Make sure to enable Macros in Excel!
For custom values just create new sheet and create a table for enumeration, Put the sheet name in the value_custom cell.
If you need additional parameters just rename spare column name to needed parameter name and start filling it in. 
Modbus documentation is here https://openrb.com/docs/modbus.htm

[tomnord]

If somebody struggle to play directly with json file here is Excel file where you can just fill it in and generate the profile.



The json file will be created in the same folder where the Profile generator is and it will have the same name, you can change the name as you want.
Make sure to enable Macros in Excel!
For custom values just create new sheet and create a table for enumeration, Put the sheet name in the value_custom cell.
If you need additional parameters just rename spare column name to needed parameter name and start filling it in. 
Modbus documentation is here https://openrb.com/docs/modbus.htm

Thank you Daniel. Great work.

Sent fra min SM-G980F via Tapatalk

[JRP]

Thank you very much Daniel extremely useful tool. It would not be too much for something similar to be included in LM.
a greeting

[Trond Hoyem]

If somebody struggle to play directly with json file here is Excel file where you can just fill it in and generate the profile.



The json file will be created in the same folder where the Profile generator is and it will have the same name, you can change the name as you want.
Make sure to enable Macros in Excel!
For custom values just create new sheet and create a table for enumeration, Put the sheet name in the value_custom cell.
If you need additional parameters just rename spare column name to needed parameter name and start filling it in. 
Modbus documentation is here https://openrb.com/docs/modbus.htm

Hi Daniel

Great tool!
I have one problem though. I have added addresses for a device where there are several custom values. I have added one sheet for each table of enumeration and entered the sheet name in the cell of respective address.

When I run the macro I get an error in the subfunction, saying the subscript is out of range and highlighting the line number 3 in the below code.

Any good idea of what I do wrong?

Code:

Function customValues2Dict(WorksheetName As String)
    Dim jsonCustomValues As New Dictionary
    Worksheets(WorksheetName).Activate
    NumRows = Range("A1", Range("A1").End(xlDown)).Rows.Count
    For Row = 1 To NumRows
        jsonCustomValues(Cells(Row, 1)) = Cells(Row, 2)
    Next Row
    Set customValues2Dict = jsonCustomValues
End Function

[Daniel]

I would guess you made a typo in the name of enum sheet.

[Trond Hoyem]

I would guess you made a typo in the name of enum sheet.

Yes, that was my first guess too, so I copied the name of the sheet into the cell, but no luck. I then removed all values from the value_custom column, and still same error.

---

I would guess you made a typo in the name of enum sheet.

Yes, that was my first guess too, so I copied the name of the sheet into the cell, but no luck. I then removed all values from the value_custom column, and still same error.

OK, figured it out. I did not realize that I needed to set the value_custom to 'null' if there is no custom values. I had removed the original lines from the sheet and started to add my own, and then this was just empty cells...

[JRP]

Hello
First of all great tool, it makes the job of making a profile much easier.
The question is that I have noticed that the generated JSON file contains one less record than indicated in the mapping sheet.
In the example itself there is the Output 10 line and in the generated JSOn file it does not appear, it stays in Output 9.
a greeting

[Daniel]

In did, I updated the generator in the original post.

[JRP]

Thanks it works perfectly.
a greeting

[gdimaria]

Hi, I get an error when I try to generate the profle.
I use MS Office 385 on two different PC anche strange thing is it work perfectly on one and even in the other PC I get errors.

Can you see what happens?

Thank in advance

Peppe

[Daniel]

I'm using office 365 not 385   and it just worked for me. Did you enable the content when it asked. Your profile attached. Didn't change anything.

[gdimaria]

Pardon, 365
I do the same things in both PC with the same Office version.

That's very strange... could be a Pc Security policy or another installed software causing it?

[Daniel]

The only thing what I can think of is this.
   

[gdimaria]

The only thing what I can think of is this.

mmm.. no. Because the macro goes on until it stops on a certain line, as you can see in the picture...

I 'll investigate, I will let you know 

[admin]

I think it has something to do with the xlsm file path. Try putting it into a different folder.

[gdimaria]

I think it has something to do with the xlsm file path. Try putting it into a different folder.

Already done. Tried in diffent folders, ieven in desktop...

[gdimaria]

I found the cause of the problem... but not the solution!

cdir = Application.ActiveWorkbook.Path

But Application.ActiveWorkbook.Path is not the path you can see on the picture ("https:\\ ... ect.")

The actual path is "C:\user\Peppe\Desktop"

I checked it on the PC in which it works and I found the right path.

That's very strange because it is the same file in the same position (Desktop) on two different PCs.

I also reinstalled Office but nothing changed.

[Daniel]

Hi
Try this one. It should always export to Desktop. Regardless where the file is.

[gdimaria]

Hi
Try this one. It should always export to Desktop. Regardless where the file is.

Perfect! That's what I thought I was doing, but I was uncertain about the syntax to use...

Thank you so much

BR

Peppe

[Ian@GWTi]

Hi,

I would like to have a total of 7 custom_values worksheets to use in the value_custom drop down menu. Can this be done?