We have an MIS system were I can export to a text file the job numbers closed in a certain time frame.
Based on this I am wanting to find, buy, or program a solution to move the closed jobs in our "Jobs"/"Client Folder" to an archive folder so an operator can manage what needs to be archived or deleted. The job folders always start out with the job number but the rest of the name is based on the operators naming convention, which is how we like it.
I was starting to look at VBScript (Windows) to do this. The reason for VBScrpt is, in the past I had an Applescript programmed to rename 500+ files based on a text file containing the name before and after. This script took between 30 to 60 minutes to complete. I found a similar solution with VBScript which completed in about 2 minutes.
I figured we are not the only company in this situation. So I thought I would ask and see if anyone else needs this or has done or found something like this already.
Thanks,
Brian
Based on this I am wanting to find, buy, or program a solution to move the closed jobs in our "Jobs"/"Client Folder" to an archive folder so an operator can manage what needs to be archived or deleted. The job folders always start out with the job number but the rest of the name is based on the operators naming convention, which is how we like it.
I was starting to look at VBScript (Windows) to do this. The reason for VBScrpt is, in the past I had an Applescript programmed to rename 500+ files based on a text file containing the name before and after. This script took between 30 to 60 minutes to complete. I found a similar solution with VBScript which completed in about 2 minutes.
I figured we are not the only company in this situation. So I thought I would ask and see if anyone else needs this or has done or found something like this already.
Thanks,
Brian