Outlook & filePro

[GCC Consulting]

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
>