Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
Clear All
new posts
Previous template Next
    #1

    Edited field titles do not export to JSON

    Column name changes are not reflected in JSON or XML. I would assume that is is behaving as designed, since JSON and XML are data exports. Excel export does respect the column name change.

    I need to know if this is expected so I can close the ticket on our end. If its not, then I would need to know if it has been resolved or if its planned to be resolved.

    SmartClient_v91p_2014-05-13_PowerEdition

    All browsers

    Repro steps:
    1. Load the test case
    2. Change a column title with the column picker
    3. Execute in the Javascript concole - "exportJSON()"
    4. Open the exported JSON file, and note that the column name changed in step 2 is still the original value.

    Code:
    <!DOCTYPE html>

<html>
<head>
    <title >SNQA-661</title>
	
   	<script type="text/javascript" >
		var isomorphicDir="http://localhost:8080/isomorphic/";

</script>
	
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Core.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Foundation.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Containers.js"></script>
  <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Grids.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Forms.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_DataBinding.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Drawing.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_PluginBridges.js"></script> 
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Charts.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/system/development/ISC_Tools.js"></script>
 <script type="text/javascript" SRC="http://localhost:8080/isomorphic/skins/EnterpriseBlue/load_skin.js"></script>

</head>
<body>

 <script type="text/javascript">

	var data = [
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "Long Project Name", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 23, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "Feliz Navidad", redflag: "", owner: "University of MD", ins: 33, obs: 1, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "Whitehouse Lawn Maintenance", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 1, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "Automated Teller MAchine Upgrades", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 34, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 1, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "123 Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 231, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" },
			{ project: "Saks Avenue", redflag: "", owner: "University of MD", ins: 33, obs: 1, unsafe: 9, safe: 222, insDate: "10/12/2011", score:"<img src='star-4.png'/>55%", link:"<a href=''>View Analysis</a>" }
		];

</script>

</head>

<body>

	<script type="text/javascript">
	isc.DataSource.create({
			ID: "ds",
			fields: [
				{name:"project", title:"Project", type:"text" },
				{name:"redflag", type:"text", title:"Flag"},
				{name:"owner", type:"text", title:"Owner"},
				{name:"ins", type:"integer", title:"#Inspections"},
				{name:"obs", type:"integer", title:"#Observations"},
				{name:"unsafe", type:"integer", title:"# Non-Compliant"},
				{name:"safe", type:"integer", title:"# Compliant"},
				{name:"insDate", type:"date", title:"Last Inspection"}
			],
			cacheData:data,
			clientOnly: true
		});
		
		var grid = isc.ListGrid.create({
				dataSource : ds,
				dataFetchMode : "local",
				autoFetchData: true,
				width : 800,
				align : "center",
				autoFitData : "vertical",
				autoFitMaxHeight : 600,
				alternateRecordStyles : true,
				canAddFormulaFields : true,
				//canAddSummaryFields : true,
				canGroupBy : true,
				//canReorderFields : true,
				showGroupSummary : true,
				//groupByMaxRecords : 1000,
				//canMultiGroup : true,
				useAdvancedFieldPicker : true,
				advancedFieldPickerThreshold : 3,
				canEditTitles: true
		});
		
		var exportJSON = function() {
		
			var exportOpts = {
						exportAs : "json",
						exportDisplay : "download",
						exportFilename : "SNQA-661.json",
						message : "JSON"
					};
			grid.exportClientData(exportOpts);		
		}
			


			</script>
</body>

</html>
    Last edited by jwbst21; 4 Jun 2015, 10:18.
    Tags: None
    #2
    Correct, the default for JSON exports is to use the field name, not the field title, since this kind of export is generally for data interchange, not for end user display.

    Comment

    Previous template Next
    Working...
    X