Combine your business system data with labels containing Reports. Create reports in NiceLabel Designer and fill your reports with data from your business systems in NiceLabel Automation.
Your completed reports use your business system data to print. NiceLabel Automation:
Receives your business system data.
Parses your data with a data filter.
Populates your Report with parsed data.
Executes printing for your new populated reports with a trigger.
You need to design your Reports before you automate them. To design reports, you need to connect them to a database.
If you use data from external business systems for reports, you have no database to work with. To work correctly, report data needs a hierarchical structure with clearly defined elements.
Create a temporary database with data from your business system (Usually XML or JSON data). With your temporary database, design and configure your reports. Your temporary database is only for setup. Configured reports print using Automation triggers, not your temporary database.
For you temporary database, create a CSV text database file. You have multiple options:
Manually convert your data structure to a CSV text file:
Use a common XML to Excel or XML to CSV conversion tool and manually format your data in a spreadsheet.
Use an Automation data filter to automatically parse your data into a CSV text database (Refer to your included XML to CSV sample file for more information).
Open Designer to create your Report with your temporary CSV text database:
Connect your temporary CSV text database to your Report.
Design your report using your CSV text data as variables for objects in in your Repeater Definition.
Match your variable names with data names in your data filter to map your data correctly.
Create a data filter in Automation to use in your report (Refer to your included example trigger for more information on creating XML filters):
Tips for creating data filters for reports:
You can use Structure Import Wizard to import your data structure.
Name your elements in data blocks of repeatable elements.
Set your elements as assignment areas or set sub-items as variables.
For your trigger to work, your data source names in Designer must match the data block field names in your data filter.
Include a Use Data Filter action to apply your data filter.
Enable Collect records for report to collect all records in a table Automation uses to open your report labels.
Use the same data structure names in your reports, triggers, and filters.
Include a Print Label action.
Enable All (unlimited quantity).
Run your trigger. Your report now automatically updates with new data and prints with your trigger.