+1<br><br><div class="gmail_quote">2009/12/22 Simon Cropper (Botanicus Australia Pty Ltd) <span dir="ltr"><<a href="mailto:scropper@botanicusaustralia.com.au">scropper@botanicusaustralia.com.au</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
This is another - "it would be better" issues.<br>
<br>
When you join two tables and then export the shapefile to "hard code"<br>
the information so to speak. Despite having unique names the resulting<br>
attribute table to the exported shapefile has "j_" in front of all the<br>
field names. This is frustrating because if you have a field name, like<br>
I did, Active2005, Active2007 and Active2009 once this prefix is added<br>
the resulting table has tree fields called "J_ACTIVE20" as the fields<br>
are truncated to 10 characters.<br>
<br>
I suppose I could understand this behaviour if you have duplicate fields<br>
in the original joined table (i.e. the use of a prefix) but the creation<br>
of a table that has duplicate field names is a violation of the rules<br>
around DBFs (i.e. you can't have two fields the same).<br>
<br>
The export facility should review the output file's attribute table<br>
names and confirm that duplicate names have not been generated.<br>
<br>
Personally, I think that if you have a joined table and no fields have<br>
the same name then the exported table should just be a reflection of<br>
this - i.e. the "J_" should not be inserted.<br>
--<br>
<br>
Cheers Simon<br>
<br>
Simon Cropper<br>
Botanicus Australia Pty Ltd<br>
PO Box 160, Sunshine, Victoria 3020.<br>
P: 9311 5822. M: 041 830 3437.<br>
mailto: <a href="mailto:scropper@botanicusaustralia.com.au">scropper@botanicusaustralia.com.au</a><br>
<mailto:<a href="mailto:scropper@botanicusaustralia.com.au">scropper@botanicusaustralia.com.au</a>><br>
web: <a href="http://www.botanicusaustralia.com.au" target="_blank">www.botanicusaustralia.com.au</a> <<a href="http://www.botanicusaustralia.com.au" target="_blank">http://www.botanicusaustralia.com.au</a>><br>
<br>
_______________________________________________<br>
Gvsig_internacional mailing list<br>
<a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
<a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Juan Ignacio Varela García (Nacho Uve)<br>Coordinador Grupo de Desarrollo <br>Cartolab - Laboratorio de Ingeniería Cartográfica<br><a href="http://www.cartolab.es">http://www.cartolab.es</a><br>
<br>ETS Ingeniería de Caminos, Canales y Puertos<br>Universidade da Coruña<br>Campus de Elviña - 15071 A Coruña (España)<br>(34)981167000 ext. 5493<br>