Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Text Data Source


Welcome to the start of Tech Tuesday posts on our blog! Each Tuesday I will be adding a new article to this collection that can be used in your own projects and implementations. I’ll try to keep them brief and to the point as the idea behind them is to be more technically focused to balance out Martin’s dominance of the blog up to this point.

One question that we commonly receive in support is whether or not SmartConnect can read in data from text files that may not have a header or files that may use a delimiter other than a comma. We can actually use SmartConnect to configure all the connection details to your needed text file.

When you are setting up the data source you should choose ODBC as the connection type and then select the text driver from the connection string lookup button.


In the ODBC Text driver setup window you will want to uncheck the Use Current Directory option and then hit the Select Directory button and choose the folder that contains the text file you want to use as the data source.



Next, hit the Options button to expand the setup window and then hit the Define Format button. From this window you can choose your file, determine whether it has headers or not with the option box, and also choose the delimiter. If you choose the Custom Delimited option you can enter the pipe character in the field below it.



Once you have selected your file and determined the header and delimiter options, you can hit the Guess button at the top right to have the driver determine what columns are in your source file and their data types. Once you have everything configured properly from these windows, you can close out of them and continue with your map setup as normal.

1 Comment

  1. Darren on April 20, 2011 at 11:44 am

    Tech Tuesday… Chris, this is a great idea. Looking forward to future posts!

Leave a Comment





RECENT POSTS


Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING
US Office Closed, Memorial Day - May 29, 2023
Accessing Historical Dynamics GP Data in NetSuite: The Azure Data Lake
New Webinar Series: What is the Azure Data Lake?
UPCOMING WEBINAR: Top 10 New Popdock Features

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

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 Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.