[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Export to PDF with google maps + msacces export

Maarten Porters

7/28/2008 11:10:00 AM

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?
--
Posted via http://www.ruby-....

1 Answer

Florian Gilcher

7/28/2008 1:45:00 PM

0

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