For BEI clients only, this process will reset e-automate's callback criteria to match BEI's callback criteria so that e-automate is flagging callbacks with the same logic as BEI. It will update the e-automate days/clicks callback for each model. (Most BEI dealers already have models in e-auto matching BEI models. If you don't, it's OK as the spreadsheet allows 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.
VariableY: If you are using this process to update the model callback parameters from the BEI published values but you have a matching model set in e-automate to 'Use System CallBack parameters', then this update will not affect that model. If you want this process to turn off that check box so that the uploaded callback values will take effect, set this variable value to 'YES'.
**It will NOT reset any callback flags on any service calls already closed in e-automate.
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
- Click on 'Dealer Admin'
- Click on 'Model List'
- Click on "Export Table'
- Automatically save .csv file
- Open the 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.
**Please note: Our spreadsheet utlity does NOT have all the same column headers that your BEI spreadsheet does. So be sure to remove any columns from your BEI spreadsheet that don't match up to ours. Then make sure ALL columns in both CEO Juice and BEI spreadsheets are in correct order.
For example, our spreadsheet does not contain column header of 'Technology' like this BEI spreadsheet does:
- Now, press the 'Insert' button, at which point you will be prompted for a valid user login & password for SQL Server.
- You will be prompted for SQL user login (this is not a Windows domain user.) You may need to create an SQL user for this process. DB_writer access to the Ceojuice database is needed.
In SQL user should be created as a User under CEOJuice database:
DB_writer access to the Ceojuice database is needed for this user.
(1) User in Green is correct example; whereas user in (2) is not as is domain user:
- After you enter your user login and password press ‘OK’ and if your login is valid for the SQL Server the spreadsheet will process the data into our CEOJuice DB Table. You should see 'Posted' in every row under the Status column.
- 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 firstname.lastname@example.org 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 e-auto 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 e-automate with the new callback data.
Sample of CEO Juice ID633 email showing what updated and any models not matched:
The very top section (as shown below) will be for rows in the BEI spreadsheet you've uploaded where cbclicks are 0. After that, there are normally a lot of records where the BEI dealer model from the spreadsheet does not match a model number in e-automate. These are normally valid and represent models that are still in BEI, but no longer match the model number in your e-automate database. Can be models no longer in e-auto or where the model number has changed. If you compare the model not associated in the alert to the BEI spreadsheet, you would normally find multiple entries in the spreadsheet for the BEI Model Number, one will most likely match a model in eA-automate, the other won't.
e-auto uses a simple logic for checking for Call Backs and Call Alerts and if you want e-auto 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 a zero in 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.