Description

The FlexibleVINCSVGen Generator loads World Manufacturer Identifier (WMI), Vehicle Descriptor Number (VDN), a 1-digit year, and plant code from column data within a CSV file to generate a valid and synthetic 17-digit Vehicle Identification Number (VIN). Some example VINs are below: 

  • JT3HJ85JXW7584587
  • 1HGCM826X37703667
  • 1G1ZT5285F7225845
  • 1HGCM826237120610


In This Article


Prerequisites

A CSV file will be required to pass the following information on to the Generator. The values used in the CSV file (WMI, VDS, etc.) need to be consistent and aligned with each other to generate valid VINs. 

  • World Manufacturer Identifier (WMI) - First three digits of VIN (e.g., MCB, ML3, SAJ, WP1).
    • Digit 1 - Country
    • Digit 2 - Region/Maker
    • Digit 3 - Vehicle

  • Vehicle Descriptor Number (VDN) - The next five digits of the VIN are the vehicle description. Examples are below: 
    • CM826 - Honda Accord, 3.0L V6, sedan body style, make = Honda
    • AFP40 - Ford Mustang, passenger car with airbags, make = Ford
    • HJ85J -  Toyota Land Cruiser, 4.5L engine, SUV, make = Toyota
    • ZT528 - Chevrolet Malibu, 3.5L engine, 4-door sedan, make = Chevrolet

  • Year - Digit 10 in VIN, this should be one character. Examples are below: 
    • A = 2010
    • 3 - 2003
    • N = 2022

  • Plant Code - Identifies the plant where the vehicle was built. Examples are below: 
    • Ford - F, R, K, W
    • GM - 1, 3, 5
    • Toyota - U, J, M
    • Honda - A, C, L
    • Not all codes are standard across manufacturers. Some plants share codes; you must use the WMI to resolve the plant identity.

NOTE: See the following Wikipedia page to learn more about Vehicle Identification Numbers (VINs) -https://en.wikipedia.org/wiki/Vehicle_identification_number


Sample CSV File

A sample CSV is shown below. This file has also been attached to the article and can be downloaded for use.



Generator Parameters

The following parameters are available for the FlexibleVINCSVGen Generator. Items with an asterisk (*) are required. 

  • filePath* - Defines the path where the CSV file is located. 
  • fileSubDir - Defines an optional subdirectory under the filePath where the CSV exists.
  • fileName* - Define the name of the CSV file to open for WDS, VDS, and Year. 
  • delimiter* - Defines what delimiter is used to separate column data within the CSV file.
  • seed - Defines an optional seed for randomization. Using the seed will ensure that the same random data is generated each time.
  • unique - Defines whether to generate a unique list of VINs.
  • list - Stores one value on each line in the list. To add values, type them in and hit ENTER. Note that the listed value is shown only for simulation mode. When running a true Scenario, the data will be specified from the actual source.


Example - Generate Unique VINs for 10 Users

This example uses the FlexibleVINCSVGen to generate 10 unique Vehicle Identification Numbers (VINs). 


CSV File

The sample CSV file is attached at the bottom of this article:
 

 

Project Setup

  • Domain loopCount = 10
  • Receiver = DelimitedFileReceiver
  • Scenario = VINScenario


Attribute and Generator

The Domain has a vin Attribute, and the FlexibleVINCSVGen will be used to generate the required  VINs. The following parameters have been configured for this example: 

  • filePath - references the user's output directory
  • fileName - name of the required CSV file
  • delimiter - delimiter used in the referenced CSV file, comma for this example


Sample Output