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@arcor.de> wrote:

> Which would be a proper way?

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/cp-app/ste_cat/CCGantt
http://www.zdnetasia.com/downloads/mac/swinfo/0,39043228,20070611s,00.htm
For both :
http://www.x2max.com/en/products/xmCHART/info.html

Ursus

"Klaus Versl" <kversl.fm@arcor.de> schreef in bericht 
news:1h7sd9q.7ilwp816o3l8sN%kversl.fm@arcor.de...
> 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! 

Thanks!
ursus.kirk <secret@nowhere.com> wrote:

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

I want to build Line Charts.

> For charts :
> http://www.briandunning.com/chartmaker/

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

> For 'Gantt' :
> http://www.clevelandconsulting.com/cp-app/ste_cat/CCGantt
> http://www.zdnetasia.com/downloads/mac/swinfo/0,39043228,20070611s,00.htm
> For both :
> http://www.x2max.com/en/products/xmCHART/info.html
> 

> "Klaus Versl" <kversl.fm@arcor.de> schreef in bericht 
> news:1h7sd9q.7ilwp816o3l8sN%kversl.fm@arcor.de...
> > source: FMP8,
> > target: OpenOffice spreadsheet,
> > on a Mac.
> > This is my first reasonable project.
> >
> > I plan to build an OpenOffice spreadsheet with pre-made graphic charts.
> > Every period (2 Months) their data has to be replaced with
> > data from FileMaker's source table "timeBase".

manet <pmanet@invivo.edu> wrote:

> Klaus Versl <kversl.fm@arcor.de> wrote:
> 
> > Which would be a proper way?
> 
> 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.

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/cp-app/ste_cat/CCGantt
http://www.zdnetasia.com/downloads/mac/swinfo/0,39043228,20070611s,00.htm
For both :
http://www.x2max.com/en/products/xmCHART/info.html
Remi-Noel

-------------------Your message-----------------
"ursus.kirk" <secret@nowhere.com> a �crit :
> 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/cp-app/ste_cat/CCGantt
> http://www.zdnetasia.com/downloads/mac/swinfo/0,39043228,20070611s,00.htm
> For both :
> http://www.x2max.com/en/products/xmCHART/info.html
>
> Ursus 

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@free.fr> schreef in bericht 
news:43a6e239$0$18147$626a14ce@news.free.fr...
> 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/cp-app/ste_cat/CCGantt
> http://www.zdnetasia.com/downloads/mac/swinfo/0,39043228,20070611s,00.htm
> For both :
> http://www.x2max.com/en/products/xmCHART/info.html
> Remi-Noel
>
> -------------------Your message-----------------
> "ursus.kirk" <secret@nowhere.com> a �crit :
>> 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/cp-app/ste_cat/CCGantt
>> http://www.zdnetasia.com/downloads/mac/swinfo/0,39043228,20070611s,00.htm
>> For both :
>> http://www.x2max.com/en/products/xmCHART/info.html
>>
>> Ursus
>
> 

ursus.kirk <secret@nowhere.com> wrote:

> Since it seems there are people having trouble finding mails as old as two
> days, i just copied and pasted. 
> 
> Klaus: those links were originally collected in this order by Remi-Noel.

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@arcor.de> schreef in bericht 
news:1h7vjcx.neze8s181nlkwN%kversl.fm@arcor.de...
> ursus.kirk <secret@nowhere.com> wrote:
>
>> Since it seems there are people having trouble finding mails as old as 
>> two
>> days, i just copied and pasted.
>>
>> Klaus: those links were originally collected in this order by Remi-Noel.
>
> 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