Latest Contributions by MattiasEkström

I've written a pythonscript that queries a mapservice layer then populates a featureset with the result and then export the attributes to an Excelfile with arcpy.TableToExcel_conversion. The problem is that once the data is loaded into the featureset any special characters like å ä ö gets messed up. How can I make sure that all characters are correct in the FeatureSet and the result Excelfile? Here is some sample code that shows the problem: # -*- coding: utf-8 -*- import arcpy, urllib2, os #baseURL = arcpy.GetParametersAsText(0) baseURL = "http://services.arcgis.com/hrh7HJqpzvUrwY6X/arcgis/rest/services/Sveriges_l%C3%A4n/FeatureServer/0" #where = arcpy.GetParametersAsText(1) where = "1=1" where = urllib2.quote(where) query = "/query?where={}&outFields=*&returnGeometry=false&f=json".format(where) queryURL = baseURL + query print queryURL JSONrespons = urllib2.urlopen(queryURL).read() print "JSONrespons where å ä ö displays correct: " print JSONrespons print "\n-----------------------------------------------------------------\n" fs = arcpy.FeatureSet() filename = "Table.xls" try:     fs.load(queryURL)     print "JSON extracted from recordset where å ä ö displys incorrect:"     print fs.JSON     try:         arcpy.TableToExcel_conversion(fs,filename)         #Excel-file from feature_set also displays å ä ö incorrect...         outputFile = os.path.join(arcpy.env.scratchFolder, filename)          arcpy.SetParameterAsText(2, outputFile)     except Exception, e:         print e.message     except Exception, e:     print e.message ... View more

I've just started to use related records in popups in my ArcGIS Viewer for Flex application, I have a problem when using multiple relationships. The buttons used to switch between relationships shows the name of the relationships shown in the Rest Service Directory, but those names are long and ugly and I can't find a way to rename them. The tables I'm relating to are query layers from an Oracle database (not SDE), even if I rename the table in the TOC it still has some kind of name in the background that is something like [ORACLEUSER].%[TABLENAME] and if I change the SQL-query for the layer an underscore an a digit is added to that name. And that name is also used to name the relationship as it appears in the service directory, and that's what shows to the end user in the popup. Se attached images for an example. Is there any way to rename the relationship in ArcMap that will affect the name in the published map service? If not does anyone know if it's possible to rename the buttons in the code? I've been trying to customize the RelationshipInspectorSkin.mxml without any luck so far, can't access the actual buttons, just the HGroup they are put in. ... View more