# Export to PDF with google maps + msacces export

**URL:** <https://www.ruby-forum.com/t/export-to-pdf-with-google-maps-msacces-export/144299>\
**Category:** Ruby\
**Created:** [July 28, 2008, 1:10pm UTC](https://www.ruby-forum.com/t/export-to-pdf-with-google-maps-msacces-export/144299 "2008-07-28T13:10:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![temesta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/e9bcb4/32.png) [@temesta](https://www.ruby-forum.com/u/temesta)\
**Post date:** [July 28, 2008, 1:10pm UTC](https://www.ruby-forum.com/t/export-to-pdf-with-google-maps-msacces-export/144299/1 "2008-07-28T13:10:42Z")

</div>

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

What’s the best way to tackle these issues? I was wondering if it’s  
possible to just take a screenshot of the form page and convert the jpg  
file to a pdf document (serverside). Is this possible?

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.

What do you guys think of this?

---

<div class="post-metadata">

**Author:** ![temesta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/e9bcb4/32.png) [@temesta](https://www.ruby-forum.com/u/temesta)\
**Post date:** [July 28, 2008, 3:46pm UTC](https://www.ruby-forum.com/t/export-to-pdf-with-google-maps-msacces-export/144299/2 "2008-07-28T15:46:17Z")

</div>

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

On Jul 28, 2008, at 1:10 PM, Maarten P. 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 G.  
-----BEGIN PGP SIGNATURE-----  
Version: GnuPG v1.4.8 (Darwin)

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