<HTML><HEAD><TITLE>Re: [Gvsig_english] Problems with printing and exporting a map containing data from a geodatabase</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17098" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText74142>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>I have created new binaries for the Oracle Spatial extension for testing purposes. You can test them by </FONT><FONT face="Times New Roman" color=#000000 size=3>following these steps:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Go to your gvSIG folder and rename the folder:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>[gvSIG]/bin/gvSIG/extensiones</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>to</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>[gvSIG]/bin/gvSIG/old_extensiones</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Download this file, unzip it and place its folder "extensiones" in the folder mentioned in the previous </FONT><FONT face="Times New Roman" color=#000000 size=3>step:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="https://correo.prodevelop.es/descarga/gvsig/oracle_august_2011/ora_spa_test_12_08_2011.zip">https://correo.prodevelop.es/descarga/gvsig/oracle_august_2011/ora_spa_test_12_08_2011.zip</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Start gvSIG normally and you can test the Oracle Spatial functionalities.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>These are some tests for the Munich people specifically:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Open the table KART_FLAECHE, create a map and export it to PDF or print it to check that </FONT><FONT face="Times New Roman" color=#000000 size=3>everything is ok. I have created a little shapefile with a few rectangles indicating some sophisticated </FONT><FONT face="Times New Roman" color=#000000 size=3>geometries:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="https://correo.prodevelop.es/descarga/gvsig/oracle_august_2011/boxes_for_some_complex_geoms_31468.zip">https://correo.prodevelop.es/descarga/gvsig/oracle_august_2011/boxes_for_some_complex_geoms</FONT><FONT face="Times New Roman" color=#000000 size=3>_31468.zip</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>You can use it to browse them one by one as I did in this video. What I am doing is selecting one by </FONT><FONT face="Times New Roman" color=#000000 size=3>one the rectangles and zooming to them to see the Oracle Spatial geometry of that area:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://www.youtube.com/watch?v=a0m_u-LSq_o">http://www.youtube.com/watch?v=a0m_u-LSq_o</A></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV><FONT face="Times New Roman" color=#000000 size=3></FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>
<DIV>- Somebody sent me a shapefile with two large geometries with dozens of holes. It looked like this:</DIV>
<DIV> </DIV>
<DIV><A href="https://correo.prodevelop.es/descarga/gvsig/oracle_august_2011/two_polygons.png">https://correo.prodevelop.es/descarga/gvsig/oracle_august_2011/two_polygons.png</A></DIV>
<DIV> </DIV>
<DIV>You can try to export it again to Oracle Spatial and it should work, also the printing.</DIV>
<DIV> </DIV>
<DIV>- Test the "Modify geometry > Join" with a 3D Oracle Spatial table (for example KART_FLAECHE) and it should now work.</DIV>
<DIV> </DIV>
<DIV>- Test the geometric restriction when adding an Oracle Spatial layer. It should now work too. In this case I have found a situation where there is still a problem. The problem happens (at least) under these conditions:</DIV>
<DIV> </DIV>
<DIV>-- You have an Oracle Spatial table with a field called GID which has a unique-value restriction </DIV>
<DIV>-- You open that table from gvSIG using a filter (SQL or geometric)</DIV>
<DIV>-- You start the editing mode and add a new element</DIV>
<DIV> </DIV>
<DIV>At least in this case, there can be an error message and you might not be able to insert the data. As for now, the solution is avoiding one of the three conditions above.</DIV>
<DIV> </DIV>
<DIV>- Delete the folder "extensiones" and rename "old_extensiones" to "extensiones" to go back to the original binaries.</DIV>
<DIV> </DIV>
<DIV>These changes will be available in the upcoming gvSIG 1.12. If you find any problem with those binaries, please report it quickly so we can fix it.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV></FONT><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature23395>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de georgsedlmeir<BR><B>Enviado el:</B> lun 06/06/2011 11:55<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] Problems with printing and exporting a map containing data from a geodatabase<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hello,<BR>I would like to revive this thread, have any possible solutions been<BR>discovered in the meantime?<BR>@Juan: Was it possible to track down any errors by evaluating the results<BR>from the database?<BR>Thank you very much.<BR><BR>Best regards,<BR>Georg Sedlmeir<BR><BR>--<BR>View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/Problems-with-printing-and-exporting-a-map-containing-data-from-a-geodatabase-tp6031316p6444488.html">http://osgeo-org.1803224.n2.nabble.com/Problems-with-printing-and-exporting-a-map-containing-data-from-a-geodatabase-tp6031316p6444488.html</A><BR>Sent from the gvSIG users mailing list archive at Nabble.com.<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>