Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To Export a file, Users must first add the file as an item on the Export Files grid. Click the Add ButtonImage Removed image-20240819-151223.pngImage Added button located on the Grid Toolbar above the Export Files grid.

...

  1. Navigate to the Export Files grid by opening the 'Admin' tab and clicking on the node labeled 'File Management'.

  2. Click on the node labeled 'Export Files'. Admin > Imports/Exports > Export Files

  3. Click the row containing the information that is desired for the export.

  4. Click the Generate Export File button.

  5. The View Export File buttonImage Removedimage-20240819-151253.pngImage Added button will allow viewing of the selected Export File and theDownload Export File buttonImage Removedimage-20240819-151256.pngImage Added button will download the selected Export File.

    Generate Export File form exampleImage RemovedGenerate Export File form exampleImage Added


    • The 'Template replacements for executing SQL and build the file' field is used for changing and replacing parts of an SQL Query in the fields.

    • The 'Bind Params for Running the Query' field is used for defining variables in the query in the fields

...

  1. From the Export Files grid, open the desired Export and select the 'Schedule/Event' tab.

  2. Click the the Add Button button on the Schedule/Event grid.

  3. This will open the 'Add New Export Event' form.

    Add New Export Event formImage RemovedAdd New Export Event formImage Added
  4. Select either an Event or a Schedule as the trigger to Export the file on the 'Event or Scheduled' drop down.

    • The 'Next Run Date' field is used for setting the exact Date and Time for the Schedule.

      • If a 'Schedule' is desired, the User must then specify both the 'Frequency' of the Export.

        • Frequencies range between 'Every Minute' and 'Yearly'.

      • Exports can also be set to trigger whenever a 'Bill' has been generated, with the 'Run this Export when an Event is Triggered' option.

  5. Finally, the User must select the method for the Export.

    1. 'Email': the exported file will be emailed to the Email address provided in the 'Email' field.

    2. 'Outbound': the exported file will be placed in the Outbound Directory, where it can be accessed by other systems.

    3. 'Both Email and Outbound': the exported file will both be emailed and placed in the Outbound Directory.

...

To add a header or a footer, click the Add buttonImage Removed image-20240819-151350.pngImage Added button on the Grid Toolbar above the Header/Footer Lines grid. In the form, Users should first enter a 'Line Number' to determine the order of the header/footer in the case of multiple entries. If the User is adding a footer, check the box next to the 'Footer' field.

...

Once these required fields have been satisfied, click the Save New buttonImage Removed image-20240819-151500.pngImage Added button. The new header/footer will appear on the 'Headers/Footers Line' grid.

...