Geocode excel file & batch geocode
I saw on the video guides you can drag and drop excel and csv files into the silverlight viewer from v1.8.
We're running GE 3.14 and sliverlight viewer 1.9 but adding excel files do not work. CSV files work fine.
Also, I've tried to configure the Batch Geocoder function but clicking it in the viewer does nothing.
Do we need to have ms office installed on the server? Any other thoughts?
Thanks.
-
Found where I went wrong, I had to configure the geocoding module in the viewer xml BEFORE adding the batch geocode tool.
0 -
OK next problem. The application opens the xls fine and lists the columns, there's about 250 addresses. I choose the column with the addresses and then after about 15 seconds notice this error:
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)
Timestamp: Tue, 7 May 2013 05:25:18 UTC
Message: Unhandled Error in Silverlight Application [Format_InvalidString]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.0.20125.00&File=mscorlib.dll&Key=Format_InvalidString at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at ESRI.ArcGIS.Client.Tasks.Locator.deserializeAddressesToLocations(String json)
at ESRI.ArcGIS.Client.Tasks.Locator.addressesToLocationsCompleted(Object sender, RequestEventArgs e)
at ESRI.ArcGIS.Client.Tasks.TaskBase.request_Completed(Object sender, RequestEventArgs e)
at ESRI.ArcGIS.Client.WebRequest.OnComplete(RequestEventArgs args)
at ESRI.ArcGIS.Client.WebRequest.uploadStringCompleted(Object sender, UploadStringCompletedEventArgs e, Action retryCallback)
at ESRI.ArcGIS.Client.WebRequest.<>c__DisplayClass1d.<BuildClient>b__1a(Object s, UploadStringCompletedEventArgs e)
at System.Net.WebClient.OnUploadStringCompleted(UploadStringCompletedEventArgs e)
at System.Net.WebClient.UploadStringOperationCompleted(Object arg)
Line: 1
Char: 1
Code: 0
URI: http://n675.dev.csv.au/SilverlightViewer_1_9/Silverlight.jsA bit of reseach in the web indicates it may be a regional/locale number formatting issue. I've tried setting the region to US and Canadian without luck.
Any thoughts?
0 -
Still not getting anywhere with the batch geocoder.
Below is the JSON return using the rest interface:
{ "spatialReference": { "wkid": 102171, "latestWkid": 3111 }, "locations": [ { "address": "2 GEDDES STREET ASCOT VALE 3032", "location": { "x": 2492463.0829999968, "y": 2413701.4745000005 }, "score": 90, "attributes": { "ResultID": 1, "Status": "M", "Score": 90, "Match_addr": "2 GEDDES STREET ASCOT VALE 3032", "Addr_type": "Address" } }, { "address": "22 GEDDES STREET ASCOT VALE 3032", "location": { "x": 2492388.3046000004, "y": 2413712.0835000016 }, "score": 90, "attributes": { "ResultID": 2, "Status": "M", "Score": 90, "Match_addr": "22 GEDDES STREET ASCOT VALE 3032", "Addr_type": "Address" } } ] }Any ideas why I'm getting the InvalidString error based on the above? As far as I can see the detail being returned is as expected.
0 -
The batch geocoding functionality is built into the Viewer for Silverlight, not in the core product. So this isn't the right forum which likely why it's not getting attention. I'm doing a little research to learn more, but have found nothing yet.
0 -
I made some progress, the batch process works on about 7 to 8 records but any more than that it fails. I've tried different combinations of records and it's the same. Is there some limitation to the amount of data returned by the GET function?
I've asked this in the Silverlight viewer forum as well.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
5 Kommentare