Key and Data combine.

[John Esak]

Sorry, this got garbled...
The two line process to put in your orig file and run (called mv_data) is:

   then:  lookup temp r=free
   then: copy temp;  write temp;  end

Run it with:

   rreport origfile -fp mv_data -a -u
 

> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of John Esak
> Sent: Friday, October 22, 2010 11:23 AM
> To: 'Kroboth, Joe'
> Cc: filepro-list at lists.celestial.com
> Subject: RE: Key and Data combine.
> 
> No, you're making it way too hard.
> 
> If, as you say, you don't need to keep @cd and @ud etc., Just 
> createa new
> ffile exactly the way you want it with the name "temp" let's 
> say. In other
> words have all the same fields, but no "data" section. Then, 
> copy all the
> records from the original ffile to the new one with a two 
> line prc tabele in
> the original file.... Let's call it mv_data.
> 
> Then: lookup temp r=free.  You will now have in the temp file 
> a correct
> "key" file and no "data" file assuming you designed it properly. 
> Then: copy temp;  write temp;  end
> 
> You would run:
> 
> Rreport orig_file -fp mv_data -a -u
> 
> Then you would:
> 
> CAREFULLY edit the original file's map with a text editor  to have the
> numbers between the first 4 colons look just like they do in 
> the new "temp"
> file's map.  Then, remove the orig file's key and data from 
> the folder and
> move the new temp/key file into that original file's folder. 
> You have a
> fully working file with just a key and no data, but all the 
> old formats,
> etc.  You should reindex the file at this point before you use it.
> 
> John
> 
> P.S. What I mean by edit the map with edit and the first 4 
> colons etc. is
> this.... Is 
> 
> 
> Windows
> cd ...\filepro\origK_file
> edit map
> 
> *nix
> cd .../filepro/origK_file
> vi map
> 
> 
> Then change  the new "temp" file's numbering between the 
> first 4 colons of
> the first line so that the first line of orig_file's map now 
> has the new
> numbering between the colons. Leave all the other stuff on 
> that first line
> exactly the same as you find it.
> 
> map:17:27:3:161af71c:Yz4o'9;lt)M'usNp│map:20:0:2:161af71c:Yz4o
> '9;lt)M'usNpma
> p:
>       ^          ^
>       ^          ^
>       the first 4 colons
> 
> Leave all the rest alone.
> 
> 
> 
> > -----Original Message-----
> > From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> > [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> > m] On Behalf Of Kroboth, Joe
> > Sent: Friday, October 22, 2010 9:52 AM
> > To: filepro-list at lists.celestial.com
> > Subject: Key and Data combine.
> > 
> > I several old filePro files.  They are in Key and Data 
> > formats.  I would like to combine the key and data segments 
> > to just key.   Not sure the how I can do this.
> > 
> > On the files where I don't need to preserve @UD, at UB etc. I've 
> > tried the following.
> > 
> > Recreate the file only using the key. 
> > Copy all records to the new file
> > Copy the new blob,data,key,map and map.tmp back into original 
> > directory.
> > 
> > The data seems to work but it the file has a creation 
> > password on it. I can't seem to get by this. Is there a way 
> > to get rid of this password? 
> > 
> > 
> > On the files where I need to preserve @ud, at up etc. I have no 
> > clue what to do.
> > 
> > Thanks.
> > 
> > 
> > Joe Kroboth
> > Chernay Printing, Inc
> > joe_kroboth at chernay.com
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list