maddie

Automating Import of Files

Discussion created by maddie on Jan 5, 2016
Latest reply on Jan 5, 2016 by electon

A client wants to automate the self import of files into his database. I think I'm on the right track, but whenever I test the script, I keep on getting error 100 (File not Found). I know that's not right because when I open the folder the file is in there. They have multiple files to upload, but the variables are similar, here is what one looks like:

 

"filemac:Macintosh HD/Users/amk/Desktop/Client Files/" & Clients::Folder & "/" & Matters::Matter ID & "/" & "correspondence." & Matters::Matter ID & ".pdf"

 

In the finished version, the script will know wether the user is on a windows machine or a Mac and will populate the variable accordingly. Any of the variables will look like this when populated:

 

filemac:Macintosh HD/Users/amk/Desktop/Client Files/Able Studios/INV.800/correspondence.INV.800.pdf

 

I cannot change the file name as they want to keep their filenames consistent.

 

Below is the script that I'm working on:

Screen Shot 2016-01-05 at 10.14.29 AM.jpg

 

Any idea what is going wrong?

Outcomes