Business Integration Solutions Documentation

Walkthrough: Item Export

About this walkthrough

This walkthrough provides an overview on how to export data from Microsoft Dynamics NAV. In the following example we will export item data in fixed length format.

Prerequisites

Template Description Sample File

TI_CS_ITEM.OUT

STAEDEAN Template - Export Items (TXT Format)

N/A

Story

  • This connection uses a Timer Event to trigger the pipeline, based on a time interval in Microsoft Dynamics NAV.
  • Once the Pipeline is triggered, the XML Generator Activity will create an XML-file, based on an internal document and filtered set of data.
  • The XML to Text Translator is used to convert the XML to a text document.
  • The File Writer writes the text document to the specified location.

Item Out

Task

Setup

  1. Import Connectivity Studio Connection-TI_CS_ITEM.OUT.zip configuration package. Item Out
  2. Open the TI_CS_ITEM.OUT connection. On the connection page, edit the File Writer settings and provide the Folder Name. Item Out Settings

Process

  1. Process the connection.
  2. Check the output folder location.
  3. A text file with the item details should be created. In this scenario the item details are exported based on the following filter: Item: No.=>1000&<1200. You can change this in Timer Event settings.

Result

Item Out Result

This will export items (in fixed length format) based on the internal document structure and a filtered set specified in the Timer Event.