Hi, using ArcMap 10.5. look i want to simply load the data from one gdb to other gdb... but on my first attempt the geometry of polygons and lines was not uploaded. I read in the forums that i needed to include the "SHAPE@". I tried as such, but the result is bad... i cannot understand how to fix it. The error message is: AttributeError: 'unicode' object has no attribute editable. can someone suggest me something? cheers P env . workspace = datasets [ 0 ] fcs = arcpy . ListFeatureClasses ( ) for fc in fcs : #print '\t', fc count = count_records ( fc ) # counts the features within each FC if count <> "0" : listfields = arcpy . ListFields ( fc ) for l in range ( len ( listfields ) ) : ## listfields = listfields .name ## print listfields listfields = [ f . name for f in listfields if f . editable and f . type != "Geometry" ] + [ "SHAPE@" ] with arcpy . da . SearchCursor ( fc , listfields ) as cur : with arcpy . da . InsertCursor ( GDBDwgs + "\\" + fc , l ) as icur : for row in cur : print '\t' , fc icur . insertRow ( row ) del icur del cur

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

using cursor to load data

PSGeo

Hi,

using ArcMap 10.5.

look i want to simply load the data from one gdb to other gdb... but on my first attempt the geometry of polygons and lines was not uploaded. I read in the forums that i needed to include the "SHAPE@". I tried as such, but the result is bad... i cannot understand how to fix it. The error message is: AttributeError: 'unicode' object has no attribute editable.

can someone suggest me something?

cheers

        env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> datasets<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        fcs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

        <SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcs<SPAN class="punctuation token">:</SPAN>
            <SPAN class="comment token">#print '\t', fc</SPAN>
            count<SPAN class="operator token">=</SPAN>count_records<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>   <SPAN class="comment token"># counts the features within each FC</SPAN>
            <SPAN class="keyword token">if</SPAN> count<SPAN class="operator token"><></SPAN><SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">:</SPAN>
                listfields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
                <SPAN class="keyword token">for</SPAN> l <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>listfields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="comment token">##                    listfields<L> = listfields<L>.name</L></L></SPAN>
<SPAN class="comment token">##                    print listfields</SPAN>
                    listfields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> listfields <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>editable <SPAN class="operator token">and</SPAN> f<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">!=</SPAN> <SPAN class="string token">"Geometry"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"SHAPE@"</SPAN><SPAN class="punctuation token">]</SPAN>
                <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN>listfields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>

                    <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>GDBDwgs <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> fc<SPAN class="punctuation token">,</SPAN> l<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> icur<SPAN class="punctuation token">:</SPAN>

                        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
                            <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\t'</SPAN><SPAN class="punctuation token">,</SPAN> fc
                            icur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="keyword token">del</SPAN> icur
                <SPAN class="keyword token">del</SPAN> cur
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Vind meer berichten getagd met

Accepted answers

jskinner

Hi Pedro,

You could use the truncate and then append tool to load the data from one feature class to another. First execute the truncate so that you will not append duplicate features.

All comments

CaseyFrost

Your code is hard for me to read but I had a similar issue and I solved it by placing the 'Shape@' field in my list of fields for the insert cursor, as well as in my list of fields for the search cursor.

new_fields = [field.name if field.name != 'Shape' else 'Shape@' for field in arcpy.ListFields(new_path)]
old_fields = [field.name if field.name != 'Shape' else 'Shape@' for field in arcpy.ListFields(old_path)]

PSGeo

I tried the append... but it gave this error:

Traceback (most recent call last):
File "\\eusc.europa.eu\ATLAS\Home\psoares\Documents\python\filesupporttools\CopyfGDBtGDB_append_version.py", line 63, in <module>
arcpy.Append_management(fcs,GDBDwgs,"NO_TEST","","" )
File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\management.py", line 4271, in Append
raise e
ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000840: The value is not a Table View.
ERROR 000840: The value is not a Raster Layer.
Failed to execute (Append).

fcs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>


        <SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcs<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\t'</SPAN><SPAN class="punctuation token">,</SPAN> fc
            count<SPAN class="operator token">=</SPAN>count_records<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>   <SPAN class="comment token"># counts the features within each FC</SPAN>
            <SPAN class="keyword token">if</SPAN> count<SPAN class="operator token"><></SPAN><SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">:</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>fcs<SPAN class="punctuation token">,</SPAN>GDBDwgs<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN> <SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

this is really hard

DanPatterson_Retired

the equivalent tools exist in arcmap

jskinner

Hi Pedro,

You could use the truncate and then append tool to load the data from one feature class to another. First execute the truncate so that you will not append duplicate features.

PSGeo

Hi Dan,

thanks for the feedback. But the links are all for arcgisPro, it's not my case. Plus, I have already a destination GDB with feature classes inside. my goal in the end is that i run the script for several gdbs that will feed a single gdb (existing one not creating a new one).

DanPatterson_Retired

There is no need to do things through a cursor.

If you have a need to copy featureclasses from one gdb to another and you want to do it with some changes in the output name perhaps, look at existing tools and their code examples.

Do recognize that many tools can be 'batched' without coding.

Copy—Data Management toolbox | Documentation

Feature Class to Feature Class—Conversion toolbox | Documentation

Examine the existing tools within the Tools structure, particular those in the Conversion and Data Management toolsets.

Anatomy of a tool reference page—ArcGIS Help | Documentation

Code examples ... if needed at all ... are contained within

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.