Upgrading License Plate Data from Version 1 to Version 2
The Insight Works License Plate module underwent several changes in version 2 of the product. In order to upgrade from on-premises version 1 installations, some data conversion is required. This conversion is required if converting from the C/AL version 1 codebase to a newer C/AL or AL version. There are two primary differences between version 1 and version 2 that must be accounted for:
The tables are no longer global across all companies. I.e.:
The “DataPerCompany” property is set to “Yes” on the version 2 tables.
The “Source Company Name” field has been removed.
The “Item No.” field has been replaced by “Type” and “No.” fields to allow for nested license plates.
To upgrade the License Plate data:
Export the existing license plate data by using RapidStart or manually exporting table data to Excel. The tables to export are:
License Plate Header
License Plate Line
License Plate Line Usage
Note: If the license plate data spans multiple companies, create a new file for each company by filtering on the “Source Company Name” on the License Plate Header when exporting.
Upgrade the application objects.
If moving to an updated C/AL version of License Plating, the table names and number remain the same. If moving to the AL (app) version of License Plating, the new table names will be:
IWX LP Header
IWX LP Line
IWX LP Line Usage
Import the license plate data into the new tables using one of two options: RapidStart or the Insight Works Universal XMLPort.
Using the Universal XMLPort:
In Excel, insert a new column called “Type” in the previously exported License Plate Line data and fill it with the text “Item”.
Rename the “Item No.” column header to “No.”.
Save the exported sheets as tab-delimited text files, or copy/paste the data into a text editor and save it.
Using the Universal XMLPort, import each table. The XMLPort will present a warning for fields that do not exist in the new tables, such as “Source Company Name”. Accept these warnings to proceed with the import.
Export the new tables to Excel as a template.
Paste the data from the originally exported tables to the new RapidStart template, column by column.
Paste the “Item No.” data into the “No.” field.
Fill the “Type” field with the text “Item”.
Ignore any fields from the original export that do not exist in the new tables, such as “Source Company Name”.
Import and apply the data via RapidStart.
Note: If you exported multiple companies into separate files, ensure you import each file into the individual companies.