Latest Contributions by WilliamCraft

The option you want is actually two icons to the left when viewing the attribute table in George's screenshot.  The very first icon start on the left has a drop-down arrow associated with it; click that and pick Select by Attributes.  There is no difference "feature" attributes and "table" attributes, truthfully.  While feature classes and tables do appear differently in the ArcMap table of contents, the Select by Attributes capability is exactly the same when being performed either on a feature class or on a table.  Attributes can exist in tables or feature classes.  The difference in HOW you access the Select by Attribute dialog box when dealing with a feature class versus a table is something to note though; for feature classes, you can get to the Select by Attribute dialog box by opening the Selection menu at the top of ArcMap.  For tables, you have to open the attribute table first and use the button / drop-down arrow I've just mentioned.  Both dialog boxes work the same way; but as you have correctly indicated, the Select by Attribute dialog box that gets opened from the ArcMap Selection menu does not work with tables. ... View more

I'm not convinced that all of the permissions have been assigned correctly; mainly with the F, S, D, and A tables that correspond to your base table.  I see from you original screenshot that the object class in question is versioned as a State ID is referenced in the error.  This is why it's critical to use the ArcGIS Desktop tools when granting and revoking permissions to roles for given object classes... because doing so in Oracle can cause issues if you don't do it for all of the right tables involved.  You will need to find out which F, S, D, and A tables correspond to your feature class's base table and grant the same permissions to those as you did with the base table.  Once you commit your permission SQL statements from within Oracle, close and re-open ArcGIS Desktop and try connecting again with a user from the role that was just given permissions. EDIT: I've just re-read a few things in this thread.  You said that the user can see the data if permissions are given to the user directly rather than just to the role.  In that case, please check to see if the role in question for that user account is set to be a DEFAULT role in Oracle. ... View more

Understoood; however the funny thing is that only one person is editing. Every other user is simply viewing the file. Viewing the contents of a file geodatabase OR editing its contents using an Esri product, it doesn't matter which, will produce a .LOCK file inside the file GDB's folder on the file system which can be seen via Windows Explorer.  It will contain some numbers in its filename, one of which refers to the process ID (PID) of the active process connecting to it.  To know which process or application has your FGDB locked, open Task Manager and explore the contents of your GDB folder on the file system using Windows Explorer.  Add the PID field to Task Manager and then compare the process IDs in Task Manager to that of the lock file to identify the culprit.  The presence of the .LOCK file is essentially an exclusive lock and won't allow you to do much else other than view the FGDB contents until it is gone. Killing those connections can be done by ending the process brutally in Task Manager or gracefully closing an application or stopping a GIS service, if applicable.  Now, if there is no lock file or process holding on to the FGDB, then you probably have a system lock of some sort that hasn't cleared up.  Rebooting should resolve that; but if rebooting isn't possible then you'll need to close the FGDB files manually.  If you have Windows 7 or Server 2008 R2 or higher, then go to the Start menu and type 'fsmgmt.msc', pick the Open Files node, multi-select the files that are open in your FGDB folder, and right click them to close all. ... View more

For 10.1, check out the help file here: http://resources.arcgis.com/en/help/main/10.1/index.html#//005s0000001w000000 "You can open Microsoft Office Excel tables directly in ArcGIS and work with them like other tabular data sources. For example, you can add them to ArcMap, preview them in ArcCatalog, and use them as inputs to geoprocessing tools." From there, you can create a file geodatabase and then export your Excel table from the ArcMap table of contents to a table within your new file geodatabase by right clicking it and choosing Export Data. ... View more

Within the same Oracle instance and within the same Oracle database, you can have multiple user-schema geodatabases but one and only one SDE schema (referred to often as the master schema).  In other words, you have one master geodatabase and multiple user-schema geodatabases which are essentially system-managed through the SDE schema.  All of those user schemas MUST be at the same Esri release; you cannot have one user schema at 9.3.1, one at 10.0, and another at 10.1 SP1 while the SDE user schema is at 10.2.  Upgrading the geodatabase will migrate all user schemas to the same version (at 10.1 and higher, the Upgrade Geodatabase tool does this automatically) and it's not possible to use multiple releases, period. ... View more

I think what you might be experiencing is NIM090672: Specific Microsoft updates may result in data corruption with file geodatabases or shapefiles created on a network share.  In short, when writing data to a file geodatabase on a network share using a few select Windows operating systems, errors can occur upon subsequent request of that same data.  In your case, this looks like it could be the issue based on what you reported.  Check out the link below to determine if this is correct in your case and how to apply the fixes: http://support.esri.com/zh-cn/knowledgebase/techarticles/detail/41119 ... View more

I am pretty sure the request for a a 1-year token gets overridden by the Security Settings in ArcGIS Server Manager under the Security --> Tokens section.  Are you requesting the token via the tokens application such as https://servername/arcgis/tokens/ and setting the expiration to 1 year in the drop down menu?  While that might sound like the right approach (if this is indeed what you're doing), there's one more setting to configure in AGS Manager.  See the screenshot... [ATTACH=CONFIG]29877[/ATTACH] Change your Long-Lived Tokens value to 365 days and see what happens after an hour as a result after requesting a new token.  You can do this by clicking the small pen icon to the right of the section header. ... View more

Alternatively, if you are satisfied with the output from your script then you can use the Add XY Data option in ArcMap to create an XY event layer using the X and Y fields.  The rest of the info in your file becomes attribution.  Then, right click the layer in ArcMap's table of contents and use the option for Export Data.  Pick Shapefile format per your requirements and save the output to a familiar location. ... View more

I am not sure of your computer settings, but if you would like me to help with the code please provide an example of the original source file.  You said that you were altering the TXT files to become comma-delimited, so whatever you are running the script against is what I would need to start with.  It sounds like the script you wrote isn't quite right as it is truncating certain values or you are getting NULL returns on others.  It's possible that we could write some alternate Python that would convert your source file(s) directly to Shapefile format without having to produce an intermediate comma-separated file.  Without that, I can't troubleshoot your output file. ... View more

I first wrote a simple script to format the data as comma delimited. Just curious, is the file you provided the modified one from the script or is it the original?  Please provide the original if possible.  Which version of ArcGIS are you working with? ... View more

I'm happy to try and help you, but I'll need a bit more info from you first.  Please post the input file or at least a few sample lines of what the file contents look like. ... View more

I think it would be a bit easier (or at least, just as thorough) to do this with a Make Feature Layer followed by a Select By Attribute followed by a Copy Features.  Try something like this: # Make a feature layer of your input data, specifying only the fields you care about; this feature layer is stored in memory arcpy.MakeFeatureLayer_management(thePoint, "thePoint_selection", "", "", "POINTGUIDt POINTGUIt VISIBLE;S_FILE S_FILE VISIBLE;LINE_NBR LINE_NBR VISIBLE; OTHER_FIELD1 OTHER_FIELD1 HIDDEN; OTHER_FIELD2 OTHER_FIELD2 HIDDEN") # Create your selection set (assuming an attribute-based selection); the selection will persist in memory for subsequent tools while the script is still running arcpy.SelectLayerByAttribute_management("thePoint_selection", "NEW_SELECTION", "SOME_FIELD > 10000") # Write the in-memory feature layer to a physical feature class in an output file geodatabase, which should copy over only the fields you specified from the Make Feature Layer tool arcpy.CopyFeatures_management("thePoint_selection", "C:/E1B8/ScriptTesting/SelectbyAttributeAndExport/Actual/output.gdb/selection_set") ... View more

After re-reading through all of this thread, I'm wondering if the permissions here might be the problem.  For the two posts showing the Oracle error, the message indicates that the tables can't be found.  This is typically the case when the user account accessing the database can't "see" the tables because it does not have SELECT permissions on those tables or isn't assigned to a role that does either.  This leads me to ask the question: which user account is embedded within your SDE connection files when connecting to the Oracle geodatabase via your script?  Is it the SDE user, the schema owner (i.e., MDC or ARC), or some other user account?  If it is not the schema owner that is attempting the delete operation, that could the the problem right there.  Also, while the SDE user account should technically be able to see the tables, I don't think it would have rights to delete objects in another user-schema besides its own (unless the SDE user had a DROP ANY TABLE system privilege).  So, could you check to see if the user account specified in your connection file is the data owner or something else? ... View more

Glad it worked for you.  Please mark the correct answer; it will also help others with similar issues. ... View more