From: Florian Gilcher <flo@...>
Date: 2008-07-28T22:45:27+09:00
Subject: Re: Export to PDF with google maps + msacces export

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jul 28, 2008, at 1:10 PM, Maarten Porters wrote:

> Hi,
>
> my client is looking for an application with different forms. Things  
> are
> a bit nasty because of some requirements:
>
> - each form has a google map included.
> - after submitting the form, a pdf needs to be generated (google map
> included)

There is a static version of google maps. Take the locationdata, ask  
google
for the jpeg, include it.

Step 3: tackle their lawyers. I do not know googles terms of use in  
and out, but i assume
that including their maps in you own documents is violating their  
copyright. (Regardless
of how you do it)

> - my client has a ms access database, data needs to be synchronized  
> with
> this database. (using their database structure - which is very bad)

> The access database is another problem. Things don't need to be
> synchronized in realtime. So I think the easiest way to do this, is by
> exporting and transforming the mysql table with form results to an XML
> file. The client has to import the xml files manually in access.

Possible. Why not write an  XSLT-Stylesheet that transforms Data  
between the two?
I mean - thats really a valid use of XSLT.

Regards,
Florian Gilcher
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)

iEYEARECAAYFAkiNzYoACgkQJA/zY0IIRZa9KwCdFYTtAUsJ1cDBw1mldz5vrSei
UNcAn3b8R6Obu8RsDxCK5rb+NpcgYICt
=FL7z
-----END PGP SIGNATURE-----