Automation of Naming Windows Folders

[Joseph31]

Is there a way to make a script that will make a folder on windows and name it something custom from the database?

ie: (Full Name) (Policy Number)

[normanicus]

Go here:

http://www.databasepros.com/resources.html

and search for 'folder 2' and download the windows version of the file. Should give you some ideas.

[Joseph31]

Thank you for the Link --- funny thing it makes a zip file not a folder but it may still work --- do yo know of any other links that I could look at to make a new folder on the desktop? Of course with a custom name from filemaker?

Thank you,

Joseph

[_henry_]

Hi Joseph,

If you still cannot find it and you prefer to use plugin, here is the website "Moo Plugin" (free plugin). The explanation: Folder Create

Download Moo plugin in here: Moo Plugin Download

Hope that helps...

[Joseph31]

Great thank you -- I will check it out.

Joseph

[aholtzapfel]

There is another way, no plug-in, no problem.

Filemaker (on windows) has a Nifty little script step call "Send Event" that sends commands to the run line of windows. From the run line you can do all sorts of things including creating folders and paths. Attached is a sample of this. I have attached the "send event" script step to a button and it will create a folder with the name and path that you choose.

CreateFolder.zip

[aldipalo]

I just went through this and found , on the forum, the VBScript Repository. It is a database of every conceivable, in my ability to conceive, VBScript. Here's one to create a new folder:

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFolder = objFSO.CreateFolder("C:FSO")

However, I like Al's example as you can chose your folder path and name and do not have to hard code it. Since I'm not a VB Guru (Not even a novice) this gives more flexibility. Perhaps someone with more VB knowledge can tell us how to create the folder name from a variable?

[_henry_]

Hi aholtzapfel,

It is a good idea creating a Folder without plugin. Your way is using "send event." But, can we capture the error from "send event," for example, if the folder is already exists, or the folder cannot be created because of privilege issue?

TIA for your response

[aholtzapfel]

No there is not a way to capture an error using the send event command. It can still be done without a plug-in by creating a vbs script to do it. By using the script you could capture errors, create a text file and write the error to it, then call a Filemaker script to import the text file to get the result of the vbs script. This is a lot more work but is still free (except for your time). There are disadvantages to using VBS and you can run into security issues (as they are often blocked by system administrators). I could throw something together that would do this (4-5hrs to completely build and check a solution) but depending on the number of users that need this and your familiarity with vbs and Filemaker, It may make sense to use a plug-in. If you decide to use VBS I can point you in the right direction.

[_henry_]

Hi aholtzapfel ,

Thank you for your explanation. About VBS Script, I am not the one who ask the question, but I would like to see it happens. If I was not mistaken, aldipalo is the one who asked about VBS.