Copy PDFs from publish subfolder to two other locations

[CALM]

Hi, I have a Publish folder that I always pdf to. I want to be able to then double click a batch file to copy the PDFs from the subfolder, within my publish folder, to a one drive folder and a box folder on my computer. I want the user to be asked the job number and file path of the one drive and box folder to be predetermined and the job number defines the folder then the suffix of the file path needs added . Eg

c/box/project/123 - job name /01 drawings/pdfs/1000 - ELEV

And

c/onedrive/02 - live project/123 - job name/07 - DRGS/PDFS/1000 - ELEV

OR

c/box/project/123 - job name /01 drawings/pdfs/2000 - PLANS

And

c/onedrive/02 - live project/123 - job name/07 - DRGS/PDFS/2000 - PLANS


My publish folder is set up


C/docs/_PUBLISH/COPY TOOL/

Then subfolders of

1000 - ELEV
2000 - PLANS
3000 - DETAILS

once I pdf drawings I drop them into the correct folder, I can’t automate using the pdf names as a lot of projects have there own specific number protocols so may not match ours but we want consistent folder structure. The idea is the batch file is in the COPY TOOL folder. When clicked it asks for job number then runs thru the COPY TOOL subfolders and making copies over the the relevant sub folders in onedrive and box.


I managed to get it to work but only if I hard write the specific folders and only from each subfolder but that’s not practical so I thought it must be possible to hardcode the file path prefix and suffix with just the middle bit of the file path being dynamic and based on user typing job name. For some reason only Robo copy worked with the onedrive path.

The job name folder will always be “job no - job name”

eg

235 - London Road

Or

497- Metro City

Thanks for any assistance you can give.

[pieh-ejdsch]

hallo Calm,

Are the file names formed according to any naming conventions that can be used for distribution?

Which files should be copied? All those that are NOT saved in C:\BOX? Or should the data to be saved be selected again separately?

c/box/project/123 - job name /01 drawings/pdfs/1000 - ELEV
c/onedrive/02 - live project/123 - job name/07 - DRGS/PDFS/1000 - ELEV

project=which identifier should this be? Will it remain the same? Manageable namespace?
/02 - live project=separate identifier? Will it remain the same? Manageable namespace?
01 drawings=what name is this? Does it always remain the same or does it have a manageable number of names?
07 - DRGS=The same questions as above.

You can already name the data at the workstation or put it into folder names so that the backup can run automatically. A list can also be created which is available for selection and the name parts can be inserted manually.

Phil