topic Re: Uploading multiple CSV files from folder using code in ArcGIS Pro Questions

Uploading multiple CSV files from folder using code

OriHarash — Mon, 21 Mar 2022 09:22:18 GMT

I'm trying to read multiple CSV files to my arcGIS pro project.

The csv files consist x,y coordinated so I would like to upload them to the project and show them on the map, as happends when I upload the CSV file through the 'MAP'-->'Add Data'-->'X,Y Point Data'.

I do this action very often so I would like to automate it.

I'll be happy to get some guidance or a script to do so.

Tnx a lot

Re: Uploading multiple CSV files from folder using code

DanPatterson — Mon, 21 Mar 2022 09:41:49 GMT

There is sample code in the help, but it is for loading 1 file

XY Table To Point (Data Management)—ArcGIS Pro | Documentation

You can right-click on the tool in ArcToolbox and try it in batch mode

Then if you want a script, you can export to a script and modify it to suit your needs

Re: Uploading multiple CSV files from folder using code

JohannesLindner — Mon, 21 Mar 2022 09:57:08 GMT

When you do it manually, you open the tool XY Table To Point (Data Management)—ArcGIS Pro | Documentation.

To automate the process, you could use a script like this:

csv_files = [ "H:/test.csv", # etc. ] import os wkid = 25832 # the wkid of your coordinate system x = "X" y = "Y" z = None gdb = None # path to the database where you want to save the feature class. None: default gdb of your project for csv in csv_files: print(csv) name = os.path.basename(csv).split(".")[0] if gdb is not None: name = os.path.join(gdb, name) arcpy.management.XYTableToPoint(csv, name, x, y, z, wkid)