[libreoffice-users] need help off this list - need Linux package choice help

[tonybsa]

Hi Tim

There is a very comprehensive Video editor for Linux called OpenShot 2.0.
Runs well on Ubuntu 16.04. (Not sure about previous ubuntu systems, but am 
pretty sure will run on 14.04 plus).

The program is a Kickstarter success.

OpenShot Video Editor is a free, open-source video editor for Linux licensed 
under the GPL version 3.0.
http://www.opnshot.org

sudo apt-get-repository ppa:openshot.developers/ppa
sudo apt-get update
sudo apt-get install openshot-qt




Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.3
LibreOffice 4.4.5
Scribus 1.4.4
Libre Project 1.5.19
Parallels Desktop 11.02
Ubuntu 16.04
LibreOffice 4.4.4







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: missing in Calc 5.1.5.2

[tonybsa]

> On 9/08/2016, at 09:04, V Stuart Foote  wrote:
> 
> Controls affecting the content of the sheet have been consolidated in the
> Sheet menu. Fill actions are in Sheet -> Fill Cells menu.
WHY?

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Compatibility of LO Base with Access databases

[tonybsa]

In defence of LibreOffice Base.
Unlike Ian I have had very good results with Base.

Over the last 8 years I have used Base as a a "front end" to a MySQL database 
in 5 different countries for different projects.

One database was for the New Ireland (PNG) Provincial Government Old Age & 
Disabled Pension fund. 170,000 records updated and maintained by two dedicated 
data entry people, but accessed by approximately 35 other users. LibreOffice 
Base on Windows 10, 8 and XP PC, on Ubuntu 12.04 PC, on Macintosh OS X laptop. 
All connecting via ethernet and wireless to a Ubuntu 12.04 Server.

Another similar situation with Ministry of Tourism, Tonga collecting data on 
visitors to Tonga and also used for tourism venture's licensing and 
administration and conventions. 25 users connecting LibreOffice Base to MySQL 
on FreeBSD server, with Windows and Ubuntu PCs.

Full administration for 5 divisions in Sanma Provincial Council, Santo, 
Vanuatu. Including HR, Accounts, Youth, Disabilities, Planning, etc. 75 staff 
members, plus external users, with LibreOffice Base connecting to MySQL on 
Ubuntu 14.04 server from Windows (10, 8.1, XP), Ubuntu 12.04 and Macintosh PCs.

Now I used Access (Base not available) at Kokopo Business College for student 
records. Created a database for College Library with Base on Ubuntu PCs 
connecting to central MySQL database via Fibre Optics.

Had real trouble trying to set this up with Access for multiple users (25 
teachers, 10 admin staff).
When I got LibreOffice Base I had similar problems with using the HSQLDB engine.

I found that connecting Base to MySQL was very easy and I had real problems 
trying to connect Access. 
I could also use Base on Linux machines and update all my colleagues to a 
consistent operating system.

You can not export Access forms, reports, macros, etc to use with Base but you 
can export all the data from Access and import it into Base very easily.

Sorry to keep on!!! I have had good results with LibreOffice Base connecting to 
an external database. I also make extensive use of Macros with Base.

Just in case you are wondering -- I am retired and about to have my 75th 
birthday so not just straight out of Uni.!!!

Thanks for listening

Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.6
LibreOffice 5.0.6
Scribus 1.4.4
Libre Project 1.5.19
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4
MySQL, PHP, Apache







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

[tonybsa]

> On 15/04/2016, at 08:54, tonybsa <tony...@me.com> wrote:
> 
> Microsoft Front page;   Scribus

This is incorrect -- Sorry had a slip of the brain or copy / paste !!!

Front page is one of the worst programs for creating Web pages (HTML). Even 
"Dreamweaver" used to have a menu option called "clean up Front page".

My recommendations, amongst the many, many web development programs available,  
is "Bluefish", open source, runs on Linux, Windows, OS X, etc.

So Microsoft Front page;   Bluefish

--

Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.3
LibreOffice 4.4.5
Scribus 1.4.4
Libre Project 1.5.19
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

[tonybsa]

> On 15/04/2016, at 08:19, toki  wrote:
> 
> On 14/04/2016 16:58, nasrin khaksar wrote:

A "couple" more to add to Toki's list

Microsoft Front page;   Scribus
Microsoft Publisher;   Scribus
Microsoft Project;  Libre project



--
Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4
Libre Project 1.5.19
LibreCAD Qt/QMake







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Disabling Tool Tips / Balloon Tips

[tonybsa]

> On 18/03/2016, at 13:00, Remy Gauthier  wrote:
> 
> I can disable tips by going in Tools -> LibreOffice -> Options ->
> Advanced Options -> Advanced configuration. Seach for the keyword "Tip"
> (not case sensitive), then searching for org.openoffice.Office.Common,
> Help -> Tip and setting it to False.


Who decides on all the unnecessary idiotic changes for no apparent good reason?

Adding new options can be put into any menu / sub-menu that the development 
team thinks is appropriate, but moving existing options from one place to 
another is VERY counter productive. Not to say annoying.


--
Tony Bray
tony...@mac.me
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Database help please

[tonybsa]

> On 3/03/2016, at 08:07, John Montgomery  wrote:
> 
> My problem arises when I enter double numbers eg A11, A20 etc, these should
> follow in sequence but do not follow the sequence I want but A10 follows A1
> etc.
> How can I ensure correct sequencing.

Enter A1 to A9 as A01 - A09

Similarly  with B01 - B09, etc

Tony Bray
tony...@mac.me
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] calc filter?

[tonybsa]

> Hi,
> My understanding is you want to re-display the list in the order you provided.

Set B2 to B17 to your list
 Then set A2 to A17 to your required order. Note in column A you are telling 
the numbers in column B where they should appear in the sorted list i.e Number 
16 (sixteen) in column B should end up as number 2 in the sorted list.
Select A2 to A17 and do a sort. 
When asked if you want to extend the sort click "Extend"   

A2 to A17B2 to B17 before sort   B2 to B17 
after sort   Your required order



Hope this makes sense

Tony Bray
tony...@mac.me
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4







-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Base - automatically running a macro on form opening

[tonybsa]

A long set of macros to open & close forms.

To open a form when the database starts 
select "Tools > Customize > Events > Open Document. 
Click Assign: Macro and assign the DBOpen macro.

HERE ARE THE MACROS. 
As I can't send attachments you will have to copy and paste these into your 
Macro Library

'** LOAD LIBRARY **
'Loads all the tools libraries and opens the connection
Sub DBOpen(Optional poEvent As Object)
dim mydbdoc,CurrentDb,mymsg,metb
On Local Error GoTo Error_Sub
mydbdoc = ""
metb = ""
' load the access library containing the functions similar to MS Access
If GlobalScope.BasicLibraries.hasByName("Access2Base") then 
 If NOT GlobalScope.BasicLibraries.isLibraryLoaded("Access2Base") Then
GlobalScope.BasicLibraries.LoadLibrary("Access2Base")
mymsg = "Access loaded"
 End if
End if
REM Use some methods from the Tools library.
  If NOT GlobalScope.BasicLibraries.isLibraryLoaded("Tools") Then
GlobalScope.BasicLibraries.LoadLibrary("Tools")
mymsg = mymsg & " Tools loaded"
  End If
  'loaded the Standard library which applies to this database
  If NOT GlobalScope.DialogLibraries.isLibraryLoaded("Standard") Then
GlobalScope.DialogLibraries.LoadLibrary( "Standard" )
mymsg = mymsg & " Standard dialog loaded"
  end if
 
mydbdoc = ThisDatabaseDocument
   ' msgbox "The following was loaded " & mymsg ,6 , "Loaded"
Call OpenConnection(ThisDatabaseDocument)
call openThisForm 
 Exit_Sub:
Exit Sub
 Error_Sub:
TraceError("ERROR", Err, "Opening database at DBopen", Erl)
GoTo Exit_Sub
End Sub




'** Use this for opening a data form ***
'we use this to open the main menu when the document first opens
Sub openThisForm(optional openname as variant,optional closefrmname as variant)
dim sfrmName,openit
 ' This is the variable for the form that must be opened at the start of program
 'the normal form to open is the "noticefrm", but for data entry on household 
surey
 'we use the demo_menu form. Data entry is restricted this way.
 if IsMissing(openname) then
 sfrmName =  "noticefrm" ' "planningf/demo_menu" '
 else
sfrmName = openname
 end if
'Closefrmname is the form with the calling btn on it or one that was 
sent from a script
 if IsMissing(closefrmname) then
closefrmname = "noticefrm"
 end if
 call thesearetheforms(closefrmname,sfrmName)
end sub

' Use this to open any form from another form 
'Open a form that may be in a folder. The folders are defined by / i.e 
plan/planmenu
Sub openHierachForm(optional openname as variant,optional closefrmname as 
variant)

dim sfrmName as string
dim sfrmtoclosename as string
dim openit, otestform
'dim canIopenthis as boolean ' These are used to check tha the user is
'canIopenthis = false "allowed to open & view this form
 ' openname is the variable for the new form that must be opened
 if IsMissing(openname) then
 sfrmName = "noticefrm" 
 else
 'the source is the button that was clicked. The button may have a tag in the 
Additional Information field
 'This tag defines who is allowed to open the form. If there is no tag then 
anyone can open the form.
otestform = openname.source.model
'check to see if the user has permission to open the openname form
'canIopenthis =  checkstaffnames(otestform)
'if canIopenthis = false then
'   msgbox ("Sorry you are not authorised to view this form",6,"Not 
authorised")
'   exit sub
' end if
sfrmName = openname.source.model.name 
 end if
 'the form we were on when we clicked the "open form" button 
 if IsMissing(closefrmname) then
sfrmtoclosename = openname.source.model.parent.name 
 else
sfrmtoclosename = closefrmname
 end if
call thesearetheforms(sfrmtoclosename,sfrmName)
end sub
'Changed 9 Sept 2015. The names of the forms to open and close
SUB thesearetheforms(sfrmtoclosename,sfrmName)
'open the new form before closing the original. Prevents "flash" of desktop.
 if thisDatabaseDocument.FormDocuments.hasByHierarchicalName(sfrmName) then
thisDatabaseDocument.FormDocuments.getByHierarchicalName(sfrmName).open
  else
msgbox "Sorry I can't find the form " & sfrmName & chr(10) & "Please 
check the name!",6,"Form not found"
end if
if sfrmtoclosename <> sfrmName then
if 
thisDatabaseDocument.FormDocuments.hasByHierarchicalName(sfrmtoclosename) then

thisDatabaseDocument.FormDocuments.getByHierarchicalName(sfrmtoclosename).close
elseif ThisDatabaseDocument.FormDocuments.hasbyname(sfrmtoclosename) 
then

ThisDatabaseDocument.FormDocuments.getbyname(sfrmtoclosename).close
else
msgbox "sorry I can not close the form " & 

Re: [libreoffice-users] Shortcut changes

[tonybsa]

> On 18/10/2015, at 08:17, James E. Lang  wrote:
> 
> PLEASE, developers, think about the impact your change will have on existing 
> users.  The longer a shortcut has existed the more attention should be given 
> should be given to the impact of changing it with shortcuts that have existed 
> for more than one full major release being ALMOST cast in granite. 

This particular change from F4 to Ctrl-Shift_F4 for data source in Calc but not 
in Writer is a massive problem. The F4 shortcut has been around for YEARS.

I now have to re-write my tutorials and workshop examples.
I now have to go back to the hundreds of users that have been using F4 for 
YEARS and try to explain why there is a difference between Calc & Writer.

A large number of the people (I have trained ) that use LibreOffice use F4 for 
mail merge in Writer and Pivot Tables in Calc. 
Because the usual source is a MySQL database where data is being updated on a 
regular basis, the mail merge and pivot tables need updating regularly.

Why was this change made? 
As far as I can see (from the bugzilla history) it was requested in 2013 
because 1 or 2 people, that are changing from Lotus 123 to Calc could not make 
the change from F4 to Shift-F4 for the "Absolute cell reference shortcut".

I don't remember any of "my" users having ever found it necessary to change the 
cell reference from absolute to relative once they have formatted a cell.

So I agree with James Lang & Alexander Thurgood when they decry this change.
Who made the change 2 years after it was requested, without discussing it with 
the people on this list?

Developers, please do NOT make changes to existing menu options and shortcuts 
without FULLY consulting the "professional" users of LibreOffice. 
Thank you.

Tony Bray


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Operating Environment Survey

[tonybsa]

On 26/07/2015, at 5:54, James Knott james.kn...@rogers.com wrote:

 Did they have slide rules way back then?  ;-)
Yep, they were still using slide rules when I joined the Royal Navy in 1959 (No 
that is not a mistake!)

The first computers I wrote about, as a technical author in 1969, was the 
Energy Management Analogue Computer  (EMAC) and the Crosswind Control 
Computer for the USAF -- C5A Galaxy aircraft. Followed by computers for 
Concorde with the English-French Consortium.

Analogue computers (which people dispute were computers) did not use any 
software, so if you wished to change a parameter you probably needed to replace 
a couple of resistors and capacitors, change the input to a feedback loop, etc.
These computers had the equivalent of For and While loops, maths functions, 
such as X + Y (through AND gates). Most operations, including the mechanical 
read-out updates were done by triggering a transistor -- hence we got the 0 
or 1 output.

Been working with software since -- still creating databases using LibreOffice 
Base connected to MySQL servers, creating WEB sites using HTML5, etc.

Not sure when this retirement thing is supposed to take place ;-)

By the way I am a Pom, but have been living in New Zealand for the past 43 
years. Yea there do seem to be a lot of old farts on this list ;-)

Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009 
Mac OS X  10.9.5.
LibreOffice 4.4.3, Coda 2 and a whole lot more.
Also runs Ubuntu 14.04 desktop using Parallels 

Acer 15 inch laptop, 4 GB RAM
Ubuntu 14.04 desktop, 
LibreOffice 4.3.? , BlueFish, MySQL server,  MySQL workbench. 
Mainly used as backup to HP server and for testing.

HP 15 laptop as server 
Ubuntu 14.04 server, Apache2, PHP 5.5, MySQL server, MySQL workbench, Firefox, 
Chrome







-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

[tonybsa]

Use Edit  Fill  Series 

Click in cell A2
Right click Format Cells  date  Fri, 31Dec 99  OK
With A2 still selected shift click A6
Click EditFillSeries
When the dialog box opens
Select Down  Date  Day
Enter start date:  3/08/2015
Enter finish date: 7/08/2015
Increment: 1
Click OK

Result:
Mon, 3 Aug 15
Tue, 4 Aug 15
Wed, 5 Aug 15
Thu, 6 Aug 15
Fri, 7 Aug 15


The secret i using the Edit  Fill  Series menu options

So now you have the dates, with days in the A column you could put time along 
the the row 1. 
Starting at B1 and use the Edit  Fill  Series Right  Date . Start 08:00, 
End 12:00 Increment 1:00.
Just ensure that the Cell Format for the Row is set to Time rather than Date.

Hope this helps.

I came into this world with nothing.
Fortunately I have got most of it left.
Tony Bray
tony...@me.com




-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: Re: [libreoffice-users] Installation version chaos

[tonybsa]

On 17/04/2015, at 19:05, Tom Davies tomc...@gmail.com wrote:

 There's a tiny gotcha in there that i only noticed because i have done
 the same thing myself.  It's the . in
 sudo apt-get remove libreoffice*.*
 
 Try again but this time without the extra * and the . before it;
 sudo apt-get remove libreoffice*

If you are using apt-get on Ubuntu (don't know about other versions of Linux) 
the best way to ensure that you have removed ALL Libreoffice information is

  sudo apt-get purge libreoffice?

Note: Use the ? mark not * and no spaces.

Hope this helps
Tony Bray
-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Styles and Formatting Not Working

[tonybsa]

On 22/02/2015, at 12:37, Taang Zomi libreofficez...@gmail.com wrote:

Just a suggestion with the Save button appearing not to dim after saving.
Do you have 
Allow to save document even when the document is not modified 
selected under the LibreOffice  General Options?

This sometimes means that the save button does not dim as you can still save 
again.

Just a thought




Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.9.5.
LibreOffice 4.2.6.3

Ubuntu 14.04, LibreOffice 4.3.? Acer 15 inch laptop, 4 GB RAM


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] And while I'm here, data extraction

[tonybsa]

On 3/02/2015, at 22:55, Mark Stanton m...@vowleyfarm.co.uk wrote:

 I've been thinking about this.
 
 Firstly, the cut'n'paste solution isn't working here for me on the results 
 (23 rows, perhaps ten columns) of a query in SQL view with Fedora Linux (20) 
 and LO 4.2.8.2 (please don't suggest I upgrade to the latest as I'm using the 
 OS repos, and there hasn't been any work on Base in that time anyway)(has 
 there?). It doesn't work in design 
 view either I now find.

You do not select the cells from an open query.
Just select the query in the Query panel i.e the actual name of the query and 
copy that.
Then paste that into your spreadsheet and all your data should be imported.

So don't open the query just copy the query name.

Hope this makes sense.

Tony Bray


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] JDBC-connector to MySQL database

[tonybsa]

On 2/02/2015, at 6:53, Heinrich Stöllinger hc.stoellin...@aon.at wrote:

 I don't see any error messages in any of the logs I wonder what's the 
 problem...

When I run your Create Table script (copied from your Email) in MySQL Workbench 
I get the following error

Error Code: 1005. Can't create table 'sanmadb_test.inventar' (errno: 150)   
0.187 sec

The 'sanmadb_test' bit is the name of the database I used to try and create the 
table.

I know that you said the table was showing up when using MySQl from the 
command line, but I wonder if it is actually being re-created when you use JDBC?
Is the table actually being created in your database?

Regards
Tony Bray



-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] MySQL - LO Base question.

[tonybsa]

On 24/01/2015, at 6:13, Ian Whitfield whitfi...@telkomsa.net wrote:

 I now need to set-up my Database again but have a question.
 (My Database has only one table with about 2500 records and each record has 
 80 fields.)
 
 Which is the correct procedure??
 2) Set-up the Database in MySQL then use LO Base to create the table and do 
 the import

I would suggest option 2.

Sorry about the long post, but I hope this helps.

Login to MySQL as normal
In MySQL create an EMPTY database  mysql create database newname ; or reuse 
your old database name.
Quit MySQL \q

Take your CSV file and open it in LibreOffice calc.
Save the spreadsheet

Open new database in LibreOffice Base

Select connect to an Existing Database
Select MySQL
on the next screen 
Select the driver (I use JDBC)
on the next screen 
Enter the name of the database you created in MySQL
Enter the server, probably Localhost or 127.0.0.1
Accept the default Port
on the next screen
Enter your MySQL logon name 
Tick Password required
on the Final screen
Select Yes register the database
Click Finish

Now LibreOffice will ask for a new database name -- this is the name of the 
Base Front End you will be using to connect to the MySQL server (it is NOT a 
database!).
When LibreOffice creates the new front end it should open with a blank set of 
tasks.
Open the spreadsheet you created earlier.
Select ALL the data including column headings
Copy this data 
Go to your front end
Make sure that Tables are selected in the list of tasks
Click in the blank area below the Options panel
Paste your data!!
LibreOffice will ask you to confirm that you want to add the definition  data, 
and that the first row is column headings
Click OK
On the next screen you need to select the columns (or fields) that you want to 
import. Just select all.
Click Create
LibreOffice should, all being well, create a new table with all your data in 
the correct columns.
You may be asked if you want to add a primary key. I suggest that you say yes. 
You can always change this later but it saves problems when inserting a pasted 
set of data.

You should now have a new database with all your original data as previously.
You may have to do some tidying up if the data types did not import 
correctly, such as Dates.

Sorry about the long post, but I hope this helps.


Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.9.5.
Ubuntu 14.04 on a Acer PC 4GB RAM
LibreOffice 4.2.6  4.3



-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

[tonybsa]

On 20/01/2015, at 9:16, Rich Shepard rshep...@appl-ecosys.com wrote:

 Tony,
 
  With the help of one subscriber to the unixODBC mail list we may have
 found the problem source. 
 dltest /usr/local/lib/libsqlite3odbc.so SQLConnect

Good to know that there is a solution. 
Perhaps the documentation team can find time to add this information to the 
Base User Guide or Help or somewhere.

Tont


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

[tonybsa]

On 20/01/2015, at 8:08, Rich Shepard rshep...@appl-ecosys.com wrote:

 Tony,
 
  I've done this several times, but the only drivers visible are for sun
 (now oracle) star. See attached .png.

Yes I was aware of this but thought that just maybe the oracle drivers would 
work for you.
Sorry all out of other suggestions.




Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.9.5.






-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

[tonybsa]

On 20/01/2015, at 6:40, Rich Shepard rshep...@appl-ecosys.com wrote:

  The connection to the data source 'filename' could not be established.
  [unixODBC][Driver Manager] Data source name not found, and no driver
 specified.

  What am I doing incorrectly here?

You may need to go to LibreOffice  Tools  Options  LibreOffice Base  
Connections and select the ODBC Driver, under the Connection Pool dialogue.
Select the driver and click the Enable pooling for this driver checkbox.

This MAY solve the problem. No promises!




Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.9.5.






-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

[tonybsa]

On 19/01/2015, at 4:43, Rich Shepard rshep...@appl-ecosys.com wrote:

 Step 4 is 'Save and Proceed' which is where my choices do not produce the
 result I expect.
 
  The top portion of the dialog box has 2 radio buttons: do I want to
 register the database with Base? I assume so, but the help button moves the
 open firefox to that virtual desktop and presents a page with no
 information. What are the effects of registering and not registering the
 database with Base?
It is a good idea to register the database as then the data is accessible to 
the Writer and Calc programs under View Data Source


The DATABASE terminology confusion
The problem is the Database terminology. Unfortunately there are two times 
the word Database gets used, once when you create a database such as SQLlite or 
MySQL, etc. and once when you create a 'front end to your database.

LibreOffice Base can be a database!! but in your case the database is SQLlite 
and the LibreOffice Base is just a way of working with the data from the 
SQLlite database.
When you save the newly created connection to the database by giving your Base 
file a name you are in fact creating the front end, NOT a database!!
So once you save this front end file and open it you will find all your 
SQLlite tables, views, procedures, etc. displayed in the front end and you can 
then edit or work with the data in the SQLlite database.
If your connection to the database is good you can now control the input and 
extracion of data using your Base front end.

Hope this all makes sense?
SO go ahead register your database (which in fact is registering the Base 
front end) and when asked to save the new file you can give it any name you 
like as you are saving the front end to your PC.

For instance I have a real database on a MySQL server called sanmadb , the 
front end (in Base) on my laptop is called Sanma Central Database. 
The accountants base front end is called Sanma Finances but both front ends 
connect and get their data from the same MySQL database (sanmadb). 


-- 
To unsubscribe e-mail to: users+unsubscr...@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