Upgrading License Plate Data from Version 1 to Version 2

Upgrading License Plate Data from Version 1 to Version 2

You are here:

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:

  1. The tables are no longer global across all companies. I.e.:
    1. The “DataPerCompany” property is set to “Yes” on the version 2 tables.
    2. The “Source Company Name” field has been removed.
  2. The “Item No.” field has been replaced by “Type” and “No.” fields to allow for nested license plates.

To upgrade the License Plate data:

  1. Export the existing license plate data by using RapidStart or manually exporting table data to Excel. The tables to export are:
    1. License Plate Header
    2. License Plate Line
    3. License Plate Line Usage
  2. 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.
  3. Upgrade the application objects.
  4. 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:
    1. LP Header
    2. LP Line
    3. LP Line Usage
  5. Import the license plate data into the new tables using one of two options: RapidStart or the Insight Works Universal XMLPort.
    1. Using the Universal XMLPort:
      1. In Excel, insert a new column called “Type” in the previously exported License Plate Line data and fill it with the text “Item”.
      2. Rename the “Item No.” column header to “No.”.
      3. Save the exported sheets as tab-delimited text files, or copy/paste the data into a text editor and save it.
      4. 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.
    2. Using RapidStart:
      1. Export the new tables to Excel as a template.
      2. Paste the data from the originally exported tables to the new RapidStart template, column by column.
        1. Paste the “Item No.” data into the “No.” field.
      3. Fill the “Type” field with the text “Item”.
      4. Ignore any fields from the original export that do not exist in the new tables, such as “Source Company Name”.
      5. Import and apply the data via RapidStart.
  6. Note: If you exported multiple companies into separate files, ensure you import each file into the individual companies.
Was this article helpful?
5 out Of 5 Stars

1 rating

5 Stars 100%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?

Leave A Comment

Go to Top