Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Importing into Extender Tables


The importing of data into Microsoft Dynamics GP can be a very useful tool. When using Extender in your Microsoft Dynamics GP, the likelihood that you would want to import that data is pretty high as well. So, what are the best practices for this? Extender Imports: Extender has an import function built into it just for data. This tool can import from comma delimited, tab delimited, Excel spreadsheet, and fixed width files. The Extender import option allows you to match up the columns to your import file and save that setup. When you are ready to run the import, you just need to browse to file and click import. The one thing to be aware of with the Extender import is that it doesn’t have a verification or error reporting process to the import. The data will be read and if it is correct, will be imported. If it is incorrect, it will be skipped and the import will move on. You will need to verify the data. SmartConnect: SmartConnect has all the functionality of the Extender Import and much more. SmartConnect has many more source file types for you to choose from. The other main thing SmartConnect can do is the data verification and error handling. SmartConnect will let you know if there are data issues in the import process as well as handle any errors that need to be returned to the end user. SmartConnect can run real-time if you choose with the data into and out of Extender. All of the nodes for Extender are built into SmartConnect so it will automatically pick up your resources for you and allow you to map to them. SQL Imports: The Extender tables are simply SQL tables and with that, data can always be imported through the SQL processes. This however is not recommended with Extender data. The Extender table structure is very complex and data corruption can occur very easily if not done correctly into all of the tables necessary for Extender. While the data may seem to display in the Extender Windows and Forms, it doesn’t always mean it is completely there. We have seen many issues with data that is imported directly through SQL, especially in the detail portion of windows and forms. So, to wrap up, SmartConnect is the most complete option for importing data into Extender resources. The built-in Extender Import also will work if you know that your data is good and shouldn’t have any issues. SQL imports directly are not recommended. Have a question for Nicole or our sales team? Leave a comment or email us at sales@eonesolutions.com!

3 Comments

  1. Amber R on April 1, 2015 at 5:34 pm

    Hi,
    I’ve created an Extender window on my Item Maintenance screen and I want to do a mass upload. The Extender window has the Item Number (key field) and then a list to determine the item’s ownership: Agency, Consigned, or Owned. In my SmartConnect map, how do I tell it to populate the Extender window?

    If I choose
    Group: Extender
    Node Type: Window
    Description: Extender Window Add Update
    the required fields are Window ID and Key 1. What do I put in those fields?

    Thank you so much!
    Amber

  2. Amber R on April 1, 2015 at 5:50 pm

    I figured it out and wish I could un-post my comment now. 🙂

    Window ID = the name of my Extender window (Item Ownership)
    Key 1 = my key field (Item Number)
    Field Value 1 = the information I’m trying to import (Agency, Consigned, or Owned)

    The trick was that I needed to set the ‘Data Type’ = Local Constant and manually type in the Window ID name in the ‘Column Name’ field.

    Thanks!

  3. Clint Grubb on August 18, 2016 at 11:15 am

    Thanks Nicole! I just created my first form and used the import to populate from Excel. 🙂

Leave a Comment





RECENT POSTS


Happy Thanksgiving from eOne! - US Office Closed November 25 & 26
Popdock: What is your Locale?
Q4 2021 Partner All Hands Call - Recording Now Available
An Announcement regarding SmartList Builder and SmartView from eOne Solutions
Join us for the Q4 2021 Partner All Hands Call!

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 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.