Re: [libreoffice-users] Similar Problem?
Unfortunately, I don't know what causes the problem and, thus, I can't recreate it. I am trying something now. I brought it up, updated a record but did not save it (I have a saved copy someplace else). I intend to let it be up overnight and check in the morning for the files. I had already cleared out all of the empty ones. I noted the time I brought is up and made the change. I want to see if it reoccurs. if so, then when. I also intend to save it and close it in the morning. If the files are there, see if the creation stops. Hopefully, this will lead to why it is happening. On another tangent, I had lost data and had to recreate the db. During that process, I read a few things indicating that using HSQL could lead to losing data. The recommendation was to use an external db. I spent several weeks last year trying to get Mysql to work. I followed the conversion guidelines that I had found but was unable to get it to work. I created the Mysql database and was able to create and load the tables (I think) but I could never get Base to recognize and use it. All of my queries and reports are in Base. I may have to try again if I can find the time. This time I will record what I install and what I do. Vince Radice On 01/15/2014 11:46 AM, Alex Kempshall wrote: Having said all that. It would appear that I've never had auto backup switched on. Having switched it on I now see backups and autobackups for writer and calc documents. Nothing at all for base documents. Alex On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote: I used to have that problem. It seems to have stopped around about 16th July 2013. Not sure why! Either - I upgraded LibreOffice which stopped the feature or I did something else which I can't remember! I'm currently on 4.1.4.2. Alex On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote: Hi :) Errr, is it possible to switch the auto-save and auto-backups off for a while and see if that improves things? The thing i find difficult about doing that is remembering to save properly and frequently enough. With Base i think it's also important to close properly. There is some documentation and a handbook at https://wiki.documentfoundation.org/Documentation/Publications and the Faq at https://wiki.documentfoundation.org/Faq might be able to help too but the best place seems to be this mailing list or the Base forums at Apache OpenOffice. Regards from Tom :) On 15 January 2014 07:30, Tom Davies wrote: Hi :) Errr, are you using the internal back-end? You haven't connected to an external back-end have you? You should really be keeping your data in an external back-end instead of having the whole database as a single file. Being able to do that is one of the main things that makes Base so much more powerful than Access. The internal back-end got tacked on to make Base more familiar to people who have picked up bad habits by using Access. It seems to be a bit broken though. Annoyingly the Marketing Mailing List and all our flyers, posters and leaflets (at least all the ones that mention Base at all) keep pushing people into using the internal back-end despite the fact that users have even experienced data-loss by doing so. I'm tempted to ask you to take this problem to the marketing list to get them to solve it but the experts in Base are mostly on this list and will hopefully be able to help with this issue. It should be possible to export your existing tables into an external back-end and this mailing list (note, not the marketing list) might be able to help you with that. The next smart thing about Base is that forms and reports can be, and are best made in Writer or/and (i think) Calc. So normal users who are clueless about databases can read the data in a familiar setting and use familiar tools to format and edit things around the data-fields. The forms and reports inside Base seem to be for data-entry and people who have some clue about databases. However i have never quite got around to getting to grips with all this. So hopefully some of the experts might wade in and set me straight (again) Regards from Tom :) On 15 January 2014 05:57, Vince Radice wrote: I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 Build ID: 4.1.4.2-2.fc19 Here are some lines of a ls -la command -rw---. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_100
[libreoffice-users] Re: Base - Passthrough queries?
Le 16/01/2014 00:57, Ryan Ashley a écrit : > That is not what I need. When I push a button on a form, I need some SQL > statement(s) to be sent to the server. Is this possible? > Only via a LO Basic macro or a script (python, java, JS, REXX), the push-once and fire functionality you're considering isn't available in LO as a simple UI option. The UNO API property that deals with (by)passing the internal SQL parser is "EscapeProcessing" http://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sdb_1_1DataAccessDescriptor.html#aa71981b851337d3842caede42c842c31 Alex -- 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: Recalc cell("filename") [partially solved]
So, are you using Apache OpenOffice (AOO) or LibreOffice (LO)? I only ask because you posted to the LO group about a bug you reported in AOO Not that I have not done similar things given that I subscribe to both mailing lists. On 01/15/2014 12:56 AM, James E Lang wrote: Related bug report: AOO Bug 68188 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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: Connection to SQL database
Tom, The initial format and some of the data types would need to be converted so the syntax matched to the new . This is a well known problem when migrating from one SQL database to another where there are added, non-standard data types. Jay On 01/15/2014 05:12 PM, Tom Davies wrote: Hi :) Is it likely to be possible to connect Base directly to the original data? So that instead of getting an export or a dump of the data it can be read dynamically? I know it is not what the o.p. is asking for but i often wonder. Regards from Tom :) On 15 January 2014 22:03, Alex Thurgood wrote: Le 15/01/2014 22:08, Carl Paulsen a écrit : Hi Carl, ) ENGINE=MyISAM DEFAULT CHARSET=latin1; This is enough to tell us that the data came from a mysql database originally. MyISAM is the default engine for non-transactional MySQL databases : http://en.wikipedia.org/wiki/MyISAM In the sample table you give, the table/field definitions are particular to mysql, so if you try to run that sql with another db engine, e.g. in hsqldb via LO Tools > SQL, it will fail because it will not recognise the field types you're trying to create (e.g. enum, mediumint. So, your best bet would be to import that into a mysql server, assuming you have one to hand and you have some kind of console/terminal access (localhost / same machine): mysql < '/path/to/myfiletoimport.sql' optionally with -p if you require authentication for the user that is connecting to the mysql server : mysql -p < '/path/to/myfileimport.sql' There are many web sites on the internet that are full of information on how to set up and import data into a mysql server. Alex -- 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 -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - Passthrough queries?
Hey Ryan, You could write some Basic code and link it to the button. On 01/15/2014 06:57 PM, Ryan Ashley wrote: > That is not what I need. When I push a button on a form, I need some SQL > statement(s) to be sent to the server. Is this possible? > > On 1/15/2014 1:04 PM, Alex Thurgood wrote: >> Le 15/01/2014 16:14, Ryan Ashley a écrit : >> >> Hi Ryan, >> >>> In Access I can runn a passthrough query to execute SQL commands on a >>> true DB server. Is this possible in Base? I have a MariaDB server and >>> want to use Base to create forms for accessing it, but need to run SQL >>> commands to encrypt and decrypt certain data, so linking the tables >>> won't work. >> >> There is an option to execute SQL directly. >> >> >From within the main LO Base window, once an ODB file is opened, go to >> Tools > SQL >> >> If you are just carrying out a select query, you can do this via the >> "Construct a query in SQL mode" >> >> Note that only select queries are supported via the Query GUI. Use the >> Tools > SQL menu entry for DDL statements. Also note that even Tools > >> SQL does not replace a command line client console, so your mileage as >> to what you want to actually achieve might vary. >> >> >> Alex >> >> > > -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- 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: Connection to SQL database
Hi :) Is it likely to be possible to connect Base directly to the original data? So that instead of getting an export or a dump of the data it can be read dynamically? I know it is not what the o.p. is asking for but i often wonder. Regards from Tom :) On 15 January 2014 22:03, Alex Thurgood wrote: > Le 15/01/2014 22:08, Carl Paulsen a écrit : > > Hi Carl, > >> ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > This is enough to tell us that the data came from a mysql database > originally. MyISAM is the default engine for non-transactional MySQL > databases : > > http://en.wikipedia.org/wiki/MyISAM > > In the sample table you give, the table/field definitions are particular > to mysql, so if you try to run that sql with another db engine, e.g. in > hsqldb via LO Tools > SQL, it will fail because it will not recognise > the field types you're trying to create (e.g. enum, mediumint. > > So, your best bet would be to import that into a mysql server, assuming > you have one to hand and you have some kind of console/terminal access > (localhost / same machine): > > mysql < '/path/to/myfiletoimport.sql' > > optionally with -p if you require authentication for the user that is > connecting to the mysql server : > > mysql -p < '/path/to/myfileimport.sql' > > There are many web sites on the internet that are full of information on > how to set up and import data into a mysql server. > > > Alex > > > -- > 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 > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base - Passthrough queries?
That is not what I need. When I push a button on a form, I need some SQL statement(s) to be sent to the server. Is this possible? On 1/15/2014 1:04 PM, Alex Thurgood wrote: Le 15/01/2014 16:14, Ryan Ashley a écrit : Hi Ryan, In Access I can runn a passthrough query to execute SQL commands on a true DB server. Is this possible in Base? I have a MariaDB server and want to use Base to create forms for accessing it, but need to run SQL commands to encrypt and decrypt certain data, so linking the tables won't work. There is an option to execute SQL directly. >From within the main LO Base window, once an ODB file is opened, go to Tools > SQL If you are just carrying out a select query, you can do this via the "Construct a query in SQL mode" Note that only select queries are supported via the Query GUI. Use the Tools > SQL menu entry for DDL statements. Also note that even Tools > SQL does not replace a command line client console, so your mileage as to what you want to actually achieve might vary. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Connection to SQL database
Le 15/01/2014 22:08, Carl Paulsen a écrit : Hi Carl, > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; This is enough to tell us that the data came from a mysql database originally. MyISAM is the default engine for non-transactional MySQL databases : http://en.wikipedia.org/wiki/MyISAM In the sample table you give, the table/field definitions are particular to mysql, so if you try to run that sql with another db engine, e.g. in hsqldb via LO Tools > SQL, it will fail because it will not recognise the field types you're trying to create (e.g. enum, mediumint. So, your best bet would be to import that into a mysql server, assuming you have one to hand and you have some kind of console/terminal access (localhost / same machine): mysql < '/path/to/myfiletoimport.sql' optionally with -p if you require authentication for the user that is connecting to the mysql server : mysql -p < '/path/to/myfileimport.sql' There are many web sites on the internet that are full of information on how to set up and import data into a mysql server. Alex -- 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: Connection to SQL database
Carl, Depending on the program (this looks like the output from MySQL Workbench) and the tables are MySQL/MariaDB - the MyISAM is specific MySQL/MariaDB database engine. If you have MySQL or MariaDB and MySQL Workbench installed you can import/restore the data. The second dump has the data after value with each row in parentheses. You could open the file in any text editor. The remove the first part and the use find and replace to remove the parentheses and each '. The program that generated the data probably allows you to get all the rows and export/save them as a csv file. Jay On 01/15/2014 04:08 PM, Carl Paulsen wrote: Below is an excerpt from the file referring to the donations_money table. Obviously there are some ID fields, donation info fields (Amount, Date, etc.), a primary key field, etc. Immediately after the table, there's the "dump" of all the data in that table. I've only included one or two "records" from the dump, but there are many hundreds or even thousands of records. There are quite a few tables in the file, many of which we don't need (past logins under the old system, for example). Any wisdom on how to convert this data into CSV files? I thought I'd need to either "open" it with MySQL or connect to it via Base. If I could convert it to CSV, I can do any cleanup and prep work in Calc or some other tool I'm more familiar with. Thanks again, everyone! Excerpt: -- Table structure for table `donation_money` -- DROP TABLE IF EXISTS `donation_money`; CREATE TABLE `donation_money` ( `dm_id` mediumint(9) NOT NULL auto_increment, `dm_resource_id` mediumint(9) default NULL, `dm_promise_id` mediumint(9) default '0', `dm_date` date default NULL, `dm_amount` float(10,2) default NULL, `dm_receipt_number` varchar(15) default NULL, `dm_donation_code` varchar(15) default NULL, `dm_appeal_code` varchar(15) default 'NONE', `dm_payment_code` enum('CHE','CRD','CAS','ACH','STK','PAY','INK','OTH') default NULL, `dm_mem_hon` enum('NUL','MEM','HON') default NULL, `dm_mem_hon_who` varchar(40) default NULL, `dm_foundation_code` varchar(15) default 'NONE', `dm_in_kind_desc` varchar(60) default NULL, `dm_comment` varchar(255) default NULL, `dm_send_thank_you` tinyint(1) default '1', `dm_in_thank_you_set` tinyint(1) default '0', `dm_from_distribution_id` mediumint(9) default '0', `dm_user_field1` varchar(50) default NULL, `dm_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `dm_created_by` varchar(15) default NULL, `dm_modified` timestamp NOT NULL default '-00-00 00:00:00', `dm_modified_by` varchar(15) default NULL, PRIMARY KEY (`dm_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `donation_money` -- /*!4 ALTER TABLE `donation_money` DISABLE KEYS */; LOCK TABLES `donation_money` WRITE; INSERT INTO `donation_money` (`dm_id`, `dm_resource_id`, `dm_promise_id`, `dm_date`, `dm_amount`, `dm_receipt_number`, `dm_donation_code`, `dm_appeal_code`, `dm_payment_code`, `dm_mem_hon`, `dm_mem_hon_who`, `dm_foundation_code`, `dm_in_kind_desc`, `dm_comment`, `dm_send_thank_you`, `dm_in_thank_you_set`, `dm_from_distribution_id`, `dm_user_field1`, `dm_created`, `dm_created_by`, `dm_modified`, `dm_modified_by`) VALUES (1,467,NULL,'2008-05-12',60.00,'03718C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','',1,1,NULL,NULL,'2008-05-14 15:39:14','jessi','2008-08-07 17:17:40','george'),(2,467,NULL,'2007-06-11',35.00,'04379C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','', -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Connection to SQL database
Below is an excerpt from the file referring to the donations_money table. Obviously there are some ID fields, donation info fields (Amount, Date, etc.), a primary key field, etc. Immediately after the table, there's the "dump" of all the data in that table. I've only included one or two "records" from the dump, but there are many hundreds or even thousands of records. There are quite a few tables in the file, many of which we don't need (past logins under the old system, for example). Any wisdom on how to convert this data into CSV files? I thought I'd need to either "open" it with MySQL or connect to it via Base. If I could convert it to CSV, I can do any cleanup and prep work in Calc or some other tool I'm more familiar with. Thanks again, everyone! Excerpt: -- Table structure for table `donation_money` -- DROP TABLE IF EXISTS `donation_money`; CREATE TABLE `donation_money` ( `dm_id` mediumint(9) NOT NULL auto_increment, `dm_resource_id` mediumint(9) default NULL, `dm_promise_id` mediumint(9) default '0', `dm_date` date default NULL, `dm_amount` float(10,2) default NULL, `dm_receipt_number` varchar(15) default NULL, `dm_donation_code` varchar(15) default NULL, `dm_appeal_code` varchar(15) default 'NONE', `dm_payment_code` enum('CHE','CRD','CAS','ACH','STK','PAY','INK','OTH') default NULL, `dm_mem_hon` enum('NUL','MEM','HON') default NULL, `dm_mem_hon_who` varchar(40) default NULL, `dm_foundation_code` varchar(15) default 'NONE', `dm_in_kind_desc` varchar(60) default NULL, `dm_comment` varchar(255) default NULL, `dm_send_thank_you` tinyint(1) default '1', `dm_in_thank_you_set` tinyint(1) default '0', `dm_from_distribution_id` mediumint(9) default '0', `dm_user_field1` varchar(50) default NULL, `dm_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `dm_created_by` varchar(15) default NULL, `dm_modified` timestamp NOT NULL default '-00-00 00:00:00', `dm_modified_by` varchar(15) default NULL, PRIMARY KEY (`dm_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `donation_money` -- /*!4 ALTER TABLE `donation_money` DISABLE KEYS */; LOCK TABLES `donation_money` WRITE; INSERT INTO `donation_money` (`dm_id`, `dm_resource_id`, `dm_promise_id`, `dm_date`, `dm_amount`, `dm_receipt_number`, `dm_donation_code`, `dm_appeal_code`, `dm_payment_code`, `dm_mem_hon`, `dm_mem_hon_who`, `dm_foundation_code`, `dm_in_kind_desc`, `dm_comment`, `dm_send_thank_you`, `dm_in_thank_you_set`, `dm_from_distribution_id`, `dm_user_field1`, `dm_created`, `dm_created_by`, `dm_modified`, `dm_modified_by`) VALUES (1,467,NULL,'2008-05-12',60.00,'03718C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','',1,1,NULL,NULL,'2008-05-14 15:39:14','jessi','2008-08-07 17:17:40','george'),(2,467,NULL,'2007-06-11',35.00,'04379C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','', -- Carl Paulsen Dover, NH 03820 -- 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: Connection to SQL database
Sent to just Alex T by mistake: On 1/15/14 1:41 PM, Carl Paulsen wrote: OK, this is VERY helpful. I decided to try reading the file in a text editor and that was instructive! The file is about 13MB, and from a quick read through, the vast majority seems to be actual data in a kind of comma-delimited form. First part seems to be instructions for setting up the tables including keys and fields/columns, etc. I don't pretend to understand a lot of it, but I think I get the basics. So... Given it has instructions for table setup and raw data in it, how do I "open" it in LO? Or would I be better off moving to MySQL or something else and trying that? Is there usually info in the file about which db engine produced the file, or is there any other way to determine that? Maybe I'll just see if I can open it directly in LO and hope for the best. If you have other thoughts, though, I'd be grateful to hear them. Cheers again, Carl On 1/15/14 12:57 PM, Alex Thurgood wrote: Le 15/01/2014 16:51, Carl Paulsen a écrit : Hi Carl, An SQL file does not necessarily need to contain "data", it could contain just a set of instructions for the database engine to execute. The SQL file is not a database as such, it is a generally text file containing instructions that a SQL db engine will understand and optionally data enclosed within INSERT statements. If your SQL file contains both data and instructions, it would be a good idea to know how it was produced, i.e. from which db engine the output came, as SQL dialects between different vendors, db engines etc, can differ according to their specific implementations of the SQL standards. The file itself should be loadable into any text editor, providing that it can handle the size of the file ! That can give you a better idea of what's inside. For example, it is all very well having just insert statements with associated data in a SQL file, but if the tables and db haven't been set up in advance, you won't be able to get very far with it. Some of those SQL statements might be directly executable from an empty LO Base file in the Tools > SQL window, e.g. table creation statements, key definition statements, constraints, etc, but again that would depend on whether these statements were supported by the version of hsqldb that comes with a default embedded ODB database file. Alex -- Carl Paulsen Dover, NH 03820 -- 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] Connection to SQL database
Thanks again, Jay. Because of my long-time familiarity with Filemaker, Access, Salesforce (and Base soon I hope), I'm well aware of the structure of a relational database. And I'm pretty sophisticated user and even developer so long as the backend is hidden from me (LOL). Now I have this file I need to "open" and examine, and then move into separate tables/csv files to eventually move into Salesforce. The file came from a proprietary online database system (I'm not sure what) as a backup. And you are correct, the structure is almost certainly similar to what you outline (e.g. name/contact table, donations table, perhaps a volunteer actions table, etc. all with various keys to connect). But...I don't know just what tables are there, what field/columns are there, whether there's any consistency in data entry, and the like. All of this needs to be mapped into appropriate fields in the Salesforce system. I need to "see" the data and edit it (adding fields, splitting data up, etc.) in order to plan and prepare for the move, and then extract it into a csv file (the only file type that Salesforce will accept as a source). Thanks to Alex's suggestion, I've learned that the file contains table structure info (table name, column names and types, Key field assignments, etc.) with the actual data for each table included (comma separated I think). I suspect the file is sufficient to construct a SQL database that will contain all of the organization's data, either in MySQL or in Base or Access. But I need to figure out how to do that in such a way that I can assess what data is there and export into a csv file. Thanks again. Any more help is always appreciated. Carl On 1/15/14 2:43 PM, Jay Lozier wrote: Carl SQL is the query language used by relational databases and there is ANSI/ISO standard specification for the SQL. So, in principle, any relational database should understand vanilla SQL. Generally, this is true. HSQL (Base backend), Jet (Access), Oracle, MySQL/MariaDB, PostgreSQL, and SQL Server are all relational databases and they all use SQL as their query language. The only warning is all the database providers have added extensions to the SQL language. The GUIs used by Base and Access tend to hide the SQL query from the user. Some of the other tools such as PgAdmin (PostgreSQL) or MySQL Workbench generally require you to write the SQL query in an editor. But these tools allow to use a GUI to access most of the database functions. The database is program for storing and accessing data that has some sort of structure. In a relational database, the data is organized in tables that consist of rows (specific data) and columns (data types). To keep the data manageable, the data is usually broken up across a series of related tables with defined relations between the tables defined (the data in a specific row in Table A is related to the data in specific row in Table B). In relational database each column has specific data type (number, string, date, etc.). Your raw data, say for a donor, would consist of name, address, contact information, pledge amount, payments, etc. You would probably split the data into two or more tables. One table would have the donor name, address, and contact information. Another table might have a record of contacts including type, date, result. A third table might have a detail record of payments/donations with date and amounts. To relate each table, each table would likely have a primary key assigned for each entry with appropriate foreign keys (keys that refer to an entry in another table) included as well as the data specific to the table. A query would use these keys to get the data and combine it into a result set. The data design is based on the principle of entry data only once into the database (called "normalization"). So you would only have one table with the donor's name entered while the other tables that would refer to the entry would was the entry's primary key to refer to it. Often integers are used as primary keys because they are easy to deal with and increment nicely. The only requirement for a primary key is that is unique to the table. If you are using MySQL or MariaDB (MariaDB is a MySQL fork) a pretty good book specific to that family is MariaDB: A Crash Course by Ben Forta. It covers basic SQL, basic database design, etc. Jay On 01/15/2014 01:34 PM, Carl Paulsen wrote: Thanks, Jay, that is VERY helpful and clarifies a lot. I wondered if I needed the server setup but lots of things I read yesterday suggested I did need that. I do understand that things like Base and Access are just GUIs, but I guess I really just don't understand what a database is and, in particular, what SQL is. I know there needs to be raw data and a file/table structure and I assume a way to interact with it, but I'm still missing a lot. Is there a basic online reference to help me understand what a SQL
Re: [libreoffice-users] Connection to SQL database
Carl SQL is the query language used by relational databases and there is ANSI/ISO standard specification for the SQL. So, in principle, any relational database should understand vanilla SQL. Generally, this is true. HSQL (Base backend), Jet (Access), Oracle, MySQL/MariaDB, PostgreSQL, and SQL Server are all relational databases and they all use SQL as their query language. The only warning is all the database providers have added extensions to the SQL language. The GUIs used by Base and Access tend to hide the SQL query from the user. Some of the other tools such as PgAdmin (PostgreSQL) or MySQL Workbench generally require you to write the SQL query in an editor. But these tools allow to use a GUI to access most of the database functions. The database is program for storing and accessing data that has some sort of structure. In a relational database, the data is organized in tables that consist of rows (specific data) and columns (data types). To keep the data manageable, the data is usually broken up across a series of related tables with defined relations between the tables defined (the data in a specific row in Table A is related to the data in specific row in Table B). In relational database each column has specific data type (number, string, date, etc.). Your raw data, say for a donor, would consist of name, address, contact information, pledge amount, payments, etc. You would probably split the data into two or more tables. One table would have the donor name, address, and contact information. Another table might have a record of contacts including type, date, result. A third table might have a detail record of payments/donations with date and amounts. To relate each table, each table would likely have a primary key assigned for each entry with appropriate foreign keys (keys that refer to an entry in another table) included as well as the data specific to the table. A query would use these keys to get the data and combine it into a result set. The data design is based on the principle of entry data only once into the database (called "normalization"). So you would only have one table with the donor's name entered while the other tables that would refer to the entry would was the entry's primary key to refer to it. Often integers are used as primary keys because they are easy to deal with and increment nicely. The only requirement for a primary key is that is unique to the table. If you are using MySQL or MariaDB (MariaDB is a MySQL fork) a pretty good book specific to that family is MariaDB: A Crash Course by Ben Forta. It covers basic SQL, basic database design, etc. Jay On 01/15/2014 01:34 PM, Carl Paulsen wrote: Thanks, Jay, that is VERY helpful and clarifies a lot. I wondered if I needed the server setup but lots of things I read yesterday suggested I did need that. I do understand that things like Base and Access are just GUIs, but I guess I really just don't understand what a database is and, in particular, what SQL is. I know there needs to be raw data and a file/table structure and I assume a way to interact with it, but I'm still missing a lot. Is there a basic online reference to help me understand what a SQL database is and what MySQL and the rest are relative to that? Thx, Carl On 1/15/14 12:11 PM, Jay Lozier wrote: Carl Backend is a database term that refers to the database itself such as MySQL, JET (MS Access), SQL Server, etc. Most non DBA's refer to the GUI tools (BASE, Access) as the database when in fact they are used to connect various backends. Base and Access both can connect to the variety of backends not just the default they are shipped with. I do not think you need XAMP just the database connector and database. XAMP refers to X = OS, A = Apache server, M = MySQL, and P = Perl/Python/PHP. It is normally used by developers and the reason for the Apache server is to provide test for web connectivity. PHP is a very common server scripting language used by many websites. For Windows is sometimes called WAMP, Mac - MAMP, and Linux - LAMP. I use MySQL for database development and do not use LAMP (Linux user) at all because I only need the database. Jay On 01/15/2014 11:55 AM, Carl Paulsen wrote: OK, thanks everyone. My system: Mac: OS 10.6.8 and LO 4.0.4.2 (I was thinking of upgrading to LO 4.1.4) PC: Win7 and OOo 3.2 (I could install any version of LO on the PC) I'm pretty far over my head here based on how little I understand of the replies, but I'm sure I can do it if I persist. Here's what I think I'm hearing so far: 1. Lots of talk about the "backend." I thought the file I had was the data itself which I'd hoped I could somehow directly access, but even if it were the data, it sounds like at best I'd have to serve that file/data using MySQL or something like that and a server like XAMP, then connect via Base. Right? In which case I might be able to extract the data directly fro
Re: [libreoffice-users] Connection to SQL database
Thanks, Jay, that is VERY helpful and clarifies a lot. I wondered if I needed the server setup but lots of things I read yesterday suggested I did need that. I do understand that things like Base and Access are just GUIs, but I guess I really just don't understand what a database is and, in particular, what SQL is. I know there needs to be raw data and a file/table structure and I assume a way to interact with it, but I'm still missing a lot. Is there a basic online reference to help me understand what a SQL database is and what MySQL and the rest are relative to that? Thx, Carl On 1/15/14 12:11 PM, Jay Lozier wrote: Carl Backend is a database term that refers to the database itself such as MySQL, JET (MS Access), SQL Server, etc. Most non DBA's refer to the GUI tools (BASE, Access) as the database when in fact they are used to connect various backends. Base and Access both can connect to the variety of backends not just the default they are shipped with. I do not think you need XAMP just the database connector and database. XAMP refers to X = OS, A = Apache server, M = MySQL, and P = Perl/Python/PHP. It is normally used by developers and the reason for the Apache server is to provide test for web connectivity. PHP is a very common server scripting language used by many websites. For Windows is sometimes called WAMP, Mac - MAMP, and Linux - LAMP. I use MySQL for database development and do not use LAMP (Linux user) at all because I only need the database. Jay On 01/15/2014 11:55 AM, Carl Paulsen wrote: OK, thanks everyone. My system: Mac: OS 10.6.8 and LO 4.0.4.2 (I was thinking of upgrading to LO 4.1.4) PC: Win7 and OOo 3.2 (I could install any version of LO on the PC) I'm pretty far over my head here based on how little I understand of the replies, but I'm sure I can do it if I persist. Here's what I think I'm hearing so far: 1. Lots of talk about the "backend." I thought the file I had was the data itself which I'd hoped I could somehow directly access, but even if it were the data, it sounds like at best I'd have to serve that file/data using MySQL or something like that and a server like XAMP, then connect via Base. Right? In which case I might be able to extract the data directly from the server? 2. Ryan may be right, I think what I have is a so-called backup from a commercial fundraising database used by a non-profit I'm working with. Perhaps it's just scripts that connect to a hosted database? How do I "execute" my .sql file on a MySQL server (which I've set up on my Win7 machine)? I am assuming I can get XAMP to serve up MySQL on the Win7 machine... Ryan, can I contact you off-list if I figure out how to set up the MySQL server? 3. I assume I'll need a password/login credentials, but can get them if I need them. I'm sure the data is in schema of some sort. 4. Thanks for the reference Fernand. Cheers, Carl -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base - Passthrough queries?
Le 15/01/2014 16:14, Ryan Ashley a écrit : Hi Ryan, > In Access I can runn a passthrough query to execute SQL commands on a > true DB server. Is this possible in Base? I have a MariaDB server and > want to use Base to create forms for accessing it, but need to run SQL > commands to encrypt and decrypt certain data, so linking the tables > won't work. There is an option to execute SQL directly. >From within the main LO Base window, once an ODB file is opened, go to Tools > SQL If you are just carrying out a select query, you can do this via the "Construct a query in SQL mode" Note that only select queries are supported via the Query GUI. Use the Tools > SQL menu entry for DDL statements. Also note that even Tools > SQL does not replace a command line client console, so your mileage as to what you want to actually achieve might vary. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Connection to SQL database
Le 15/01/2014 16:51, Carl Paulsen a écrit : Hi Carl, An SQL file does not necessarily need to contain "data", it could contain just a set of instructions for the database engine to execute. The SQL file is not a database as such, it is a generally text file containing instructions that a SQL db engine will understand and optionally data enclosed within INSERT statements. If your SQL file contains both data and instructions, it would be a good idea to know how it was produced, i.e. from which db engine the output came, as SQL dialects between different vendors, db engines etc, can differ according to their specific implementations of the SQL standards. The file itself should be loadable into any text editor, providing that it can handle the size of the file ! That can give you a better idea of what's inside. For example, it is all very well having just insert statements with associated data in a SQL file, but if the tables and db haven't been set up in advance, you won't be able to get very far with it. Some of those SQL statements might be directly executable from an empty LO Base file in the Tools > SQL window, e.g. table creation statements, key definition statements, constraints, etc, but again that would depend on whether these statements were supported by the version of hsqldb that comes with a default embedded ODB database file. Alex -- 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] Similar Problem?
Not sure if this got to the list Alex On Wednesday 15 Jan 2014 16:46:24 you wrote: > Having said all that. It would appear that I've never had auto backup > switched on. > > Having switched it on I now see backups and autobackups for writer and calc > documents. Nothing at all for base documents. > > Alex > > > > On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote: > > I used to have that problem. It seems to have stopped around about 16th > > July 2013. Not sure why! > > > > Either - > > > > I upgraded LibreOffice which stopped the feature > > or I did something else which I can't remember! > > > > I'm currently on 4.1.4.2. > > > > Alex > > > > > > > > > > On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote: > > > Hi :) > > > Errr, is it possible to switch the auto-save and auto-backups off for > > > a while and see if that improves things? The thing i find difficult > > > about doing that is remembering to save properly and frequently > > > enough. With Base i think it's also important to close properly. > > > > > > There is some documentation and a handbook at > > > https://wiki.documentfoundation.org/Documentation/Publications > > > and the Faq at > > > https://wiki.documentfoundation.org/Faq > > > might be able to help too but the best place seems to be this mailing > > > list or the Base forums at Apache OpenOffice. > > > Regards from > > > Tom :) > > > > > > On 15 January 2014 07:30, Tom Davies wrote: > > > > Hi :) > > > > Errr, are you using the internal back-end? You haven't connected to > > > > an external back-end have you? You should really be keeping your data > > > > in an external back-end instead of having the whole database as a > > > > single file. > > > > > > > > Being able to do that is one of the main things that makes Base so > > > > much more powerful than Access. The internal back-end got tacked on > > > > to make Base more familiar to people who have picked up bad habits by > > > > using Access. It seems to be a bit broken though. Annoyingly the > > > > Marketing Mailing List and all our flyers, posters and leaflets (at > > > > least all the ones that mention Base at all) keep pushing people into > > > > using the internal back-end despite the fact that users have even > > > > experienced data-loss by doing so. I'm tempted to ask you to take > > > > this problem to the marketing list to get them to solve it but the > > > > experts in Base are mostly on this list and will hopefully be able to > > > > help with this issue. > > > > > > > > It should be possible to export your existing tables into an external > > > > back-end and this mailing list (note, not the marketing list) might be > > > > able to help you with that. > > > > > > > > The next smart thing about Base is that forms and reports can be, and > > > > are best made in Writer or/and (i think) Calc. So normal users who > > > > are clueless about databases can read the data in a familiar setting > > > > and use familiar tools to format and edit things around the > > > > data-fields. The forms and reports inside Base seem to be for > > > > data-entry and people who have some clue about databases. > > > > > > > > However i have never quite got around to getting to grips with all > > > > this. So hopefully some of the experts might wade in and set me > > > > straight (again) > > > > Regards from > > > > Tom :) > > > > > > > > > > > > > > > > > > > > On 15 January 2014 05:57, Vince Radice wrote: > > > >> I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 > > > >> Build ID: 4.1.4.2-2.fc19 > > > >> > > > >> Here are some lines of a ls -la command > > > >> > > > >> -rw---. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1008.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1009.odb > > > >> -rw---. 1 vince root 0 Dec 13 13:26 GRNew odb_100.odb > > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1010.odb > > > >> > > > >> My database name is GRNew,odb. > > > >> I was looking at some of the recent messages that were talking about LO > > > >> looping saving backups of untitled documents. It mentioned Calc and > > > >> Write > > > >> as being involved. Could this be related to my problem? > > > >> > > > >> Thanks, > > > >> Vince Radice > > > >> > > > >> > > > >> On 01/14/2014 12:44
Re: [libreoffice-users] Similar Problem?
Having said all that. It would appear that I've never had auto backup switched on. Having switched it on I now see backups and autobackups for writer and calc documents. Nothing at all for base documents. Alex On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote: > I used to have that problem. It seems to have stopped around about 16th July > 2013. Not sure why! > > Either - > > I upgraded LibreOffice which stopped the feature > or I did something else which I can't remember! > > I'm currently on 4.1.4.2. > > Alex > > > > > On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote: > > Hi :) > > Errr, is it possible to switch the auto-save and auto-backups off for > > a while and see if that improves things? The thing i find difficult > > about doing that is remembering to save properly and frequently > > enough. With Base i think it's also important to close properly. > > > > There is some documentation and a handbook at > > https://wiki.documentfoundation.org/Documentation/Publications > > and the Faq at > > https://wiki.documentfoundation.org/Faq > > might be able to help too but the best place seems to be this mailing > > list or the Base forums at Apache OpenOffice. > > Regards from > > Tom :) > > > > On 15 January 2014 07:30, Tom Davies wrote: > > > Hi :) > > > Errr, are you using the internal back-end? You haven't connected to > > > an external back-end have you? You should really be keeping your data > > > in an external back-end instead of having the whole database as a > > > single file. > > > > > > Being able to do that is one of the main things that makes Base so > > > much more powerful than Access. The internal back-end got tacked on > > > to make Base more familiar to people who have picked up bad habits by > > > using Access. It seems to be a bit broken though. Annoyingly the > > > Marketing Mailing List and all our flyers, posters and leaflets (at > > > least all the ones that mention Base at all) keep pushing people into > > > using the internal back-end despite the fact that users have even > > > experienced data-loss by doing so. I'm tempted to ask you to take > > > this problem to the marketing list to get them to solve it but the > > > experts in Base are mostly on this list and will hopefully be able to > > > help with this issue. > > > > > > It should be possible to export your existing tables into an external > > > back-end and this mailing list (note, not the marketing list) might be > > > able to help you with that. > > > > > > The next smart thing about Base is that forms and reports can be, and > > > are best made in Writer or/and (i think) Calc. So normal users who > > > are clueless about databases can read the data in a familiar setting > > > and use familiar tools to format and edit things around the > > > data-fields. The forms and reports inside Base seem to be for > > > data-entry and people who have some clue about databases. > > > > > > However i have never quite got around to getting to grips with all > > > this. So hopefully some of the experts might wade in and set me > > > straight (again) > > > Regards from > > > Tom :) > > > > > > > > > > > > > > > On 15 January 2014 05:57, Vince Radice wrote: > > >> I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 > > >> Build ID: 4.1.4.2-2.fc19 > > >> > > >> Here are some lines of a ls -la command > > >> > > >> -rw---. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb > > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1008.odb > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1009.odb > > >> -rw---. 1 vince root 0 Dec 13 13:26 GRNew odb_100.odb > > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1010.odb > > >> > > >> My database name is GRNew,odb. > > >> I was looking at some of the recent messages that were talking about LO > > >> looping saving backups of untitled documents. It mentioned Calc and > > >> Write > > >> as being involved. Could this be related to my problem? > > >> > > >> Thanks, > > >> Vince Radice > > >> > > >> > > >> On 01/14/2014 12:44 PM, Tom Davies wrote: > > >>> > > >>> Hi :) > > >>> On Ubuntu 12.04 i have no files in there. Do the file-names start > > >>> with a ~ or with "lock"? In either of those cases i think you can > > >>> delete the files without worry but it might be worth testing that for > > >>> 1 or 2 files. > > >>> > > >>>
Re: [libreoffice-users] Connection to SQL database
Carl , Use a mySQL database and connect over the Native Connector then google for the book "DataBase Programming" writen by Roberto Benitez for Openoffice but also for LibreOffice a lot of code can been found on the Book-website Greetz Fernand On 15/01/2014 16:55, Ryan Ashley wrote: SQL files are normally SQL scripts which are backups or scripts that create a database on a SQL server. If you need something in that script, you would need to setup a MySQL server, execute the SQL file on that server, and then get the data out that you need. I know that is a mouthful, and the process varies based on your operating system (Linux, Windows, Mac, etc). After you do the above, you can connect with base, but you could also get your data out using the MySQL Workbench tool or even a command-line if you are using Linux. I can help you if somebody else doesn't help first, but I need to know what OS you are running to be able to help you further. On 01/15/2014 10:51 AM, Carl Paulsen wrote: I have a project for which I need to extract data that is in a .sql file (presumably a SQL database). I've done very little with SQL so I need some guidance on doing this. One route would be to open it with Base or Access (I now finally have access to MSAccess on a Windows machine but would prefer Base), but I don't understand the basics of doing this. So...can someone point me to a tutorial on how to do this, step-by-step and from the very beginning? For instance, do I need to set up a SQL server and if so, how? (I've tried installing XAMP with MySQL on the Windows machine but haven't gotten it to connect to the file yet.) Can I access a .sql file directly or via other methods? I'd like to eventually learn how to use SQL but I'm also on a pretty limited timeframe on accessing this data. Or does someone want to outline the steps here for me to research on my own? Thanks very much, Carl -- 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] Connection to SQL database
On 01/15/2014 10:51 AM, Carl Paulsen wrote: I have a project for which I need to extract data that is in a .sql file (presumably a SQL database). I've done very little with SQL so I need some guidance on doing this. One route would be to open it with Base or Access (I now finally have access to MSAccess on a Windows machine but would prefer Base), but I don't understand the basics of doing this. So...can someone point me to a tutorial on how to do this, step-by-step and from the very beginning? For instance, do I need to set up a SQL server and if so, how? (I've tried installing XAMP with MySQL on the Windows machine but haven't gotten it to connect to the file yet.) Can I access a .sql file directly or via other methods? I'd like to eventually learn how to use SQL but I'm also on a pretty limited timeframe on accessing this data. Or does someone want to outline the steps here for me to research on my own? Thanks very much, Carl Carl First please advise your OS and LO version. The basic steps to connect to any outside database backend are: 1. Set up the database backend - Note any usernames and passwords used to connect to the database. Often the install wizard will prompt you for both. 2. Make sure it is running - depending on your boot settings you might need to manually start the backend. This may require you to use your command line aka terminal on Linux and Macs, Command on Windows. 3. Make sure the correct connector for your backend is installed for Base. In Linux check your package manager to make sure it is installed. I am not sure what the Windows or Mac installers do. 4. Run the connection wizard in Base. A detail I am not sure about here is whether you need to have any schema/database/tables set up in the backend. I usually use Base for pretty reports for a MySQL/MariaDB backend that has numerous schemas/tables already setup. If you used the default settings when setting up the database backend you mainly have to enter the log in credentials. Most backends have a default port they listen on (MySQL/MariaDB is 3306) and normally you do not need to change this. Also, you will need to know the path to the database or URL to reach it. If the database backend is on your local computer the path is localhost (127.0.0.1). -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Connection to SQL database
SQL files are normally SQL scripts which are backups or scripts that create a database on a SQL server. If you need something in that script, you would need to setup a MySQL server, execute the SQL file on that server, and then get the data out that you need. I know that is a mouthful, and the process varies based on your operating system (Linux, Windows, Mac, etc). After you do the above, you can connect with base, but you could also get your data out using the MySQL Workbench tool or even a command-line if you are using Linux. I can help you if somebody else doesn't help first, but I need to know what OS you are running to be able to help you further. On 01/15/2014 10:51 AM, Carl Paulsen wrote: I have a project for which I need to extract data that is in a .sql file (presumably a SQL database). I've done very little with SQL so I need some guidance on doing this. One route would be to open it with Base or Access (I now finally have access to MSAccess on a Windows machine but would prefer Base), but I don't understand the basics of doing this. So...can someone point me to a tutorial on how to do this, step-by-step and from the very beginning? For instance, do I need to set up a SQL server and if so, how? (I've tried installing XAMP with MySQL on the Windows machine but haven't gotten it to connect to the file yet.) Can I access a .sql file directly or via other methods? I'd like to eventually learn how to use SQL but I'm also on a pretty limited timeframe on accessing this data. Or does someone want to outline the steps here for me to research on my own? Thanks very much, Carl -- 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] Connection to SQL database
I have a project for which I need to extract data that is in a .sql file (presumably a SQL database). I've done very little with SQL so I need some guidance on doing this. One route would be to open it with Base or Access (I now finally have access to MSAccess on a Windows machine but would prefer Base), but I don't understand the basics of doing this. So...can someone point me to a tutorial on how to do this, step-by-step and from the very beginning? For instance, do I need to set up a SQL server and if so, how? (I've tried installing XAMP with MySQL on the Windows machine but haven't gotten it to connect to the file yet.) Can I access a .sql file directly or via other methods? I'd like to eventually learn how to use SQL but I'm also on a pretty limited timeframe on accessing this data. Or does someone want to outline the steps here for me to research on my own? Thanks very much, Carl -- Carl Paulsen Dover, NH 03820 -- 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 - Passthrough queries?
In Access I can runn a passthrough query to execute SQL commands on a true DB server. Is this possible in Base? I have a MariaDB server and want to use Base to create forms for accessing it, but need to run SQL commands to encrypt and decrypt certain data, so linking the tables won't work. Also, thank you for the advice with my last issue! I will be looking into using one of those methods to do an application style form later today. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto save didn't work?
Le 15/01/2014 04:30, rost52 a écrit : Hi, > > Is below statement only valid for a Mac or also for a PC with XP? This is my experience on Mac over the different versions of LO from 3.3.0 to present, and having moved through Snow Leopard to Lion to Mountain Lion and now Mavericks. I have seen issues in the past on Linux where autosave was activated and didn't function as intended, i.e. it was impossible to recover anything, but that was a while ago, and probably with Openoffice.org at the time. Alex -- 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] Similar Problem?
I used to have that problem. It seems to have stopped around about 16th July 2013. Not sure why! Either - I upgraded LibreOffice which stopped the feature or I did something else which I can't remember! I'm currently on 4.1.4.2. Alex On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote: > Hi :) > Errr, is it possible to switch the auto-save and auto-backups off for > a while and see if that improves things? The thing i find difficult > about doing that is remembering to save properly and frequently > enough. With Base i think it's also important to close properly. > > There is some documentation and a handbook at > https://wiki.documentfoundation.org/Documentation/Publications > and the Faq at > https://wiki.documentfoundation.org/Faq > might be able to help too but the best place seems to be this mailing > list or the Base forums at Apache OpenOffice. > Regards from > Tom :) > > On 15 January 2014 07:30, Tom Davies wrote: > > Hi :) > > Errr, are you using the internal back-end? You haven't connected to > > an external back-end have you? You should really be keeping your data > > in an external back-end instead of having the whole database as a > > single file. > > > > Being able to do that is one of the main things that makes Base so > > much more powerful than Access. The internal back-end got tacked on > > to make Base more familiar to people who have picked up bad habits by > > using Access. It seems to be a bit broken though. Annoyingly the > > Marketing Mailing List and all our flyers, posters and leaflets (at > > least all the ones that mention Base at all) keep pushing people into > > using the internal back-end despite the fact that users have even > > experienced data-loss by doing so. I'm tempted to ask you to take > > this problem to the marketing list to get them to solve it but the > > experts in Base are mostly on this list and will hopefully be able to > > help with this issue. > > > > It should be possible to export your existing tables into an external > > back-end and this mailing list (note, not the marketing list) might be > > able to help you with that. > > > > The next smart thing about Base is that forms and reports can be, and > > are best made in Writer or/and (i think) Calc. So normal users who > > are clueless about databases can read the data in a familiar setting > > and use familiar tools to format and edit things around the > > data-fields. The forms and reports inside Base seem to be for > > data-entry and people who have some clue about databases. > > > > However i have never quite got around to getting to grips with all > > this. So hopefully some of the experts might wade in and set me > > straight (again) > > Regards from > > Tom :) > > > > > > > > > > On 15 January 2014 05:57, Vince Radice wrote: > >> I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 > >> Build ID: 4.1.4.2-2.fc19 > >> > >> Here are some lines of a ls -la command > >> > >> -rw---. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb > >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1008.odb > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1009.odb > >> -rw---. 1 vince root 0 Dec 13 13:26 GRNew odb_100.odb > >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1010.odb > >> > >> My database name is GRNew,odb. > >> I was looking at some of the recent messages that were talking about LO > >> looping saving backups of untitled documents. It mentioned Calc and Write > >> as being involved. Could this be related to my problem? > >> > >> Thanks, > >> Vince Radice > >> > >> > >> On 01/14/2014 12:44 PM, Tom Davies wrote: > >>> > >>> Hi :) > >>> On Ubuntu 12.04 i have no files in there. Do the file-names start > >>> with a ~ or with "lock"? In either of those cases i think you can > >>> delete the files without worry but it might be worth testing that for > >>> 1 or 2 files. > >>> > >>> Going off on a tangent i do have a non-LibreOffice folder with a load > >>> of crash reports from when i don't close Xbmc properly and i routinely > >>> delete all of them from time-to-time. I'm not sure if this is similar > >>> or not. > >>> Regards from > >>> Tom :) > >>> > >>> > >>> On 14 January 2014 04:12, Vince Radice wrote: > > I am seeing something and I don't know if it is a problem or something I > have to live with. > > In the ~/.config/libreoffice/4/use
[libreoffice-users] Re: Base - Application mode?
Le 14/01/2014 22:42, Ryan Ashley a écrit : Hi Ashley, > In MS Access you can select a startup form that will open when the > database file is opened. You can also hide all of the development stuff > (buttons, toolbars, etc) when said form opens so it appears to the end > user as an application. How do I do this in Base? I have been struggling > for a week trying to figure this out. Heck, I am struggling with Base > period, it is much more difficult to use than Access, but I can overlook > that due to the power it has that Access does not. Still, how do I hide > the development stuff and open my form when the ODB file is opened? > You might want to check out the Switchboard extension to see whether that goes in the direction you're looking at. http://extensions.openoffice.org/de/project/SwitchBoard otherwise you will have to write a macro to bind the loading of the form to the event of opening the ODB file and probably fiddle with xcu/xcs (xml configuration files) that deal with the toolbars, bearing in mind that some of the toolbars are dependent on the main LibreOffice app and probably can not be completely removed. Alex -- 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] Editing Custom Styles in Calc
At 04:48 15/01/2014 -0800, James E Lang wrote: I use custom styles in Conditional Formatting. For example, I highlight cells that contain values that are more than 2.5 standard deviations on either side of the mean value of the data. I am unable to delete styles that I no longer need or to change their characteristics (e.g. background color) to better meet my needs. You should be able to do either of these, of course. What should I do? Perhaps explain what you tried, what you expected to happen, and what actually happened? Otherwise, anyone can only guess. o Go to Format | Styles and Formatting (or click the Styles and Formatting button in the Formatting toolbar, or press F11). o Click Cell Styles. o Ensure that the drop-down menu at the bottom allows the display of the relevant style. o Right-click the relevant style and go to Modify... | Background - or to Delete... . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Editing Custom Styles in Calc
Highlight the area, then Format > Clear Direct Formatting. Tink. -- View this message in context: http://nabble.documentfoundation.org/Editing-Custom-Styles-in-Calc-tp4092310p4092325.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Editing Custom Styles in Calc
I use custom styles in Conditional Formatting. For example, I highlight cells that contain values that are more than 2.5 standard deviations on either side of the mean value of the data. I am unable to delete styles that I no longer need or to change their characteristics (e.g. background color) to better meet my needs. What should I do? -- Jim -- 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 - Application mode?
Hi :) There is also the idea that you can create a Writer document that acts as a form or a report. Opening the Writer document only shows "the front-end". I think it can't be used to enter data but is good for just using and accessing the data. Regards from Tom :) On 14 January 2014 23:32, Marion & Noel Lodge wrote: > Hi Ryan, > > I'm not sure if this is the best solution, but I have found that it works - > > Create the following macros - > > Sub OpenfMainMenu() > OpenForm("fMainMenu") > End Sub > > Sub OpenForm(FormName AS String)'Called from OpenfMainMenu() > With ThisDatabaseDocument.currentcontroller > If Not .isConnected Then >.Connect > End if > End With > ThisDatabaseDocument.FormDocuments.getByName(FormName).open > End Sub > > I have called my form "fMain Menu". In your macro, alter the form name to > the name of the form you want to open on startup. > > Then on LibreOffice's main form, (the one with buttons for Tables, Queries, > Forms and Reports down the left hand side), choose > Tools|Customise|Events|Open Document and assign the OpenfMainMenu() macro. > > Now, when you start LibreOffice you should find that the desired form will > open. Depending on the speed of your PC/Notebook, you may see the > LibreOffice main form briefly, (or on slow machines, not so briefly!), > before the desired form opens. I haven't yet found a way to prevent this > happening, but I have found that it doesn't seem to worry most users as > long as the familiar form eventually appears. > > Hope this helps. > > Noel > -- > Noel Lodge > lodg...@gmail.com > > > On 15 January 2014 08:42, Ryan Ashley wrote: > >> In MS Access you can select a startup form that will open when the >> database file is opened. You can also hide all of the development stuff >> (buttons, toolbars, etc) when said form opens so it appears to the end user >> as an application. How do I do this in Base? I have been struggling for a >> week trying to figure this out. Heck, I am struggling with Base period, it >> is much more difficult to use than Access, but I can overlook that due to >> the power it has that Access does not. Still, how do I hide the development >> stuff and open my form when the ODB file is opened? >> >> -- >> 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 >> >> > > -- > 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 > -- 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: Auto save didn't work?
Hi :) I tend to have auto-save off or set at much longer intervals. Generally i tend to find that it takes almost no-time to re-type or re-do anything that took under 20mins to do the 1st time around and often there is an improvement 2nd time around anyway. Also i find it really frustrating to have to stop mid-flow when i am cracking on with something. It's too easy to get distracted in my office as it is anyway. 20mins to half hour saves are usually more than enough and if i do them myself then it's easier to remember to add 1 to the documents version number to make sure i have an old version in easy reach if something goes badly wrong. Errr, my version numbers are a tad basic, none of this fancy 3 digit and meaningful = i just stick a -v1 at the end and then up that number at random intervals to get things like; KhidmatSisters-poster-2014-Jan-v2 well not quite like that but it gives a rough idea. If i'm collaborating with other people then i tend to occasionally sweep all those older versions into a sub-folder, along with all my images, potential images, logos, notes from elsewhere and other clutter. Then a few months later i have a quick scroll through the sub-folder to see if anything should be copied elsewhere and then delete the sub-folder. Regards from Tom :) On 15 January 2014 03:40, Kracked_P_P---webmaster wrote: > > I had a "crash" a few days ago, but it was not really one, but a system > "forced shutdown". When I reopened LO [not the issue] it recovered the file > properly. > > I keep auto save at 5 minutes or less. > > > > On 01/14/2014 10:30 PM, rost52 wrote: >> >> Hi Alex, >> >> Is below statement only valid for a Mac or also for a PC with XP? >> >> In the past (LibO version before 4.1.4.2 eg.4.0.5 or 6 and earlier) I >> never observed problems with autosave and recovery when LibO crashed. >> >> Thanks in advance for your comment. >> >> ROSt52 >> >> On 2014-01-14 23:39, Alex Thurgood wrote: >>> >>> However, LO, at least in the 4.0.x versions (don't know if later >>> versions do better) doesn't know how to deal with this situation with >>> regard to temporary files that it creates (your autosave files are store >>> in a temporary file store), so they just get wiped from memory when the >>> app is shut down. >> >> >> > > > -- > 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 > -- 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] Similar Problem?
Hi :) Errr, is it possible to switch the auto-save and auto-backups off for a while and see if that improves things? The thing i find difficult about doing that is remembering to save properly and frequently enough. With Base i think it's also important to close properly. There is some documentation and a handbook at https://wiki.documentfoundation.org/Documentation/Publications and the Faq at https://wiki.documentfoundation.org/Faq might be able to help too but the best place seems to be this mailing list or the Base forums at Apache OpenOffice. Regards from Tom :) On 15 January 2014 07:30, Tom Davies wrote: > Hi :) > Errr, are you using the internal back-end? You haven't connected to > an external back-end have you? You should really be keeping your data > in an external back-end instead of having the whole database as a > single file. > > Being able to do that is one of the main things that makes Base so > much more powerful than Access. The internal back-end got tacked on > to make Base more familiar to people who have picked up bad habits by > using Access. It seems to be a bit broken though. Annoyingly the > Marketing Mailing List and all our flyers, posters and leaflets (at > least all the ones that mention Base at all) keep pushing people into > using the internal back-end despite the fact that users have even > experienced data-loss by doing so. I'm tempted to ask you to take > this problem to the marketing list to get them to solve it but the > experts in Base are mostly on this list and will hopefully be able to > help with this issue. > > It should be possible to export your existing tables into an external > back-end and this mailing list (note, not the marketing list) might be > able to help you with that. > > The next smart thing about Base is that forms and reports can be, and > are best made in Writer or/and (i think) Calc. So normal users who > are clueless about databases can read the data in a familiar setting > and use familiar tools to format and edit things around the > data-fields. The forms and reports inside Base seem to be for > data-entry and people who have some clue about databases. > > However i have never quite got around to getting to grips with all > this. So hopefully some of the experts might wade in and set me > straight (again) > Regards from > Tom :) > > > > > On 15 January 2014 05:57, Vince Radice wrote: >> I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 >> Build ID: 4.1.4.2-2.fc19 >> >> Here are some lines of a ls -la command >> >> -rw---. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb >> -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1008.odb >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1009.odb >> -rw---. 1 vince root 0 Dec 13 13:26 GRNew odb_100.odb >> -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1010.odb >> >> My database name is GRNew,odb. >> I was looking at some of the recent messages that were talking about LO >> looping saving backups of untitled documents. It mentioned Calc and Write >> as being involved. Could this be related to my problem? >> >> Thanks, >> Vince Radice >> >> >> On 01/14/2014 12:44 PM, Tom Davies wrote: >>> >>> Hi :) >>> On Ubuntu 12.04 i have no files in there. Do the file-names start >>> with a ~ or with "lock"? In either of those cases i think you can >>> delete the files without worry but it might be worth testing that for >>> 1 or 2 files. >>> >>> Going off on a tangent i do have a non-LibreOffice folder with a load >>> of crash reports from when i don't close Xbmc properly and i routinely >>> delete all of them from time-to-time. I'm not sure if this is similar >>> or not. >>> Regards from >>> Tom :) >>> >>> >>> On 14 January 2014 04:12, Vince Radice wrote: I am seeing something and I don't know if it is a problem or something I have to live with. In the ~/.config/libreoffice/4/user/backup directory, I have 3,000+ files with 0 bytes. I assume that this means the files are empty. There are other files there which are not empty. The non-empty ones appear to be backups of files I have worked on. The empty files all appear to be attempts to backup a Base database that I have created using the built in hsql engine. The file is stored on my computer. The time stamps on the files are unusual. There are 6 files with a time stamp of
Re: [libreoffice-users] Similar Problem?
Hi :) Errr, are you using the internal back-end? You haven't connected to an external back-end have you? You should really be keeping your data in an external back-end instead of having the whole database as a single file. Being able to do that is one of the main things that makes Base so much more powerful than Access. The internal back-end got tacked on to make Base more familiar to people who have picked up bad habits by using Access. It seems to be a bit broken though. Annoyingly the Marketing Mailing List and all our flyers, posters and leaflets (at least all the ones that mention Base at all) keep pushing people into using the internal back-end despite the fact that users have even experienced data-loss by doing so. I'm tempted to ask you to take this problem to the marketing list to get them to solve it but the experts in Base are mostly on this list and will hopefully be able to help with this issue. It should be possible to export your existing tables into an external back-end and this mailing list (note, not the marketing list) might be able to help you with that. The next smart thing about Base is that forms and reports can be, and are best made in Writer or/and (i think) Calc. So normal users who are clueless about databases can read the data in a familiar setting and use familiar tools to format and edit things around the data-fields. The forms and reports inside Base seem to be for data-entry and people who have some clue about databases. However i have never quite got around to getting to grips with all this. So hopefully some of the experts might wade in and set me straight (again) Regards from Tom :) On 15 January 2014 05:57, Vince Radice wrote: > I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 > Build ID: 4.1.4.2-2.fc19 > > Here are some lines of a ls -la command > > -rw---. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb > -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb > -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb > -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb > -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb > -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb > -rw---. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb > -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb > -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb > -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1008.odb > -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1009.odb > -rw---. 1 vince root 0 Dec 13 13:26 GRNew odb_100.odb > -rw---. 1 vince root 0 Dec 13 15:59 GRNew odb_1010.odb > > My database name is GRNew,odb. > I was looking at some of the recent messages that were talking about LO > looping saving backups of untitled documents. It mentioned Calc and Write > as being involved. Could this be related to my problem? > > Thanks, > Vince Radice > > > On 01/14/2014 12:44 PM, Tom Davies wrote: >> >> Hi :) >> On Ubuntu 12.04 i have no files in there. Do the file-names start >> with a ~ or with "lock"? In either of those cases i think you can >> delete the files without worry but it might be worth testing that for >> 1 or 2 files. >> >> Going off on a tangent i do have a non-LibreOffice folder with a load >> of crash reports from when i don't close Xbmc properly and i routinely >> delete all of them from time-to-time. I'm not sure if this is similar >> or not. >> Regards from >> Tom :) >> >> >> On 14 January 2014 04:12, Vince Radice wrote: >>> >>> I am seeing something and I don't know if it is a problem or something I >>> have to live with. >>> >>> In the ~/.config/libreoffice/4/user/backup directory, I have 3,000+ >>> files >>> with 0 bytes. I assume that this means the files are empty. There are >>> other >>> files there which are not empty. The non-empty ones appear to be backups >>> of >>> files I have worked on. The empty files all appear to be attempts to >>> backup >>> a Base database that I have created using the built in hsql engine. The >>> file is stored on my computer. The time stamps on the files are unusual. >>> There are 6 files with a time stamp of 15:58, 6 with 15:59, 6 with 16:00 >>> and >>> the pattern continues for the other 3,500 empty files. >>> >>> Does any one else have the same situation? I have the save/backup time >>> in >>> the general options set to 15 minutes. >>> >>> I have a listing of all of the files if anyone wants to see it. >>> >>> Thank you, >>> Vince Radice >>> >>> -- >>> 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 >>> > --