[RBASE-L] - Re: Data File Relocation Routine

[Jason Kramer]

Bruce,     If I understand correctly, you have a table that looks like this: file_sn    file_set 10001        a 10002        a 10003        b 10004        c     A single directory with all files in it, and directories named a,b,c,d that you want to copy (or move) the files into, and an Excel file with the same information?  Is that correct?                                                                 Thanks,                                                                 Jason Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) On 3/7/2012 11:20 AM, Bruce Chitiea wrote: All: RBASE 91_64 9.1.5.20214 have PluginPowerPak 91_64 Windows 7 GOAL Distribute classed sets of data files from a common folder to their respective set folders. BACKGROUND For a client with severe data-file duplication and file-content-identification issues ranging across several thousand files, I've: - created a backup working set of those files - pre-pended a 5-digit serial number to each file-copy into the format: xxxxx.filename.ext - aggregated all files into a common folder - successfully parsed the folder's file list into text fields: xxxxx filename ext filesize datestamp - processed these in Excel to identify duplication and content-meaning, and to class files into four sets: [ a b c d ] - successfully Gateway'd the file serial number and file set identifier into a two-column R:Base table: file_sn [ 10001,10002...2nnnn ] file_set [ a b c d ] - created four empty file folders, each reserved for one file class NEED I'm thinking the 'file_sn' and 'file_set' values are sufficient input to a process that 'walks' the common file list and performs the distribution. I have no such routine and I'm SO FAR behind the 8-ball on this job ... What's the best way to handle this? MTIA Bruce Chitiea SafeSectors, Inc.