Microsoft Dynamics 365 | Integration, Dataverse...

Chart Import Error: not valid XML or does not conform to the chart schema

(0) Share

Report

Posted on by mcrthomas

166

I'm following instructions found here, Modifying Multi-Series Dynamics CRM Charts to Use a Single Axis - CRM Software Blog | Dynamics 365 to remove the secondary axis for a multi-series chart.

I've exported the chart, opened it in Notepad, removed the yAxisType, saved it over the exported XML file, but when I try to import it again, I receive this error:

The specified XML file "Opps--YTD.xml" is either not valid XML or does not conform to the chart schema.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Steve Zhao2 on at

Like (0)

Report

Hi AdmWombat,

I followed the blog you provided, and I can import it successfully.

Original chart:

Delete the YAxisType property and import chart:

It seems that your chart xml is invalid. Please try to export it and only delete the YAxisType property to try again.

Was this reply helpful? Yes No
mcrthomas 166 on at

Like (0)

Report

Exact same error. Tried it in Chrome as well as Edge. Also tried to Export and Import with no changes, but I get the same error.

Was this reply helpful? Yes No
Steve Zhao2 on at

Like (0)

Report

Hi AdmWombat,

Could you provide the chart xml?

Was this reply helpful? Yes No
mcrthomas 166 on at

Like (0)

Report

Sure. This is the version I'm trying to import,

<visualization>

<visualizationid>{9834979b-eec4-ed11-83ff-000d3a565cf9}</visualizationid>

<name>Revenue & Budget--All YTD</name>

<description>null</description>

<primaryentitytypecode></primaryentitytypecode>

<datadescription><datadefinition><fetchcollection><fetch mapping="logical" aggregate="true"><entity name="opportunity"><attribute name="name" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0"/><attribute name="actualvalue" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_0"/><attribute name="estimatedvalue" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_14"/></entity></fetch></fetchcollection><categorycollection><category alias="_CRMAutoGen_groupby_column_Num_0"><measurecollection><measure alias="_CRMAutoGen_aggregate_column_Num_0"/></measurecollection><measurecollection><measure alias="_CRMAutoGen_aggregate_column_Num_14"/></measurecollection></category></categorycollection></datadefinition></datadescription>

<presentationdescription><Chart Palette="None" PaletteCustomColors="91,151,213; 213,112,44; 160,116,166; 178,134,0; 68,114,196; 90,139,56; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 86,122,154; 192,120,72; 167,129,172; 178,143,35; 105,142,208; 112,154,83; 50,125,194; 210,96,18; 150,83,159; 183,138,0; 51,90,161; 90,138,57;"><Series><Series ChartType="Bar" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40"><SmartLabelStyle Enabled="True"/></Series><Series ChartType="Bar" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40"><SmartLabelStyle Enabled="True"/></Series></Series><ChartAreas><ChartArea BorderColor="White" BorderDashStyle="Solid"><AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"><MajorGrid LineColor="239, 242, 246"/><MajorTickMark LineColor="165, 172, 181"/><LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59"/></AxisY><AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"><MajorTickMark LineColor="165, 172, 181"/><MajorGrid LineColor="Transparent"/><LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59"/></AxisX><AxisY2 LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"> <MajorGrid LineColor="239, 242, 246"/> <MajorTickMark LineColor="165, 172, 181"/> <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59"/> </AxisY2></ChartArea></ChartAreas><Titles><Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="59, 59, 59"/></Titles><Legends><Legend Alignment="Center" LegendStyle="Table" Docking="right" IsEquallySpacedItems="True" Font="{0}, 11px" ShadowColor="0, 0, 0, 0" ForeColor="59, 59, 59"/></Legends></Chart></presentationdescription>

<isdefault>false</isdefault>

</visualization>

Was this reply helpful? Yes No
mcrthomas 166 on at

Like (0)

Report

I think I have it working now. I was trying to upload in the form view rather than in advanced settings. It worked in advanced settings.

It's not showing in the list view drop down for charts, but I am able to add the new version to a dashboard.

Was this reply helpful? Yes No
Steve Zhao2 on at

Like (1)

Report

Hi AdmWombat,

I'm glad to hear that. Cheers!

Was this reply helpful? Yes No