Link to the Flexi2XML tool: https://podpora.flexibee.eu/cs/?q=Flexi2XML
This example covers importing data from Excel into the Address Book module and provides instructions on how to update labels in Flexi.
1) Prepare the Excel files.
One for deleting labels (vymazani.xls) – contains the IDs of companies in the address book in the id column and the character x in the stitky column.
A second one for importing labels (import.xls) – contains the id of companies in the address book and the label abbreviations separated by commas in the stitky column.
2) Create the XML files.
In the command line, navigate to the directory where Flexi2xml-cli.exe and the Excel files are located.
Run the commands to generate the XML files.
flexi2xml-cli --from-xls vymazani.xls --evidence adresar --to-xml vymazani.xml
flexi2xml-cli --from-xls import.xls --evidence adresar --to-xml import.xml
3) Edit the vymazani.xml file.
Select all text in this file and use the find and replace function to find <stitky>x and replace it with <stitky removeAll="true">.
4) Import the XML files.
Go to Tools -> Import -> Import from XML and first import vymazani.xml, then import.xml.
