D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Data Connector

  • 1.  Data Connector

    Posted 22 days ago
    I am using a lot the data connector to import data into the D365 system.
    Any time I do it I need to Design it adding columns needed

    Anyone knows if there is a way to save templates to use in the future avoiding to design it any time?

    Thanks in advance for your help

    Regards,

    ------------------------------
    Alexis Barrios
    Fyffes Group Ltd
    Pompano Beach FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Data Connector

    SILVER CONTRIBUTOR
    Posted 21 days ago
    You can start by using the Office integration in D365 within Organization administration module.

    1. Use document templates to create and save customized templates to use for the data import from various forms or pages in D365.

    The below links will assist you in answering your questions with some demonstrations:

    https://us.hitachi-solutions.com/knowledge-center/customizing-open-excel-templates-dynamics-365
    https://dynamicsax-fico.com/2017/12/07/dynamics-365-general-journal-excel-imports/

    Hope this helps.

    ------------------------------
    Shilpi Thakur
    Freelance AX/D365 Microsoft Consultant
    Dynact Consulting Ltd
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Data Connector

    Posted 20 days ago
    Thanks Shilpi Thacur

    I coud build the template and browsed into the document templates, I did no override the original one, My intention was to create a new template.

    When I go back to the General Journal and open lines in Excel I do not see the one I created.  Am I missing a step there?

    Regards,

    ------------------------------
    Alexis Barrios
    Fyffes Group Ltd
    Pompano Beach FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Data Connector

    SILVER CONTRIBUTOR
    Posted 19 days ago
    You probably want to start wit the Organization Administration> Office Integration> Excel Workbook Designer, select the entity and fields you want to access, and then click "Create Workbook".  Then you can save your workbook and import it into the list of templates in D365 using Organization Administration> Office Integration> Document Templates, to make it available to others and potentially on the dropdown list for "Open in Excel" on various pages within D365.
    See this page for details on settings you can choose when saving a new template.
    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/office-integration-edit-excel

    ------------------------------
    Lynn Kinsman
    Senior Systems Analyst, Pricing, Rebates, Projects
    Kodak Alaris Inc.
    Rochester NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Data Connector

    SILVER CONTRIBUTOR
    Posted 19 days ago
    Edited by Shilpi Thakur 19 days ago
    Did you upload your designed General Journal template in D365 with a different template name? You have to use the same (LedgerJournalLineEntryTemplate) when uploading the new desinged template otherwise, the upload will successed but you won't be able to make use of document template.

    I designed and saved my document template as (LedgerJournalLineTemplate_ST). In my example, it ends with _ST.


    Now when you upload the template, delete this suffix and make use of the original template name ('LedgerJournalLineEntryTemplate').

    You can also rename the Template display name as given in the screenshot.

    You will be able to see the new designed template when you use MS Office add in - Open in excel from General Journal page


    Hope this helps.




    ------------------------------
    Shilpi Thakur
    Freelance AX/D365 Microsoft Consultant
    Dynact Consulting Ltd
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Data Connector

    SILVER CONTRIBUTOR
    Posted 19 days ago
      |   view attached
    Hello Shilpi,

    My question with this process is if you rename the template to the same 'LedgerJournalLineEntryTemplate' then it says that the template exists and it overrides the one in the system. it works but I never got the two templates to show under the open in excel.




    ------------------------------
    Juan Sebastian Grijalba
    Berkowitz Pollack Brant
    Miami
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Data Connector

    SILVER CONTRIBUTOR
    Posted 19 days ago
    Sorry I missed demonstrating that the second template is specific to the company or legal entity.
    If you do not want to override the default template used across legal entities you can add a separate designed template specific to a company. The Company then defaults on the designed template when using the import/ export functionality from Open to Excel .

    ------------------------------
    Shilpi Thakur
    Freelance AX/D365 Microsoft Consultant
    Dynact Consulting Ltd
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Data Connector

    Posted 19 days ago
    Got, Thanks a lot!!!

    ------------------------------
    Alexis Barrios
    Fyffes Group Ltd
    Pompano Beach FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: Data Connector

    SILVER CONTRIBUTOR
    Posted 18 days ago
    I have not had a problem getting my custom templates with their own name to show as an "Open in Excel" option.  Just need to set the flag on the template.  See these instructions: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/office-integration-edit-excel

    When will a template show as an Open in Excel option?

    When a template listed in the Common > Common > Office integration > Document templates form (DocuTemplate) has ShowInOpenInOfficeMenu set to Yes and has the same root datasource (table) as the current form, it will be added as an option in the Open in Excel section of the Open in Microsoft Office menu. The following image shows the Document templates form with two of my custom templates with "List in Open in Office" ticked.



    ------------------------------
    Lynn Kinsman
    Senior Systems Analyst, Pricing, Rebates, Projects
    Kodak Alaris Inc.
    Rochester NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role