Agvance and Energy Force Automated Tank Import to Agvance

New and modified Tanks can be automatically imported to Agvance without having to run the export and import processes.

The Tank table has a Last Modified Date and Time (UTC time) field that is used to compare to the Last Run Date log. Only tanks modified or created after the Last Run Date of the tank will export.

There are 2 new system settings for the automatic tank import.

• SyncTankstoAgv – When this setting is set to N the tank export runs as it has before, creating a tank export file that will need to be imported into Agvance.  Setting the value to Y updates tanks in Agvance using the API without having to do the export and import processes. This system setting is auto generated and defaulted to N.
• SyncTankstoAgvAltID – For customers using Alt ID’s, the SyncTankstoAgvAltID needs to be set to Y even if the export/import process is still used.  This system setting is not auto generated.

The Secured Values table is required to be filled out. If the customer sync is already being used then this table will already be completed.

The tank sync process can be run 3 different ways:

1.  From Main Menu / Posting Menu / Daily Clear, select Daily Tank Export.  This button runs the export or sync (based on the SyncTanksToAgv System Setting) with or without alternate ID’s (based on the SyncTanksToAgvAltID System Setting), so the daily tank export with Alt IDs button has been removed.
   
2. The second process is running the Master Daily Clear at Main Menu / Posting Menu / Daily Clear.  When sending sales from Energy Force to Agvance, Tanks need to be updated to avoid errors and to ensure they are up to date at the time of the Master Daily Clear and the tank import will run automatically.
3. The automatic tank import can also be set up in the background tasks located at Supervisor Menu / Maintenance Menu / Automated Tasks Menu / Background Tasks.
   
   1. Select Create.
   2. Select TankSync from the Type drop-down.
   3. Enter the Interval (Minutes) for how often the update should run.
   4. Checkmark the task as Active and select Save.
   5. All of the date fields as well as the User Id field will fill in automatically.