Dynamics 365 general forum

XRMToolBox - FetchXML Builder

(0) Share

Report

Posted on by Teach Me

Hi,

How can you export to excel your FetchXML results?

Thanks

Categories:

Other Functionality

I have the same question (0)

All responses (15)

Answers (1)

Mahadeo Matre 17,021 on at

Like (0)

Report

Hi..

Make same filters in Advanced find on entity and then you can easily export to excel.

Was this reply helpful? Yes No
Teach Me 85 on at

Like (0)

Report

It's not a view. It's audit logs so I can't open it in CRM.

Was this reply helpful? Yes No
Mahadeo Matre 17,021 on at

Like (0)

Report

you can copy xml result from xrmtoolbox, and create XML file.

and open xml file in excel. When you open xml file in excel, excel will ask how to open xml file.

After opening xml file in excel, you can hide columns which are not required.

hope this will help.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

You can try "Export to Excel", "Data Exporter" or "Advanced FetchXML Tester" plugin to export the fetchxml results to excel.

Was this reply helpful? Yes No
Teach Me 85 on at

Like (0)

Report

I can only seem to be able to open the query, but not the results. I tried with all 3 options to open the XML, but none of those give me the results.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Are you saying you are not getting the option to ecport to excel in any of these plugin?

Was this reply helpful? Yes No
Teach Me 85 on at

Like (0)

Report

I can't see the results in Excel when I open the XML in Excel, only the query.

With the XRM Tool Box the Export to Excel doesn't have an option to select Audit so I can't work from my FetchXML. I tried the Data Exporter, I could paste the FetchXML, but it was running for a few minutes and then it gave me a runtime error.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Can you share the fetchxml you are trying? It is also possible that the data returned is too huge and the tools are experiencing timeout?

Was this reply helpful? Yes No
Teach Me 85 on at

Like (0)

Report

Hi Ravi,

Sure, here is it:

<fetch distinct="false" no-lock="false" mapping="logical" >

<entity name="audit" >

<attribute name="createdon" />

<attribute name="action" />

<attribute name="userid" />

<attribute name="objectid" />

<attribute name="objecttypecode" />

<order attribute="createdon" descending="true" />

<filter type="and" >

<condition attribute="action" operator="eq" value="64" />

</filter>

<link-entity name="systemuser" from="systemuserid" to="objectid" link-type="outer" alias="SystemUser" >

<attribute name="fullname" />

<attribute name="windowsliveid" />

<attribute name="businessunitid" />

<attribute name="isdisabled" />

</link-entity>

</entity>

</fetch>

I had this idea from here:

www.concurrency.com/.../creating-an-audit-report-for-user-logins-in-dynami

Basically the end goal would be to be able to export to excel the users with their log dates and times.

Many thanks,

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi,

I tried Advance Fetch XML Tester tool and it worked as expected i.e. fetch returned me the results and I was also able to export them. It is possible that tou have more records and the tools is not able to handle those many records. Try putting a top count on your fetchxml and see if it works.

========

<fetch distinct="false" no-lock="false" mapping="logical" top="50" >

<entity name="audit" >

<attribute name="createdon" />

<attribute name="action" />

..

..

..

=============

Hope this helps.

Was this reply helpful? Yes No