source: FMP8,
target: OpenOffice spreadsheet,
on a Mac.
This is my first reasonable project.

I'll have a major table "timeBase" in filemaker which will grow monthly
by ca. 600 records; only a few fields. Based on this table, I want to
build graphic charts regularly displaying the most recent two months'
data.

I plan to build an OpenOffice spreadsheet with pre-made graphic charts.
Every period (2 Months) their data has to be replaced with FileMaker
data from FileMaker's source table "timeBase".

Now I need help to find a convenient way how to transfer the data from
FileMaker into this OpenOffice spreadsheet.

I discovered that ODBC seems to be impossible on a Mac. Neither directly
from FMP to OOo, nor from FMP via separate SQL database to OpenOffice.
FMP seems to be a one-way database: Import is fine, but export via ODBC
/ SQL seems to be impossible (at least on a Mac).

Which would be a proper way?
- FMP data export in a csv / Merge file, then import and replace
data in an OpenOffice spreadsheet?
- FMP data export in a XML file, then possibly use this as a
data source for OpenOffice ?
- other automated data transfer ?
- ???

Thanks for your assistance!

Klaus Versl <kversl.fm (AT) arcor (DOT) de> wrote:

it depends of the conveniency you want...

I don't use OpenOffice, but NeoOffice.Presumably, it's the same.

with a script in FMP, you may have a script exporting datas (csv or
other convenient way) in a fixed place and name at a fixed date.

using datasource, you can insert external datas in neoOffice's
spreadsheet with a refreshing rate.

it can be a way among others

--
Philippe Manet

If you just need to create charts you don't need to export. You might try

For charts :
http://www.briandunning.com/chartmaker/
For 'Gantt' :
http://www.clevelandconsulting.com/c...te_cat/CCGantt
http://www.zdnetasia.com/downloads/m...070611s,00.htm
For both :
http://www.x2max.com/en/products/xmCHART/info.html

Ursus

"Klaus Versl" <kversl.fm (AT) arcor (DOT) de> schreef in bericht
news:1h7sd9q.7ilwp816o3l8sN%kversl.fm (AT) arcor (DOT) de...

Thanks!
ursus.kirk <secret (AT) nowhere (DOT) com> wrote:

I want to build Line Charts.

This ChartMaker Pro could be a solution. But I wonder why this example
line Chart works with my version of FMPA8 (english) but not with my FMP7
(multi-language).

manet <pmanet (AT) invivo (DOT) edu> wrote:

This seems to be a promising method.
Thanks! I'll have to do a lot of preparation first. So it's good to know
that in the end it should be worth it.

Ursus,
I am glad you found enoughly interesting what I said in the message I
sent on Dec 15 on this forum on the thread "Re: FileMaker Pro 6, project
scheduling, Gantt charts?" to repeat it word for word under your name
....
And you got thanks for it.
Remi-Noel

-------------------My message-----------------
You may try :
For charts :
http://www.briandunning.com/chartmaker/
For 'Gantt' :
http://www.clevelandconsulting.com/c...te_cat/CCGantt
http://www.zdnetasia.com/downloads/m...070611s,00.htm
For both :
http://www.x2max.com/en/products/xmCHART/info.html
Remi-Noel

-------------------Your message-----------------
"ursus.kirk" <secret (AT) nowhere (DOT) com> a écrit :

Since it seems there are people having trouble finding mails as old as two
days, i just copied and pasted. It seems Klaus has the answer he needs for
which i'm happy, and you didn't get what you needed, for which i'm sorry.

I could think some nastyness to say, but I wouldn't.

Klaus: those links were originally collected in this order by Remi-Noel.

Ursus

"Remi-Noel Menegaux" <rnmenegaux (AT) free (DOT) fr> schreef in bericht
news:43a6e239$0$18147$626a14ce (AT) news (DOT) free.fr...

ursus.kirk <secret (AT) nowhere (DOT) com> wrote:

Oh I see. Thanks to Remi-Noel, too. I'm sorry that I may have asked a
similar question again.
But notice: Shortly before that I've done a search in the last three
months' news but nothing really pleased me, and some answers on ODBC
seemed to be contradictory.
I've tried many things on my own. Since I couldn't work out something
useful, I really needed your help how I could move on.

Klaus Versl

Klaus Are you now on the way towards an answer?

Ursus


"Klaus Versl" <kversl.fm (AT) arcor (DOT) de> schreef in bericht
news:1h7vjcx.neze8s181nlkwN%kversl.fm (AT) arcor (DOT) de...