topic Re: Automate the data loading process in Python Questions

Automate the data loading process

eyadghatasheh — Thu, 26 Oct 2017 06:18:49 GMT

Hi Professionals

I have a central geodatabase with 30 buisness datasets inside. the same schema is shared with 30 contractors

. I receive data from those contractor daily and need to load the new features in their respective datasets inside the central geodatabase. again I need to copy the features from the contractor dataset to the central dataset under the central geodatabase. keep in mind contractors are not aggregating the features, but everytime their datasets will have only the new data.

how can I automate the loading process?

Re: Automate the data loading process

JoeBorgione — Thu, 26 Oct 2017 11:46:43 GMT

Take a look at the append tool; you sould be able to script it.

Re: Automate the data loading process

XanderBakker — Thu, 26 Oct 2017 13:05:24 GMT

As jborgion suggested the Append—Help | ArcGIS Desktop is definitely the tool you want to look at.

Questions;

is it easy to distinguish by the FDGB name between the different contractors?
there are no deletes just additional data to include in the central GDB?
do you need a mechanism to check if content from a contracor GDB is already present in the central GDB?

Re: Automate the data loading process

eyadghatasheh — Thu, 26 Oct 2017 14:46:23 GMT

there is no way to distinguish between contractors; and this is not required.

as you said; no deletes are there.

checking mechanism will be helpful specially due to the amount of data that I receive everyday and due to no of workers who work on seperate FGDBs.