Latest Contributions by JamalNUMAN

Hi Jamal, At 8.x and 9.x, there used to be a great but simple tool that did just that (and a lot more). It was called "Geodatabase Reporter" and created an overview of all relevant settings in a geodatabase, like which Feature Datasets, Feature Classes, Topologies, versions etc. there were, including detailed information on field names and types. It also included access rights / privileges on datasets if I remember it well. It simply created an HTML page output showing all relevant data that could be printed for future reference. Now with 10.x, I can't easily find it anymore... maybe someone else knows if you can still get a working version of it. However, I do know there are two other unsupported but powerful geodatabase tools that may be of help to you: X-Ray for ArcCatalog (ArcGIS 10) ArcGIS Diagrammer for 10.1 See the pages for what they do, and more useful, download them and see if they are of help. Also, there is a video of X-Ray: Introduction to X-Ray for ArcCatalog There have been multiple pleas by different people to integrate much of these type of tools in core ArcGIS, and 10.1 indeed does include some of this functionality, but there still are things missing. Thank you Marco for the very useful information that you have provided. This is very helpful. I thought that there might be a �??built-in�?� functions that do this sort of work Best Jamal ... View more

To Jamal: I am working on a small PDF file with one figure / diagram that should clear up much of your, and other's, confusion around the "ESRI Geodatabase framework" (if I may call it so...) and all the components / applications involved. I hope to post it tomorrow in the "Why would I install ArcSDE with 10.1?" thread, as there is already a ton of good info by multiple contributors in that particular thread. Stay tuned. Marco Thank you Richard and Macro for the valuable comments. Yes please share it. Appreciated Till now I could summarize the following: Server machine: �?� Windows 7 �??server�?� �?� IIS �?� Sql server 2008 �?� ArcGIS Server 10.1 �?� ArcSDE 10.1 �?� ArcGIS Web Adaptor 10.1 Client Side �?� Windows 7 �?� ArcGIS Desktop 10.1 In this case �?� The users can access (depending on their credentials) the database through the �??add database connection�?� (choosing the database platform, instance and database) �?� Can access (depending on their credentials) the services or publish (mxd, loc, tbx, lyr, etc.) through the url: http://servername/arcgis/rest/services hope I'm right! ... View more

Hi Jamal, This is a typical editing question in a versioned ArcSDE (without using move edits to base option) environment. The situation you have seen is as expected. When you have reconciled and posted edits to the default version, the changes will show up in ArcGIS Desktop but not in your SQL Server business table side. Only when you have run a FULL compress for the ArcSDE geodatabase, then you will see the changes from the SQL Server business table as well. Here is a simple example explaining the versioning editing workflow. 1. You register a feature class as versioned, then that will create 2 new tables in database side, like A100 table and D100 table, the number 100 is the registration ID for that feature class, so A100 stands for Add table and D100 stands for Delete table. 2. When you edit the feature class in Default version from ArcMap, like Creating a new feature, then the feature will be added to the A100 table, but not to the business table. 3. So basically when you see edits from ArcMap for the Default version, you will see changes like following: features from business table + (plus) features in A table reflect to the Default version - (minus) features in D table reflect to the Default version 4. But when you see records from database side directly, you will only see features from the business (base) table. Please refer to the following web help document regarding how to achieve a FULL compress for your ArcSDE geodatabase. http://resources.arcgis.com/en/help/main/10.1/index.html#/The_geodatabase_compress_operation/003n000000s5000000/ Thanks, Ben L. An instructor provided me with a code (attached) that does the whole process �?� �??analyse dataset�?� �?� �??rebuild indexes�?� �?� �??compress�?� [ATTACH=CONFIG]20333[/ATTACH] The first time I applied it worked fine and the data in the sqle side is updated according to the ArcGIS side. I did further edits in the default version and applied the script again. Unfortunately, the changes were not reflected on the sql data [ATTACH=CONFIG]20334[/ATTACH] What might be the issue behind? Best Jamal ... View more

Thank you �??GIS Dev�?� for the help, Although my issue is extremely simple but I couldn�??t get sufficient resources to solve it. All what I need is to search �??in particular layer based on a field and to zoom to the selected�?�. That�??s all what I need. It is simple in �??ArcGIS Web Applications Manager�?� and this is what i expect in the "ArcGIS Viewer for Flex". Best Jamal I got the solution! An instructor provided me the way the �??Find�?� can be developed in the �??ArcGIS Viewer for Flex�?� Please, have a look on the screenshot below which contains the solution: [ATTACH=CONFIG]20326[/ATTACH], [ATTACH=CONFIG]20327[/ATTACH], [ATTACH=CONFIG]20328[/ATTACH] the issue now is how to develop the "select from list" query [ATTACH=CONFIG]20329[/ATTACH], [ATTACH=CONFIG]20330[/ATTACH] Best Jamal ... View more

Derek said "Both are server-side software" which implies that they only need to be installed on servers (i.e. not clients). ArcMap includes "ArcSDE technology" which implies that no additional installation is required on the clients. Thank you Richard. �?� In case of ArcGIS Server: I couldn�??t figure out how the �??end user�?� who has the ArcGIS Desktop installed in his/her machine will be able to publish, for example, an mxd file? I think in this case the option �??share as service�?� will be greyed out. [ATTACH=CONFIG]20324[/ATTACH] �?� In case of ArcSDE: if we are still able to pop up the dialogue box of the �??database connection�?� then it is logic that we can then access the data on the server without having the ArcSDE installed on the end user machine [ATTACH=CONFIG]20325[/ATTACH] �?� How about the SQL server? Do we need to install it on the server only or also at the end user machines? Best Jamal ... View more

Hi Jamal, FYI, in ArcGIS for Desktop 10.1 there is a new Geodatabase Administration dialog box that provides geodatabase administrators with the ability to monitor and manage user connections, locks, and versions. What's new for geodatabases in ArcGIS 10.1 (look under the New ArcGIS tools to administer enterprise geodatabases section) Hope this helps, Thank you Derek for the answer, My issue here is to have a list for all users of a particular connection for whom an access to the data is created using the tool �??create database usre�?� [ATTACH=CONFIG]20322[/ATTACH] The �??geodatabase administration�?� dialogue box shows only the users who are currently connected BUT doesn�??t show all the users (when they are not connected to database) and who have originally the right to access the database. They will not be shown just because they are disconnected! [ATTACH=CONFIG]20323[/ATTACH] Then the �??geodatabase administration�?� dialogue box includes the current connections but not all the users who have the right to connect. Best Jamal ... View more

Hi Jamal, You would typically install ArcGIS for Server and ArcSDE technology on server-side machines to enable a GIS server and an ArcSDE geodatabase, respectively. Both are server-side software. Regarding ArcSDE technology - you can have it on client (end user) machines when they use ArcGIS for Desktop. This relates to making "direct connections" to your geodatabase (as mentioned in Kim's post earlier in this thread), instead of using an ArcSDE application server connection. FYI, Enterprise Geodatabase 101 ArcUser article (look under the section "Type of Client Connections") Esri is now actively promoting the "Direct Connection" model when connecting to an ArcSDE geodatabase. Hope this helps, Many thanks Derek for the very useful information you have provided. Then still we need to install the ArcSDE (in addition to its installation on the server) in each machine of the users who are supposed to connect (direct connection) to the database on the server. Is this correct? How about the ArcGIS Server? Do we still need to install it (in addition to its installation on the server) in ALL the machines of the users who are supposed to publish? Best Jamal ... View more

Hi Jamal, These 3 connections can all be used when you are accessing a local machine for your ArcSDE Workgroup/Personal geodatabases. .\sqlexpress localhost\sqlexpress computername\sqlexpress Alternatively, you can also use the dynamic TCP/IP port number for the SQL Express instance, for example: computername,8774 We would recommend to use the following format so that it's clear to which machine and which named instance you are going to connect. computername\sqlexpress Thanks, Ben L. Thank you Ben for the answer. It is quite clear now. All the best Jamal ... View more

Hi Jamal, You can use another GP tool -> Enable Enterprise Geodatabase to create ArcSDE geodatabase system tables, stored procedures, functions, types and etc. In that case, you can previously design the Oracle tablespace/datafile locations to any physical directories that you want. Please refer to following web help documents for more details. -> Enabling geodatabase functionality in an Oracle database http://resources.arcgis.com/en/help/main/10.1/index.html#/Enabling_geodatabase_functionality_in_an_Oracle_database/002n000000t9000000/ Thanks, Ben Thank you for the contribution Ben, I�??ll try it and see if it works with me. Basically, my understanding for the �??Enable Enterprise Geodatabase�?� is that it is used in case we have an existing database (oracle/sql server/etc.) and it is required to supply them with the repository tables! And in this case it has nothing to do with the location of the Oracle database, for example. As for the sql database, this is quite simple. At the end of the day, the database is simply a file that can be attached to any sql server and thin connected to the ArcGIS. Best Jamal ... View more