Outlook & filePro

GCC Consulting gccconsulting at comcast.net
Sat Jan 21 08:40:39 PST 2006


John,
What I was looking to do, was move date from fp into outlook.  Not
visa-versa.

What I did was get the csv structure needed for my output.

Richard 

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of John Esak
> Sent: Friday, January 20, 2006 11:29 PM
> To: Fplist (E-mail)
> Subject: RE: Outlook & filePro
> 
> No, no. you missed the point of my question. There is no 
> trouble importing line by line and field by field. It is 
> difficult to impossible to write a generic routine to 
> enumerate the "heading" of a .csv for example. I want to be 
> able to print a quick list that looks like this:
> 
> 1 First Name
> 2 Last Name
> 3 Company
> 4 address 1
> 5 address 2
> 
> and so forth. To do this in filePro, you can not subscript 
> the fields in the import so you can not write a non-hardcoded 
> function (subrouting, call table, whatever) to do this. It 
> sounded as if you might have done that somehow.
> 
> Thanks,
> 
> John
> 
> 
> > -----Original Message-----
> > From: GCC Consulting [mailto:gccconsulting at comcast.net]
> > Sent: Friday, January 20, 2006 8:18 AM
> > To: john at valar.com; 'Fplist (E-mail)'
> > Subject: RE: Outlook & filePro
> >
> >
> > Top Post for John:
> >
> > I went to Outlook's help file.  It told me to export a CSV 
> file from 
> > the calendar module and the n open the file created.  It has the 
> > headings needed.  Sometimes the simplest this allude us.
> >
> > There are 21 fields exported.  The odd thing in the CSV 
> file exported 
> > is names "my contacts" if one doesn't change it.
> >
> > I haven't tested the import yet but will "assume" that it will work 
> > properly.
> >
> > Richard Kreiss
> > GCC Consulting
> >
> >
> > > -----Original Message-----
> > > From: filepro-list-bounces at lists.celestial.com
> > > [mailto:filepro-list-bounces at lists.celestial.com] On 
> Behalf Of John 
> > > Esak
> > > Sent: Thursday, January 19, 2006 9:38 PM
> > > To: Fplist (E-mail)
> > > Subject: RE: Outlook & filePro
> > >
> > >
> > > Richard,
> > > Next time you're in the room (which is almost the time 
> except just 
> > > now...
> > > :-)  tell me how you used the column headings of the .csv 
> to do the 
> > > thing you did.)  I want to write a generic "grabber of 
> the field sin 
> > > a .csv, but I haven't been able to come up with anything 
> elegant.  
> > > The only thing so far is this... which is so stupid... the 
> > > limitation of not being able to use subscript variables for the 
> > > imported  fields of any record is the problem.
> > > Do you have a good way to do this...:
> > >
> > > ::import ascii pay=(fixed_source) F=, O=" C=" R=\n:
> > > :not pay:goto fin_pay:
> > > ::declare h_head(8,.0):
> > > :h_head eq "":h_head=open("/tmp/headings","rwc0"):
> > > ::h_wl=writeline(h_head,"1" < pay(1)):
> > > ::h_wl=writeline(h_head,"2" < pay(2)):
> > > ::h_wl=writeline(h_head,"3" < pay(3)):
> > > ::h_wl=writeline(h_head,"4" < pay(4)):
> > > ::h_wl=writeline(h_head,"5" < pay(5)):
> > > ::h_wl=writeline(h_head,"6" < pay(6)):
> > > ::h_wl=writeline(h_head,"7" < pay(7)):
> > > ::h_wl=writeline(h_head,"8" < pay(8)):
> > > ::h_wl=writeline(h_head,"9" < pay(9)):
> > > ::h_wl=writeline(h_head,"10" < pay(10)):
> > > ::h_wl=writeline(h_head,"11" < pay(11)):
> > > ::goto pay_fil:
> > >
> > > This would be a one-liner prc.table if import had the 
> ability to use 
> > > an expression as the subscript, instead of the hard-coded 
> approach 
> > > here. Not too horrible to keep in a library and chop down 
> or grow to 
> > > needed size for the file at ahnd... but a one-liner loop routine 
> > > would be SO much better.
> > >
> > > So, *how* did you get the column headings??
> > >
> > > John
> > >
> > >
> > > > -----Original Message-----
> > > > From: filepro-list-bounces at lists.celestial.com
> > > > [mailto:filepro-list-bounces at lists.celestial.com]On 
> Behalf Of GCC 
> > > > Consulting
> > > > Sent: Thursday, January 19, 2006 3:59 PM
> > > > To: gcc at comcast.net; Filepro-list at lists.celestial.com
> > > > Subject: RE: Outlook & filePro
> > > >
> > > >
> > > > So, I can't type and the spell checker passed my mistype.
> > > >
> > > > Found the solution, created a csv output from Outlook
> > > calendar. Column
> > > > headings gave me the structure needed to import data 
> into outlook 
> > > > colander.
> > > >
> > > > Richard Kreiss
> > > > GCC Consulting
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: filepro-list-bounces at lists.celestial.com
> > > > [mailto:filepro-list-bounces at lists.celestial.com] On 
> Behalf Of GCC 
> > > > Consulting
> > > > Sent: Thursday, January 19, 2006 11:12 AM
> > > > To: Filepro-list at lists.celestial.com
> > > > Subject: Outlook & filePro
> > > >
> > > > Has anyone "linked" filePro output to outlook colander program?
> > > >
> > > > Richard Kreiss
> > > > GCC Consulting
> > > >
> > > >
> > > > _______________________________________________
> > > > 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
> > >
> > > _______________________________________________
> > > 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