1 of 1 people found this helpful
Take a look at the File functions of the BaseElements plug-in, it way well provide you with the ability to do what you want.
1 of 1 people found this helpful
The easiest way to do this would be to use a plug-in like the Troi File Plug-in, otherwise you would have to use shell commands or Applescript.
As far as I know, the BaseElements plug-in can not read the file modification date.
Thanks for the prompt reply. Good sugestions on both replys.
I have a question for you Christ, where can I find the Troi File Plug-in ?
I did tried the Shell Commands ( Dir *.* /S > Filelist.txt ). This writes the entire disk information to the text file "Filelist.txt". Then I open this file with Excel by using the tab delimiters. Then I have to go through the entire spreadsheet and fill out the full path (one of the columns that I open) with the information given to me by the header of each group. I also open another column that reads the Year out of the last modified Date (which will be used by the Filemaker program to select the files to be move by the year and then delete the file on a separate batch script ). Then I MANUALY delete the header and the footers from each Directory and that makes the excel spreadsheet ready to be imported to my FILEMAKER application tables.
The table for the files that I have in FILEMAKER is
FILEINFO - table name
File Type (File or DIR)
Once I upload the data then I have to create a script that will select the files by date field.
Go through each record of the found set. Locate the file by the Path and the File Name and move it
to an external disk.
I will physically check that the files have been actually moved.
The next step is to run another script that will use all the found records and delete each of the selected
files that have already being moved.
I was hopping that I could read and import the file information directly into the FILEMAKER table I have created so that I do not have to do the manual work on the Excel spreadsheet.
I believe that the /s switch for the DIR command gives you the full path. You can do this with a VBscript to and have more control if you don't want to go the plugin route.
www.troi.nl for the plugin
You should be able to do all the parsing you are doing in Excel from within Filemaker. I do something similar. It does take a bit to work out the details for the file, but it can be done in calcs.
Thanks to the good responses that have given me some light into the solution.
Wimdecorte gave me a good hint on creating a *.bat (batch file in DOS) to do the transfer of the directory
contents into EXcel. The advantage of the VBscript is that you can analyse the data on each line of the directory after it has been placed on a TXT document and find out what is the Path of the files to be read on the consecutive lines and put that path on the end of each corresponding record. This will allow me to delete those lines that do not correspond to a file path for the corresponding path read on the line above the directory group you are reading for that particular Path (saved on a Variable) .
I also am intrigued by the sugestion made by Lee Snover and I would like to have a sample coding on how to handle the parsing from calcs for Excel. This is an amazing process because that will solve the amount of hard work that we are forced to do frequently in the cleaning of our Server Drives.
IF we can come out with a good solution we should be able to sell this product very quick. This is a common problem for any person who has to regain some space on ANY computer ! Let us keep in touch, I think there is a good possibility here.
firstname.lastname@example.org (786) 262-4019
email@example.com Work (1)-888-322-4673 tell the operator to give you extension 142
Thanks for all of your great hints.
360works has a product called supercontainer that comes with a plugin... you can move all the files into supercontainer, check for duplicates, etc and then move them to any
location... demo files are free and work for 2 hours iirc.
just another method....