Automotive | Product Application
      Back to home
      1. EBMS Knowledge Base
      2. EBMS Main Documentation
      3. Automotive | Product Application

      Creating the YMM Master List

      The master Product Application list must be completed before YMM options can be added to the product catalog.  The records can be added using one of the following methods:

      1. Import the master product application list from Excel or other database file.  Data can also be exported from an existing product application list to a spreadsheet for editing purposes.  This import and export process is the recommended method when data is available.

      2. Manually create or alter the list using the basic tools within the Product Application tab

      Manually Create or Alter list

      Complete the following steps to add or adjust the master Product Application list:

      1. Open the master list by selecting Inventory > Options > Product Applications from the main EBMS menu.

      2. Add records by completing the following steps:

      3. Enter a range of years using the beginning Year setting and the year End settings.  Select Make, Model, and other optional settings and click Add to add YMM settings to the table.   Note that records will need to be deleted individually using <Ctrl> <Delete> or using the Delete button.

      4. Existing records cannot be changed within EBMS.   Records need to be deleted by using the <Ctrl> + <Delete> or using the Delete button and added again to alter settings.   All records that are listed will be deleted.

      Import List from Excel or other Database File

      Use the Data Import and Export Utility  to create or maintain the master product application list by completing the following steps:

      1. Launch the Data Import and Export Utility by selecting File > Utilities > Text Import/Export Mappings from the main EBMS menu:

      2. Create a New Import/Export Mapping Property settings or select Properties to open existing mapping Properties.   

      3. Map the files between the spreadsheet or other file and the EBMS master product application list.  Review Configuring Import/Export Mappings for configuration details.

      4. Update master Product Application list.  Review Importing Text Files into EBMS for the steps to covert the master list from an Excel or other file into the EBMS.

      Review Export EBMS data to a Text File to export the master product application list to a CSV file that can be read using MS Excel.