Configuring Lithernet Gateway

Converting the CSV file.

At Adquio, we always try to make the work of our partners easier. In this case, we have created a special program that allows you to automatically convert the file downloaded from Yabe to a format directly compatible with Adquio.

You can download this program from here:

https://adquio.com/wp-content/uploads/2023/09/Lithernetcsv2json.zip

This program is currently available for Windows ©, and will soon be available for Mac © and GNU/Linux as well.

You will see that it is a compressed file, when you decompress it you will get an executable, you can put it directly on your desktop.

On Windows, executable programs downloaded from the Internet are always suspected of containing viruses, in this case we have downloaded it from a trusted website https://adquio.com 🙂, so we can open it without problems. To do this, you must double-click on it, and you will get the following notice:

Converting the CSV file.
Converting the CSV file.

We will click on more information and…

We press the ‘Run anyway’ button, and finally we have our program ready to run.

Converting the CSV file.
Converting the CSV file.

The first thing will be to import the file from the previous step. To do this, press the button we indicated and select it.

Next, the program will load the file and automatically tell you what your output file will be. It will create a name with the current date and time so that they never conflict with others already created on your drive. It will leave it in the same folder as the source file with the name ‘conversion’, and then the current date and time.

Converting the CSV file.
Converting the CSV file.

At the moment, the program has not done anything, first we must select and indicate what we need for our specific case, let’s start:

Remember that we are generating a file so that Adquio can automatically read all the Lithernet values, therefore, all the data that we are going to indicate will be used to access the Current device:

  • IP address: It is the address of your Lithernet device. If you have left it at the default address you will see it as in the image, if not, you must go to the second chapter of this document where we set it.
  • Port: It is always BAC0, it will be loaded by default.
  • Instance: This value depends on what Adquio model you have, and how you have connected the Lithernet device, the possible values ​​are:
  • Bacnet_ip_wan: It is the correct option for Adquio Mini, Adquio Micro Server and Adquio Server. In Adquio Lite and Pro, it is valid if the controller can reach the Lithernet device through its WAN port, that is, if it is on the customer network and not on the internal network.
  • Bacnet_ip: Valid for cases in which you have an Adquio Lite or Pro, and you have connected your Lithernet to its LAN ports.
  • Code: By default, it suggests ‘LITHERNET’. It is the device name that you are going to use within Adquio as a code. If you have more than one you must put different codes here to be able to identify them, in our case we will leave it like this, but in lower case and we will put an example number:
Converting the CSV file.
Converting the CSV file.

Next, you can select what data you want Adquio to manage. We have previously done this in Lithernet when selecting what to export, but now we have the opportunity to detail our selection.

You will see that we have 4 main options indicated: Broadcast, Devices, Groups, and Scenes.

Here you must decide exactly what information you need your Adquio controller or your Screens or SCADA’s to manage. Let’s see what each section entails:

  • Broadcast: As we explained previously, if you have selected this option in Lithernet, now here you can also select it or not. If you select it, Adquio will be able to send messages to the entire Casambi network, turning it on, off, regulating, changing color, etc. If you require this, leave this option checked, otherwise uncheck it.
  • Devices: If you are going to need to read the values ​​of each device individually, leave this option checked, if you are going to work only with scenes or groups, uncheck it. To manage the status of the devices and create alarms, (as we will see in later chapters), you need to select this option and check ‘Online’ and ‘Condition’.
  • Groups: Leave it checked only if you are going to work with groups, in many cases it is not used, since everything is managed by scenes, you decide.
  • Scenes: Leave it checked only if you are going to work with scenes, in many cases it is not used, since everything is managed by groups, as before, you decide.
! We remind you that we must select our needs as specifically as possible. Fewer variables = Better response speed.

Let’s now see what we have within each option, we start with the most important ones:

  • Level: This variable allows you to turn on, turn off or regulate this luminaire, scene, etc. Its values ​​range from 0 (off) to 255 (100% on) and any value in between is regulation.
  • Online: It allows Adquio to know if each device is connected, it is not very useful in scenes or groups, but it is useful in devices. If you are going to need alarms, it is a good idea to select this option in devices.
  • Condition: This is one of the most important variables in the devices if you are going to do individual monitoring of them. This variable provides the status of the drivers and luminaires, with a series of values ​​such as temperature, lamp error, and a long list of other states. You can consult the complete list in this link: Get the most out of your Casambi devices

The rest of the variables from here are related to lighting, color, saturation, tone of white, etc. Select only the ones you require, for example, if your installation does not have RGB, never select this option, as it adds many variables to the communication.

When you have finished your selection, you just have to press the ‘Run’ button, and the process of creating the output file will end.

Now you have two options:

  • Either use the file that was created for you, and you can see its location at the top (Out file).
  • Or right-click on the bottom part, where you see a lot of text, select everything and copy it. In the next chapter, we will tell you where to paste it.

You are done in this part.

Converting the CSV file.