janitza 14.02.001, User Manual And Technical Data

Page: 84 / 86

UMG 804 www.janitza.com
84
16. Appendix
16.1 Spreadsheet Utility (firmware 1.126 or
higher)
Using the Configuration Spreadsheet Utility
·The UMG 804 can be configured by using the
Configuration spreadsheet utility which can be
loaded onto the UMG 804 via a USB flash drive
or over the network if a USB flash drive is popu-
lated in the UMG 804.
·Likewise the configuration file can also be down-
loaded from a UMG 804 either directly to a USB
drive in the UMG 804 or over the network.
·The Configuration utility is designed to work with
MS Excel and the resultant config.csv file can be
manually edited to make individually changes like
customized IP addresses.
Editing the Configuration Utility
·Open the Configuration Utility spreadsheet and
follow the instructions on the “Form Tab” of the
spreadsheet.
·Edit the fields as needed.
·Save the file as “config.csv” onto a USB flash dri-
ve (must be a high quality drive that is <32 GB).
Direct Editing of Downloaded config.csv
spreadsheets
·The values config.csv spreadsheet may be di-
rectly edited on the .csv file
·By deleting values from fields that do not have to
be modified will only result in the populated va-
lues being uploaded; this is useful for modifying
addressing without potentially overwriting other
configuration fields.
·
Note:
all files need to be saved as “config.csv!
1
Deleted values in fields not required
2
Modify values directly on .csv file
1
2