Key and Data combine.

[Kroboth, Joe]

Thanks John, Worked great.

Joe

> -----Original Message-----
> From: John Esak [mailto:john at valar.com]
> 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'u
> sNpma
> 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