<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143609#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143609">bug 143609</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>Brant: I had forgotten about your email so I'm copying/pasting here so everyone
have the information:
"
If 7.2 is not made more forgiving to text field
string lengths in excess of the amount specified in the odb table master file,
then users will have to make sure that specified string length for each text
field is at least equal to the maximum length in the table for that field.
Exporting to a calc spreadsheet, copying the field headings out to the right,
using the LEN and Max functions and then updating the odb master file using
7.1 [upload file format length importing into 7.2] appears to solve the
problem.
The error I posted showed the master file specified 30 but base 7.2 found a
string length of 35. I found 10 specified and a 12 maximum field length and
20 specified and a 28 maximum. Each text field has to be corrected. I know
that I was lazy in that I used the auto feature for 10/100/1000 rows with an
upload of 31,000 rows. In 7.0 and 7.1 that was not a problem, a file upload
with with string lengths in excess of the specified amount would upload/open
and it does not appear to have truncated the data.
"</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>