Sync NAV items to Perfion

Owned by Morten Lindequist Køhler
Feb 14, 2024
1 min read

This Action Map synchronizes items from NAV to Perfion.

This example is provided as inspiration only. It must be adapted to your Perfion environment to work. Perfion Support does not assist with such adaptations. Please contact your Perfion Partner or your Perfion consultant if you need assistance.

Action Map

  • All lines containing a Command are created as virtuals. This is a recommended best practice

  • The NAV connection in this example is included directly in the Action Map. As an alternative, it can be stored in another action and referenced via the EXECUTE.ACTION command

  • The SQL script in this example returns data directly formatted for Perfion import. This means there is no need for further mapping in the Action Map

Sample data for building Action Map

NOTE: Line breaks are omitted if you paste scripts from the table below directly to an action. In stead, paste script to Notepad++ and then copy from there. That will preserve line breaks when you paste into an action.

Action Map - From

To

Command

Action

Script

Note

Provider=SQLOLEDB;uid=sa;pwd=XXX;Database=demo database nav (8-0);Server=(local)

NAV Database

SET

 

 

 

NAV Database

NAV Data

SELECT.SQL

 

SELECT
I.No_ _Value
,I.Description ItemName_EN
FROM [CRONUS International Ltd_$Item] I
WHERE
I.Blocked = 0
AND I.[Item Category Code] = 'COFFEE'

 

NAV Data

Product

IMPORT