I've reported this one as bug <a href="http://trac.osgeo.org/grass/ticket/1445">http://trac.osgeo.org/grass/ticket/1445</a>.<div><br></div><div>Aren<br><br><div class="gmail_quote">On Mon, Sep 5, 2011 at 10:30 AM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com">aren@arencambre.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">So I've narrowed it down a bit more.<div><br></div><div>Attached is an Excel spreadsheet showing the data GRASS is trying to insert interposed with the actual column information (name, field type, length, etc.) in the GRASS DBF. Note that in some cases, the first <b>'</b> in a string doesn't appear; that's just how Excel somehow works. (<b>'</b> means take the following text literally, so <b>'string'</b> may appear as <b>string'</b> in a few places.)</div>
<div><br></div><div>I'm not clear I see anything obscenely wrong, but I did notice a few cases where possibly non-numeric stuff, like <b>18:40:00</b>, is being entered into a field with N type. Is this valid?</div><div>
<br></div><div>Again, the key problem here is that GRASS is giving me a "Cannot insert new row" error, but it gives me no clue of what the actual problem is.</div><div><br></div><div><font color="#888888">Aren</font><div>
<div></div><div class="h5"><br><div><br><div class="gmail_quote">
On Sun, Sep 4, 2011 at 10:19 PM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com" target="_blank">aren@arencambre.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I reported this as a bug: <a href="http://trac.osgeo.org/grass/ticket/1439" target="_blank">http://trac.osgeo.org/grass/ticket/1439</a>.<div><br></div><div>It also happens with the standalone copy of GRASS GIS 6.4.1.<br>
<div>
<br></div><div><font color="#888888">
Aren</font><div><div></div><div><br><br><div class="gmail_quote">On Sun, Sep 4, 2011 at 7:47 PM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com" target="_blank">aren@arencambre.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I am running the GRASS 6.4.1 that is bundled with QGIS 1.7.<div><br></div><div>When I run v.in.ogr.qgis from the UI, I end up with an error. The source is a QGIS PostGIS layer that is just geometry points.</div><div><br>
</div>
<div>From the error details, I assume that v.in.ogr.qgis is just a bridge between QGIS and v.in.ogr as the actual error message is from v.in.ogr.</div><div><div><br></div><div>The command doesn't work, and the error message is unhelpful. Here's the module's output:</div>
<div><b>v.in.ogr -o "dsn=PG:dbname='de' host=localhost port=5432 user='postgres' password='[<i>redacted</i>]' sslmode=disable" "layer=raw.TxDOT crash" "where="Cnty_ID" = '57'" output=pointdata snap=-1 min_area=0.0001</b></div>
<div><b>Over-riding projection check</b></div><div><b>Layer: raw.TxDOT crash</b></div><div><b>Default driver / database set to:</b></div><div><b>driver: dbf</b></div><div><b>database: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/</b></div>
<div><b>Counting polygons for 264398 features...</b></div><div><b>Importing map 264398 features...</b></div><div><b>DBMI-DBF driver error:</b></div><div><b>Cannot insert new row: insert into pointdata values ( 1, '[<i>redacted--was a time</i>]', '', 1, NULL, 32.959261, 2, NULL, NULL, NULL, 6, 0, NULL, 'N', '', NULL, 0, NULL, NULL, NULL, NULL, '', NULL, 0, 2, '762', '', NULL, 0, NULL, 0, NULL, NULL, NULL, '', 'N', NULL, 0, NULL, 'E BETHEL SCHOOL RD', 8, NULL, 0, NULL, 4, 38, NULL, NULL, NULL, '', 'N', NULL, NULL, 'N', 1, NULL, 94, '', NULL, NULL, 8, 22, 22, NULL, NULL, 'N', 'N', '[<i>redacted--was a date</i>]', NULL, 2, NULL, '', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 1, 0, 1, NULL, NULL, 5, 'Y', NULL, NULL, NULL, '', 3, '', NULL, '', 1, 2, NULL, 'N', 'MOCKINGBIRD LN', NULL, 1, '', 57, NULL, 1, NULL, NULL, 64, 0, 1, NULL, 0, NULL, NULL, NULL, '', 1, 0, NULL, 'N', NULL, 'N', 0, NULL, 1, NULL, 2003000146, 'Y', '', NULL, 0, NULL, '', 2, 'Y', -96.968529, 0, 0, NULL )</b></div>
<div><b>Finished with error</b></div><div><br></div><div>I have no idea why this insert didn't work; the error has no details. Searching online, it appears this error message almost always has an explanation provided by GRASS.</div>
</div><div><br></div><div>Is there something that is being done to suppress the error details here?</div><div><br></div><font color="#888888"><div>Aren</div>
</font></blockquote></div><br></div></div></div></div>
</blockquote></div><br></div></div></div></div>
</blockquote></div><br></div>