1. NiceLabel Help Center
  2. Automation
  3. [en] Reference and Troubleshooting

[en] Automating Reports

目前还没有官方翻译。
Pro_Enterprise.png

[en] 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.

[en] Your completed reports use your business system data to print. NiceLabel Automation:

  • [en] Receives your business system data.

  • [en] Parses your data with a data filter.

  • [en] Populates your Report with parsed data.

  • [en] Executes printing for your new populated reports with a trigger.

[en] Creating temporary databases

[en] You need to design your Reports before you automate them. To design reports, you need to connect them to a database.

[en] 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.

[en] 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.

UUID-37136986-1bbf-336d-a921-0fa949f42863.png

[en] Data from your business system with no hierarchy.
UUID-3f900745-e1a5-5ed3-e863-b3b6179a3aef.png

[en] Data with hierarchy you can use to print reports.
UUID-bc42869d-c3a7-a5ef-e3e7-bb0930556865.png

[en] Sample XML data you need to design reports (unparsed).

[en] For you temporary database, create a CSV text database file. You have multiple options:

  1. [en] Manually convert your data structure to a CSV text file:

    UUID-d5c7d971-643f-91ac-ea17-7b42ee7af04b.png

    [en] Manually creating temporary CSV text databases.

  2. [en] Use a common XML to Excel or XML to CSV conversion tool and manually format your data in a spreadsheet.

  3. [en] Use an Automation data filter to automatically parse your data into a CSV text database.

[en] Designing automated Reports

[en] Open Designer to create your Report with your temporary CSV text database:

  1. [en] Connect your temporary CSV text database to your Report.

  2. [en] Design your report using your CSV text data as variables for objects in in your Repeater Definition.

    注意

    [en] Match your variable names with data names in your data filter to map your data correctly.

    UUID-b74cb9bf-193f-cd7f-f56b-8c692193929b.png

    [en] Designing reports with your temporary CSV text database.

[en] Creating data filters

[en] Create a data filter in Automation to use in your report (Refer to your included example trigger for more information on creating XML filters):

UUID-2154bab4-7f0a-875c-a010-27cd26cd8e66.png

[en] Configuring your XML data filter.

[en] Tips for creating data filters for reports:

  • [en] You can use Structure Import Wizard to import your data structure.

  • [en] Name your elements in data blocks of repeatable elements.

  • [en] Set your elements as assignment areas or set sub-items as variables.

[en] Creating triggers for your new data filter

注意

[en] For your trigger to work, your data source names in Designer must match the data block field names in your data filter.

  • [en] Include a Use Data Filter action to apply your data filter.

    UUID-8adcac97-da66-9ffb-1594-5edbe6c3d92e.png

    • [en] Enable Collect records for report to collect all records in a table Automation uses to open your report labels.

      注意

      [en] Use the same data structure names in your reports, triggers, and filters.

  • [en] Include a Print Label action.

    UUID-68fd3beb-a876-5fbd-d724-6dbb20f1651e.png

    • [en] Enable All (unlimited quantity).

[en] Run your trigger. Your report now automatically updates with new data and prints with your trigger.