2

Closed

Join Excel File 'Data' Label not working(right click on layer)

description

I am still working with x86 VB dotspatial. and getting an error when trying to join a shapefile to excel data based on pin column. I was wondering if anybody has an suggestions?

file attachments

Closed Sep 22, 2012 at 10:19 AM by mogikanin

comments

ambiente wrote Jul 15, 2012 at 1:43 PM

I have a similar problem when I importing data where the link column has an ' in it's name.
Like:
Aparecida d'Oeste
Estrela d'Oeste
São João do Pau d'Alho
....
The error comes in the FeatureSet.cs
public IFeatureSet Join(string xlsFilePath, string localJoinField, string xlsJoinField)

mudnug wrote Jul 16, 2012 at 5:58 PM

Yep, it looks like the code in that method needs to be rewritten to used parameterized queries.

mogikanin wrote Sep 22, 2012 at 10:13 AM

In this case just need to replace quota by double quota.

wrote Sep 22, 2012 at 10:19 AM

Resolved with changeset 69585: Fixed #23011 - Join Excel File 'Data' Label not working when shapefile contains quotes in text fields

ambiente wrote Oct 1, 2012 at 9:27 AM

In this case just need to replace quota by double quota.
this is a workaround but not a solution.
If I first have to search all excel files for single quota and update to double quota this is not user friedly

mogikanin wrote Oct 2, 2012 at 5:25 PM

You no need to modify your excel files. My comment was touched changes in code.
P.S. If you can, please check latest version of DS and confirm that this issue no longer reproduced for you.

Sign in to add a comment