topic Re: Is there a way to queue and load multiple feature classes into a geodatabase in Data Management Questions

Is there a way to queue and load multiple feature classes into a geodatabase

OliverIshmael — Wed, 04 Mar 2020 18:58:18 GMT

Hello,

We have a regular need to update feature classes within a geodatabase with new data. This takes the following approach:

Open ArcMap

Add the QA_ feature class

Data Management Tools > Features > Delete Features

Drag in the data you want to load from ArcCatalog

Data Management Tools > General > Append

Set Schema to NO_TEST

We repeat this process 20-50 times.

Is there a way to automate this?

Many thanks

Asrujit_SenGupta — Thu, 05 Mar 2020 06:01:38 GMT

Yes. Write a Python script and schedule it to execute every 30min (decide time based on your requirement) using Windows Task Scheduler.

One suggestion: If you are deleting all records from the feature class, use the Truncate Table tool. That will be much faster.

JoshuaBixby — Thu, 05 Mar 2020 15:20:21 GMT

If Python coding is beyond your reach, you can also use What is ModelBuilder?—ArcGIS Pro | Documentation.