Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On 07/08/2013 02:45 AM, Alexander Thurgood wrote:
Le 07/07/13 21:37, Mark LaPierre a écrit :

Hi Mark,

Any suggestions on how to proceed from here?  Do I just copy and paste
the data from the spreadsheet directly into the mySQL table?

You could try this :

1) Open your ODB file, click on the Tables icon so that you can see the
list of tables in your mysqldb.

2) Now open your Calc spreaadsheet.

3) In the top left hand corner of your spreadsheet, click on the on the
grey corner square/rectangle so that the whole sheet gets selected.

4) Now drag and drop the whole sheet to the space where your mysql table
list is visible within the ODB container and the copy data assistant
should start up. Bear in mind that the assistant doesn't always
recognize and set field types correctly when converting from Calc to
Base, so you will have to check this before validating the creation of
the table, otherwise you may end up with truncated data in your table or
some funky odd stuff. The most problematic ones seem to be date/datetime
strings. If you have images pasted in your spreadsheet cells as part of
your data set, these will not be converted to binary large objects by
the assistant.



Okay, that worked pretty well. It's still not a good solution because, to make it work with the multitude of spreadsheets that I have, I have to import each one by dragging and dropping then spending several minutes defining all the data types to match the internal table that I want to import the data into. This would be so much easier if I could link to the external spreadsheet, import the data from it, then copy the new spreadsheet to the same name/location as the linked file, start up the LO-BASE and import that batch of data into the SQL back end.

I get a new spreadsheet every week with some duplication of data on each sheet from what was on the previous sheet. I don't want to copy and paste the duplicate data into the main table. I'll have to think about this one for a while.

Thank you for the solution Alex. It's a good start to what I hope is a workable solution.

   ^ ^  Mark LaPierre
Registered Linux user No #267004

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.