Latest Contributions by JoshuaChan

‎08-30-2016

is there a bug submission page somewhere?

‎08-30-2016

thank God a colleague of mine was able to help me out. It was not a syntax thing but an ESRI Bug of some sort that's referenced in another thread: https://community.esri.com/thread/170160#comment-581568 MakeTableView doesn't work properly in some situations using 10.3 even though the exact same script using the exact same dataset will work in 10.2 ESRI : please fix this ASAP! Copying out my table into another table to add ObjectID before making my virtual table seems kinda redundant and pointless... If anyone from ESRI read these forums please add to your to-do list - please and thank you!

‎08-29-2016

i'm not familiar with that and the help seems to make it look more like a way to connect to the database(?) Or it creates some long string to connect(?) can you explain how this would be used in the context of my MakeTableView problem?

‎08-29-2016

unfortunately that didn't seem to do it either. Same error message: (DISPOSITION_TRANSACTION_SID = 923413) AND (PRIMARY_CONTACT_YRN = 'Y') ERROR 000358: Invalid expression Failed to execute (MakeTableView). I altered my script to use the AddFieldDelimiter: t1 = self.bcgw + '\\WHSE_TANTALIS.TA_TENANTS' # gobetween table t2 = self.bcgw + '\\WHSE_TANTALIS.TA_INTERESTED_PARTIES' # fields for joining the tables t1Field = 'DISPOSITION_TRANSACTION_SID' joinField = 'INTERESTED_PARTY_SID' contField = 'PRIMARY_CONTACT_YRN' # only pulling out client identified as "Primary Contact" # editing out and trying AddFieldDelimiters # http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-functions/addfielddelimiters.htm # whereClause = t1Field + " = " + str(dispID) + " AND \"PRIMARY_CONTACT_YRN\" = \'Y\'" wcList = [t1Field, contField] wc1 = arcpy.AddFieldDelimiters(self.bcgw, t1Field) wc2 = arcpy.AddFieldDelimiters(self.bcgw, contField) whereClause = "({0} = {1}) AND ({2} = '{3}')".format(wc1, str(dispID), wc2, 'Y') arcpy.AddMessage(whereClause) legal = 'LEGAL_NAME' # field names in the TA_INTERESTED_PARTIES table first = 'FIRST_NAME' last = 'LAST_NAME' txtClientName = 'Interest Holder: ' # resetting txtClientName arcpy.MakeTableView_management (t1, "t1View", whereClause) arcpy.AddMessage("created t1View")

‎08-26-2016

Oracle. Not sure what version. I can find out if the version of Oracle matters. but that part remains the same... when I run in 10.2 or 10.3 it's still the same DBMS.

‎08-25-2016

unfortunately the double quotes around the field names didn't help. I also tried the square brackets. I was looking earlier in my script and I have a SQL statement (using the same format) that I was using in a definition query on a layer (also stored in SDE) and that worked fine in both 10.2 and 10.3 I was about to copy/paste my module (after adding double quotes) here but it looks like all formatting disappears (spaces, tabs etc). So here it is on an FTP site: ftp://ftp.geobc.gov.bc.ca/pub/outgoing/_SouthCoast_Region/clientNameModule.txt

‎08-25-2016

the data is sitting in ArcSDE and is the same data. It's only the ArcGIS version that's different (10.2 vs 10.3) in the past the SQL hasn't been an issue. I'll see if fiddling with double-single quotes helps or round/square/curly brackets helps or not. when I remove that reference to that module that script works fine so it is something about the MakeTableView_Management tool that has changed or as you suggest, maybe something about how SQL needs to be formatted in 10.2 vs 10.3?

‎08-25-2016

good point... here's the print out of my SQL statement plus the error message: DISPOSITION_TRANSACTION_SID = 923413 AND PRIMARY_CONTACT_YRN = 'Y' ERROR 000358: Invalid expression Failed to execute (MakeTableView). DISPOSITION_TRANSACTION_SID and PRIMARY_CONTACT_YRN are both fields in tables and the script runs fine when I run it in 10.2 but bombs in 10.3 Does it matter what version of ArcGIS the mxd was created in? the original one was probably 10.1.

‎08-24-2016

I have a python script that is used as a toolbox that allows users to plug in a few variables and then a map is created for them, filtering the layers based on their input. It works fine in ArcMap 10.2 But for some reason it has errors in ArcMap 10.3 where it bombs is the MakeTableView tool. The error statement is saying I have an improper SQL statement. What has changed from 10.2 to 10.3 that would make my SQL statement invalid? Anyone know how to fix this? the end user wants to use 10.3

‎07-08-2016

I downloaded the latest version of Survey123 Connect. The first survey I made was a success. But the next one I tried, the application freezes, becomes unresponsive. This happens when I try choosing an already created survey or when trying to create a new survey. It just freezes and even after five minutes, remains unresponsive. Now whenever I start it up and try to create a new survey or access an existing one it freezes. I have tried uninstalling-reinstalling and no use. I went back to ver 1.3.something and it seems to be OK. But what happened to ver 1.5.35?

‎01-27-2015

can any one out there help? Or is this posted in the wrong place? where do questions like this belong? still having trouble navigating the new format

‎01-23-2015

I'm having trouble creating a many-to-many relationship in ArcGIS. The help docs (ArcGIS Help 10.1) make it sound like it's possible but when I try the dialog for both the "Create Relationship Class" and the "Table to Relationship Class" tools there doesn't seem to be a way to link the interim table inside of there. It's quite confusing. Even the naming of an "origin" and "destination" table doesn't quite make sense to me yet, especially in the M:M case where there's a third table, the linking table, which is nowhere to be seen in the dialog box. Second part of the question is - can the M:M relationship dataset be published as a map service? when I click on my polygon will that relationship be valid and I'll see the many records from my related table appear? P.S. - how do I post this question to the right "place"?

‎10-06-2014

by using the Add button do u mean adding it from my workstation instead of the ESRI myContent cloud?

‎10-03-2014

I added a zipped shapefile to "My Content" and set it to Public. However, I am still unable to add it to a map. How can I make it "visible" when I search for a list of available content???"

‎08-26-2014

I have an unanswered question about arpcy.mapping here: https://community.esri.com/message/395210?sr=search&searchId=217e8af9-1d87-4cde-a095-f520d1ef56cd&searchIndex=1#395210 The format is getting really long and messy and it hasn't been answered yet. For the history please read thru it. But I think the problem seems to be a bug with the way arcpy.mapping.listLayers works or doesn't work. in the interactive python window using my mxd I can list layers and see my layer of interest: "Dimensions". If I perform the same command in my script, the "Dimensions" layer does not appear. yet I'm using the same commands on the same mxd. i've used "CURRENT" and the pathname to the mxd. please see the attached to see what I'm talking about plus the previous forum post above. Help is desperately required and much appreciated!!!

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by JoshuaChan

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Re: ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

ArcPy: MakeTable_View works in 10.2 but not in 10.3? Why?

Survey123 Connect ver 1.5.35 freezing

Re: Many-to-many relationships and Publishing a map service

Many-to-many relationships and Publishing a map service

Re: Zipped shapefile in "My Content" not visible when I want to add to a map. Why?

Zipped shapefile in "My Content" not visible when I want to add to a map. Why?

buggy Arcpy.Mapping behaviour (!?)

Many-to-many relationships and Publishing a map se...

Re: df.ZoomToSelectedFeatures not working