koolit5665 Posted November 15, 2016 Share Posted November 15, 2016 Hi guys/gals, Hope you might be able to help out here. We're working on Windows version of FM/FMS. When I create a client record I manually create a folder within our documents folder on the network and copy/paste the folder path into the folder field. It normally looks something like this: "\\SVR\Documents\CustomerName" When we create a job on the system an order acknowledgement PDF is emailed out to the customer and a copy of the order ack placed in the customers root directory (as above). This wasn't a problem when we first started with the FM solution but now we have hundreds of customers with dozens of Order Acknowledgements cluttering up the root customer directory. What I'd like to do is have FM auto create a directory, such as "\\SVR\Documents\CustomerName\OrderAcks" when the record is created. This I think I'm fine with for new records. I can work that out with a script step. I can probably work out a looped script to create the directory in all the EXISTING customer's folders but how would I go about moving all the existing OA's into the new folder via FM? All the OA's have the same naming schema such as "OA-12345.pdf" so doing a wildcard select may be a possibility. I was thinking something along the lines of: Move OA*.pdf <OA Folder> Any ideas guys/gals? Rick. Link to comment Share on other sites More sharing options...
webko Posted November 15, 2016 Share Posted November 15, 2016 FileMaker in and of itself doesn't really do 'move' - OS level scripting, or some of the various plugins may be able to assist with that. Personally, I'd just recreate all of them into the correct folders over a weekend, and probably also create a list of files generated to compare to the ones in the root directory to identify any that weren't recreated. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2846 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now