Modifying the Custom Mapping Files

The custom mapping files are modified using Microsoft Excel. The following are some values you can use.

Custom Mapping
Value Result
Text Imports the text into the related field in EasyPower if all other import values are valid.
Number Imports the number into the related field in EasyPower if all other import values are valid.
{{=xxx}}

Compares the value in the SKM export file with the value in the CSV file. If the values are equal, the criteria is considered to be met.

For example, if the value in the SKM export file is 480 and the value in the CSV file is {{=480}}, and all other import values are valid, the specified EasyPower values are imported.

The curly braces are required. The comparison values are not limited to 3 characters—this is just used as an example.

{{<=xxx}}

Compares the value in the SKM export file with the value in the CSV file. If the values are greater than or equal, the criteria is considered to be met.

For example, if the value in the SKM export file is 400 and the value in the CSV file is {{<=200}}, and all other import values are valid, the specified EasyPower values are imported.

The curly braces are required. The comparison values are not limited to 3 characters—this is just used as an example.

{{>xxx}}

Compares the value in the SKM export file with the value in the CSV file. If the SKM export value is greater, the criteria is considered to be met.

For example, if the value in the SKM export file is 200 and the value in the CSV file is {{>250}}, and all other import values are valid, the specified EasyPower values are imported.

The curly braces are required. The comparison values are not limited to 3 characters—this is just used as an example.

{{%xxx}}

Compares the value in the SKM export file with the value in the CSV file. If the values contain the same characters (including values that contain additional characters), the criteria is considered to be met.

For example, if the value in the SKM export file is "circuit breaker" and the value in the CSV file is {{%circuit}}, and all other import values are valid, the specified EasyPower values are imported.

The curly braces are required. The comparison values are not limited to 3 characters—this is just used as an example.

xxxx, xxxx

Compares the value in the SKM export file with the value in the CSV file. If the values contain either set of characters, the criteria is considered to be met. You can have multiple values separated by commas.

For example, if the value in the SKM export file is "circuit" and the value in the CSV file is "circuit, breaker" and all other import values are valid, the specified EasyPower values are imported.

More Information