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] Problems importing an OO database into LO
On Fri, 2012-04-20 at 13:08 +0100, Mark Stanton wrote: > 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... Mark: This will work for any database engine other than a HSQLDB 2.x version. Once the newer hsqldb.jar has been added as a Class Path (Options > LibreOffice > Java) to LO, that version will not open any of the embedded Base databases. (You can not access hsqldb as an external database until you do this.) This has to be done a different way. I have tried to open all of my embedded databases with LO 3.4.5 after I had added the 2.2.8 hsqldb.jar as a Class Path. All gave me an error message. I had no problems opening them using LO 3.5.2. Since that time, I could open these embedded databases using LO 3.4.5 as another user (same computer same OS). Opening an embedded database in one LO version and connecting to hsqldb in another does not allow copying and pasting between these two. Drag and drop does not work either. I think that this is the problem faced by Base when hsqldb issued new versions: no backward compatibility. In this case, the database document file has to be unzipped and the files places in a new folder. The path URL for this data is <>/<>/. Files have to be renamed. (I'm not sure how many of these require this.) They include script, log, properties, and data. For the database named abc, these files are renamed to abc.script, abc.log, abc.properties, and abc.data respectively. There are more things that need to be done than this. --Dan -- 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] 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
> > 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
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
> 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] 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
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
On Fri, 2012-04-06 at 14:43 -0400, Dan Lewis wrote: > On Fri, 2012-04-06 at 09:54 -0700, ptoye wrote: > > I have an OO database, and am trying out LO, and am having at least one > > problem. There is a form which is based on a query whose results are > > displayed in a grid, and various fields are copied into subform fields to > > allow me to update them. In OO everything is fine. The attached screenshots > > show what I mean. > > http://nabble.documentfoundation.org/file/n3890826/LOBaseBug.zip > > LOBaseBug.zip > > > -- > > View this message in context: > > http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3890826.html > > Sent from the Users mailing list archive at Nabble.com. > > What LO version are you using? > > What OS (operating system) are you using? > > Does LO show the same table contents as OOo does? > > Using Design View for the query is question: What differences do you see > for OOo vs LO? Also what version of OO.o is the file coming from? > > --Dan > > -- 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] Problems importing an OO database into LO
On Fri, 2012-04-06 at 09:54 -0700, ptoye wrote: > I have an OO database, and am trying out LO, and am having at least one > problem. There is a form which is based on a query whose results are > displayed in a grid, and various fields are copied into subform fields to > allow me to update them. In OO everything is fine. The attached screenshots > show what I mean. > http://nabble.documentfoundation.org/file/n3890826/LOBaseBug.zip > LOBaseBug.zip > -- > View this message in context: > http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3890826.html > Sent from the Users mailing list archive at Nabble.com. What LO version are you using? What OS (operating system) are you using? Does LO show the same table contents as OOo does? Using Design View for the query is question: What differences do you see for OOo vs LO? --Dan -- 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 :) It looks like the relationship between some of the tables has gone wonky. Can you look at the relationships in the OOo and LO versions to see what is different? The Base Guide hasn't really got into it yet but there is some stuff in Chapter 2 that you might find useful as it explains the theory quite well. https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Now just to find screen-shots and things! The Faq misses out on relationships https://wiki.documentfoundation.org/Faq Regards from Tom :) --- On Fri, 6/4/12, ptoye wrote: From: ptoye Subject: [libreoffice-users] Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 6 April, 2012, 17:54 I have an OO database, and am trying out LO, and am having at least one problem. There is a form which is based on a query whose results are displayed in a grid, and various fields are copied into subform fields to allow me to update them. In OO everything is fine. The attached screenshots show what I mean. http://nabble.documentfoundation.org/file/n3890826/LOBaseBug.zip LOBaseBug.zip -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3890826.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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] Problems importing an OO database into LO
I have an OO database, and am trying out LO, and am having at least one problem. There is a form which is based on a query whose results are displayed in a grid, and various fields are copied into subform fields to allow me to update them. In OO everything is fine. The attached screenshots show what I mean. http://nabble.documentfoundation.org/file/n3890826/LOBaseBug.zip LOBaseBug.zip -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3890826.html Sent from the Users mailing list archive at Nabble.com. -- 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