For BEI clients only, this process will reset eAutomate's callback criteria to match BEI's callback criteria so that eAutomate is flagging callbacks with the same logic as BEI. It will update the eAutomate days/clicks callback for each model. (Most BEI dealers already have models in eAuto matching BEI models. If you don't, its OK as the spreadsheet allows for you to point to your specific model.) It will only update when you manually download the spreadsheet and import, our task runs every 15 minutes and if it sees new data has been imported it will process it.
**It will NOT reset any callback flags on any service calls already closed in eAutomate.
We recommend you go through this process quarterly so any new models from your BEI subscription get picked up. And please be sure your model records are NOT set up to use System call back and call alert parameters (please see details/screen shots at bottom of this post)
Once subscribed to our alert then the first step is to download YOUR BEI data as clients may want to tweak it before importing.
- Login to BEI Services website
- In BEI drop down “EXTRAS' then 'Dealer Admin' from the toolbar
- Click on 'My Models'
- Save the results as a CSV file for import into Excel.
- Open the CSV file in Excel and leave these results open for use in the next steps...
Now go to the very bottom of this page and look for the attachment section and download our spreadsheet. Open our Ceojuice_BEI_ModelMapping_Revxxx.x.xlsm spreadsheet and make sure you are on the 'Settings' tab.
- In the Settings tab, enter in ‘CEOJuice’ in the Company DB Name, and your E-Automate SQL Server name under Server.
- Switch to the BEIModelMapping tab. Highlight and ‘copy’ all the rows of data from the BEI spreadsheet (from above) and paste the contents into our spreadsheet, starting in the 'Dealer Model' column.
- Now, press the 'Insert' button, at which point you will be prompted for a valid user login & password for SQL Server.
- After you enter your user login and password press ‘OK’ , and if you login is valid for SQL Server the spreadsheet will process the data into our CEOJuice DB Table. You should see 'Posted' in every row under the Status column.
- It has to be an SQL user, not a Windows user. You may need to create an SQL user for this process. Datawriter access to the Ceojuice database is needed.
- If nothing is showing as posted, you may need to enable active content on the spreadsheet.
Look for a 'Security Warning', like below...
Click the Options button to bring up the Options Window. On the Options Window, check the radio button next to 'Enable this content', then click the OK button to accept. Now try to run the Insert again. If you still have issues, please let us know.
- Once the data is imported it will now be processed by ID633. This process runs daily by default, but can be run on whatever schedule you specified - hourly, twice daily, etc. Let us know at email@example.com if you wish to change the default schedule.
- By default, ID633 is also run in test mode. In test mode, the report you receive from ID633 will just list what would change, no changes are actually made to your callback details in eAutomate until you tell us to switch the alert to Live mode.
Summary of events:
1. Customer downloads our spreadsheet
2. Customer downloads the model callback data from BEI
3. Customer dumps the data from step 2 into our spreadsheet.
4. Customer updates data connection on our spreadsheet and clicks button to import into a temporary table in the CEOJuice database. Any models not matched to eAuto Model Number will show error on import spreadsheet.
5. Alert runs and sees that there is unprocessed records in the temporary table and it alerts the customer of the changes (or what would be changed). When in TEST mode, this is just an alert only. When in live mode, the alert will actually update the Models table in eAutomate with the new callback data.
Sample of CEO Juice ID633 email showing what updated and any models not matched:
eAuto uses a simple logic for checking for Call Backs and Call Alerts and if you want eAuto to use BEI stats, then make sure your Model Record does not have check mark on 'System call back and call alert parameters'.
This is the model record. You get here from Inventory/Model:
If this is checked it uses the system defaults.
Remember if there is no check mark and zeros for a field, and then the call backs and call alerts will be disabled.
The system is set at options in the Tool/Options/Service Calls/Dispatch Console
Remember if there is no check mark and zeros for a field, then the call backs and call alerts will be disabled.
NEVER… EVER have zeros for your system settings.
If you have call back and call alert parameters set on the Equipment Record, those will override any settings at the Model or System level.