{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["User Manual","settings reconf","identity reconf","User data #1","User data #2","User data #3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User Manual","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["This Excel-based macro template provides a simple tool for mass generation of .reconf-files for Jomitek sensors."]
[]
["GOAL"]
["Rolling out, or reconfiguring, large amounts of sensors with respect to the content of their 'settings.conf' or 'identity.conf' files."]
[]
["SENSOR RECONFIGURATION OPTIONS"]
["Both 'settings.conf' and 'identity.conf' may contain device specific information fields which are not supposed to be changed during an update. For this reason Jomitek sensors support incremental updates via .reconf-files. By uploading e.g. a 'settings.reconf' file, the sensor will automatically detect the file, and perform the requested incremental updates to the 'settings.conf' parent file. After this operation the .reconf-file is deleted from the sensor. Note that some changes may require a restart of the sensor to take effect."]
[]
["INPUT REQUIREMENTS"]
["To support automatic generation of a file upload script, each sensor must be identified by its IP address. The provided template lists some of the data fields defined per default. Additional fields can be added, and the existing removed as needed for a particular reconfiguation purpose. "]
[]
["OUTPUT FORMAT"]
["When pressing the 'Generate Output' button on either the settings or identity template sheets, a Lua formatted script file will be generated for each IP address, placed in subfolders relative to the Excel sheet. In addition a .bat and .txt file will be generated which supports automated FTP transfers of the relevant files using the freeware program WinSCP. See WinSCP.net for download options."]
["Important: Please update the install path used for WinSCP below, for correct generation of the .bat file."]
["C:\\Program Files\\WinSCP"]
[]
["IMPLEMENTATION"]
["Especially for mass updates, it is recommended to test the update procedure, as well as the update content, on one or more easily accessible test sensors. Following this, the updates may efficiently be distributed using the generated source files and the transfer scripts created for WinSCP-based distribution."]
[]
[]
["STEP-BY-STEP GUIDE"]
["1. Identify the IP adresses of the devices targeted for a configuration update."]
["2. Define the information fields to be updated, and update the column title accordingly. The syntax of the column titles must be a Lua acceptable format, meaning no spaces, avoid special characters in general, and use the '.' (punctuation) character to step into the next level in the Lua database hierachy. The main information view on the web page (the tree view structure), can be used for reference on what information fields are currently defined. "]
["3. Define the content of the information to be updated for each device, and insert it into the relevant cells (according to IP adress, and column title). Note that information fields, or entire subsections may be deleted using the special entry \"<_delete_>\" (without quotation marks)."]
["4. Press the 'Generate Output' button. Note that you must have enabled Macros for this step to succeed."]
["5. E.g. in an explorer view, go to the folder where this Excel sheet is stored. Subfolders with the IP adresses has been created, along with .reconf-files as specified. Here you will find the .bat-script 'Distribute Reconf via FTP'. By activating this batch process, and assuming that the WinSCP install path has been correctly defined, the generated .reconf files will be distributed to all the IP adressess specified."]
["6. Check the command prompt list to see if there were any failed transfers, and start troubleshooting if this is the case."]
["7. Make a sample check using e.g. the web interface on a couple of the devices, to verify that the updates were succesful."]

{"sheet":"settings reconf","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["settings.reconf"]
["IP address","i3.post_processing.average_time","i3.post_processing.flip_direction_of_current","i3.estimator.estimator_mode","i3.estimator.timer ","i3.event_settings.short_circuit_current_threshold","tcpip.dhcp"]
["192.168.135.10",30,false,"P1N0",60,400,true]
["192.168.135.11",30,false,"P1N0",60,400,true]
["192.168.135.12",30,false,"P1N0",60,400,true]
["192.168.135.13",30,false,"P1N0",60,400,true]

{"sheet":"identity reconf","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["identity.reconf"]
["IP address","location_name","location_description","address","zip","city","country_state","wgs84_coordinate"]
["192.168.135.10","Jomitek office, section 1","Test lab","Skovlytoften 22",2840,"Holte","Denmark","55.821923,12.488537"]
["192.168.135.11","Jomitek office, section 2","Test lab","Skovlytoften 22",2840,"Holte","Denmark","55.821923,12.488538"]
["192.168.135.12","Jomitek office, section 3","Test lab","Skovlytoften 22",2840,"Holte","Denmark","55.821923,12.488539"]
["192.168.135.13","Jomitek office, section 4","Test lab","Skovlytoften 22",2840,"Holte","Denmark","55.821923,12.488540"]

{"sheet":"User data #1","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["This sheet can be used for input data being prepared for insertion into the settings or identity reconf file templates."]

{"sheet":"User data #2","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["This sheet can be used for input data being prepared for insertion into the settings or identity reconf file templates."]

{"sheet":"User data #3","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["This sheet can be used for input data being prepared for insertion into the settings or identity reconf file templates."]