Skip to content

ApoAlly Insights Data Export#

ADG S3000#

The integration of ApoAlly Insights with the ADG S3000 inventory management system allows pharmacies to efficiently export business data and use it for detailed analyses. Below is a step-by-step guide to creating a data export in ADG S3000 and integrating it into ApoAlly Insights.

Creating a New Job in the S3000 Reporting Center#

  1. Select Register
    Navigate to the desired register in ADG S3000 and click the button to create a new job. In the following dialog, select the desired data source. The choice of data source depends on the specific requirements of your pharmacy.

Find more information here.

  1. Open Job Editor
    After selecting the data source, the job editor opens. This allows you to configure the job, including the selection of filters and list elements.

  2. Select Filters and List Elements
    - Use the set search to select the desired filters and list elements from the data source. Alternatively, you can manually search for the sets.
    - Drag the desired set into the filter or list using the left mouse button and make the necessary presettings.

  3. Presettings for Filters
    - Define boundaries for the filter (e.g., time periods, product groups).
    - Enable the additional parameter “Query at filter start” to allow the user to modify the boundaries before starting the evaluation.

  4. Presettings for List Elements
    - Define headers, column widths, sorting, and any summation for the list elements.

  5. Save Job
    - Open the dialog to save the job and provide a unique name for the evaluation.
    - In the “Comments and Version” tab, you can add a short and detailed comment about the created evaluation. Ideally, use the current version number of the S3000 inventory management system as the version number.

  6. Configure List Options
    - Define the output device (e.g., printer, file) and the type of list.
    - Find more information about list options here.

  7. Set Security Rights
    - In the “Security” tab, determine which users are allowed to execute the created evaluation.
    - Find more information about user management here.

Integration with ApoAlly Insights#

  1. Data Export from ADG S3000
    Export the created evaluation from ADG S3000 in a supported format (e.g., CSV, TSV, XML).

  2. Upload Data to ApoAlly Insights
    Use the ApoAlly REST API or the provided scripts (PowerShell or Bash) to securely import the exported data into ApoAlly Insights.

  3. Data Validation
    Verify the uploaded data in the ApoAlly Dashboard to ensure it has been processed correctly.

  4. Create Queries
    Use the text-to-SQL functions of ApoAlly Insights to create targeted queries and make informed decisions based on your business data.

By following these steps, you can seamlessly integrate the data from your ADG S3000 system into ApoAlly Insights and leverage the benefits of text-to-SQL technology for your pharmacy.