Latest Contributions by Henryobaseki

‎01-11-2018

I know its obsolete my company still have an application built on this old version

‎01-11-2018

Hi All, Currently using old version of Flex. version 1 I think. What I want to get to is when an my application page is launched and app opens the first thing to be seen is the splash widget, user clicks to continue. Have tried to referenced the splash as the main Application config. see below, How ever not splash does not show when application is launced  <geometryservice url="https://gbepabz-apgis01.main.glb.corp.local/ags/rest/services/Utilities/Geometry/GeometryServer" /> <splashpage label="ArcGIS Viewer for Flex" config="com/total/ep/gisep/widgets/splash/SplashWidget.xml" url="com/total/ep/gisep/widgets/splash/SplashExtWidget.swf" />  <widget right="75" top="100" config="widgets/Navigation/NavigationWidget.xml" url="widgets/Navigation/NavigationWidget.swf"/> <widget right="-2" bottom="-2" config="com/total/ep/gisep/widgets/overviewMap/OverviewMapWidget.xml" url="com/total/ep/gisep/widgets/overviewMap/OverviewMapWidget.swf" /> <widget right="5" top="65" config="com/total/ep/gisep/widgets/mapSwitcher/MapSwitcherWidget.xml" url="com/total/ep/gisep/widgets/mapSwitcher/MapSwitcherWidget.swf" /> <widget left="0" top="0" config="com/total/ep/gisep/widgets/headerController/HeaderControllerWidget.xml" url="com/total/ep/gisep/widgets/headerController/HeaderControllerWidget.swf" /> <widget left="3" bottom="3" config="config/applications/seismic_viewer/widgets/CoordinateWidget.xml" url="com/total/ep/gisep/widgets/coordinate/CoordinateWidget.swf" />  <widget left="0" top="60" config="com/total/ep/gisep/widgets/tocFix/TocFixWidget.xml" url="com/total/ep/gisep/widgets/tocFix/TocFixWidget.swf" />  Thanks for your help!

‎11-21-2017

Thank you, it works!

‎11-21-2017

Morning Xander, ran the script Runtime error Traceback (most recent call last): File "<string>", line 16, in <module> NameError: name 'oid' is not defined

‎11-20-2017

your code works fine, I just replaced state with Field_name that's all. I have field_Name and RESID as field attributes in both tables But what I want to achieve is... if fid_RESID in tbl 1 equals or matches the fid_RESID in tbl2 then update fid _Field_Name in tbl2

‎11-20-2017

If I want to add another field RESID to the search cursor I ' m stuck at dct see below ...... import arcpy from arcpy import env env.workspace = r"C:\Users\L0505857\Data" tbl1 = "Updated_subset.dbf" tbl2 = "airports_old.dbf" fld_oid = "OID" fld_FIELD_NAME = "FIELD_NAME" fld_RESID = "RESID" dct = {r[0]: r[1] for r in arcpy.da.SearchCursor(tbl1, (fld_oid, fld_FIELD_NAME,fld_RESID))} with arcpy.da.UpdateCursor(tbl2, (fld_oid, fld_FIELD_NAME,fld_RESID)) as curs: for row in curs: oid = row[0] FIELD_NAME = row[1] if oid in dct: row[1] = dct[oid] curs.updateRow(row)

‎11-20-2017

Thanks Xander, I was looking at the wrong table. Code works!

‎11-20-2017

OID OBJECTID ID FIELD_NAME KEY_WELL WATER_DEPT BASIN_NAME TOT_RECOVE HC_TYPE OVP_bar Res_Age Formation Lithology RESID Regional_s >>>

‎11-20-2017

The two tables have state and OID RESID attributes I want to use the state field attributes in Updated-subset.dbf to update the state field attribute in airport.dbf which is currently empty I want the update to occur if the OID and the RESID in both tables match. I m still getting the same runtime error Thanks for your help

‎11-20-2017

Hi Xander, I keep getting runtime errors >>> import arcpy ... from arcpy import env ... env.workspace = r"C:\Users\L0505857\Data" ... ... tbl1 = "Updated_subset.dbf" ... tbl2 = "airports_old.dbf" ... ... fld_oid = "OID" ... fld_state = "state" ... ... dct = {r[0]: r[1] for r in arcpy.da.SearchCursor(tbl1, (fld_oid, fld_state))} ... ... with arcpy.da.UpdateCursor(tbl2, (fld_oid, fld_state)) as curs: ... for row in curs: ... oid = row[0] ... state = row[1] ... if oid in dct: ... row[1] = dct[oid] ... curs.updateRow(row) ... Runtime error Traceback (most recent call last): File "<string>", line 11, in <module> File "<string>", line 11, in <dictcomp> RuntimeError: A column was specified that does not exist. >>>

‎11-16-2017

From the script below can my sql statement be to update State in fc2 = "airports_old.dbf" if Field 1 and Field 2 in ... fc = "Updated_subset.dbf" matches withField 1 and Field 2 in airports_old..dbf" import arcpy ... from arcpy import env ... env.workspace = "C:\\Data" ... print 'Processing...' ... fc = "Updated_subset.dbf" ... cursor = arcpy.da.SearchCursor(fc, ["OID"]) ... for row in cursor: ... SQL_stat= "OID = "+ str(row[0]) ... fc2 = "airports_old.dbf" ... cursor2 = arcpy.da.SearchCursor(fc, ["STATE"], SQL_stat) ... for row2 in cursor2: ... UpdatedValue = row2[0] ... cursor3 = arcpy.da.UpdateCursor(fc2, ["STATE"],SQL_stat) ... for row3 in cursor3: ... row3[0] = UpdatedValue ... cursor3.updateRow(row3) ... del row ... del cursor ... del row2 ... del cursor2 ... del row3 ... del cursor3 ...

‎11-16-2017

Hi Dan, I have Table 1 with fields - Top, Base, Names, and State all have contents I have Table 2 with fields - similar contents Top, Base, Names, and State, but the state needs to be updated with the state content in table 1 A script to update state in table 2 if Top, Base and Names Match with table 1 if no match do something not sure if the sql statement above will help

‎11-16-2017

import arcpy ... from arcpy import env ... env.workspace = "C:\Users\L0505857\Data" ... print 'Processing...' ... fc = "Updated_subset.dbf" ... cursor = arcpy.da.SearchCursor(fc, ["OID"]) ... for row in cursor: ... SQL_stat= '"{}" = \'{}\''.format("field", row0) ... fc2 = "airports_old.dbf" ... cursor2 = arcpy.da.SearchCursor(fc, ["STATE"], SQL_stat) ... for row2 in cursor2: ... UpdatedValue = row2[0] ... cursor3 = arcpy.da.UpdateCursor(fc2, ["STATE"],SQL_stat) ... for row3 in cursor3: ... row3[0] = UpdatedValue ... cursor3.updateRow(row3) ... del row ... del cursor ... del row2 ... del cursor2 ... del row3 ... del cursor3 ... ... print "Done"

‎11-16-2017

Hi Dan, so how do I add this script to the above one. Thanks for your help

‎11-16-2017

Hi Darren, >>> import arcpy ... from arcpy import env ... env.workspace = "C:\Data" ... print 'Processing...' ... fc = "Updated_subset.dbf" ... cursor = arcpy.da.SearchCursor(fc, ["RESID"]) ... for row in cursor: ... SQL_stat= "RESID = "+ str(row[0]) ... fc2 = "airports_old.dbf" ... cursor2 = arcpy.da.SearchCursor(fc, ["Regional_s"], SQL_stat) ... for row2 in cursor2: ... UpdatedValue = row2[0] ... cursor3 = arcpy.da.UpdateCursor(fc2, ["Regional_s"],SQL_stat) ... for row3 in cursor3: ... row3[0] = UpdatedValue ... cursor3.updateRow(row3) ... del row ... del cursor ... del row2 ... del cursor2 ... del row3 ... del cursor3 ... ... print "Done" ... Processing... Runtime error Traceback (most recent call last): File "<string>", line 11, in <module> RuntimeError: A column was specified that does not exist. see the runtime error Thanks

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

My Ideas

Latest Contributions by Henryobaseki

Re: splash widget old version

splash widget old version

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: update attribute table from another table based on a query

Re: Update attribute table using Arcpy

Re: update attribute table from another table base...

Update attribute table using Arcpy