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-151231.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 button.

  5. The View Export File buttonImage Removedimage-20240819-151248.pngImage Added button will allow viewing of the selected Export File and theDownload Export File buttonImage Removedimage-20240819-151259.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 form
  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.

Source Data - Crystal Report (Depreciated)

Crystal Report will draw from any currently created Crystal Reports that are available. Simply click the 'Crystal Report' picker in the 'Crystal RPT' tab. A Crystal Report can be Exported as one of several desired 'File Types'; 'PDF', 'Word Document', 'Excel File', 'Rich Text File (rtf)', or 'CSV'. The Filename 'Prefix' field and 'Extension' may also be optionally selected.

Source Data -

...

Custom Reports

Custom Report will draw from any currently created Custom Reports that are available. Simply click the ‘Custom Report’ picker in the ‘Custom Report' tab. A Custom Report can only be exported as a PDF. The Filename 'Prefix' field is optional but the 'Extension' will be set to 'pdf’.

Source Data - SQL

...

To Export as a SQL Query, the User must specify a Delimiter and optionally specify the Enclosure. The Filename 'Prefix' field and 'Extension' may also be optionally selected. These will set the name of the file after it is Exported. SQL must be entered manually as a SQL Query in the 'SQL Query' tab. SQL Select into File Command (MySQL Only) allows you to set the SQL query to a file on the server. This is good if you need to view a lot of data that is limited by Adhoc and Import limitations.

...

An E911 file can be exported as one of three different 'File Types': Fixed Width , or Delimited, or Crystal Report.

When Exporting an 'E911' file, there are three tabs of information to be considered: Columns, Header/Footer Lines, and Schedule/Event.

...

To add a header or a footer, click the Add buttonImage Removed image-20240819-151340.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-151456.pngImage Added button. The new header/footer will appear on the 'Headers/Footers Line' grid.

...