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