Cooper Order & Invoice Download Scripts

Users can apply scripts to the OASIS database to automatically initiate order and invoice downloads every 30 minutes for Cooper connectivity. This removes the user's burden of manually downloading the updates. However, these scripts will NOT automatically manage the updates inside the download folders after downloading them. Learn more about managing the download folder for Cooper Order Status Download and Cooper Invoice Status Download.

Requirements:

• User must have Admin access to Software.
• User must have Admin access to Manufacturers.

Setting Up the Background Process User

Each script requires a user's active Flash credentials in OASIS to initiate the downloads. This user must be configured as the Background Process User under the parent manufacturer entry in OASIS. Note: the scripts will fail if the user's Flash credentials expire. However, once the user's Flash credentials are updated in OASIS, the scripts should restart without further input.

1. Navigate to the Manufacturers page.

2. Open the parent entry for Cooper.

3. On the General tab, click Configure Specialization.

4. The Configure Flash Connection window will appear. 

5. On the Direct tab, click the Settings subtab.

6. Select the user with active Flash credentials from the Background Process User drop-down list.

7. Click Ok.

Running the Scripts

Note: if multiple databases are syncing, the scripts must be run on each database.

1. Download each script file attached at the bottom of this article to the machine's desktop.

2. Navigate to the Configuration page, then select Software from the drop-down list.

3. Click Run SQL.

4. The Run SQL - Alter database! window will appear.

5. Click  to browse files on the machine. 

6. A file selection window will appear. Select one of the script files from the desktop.

7. Click Open.

8. Click Ok to run the script.

9. Repeat steps 3-8 for the remaining script.

Note: if an error appears after running either script file, please contact OASIS Support by email at support@oasissalessoftware.com or by phone at 501-843-6750.

Script Files