Saturday, August 04, 2007
My Tridium R2 tools 1
I thought about this over a year, and finally upgraded my tools of importing NVs from Excel 50/500 controllers and converting them to program objects.
There are 2 ways, from CARE printout or from LonSchemaManager of Dynamic device. They are separate exe files now. Maybe in next upgrade, I'll combine them together.
The improvements are:
1) Before LonSchemaManager, I was using web property page of each Dynamic device, which requires additional webUI, live station and Excel as a temporary media. LonSchemaManager is much easier to get, even from a offline station.
There was an even earlier version, which requires a man-made Excel spreadsheet. The Excel spreadsheet was a part of the turnover documents from the CARE guy. But I didn't like it. Firstly, it costs more CARE guy's time and sometimes he just simply cannot provide it. Secondly, it may not reflect the true settings in CARE, since it's a manual process, and any human mistake may happen.
2) The software now shows an editable table of all NVs instead of directly generating codes in text windows and leaving no interface for human reviewing and editing. Single or multiple continuous NVs can be manually deleted. It's sorted by NV names. For further orgnizing, these NVs can be copied to and pasted from Excel.
3) The CARE version now supports automatically removing bound NVs from the NV list, which saves a lot of my manual filtering time.
4) Generally, the LonSchemaManager version should support all 3rd party Lon controllers. But I don't have enough time to review the program object code. In next upgrade, if possible, I would like to have a configurable code template to make this tool more generic and flexible.
There are 2 ways, from CARE printout or from LonSchemaManager of Dynamic device. They are separate exe files now. Maybe in next upgrade, I'll combine them together.
The improvements are:
1) Before LonSchemaManager, I was using web property page of each Dynamic device, which requires additional webUI, live station and Excel as a temporary media. LonSchemaManager is much easier to get, even from a offline station.
There was an even earlier version, which requires a man-made Excel spreadsheet. The Excel spreadsheet was a part of the turnover documents from the CARE guy. But I didn't like it. Firstly, it costs more CARE guy's time and sometimes he just simply cannot provide it. Secondly, it may not reflect the true settings in CARE, since it's a manual process, and any human mistake may happen.
2) The software now shows an editable table of all NVs instead of directly generating codes in text windows and leaving no interface for human reviewing and editing. Single or multiple continuous NVs can be manually deleted. It's sorted by NV names. For further orgnizing, these NVs can be copied to and pasted from Excel.
3) The CARE version now supports automatically removing bound NVs from the NV list, which saves a lot of my manual filtering time.
4) Generally, the LonSchemaManager version should support all 3rd party Lon controllers. But I don't have enough time to review the program object code. In next upgrade, if possible, I would like to have a configurable code template to make this tool more generic and flexible.
# posted by comfortpoint @ 10:46 PM 
