Import Inventory From AutoIMS

1) In AutoIMS, locate the Inventory Report you would like to import into OMG!

Screen_Shot_2017-08-24_at_11.55.23_AM.png

 

2) From the buttons above the report, select 'Download', and open the file in Excel.

Screen_Shot_2017-08-24_at_11.55.59_AM.png

 

3) Delete yellow areas, and change each vin to the last 8 characters only.

delete_yellow.png

 

4) Change the following column headers:

  • Add Column -> Related Customer (Enter Customer Account # As Listed in OMG!)
  • Change 'Assignment Accepted' -> Date
  • Change 'City' -> Location: City (You will only need this for Transportation Request)
  • Change 'Vin8' -> Last 8 of Vin

Select & Copy all of the data, including column headers.

import_file.png

 

5) In OMG!, select 'Vehicle Records' from the top navigation.

Screen_Shot_2017-08-24_at_10.38.33_PM.png

6) From the 'More' dropdown in the top right, select 'Import/Export'

Screen_Shot_2017-08-24_at_10.41.37_PM.png

 

7) Complete the following steps in the upload section:

  • Select 'Import into a table from the clipboard'
  • Pick Table should display 'Vehicle Records'
  • Paste the data from the spreadsheet into the box
  • Click Import Data

Screen_Shot_2017-08-24_at_10.45.42_PM.png

 

8) Verify that the data appears in the correct columns. If not, select the correct column name from the dropdown. **Do Not Upload City** Then Click 'Import'

Screen_Shot_2017-08-24_at_11.09.15_PM.png

 

9) Your records should now appear in your New Vehicle Records Report.

Screen_Shot_2017-08-24_at_11.12.18_PM.png

10) Click here for section on importing Transportation Requests

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.