EXPORT Question
Steve Parker
sparker at abccompuserve.com
Tue Oct 12 20:00:36 PDT 2010
-----Original Message-----
From: filepro-list-bounces+sparker=abccompuserve.com at lists.celestial.com
[mailto:filepro-list-bounces+sparker=abccompuserve.com at lists.celestial.com]
On Behalf Of filepro-list-request at lists.celestial.com
Sent: Tuesday, October 12, 2010 7:45 PM
To: filepro-list at lists.celestial.com
Subject: Filepro-list Digest, Vol 81, Issue 12
Send Filepro-list mailing list submissions to
filepro-list at lists.celestial.com
To subscribe or unsubscribe via the World Wide Web, visit
http://mailman.celestial.com/mailman/listinfo/filepro-list
or, via email, send a message with subject or body 'help' to
filepro-list-request at lists.celestial.com
You can reach the person managing the list at
filepro-list-owner at lists.celestial.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Filepro-list digest..."
Today's Topics:
1. Re: SCO OpenServer & filePro permissions (scooter6 at gmail.com)
2. Re: Too Many Open Files - Linux 5.0 (Nancy Palmquist)
3. Re: SCO OpenServer & filePro permissions (Jean-Pierre A. Radley)
4. Re: SCO OpenServer & filePro permissions (Fairlight)
5. EXPORT Question (Art Moore)
6. RE: EXPORT Question (Richard Kreiss)
7. Re: EXPORT Question (Brian K. White)
----------------------------------------------------------------------
Message: 1
Date: Tue, 12 Oct 2010 09:37:59 -0400
From: "scooter6 at gmail.com" <scooter6 at gmail.com>
Subject: Re: SCO OpenServer & filePro permissions
To: Fairlight <fairlite at fairlite.com>
Cc: filePro Mailing List <filepro-list at lists.celestial.com>
Message-ID:
<AANLkTinyTj_5xFsb_Hcxz0LrqPZ-dQ=iDBQ2PvfGa-3k at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Mark,
I am also an administrator and I understand all you're saying.
My only concern was I don't ever recall manually creating a filepro user,
I assumed it was created by default when installed.
Therefore, I wouldn't expect the user 'filepro' to have an expired
password.
That was my only concern on this.
Thanks
Scott
On Mon, Oct 11, 2010 at 10:26 PM, Fairlight <fairlite at fairlite.com> wrote:
> The honourable and venerable scooter6 at gmail.com spoke thus:
> > So does it matter what I set filepro's password to? I never
> > knew it got installed with a password, much less a password that
> > expires?? Strange......
>
> If the installation is what creates the filepro user, my recollection is
> that it does not even -set- a password, you have to do that manually. I
> may be misremembering. Usually I'm doing a migration, so I set up the
> account manually, before actual fP installation.
>
> If you're planning on physically logging in manually as filepro, then you
> should pick a strong password that you can remember. If you're only going
> to be using su or ssh with authorized_keys, then you would be safe to just
> put x or * in the encryption field in /etc/shadow. If you're not even
> going to have filepro as a user -do- anything, one can lock it down with a
> shell of /bin/nologin or /bin/false.
>
> > That leads me to the other part of my problems/issues/questions. I'm
> > assuming them I can use the filepro user to ftp to our client's site
> > and 'get' files, thus these files would have filepro ownership already,
> > right?
>
> Given the correct credentials and automation, yes, the filepro user can
ftp
> out and get files. Resultant files would be owned by filepro.
>
> > I guess I can also do some 'system' calls to chmod etc right from
> > processing.
>
> I know you can, I don't have to guess. Now chown is another story
> entirely...
>
> > But I would like to know if:
> > a) this is standard behaviour for filepro (an expiring password)
>
> Password expiry has nothing whatsoever to do with filepro, and everything
> to do with the security configuration of the authentication subsystem of
> the underlying operating system. I'm not sure what SCO is using as of
> 5.0.7. In linux, this would be a function of how the PAM module is
> configured, for most (if not all) modern distributions.
>
> > b) does it matter what I set filepro's password to?
>
> See above.
>
> > c) will it break anything when I change it?
>
> The only thing changing the filepro user's password will "break" is the
> ability for someone that's been using the current password (if one even
> exists) to log in using that same password after you've changed it. The
> filePro software in no way relies on logging in as filepro, or upon the
> actual password. There's a filepro user so that the binaries have a user
> other than root to be set SUID to and the data can be owned by that user,
> and that's it. I have multiple systems set up where you can't even log in
> as filepro, both because it has the password field set to an invalid
> encryption (x or *), -and- because it doesn't have a valid login shell
> that's listed in /etc/shells.
>
> Happy to help to a degree on-list, but this stuff is pretty much "Unix
001"
> territory. If you have an administrator for the system, you might confer
> with them; any competent administrator could answer these questions. If
> you don't, you might want to hire or contract one.
>
> mark->
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20101012/79e
67349/attachment.html
------------------------------
Message: 2
Date: Tue, 12 Oct 2010 11:47:30 -0400
From: Nancy Palmquist <nlp at vss3.com>
Subject: Re: Too Many Open Files - Linux 5.0
To: filepro-list at lists.celestial.com
Message-ID: <4CB48312.606 at vss3.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
On 10/11/2010 7:12 PM, Nancy Palmquist wrote:
> I know something is wrong. The following is a dump of @ALLFILES[]
>
> Starting with element 422 (450-423 are blank) I get a bunch of the same
> thing.
>
> Right before this I used getnext to find all the entries that match one
> inquiry number. There could easily have been hundreds, but each access
> should not list the same index.
>
> * 10/11/10 19:04:53 -------------------------------- START
> * Start: F10500385482000
> * ---------------------------------
> * ========= 422-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 421-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 420-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 419-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 418-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 417-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 416-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 415-/home/appl/filepro/mrxmlinqy/index10.D
>
> [snip] everything from 414 to 17 - they are all the same
>
> * ========= 16-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 15-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 14-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 13-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 12-/home/appl/filepro/metrodb/index.A
> * ========= 11-/home/appl/filepro/xmltransID/index.E
> * ========= 10-/home/appl/filepro/xmltransID/index.D
> * ========= 9-/home/appl/filepro/xmltransID/index.C
> * ========= 8-/home/appl/filepro/xmltransID/index.B
> * ========= 7-/home/appl/filepro/xmltransID/index.A
> * ========= 6-/home/appl/tmp/rpX2ug1r
> * ========= 5-/home/appl/filepro/xmltransID/index.E
> * ========= 4-/home/appl/filepro/xmltransID/index.D
> * ========= 3-/home/appl/filepro/xmltransID/index.C
> * ========= 2-/home/appl/filepro/xmltransID/index.B
> * ========= 1-/home/appl/filepro/xmltransID/index.A
> * Start: E09300241396000
>
> I did a CLOSE before the Start at the bottom and then it crashed when I
tried to do the next inquiry processing.
> I tried running this in readonly to make sure it was not updating
anything.
>
> This has run in the past but it has been a few months since I ran this
report.
>
> I get too many open files - 60 is the limit. I have to get this running.
It seems to affect more than just this report.
>
> Any ideas.
> Nancy
Update info. This file is shared across an NSF mount, I was using it
from the source drive, not the mounted drive. I copied the key to a
qualifier, built fresh indexes for the qualifier and the processes run
perfectly.
My conclusion is that it is an issue with the NSF mount somehow. I have
no idea how to troubleshoot that issue, but I just wanted to post the
suspect, in case someone else is having issues.
When I ran it from the qualifer, the @allfiles[] did not have the
mrxmlinqy/index10.D repeated over 400 times. It was just there once.
Not sure what is happening in filePro but something is certainly funky.
Nancy
--
Nancy Palmquist MOS& filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
------------------------------
Message: 3
Date: Tue, 12 Oct 2010 13:29:50 -0400
From: "Jean-Pierre A. Radley" <appl at jpr.com>
Subject: Re: SCO OpenServer & filePro permissions
To: FilePro Mailing List <filepro-list at lists.celestial.com>
Message-ID: <20101012172950.GA9601 at jpradley.jpr.com>
Content-Type: text/plain; charset=us-ascii
scooter6 at gmail.com propounded (on Mon, Oct 11, 2010 at 08:09:46PM -0400):
| So does it matter what I set filepro's password to?
There is no characteristic or behavior of any Unix user that is affected
one way or another by the password chosen for that user. If you
never intend to log in as that user, then you don't even need to pick
something you can remember; anyhow root can always change any password
if the occasion arises.
I log in as appl (== filepro) all the time. In my password file, the
filepro line is duplicated by the appl line, under which login I
subscribe to this mailing list and am typing these words. The reason I
created appl with the same UID as filepro is that appl is shorter to
type. :-)
I do all my writing and editing of processing tables in 'vi'; doing
so as user appl, same as filepro, bestows the proper ownership on the
prc.tables.
I have also contrived to have the same UID for filepro on several my
customer's machines, which makes it more convenient to move fP-related
files between their computers and mine.
--
JP
------------------------------
Message: 4
Date: Tue, 12 Oct 2010 14:23:11 -0400
From: Fairlight <fairlite at fairlite.com>
Subject: Re: SCO OpenServer & filePro permissions
To: FilePro Mailing List <filepro-list at lists.celestial.com>
Message-ID: <20101012142311.A26629 at iglou.com>
Content-Type: text/plain; charset=us-ascii
Four score and seven years--eh, screw that!
At about Tue, Oct 12, 2010 at 01:29:50PM -0400,
J. P. Radley blabbed on about:
>
> I have also contrived to have the same UID for filepro on several my
> customer's machines, which makes it more convenient to move fP-related
> files between their computers and mine.
Which is also good because you're preconfigured for filepro to use NFS, if
it ever becomes necessary.
m->
--
Audio panton, cogito singularis.
------------------------------
Message: 5
Date: Tue, 12 Oct 2010 18:49:51 -0500
From: "Art Moore" <cowboy at pcanswersinc.com>
Subject: EXPORT Question
To: <filepro-list at lists.celestial.com>
Message-ID: <292273C2622846B7A07B894A9DDE4854 at NBCPCA>
Content-Type: text/plain; charset="iso-8859-1"
I realize what I am asking about is filePro 101. But....
I have tried using lines from Laura's Help File and am surely doing
something wrong because it does not work. I am sure I am misinterpreting
some very simple instructions.
I have a file named 'crsfinal'. I want the data in that file to ultimately
end up in an EXCEL file. My limited knowledge tells me to export the data
into a comma-delimited .csv file and from there I can convert it to an EXCEL
file.
Assuming that is correct I have written the following line in output
processing in the 'crsfinal' file.
EXPORT WORD ofile="myfile"
I get the following error:
System Error
on File: "myfile"
Output Processing
Line Number 1
EXPORT WORD ofile = "myfile"
^
Bad Function Number
If anybody is listening I would be grateful for some help. THANK YOU IN
ADVANCE.
Art Moore
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20101012/144
00c87/attachment.html
------------------------------
Message: 6
Date: Tue, 12 Oct 2010 19:11:56 -0400
From: "Richard Kreiss" <rkreiss at verizon.net>
Subject: RE: EXPORT Question
To: "'Art Moore'" <cowboy at pcanswersinc.com>,
<filepro-list at lists.celestial.com>
Message-ID: <001201cb6a62$dea2c6a0$9be853e0$@verizon.net>
Content-Type: text/plain; charset=US-ASCII
I do a lot of exports to create file imported into EXCEL.
export word ofile=c:\path\myfile.csv (no quotes)
If the value to the right of the = is a long variable, use
Filename= "c:\path\myfile.csv"
export word ofile=(filename)
My preference on a windows based system is to place the file in the users
documents folder and the at @done
System "start excel"<filename
Or if you don't want to come back into filePro,
Putenv "myfile",filename
Add after your command line for the export, start %myfile%
However if the export file name never varies, hardcode the name.
Richard Kreiss
GCC Consulting
-----Original Message-----
From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
[mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
Behalf Of Art Moore
Sent: Tuesday, October 12, 2010 7:50 PM
To: filepro-list at lists.celestial.com
Subject: EXPORT Question
I realize what I am asking about is filePro 101. But....
I have tried using lines from Laura's Help File and am surely doing
something wrong because it does not work. I am sure I am misinterpreting
some very simple instructions.
I have a file named 'crsfinal'. I want the data in that file to ultimately
end up in an EXCEL file. My limited knowledge tells me to export the data
into a comma-delimited .csv file and from there I can convert it to an EXCEL
file.
Assuming that is correct I have written the following line in output
processing in the 'crsfinal' file.
EXPORT WORD ofile="myfile"
I get the following error:
System Error
on File: "myfile"
Output Processing
Line Number 1
EXPORT WORD ofile = "myfile"
^
Bad Function Number
If anybody is listening I would be grateful for some help. THANK YOU IN
ADVANCE.
Art Moore
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20101012/144
00c87/attachment.html
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
Art,
Nothing simple about this stuff in the beginning, even though it may seem
like your question is "simple". It is only simple once the light bulb comes
on!
One other great way to make this easily available to a user for import is to
put the file on a "shared" volume on the Unix server (if you are on Unix) or
on a Windows "share" so that a mapped drive will have immediate access to
the report files.
I do a lot of both importing and exporting, and it really automates things
for people! Great stuff!
So on one of my Unix servers I have a "share" called UNIX, set that way by
facetwin. Under that folder is a folder called "Report", so in their Excel,
they simply point to drive "U:\Report" and see their recent report files
immediately and can open them with Excel!
Steve Parker
ABC Computing Services
--------------------
On 10/12/2010 7:49 PM, Art Moore wrote:
> I realize what I am asking about is filePro 101. But....
>
> I have tried using lines from Laura's Help File and am surely doing
something wrong because it does not work. I am sure I am misinterpreting
some very simple instructions.
>
> I have a file named 'crsfinal'. I want the data in that file to
ultimately end up in an EXCEL file. My limited knowledge tells me to export
the data into a comma-delimited .csv file and from there I can convert it to
an EXCEL file.
>
> Assuming that is correct I have written the following line in output
processing in the 'crsfinal' file.
>
> EXPORT WORD ofile="myfile"
>
> I get the following error:
>
> System Error
> on File: "myfile"
> Output Processing
> Line Number 1
> EXPORT WORD ofile = "myfile"
> ^
> Bad Function Number
>
> If anybody is listening I would be grateful for some help. THANK YOU IN
ADVANCE.
>
> Art Moore
There are a few things you didn't specify which are necessary for an
export process to work.
Rather than guess all the details of what you're doing, instead here is
a basic export example from top to bottom, since it's easy.
This will export the first 3 fields of every record of "fpfile" out to a
csv file called "fpfile.csv" in .../appl/fpmerge
First go to define processing, select "fpfile", output processing, new,
"csvout"
-----top of processing-----
If:
Then: export word out="fpfile.csv"
If:
Then: out(1)=1
If:
Then: out(2)=2
If:
Then: out(3)=3
If:
Then: end
@once:
If: ' just in case...
Then: putenv "FPADDWP","OFF"
If:
Then: end
-----bottom of processing-----
Now run the export like this:
rreport fpfile -fp csvout -y NoAuto -u -a -ro
Now the likely modifications from that minimal working example:
If you want your prc.automatic to run on every record, remove "-y NoAuto"
If you need to do any other kind of processing involving updating any
filepro data along the way, remove "-ro"
If you want to specify the output file from the rreport command line in
a handy way:
add "-r /path/to/output/file.csv"
and change
Then: export word out="fpfile.csv"
to
Then: export word out=(@pm)
If you want to export all the fields instead of just the first three,
add more lines like "out(4)=4" after out(3)=3, and before the first END.
Warning: You can't write any sort of loop or dim/map an array to get
around having to explicitly write a command for each individual field.
Don't waste your time trying. The reason is an export alias can not take
an expression as an argument, only a litteral. The only way to automate
that is by having a process that actually writes a process table as it's
output and then runs it. See jhimport/jhexport for a full blown nice
interactive utility to do that for you if it's going to be a big deal.
I didn't get into unix permissions issues and how to write a robust
shell script around this report since you didn't say what your expected
context was. Will a user run this manually once in a while? Will cron
run this periodically? What needs to happen to the file after it is
generated? (who/what needs to be able to read it, when, immediately
after generation? would an immediate http download to the user be cool
or does some other entity need to get it via ftp the next day or does
someone expect to get it by email etc...) could (not will, _could_) more
than one person run this at the same time? etc etc etc...
--
bkw
------------------------------
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
End of Filepro-list Digest, Vol 81, Issue 12
********************************************
More information about the Filepro-list
mailing list