ESM Excel to Metrel file converter User Guide
- June 9, 2024
- METREL
Table of Contents
Excel to Metrel ESM file converter
Welcome!
This tool will help you convert your data in a .xlsx (Excel) file format to
Metrel .padfx file format. You can then easily edit and/or view your data
using the Metrel ES Manager or Metrel SDK software.
Continue
Excel to Metrel ESM file converter instructions
ESM Excel to Metrel file converter
Distributor:
Manufacturer:
METREL d.d.
Ljubljanska cesta 77
1354 Horjul
Slovenia
web site: http://www.metrel.si
e-mail: metrel@metrel.si
© 2022 METREL
**** Mark on your equipment certifies that this equipment meets the
requirements of the EU (European Union) concerning safety and electromagnetic
compatibility regulations.
No part of this publication may be reproduced or utilized in any form or by
any means without permission in writing from METREL.
Dashboard screen
General Settings
Enables basic settings for creation of .padfx files.
Number of lines to skip from top| Defines how many lines in the excel file
will be skipped (starting, line 1).
Work scope 151 level| Defines the master and child Work scope for created
.padfx file. Correct Work scope must be selected in
order to enable files transfer to the desired instrument.
Work scope 2r4 level
Structure objects Settings
Enables the creation of a basic structure, where the structural elements with
relevant data will be imported.
Structure object type| Enables selection of corresponding structural elements
for the relevant structural level.
Row Settings
Enables to define data structure from excel file, to be linked to the
corresponding parameters of the selected structural element.
Parameter links
Each configuration is corresponding to relevant column from source excel file.
Parameter| Enables selection of parameter linked to the
corresponding structural element. Each parameter can be linked only to one
column letter in the source excel file.
Column letter| Defines the column in the source excel file.
Allow null or empty| Defines criteria for specific cell.
True = allows empty cells in specific column.
False = forbids empty cells in specific column.
Column type| Defines criteria for specific cell.
Text = cell data can contain letters, numbers, and
special characters such as ! or &.
Date & time = cell data shall be in following format
dd.mm.yyyy hh:mm:ss.
Add new…| Allows adding of the set parameters to the list.
Load configuration| Enables to load user configuration from file.
Save configuration| Enables to save set configuration to file.
Select an excel file and start conversion| Enables selection of source excel
file, conversion to .padfx is started automatically if no exceptions are
found.
Importing example
First prepare the excel file, put the data into the correct format. Data shall
be arranged in columns, all cells except dates shall be categorized as
General. Cells containing dates
shall be categorized as Date and formatted as dd.mm.yyyy.