Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Editing Import view

Posted on by 1,210

Hi is it possible to edit the system view or create a personal view for imports?

I have not been able to find anything under customization for imports and under saved views (personal) there is only import jobs which is not it.

Is there also a way to automate exportation of a view everyday? Or I have noticed that there is a template that sends on completion of an import job, is there a way to add the success and failures of the job to this template?

Thanks.

*This post is locked for comments

  • Editing Import view
     
    thanks.

    I feel the orignal question still remains unresolved.

    I want to export views and edit them and import those views.
  • Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Editing Import view

    Hi Michael,

    The view is actually stored in this table:

    select * from SavedQuery

    where ReturnedTypeCode = '4412'

    Which is you can edit, but be aware, in unsupported way (onpremise only), the fetch xml and the layout as well...

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Editing Import view

    Hi Michael,

    Out of the box, you cannot customize the Import File System View.

    The entity name is actually 'Import' for the job list and 'ImportFile' for the detail record of file, not import job nor System Job.

    So, the template that you are talking about is for System Job notification only for Bulk Deletion and Bulk Duplicate Detection Jobs, not for the Import File (from csv or xml or zip). So, you cannot use that email to send notification.

    And that entity name, which is Import File, is a hidden entity, which is you cannot find in the Customize Entities, unless you tweak the database tp get the fetchxml View and modify this.

    Hope this helps!

    Thanks.

  • Michael Minn Profile Picture
    Michael Minn 1,210 on at
    RE: Editing Import view

    Hi Aileen

    I am talking about editing the view you posted in your last picture. I want to be able to create views that are pre filtered to specific created on etc.

     Data-import-email-job.jpg

    Also the template I was talking about was this:

    I want to know if i can add the success and failure that you see in the import view into this.

  • Suggested answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans