Export to PDF with google maps + msacces export

M

Maarten Porters

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

Florian Gilcher

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top