How can I export the columns from import details page?

(0) Share

Report

Posted on by Community Member

Hi,

I need export Description, column value and error code columns. I tried export error rows, but not include these three columns.

Thanks

Carys

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi ,

Can you please give some more information , how you are exporting ?

Did you tried to export with different view or with less data ?

Try to export from advanced find and select few columns see you can able to export or not .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot! My purpose is to export the description column. I am not sure where and in which entity I can find this column. I tried the entity of Import log, but no luck.

Thanks

Carys

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

How you are navigating the the grid ?

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Carys,

Unfortunately, you cannot export this information. However if you want, you can click on print button (before the 'Export Error Rows') which will give you an option to either print it on Paper or you can print it on a pdf.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (1)

Report
Copy link

Link copied!

There are limitations on UI and You cant query these records from Advance find but it does not mean we cant query these at all.

Internally these are stored in importdata and importlog entities

You can build Fetch query to include the columns you need and then run the fetch on lets say XRMToolBox Export To Excel tool.

This tool does not look like it supports these entities but in the fetch XML winodw it allows you to paste query and export data

To knore more about these entities and fields, you can use XRM toolbox meta data browser plugin

You could give this a try

Hope this helps

Was this reply helpful? Yes No
Suggested answer

MMK 745 on at

Like (1)

Report
Copy link

Link copied!

Hi Kokulan

your trick really works

but i wasn't able to use Export to Excel

but with FetchXML builder i can see the list and just copied the result view table and pasted it in an Excel

here is the fetcxml for folks to download the logs

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="importlog">

<all-attributes />

<filter type="and">

<condition attribute="importfileid" operator="eq" uitype="importfile" value="{IMPORTFILEGUIDIDPUTHERE}" />

</filter>

</entity>

</fetch>

make sure to put the Guidid of the importfile which is that what opens up when you click on imports

Was this reply helpful? Yes No
Dynamics 365 Community 52 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the direction, you pointed in the right direction. It helps me to think that way. I didn't use the XRM tools. Using SSMS tool, I was able to get the result. Sharing the query for others to use:

SELECT

[sequencenumber]

,[linenumber]

,[additionalinfo]

,[modifiedon]

,[headercolumn]

,[ownerid]

,[columnvalue]

,[importfileidname]

,[logphasecodename]

,[owneridname]

,[importdataidname]

FROM [dbo].[importlog]

where importfileidname = 'StudentClassAssessment.csv'

Was this reply helpful? Yes No