So close but could use some help

[sk8shorty01]

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

[Stefan]

Hi Mike, welcome!

- open XYplorer and locate the root of your share
- type this in the XYplorer address bar
!echo Please wait & dir /B /S *.pdf > xyPDFlist.txt & echo All done.

Press ENTER and wait till you see "All done."
Then you will find an new "xyPDFlist.txt" (i hope you have write access there?)



-----------

An other way takes more time to explain then doing it:

- browse to your top most folder
- open "Windows > Show Info Panel"
- open the [Find Files] tab and set:
Name: pdf ; All Types ; Mode: Standard ; [X] Include subfolders
Attributes: [X] Not Directory

- click at [Find now]

Wait till the search is ended.
- click in the list at the found files
- press Ctrl+A to select all
- use menu "File > To Clipboard > Item Path/Names"

- open notepad and paste in
or right click into an folder and chose "Paste Special > Paste Text into new file"

----------------

And if you can use scripting with XYplorer you can use an script like this to do smtg with the result:

(It had take some time to build this script. Still non easy for beginners
to do this with XY scripting because listfolder() is not recursive by nature at its own )

Code: Select all

  //////We use this XYplorer scripting commands:
  //////folderreport([type=dump], [target=clipboard], [folder], [flags], [outputfile])
  //////listfolder([path=<curpath>], [pattern=*], [flags], [separator="|"])



  //////Get an list of all subfolders:
  $startfolder = "<curpath>";
  $folders = folderreport("dirs", "return", $startfolder, "r");


  ////// For Each Folder In Folders Do
  $result="";
  foreach( $folder, $folders, "<crlf>")
  {
      //////IF the search for *.PDF succeeds, store the result into an var:
      $exist = listfolder( "$folder", "*.pdf", 1, "<crlf>");
      if ($exist != "") { $result = $result . $exist . "<crlf>" };
      status Processing $folder;
  }

  //////At the end inform the user:
  status All done!
  beep 200, 600;   beep 300, 100;
  text $result; 

Now you can choose, or wait till someone provide something better.