Create SmartConnect Journal – Standard Map: Create Integration Map

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

With the prerequisites decided, in this post, I’m going to start creating the Journal – Standard integration, the first step of which is to define the Source & Destination information.

To create the integration, launch SmartConnect and on the Map tab click the Create button on the action pane:

SmartConnect Map tab showing action pane

The Map Setup window will be launched.

Enter JOURNAL_STANDARD in the Map ID field and Journal - Standard in the Map Description field.

The next step is to define the Data Source:

  • Data Source Type should be set to Bulk Data Load.
  • Set Data Source to Folder Data Source.

Despite being in the top section, we need to define the Settings before we can set the Key Fields.

Map Setup window showing settings of new map

There are quite a few fields in the Settings section:

  • Data Source Type should be set to Excel2016; if you’re using a later version of Excel, this is still the crrect item to pick.
  • Template File should be set via the ellipsis field to an empty file which will be used as the template for this map; only files matching the format of the template dropped into the folder will be processed.
  • Excel Sheet is the sheet in the workbook which is to be processed.
  • Set the Source Folder which is the folder the map will poll for the data.
  • Success Folder is the folder to where the processed files are moved when they are successfully integrated.
  • Failure Folder is the folder to where the processed files are moved if they fail to integrate.
  • If Source File is Empty I’ve set to Leave File.
  • Mark the Append date/time to moved files as this will give you an easy way to check when the files were processed and makes sure that each moved file has a unique name.

The final step in configuring the file, is to define the Key Fields back near the top of the window. Click the plus icon button next to the Key Fields header and select the relevant fields:

Fields Lookup window

I selected the three fields which comprise the journal header:

  1. BatchID
  2. TrxDate
  3. Reference

Click the Validate button to check that everything is correct:

Connection was successful message popup

Click OK to dismiss the message and then click Preview to preview the data; I can see the correct column headers, but there is no data to preview as I haven’t actually entered any yet:

Preview Data window with no data

With the map itself created, the next step is to creating the field mapping which I will cover in the next few posts.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

Your email address will not be published. Required fields are marked *