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; } } }

Model Builder not Appending Data Correctly ?!

TimDunlevie2

Hi guys,

I'm using ArcGIS 10.2...and I'm getting some frustrating results using Model Builder to append data to a Feature Class within a FGDB.

I have 6 datasets (a mix of shapefiles and FC in a FGDB)

The steps I perform in the model include:

1. add fields to these datasets

2. calculate fields

3. append to a "master" FC in a FGDB using schema type "NO_TEST" and field map the various fields from the input datasets to the Target.

for some reason the data is not appending correctly. The field mapping looks correct.

I've deleted features from the Target FC (empty FC) and tried appending over again, yet the same (wrong) fields map to the target fc.

is it holding this data in memory ???

Is MB always so buggy ?

many thanks,

Tim

Trouver plus de publications taguées avec

Accepted answers

All comments

curtvprice

I think it's important not to ask too much more of Model Builder than the environment is designed to support. If your workflow is complex (as in this example, where field mappings must be modified on each run based on the inputs), you may have to go to Python scripting. Even then, prototyping the process in ModelBuilder can save you a lot of time if the workflow and tools are complicated.

CaryLancaster

100% agree with you Paul. it is 2018 and still the bugs are there.

TimDunlevie2

Thanks mate.

In the end I converted to a python script instead….MB was doing my head in.

Tim

curtvprice

Field mappings are a little problematic in ModelBuilder because they are set up so they can be user-edited within the MB edit mode. If you change the inputs, those field maps don't always update unless the model is re-validated, and event then if you've done edits to the field map it tries to keep it around.

I have worked around this by using code to create field maps at runtime inside the Calculate Value tool. Not an easy or elegant solution.

TimDunlevie2

Thanks Paul.

I might revert to a python script instead…as I know this works !!!

PaulLohr

Tim,

I am also frustrated by the bugs in Modelbuilder. It has been around long enough that a lot of these problems could be corrected by now. It is rare that I build a Modelbuilder process and it simply works without research time and a call to tech support.

DarrenWiens2

It looks like plenty of other users are experiencing the same thing with field mappings in ModelBuilder. Working alternative seems to be to implement in Python, which may or may not be a significant time commitment for you.

TimDunlevie2

Yep – tested this.

All I am doing is adding 6 shapefiles/FCs to MB.

Adding a few fields to each.

Updating the metadata…

Then appending to a blank FC….field map to the relevant fields.

I was just curious to see if anyone else have had a similar experience.

Thanks

DarrenWiens2

Does it work as expected outside of ModelBuilder?

TimDunlevie2

Hi Paul,

Thanks for the suggestion….I will give it a go.

Seems strange that Model Builder is very buggy.

Tim

PaulLohr

If you are still working on this, you might want to look for a different approach. Maybe try Copy Features then append that result into your master feature class. Maybe try Make Feature Layer then append. Things simply don't work right in modelbuilder and this is how I have been able to make things work.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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