Orion by Auxo

TABLE OF CONTENTS

• Intro
• OSEE setup
  • Service
  • Parts
  • FTP
  • Manual Export
• What Data is Exported

Other OSEE KB articles

• Automating the export
• File formats

Intro

OSEE (Orion Standard Extraction Engine) is a tool to export more detailed transactional data out of Orion to be used by 3^rd party tools for benchmarking, Reporting, customer dashboard …etc.
 The export files are Microsoft Excel CSV and when run on a Windows scheduled task (to automate the extract) will include only data that has changed in the last 5 days. Meaning, if a record changes (a new invoice created) it is included in the next 5 uploads. The reason for this model is to allow for outages when the file may not be created or uploaded (to an FTP site). Historical or full exports can be done manually.

OSEE setup

Within Orion navigate to Accounts > Utilities > Export > Orion Standard Extraction Engine (OSEE). 

Setup the main dealer information. For multi-location/department sites the dealer information can be set per department.

The following tabs are used to filter the export data.

Service

Select the Makes of vehicle to include in the export. Select ALL or filter the export data using the 5 available Make filters. *Ignore the Franchises

Parts

Select the parts Suppliers or Franchise to include in the export. Only parts linked to these suppliers will be exported. Or select the All Suppliers option.

FTP

The OSEE has a built-in option to FTP (File Transfer Protocol) the data. This data transfer option requires an external server with the following security credentials to be set up by your IT staff.
Set the option to “No FTP” if this is not required.

Manual Export

A manual export can be run to provide historical data, or run when you require the data. Enter the date ranges and select the Export button to run.

If no valid FTP details are entered the Manual Export will display some FTP errors and the “No FTP” is not selected. Select Close on these errors to continue the export.

Note: Save any settings before running a manual export or they will not be saved.

The export files will be saved into the ..ORION\EXPORT\OSEE folder. 

This is your Shared folder for hosted Citrix users.

What Data is Exported

• VST-CONTACT (Customer file excluding Companies)
• VSM-COMPANY (Customer file only including Companies)
• VSV-VEHICLES (All Vehicle data)
• VS9- VEHICLE STOCK (Sales Vehicle data)
• VS7- SERVICE (Summarised Workshop Invoice data)
• VV7- INVOCIE HEADER (Detailed Workshop Invoice data)
• VV5- INVOICE LABOUR (Workshop Invoice Labour data)
• VV3- INVOICE PARTS (Parts Invoices)
• VS4- PARTS INVENTORY (Parts Stock)
• VT1- SERVICE APPOINTMENTS (WIP Jobs)
• RTS CODE VV6 (Job Descriptions)
• VS5 Sales People (Users)