Move Whole Tree

[john renfrew]

Is there a way to move a whole tree of related SC files from inside FM??

I would like to move everything located on the server inside "Active/BADDOC3..." to "Withdrawn/BADDOC3..." but the SCscanfolder will only work on the local hard drive and not take the SuperContainer/Files path so I cant build a looped script.

I can set the calculation in the webviewer to If ( status = withdrawn ; withdrawn & path ; active & path ) to see the various files but some of them have been put there using SCSetContainer as we never want to view them but want them in the storage tree

Any ideas??

[Smef]

You could use the SCMove function to move a file from one path to another, but it sounds like what you really need to do instead is not include Active/Withdrawn in your filepath, and instead of moving files around you may want to have a dropdown or radio button field on your layout to mark your documents as active or withdrawn. Your users should never be seeing your file path for SuperContainer, so changing that path shouldn't really affect your user's experience.

[john renfrew]

David

The problem is that the SCScan function NEEDS a valid path/to/files to build a list so that I can then parse and walk the tree to move everything which I can only do one file at a time which means that the SuperContainer/Files directory needs to then be on a share so it can be seen by the OS

If you can imagine the scenario where after a few yeas of study there are LOTS of files to move it would be nice to have a quick way of moving the whole tree so that ALL subreferences are then valid too.

[Smef]

Your SuperContainer files are (or should all be) calculated somewhere in your FileMaker database (or else you wouldn't be able to see any of them). You can use the same records and file paths that you are using to upload or view files in a looping script to move the files. The number of records won't make a difference, other than the time it takes to complete.

You should not need to use the SCScanDirectory function at all on your server (and can't use it anyway), as you know where all the files are already because you've been uploading and accessing them through your filemaker database.

[john renfrew]

David

Am using this to store files for part of this solution which are history so I can rectreate the unique Id and then view the single file in a viewer, but when a student graduates for example we want to move the whole tree to the graduated branch, form the active branch

I have it working well, but today I started getting 412 errors

Have uploaded log file on your site (JR_Superconteiner..etc.etc), look from lines 15220 onwards....

[Smef]

Can you send your server log as well after the next time you get this error?

[john renfrew]

Have uploaded the log through your website as I cant upload here for some reason.

Just tested this at home using the local version of the server and it doesn't seem to exhibit the same issues, so it is likely to be server related.