Export to PDF with google maps + msacces export

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?

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs