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
Solved
Add data from a table containing file paths
Dear FMErs
Best answer by takashi
Hi Gerardo,
View original
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
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
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 :)
- Best Answer
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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.