topic Re: Copying file names in folder directory to FGDB Table in Geoprocessing Questions

Copying file names in folder directory to FGDB Table

CraigPrisland2 — Thu, 05 Aug 2021 20:25:52 GMT

Hello,

I'm looking to build a Python script that will take the file names of PDFs in a certain folder directory and copy them to a new FGDB table. I am able to print these file names using the following simple script:

import os, arcpy arcpy.env.workspace = r'\\ch_gis\gis\......' files = arcpy.ListFiles() for f in files: print f

and get the expected outcome:

However, I am having troubles trying to copy these file names to an empty FGDB table. Any assistance would be appreciated.

Thanks,

Craig

Re: Copying file names in folder directory to FGDB Table

DavidPike — Thu, 05 Aug 2021 21:05:38 GMT

What do you mean by copy them exactly? as in just add the filepath strings to a column in the table? Does the table and column already exist? I'd say just an insert cursor.

Re: Copying file names in folder directory to FGDB Table

CraigPrisland2 — Thu, 05 Aug 2021 21:34:37 GMT

David,

To clarify, I do have a table and field already created. I'm looking to just copy the file names (i.e. WP20150014.pdf) to the table. Thanks for the suggestion of the insert cursor.

Re: Copying file names in folder directory to FGDB Table

DavidPike — Thu, 05 Aug 2021 22:04:57 GMT

untested

import arcpy import os arcpy.env.workspace = r'\\ch_gis\gis\......' files = arcpy.ListFiles() for f in files: print(f) fields = ['your field'] cursor = arcpy.da.InsertCursor(r'path to your table', fields) for f in files: cursor.insertRow((f)) del cursor

Re: Copying file names in folder directory to FGDB Table

CraigPrisland2 — Fri, 06 Aug 2021 21:17:46 GMT

Thanks David. This works great. The only change that I made to your code was to add brackets around 'f' so it read: cursor.insertrow([f])