Geocode excel file & batch geocode

Permanently deleted user

April 18, 2013 13:13

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.

0

• 

  Permanently deleted user

  May 06, 2013 13:04

  Found where I went wrong, I had to configure the geocoding module in the viewer xml BEFORE adding the batch geocode tool.

  0
• 

  Permanently deleted user

  May 07, 2013 12:50

  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.js

   

   

  A 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
• 

  Permanently deleted user

  May 21, 2013 11:09

  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
• 

  Permanently deleted user

  May 22, 2013 01:28

  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
• 

  Permanently deleted user

  June 01, 2013 09:32

  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

Please sign in to leave a comment.