topic Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues. in Data Management Questions

Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 16:39:16 GMT

This is issue. I am trying bring in a excel table with a standard set of attribute (fields) which I will then merge layers to this new excel table. The issue is that I have an example of how the data should be entered, and when I bring in this excel table I keep getting this error message.

One or more layers failed to draw:

ValdesSlidesMetrics$ Events: Syntax error (missing operator) in query expression 'Longitude centrepoint >= -129.300244 AND Latitude centrepoint >= 49.622159 AND Longitude centrepoint <= -123.957440 AND Latitude centrepoint <= 53.344866'.
ValdesSlidesMetrics$ Events: An invalid SQL statement was used. [`ValdesSlidesMetrics$`]

So when I go to export the data it will not work. I was wondering I have missed something...as this is a very simply step and I can not see what I've done wrong. Any suggestions would be most helpful.

Thanks

Jessica

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

DarrenWiens2 — Wed, 13 Sep 2017 16:44:06 GMT

As a starting point, your field names cannot contain a space, so remove those.

Did you make that SQL statement as a definition query, or are you getting that error message as soon as you try to add the Excel sheet as a layer?

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JoeBorgione — Wed, 13 Sep 2017 16:45:55 GMT

Not sure if this is your problem or not, but it's worth taking a look at:

centrepoint <= 53.344866' (the ' at the could be the culprit)

Also, be sure your centrepoint data are typed as float or double, not text. It may be that you are trying mathematical comparisons ( <,> =>,<=) on a text field.

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 17:07:39 GMT

Hi Darren

I get this error when bringing in the excel sheet to ArcMap. I will have a closer look at the excel table for spaces etc...and try again. Also notice Joe Borgione comments below. I will change this and see if it work.

Thanks for the help.

Cheers

Jessica

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 17:09:03 GMT

HI Joe

Thanks, I was wondering about this. The excel table was sent to me from someone and I thought this might be needed. I will remove it and then see if this works. I let you know.

Thanks

Jessica

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

DarrenWiens2 — Wed, 13 Sep 2017 17:22:59 GMT

I'm not sure how that SQL query is getting in there, then. Do you have filters on, in Excel? If so, try removing them.

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 17:33:08 GMT

Hi again Joe

So I checked the table to see if the ..'...was the problem and then checked to make sure the parameters were 'double' and not text. But I still get the error below. I am not too sure what else to try?

Jessica

One or more layers failed to draw:

ValdesSlidesMetrics$ Events: Syntax error (missing operator) in query expression 'Longitude centrepoint >= -133.851656 AND Latitude centrepoint >= 46.634603 AND Longitude centrepoint <= -119.664869 AND Latitude centrepoint <= 56.379586'.
ValdesSlidesMetrics$ Events: An invalid SQL statement was used. [`ValdesSlidesMetrics$`]

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JoeBorgione — Wed, 13 Sep 2017 18:15:48 GMT

The problem appears to be your field names, as suspected/suggested by Darren Wiens Most of them have spaces and/or special characters:

That's a huge problem with excel files coming into ArcGIS. Excel is okay with spaces and/or special characters in the field names, while ArcGIS is not. You need to clean up the field names in the source data (your excel worksheets) before you can use them in ArcGIS.

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 18:23:44 GMT

Hey Joe

I was wondering about that. I will change it for the purpose of this database. I was hoping I didn't have to change much of what they were wanting. Thanks for clarifying. I am also a wee knew to using other peoples data and as this is a big project, I was trying to stay within their requirement with regards to the table. Anyhow, I greatly appreciate your time.

Thanks

Jess

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 18:34:34 GMT

Hi Joe and #Darren Wiens

Also, realize that there are several data validations (drop down menus) in this table, that I need to have in here. I was wondering if there a way around this when bringing the file into Arc?

Any ideas?

cheers

Jess

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JoeBorgione — Wed, 13 Sep 2017 20:04:43 GMT

Jess- take a look at domains and subtypes: allowable values in a geodatabase: Coded value domains and subtypes—Help | ArcGIS Desktop

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Wed, 13 Sep 2017 23:41:18 GMT

Hi Joe

Thanks

Ill have a look tomorrow. As I off now. Thanks for getting back to me.

Cheers

Jess

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

XanderBakker — Thu, 14 Sep 2017 11:54:47 GMT

Could you share your Excel file to see if we can reproduce the problem? I normally prefer to convert the Excel files into FGDB tables before working on them in Desktop. There are so many things you can do in Excel that are not valid from a database perspective, so having a look at the original Excel file would help.

Re: Hi, I realize this question has been asked a few times, however, I have tried to remove spaces, change name etc, but I am still having issues.

JessicaRutherford2 — Thu, 14 Sep 2017 18:31:48 GMT

Hello Xander

I managed to bring the excel file into ArcMaps by editing the field names, as per suggested. So thanks for the help.

Cheers

Jess