Create Named Folder on Desktop (PC)

[Rich]

Greets, and a happy, holiday season to all.

This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command: 

"cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" )

...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, "[3] Command is unavailable (for example, wrong operating system or mode)".

So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix?

Cheers,

Rich

Edited November 18, 2018 by Rich

[siroos12]

 Have you tried "Create directory" option on "Export Field Contents" or "Export records" in FileMaker 17  instead of "Send Event? 

https://fmhelp.filemaker.com/help/17/fmp/en/index.html#page/FMP_Help/export-field-contents.html

Export Field Contents [ Create directories:Yes ]
Export Records [ Create directories:Yes ]

 

 

 

[Rich]

Hi, Siroos:

I tried that (enabling Create Directories) but ran into the problem of setting the path, even with the basic Get (DesktopPath)--I get an error message (See attached.)

Even if I can get it to work, I don't see how it will create a folder on the desktop but that could be because I'm being extraordrinarily dense...which is more dense than usual. : )

[siroos12]

Can you type the path you used here so we can have a better idea?

 

[Rich]

It's pretty straightforward:

 

/C:/Users/WF7A/Desktop/

[siroos12]

You did not specify the folder name. Try something like this:

 

/C:/Users/Siroos/Desktop/test folder/1.pdf

 

The formula to achieve above can be something like this:

Get ( DesktopPath ) & "test folder" & "/" & GetContainerAttribute ( Yourtable::YourContainerField; "fileName" )

 

 

Edited November 22, 2018 by siroos12

[OlgerDiekstra]

On 11/19/2018 at 4:48 AM, Rich said:

Greets, and a happy, holiday season to all.

This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command: 

"cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" )

...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, "[3] Command is unavailable (for example, wrong operating system or mode)".

So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix?

 

I just tried the exact same command on my Win7 box using both FMAv16 and FMAv17.0.2. Worked fine both cases.

Try converting the "/" to "\" in case that's causing an issue. Windows should be able to handle forward slashes, but traditionally, backslashes are used in paths.

Have you tried the BE plugin to see if that can create the folders?

Could malware protection be sandboxing the FMP app?

Being virtual should make no difference. I run FMA in VirtualBox at home (Linux host OS) on Win7.

[Rich]

* heavy sigh *

This is one of those instances where you chase your tail and end up with a major "D'oh!" 

I've attached the script steps that I've been using and it suddenly dawned on me that even with the PC version of FMP running in the PC environment of the emulator, the Get (SystemPlatform) command still pulls the "root" operating system of the computer--which in my case is OS-X (Mojave)--so with the script steps, as coded, the first part of the IF statement will drive the result of it; when I nulled all but the PC's Send Event command, it worked.

Thank you all for your patience and help, and my apologies for taking up your time from my ignorance.

 

[OlgerDiekstra]

Maybe try running a proper type 2 hypervisor on Mac such as VirtualBox, in which case you get a real virtual (Windows) guest that FileMaker won't be able to break out of. Get( SystemPlatform ) will give you a Windoze result.

[Rich]

Thanks, I'll check it out!