On Fri, 2008-06-13 at 15:46 -0400, Drew Jensen wrote: > 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. > I agree, and I'm only using the spreadsheet as a "translator". Going from OO.o to mySQL.
Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
