Keith Clark wrote:
On Thu, 2008-06-12 at 21:50 -0400, Drew Jensen wrote:
Keith Clark wrote:
On Thu, 2008-06-12 at 21:21 -0400, Drew Jensen wrote:
Also - have you tried to divide and conquer.
Split the file in 3 - one segment up to the line before the error.
One segment from the line after the error to the end.
Save the 'naughty' line to a separate file..
---------------------------------------------------------------------
Sort of, I just delete the record and try again. Same error, same
place.
well, I would check then on MySQL forums as you say..sorry.
Drew, get this....To fix the problem, I just went and retyped the data
that was stored in the products_name field. Now it uploads just fine.
Why would this happen?
Well...lol... who knows...by any chance does the field have a fixed
length..did the old data maybe exceed that. Is the product_name field
linked to another table ( related to ) maybe, and if so is it case
sensitive?
The thing to keep in mind is that there are some very fundamental
differences between spreadsheets and databases with regards to data.
At one level:
A spreadsheet doesn't really care what kind of data is in what cell (
your formulas do of course ). While database systems are fundamentally
about rules. The rules describe what is acceptable data and what is not
and the enforcement of those rules is the focus of the system, the
actual data is just payload.
This interplay between spreadsheet and database is always an interesting
one because of this difference.
Larger organizations usually address by getting the data into a formal
database system first - then feeding this into spreadsheets for the
business level users to have at it. Transferring data in that direction
is usually very simple, and is so even with OO.o.
Smaller organizations however tend to go the other way around..the
spreadsheet is the data collector. It is just easier to do it this way.
Create a new file and start entering data. However, if they then need
for some reason, or just want to, move it to a database environment -
transferring from SS to DB can be a much more challenging
experience..and on that score OO.o is, if not weak, at least not robust
in user friendly tools, IMO.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
