finding things in unix

John Esak john at valar.com
Mon Apr 26 15:42:15 PDT 2010


I received a mysterious mewsage saying that someone wrote me a personal
message on the fptech forum... Then it listed out the message... Which is
very much like yours Henry.  It sounded as if FP Tech was needing this
advice. :-)   I was not able to get onto the forum I forgot my passwrd and
the reset never got sent. I even answered my personal question.  I think,
perhaps, I don't know my correct old username.  Email got me somewhat
further, but essentially can't login to the forum.

As to gettting data out of filePro into your new package.  FilePro is fully
capable of outputting any and all data in practically any method your new
package requires. Does it look for a .csv file. Sometimes this is referred
to as an import file... An ascii import file?  Is it looking for an SQL
database file?  My guess is if you determine the format the new package is
looking for, it will be an easy matter to use "export" to get the data into
that format.

If you have header-detail files this will be somewhat harder, but pretty
much the same methodology.  You might have to make a  pair of files that
duplicate your header-detail records.  It all depends on what the new
package wants ... And how it wants it.

Get that figured out by checking with the support for the product and then
re-ask the question on the mailing list with more specifics... Like I need
to generate a structured ascii file, or a comma delimited file.  Your new
system may be able to take data from an Excel spreadsheet format.  That
would be an easy match-up for a .csv file.  filePro has the EXPORT command
to do this like this.....


Export WORD path-to-export-filename

That will generate a file which could esialy be read into Excel... Or in the
same manner your new app.


John Esak
 

> -----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 Henry B. Castaneda
> Sent: Monday, April 26, 2010 6:17 PM
> To: 'Dennis Malen'; 'Kenneth Brody'
> Cc: 'FilePro Mailing List'
> Subject: RE: finding things in unix
> 
> Hi Dennis,
>  
> This is totally unrelated, but I have to admit that I am not 
> familiar with
> the correct way.
> 
> I have a business that runs its orders using filePro on Unix. 
> I am now using
> salesforce.com for CRM. How can I export data from filePro to 
> this software
> that is web based?
> 
> Thanks,
> 
> Henry
> 
> -----Original Message-----
> From: filepro-list-bounces+henryca=comcast.net at lists.celestial.com
> [mailto:filepro-list-bounces+henryca=comcast.net at lists.celesti
al.com] On
> Behalf Of Dennis Malen
> Sent: Monday, April 26, 2010 6:00 PM
> To: Kenneth Brody
> Cc: FilePro Mailing List
> Subject: Re: finding things in unix
> 
> Yes and it works perfectly.
> 
> Dennis Malen
> 516.479.5912
> ----- Original Message ----- 
> From: "Kenneth Brody" <kenbrody at spamcop.net>
> To: "Dennis Malen" <dmalen at malen.com>
> Cc: "FilePro Mailing List" <filepro-list at lists.celestial.com>
> Sent: Monday, April 26, 2010 5:03 PM
> Subject: Re: finding things in unix
> 
> 
> > On 4/26/2010 4:27 PM, Dennis Malen wrote:
> > [...]
> >> From: "Jean-Pierre A. Radley" <appl at jpr.com>
> > [...]
> >>> | Yes, your summary and conclusions drawn are correct. 
> Find is the most
> >>> useful
> >>> | as it looks in all directories without providing the 
> proper  PATH.
> >>>
> >>> Another of your mis-statements...
> >>>
> >>> Find does not look "in all directories".  It looks under specified
> >>> directories.
> >>>
> >> Correction: I cd / and then find. Looks in all 
> directories. I have always
> >> been able to find a file this way.
> >
> > Exactly what JP said.  You specified the root directory on 
> the "find" 
> > command line.
> >
> > -- 
> > Kenneth Brody 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 



More information about the Filepro-list mailing list