So close but could use some help
Posted: 29 Jun 2011 20:11
I am trying to gather a list of all of the .pdf files we have on our server. We need to document the full file path (example - S:\...) starting from the point of the server designated "drive" letter all the way to the .pdf extension.
I am sure there is a way to get the export tool to work that way but I have a couple issues depending on which way I attempt to go about it.
- If I use current folder as report type
- I get the full file path but it does not go off my searched findings (all .pdf) instead it includes everything from the folder.
- It exports the path, size, modified date all into one column. In all reality all I need is the file path, the rest is going to be deleted anyways.
- If I use current list as report type
- It only includes the .pdf that I found in my search which is what I want
- It does not supply the entire file path, instead it starts from the browse point where the search was started from. It also does not include the file name with the extension
The general file structure is as follows:
Site (location as in city)
Building Number
Subfolders
We have all the .pdf files that relate to each building under their respective building folder. Also we have built an excel database under each building folder that lists all of the drawing names as well as the attributes that are associated with those files (floor plan, architectural, location, etc.). One attribute that we originally did not include that we have decided to add is the file path of each .pdf file, which would be added to our excel database. I am trying to run a report that shows each .pdf file path building by building and then copy-paste the data into our excel list. Because we have a seperate excel list for each building I would like to make it as easy as possible to copy a batch of paths and paste them.
Is there any way that this program could solve the little issues I am having? If I blend the two search options together it would be perfect, each has a few things that make it difficult for me to take the information and be able to save time.
If I could get just the entire file path like the "Current Folder" search allows (without size or date) on just the .pdf files like the "Current List" allows it would be absolutely perfect.
If you have any help at all it would be greatly appreciated, I have been attempting to get this accomplished for a few days now and I cannot seem to find anything that works better than this program, there are just a few things I would like to weed out that I cannot seem to figure out how to do.
Thanks!
Mike Bauer
I am sure there is a way to get the export tool to work that way but I have a couple issues depending on which way I attempt to go about it.
- If I use current folder as report type
- I get the full file path but it does not go off my searched findings (all .pdf) instead it includes everything from the folder.
- It exports the path, size, modified date all into one column. In all reality all I need is the file path, the rest is going to be deleted anyways.
- If I use current list as report type
- It only includes the .pdf that I found in my search which is what I want
- It does not supply the entire file path, instead it starts from the browse point where the search was started from. It also does not include the file name with the extension
The general file structure is as follows:
Site (location as in city)
Building Number
Subfolders
We have all the .pdf files that relate to each building under their respective building folder. Also we have built an excel database under each building folder that lists all of the drawing names as well as the attributes that are associated with those files (floor plan, architectural, location, etc.). One attribute that we originally did not include that we have decided to add is the file path of each .pdf file, which would be added to our excel database. I am trying to run a report that shows each .pdf file path building by building and then copy-paste the data into our excel list. Because we have a seperate excel list for each building I would like to make it as easy as possible to copy a batch of paths and paste them.
Is there any way that this program could solve the little issues I am having? If I blend the two search options together it would be perfect, each has a few things that make it difficult for me to take the information and be able to save time.
If I could get just the entire file path like the "Current Folder" search allows (without size or date) on just the .pdf files like the "Current List" allows it would be absolutely perfect.
If you have any help at all it would be greatly appreciated, I have been attempting to get this accomplished for a few days now and I cannot seem to find anything that works better than this program, there are just a few things I would like to weed out that I cannot seem to figure out how to do.
Thanks!
Mike Bauer