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

Import CSV files based on Field Name in Feature Dataset

Paul_Duffy_Waters_of_LIFE

Hi,

I have a Feature Class which shows the extent of a number of associated CSV files containing DTM points. Using a select by location query, I have created a second feature class which contains a subset of those CSV files I want to import to a GDB.

My question is, is there a way to import CSV files based on the field name in the feature class so I only import those CSV files?

Thanks,

Paul

Find more posts tagged with

Accepted answers

Paul_Duffy_Waters_of_LIFE

I ended up doing this in a roundabout fashion as I hadn't received the above suggestions in time.

I used the selection from the Feature Class to create a text file containing a list of the files I wanted called "PullFiles.txt"

I created a new folder called "HSO_WB_Files" and used PowerShell to copy the relevant files to that folder using the below script found online:

I batch imported all the CSV files into a GDB.

I then used a Model to Iterate through all the files and create XY point files from each

The suggestions by Bob and Dale are more elegant, but this worked anyway.

All comments

BobBooth1

You could make a list of the table names and use Python to iterate over the list and add the tables to the map.

https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/table.htm#:~:text=script%20will%20add%20a%20table

Dale_Honeycutt

Another way to do this is within ModelBuilder. ModelBuilder has the Iterate Row Selection and Iterate Field Value iterator which you could use to grab the value of the CSV REF field into a model variable. You could then use inline substitution with this model variable to construct the pathname to the CSV file, then feed that pathname into the Table To Table tool to create a .gdb table.

This topic explains all the iterators available to you.

Paul_Duffy_Waters_of_LIFE

Thanks Bob, thats' a good solution

Paul_Duffy_Waters_of_LIFE

Thanks Dale, that would work alright!

Paul_Duffy_Waters_of_LIFE

I ended up doing this in a roundabout fashion as I hadn't received the above suggestions in time.

I used the selection from the Feature Class to create a text file containing a list of the files I wanted called "PullFiles.txt"

I created a new folder called "HSO_WB_Files" and used PowerShell to copy the relevant files to that folder using the below script found online:

I batch imported all the CSV files into a GDB.

I then used a Model to Iterate through all the files and create XY point files from each

The suggestions by Bob and Dale are more elegant, but this worked anyway.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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