Skip to main content

Sync NAV items to Perfion

Zoltán Mikolás
  • Updated

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 - FromToCommandActionScriptNote
Provider=SQLOLEDB;uid=sa;pwd=XXX;Database=demo database nav (8-0);Server=(local)NAV DatabaseSET   
NAV DatabaseNAV DataSELECT.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 DataProductIMPORT   

Related articles

Comments

0 comments

Please sign in to leave a comment.