web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Templates for Data Imp...
Microsoft Dynamics CRM (Archived)

Templates for Data Import...what view is this using...and can I change it?

(0) ShareShare
ReportReport
Posted on by USA80 26

In CRM 2016, when I go into Settings, Data Management, and click on Templates for Data Import.  One of the drop down options I have is Client Hierarchy.  I have a request from a user to change this import spreadsheet that gets generated here.  Can I do this and if so, how?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi ,

    All the fields that are part of published forms and all the required fields of an Entity  will be included when you click on the "download template for import"  . So make sure the  fields are included in  the form or should be mandatory in that case import template will change accordingly.

    Hope this helps.

  • USA80 Profile Picture
    USA80 26 on at

    My user wanted me to change the template to match another view that was created, so I am guessing I can't mimick this template to match the other view/template?

  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    You can add any entity field in the template with the field name but make sure don't change the format of the file .

  • USA80 Profile Picture
    USA80 26 on at

    OK, so lets say there is a column showing up called Effective Date.  I need this field on the form, but I don't want it to show up in the template...can I remove it?

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    No you can not , its default behavior . However you can delete the field from the template and also without fill the data you can import the template, in that case field should not be mandatory.

  • USA80 Profile Picture
    USA80 26 on at

    Thank you, that is what I thought.

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi USA80,

    If you just want few columns from the entity and not all then you can use the below approach. As per your requirement, you could have just used the view you have created.

    1. Run an advance find, add the columns you want in your template.

    2. In the query condition, select a condition which will never be true like created on tomorrow. This to ensure that advance find doesn't return any record and just generate the layout

    3. Run the query, because of the condition, there will be no record. From here, click download excel button. This will download the excel file.

    4) Now you have an excel template with just your columns. You can add values and then import it in crm  in the normal way.

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans