[libreoffice-users] Python

2016-03-19 Thread Mark Stanton
Does the Python macro interface work? Does it work well if it does work? Mark -- 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:

Re: [libreoffice-users] Re: Python

2016-03-19 Thread Mark Stanton
On Friday 18 March 2016 10:39:07 Jim Byrnes wrote: > On 03/18/2016 09:44 AM, Mark Stanton wrote: > > Does the Python macro interface work? > > Yes Gr8! Many thanks -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-hel

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

2015-12-13 Thread Mark Stanton
Hi Don, > 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. That sucks. It *should* be quite easy since Kontact uses Akonadi which uses MySQL, so you should

[libreoffice-users] Shortcut for Recent documents

2015-08-11 Thread Mark Stanton
Does anyone here know why, in version 4.4(.5.2) is the shortcut for Recent Documents on the File menu U? It always (?) Used to be R. There doesn't appear to be any clash which would stop it being R now, not in Writer at least. Anyone? Mark -- To unsubscribe e-mail to:

[libreoffice-users] Writer mailmerge functionality changed?

2015-07-31 Thread Mark Stanton
I've just upgraded (I assume, it was actually an OS upgdate) to 4.4.4.3 running under Fedora 22 and a mailmerge document that's been working quite happily for a few years fails to work now. The problem is conditional statements in hidden paragraphs where the condition is EQ or == fail to

Re: [libreoffice-users] Base, connect to map/grid ?

2015-05-14 Thread Mark Stanton
MySQL comes with mapping capabilities, I believe. There is, or used to be, a large section in its manual about how that works. I don't know how it works because I've never taken the time to read those sections, but it might give you an idea on how to implement something. Regards Mark --

Re: [libreoffice-users] Multi-source Mail Merge

2015-05-10 Thread Mark Stanton
This sounds like an interesting problem. So, just doing it manually, how do *you* know how many spreadsheets are required for any particular result? Mark Stanton One small step for mankind... In article 554e54ba.9070...@bak.rr.com, A wrote: I have multiple spreadsheet files that each

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

2015-02-03 Thread Mark Stanton
Thanks all. 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

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

2015-02-03 Thread Mark Stanton
source window into a Writer document and choose Text export. In that dialog you can concatenate the wanted fields in one line with some delimiter between the fields. Then save as plain text. Wild! I don't see a text export though, other than saving the Writer file as a text file. Mark Stanton

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

2015-02-02 Thread Mark Stanton
There seems to be no way to output *data* from Base, is that right? For my purposes at the moment, what would be perfectly acceptable would be a csv file but I can't find a way to do that, is there something? Yes, I know I can produce a report, but you don't want to see what that looks like

[libreoffice-users] JDBC params - the J null date problem

2015-02-02 Thread Mark Stanton
not to have to. Is there something I've missed? Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] JDBC params - the J null date problem

2015-02-02 Thread Mark Stanton
in the field where you specify which database to connect to : nameofmydb?zeroDateTimeBehavior=convertToNull Thanks both! Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Base knows SQL functions?

2014-11-28 Thread Mark Stanton
that, even though it's perfectly acceptable SQL for the backend, and even though Base does no querying itself, it won't pass on a query with this function in it. There are (many) other examples. Any thoughts? Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Base knows SQL functions?

2014-11-28 Thread Mark Stanton
, or something like phpMyAdmin if you're also running a webserver. Regards Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] Base knows SQL functions?

2014-11-28 Thread Mark Stanton
Hi Tom, Time for a bug-report? I thought I'd just test the water here first. I've not had time to work with Base for a (very) long time now, but this might bring me back (and other situations are easing) if I'm right. Mark Stanton One small step for mankind... -- To unsubscribe e-mail

Re: [libreoffice-users] Base Help Anyone

2014-11-19 Thread Mark Stanton
Tom, I'm not entirely sure, when you said So, it's only Base that loses data that you properly comunicated what you meant. What did you mean? I would absolutely agree with the comments made about not storing binaries in the database. It's not a good idea, whatever database you use. And don't

[libreoffice-users] Properties Toolbar?

2014-09-25 Thread Mark Stanton
is it? Where does it come from? Where can I turn it off? I don't want it. Mark Stanton (Clearly feeling a little grumpy) -- 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

Re: [libreoffice-users] Properties Toolbar?

2014-09-25 Thread Mark Stanton
Thanks both. Yes, I found it as sidebar. In hindsight not difficult to identify, but rather different from the way they're normally named, so it didn't strike me at first. What's the thinking behind that then? Mark -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Libreoffice on Linux does not see network shares

2014-09-03 Thread Mark Stanton
Same thing happens on Fedora (x86). I don't think I've ever been able to access files from a Samba share. Mark -- 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:

Re: [libreoffice-users] a step in the right direction

2014-07-24 Thread Mark Stanton
As I understand it this is now official government procedure, ie law. Isn't that the case? I also understand that not all government necessarily wants to abide by its own laws, but this directive seems to be binding. Or have I misunderstod the intention? Mark Stanton One small step for mankind

Re: [libreoffice-users] a step in the right direction

2014-07-23 Thread Mark Stanton
Hmm, a huge public response and A rigorous process was undertaken which included considering over 500 public comments and talking directly to users. I'd hoped huge was much bigger than that. Oh well, at least the message got across. Mark Stanton One small step for mankind

[libreoffice-users] Other LO email lists

2014-07-08 Thread Mark Stanton
Even following the unsubscribe instructions on the how to unsubscribe web page, I still get the message user unknown. I'm trying to get off the QA, Devs, Documentation Marketing lists, but two of them appear to be taking no notice, complaining that they don't know my address (Recipient

Re: [libreoffice-users] Other LO email lists

2014-07-08 Thread Mark Stanton
right in thinking that this may be linked to the cause, but trying to get the right account doesn't seem to be working. Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] [MariaDB Announce] MariaDB Galera Cluster 10.0.12 GA and MariaDB 10.1.0 Alpha now available

2014-07-04 Thread Mark Stanton
And, to give an example, Fedora has moved from distributing MySQL as default to MariaDb. Mark Stanton -- 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

Re: [libreoffice-users] Tell me it's not true

2014-05-22 Thread Mark Stanton
engine running for the connector to ask to do the complicated work. Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] Company Move: Need to Know

2014-04-03 Thread Mark Stanton
Hi Sqwuiddy, I think you'd be best hiring someone in for a few days to help you with this. There are several questions that need answers to help further. In general you should be ok on many of these things, I'm not certain about all of them. Nested IF statements do work. Where is the data

Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-02-04 Thread Mark Stanton
, surely, indicates a bug. Doncha think? Sounds like no-one else has come across this behaviour though. Regards Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-02-02 Thread Mark Stanton
Doh! I meant, of course, only the first sheet was *portrait* all the others were, correctly, *landscape*. Regards Mark -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-02-01 Thread Mark Stanton
) 223 rows. This is LO 4.1.4.2 under Fedora 19 x86_64 Mark Stanton One small step for mankind... -- 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

[libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-01-31 Thread Mark Stanton
something wrong? Regards Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] MariaDB 5.5.33 Now Available

2013-09-19 Thread Mark Stanton
Fedora has also switched. Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] eastern font in new version

2013-08-02 Thread Mark Stanton
All quiet on the eastern font, then... :-) Mark -- 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:

Re: [libreoffice-users] HSLQLDB syntax

2013-07-14 Thread Mark Stanton
Google When you spell it right, with just those two words you'll get, if it's the same as for me, 116k hits. Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Calc bug?

2013-07-11 Thread Mark Stanton
. Checking actions to write this message pretty much confirms it for me. Or have I made a mistake? Regards Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Base data-loss and other problems

2013-05-10 Thread Mark Stanton
How are we to see this thread in the marketing list Tom? Just joining the list won't give it, will it? Regards Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Base stuck in Read Only mode??

2013-03-27 Thread Mark Stanton
The usual reason for Base being in read only mode is not having defined a primary key for your tables. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Base stuck in Read Only mode??

2013-03-27 Thread Mark Stanton
. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] definition of flat/relational database

2013-03-06 Thread Mark Stanton
, but also because, at least in the beginning, many databases didn't store their data in operating-system-recognisable files. So, my suggestion is to remove the term flat file and instead refer to calls to a relational database system engine or direct file manipulation. Regards Mark Stanton

Re: [libreoffice-users] definition of flat/relational database

2013-03-04 Thread Mark Stanton
application environment imnvho. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Fill Writer document with MySQL Query.

2013-03-04 Thread Mark Stanton
the mailmerge and step something-or-other (four?) gives you opportunity to save your results, save the mailmerged result as separate Writer documents. Simples! Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Mark Stanton
;) Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Development of Extensions for LibreOffice

2013-02-04 Thread Mark Stanton
Qt isn't a programming language Tom, it's a UI framework (written in C++). Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Base Report Builder

2013-01-27 Thread Mark Stanton
not be hugely difficult. It's possible, of course, that there will be some little niggling problems that need to be resolved manually, but it's possible that the move can go relatively smoothly and easily. Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Base Report Builder

2013-01-21 Thread Mark Stanton
with AOO/LO that is one of the root causes of many of the problems that users experience. Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. Regards Mark Stanton

Re: [libreoffice-users] Base Compact and Shutdown

2012-12-31 Thread Mark Stanton
. It's the difference between an embedded database file and a database engine. MySQL is a database engine. You only need to send it requests and get answers back from it. Otherwise it does all its own housekeeping and management. You don't tell it to compact its data. Regards Mark Stanton

Re: [libreoffice-users] Base Form behavior.

2012-12-06 Thread Mark Stanton
my way toward the end It should (?) be easy to find the number of rows without having a big time consuming operation to do it, database engine APIs often provide a function for this. Yes, please put in a change request. Regards Mark Stanton One small step for mankind... -- For unsubscribe

Re: [libreoffice-users] Cannot add primary key after saving without primary key.

2012-10-23 Thread Mark Stanton
shouldn't allow table creation without it. Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Base - need to re-point a form

2012-10-18 Thread Mark Stanton
presumably thems who are administering the MySQL have set something. Often the reason for having read only access through Base is that the table in question doesn't have a primary key defined, but if you've had write access before and nothing else has changed that would be unlikely. Regards Mark

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Mark Stanton
As well as existing guides by Andrew Pitonyak and others. Mark -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Have you tried with a recent release of LibO? 3.4.6 is pretty old It's the current release from the Fedora repo. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button

2012-10-04 Thread Mark Stanton
subsidiary data from it, don't store subsidiary data. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Thanks for that Steve. It looks like this is saying that OO/LO needs a specific template for a specific input, is that the case? I hope not, XML is supposed to be a self defining file format surely? A general importer ought to be easy, no? Regards Mark Stanton One small step for mankind

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Ok, I'll put it on the list. Visual FoxPro (for example) has a built in function, XMLTOCURSOR, which takes a string or filename and produces a table. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Mark Stanton
Question: How many people do you know use Base, or have tried to use Base? Whilst there is some quite valid criticism of Base, I don't think answering this question says as much about Base as it does about the general usage of databases. They are less familiar than word processors,

[libreoffice-users] Import XML files?

2012-10-03 Thread Mark Stanton
/About_Import_and_Export_Filters) suggests it ought to be doable but gives no details whatsoever. Anyone got any pointers I could use? Regars Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-29 Thread Mark Stanton
Thanks Don, I'll have a scout about. Regards Mark -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
the same one) that isn't even in the result set... This is very peculiar. Is this is a known issue? Surely not. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Re: Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
finding similar things? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
Hi Dan, The only language I'm aware of that has a difference between single and double quotes is PHP, and that's only between what it does with strings rather than whether it recognises them as strings or not. I expect there will be some, my preference is single to reduce screen clutter.

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
If we're not a database, and we're not a mailmerge engine, we're running out of functionality... :-s I've managed to get it doing this non-trivial task without error, so I'm fairly pleased. I haven't got the pinpoint accuracy requirement, so I don't know if it's playing me about there.

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
, which *may* be new since I last ran this query, so it might be Java causing the problem. It'll get to the top of my todo list eventually ;-) Mark Stanton One small step for mankind... SELECT LTRIM( CONCAT( `people`.`Title`, ' ', LTRIM( `people`.`Firstname` ), ' ', LTRIM( `people

Re: [libreoffice-users] Cannot access my database file!

2012-08-25 Thread Mark Stanton
. Store names of files not the files themselves. You can get trouser pockets big enough for beach balls, but it's not a great idea. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-31 Thread Mark Stanton
I'm listening very closely. Your strategy is based on the assumption that consecutive readings have consecutive primary keys. Not even just being in the right order, they have to be consecutive integers for your strategy to work. This elevates the primary key from internal workings to data.

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-30 Thread Mark Stanton
As far as I remember it's explicitly stated in the SQL definitions Id fields should not contain data entered by users You can't rely on them not least because often they're automatically generated by the system. They bear no necessary relationship to the data. Mark -- For unsubscribe

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-30 Thread Mark Stanton
Ok, this is, then, quite an interesting idea. The problem is that you've got nothing reliable in your data to relate one date to the next (by the looks of it). You're only taking readings at roughly monthly intervals. A good, purely SQL, solution to this would be to code a stored procedure

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-29 Thread Mark Stanton
Keys are intended for the internal workings of the database, they are not meant to be used like this. What you want is the WHERE clause, or occasionally the HAVING clause, matching or excluding rows based on their data. Keys are NOT data and should not be used as such. Regards Mark Stanton

[libreoffice-users] BASE SQL problem

2012-07-29 Thread Mark Stanton
BASE's pre-processing, of MySQL at least, prevents the perfectly legal SQL field specifier field1 = field2 AS ConditionName Does it really need to pre-process, or is this more a shortcoming of its pre-processing? Regards Mark -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] BASE SQL problem

2012-07-29 Thread Mark Stanton
Hi! It works when you turn off the parser (direct SQL mode) but then you don't have an editable record set anymore. Ah yes, silly me. Because it complained that it had to use SQL view I assumed it was in SQL mode, it wasn't. Yes, selecting SQL mode got it to work, but only in a (too)

Re: [libreoffice-users] SQL statement in Base query

2012-07-24 Thread Mark Stanton
In article 500ea6e8.4030...@gmail.com, Jay Lozier wrote: Actually most users of different backend db will be familiar with the SQL version of that backend. What users need are two things: a connector between Base and the backend and instructions on connecting to that backend. The problem is,

Re: [libreoffice-users] Uninstall Anaphraseus (LibO 3.6 on Mac)

2012-07-23 Thread Mark Stanton
Anaphraseus not working? It *seems* to be working here, but that might be because I'm not sure what to expect from it. I, too, get the complaint on closing a document (which I've reported to the author), but it doesn't seem to cause a problem, does it? Regards Mark Stanton One small step

Re: [libreoffice-users] My story

2012-05-09 Thread Mark Stanton
I have to put my hand up to the breakdown here too. I was (am) hoping to build this connector but pressure of other work has got in the way for the moment. I'll be back... Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] IPad?

2012-05-06 Thread Mark Stanton
In article 1336129306.4334.yahoomailclas...@web171003.mail.ukl.yahoo.com, Tom Davies wrote: Lol, i meant virtual machine that could run inside iPad so that you could run other OSes on your iPad fairly easily. Another nice idea ( s'pose), but not the one I had in mind ;-) Mark Stanton One

Re: [libreoffice-users] IPad?

2012-05-04 Thread Mark Stanton
In article 1336081449.9896.yahoomailclas...@web171005.mail.ukl.yahoo.com, Tom Davies wrote: Hi :) Is there a virtual machine program for iPad? Does VirtualBox work? A virtual iPad? What a concept. I love VirtualBox! Mark Stanton One small step for mankind... -- For unsubscribe

Re: [libreoffice-users] IPad?

2012-05-04 Thread Mark Stanton
A virtual iPad? What a concept. I love VirtualBox! Not VirtualBox but downloads.phpnuke.org/en/download-item-view-y-y-m-x-l-l/VIRTUAL%2BIPAD.htm claims to be a try before you buy virtual iPad. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail

[libreoffice-users] IPad?

2012-05-02 Thread Mark Stanton
Is there a LO for the iPad? Mark -- For unsubscribe instructions e-mail to: users+h...@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:

Re: [libreoffice-users] launching app from within base

2012-04-23 Thread Mark Stanton
with this. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-21 Thread Mark Stanton
Copying the structure and data in one go, as offered by the import wizard, never creates any auto-ID fields. Would this be a sensible improvement to make? Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] beware of the m$ subsidiary

2012-04-20 Thread Mark Stanton
Wish I could. Nary the knowledge or the time. Frustration abounds. I was afraid you were going to say that :-( Mark Stanton One small step for mankind... PS Nice talking to someone with a proper reader ;) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-20 Thread Mark Stanton
different from (at least some of) the past. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-20 Thread Mark Stanton
to be able to produce the details for each type. If I'm right about this, then I'll go on to turn out step-by-step's for those. Would that be the thing that what make it useful? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] beware of the m$ subsidiary

2012-04-19 Thread Mark Stanton
'S a good idea. Go for it. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] beware of the m$ subsidiary

2012-04-19 Thread Mark Stanton
?) about Intermediate free software Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-18 Thread Mark Stanton
that approach. I think that as an additional and separate approach, what is thought of as Base now *should* be made more accessible and useful so that the general populace *can* start to do things with data themselves. Mark Stanton -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-18 Thread Mark Stanton
be a good idea to broadcase these ideas. Mark Stanton One teeny-tiny step for mankind, apparently... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-16 Thread Mark Stanton
What was it you liked about Approach (I used that too)? I'm asking for feature ideas. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-16 Thread Mark Stanton
- multiple table query/update support Multi-tabe query is available, surely? Where it's not available is in file mode when there's no backing database engine. Or having I missed somthing? Multi-table update support is an SQL limitation, isn't it? Mark Stanton One small step for mankind

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-16 Thread Mark Stanton
/MariaDB/PostGres/HQLDB.. anything that accesses an external (or, only in the case of the internal HSQLDB database, an internal) database *engine* not files, it will work. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] How to format data entry in base table to UPPERCASE only

2012-04-15 Thread Mark Stanton
Sure, it does exist. It's called pattern field: Ah, there y'go. Isn't that much better than a macro? Anyway, I think that's what the op was looking for, though, as always, I could be wrong. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail

Re: [libreoffice-users] How to format data entry in base table to UPPERCASE only

2012-04-14 Thread Mark Stanton
achieves the same end result but doesn't look the same during entry (does it?) Having said all of that, it doesn't exist in Base (yet :-) ). Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] How to format data entry in base table to UPPERCASE only

2012-04-13 Thread Mark Stanton
Which is also to say that the input filters you're expecting don't exist in Base. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] [Announce] HyperSQL 2.2.8 Released

2012-04-12 Thread Mark Stanton
area of the new one! How wonderful is that?! Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] [Base} Compare contents of similar records on two sheets

2012-04-12 Thread Mark Stanton
IdField FROM Otherversion) And then do it the other way around. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] Fw: 'Open' Standards dependant on a single company?

2012-04-01 Thread Mark Stanton
I don't suppose you would be willing to copy your answer to this list or the marketing list or perhaps to Ian? I answered online, so I don't have a handy document, or even any document :-( Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] XML as mailmerge data source?

2012-03-31 Thread Mark Stanton
data, just like a database is, then this seems to be a glaring omission, so glaring I couldn't believe it. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Fw: 'Open' Standards dependant on a single company?

2012-03-31 Thread Mark Stanton
further :-( Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] XML as mailmerge data source?

2012-03-31 Thread Mark Stanton
That's a sufficiently good-English explanation. I've got a very simple XML file that I'd like to use, which is why I hadn't thought about the wider issue. Just need to be a database engine that uses XML files... And package it with Base... :-s Regards Mark Stanton One small step for mankind

[libreoffice-users] XML as mailmerge data source?

2012-03-30 Thread Mark Stanton
I've been hunting, but can't find a way to do this. Is there a way (to use an XML file as datasource for a mailmerge?) Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Conditions

2012-03-21 Thread Mark Stanton
the database and the tables using pnpMyAdmin. However, since I don't (yet) know how the internals of Base work, I don't know if that's important or not. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] Conditions

2012-03-20 Thread Mark Stanton
Thanks Dan Jean-Francois, Got to use double quotes? Whose idea was that? :-S Mutter mutter mutter, yup that works :-( All working now! We'll find out how good it is next week when it gets used in the production run! :-) Thanks again Mark Stanton One small step for mankind

Re: [libreoffice-users] Urgent Base problem

2012-03-18 Thread Mark Stanton
I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't include it. Mark Stanton One small step

  1   2   3   >