Skip to main content
Dear FMErs

 

 I have a table that contains file paths of lots of features that I need to migrate. Is there a way to read the file paths from the table to load all of the needed features? Any thoughts? Suggestions?

 

 

Thanks in advance. Have a great day
Hi,

 

 

two alternatives:

 

 

- Read the file paths, send to FeatureReader

 

 

- Read the file paths, send to WorkspaceRunner and second workspace with parametrized input file name

 

 

David
David, hi. Thanks for your respond.  Any sugestions on  how to read the file paths? I was surfing the documentation but couldnt find  anything regarding this topic. I might be using the wrong key words. Thanks you for any input on how to read the tile paths
in the readers collection there is a "Directory and File Pathnames" reader.
Gio, thanks. I looked into this as well, with the directory and file path reader, the user needs to provide a file path, I have that file paths stored as attributes in a table. So far I have hit a wall.. Thanks for you for your suggestion 🙂
...filepath attribute... srry for bad grammar.
Hi Gerardo,

 

 

If you read multiple file paths from a table, you can create a concatenated paths string (delimiter is white space), and pass it to the source dataset parameter of the main workspace through the WorkspaceRunner.

 

Each path and entire string should be quoted like this.

 

""<path1>" "<path2>" "<path3>" ... "<pathN>""

 

If a path string doesn't contain spaces, it's not essential to quote it. But I think it's better to quote always individual paths to avoid unexpected conditions.

 

 

Takashi
Thanks David, Gio and Takashi. I got my workbench to work how I intended. Your ideas and approaches defenetly made me think outside the box. Now I have an mxd that formats the input  data and generates a text file that I can use for a quick copy past on the workbench that runs the process.

 

Thanks again, glad to be part of the community

Reply