Inventory list

Avatar

sdg.marinusvz
2015-08-19 10:40

The following has been transcribed from a support call
My accounting department is wanting me to give them a list of all the equipment we've got! It should look something like the overview screen. Is there perhaps a long list that I can download somewhere?

Avatar

sdg.marinusvz
2015-08-19 10:48

Yes, as long as you've enabled the GIS, you can use PNPSCADA as an inventory system. To activate this feature, go Add New, select GIS, and add an Area. (For instance: At the office)
Once an Area entity has been added, you can see the menu item under View, Entities List By Area. Select it for a list.
It will show you a list of all your physical entities (the ones with Physical Location defined - GPS co-ordinates)
To change the list to show ALL your physical entities, even the ones that does NOT currently have a GPS co-ordinate defined, select the link at the bottom of the report that says 'list all physical entities'.
You can sort, search and download this spreadsheet (as a csv).
If you want to move meters between 'places' instead of necessarily GPS co-ordinates, you basically define your Areas with GPS co-ordinates and diameters, and then on the screen where you set the physical location of the entities, you can select the Area from a dropdown list, and submit it, and it will move the entity there. When you download the spreadsheet (in the above inventory report); it will show you in which area (smallest area) the entity falls. Of course you can still edit the location by dragging the pin on the map. In PNPSCADA we also support a history of locations, so if an entity moves around, you will be able to see the history of its locations on the View, View Location screen (also a map view).

Avatar

sdg.marinusvz
2015-08-19 11:29

The following has been transcribed from a support call
That is no good! I need to see what modems and sim cards and meters etc. are connected to each other.

Avatar

sdg.marinusvz
2015-08-19 11:54

Go Reports, Various.
There are many reports there that show the relationships between different entities, e.g. SIM cards and modems, and modems and meters. You can also download it in CSV format.
Perhaps you can synthesize what you want from there?

Avatar

sdg.marinusvz
2015-08-19 16:19

Ok, I can see the various reports are not quite going to work: it has everything, but separately.
What I've therefore done, is extend the functionality on the Entities List By Area report, when you click the link at the bottom, to have an Installation column.
The Installation column is unique per installation. All physical devices that are connected together has the same value in the Installation column. It is a number - Installation ID (the smallest entity ID of all the entities in the entanglement); and then between [] there is the quantity of entities in the entire tangle.
So, you can click on the Installation text at the top of the column to sort by Installation, and then you'll see all related entities underneath each other, e.g. SIM card, related modem, related meters, etc. This is also the case for Sensus concentrators and their meters, Waveports and Wavenis networks, RMS Etron networks, Echelon networks per DC unit, etc. Basically all at the same site or sub-site, would have the same Installation ID.
We only put the first 20ish characters of all the names concatenated together in the Installation column, otherwise it becomes too long and the performance goes down. You do have the full descriptions per entity in other columns in any case, so this should not be a problem.

Avatar

sdg.matiaan
2015-08-21 12:14

Example Thread:

1) Tangle number (all entities with this number belong to the same tangle)
2) You can type the tangle number in the search to get all the entities that belong together
3) The amount of entities in this tangle (including entities that you do not have permission to see)

Please log in to post a comment