Re: [libreoffice-users] Re: Base DB Connections

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.
>
> HTH,
>
> Alex

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.

--
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted