GetFileList for Directories?

Dexter1 · Post by **Dexter1** » Tue Mar 03, 2009 5:10 pm

Every week I generate a new folder in a specific directory. I always use the same naming convention: WK#_YYYY. This week I created WK8_2009. In two weeks I will create WK10_2009, and on, one for each week of the year.

I am currently using a macro to generate this folder but I have to enter the week number. I would like to bypass this step and automatically generate the new folder.

However, I have not yet been able to use GetFileList properly (assuming this is the right way to go?). The manual says Let>GFL_TYPE=1 should give me directories instead of files, but I haven't been able to make that work. Below is the code I have.

If there is another way I should be doing this, I'm all ears, but my basic plan was to get a list of file names, find the one with the highest week number, then create a new folder that is one higher.

I guess a bonus would be to start a new year if it hits 52 but that's not a big deal.

Code: Select all

Let>GFL_TYPE=1
GetFileList>\\rnodata01\scrub$\Production_Issues_Clarify\**,directories
Separate>directories,;,file_names
MessageModal>%directories%

Post by **Marcus Tettmar** » Tue Mar 03, 2009 5:15 pm

The only error I can see in your code is that you have missed out a dot (.) between * and *. Your code works for me (all-be-it with a different network path):

Let>GFL_TYPE=1
GetFileList>\\MadeUpServer\Shares\Marcus\*.*,directories
Separate>directories,;,file_names
MessageModal>%directories%

Bob Hansen · Post by **Bob Hansen** » Tue Mar 03, 2009 5:18 pm

Are you missing a period .?

GetFileList>\\rnodata01\scrub$\Production_Issues_Clarify\*.*,directories

Dexter1 · Post by **Dexter1** » Fri Mar 06, 2009 8:22 pm

I added the period but still get a list of all of the files in the folder. In fact, I don't get any directory names at all, just files.

Post by **Marcus Tettmar** » Fri Mar 06, 2009 8:30 pm

Which version of Macro Scheduler are you running?

Dexter1 · Post by **Dexter1** » Fri Mar 06, 2009 9:01 pm

An old one!

8.0.4

Post by **Marcus Tettmar** » Fri Mar 06, 2009 9:20 pm

That'll be it then. GFL_TYPE was added later:

http://www.mjtnet.com/mswhatsnew.htm

Dexter1 · Post by **Dexter1** » Fri Mar 06, 2009 10:44 pm

Ah! Thanks.

I'll have to see if I can talk my boss into the upgrade without having to trade my job for it.