Latest Contributions by TedKowal

There are some alternatives ....  I will not say they are easier or better only cheaper if you are on a tight budget some of these are free or opensource.... At some point in time I have used all of the below.... ( I currently use Robohelp since now I have a software budget ) Sandcastle -- http://shfb.codeplex.com/ Help & Manual - The most popular help authoring and documentation tool HTML Help Workshop and Documentation from Official Microsoft Download Center KEL CHM Creator v.1.4.0.0 | Dumah's blog HelpScribble - Complete Help Authoring Tool - WinHelp hlp, HTML Help chm, Printed Manual and Web Help HelpNDoc | HTML help authoring tool, Word, PDF and eBook documentation generator Hope this helps for those on a tight budget...... ... View more

I am an old vb guy struggling to learn python..... for the challenge I attempted to get a python script to work as well..... Bear in mind this is probably sloppy python but it works.... def FindLabel ([TestChar]):   str = [TestChar]   i = str.find(chr(34))   if i > 0:     newStr = str[:i] + " inch"   else:      newStr = str   return newStr ... View more

I edited my previous post to remove quote (really skipping over it ) and shorten the label ... View more

....?....  Some ways of exiting a python script albeit not gracefully...  sys.exit() quit() os.exit() I am not a python programmer, but some pseudo code would go along these lines.  Ok, if at the point you are going to write the point file (differences)... It sound like you need to break up your python script into discrete functions then there would be no need to stop? .... def CheckForDifferences(args to do you differences):    ....    ...    ... get your record count return CountOfRecords def CreateFile( your args):    ... return def AddToMDX( your args):    ... return # Main part of your script if there are no differences then no file will be created no need to stop or exit prematurely. Difference = CheckForDifferences(args); if Difference > 0:   CreateFile(your args):   AddToMDX(your args); ... View more

Stephen, I am not a Python guy but in VB and C  I generally use a Record Count.  If the count is zero then exit the process else carry on. These Links my help you to do this in Python http://forums.esri.com/Thread.asp?c=93&f=1729&t=292293 https://community.esri.com/message/78638?sr=search&searchId=dee6a734-2d0e-42c9-8303-aab21bb2c2dc&searchIndex=19#78638 https://community.esri.com/message/56574?sr=search&searchId=46b59d5c-a090-4485-8904-48ce486d82c0&searchIndex=13#56574 ... View more

That was my intent ... so give you a starting point.  One more tip... when using access to develop your queries I would do it in multiple phases so that any errors can be isolated quickly... Problem set up... if there is no unique unchangeable ID in your GIS data I would create a field in the elevation data (GIS) that is unique and unchangeable.  This field will be used to link the developed sql queries back to the GIS so they may be seen in ArcGIS. MS Access: Create a query selecting the Top 5 (individual query) from the GIS data  -- save it in access Create a query selecting the Bottom 5  (individual query) from the GIS data  -- save it in access Make sure the above query includes all the same fields including the unchangeable ID field. Create a Union query combining #1 and #2 -- save it in access To see the results in ArcGIS, Add the Union Query to the ArcGIS map as a datatable (If you did not know, you can add a named access query to the ArcGIS Map).  Join the elevation gis data with the unique unchangeable ID with that same ID in the union query with matching ID's only.  The result map should now only show the Top 5 and Bottom 5 results. Hope this is helpful, Ted ... View more

The SQL expression to be used would be dependant upon your database. A SQL Server way of doing would follow this type of logic: Select Top 5 Min(ElevationFieldName) Elevation, ElevationID from TablewithElevation Union All Select Top 5 Max(ElevationFieldName) Elevation, ElevationID from TablewithElevation (Note that the number of fields and basic data types must be the same in both select statements.) Oracle does not have a Top function and would have to use embedded select statments with a where clause limiting the rows along with the Union.  (A bit more complicated -- plenty of examples on google) Access would be similar to SQL Sever This is what comes immediately to mind! ... View more

I only sent a simple example on how this could be accomplished with MS Access.  In the example, each facility can have an unlimited amount of chemicals.  The database only restriction is that each site can only have one entry for that one particular chemical but can have many different chemicals example ChemicalFacilitiesNeed Table Facility 1   -  chemicalA -- Quantity 5 Facility 1  -   chemicalB -- Quantity 1 Facility 1  -  chemical C  -- Quantity 10 .... Faciltiy 2 - chemicalA -- Quantity 100 Facility 2 - chemicalC -- Quantity 2 ... Facility 3 - chemicalC -- Quantity 3 ... The only restriction is that Facility 1 can only have one chemical of each type and the related quantities for that type Facility 1 is identified in the MasterTable chemical are identified in the chemical table Does this make better sense? ... View more

What Richard says is true, however, I do not find this a challenging thing to overcome (the price of the Highways Extension is).  A general rule, the events will change location if you added length to the beginning of the route or some sort of alignment has occurred.  When these conditions occur, I simply: Export the events to a feature class and calculate their XY coordinates Update my LRS Run a tool I developed in VB.NET  ArcObjects This tool snaps the Exported events feature class back to the new LRS. (This can be accomplished all through a manual process) Calculates the new measure Calculates the new offset (if any) Export the data back to a table with the new measures/offset (This will be the new event table).  In our shop most of our attribute data resides in databases outside of ArcGis. This is not really a hard process.... Our LRS rarely changes so this is not something I have to do a lot. ... View more

I am only guessing what your are asking .....   You will have to add a third table to track what chemicals each facility needs.  Pictured below is a relationship that was made to allow multiple chemicals of the same type to multiple facilities.  I also attached a working database with an example query called ChemicalsNeededByFacilities. Hope this helps, Ted ... View more

If you are using vbscript....make sure the field that this is being calculated to is a string. CStr([Field1]) & CStr([Field2])   It would help is you indicate the script snippet you are using to concatenate the two fields. ... View more

Using a Def Query you may want to try something like this ... Select ..... where DateDiff('h','Timestampdate', now()) > 3    (Note dates always get me confuse you may have to switch the Timestampdate and the Now() function. -- this will only work against an access database.) ... View more

MS Access doe not have a classical "Timestamp".  Generally one would create a macro or function to generate this data on a record in access.  MS SQL does have a Timestamp.  If you are wanting to process or use a comparative script/sql try passing the sql using a DB Pass-through query.  This would allow you to use all MS Access functionality instead of your DSN/ODBC translations (your database link?).   I believe you would then use the Access "Now()" function to compare the time values. This is all that comes to mind at moment -- hope this can lead you somewhere. ... View more