Re: [libreoffice-users] Re: Time Calculations in LOBase (SOLVED)

AM08/18/16 11:00 AM08/18/16 12:00 PM08/18/16 03:15 PM7.75 08/19/16 06:30 AM08/19/16 11:00 AM08/19/16 12:00 PM08/19/16 03:15 PM7.75 I think I can work out the other calculations I need based on this bit. Many thanks for the help and examples. Regards, Don On F

Re: [libreoffice-users] Re: Time Calculations in LOBase

Many thanks to Robert and Bruce. I will try this as I have time over the weekend, and report back how it goes. On Thu, Aug 25, 2016 at 7:15 PM, Bruce Hohl wrote: > I can confirm as follows. > > With this in table1: > ID time1 time2 > 1 01/01/16 11:30 PM 01/02/16 04:00 AM >

Re: [libreoffice-users] Time Calculations in LOBase

Just using the HSQLDB embedded. On Thu, Aug 25, 2016 at 1:00 PM, Bruce Hohl <bruceh...@gmail.com> wrote: > What type of database is used - HSQLDB embedded, HSQLDB, MySQL, > PostgreSQL, etc? > > On Thu, Aug 25, 2016 at 11:54 AM, Don Parris <parri...@gmail.com> wrote: &

[libreoffice-users] Re: Time Calculations in LOBase

function gives me what I am looking for, but maybe it can with some extra work. I was pretty sure I would find some examples of this type of calculation out there. On Thu, Aug 25, 2016 at 11:54 AM, Don Parris <parri...@gmail.com> wrote: > Hi all, > > I need to do some time calculat

[libreoffice-users] Time Calculations in LOBase

Hi all, I need to do some time calculations in LO Base queries - seems fairly straightfoward, but I can't seem to find any good info on how this is done. I am calculating hours worked in a day (could span midnight, but that is not normally the case). In a certain app similar to Base, I can do:

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join? - RESOLVED

On Tue, Jan 5, 2016 at 5:15 PM, <libreoffice-ml.mbou...@spamgourmet.com> wrote: > Don Parris wrote: > >> Still trying to work out the OUTER JOIN syntax apparently. I tried a >> simpler outer join statement: >> SELECT >> "tCoreType"."type" &

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

On Sat, Jan 2, 2016 at 4:36 AM, Luuk wrote: > > > On 01-01-16 22:08, Paul Steyn wrote: > >> Hi Don, >> > > > You are absolutely right, but the *syntax* is different in LO >> > see link i posted earlier > > > > > Still trying to work out the OUTER JOIN syntax apparently.

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

On Fri, Jan 1, 2016 at 1:18 PM, Luuk wrote: > reply below > >> >> > > This was the second link i gave you > > it says: > Example > |select Article.* from {oj item LEFT OUTER JOIN orders ON item.no > =orders.ANR} > > The link was: > >

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

On Sat, Jan 2, 2016 at 4:36 AM, Luuk wrote: > > > On 01-01-16 22:08, Paul Steyn wrote: > >> Hi Don, >> >> Your SELECT statement is indeed incorrect; it seems as though you don't >> fully understand joins (I could be mistaken, but your syntax is off >> by enough to suggest

[libreoffice-users] LOBase Query - Left or Right Join?

Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but should. I know why: that contact has phone

Re: [libreoffice-users] LOBase Query - Left or Right Join?

On Fri, Jan 1, 2016 at 10:59 AM, Luuk wrote: > > > > >> >> >> > > In design mode, right-click on the link between two tables, and click > 'edit'... > > > If you want to manually edit the SQL, the syntax is shown here: > >

[libreoffice-users] Re: LOBase Query - Left or Right Join?

t;tCntEntity"."entity_id" AND "tCntEntityPerson" JOIN "tCntPerson" ON "tCntEntityPerson"."person_id" = "tCntPerson"."person_id" AND "tCntContactAddress" LEFT JOIN "tCntEntity" ON "tCntContactAddress"

Re: [libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger <ville...@t-online.de> wrote: > Am 12.12.2015 um 14:57 schrieb Don Parris: > > I want to use KAddressBook as the resource for my LibreOffice mailmerge. > > Unfortunately, the only way this seems possible is by exporting

[libreoffice-users] Use KAddressBook As LibreOffice Resource

I want to use KAddressBook as the resource for my LibreOffice mailmerge. Unfortunately, the only way this seems possible is by exporting the contacts from KAddressBook to a CSV file. I have searched high and low, and cannot find any good way to use KAddressBook. The KDE-PIM group seems to offer

Re: [libreoffice-users] Re: Base Reports - Getting Monthly YTD Averages

Thurgood alex.thurg...@gmail.com wrote: Le 26/09/2014 11:03, Don Parris a écrit : Thanks Alex. The underlying query gets the month from the date, as well as the total, average, max and min for each month. The results are, of course, already grouped calculated by month. I was able to get

Re: [libreoffice-users] Re: Base Reports - Getting Monthly YTD Averages

from the monthly averages? Thanks, Don On Fri, Sep 26, 2014 at 3:45 AM, Alex Thurgood alex.thurg...@gmail.com wrote: Le 25/09/2014 23:59, Don Parris a écrit : Hi Don, shown, and that works great. I used the Accumulation function to do this. But when I try to get an overall average, I

[libreoffice-users] Base Reports - Getting Monthly YTD Averages

Hi all, I have collected rainfall totals in Base and wanted to create a report showing the average for each month, as well as an overall average for the period of months in the report (YTD Average). In other words, I want to (effectively) average the monthly averages. I created a query to get

[libreoffice-users] Any Good Info on Using LibreOffice Base With KDE-PIM?

Hi all, I asked this on the KDE-PIM mailing list, but thought I would raise my question here as well - maybe someone here already uses LO with Kontact. Is there any good info anywhere on using KDE-PIM (Kontact) with LibreOffice (especially Base)? Does Base read vCard files? Is there a way to do

Re: [libreoffice-users] Any Good Info on Using LibreOffice Base With KDE-PIM?

Thanks Valter! That is fairly helpful. There is even discussion on using PostgreSQL as the back-end in place of MySQL. Maybe I can mak a little progress on this! On Tue, Aug 13, 2013 at 4:05 PM, Valter Mura valterm...@libreoffice.orgwrote: In data martedì 13 agosto 2013 15:47:09, Don

Re: [libreoffice-users] Calc - Matching Up Text Fields

connecting LOBase to PostgreSQL is still the top-ranked story on my site, so hopefully I can add some more LO action. :-) On Fri, Aug 2, 2013 at 6:23 AM, Errol Goetsch er...@xe4.org wrote: On 2013/08/01 11:31 AM, Don Parris wrote: Unfortunately, one bank throws everything except for the date

Re: [libreoffice-users] Calc - Matching Up Text Fields

:27 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 21:35 31/07/2013 -0400, Don Parris wrote: Again, I just need to figure out how to extract that bit from the bank's description. Any thoughts on that? As I mentioned, that depends on the precise possibilities in the bank data

[libreoffice-users] Calc - Matching Up Text Fields

Hi all, I download two files from my banks that have transaction descriptions that look like so (the one with a * to the left is from Bank #2 - the rest are from Bank #1): PURCHASE AT MY GROCER #NNN, CHARLOTTE, NC ON 050913 FROM CARD#: * MY GROCER #NNN CHARLOTTE NC

Re: [libreoffice-users] Calc - Matching Up Text Fields

Thanks Brian, On Wed, Jul 31, 2013 at 7:46 PM, Brian Barker b.m.bar...@btinternet.comwrote: At 18:32 31/07/2013 -0400, Don Parris wrote: SNIP All this doesn't help much until we know exactly what you need to extract from all this. I hope it became more clear further down that I really

Re: [libreoffice-users] Re: Base PostgreSQL Transactions

and...@pitonyak.org wrote: On 07/22/2013 02:48 AM, Alex Thurgood wrote: Le 19/07/2013 22:31, Don Parris a écrit : Hi Don, One possible way is to set up your form (which after all, is only a Writer or Calc document) as a dummy interface that is not bound to any data fields, and then use Basic

Re: [libreoffice-users] Base PostgreSQL Transactions

+Basic+http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooksfield-keywords=Database+Programming+with+OpenOffice.org+Base+%26+Basic+ On 07/19/2013 04:31 PM, Don Parris wrote: Thanks Andrew, So far, none of the links really strike me as helpful. Sorry, but this is fairly new

Re: [libreoffice-users] Base PostgreSQL Transactions

On 07/18/2013 04:05 PM, Don Parris wrote: Hi all, I have a 4-table DB in PostgreSQL to which I connect using LibreOffice Base. I have a form with 2 subforms in place that allows me to: Select an existing entity (from the ENTITY table) Add a new financial transaction (to the TRANSREC table

[libreoffice-users] Base PostgreSQL Transactions

Hi all, I have a 4-table DB in PostgreSQL to which I connect using LibreOffice Base. I have a form with 2 subforms in place that allows me to: Select an existing entity (from the ENTITY table) Add a new financial transaction (to the TRANSREC table) Add new line items for each transaction (to the

Re: [libreoffice-users] Base PostgreSQL Transactions

On Thu, Jul 18, 2013 at 4:27 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If you are looking for a good guide about Macros then Andrew Pitonyak's guide is supposedly the best https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Apparently it

Re: [libreoffice-users] Calendar software

Hi all, Kontact is KDE's Outlook competitor and the latest (experimental) version can be found here: https://wiki.kolab.org/Client_windows_kontact Kontact even offers a Summary page like Outlook (if you like that). It should be worth a look. I tried Digikam on Windows (briefly) and it seemed

Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

our work they would upgrade to read *.odf files -- and they did. Cost them some money for new licenses but they upgraded their MS licenses to read my files. On Mon, Jul 23, 2012 at 6:03 PM, Don Parris parri...@gmail.com wrote: I would like to take something of a straw poll, if that's ok. I

[libreoffice-users] Do You Share ODF Documents With MS Office Users?

I would like to take something of a straw poll, if that's ok. I simply want to know whether any of you have shared documents using the ODF format with MS Office users (preferably in a business environment), and what was the reaction? What problems I am not seeking advice on how to share

Re: [libreoffice-users] Migrating from Windows; take it slow

On 07/22/2012 11:05 AM, Tom Davies wrote: Hi :) Ok, so i have posted 'a few' anti-MS posts but not everyone is ready to suddenly jump into the alien world of the scary sounding GNuLinux or unix-based OSes. Windows is supplied on almost every machine bought anywhere in the world so why

[libreoffice-users] Updated Tutorial for Connecting LibreOffice to PostgreSQL via SDBC 0.8.1

Hi all, I have now posted an updated tutorial for connecting LibreOffice to PostgreSQL using the native SDBC driver (0.8.1). My old tutorial mentioned that it was not then possible to add or edit data. This updated version address the read/write issue and is a (hopefully) much better tutorial -

Re: [libreoffice-users] Paragraph Styles Not Updating

On Fri, Nov 4, 2011 at 07:17, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I gather this has been fixed by just re-writing the document? I have just had to do something similar for a Newsletter made for a particular version of Word that didn't work at all well in our current version or in

Re: [libreoffice-users] Paragraph Styles Not Updating

On Thu, Nov 3, 2011 at 04:09, Cor Nouws oo...@nouenoff.nl wrote: Hi Don, Don Parris wrote (01-11-11 02:19) I am having to update a couple documents (contact directories) I created under OOo some years ago. I had to save the documents in MS Word format (*.doc), but used paragraph styles

Re: [libreoffice-users] Paragraph Styles Not Updating

On Wed, Nov 2, 2011 at 12:43, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I'm not sure what has gone wrong. Sometimes things go a little strange when saved as MS formats. I guess documentation is unhelpful? http://wiki.documentfoundation.org/Documentation/Publications Regards from Tom

[libreoffice-users] Paragraph Styles Not Updating

Hi all, I am having to update a couple documents (contact directories) I created under OOo some years ago. I had to save the documents in MS Word format (*.doc), but used paragraph styles to maintain uniformity of style and ease of maintenance. I wanted to change the color for a particular

Re: [libreoffice-users] LO auto save

On Wed, Oct 26, 2011 at 17:41, Murray White phy...@rogers.com wrote: Thanks to both of you. I'll save this in a folder as I have a good memory -- just short! I'm working on a very large document currently at 215 pages and have been using Wordpad and I do a BU of that each day when I add any

Re: [libreoffice-users] Can Libre Office be installed on an external drive. ?

On Tue, Sep 6, 2011 at 20:13, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) It might be worth contacting the IT Staff that are going to install the systems and make the point that your work requires using specialist software or something or that you prefer using Firefox because it's safer

Re: [libreoffice-users] Can Libre Office be installed on an external drive. ?

. It might be good to test the portable apps thing in advance if you can. Good luck and regards from Tom :) From: Don Parris parri...@gmail.com To: users@global.libreoffice.org Sent: Wed, 7 September, 2011 22:24:55 Subject: Re: [libreoffice-users] Can

Re: [libreoffice-users] Can Libre Office be installed on an external drive. ?

could really help me when i'm out and about. Thanks for testing this. http://portableapps.com/apps/office/libreoffice_portable Regards from Tom :) From: Don Parris parri...@gmail.com To: users@global.libreoffice.org Sent: Wed, 7 September, 2011 23:58:27

Re: [libreoffice-users] Kexi

I have been looking at Kexi as well. As I understand it, Kexi currently offers read-only access to DBs not actually created from within Kexi. If you have already created a database, you will not have write access to that DB. That said, if you create the DB from within Kexi, you can use it more

Re: [libreoffice-users] Base / Postgresql support

On Thu, Aug 4, 2011 at 14:05, Walt ed...@full-circle.co.uk wrote: Hi Anyone know how to get native pgsql support on base - it seems missing from the connect to an exsitng database options. I've checked under both Linux and Windows. I just blogged about this. Hopefully, you'll find my info

[libreoffice-users] Calculating Time in Base Queries

Hi all, I am using LibreOffice 3.3.2 on both Windows Linux (depending on whether I'm at work or home). I have a Base DB that tracks shift work, and want a query (or view) that calculates the total hours worked. I am experimenting with two variations of the shift table. Version #1 has: