[libreoffice-users] Python
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: 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: Python
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-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] Use KAddressBook As LibreOffice Resource
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 be able to use the MySQL connector to link directly to the database... No, I've not done it, but... :) I'm not surprised at the lack of either documentation or chat about it, unfortunately. 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 + 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] Shortcut for Recent documents
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: 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] Writer mailmerge functionality changed?
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 evaluate table fields unless I qualify them. Being in a rush I fully qualified them (Database.Table.Field). I don't know if they would've worked without the database qualifier. Other qualifiers that merely test for the field being non empty (NOT(field)) still work. Has this been a conscious change or simply an unwanted side-effect? 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base, connect to map/grid ?
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 -- 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] Multi-source Mail Merge
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 represent one unique item. As an analogy, think of the spreadsheet as a basket that contains a variety of eggs (both calculated and hand-entered data). I have multiple baskets each with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet. Normally to do a mail merge you have one data source. The problem of course is that I don't have one data source, I have an unknown number - each spreadsheet is a data source. So I'm at a loss as to how to mail merge against multiple data sources in an automated fashion. Thank you in advance. -- 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
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 hasn't been any work on Base in that time anyway)(has there?). It doesn't work in design view either I now find. To be clear selecting all the data in the result and pressing ^C (or selecting Copy from the edit menu) then selecting a blank Calc spreadsheet and pressing ^V (or selecting Paste from the edit menu) doesn't produce any data whatsoever in the spreadsheet. I little experimentation has shown me that selecting either a complete column or a single cell in the result set, pressing ^C and then pressing ^V in the spreadsheet *both* give me a single cell output to the spreadsheet. Something does seem to be copying into the spreadsheet. Trying to past multiple cells like this clears the previous contents of the cell but there is nothing to see. Saving the sheet, which looks empty, produces a file of 10.2kb where saving an a truly empty sheet is 10.1kb. Is there some setting I've miss-set? Stope Press Pasting a small table (35 rows five cols) works, although, strangely, it brings in an extra row for column names. Not much use bringing in a table. That's what we need databases for in the first place, to manipulate tables to produce results. Having said all of that, is it ideal that the only way to get a data output from Base is C'n'P? 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: 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
Hmm You must not copy any opened table or query. You copy and paste the _icon_ of a query or table. That's not what the three answers above said, nor indeed what is intuitive (to me), and indeed cutting and pasting small amounts of data from the result set does work, which I would expect/hope for (without the small), but I'll give it a go... Wow! *That* works really well. I'd say that it requires a very odd intuitive leap, and I don't remember seeing it written in the docs anywhere, did I just miss it? You can also link record sets to spreadsheet ranges and pivot tables which gives quite a powerful report engine. Am I right this is only almost great? I don't see how to define a datasource, it just seems to be picking up data from the last icon I dragged to the sheet. [Tutorial] Using registered datasources in Calc https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511 That is very good, thank you. I must remember to look in the OpenOffice areas more often. You do not tell us which database you are using (no, Base is _not_ a database). With over thirty years of database coding and consulting I'm very well aware that Base isn't a database. In the previous thread I said, MariaDb (under Fedora). If it happens to be an embedded HSQLDB Yes, I saw this, but decided to ignore it. Given the trouble it causes, surely it's not a good idea to recommend embedded HSQLDB for any purpose, is it? Finally you can drag a record set from the data 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 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] And while I'm here, data extraction
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 when you force the output into a text file, and a merged writer document will not produce raw data like this (will it?) Again, have I missed the answer? 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] JDBC params - the J null date problem
I'm accessing a MariaDb (howzatt Tom? ;-) ) database through a JDBC connection on Linux (the native connector doesn't work, not sure why, yet). When accessing a datetime column with some rows set to '-00-00 00:00:00' Base complains and refuses due to this being an invalid (js) date. I note from a quick search that this is a well known problem. There are some solutions involving to the JDBC connector load string, which seems to not be accessible from Base. Is that a good idea? The only solution that I've found involves casting the field to a string. It works, but I'd prefer 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://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 params - the J null date problem
In article 54cf6b6e.6030...@aon.at, Heinrich Stöllinger wrote: Also - one obviously specify MORE than just ONE parameter in the connection string, such as dbname?autoReconnect=truezeroDateTimeBehavior=convertToNull Heinrich Alex Thurgood schrieb: The way is to add the parameter 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-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] Base knows SQL functions?
It seems that Base has a list of keywords and functions for SQL, is that right? On the one hand it might be a good thing, on the other, unless the list is kept up to date then it's a real pain. For example, ADD_DATE (or DATEADD) in MariaDb, doesn't seem to be on its list. That means 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...@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 knows SQL functions?
If you decide to use function(s) that are database specific, you tie the application you are creating to that database. It will no longer be functional if yout switch from i.e. MariaDB to MSSQL. That's a good point, but not the one I was making. If I choose to change database then I would of course have to change any product specific funtionality but If you are using Base, you can use function in Base, no mather what database you attach to it. Ok, having tested a bit further, it in fact seems to be my problem. A difference between the documentation I was looking at and the version of MaraDb on my machine. So, to explain it fully, the (very prety and worthwhile) design mode *does* appear to have a list of what it knows about... Perhaps it has to... Even with that switched off Base still checks and only accepts code it knows about, but pressing the SQL button puts it into passthrough mode and it *doesn't* check (hurrah!). I think I should've know all that before :-( If course if, like me, you use stuff your database server doesn't recognise it still won't work :-( The way to check is to put the query into the server directly through its own console, 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://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 knows SQL functions?
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 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 Help Anyone
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 use the standard HSQLdb included setup, it's really too prone to errors. 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 + 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] Properties Toolbar?
What is this thing and why can't I get rid of it? In Writer, 4.2.6.3 I now seem to have a properties toolbar. It insists on docking on the right hand side of my LO window and won't go away. I can undock it, but subseqiently closing it just makes it appear back in the LO main window. What 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: 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] Properties Toolbar?
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 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] Libreoffice on Linux does not see network shares
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: 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] a step in the right direction
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... -- 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] a step in the right direction
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... -- 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] Other LO email lists
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 address rejected: User unknown). I've sent unsubscribe messages according to what it says in the website from the accounts that the messages appear to be coming to, but no luck. Any help much appreciated. 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 + 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] Other LO email lists
Hi Charles, Did you actually subscribe with your current email address? Maybe it was a different alias of yours? Exactly. Which is why I was careful to mention from the accounts that the messages appear to be coming to, as detailed in the how to unsubscribe web page. I imagine you're 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-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] [MariaDB Announce] MariaDB Galera Cluster 10.0.12 GA and MariaDB 10.1.0 Alpha now available
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://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] Tell me it's not true
Hi Dan, Thanks, yes I know William was mistaken. My post was slightly tongue-in-cheek ( long enough ago now that actually I'd forgotten about it ;) ). My guess is that the dBase connection only supports one file because it's a file connection not a process connection, there's no database 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://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] Company Move: Need to Know
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 that you're merging? How are you accessing it? It sounds like you know what you're doing with data in general, so it might just be an LO-related issue. Incorrectly accessing that data often results in not merging. When you say none of the merge fields merged, what, precisely, happened? Sorry, I don't have time for more. 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 + 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] Good mailmerge, well done mailmerge... Errr, not quite
I think that is what Anne-ology is alluding to. Ah, ok, I didn't know that, thanks. However, the situation is that if I save the output of the mailmerge directly as a pdf (good LO, I didn't know that was a possibility) I get this behaviour, whereas if I save the exact same mailmerge output as an odt document and then save *that* as a pdf, all the pages are, correctly, landscape. It is a single page document that I mailmerge from, tho' I s'pose that could still have a first page options set. However, the fact that there is a difference between the two different save strategies, 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-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] Good mailmerge, well done mailmerge... Errr, not quite
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 + 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] Good mailmerge, well done mailmerge... Errr, not quite
Err, what settings do you mean? I tried this twice. Both times only the first sheet was landscape, all the others were portrait, which is the layout of the Writer merge document. What settings should I check? It's a mailmerge of a single address sheet with a query that holds (at the moment) 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://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] Good mailmerge, well done mailmerge... Errr, not quite
I was amazed to find that the save document option at the end of the mailmerge will save directly to a pdf file if I put that in as the file extension. Unfortunately, the first page is portrait when all the rest are (correctly) landscape :-( Has anyone else had this problem or have I done 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MariaDB 5.5.33 Now Available
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 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] eastern font in new version
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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] HSLQLDB syntax
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-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] Calc bug?
I'm not a frequent Calc user, so this might be just plain wrong, however... With a very wide table I can (as is standard in most GUIs) go a page right (or probably left) at a time by clicking in the scrollbar between the end stop and the current position indicator. However, if the column wider than the Calc window, this doesn't work. The cell is placed with its left side at the left of the window and and further page clicking to continue scolling doesn't move the page. The page can be moved by using the arrow at the end of the scrollbar, or by dragging the position indicator. 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/ 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 data-loss and other problems
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-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 stuck in Read Only mode??
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-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 stuck in Read Only mode??
In article 5152bfd4.7050...@telkomsa.net, Ian Whitfield wrote: Thanks Mark I think you are right!! I DON'T see a Primary Key!! (I'm sure I DID set it!!) BUT - If I try to set it in Base it does not accept the setting. If I try in MyAdmin to set my first column (RecordID) as Primary I get the error #1062 - Duplicate entry '' for key 'PRIMARY' I can not see any Primary Key in the list of fields So I ran .. SELECT EXISTS( SELECT 1 FROM information_schema.columns WHERE table_schema = 'FedSaintsNew' and table_name='TABLE 2' and column_key = 'PRI' ) As HasPrimaryKey I get HasPrimaryKey 0 What is stopping me setting the key or how do I get round this??!! Hi Ian, Are you saying that phpMyAdmin doesn't show a primary key? But won't let you enter one? That sounds very odd. Personally I would do most of the setup in phpMyAdmin rather than Base. 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
Dan, As I said in my response above, the distinction that LO is making is database engine call or manipulate file directly. If it manipulates files directly it does it with simple, slightly extended, text manipulation. LO has no database functionality itself, for such functions it can only make calls to a database engine (ie another program) when it has anything other than simple single file manipulation to do. DBase (for example) has no engine that LO can call to. Flat file databases are those where there is no ability to relate different tables. In that respect, outside its correct environment, I suppose you could say that dBase files are flat, but that is because of the lack of correct environment rather than any shortcoming in the files themselves. That, I think, points to flat file being a misleading term, not only because it's not just to do with the file, 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 -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
Thank God Linux came arround when it did... I am still waiting for a database program that will allow me to create applications I feel your pain. I was a professional VFP developer and have now moved to Linux and have the same problem. However, I am wondering if the one solid lump approach is the only way to go or if a collection of pieces will do the job as well (or better?) The pieces in Base are actually (potentially) pretty good). I'm hoping to get some time to develop this idea in the not-too-distant future. C, or its derivatives, would be a very poor database 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 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] Fill Writer document with MySQL Query.
Very easy to do. Use Base to map to the data you want. If all the fields aren't one table then create a query that does generate the data you want and save the query. Use the mailmerge facility to create a document and connect to the data you want. Create fields for the data fields. Run 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 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] definition of flat/relational database
I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP, whyzatt then? ;) ), however it'll be a Windoze only thing I expect. So, to answer the original question, LO is calling dBase files flat because it can't access a database engine for them and it won't do any engine work itself. A flat database? Errr, can't think of one, although I know there have been such things. You only had to ask ;) 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
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 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 Report Builder
And to allay your fears a little Hank, the job of moving your *data* to a new back end can be as easy as dragging and dropping tables. Setting up the new back end might introduce you to some new ideas so it might take a little to get your head around it, but once that's done it might 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...@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 Report Builder
If you really need to rely on your data keeping its coherency and consistency, my advice would be not to use the default hsqldb/ODB pair that is provided as the default. It is a shame really, as hsqldb in itself, certainly in its 2.0 version, is a capable db engine. It is just the integration 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 -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base Compact and Shutdown
Even if it existed, I would be quite surprised if such a thing is necessary for MySQL. Looking through the (5.1) manual, the only references to compact (as a verb) as to do with dumping data and a storage structure option. There is nothing (that I can see) listed for it as a shutdown option. 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base Form behavior.
Hank Alper wrote: I have observed some strange behavior, however,when using the triangular widgets in the navigation bar at the bottom of the forms. For example, when I open a form which maintains tables currently containing 201 records, the navigation bar indicates 1 of 41 records.As I click 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Cannot add primary key after saving without primary key.
Whilst it is recommended that every table should have a primary key field, as far as I know HSQLDB is the only engine to enforce this by refusing to allow changes to tables not having one. I certainly think that the code ought to be fixed so that database engines that require the field 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 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 - need to re-point a form
Is this after you've switched to using a different copy? It sounds like you have had read/write access in the past, is that right? If so, what changed? How do you know it's read only? If your form won't let you change the data it's a local issue, if you can save but it makes no difference 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] documentation for LO base
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 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] Import XML files?
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-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] Update SQL does nothing using Run SQL directly button
And, as a stylistic suggestion, don't use a separate field for transaction year, calculate it from transaction date. The reason is that you've created a new classs of issue for yourself by doing this, keeping two fields in step. In general it's best to store basic data and calculate 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://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] Import XML files?
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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Import XML files?
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://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] documentation for LO base
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, spreadsheets or drawing packages. 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Import XML files?
I've got an XML file (I've generated myself, programmatically). I thought it ought to be easy to import it in LO (3.4.6), somehow. I thougth Calc would be a good bet, but it just gives me General I/O error. Base does the same. The website (help.libreoffice.org/Common/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/ 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] Mailmerge from query broken in 3.4.6?
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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Mailmerge from query broken in 3.4.6?
Using a mailmerge document that worked fine in the previous version (no, I don't know the number, but very recent, I'm getting updates through the Fedora repos) hardly works at all now. The document is an address sheet with three of images. It uses hidden paragraphs for almost every line, and the images. The data navigator shows the correct data, the result of a query. Mailmerge gets the first line of the address correct, and nothing else. Some fields appear as field names (eg Address1)(yes, I do have View Fieldnames turned off), some fields appear as data from a row (always 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-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: Mailmerge from query broken in 3.4.6?
Ok, a little more information, because I've now fixed the problem and have a bit more idea of the scope of the mess, which is huge, I'd say. This mailmerge is linked to a query in a MySQL database. My query couldn't use the query wizard (Andreas won't be surprised). In coding the query I wrote the field names in camelcase (eg Address1, PersonName), the actual database fields are all in lowercase. Changing this made the mailmerge show data. However, the query worked prior to that, and in fact the hidden paragraph conditions worked correctly, even though they were also in camelcase. Interestingly, calculated fields given camelcase names with AS work! Uncalculated fields given names (eg `Address1` AS `Address1`) don't. Interestingly, again, it seems that some conditional statements don't work the way they used to, either. Am I talking complete rubbish here, or are others 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/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] Mailmerge from query broken in 3.4.6?
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. I'm certainly not aware that SQL makes any distinction. The query with single quotes, is producing the correct results (as verified against a separate system). I only do this run once every couple of months so I don't rememebr the conversations, but I don't think mailmerge can use a view, can it? Yeah, I've seen what they've done to camelcase. I've not seen any camels with lower case heads... ;-) I can't imagine that the Fedora repo has caused a problem either. 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
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. Really it shouldn't accept case-incorrect fieldnames, so at least it's halfway to being good, it's just that that progression broke my code :-( Thanks for the other references too. 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
Thanks for that Girvin. In fact my query does have the quotes around field names. I've included it at the bottom here. I haven't noticed any difference between ` (backtick) or either usual type of quotation mark either. I appear to be using the MySQL JDBC driver, com.mysql.jdbc.Driver, 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`.`Surname` ) ) ) AS `PersonName`, `people`.`PersonId`, `issues`.`iId` AS `iiID`, `issues`.`Issue`, `people`.`LastIssue`, `subscription`.`iId` AS `subiId`, `subscription`.`Type`, `subscription`.`AdType`, `subscription`.`Delivery`, `subscription`.`Issues`, `subscription`.`StartingAt`, `address`.`Company` AS `Co`, `Address1` AS `Address1`, `Address2`, `Address3`, `City`, LTRIM( `Area` ) AS `Area`, `Country`, `PostalCode`, `sent`.`iId` AS `SendId`, `sent`.`NumberSent`, LEFT( `textvalues`.`Text`, 1 ) AS `Text`, LastIssue=Issue AND Type=2 AS RenewalDue FROM `people` JOIN `subscription` ON `people`.`iId` = `subscription`.`iPeopleId` JOIN `sent` ON `sent`.`iSubId` = `subscription`.`iId` JOIN `issues` ON `sent`.`iIssueId` = `issues`.`iId` JOIN `address` ON `people`.`iId` = `address`.`iParentId` JOIN `textvalues` ON `textvalues`.`Id` = `subscription`.`Type` WHERE `issues`.`Issue` = '74' AND `sent`.`sent` = 0 AND `Delivery` = 1 AND `textvalues`.`Field` = 'CBOSUBTYPE' ORDER BY `FirstName`, `Surname` -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Cannot access my database file!
I suspect Dan is saying that memory per object needs to be bigger than the biggest picture you've got in there. For future reference, it's not a good idea to store big binary data, or, imnvho, any binary data, in database tables, certainly not in the hsqldb tables that LO uses as internal. 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/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] Other SQL question as it affects Base
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. Your strategy is based on the specific values of those numbers. That's not what table primary keys are intended for in the relational database model. As I said in my previous post, it sort of works, and happens to work reliably enough for you in your situation. That's fine. You say you're a mathematician. Does coincidental relationship bear mathematical scrutiny as a general strategy in that context? 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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 that is guaranteed to hand out successive numbers, and then you can use that to do the arithmetic you've done already. You'd want another table that stores the current value of your counter, and your entry data process would get the next number for your next entry and update the table. You could do it by finding the maximum number already allocated in your table and add one (or whatever). If you're prepared to bet the ranch on having one reading every month without fail, you could find the lowest date and then generate an integer singly increasing index on month's since first date. That'd be two more SQL selections. The problem with what you've done is that there's no guarantee that it'll continue to work. It probably will, by the looks of it, but it's only a fortunate side effect of something that is not guaranteed. In a business environment you'd get fired for something like that, and quite rightly! In an amateur environment, you're getting away with it, which might be good enough for you. The next alternative is pulling the data in date order (yes, I know it's almost certainly in date order already, but if you don't make sure then you can never enter historical data [you're sure to miss entry for some reason some day]), and then run through the table doing the sum between last month's data and this month's. Of course, if you do ever enter data out of order the first strategy here won't work, or you'd have to manually reallocate your sequence numbers. 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] BASE SQL problem
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: 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] BASE SQL problem
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) limited sense. It (my stored query) doesn't work when I call it from a Writer document. Worse than that it doesn't work in a silent, partial, sense! :-( Not very happy about that. I wish they would drop all the pre-processing and the extremely stupid query designer. I think it's REALLY important to have tools like this, so less able people can use more powerful application. However, the tools mustn't stop the more able from using the application. 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] SQL statement in Base query
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, I think, that Base does some pre-processing to check the SQL, which causes a problem, particularly in this context (non-standard SQL). Although there are some helpful points to it are there enough? 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Uninstall Anaphraseus (LibO 3.6 on Mac)
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] My story
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 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] IPad?
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] IPad?
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] IPad?
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] IPad?
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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] launching app from within base
The topic says it: is there a way to launch and application from with LO base? Could you be a bit more specific please. What type of application, why, to do with what? Presumably something to do with Base, but without a bit more context it's very hard to know where you're wanting to go 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problems importing an OO database into LO
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://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] beware of the m$ subsidiary
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 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] Problems importing an OO database into LO
Hi Perrti, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no real future forLibO's Base module, perhaps not for the whole LibO suite. I think you make some interesting points, but are too despondent. Leaving the whole suite aside, I think there is a very real future for database use here. We have the ability to make it the way we want it. The converation *does* point to the idea that the future of this probably needs to be rather 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://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] Problems importing an OO database into LO
Hi Ian, The easy version is :- 1) Open your database with the HSQLDB embedded data. 2) In a separate window, create a new database with any other kind of data engine. 3) Drag the tables from the embedded database to the new database, one by one. 4) Drag any other objects from the old database to the new one, too. I'm guessing that the important bit that you need there is missed out, the how to create and link up to A.N.Other database. Whilst there are several of those, multiplied by the possible access methods, and perhaps even the possible operating systems, we ought 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...@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] beware of the m$ subsidiary
'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/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] beware of the m$ subsidiary
Replying without quoting *anything* to maintain context is just as dumb as if not dumber than blindly quoting everything... Sorry, having a proper email client that links replies correctly, I forget that not everybody has that. I was replying to Paul D. Mirowsky's point (offer to develop?) 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://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] Problems importing an OO database into LO
I think Andreas' approach for end users is a very good idea. I think, furthermore, that it starts to redefine how databases can be used. that's a good thing and going dowm that track will, I'm sure, lead to further developments. As such, yes, I think it would be a great idea to push 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...@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] Problems importing an OO database into LO
I'm almost thinking of installing something like MySQL and writing my own front-end in Java. I'm sorry if I'm being slow, or not following the conversation properly (lots going on here at the moment), but, if you're thinking like that, what's wrong with Base? The things you'd need to do, Base does. The things that approach won't get you, something to present your data, you'd use Writer/Calc for. The two problems I've registered (which have a multitude of subsidiaries, I know, I'm not trying to say Base is great yet, it's clearly not), is that the whole thing crashes, the answer is use a back end not the embedded system, and the wizards are cr*p, building your own front end to (eg) MySQL won't help you there. Andreas' approach of writing queries and setting up Writer documents to use them does what you want, doesn't it? Writing documentation for this approach would 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://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] Problems importing an OO database into LO
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/ 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] Problems importing an OO database into LO
- 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problems importing an OO database into LO
Sorry, I should have been more precise : Lotus Approach allowed a user to create a form based on a query of a collection of DBF tables and then be able to update them via the form Yes, because Approach had a database engine. Base doesn't. If you try to do this through Base with MySQL/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 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] How to format data entry in base table to UPPERCASE only
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to format data entry in base table to UPPERCASE only
In this case a form related macro solution might be simple, I guess. Indeed, but what the op was hoping for (I think) was input masks, as exist in dBase products, where at design time the designer specifies the format of what can be input. So you could define a mask for a field like 'XXX XXX' which would force entry of two groups of three alphanumerics, only allowing numbers and capital letters. Handy since what appears on screen when entering data is exactly the way it is entered into the data, whereas (I think) the suggested solution of making the database field case sensitive 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://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] How to format data entry in base table to UPPERCASE only
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/ 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} Compare contents of similar records on two sheets
Both of these will be easy to do as a query in Base, although the first is a little tedious, provided that you can get both tables into the same database. Something along the lines of SELECT * FROM MasterTable JOIN MonthlyUpdateTable ON Master.IdField = Month.IdField WHERE Master.Column1 Monthly.Column1 OR Master.Column2 Monthly.Column2 OR ... (The rest of the fields) If you can't get both into the same database, don't use the embedded database (though you wouldn't anyway, would you? ;-) ), And bring them into separate databases and then perform that SQL using the data engine itself, ie not through Base, even if you use Base to get the data there in the first place. For any database worth its salt 2000 records is tiny. For records in one but not in the other SELECT * FROM One version WHERE IdField NOT IN (SELECT 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 + 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] Fw: 'Open' Standards dependant on a single company?
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...@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] XML as mailmerge data source?
and yes, Google claims to have found more than 65,000 results ;) Yes, as I said, I've been looking, and I found lots of results, but But bottom-line will be, convert the XML to CSV or Excel or ;) You seem to agree with me that, no, there isn't a way. Since XML is a wau of structuring 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/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] Fw: 'Open' Standards dependant on a single company?
It mentions not getting locked in to one vendor several times. It seems to me that this is the point that needs to be used, repeatedly, to avoid, errr, getting locked in to one vendor. I've responded to the first two chapters, at which point I started to gibber and couldn't carry on any 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] XML as mailmerge data source?
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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Conditions
Hi Dan, Thanks for the very detailed thoughts. There's some really interesting stuff there. I'll have a bit of a play when I've got some time. At the moment it works, which is enough until I come to vary it a little :-) I don't use HSQLDB, don't like it, sorry. I use MySQL. I created 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? 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] Conditions
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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Urgent Base problem
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Urgent Base problem (stability in long term use)
The problem with using dbf files is that you no longer have a relational database. Because Base is then dealing with files not a database engine it will only use one file at a time and will not relate them. 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] More mailmerge woes
Herr Säger, you may have hit the nail on the head, thank you. Yes, even though my query was correctly displayed as the driving data for the document (of course, since I'm using mailmerge, this is a Writer document that has the problem), when I went through the Change datasource dialogue/wizard, it showed a different database as the source, weird! And that is a *fabulous* feature in Writer, just dragging the column onto the page, fabulous. However, there was still one problem remaining which I have fixed by changing the field name Company to Co. Whether I allowed MySQL to produce the fieldname or explicitly speciifed it with an alias, Base would insert the field as company (lowercase first letter), and it would therefore display the fieldname not the field contents, because the query wasn't producing a field with that name! Company is a reserved word somehow? Surely not! Many thanx 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted