limiting browse based on login?
Boaz Bezborodko
boaz at mirrotek.com
Mon Sep 14 08:50:07 PDT 2009
Just to answer your first questions...John was commenting on the
possibility that if you called a SYSTEM command to run ddir as I
suggested, you might be doing so from within the file that you wish to
delete the existing records. The result of this is that you delete all
the records but keep the one you are standing on. My assumption was
that you would execute this from the master file before moving the data
to the new file. Under this circumstance you would delete all the
records and there wouldn't be one left over.
If you are creating a new file and just using the unqualified version of
this file, then just using the -K flag will delete all the records in
that file. If you want to delete all records in all qualifiers then you
need to use -KA. If you are creating a separate qualified file for each
customer and just want to delete a specific qualifier then "-K -m
qualifier" will delete the records in just that particular qualifier.
scooter6 at gmail.com wrote:
> Sorry John, I was just uncertain of the exact flags.
> Also, I was confused by the one blank record idea because I was also
> working
> on some import/export stuff....that's another story.
>
> Anyways, here is where I'm at.
> I have everything I want setup so far...except one thing I'm not
> certain of.
> Here is my input processing on the "new" file I created.
> Now, I'm not sure how to get the browse window keys to work.
> You can see from my processing that I want to be able to hit "V" to view
> the screen 1v in this main file. I also want to be able to hit "N"
> for notes and
> "P" for payments when at this browse window.
> I have tried using the @bk command but it doesn't do anything.
> Keep in mind, I ONLY want them to be able to view things, NOT change
> anything.
> What am I missing here?
> Also, when hitting "X" from this browse window, I want it to exit
> completely,
> not go to the filePro IUA menu.
>
> Input processing table:
>
> 1
> @menu If:
> Then: dim myiua(3)
> 2
> If:
> Then: myiua["1"]="Choose Search Option"
> 3 If:
> Then: myiua["2"]="A:Search by Acct Num"
> 4 If:
> Then: myiua["3"]="B:Search by Last Name"
> 5
> rptmnu If:
> Then: cls("22")
> 6 If:
> Then: menu myiua dosrch1, dosrch2
> 7 If:
> Then: exit
> 8 If:
> dosrch1Then: lookup act = mainfile k=3 i=A -nx b="(brw=12 xkey=x
> pop=1v prc=actn fill=asc,top) [ Acct Num
> 9 If:
> Then: Beg Bal Payments Curr Bal]
> *3 *7 *20
> *21 *22 "
>
> 10 If:
> Then: end
>
> 11 If: @bk="N"
> Then: ...does a browse lookup to the notes file, matching
> on Acct #
>
> 13 If:
> Then: end
> 14 If:
> dosrch2Then: ....does the same browse lookup as in line 8 & 9 above,
> only using a different index (for last name) and uses prc=name
>
> 17 If:
> actn Then: show \r V \r to View \r N \r for Notes \r P \r for
> Payments; end
> 18 If:
> name Then: show \r V\r to View \r N \r for Notes \r P \r for
> Payments; end
>
>
> What am I missing here???
> thanks
>
> Scott
>
>
>
> On Fri, Sep 11, 2009 at 2:13 PM, John Esak <john at valar.com
> <mailto:john at valar.com>> wrote:
>
> I'm not sure why you want to leave one blank record in the files
> you want to
> clear. The command to clear ALL records on Unix is:
>
> ddir filename -k (kill the main file only (the unqualified file))
>
> ddir filename -ka (kill all qualifiers as well)
>
> ddir filename -k -m qualifier (kill a particular qualifier)
>
> For Windows substitute dprodir for ddir.
>
> *Kill means empty the key/data and rebuild the indexes to fresh ones.
>
> But why could you not have looked this up in the manual? Or in the
> help for
> this program in the on-line Help. F10 in Define Menus for example.
>
> John
>
>
>
> > -----Original Message-----
> > From: filepro-list-bounces+john=valar.com
> <http://valar.com/>@lists.celestial.com <http://lists.celestial.com/>
> > [mailto:filepro-list-bounces+john
> <mailto:filepro-list-bounces%2Bjohn>=valar.com
> <http://valar.com/>@lists.celestial.co <http://lists.celestial.co/>
> m] On Behalf Of Boaz Bezborodko
> > Sent: Friday, September 11, 2009 10:53 AM
> > To: filepro-list at lists.celestial.com
> <mailto:filepro-list at lists.celestial.com>; scooter6 at gmail.com
> <mailto:scooter6 at gmail.com>
> > Subject: Re: limiting browse based on login?
> >
> > >
> > > Date: Fri, 11 Sep 2009 10:28:14 -0400
> > > From: "scooter6 at gmail.com <mailto:scooter6 at gmail.com>"
> <scooter6 at gmail.com <mailto:scooter6 at gmail.com>>
> > > Subject: Re: limiting browse based on login?
> > > To: Ken Cole <ken.m.cole at gmail.com
> <mailto:ken.m.cole at gmail.com>>, filePro Mailing List
> > > <filepro-list at lists.celestial.com
> <mailto:filepro-list at lists.celestial.com>>
> > > Message-ID:
> > >
> <445ca8160909110728r2015be5cr7e1fbe2285d37347 at mail.gmail.com
> <mailto:445ca8160909110728r2015be5cr7e1fbe2285d37347 at mail.gmail.com>>
> > > Content-Type: text/plain; charset="iso-8859-1"
> > >
> > > Okay, well I decided to go in another direction on
> > this due to time
> > > constraints.
> > > What I did is create a new file that mirrors the
> > 'main' file NRdebtor
> > > I copied over JUST the records for the client that
> > wants access so
> > > just their
> > > records are in this file - they will ONLY be allowed
> > to browse their
> > > data,
> > > nothing else.
> > >
> > > So I created a simple screen that will show just the
> > pertinent info,
> > > etc.
> > >
> > > Now, what I want to do is copy over just their
> > records in a nightly
> > > cron job
> > >
> > > So, to do this, what is the command to delete all the
> > records (except
> > > 1 blank)
> > > from this new "mirror" file that has only this
> > clients data in it?
> > > I know how to get the records copied from the main
> > file, but am unsure
> > > how to
> > > delete these records before copying over a 'fresh'
> > version - hope that
> > > makes
> > > sense. I suspect it will be ddir or something to
> > delete the records
> > > before I
> > > re-copy them, is that correct?
> > >
> > > Thanks for all the help - but using every form of
> > "drop" and "drop
> > > all" still just
> > > takes too long since filePro apparently has to search
> > each individual
> > > record,
> > > even if using an index based on unique account
> > number, since there are
> > > over
> > > 1/2 million records it's just not a good solution at
> > this point - this
> > > other
> > > 'solution' involves probably a little more heavy
> > lifting than might
> > > be necessary
> > > but it does the trick.
> > >
> > > I am currently writing the @menu portion so the
> > client will only be
> > > able to hit
> > > 'V' to view and 'X' to exit, etc.
> > >
> > > Thanks again
> > >
> > > Scott
> > >
> > You can run a SYSTEM command to run the DDIR program with flags to
> > delete the data before you start filling it up again.. Just
> > check out
> > the flags you can use in the manual. (I believe that -KA will
> delete
> > all data and key elements and empty the indexes. Once this
> > is done you
> > have an empty file to work with.
> >
> >
> > Boaz
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> <mailto:Filepro-list at lists.celestial.com>
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090914/847b6e3f/attachment-0001.html
More information about the Filepro-list
mailing list