EONE BLOG

Tech Tuesday: Export to File Destinations in SmartConnect.com


Recently, we have added the option to export to file destinations in Smartconnect.com. This option allows for us to send data to an excel or text file. There are also options to include headings, overwrite files, append data/time, create separate files per key field, append the key field to the filenames, and enclose column values in quotes.

We will go through the setup process for the export to file destinations and explain each option in a little more detail.

Export to File Destination


  • Click on the Target tab.
  • Select Export to File as the Target.
Export to File Destination
  • If we want to send the file to an FTP Server, then we will need to select our FTP connector (which would need to be setup in the Connections) for the FTP Destination and select the FTP Path.
  • Otherwise if the FTP Destination is left blank, the integration will output a local file.
  • Enter the File Name
  • Enter the File Type, either Excel or Text file.
  • If we selected Text File, then select a Column Separator. The options are Csv, Tab, Pipe, or Custom Delimited. Enter the Custom delimiter in the textbox shown below.

  • Select the Character Set, either ANSI or OEM.
  • Select which options you would like to add to your file.
    • Include Headings – This option will include the headings from our source file in the exported file.
    • Overwrite file – The option will overwrite any file given the same file name.
    • Append date/time – The option will add the date/time to the exported file name.
    • Separate file per key field – This option will create a separate file for each key field in the source.
    • Append key field to filename – This option will only become available if the “Separate file per key field” option is selected. It will append the key field to the file name.
    • Enclose column values in quotes (“”) – This option will enclose each data value in quotes in the exported file, not including the file headers.

Mapping and Running the Integration


  1. Click on the Integration tab.
  2. Select Export to file as the Target Lines.
  3. Under the Source Grouping tab, select any fields to group by.
  4. Select the Target Integration tab.
  5. Map the source fields that you want to the columns in the file destination.
  6. Save and run the integration process.

If you have anymore questions about exporting file destinations in SmartConnect, feel free to email us at sales@eonesolutions.com

2 Comments

  1. Chuck Curtiss on September 14, 2020 at 2:33 pm

    What version is this available in? I am running 20.18.11.1

  2. Patrick Roth on September 15, 2020 at 9:21 am

    The above is SmartConnect.com, not the onprem version you noted the version numbers of.

    SmartConnect onprem has had the ability to output to text file for years and is similar to the above. However sc.com does have the ability to define an output delimiter and also wrap the output fields in double quotes – onprem doesn’t have that yet (but coming).

Leave a Comment





RECENT POSTS


Coming Soon: Q2 Partner All Hands Call!
Tech Tuesday: SmartConnect 21 Import Process
SmartConnect Office Hours Recap: Popdock Widget Groups
Employee Spotlight: James Varn, Regional Sales Manager, EMEA
Zendesk and Dynamics 365: Sales and Support - You Can't Have One Without the Other!

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.