My goal is to be able to batch process a folder of CSV tables to a geodatabase template. My process right now is CSV -> XY Event layer -> shapefile -> append to template geodatabase. But the problem is that some attribute are not added even though the column headers are the exact same in the CSV and the geodatabase.

My question is how would I get the schema of both the CSV and the geodatabase to match exactly so the process of appending is completely seamless?

Here is an example of what I need to match: enter image description here

All of the Target Fields have A Matching Source Field but it is not picked up automatically. I need it to be automatically matched while using append so that I can batch a folder of CSVs, rather than process them one by one.

  • Don't save the Event layer to Shapefile because it will truncate field names to 10 characters. Try appending the Geodatabase with the Event layer. If you must first save to disk before the Append, save to file geodatabase. – klewis Oct 27 '16 at 18:51

You need to save the event layer into a file geodatabase so that the longer field names are not truncated. Shapefile field names can only store 10 characters by default.

Here's a bit more info: How to bypass 10 character limit of field name in ShapeFiles?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.