Import Vehicles List

Preface

This populates the vehicle list in the extension so you can start adding the vehicle application fitments to your products!

When the system encounters a Make/Model that is already present in the vehicles list, it will skip it. If the system does not know about the Make or Model yet it will be added. The names of the Make/Models should match up character for character otherwise it will be added as a new vehicle.

Rules

Summarized simply: include column labels in the first row. You are able to have a single 'year' column, or 'year_start' & 'year_end' columns for easily importing ranges of years. If you do not have a 'year' dropdown on your search use whatever "levels" your search will have.
  1. Column labels must be included in the first row to identify each column to the system.
  2. You must have a column for each "level" in your configuration.
  3. Column ordering is not important.
  4. Column labels are case-sensitive (starting with v1.33).
  5. Substitute underscore instead of space if desired.
Note

In your vehicles list, if you already had a Make "Acura", but no models, and then you specified Acura Integra for Make/Model in the import, the system would add "Integra" under the existing "Acura" record.

Troubleshooting
  1. If you use "special characters" you must use UTF-8 file encoding
  2. MAC newlines are not supported

Year Ranges

Year ranges allow you to add ranges of years by specify the start & end years. You may break the range out into two columns, or use one column and separate the columns with dashes. If the year_start you specify is greater than the year_end, they will be swapped automatically on a row by row basis. To add a single year in a range formatted file, just put the same year for both year_start & year_end, or specify just the year_start, or just the year_end (leaving the other blank).

Example #1 - No Year Ranges

If you wish, you don't need to use the year ranges.

Example #2 - Year Ranges In Multiple Fields

Example #3 - Year Ranges In One Field


If you accidentally reverse the year_end and year_start it will be automatically fixed.

2 Digit Years

When specifying the year_range column, or the year_start & year_end columns, you may use 2 digit years. It is assumed if a 2 digit year is '24' or less, that it means 21st century. If a 2 digit year is '25' or higher, it is assumed it means 20th century. Use of 2 digit years is discouraged, but supported.

Example #1 - Year Ranges In Multiple Fields (2 Digit Years)

Example #2 - Year Ranges In One Field (2 Digit Years)

Enumeration

You may separate Makes or Models by comma if you are adding the same years. Separating by comma will cause each Make,Model, or Year to be "multiplied" or blown out. In other words it will enumerate over all possible combinations. You may enumerate multiple values within any 'level' field (Make/Model/Year field). All possible combinations will be multiplied out, or in other words the system will derive the power set.

Note: If you want an actual comma, escape it with another comma. For example "test1, test2" is regarded as 2 individual models, if you mean it as one type "test1,, test2" to show you actually want the comma in there. The double comma will be replaced with a single comma.

Example #1 - Comma Enumeration:

Example #2 - Comma Enumeration In Multiple Fields (Power Set):

Logging

Logging will automatically happen when using the web interface. This will be written to '/var/vaf-import.log'. It will be logged when an import starts & stops, and when errors are encountered in your data quality that cause skipped rows.

Command Line Interface (CLI) / Cron

Navigate to Elite/Vafimporter/cron. The file to be imported will be read from vehicles-list-import.csv. Export files will be named as vehicles-list-export.csv

Import

To import, use this command:
php vehicles-list-import.csv.php
Or as a background process:
nohup php vehicles-list-import.csv.php > error_log &

Export

To export, use this command
php vehicles-list-export.csv.php
Or as a background process:
nohup php vehicles-list-export.csv.php > vehicles-list.csv &

Logging

Import logging will automatically be written to vehicles-list-import.log, errors and notices will be logged.