Outlook & filePro

John Esak john at valar.com
Fri Jan 20 20:29:22 PST 2006


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
> >
>



More information about the Filepro-list mailing list