[libreoffice-users] Base scenario
Hi All Some advice and comments please. I'm running a MySQL Database (5.1.55) with Base as the Front-End (3.6.2.2) on PCLinuxOS (2012). I have a Membership Database and have added a SubForm to show all the eMails sent and received from each Member. The eMails are all in a separate Table. On my Main Membership Form I have added a button to bring-up the eMail SubForm. (I have this part working!) But what I see as the best way to do the last step is to add a ListBox named Find Member to the SubForm and this will read from a Query holding the concatanated First Name and Surname of each Member and that Member's ID Key. Once these are inserted into the SubForm it will extract all the relative eMails, sort them into date order and display them. So - Questions and Advice please on the following... * Is this the right way to approach this requirement? * Will the Query update automatically each time it is called so as to pick-up new eMails? * How do I make the ListBox 'read' the results of the Query? * How do I make these results automatically insert into their respective fields on the SubForm? * How do I make the SubForm do the sort as a final step? (Maybe a 'Sort' Button??) Any help, suggestions or comments would be greatly appreciated!! IanW Pretoria RSA. -- 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] FDF forms
Is there a guide somewhere to making FDF forms with Writer ? I know how to export a document to an FDF but how do I add editable fields to the document. ( is this actually possible ) Ta M -- 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] Apache user can't run libreoffice --headless
Hi :) Do you have LO's or AOO's Quickstarter running? Can you see it when you check what processes are running? Sry, i don't know what to grep to look for it but something like ps aux | grep ??? with the question marks replaced by something useful, perhaps soffice? Errr, i am assuming a GnuLinux system due to the L in Lamp, otherwise i guess you would have said Wamp or something right? Regards from Tom :) From: Bobby kneisel bobby.knei...@ktechsolutionsllc.com To: users@global.libreoffice.org Sent: Tuesday, 18 December 2012, 7:03 Subject: [libreoffice-users] Apache user can't run libreoffice --headless I am stumped on something and hoping you all can help. I have need for a LAMP server to print directly from a webpage without the dialog box. So I installed CUPS and mapped the printers. I am printing .docx files so I was using the libreoffice --headless command to print using a shell script. Everything was working great until today. All of a sudden clicking the button to kick off the script failed, and after much troubleshooting, I have traced the issue back to the apache user having an issue running libreoffice --headless I used it at the CLI and it returns to a new line with no error, but no job gets submitted to CUPS. If I re-direct output to a file, all I get is a blank file commands I am using are: libreoffice --headless -pt PrinterQueue FileName or libreoffice --headless -pt PrinterQueue FileName testfile I have double-checked the PATH variable as well to make sure that was ok and it is. Any ideas? -- 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
Re: [libreoffice-users] Apache user can't run libreoffice --headless
Thanks for your reply. I looked at all the results of ps -aux last night and didn't see any service that would affect it. I solved the issue earlier today. Long story short, libreoffice needs a directory to write a temp file to and it writes to whatever is in $HOME so I needed to put export HOME=/apache/writable/ directory and that solved it. Bobby Kneisel Owner KTech Solutions bobby.knei...@ktechsolutionsllc.com 614.398.0999 On Tue, Dec 18, 2012 at 12:02 PM, Tom Davies tomdavie...@yahoo.co.ukwrote: Hi :) Do you have LO's or AOO's Quickstarter running? Can you see it when you check what processes are running? Sry, i don't know what to grep to look for it but something like ps aux | grep ??? with the question marks replaced by something useful, perhaps soffice? Errr, i am assuming a GnuLinux system due to the L in Lamp, otherwise i guess you would have said Wamp or something right? Regards from Tom :) -- *From:* Bobby kneisel bobby.knei...@ktechsolutionsllc.com *To:* users@global.libreoffice.org *Sent:* Tuesday, 18 December 2012, 7:03 *Subject:* [libreoffice-users] Apache user can't run libreoffice --headless I am stumped on something and hoping you all can help. I have need for a LAMP server to print directly from a webpage without the dialog box. So I installed CUPS and mapped the printers. I am printing .docx files so I was using the libreoffice --headless command to print using a shell script. Everything was working great until today. All of a sudden clicking the button to kick off the script failed, and after much troubleshooting, I have traced the issue back to the apache user having an issue running libreoffice --headless I used it at the CLI and it returns to a new line with no error, but no job gets submitted to CUPS. If I re-direct output to a file, all I get is a blank file commands I am using are: libreoffice --headless -pt PrinterQueue FileName or libreoffice --headless -pt PrinterQueue FileName testfile I have double-checked the PATH variable as well to make sure that was ok and it is. Any ideas? -- 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
[Solved] Re: [libreoffice-users] Apache user can't run libreoffice --headless
Hi :) Brilliant! Nicely solved :) Also thanks for letting this list know how you solved it. It's a bit over my head tbh but i'm sure there are plenty on the list that will understand it. Many thanks and regards from Tom :) From: Bobby kneisel bobby.knei...@ktechsolutionsllc.com To: Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, 18 December 2012, 17:06 Subject: Re: [libreoffice-users] Apache user can't run libreoffice --headless Thanks for your reply. I looked at all the results of ps -aux last night and didn't see any service that would affect it. I solved the issue earlier today. Long story short, libreoffice needs a directory to write a temp file to and it writes to whatever is in $HOME so I needed to put export HOME=/apache/writable/ directory and that solved it. Bobby Kneisel Owner KTech Solutions bobby.knei...@ktechsolutionsllc.com 614.398.0999 On Tue, Dec 18, 2012 at 12:02 PM, Tom Davies tomdavie...@yahoo.co.ukwrote: Hi :) Do you have LO's or AOO's Quickstarter running? Can you see it when you check what processes are running? Sry, i don't know what to grep to look for it but something like ps aux | grep ??? with the question marks replaced by something useful, perhaps soffice? Errr, i am assuming a GnuLinux system due to the L in Lamp, otherwise i guess you would have said Wamp or something right? Regards from Tom :) -- *From:* Bobby kneisel bobby.knei...@ktechsolutionsllc.com *To:* users@global.libreoffice.org *Sent:* Tuesday, 18 December 2012, 7:03 *Subject:* [libreoffice-users] Apache user can't run libreoffice --headless I am stumped on something and hoping you all can help. I have need for a LAMP server to print directly from a webpage without the dialog box. So I installed CUPS and mapped the printers. I am printing .docx files so I was using the libreoffice --headless command to print using a shell script. Everything was working great until today. All of a sudden clicking the button to kick off the script failed, and after much troubleshooting, I have traced the issue back to the apache user having an issue running libreoffice --headless I used it at the CLI and it returns to a new line with no error, but no job gets submitted to CUPS. If I re-direct output to a file, all I get is a blank file commands I am using are: libreoffice --headless -pt PrinterQueue FileName or libreoffice --headless -pt PrinterQueue FileName testfile I have double-checked the PATH variable as well to make sure that was ok and it is. Any ideas? -- 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 -- 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] FDF forms
If FDF means editable PDF, then it should be enough to put widgets from the form toolbar into a writer document. Then export it in PDF. Hope to have understood and given a correct answer. Il giorno 18/dic/2012 14:57, Malcolm Moore st-malcolm.mo...@whsg.info ha scritto: Is there a guide somewhere to making FDF forms with Writer ? I know how to export a document to an FDF but how do I add editable fields to the document. ( is this actually possible ) Ta M -- 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
Re: [libreoffice-users] FDF forms
Yes, many thanks Mal _ From: Gabriele Ponzo [mailto:gpo...@gmail.com] To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] Cc: users@global.libreoffice.org Sent: Tue, 18 Dec 2012 17:16:03 + Subject: Re: [libreoffice-users] FDF forms If FDF means editable PDF, then it should be enough to put widgets from the form toolbar into a writer document. Then export it in PDF. Hope to have understood and given a correct answer. Il giorno 18/dic/2012 14:57, Malcolm Moore st-malcolm.mo...@whsg.info ha scritto: Is there a guide somewhere to making FDF forms with Writer ? I know how to export a document to an FDF but how do I add editable fields to the document. ( is this actually possible ) Ta M -- 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 -- 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] ApacheOpenOffice and LibrOffice migration and sharing acor_en-US.dat
Hi, I am a long term user of ApacheOpenOffice but want to use both AOO (I presume that's the abbrv.) and I have customized things from colors to toolbars in AOO, and over the years my acor_en-US.dat has also grown a lot. Therefore I would like to know, #1. Can I copy the whole user folder from AOO to LO, or at least the wordbook and config folders? If not how about acor_en-US.dat, and the files for the toolbars and the colors (the OptionsOpenOffice.orgColors)? But which files are for the toolbars and the colors? 2. Can I go into Paths and change the defaults for AutoCor and AutoText so that both AOO and LO share the same ones? I do use both Word Pros concurrently, but would not be writing to these files at the same time. 3. What purpose does adding another path (in Options) for AutoCor and AutoText actually serve? I have asked about sharing the AutoCor and AutoText files on OOo forum a while back, but no one really gave an answer, and I do not want to corrupt them. I have merged them in the past however. Thanks for any help and may God bless. -- View this message in context: http://nabble.documentfoundation.org/ApacheOpenOffice-and-LibrOffice-migration-and-sharing-acor-en-US-dat-tp4025019.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
Re: [libreoffice-users] ApacheOpenOffice and LibrOffice migration and sharing acor_en-US.dat
Hi :) Yes, you can copypaste the AOO User Profile to the location used by LO. Then when you install or upgrade LO it picks-up the copy and uses that. If you already have LO installed then it still picks up the copy but there might be some things missing or set-up 'wrongly' (for LO). Doing an install of LO just after doing the copy helps give LO the chance to set things straight. There are possibly potential problems with just changing the paths in Tools - Paths so that AOO and LO share a single profile. I suggested it a couple of weeks ago and got a lot of people pointing out that it could create problems. I would be tempted to create regular back-ups of the single profile and just see what kind of errors occur, but i have the advantage of saving regularly to a network where all my files are regularly backed-up without me having to do anything. I think it would be a bad idea for most people. Regards from Tom :) From: PeaceByJesus saved2se...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, 18 December 2012, 20:00 Subject: [libreoffice-users] ApacheOpenOffice and LibrOffice migration and sharing acor_en-US.dat Hi, I am a long term user of ApacheOpenOffice but want to use both AOO (I presume that's the abbrv.) and I have customized things from colors to toolbars in AOO, and over the years my acor_en-US.dat has also grown a lot. Therefore I would like to know, #1. Can I copy the whole user folder from AOO to LO, or at least the wordbook and config folders? If not how about acor_en-US.dat, and the files for the toolbars and the colors (the OptionsOpenOffice.orgColors)? But which files are for the toolbars and the colors? 2. Can I go into Paths and change the defaults for AutoCor and AutoText so that both AOO and LO share the same ones? I do use both Word Pros concurrently, but would not be writing to these files at the same time. 3. What purpose does adding another path (in Options) for AutoCor and AutoText actually serve? I have asked about sharing the AutoCor and AutoText files on OOo forum a while back, but no one really gave an answer, and I do not want to corrupt them. I have merged them in the past however. Thanks for any help and may God bless. -- View this message in context: http://nabble.documentfoundation.org/ApacheOpenOffice-and-LibrOffice-migration-and-sharing-acor-en-US-dat-tp4025019.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
Re: Fwd: Re: [libreoffice-users] Value '0000-00-00' can not be represented as java.sql.Date
Jay, You have a good idea which I think I should be able to incorporate. The syntax that worked for me is - UPDATE table_name SET `column_id`=NULL WHERE `column_id` = '-00-00'; Thanks for the suggestion! David ... On 12/17/2012 7:16 PM, Jay Lozier wrote: On 12/17/2012 05:35 PM, receiver wrote: Girvin's reasoning about dates is quite correct in my opinion. In our case the zero valued date fields are logically NULLs and I would prefer that the database store them as NULLs instead. I'm afraid it is MySQL that is choosing to store zero values. The database in question is being loaded with data extracted from other sources. I can get it in either CSV or TAB separated format which I then load using phpMyAdmin - Import which I believe it utilizing what MySQL refers to as load data infile. Whether I get CSV or TAB separated format there is no data (i.e., they are in my opinion NULLs) supplied for these fields which phpMyAdmin (or possibly MySQL) is choosing to store as (I'd even say convert to) zero values. Therefore, I'm quite happy to have that connector convert these fields (back) to NULL. If there is a way to get MySQL to store NULLs when the imported files contain no data I'd love to know about it. I should point out that in the case of strings (e.g., fields of type VARCHAR) MySQL will store a string of zero length instead of NULL. However, this is much more reasonable than storing an invalid value such as a zero date. David ... I think the problem is with MySQL not the connector. I see this with MySQL also. A possible work around is after the data has been imported to do the following: UPDATE tablename SET datefield IS NULL WHERE datefield = '-00-00' In principle this should work but I have tried on a database with '-00-00' as date nulls. On 12/16/2012 4:48 PM, Girvin R. Herr wrote: David, Playing devil's advocate here, I think there may be an inherent systemic problem with zero dates. Most operating systems count time in seconds, or finer, from an arbitrary date, usually the date the operating system was first released or created. All are in the latter 20th century. Since that date is certainly greater than -00-00 no matter which OS you have, such a date is outside the valid range of dates for the system. Additionally, since days and months start at 1, then a day and/or month of 00 is invalid also. Maybe that is why such a date produces a fatal error, while a null date is fine, since null means the date was never set. Although one may assume so, -00-00 is _not_ null! It would be an interesting exercise to test if the year, month, or day being 0 produces the error. Just my 2-cents. Glad to hear you got it working. Girvin Herr receiver wrote: It works!!! The fact that this rather ugly bit of coding is confined to the .odb file is the good news. It can be out of sight and out of mind for my technically challenged end user community. Many thanks for a pretty useful tip. For the record I'm testing with LO Base 3.6.4, MySQL Connector J 5.1.22, MySQL Server 5.5.16 David ... On 12/15/2012 6:10 PM, Girvin R. Herr wrote: receiver wrote: I'm trying to create a LibreOffice (3.6.4) Base document which utilizes a MySQL database. I have installed the MySQL Connector J (5.1.22) and have good results with one significant exception. The subject error prevents display of a table which does contain dates. I suspect that this may be a problem with the JDBC connector and have reported it here http://forums.mysql.com/read.php?39,576155,576155#msg-576155, however it also seems possible that this is caused by LibreOffice Base. Any advice on what I may have overlooked would be appreciated. David ... -- View this message in context: http://nabble.documentfoundation.org/Value--00-00-can-not-be-represented-as-java-sql-Date-tp4024569.html Sent from the Users mailing list archive at Nabble.com. David, Try this: Edit - Database - Properties Select the Advanced Properties tab. Under Name of the MySQL database, enter: database_name?zeroDateTimeBehavior=convertToNull where database_name is the name of your database. No spaces anywhere. Then click OK. You may have to close and reopen LO/Base for this to take effect. This is the string that LO/Base passes to the MySQL connector to open the database. I had the same problem with zero dates and times when I read about this workaround years ago. I was not sure if it is still a problem with the later versions, but it sounds like it is by your posting. LO 3.5.7.2, MySQL 5.0.67, mysql-connector-java-5.0.7 Hope this helps. Girvin Herr -- View this message in context: http://nabble.documentfoundation.org/Fwd-Re-libreoffice-users-Value--00-00-can-not-be-represented-as-java-sql-Date-tp4024589.html Sent from the Users mailing list archive at Nabble.com. -- View this message in context:
Re: Fwd: Re: [libreoffice-users] Value '0000-00-00' can not be represented as java.sql.Date
On 12/18/2012 05:47 PM, receiver wrote: Jay, You have a good idea which I think I should be able to incorporate. The syntax that worked for me is - UPDATE table_name SET `column_id`=NULL WHERE `column_id` = '-00-00'; Thanks for the suggestion! David ... I thought UPDATE ... SET ... WHERE ... should work. I work with RDMS' quite a lot and done similar global changes. Jay On 12/17/2012 7:16 PM, Jay Lozier wrote: On 12/17/2012 05:35 PM, receiver wrote: Girvin's reasoning about dates is quite correct in my opinion. In our case the zero valued date fields are logically NULLs and I would prefer that the database store them as NULLs instead. I'm afraid it is MySQL that is choosing to store zero values. The database in question is being loaded with data extracted from other sources. I can get it in either CSV or TAB separated format which I then load using phpMyAdmin - Import which I believe it utilizing what MySQL refers to as load data infile. Whether I get CSV or TAB separated format there is no data (i.e., they are in my opinion NULLs) supplied for these fields which phpMyAdmin (or possibly MySQL) is choosing to store as (I'd even say convert to) zero values. Therefore, I'm quite happy to have that connector convert these fields (back) to NULL. If there is a way to get MySQL to store NULLs when the imported files contain no data I'd love to know about it. I should point out that in the case of strings (e.g., fields of type VARCHAR) MySQL will store a string of zero length instead of NULL. However, this is much more reasonable than storing an invalid value such as a zero date. David ... I think the problem is with MySQL not the connector. I see this with MySQL also. A possible work around is after the data has been imported to do the following: UPDATE tablename SET datefield IS NULL WHERE datefield = '-00-00' In principle this should work but I have tried on a database with '-00-00' as date nulls. On 12/16/2012 4:48 PM, Girvin R. Herr wrote: David, Playing devil's advocate here, I think there may be an inherent systemic problem with zero dates. Most operating systems count time in seconds, or finer, from an arbitrary date, usually the date the operating system was first released or created. All are in the latter 20th century. Since that date is certainly greater than -00-00 no matter which OS you have, such a date is outside the valid range of dates for the system. Additionally, since days and months start at 1, then a day and/or month of 00 is invalid also. Maybe that is why such a date produces a fatal error, while a null date is fine, since null means the date was never set. Although one may assume so, -00-00 is _not_ null! It would be an interesting exercise to test if the year, month, or day being 0 produces the error. Just my 2-cents. Glad to hear you got it working. Girvin Herr receiver wrote: It works!!! The fact that this rather ugly bit of coding is confined to the .odb file is the good news. It can be out of sight and out of mind for my technically challenged end user community. Many thanks for a pretty useful tip. For the record I'm testing with LO Base 3.6.4, MySQL Connector J 5.1.22, MySQL Server 5.5.16 David ... On 12/15/2012 6:10 PM, Girvin R. Herr wrote: receiver wrote: I'm trying to create a LibreOffice (3.6.4) Base document which utilizes a MySQL database. I have installed the MySQL Connector J (5.1.22) and have good results with one significant exception. The subject error prevents display of a table which does contain dates. I suspect that this may be a problem with the JDBC connector and have reported it here http://forums.mysql.com/read.php?39,576155,576155#msg-576155, however it also seems possible that this is caused by LibreOffice Base. Any advice on what I may have overlooked would be appreciated. David ... -- View this message in context: http://nabble.documentfoundation.org/Value--00-00-can-not-be-represented-as-java-sql-Date-tp4024569.html Sent from the Users mailing list archive at Nabble.com. David, Try this: Edit - Database - Properties Select the Advanced Properties tab. Under Name of the MySQL database, enter: database_name?zeroDateTimeBehavior=convertToNull where database_name is the name of your database. No spaces anywhere. Then click OK. You may have to close and reopen LO/Base for this to take effect. This is the string that LO/Base passes to the MySQL connector to open the database. I had the same problem with zero dates and times when I read about this workaround years ago. I was not sure if it is still a problem with the later versions, but it sounds like it is by your posting. LO 3.5.7.2, MySQL 5.0.67, mysql-connector-java-5.0.7 Hope this helps. Girvin Herr -- View this message in context: http://nabble.documentfoundation.org/Fwd-Re-libreoffice-users-Value--00-00-can-not-be-represented-as-java-sql-Date-tp4024589.html Sent from the Users mailing list archive at
[libreoffice-users] Re: ApacheOpenOffice and LibrOffice migration and sharing acor_en-US.dat
Tom wrote Hi :) Yes, you can copypaste the AOO User Profile to the location used by LO. Then when you install or upgrade LO it picks-up the copy and uses that There are possibly potential problems with just changing the paths in Tools - Paths so that AOO and LO share a single profile. I suggested it a couple of weeks ago and got a lot of people pointing out that it could create problems. I would be tempted to create regular back-ups of the single profile and just see what kind of errors occur, but i have the advantage of saving regularly to a network where all my files are regularly backed-up without me having to do anything. I think it would be a bad idea for most people. Regards from Tom :) Thanks Tom, that was quick! Backing up could be done automatically, but the issue is keeping both the same. You can merge them but it requires decompression and WinMerge. I would rather they were just regular text files. And what does adding a second path besides the default for AutoCor achieve? Would you also know which files are for the toolbars (the LO one in C:\Users\username\AppData\Roaming\LibreOffice\3\user\config\soffice.cfg\modules\swriter\toolbar (Vista-W/8 path) is empty, unlike in AOO) and colors? I guess there is no chart yet for what all the files in the user folder do, but I might try to make one if I knew! Thanks again. From: PeaceByJesus lt; saved2serve@ gt; To: users@.libreoffice Sent: Tuesday, 18 December 2012, 20:00 Subject: [libreoffice-users] ApacheOpenOffice and LibrOffice migration and sharing acor_en-US.dat Hi, I am a long term user of ApacheOpenOffice but want to use both AOO (I presume that's the abbrv.) and I have customized things from colors to toolbars in AOO, and over the years my acor_en-US.dat has also grown a lot. Therefore I would like to know, #1. Can I copy the whole user folder from AOO to LO, or at least the wordbook and config folders? If not how about acor_en-US.dat, and the files for the toolbars and the colors (the OptionsOpenOffice.orgColors)? But which files are for the toolbars and the colors? 2. Can I go into Paths and change the defaults for AutoCor and AutoText so that both AOO and LO share the same ones? I do use both Word Pros concurrently, but would not be writing to these files at the same time. 3. What purpose does adding another path (in Options) for AutoCor and AutoText actually serve? I have asked about sharing the AutoCor and AutoText files on OOo forum a while back, but no one really gave an answer, and I do not want to corrupt them. I have merged them in the past however. Thanks for any help and may God bless. -- View this message in context: http://nabble.documentfoundation.org/ApacheOpenOffice-and-LibrOffice-migration-and-sharing-acor-en-US-dat-tp4025019.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@.libreoffice 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+help@.libreoffice 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 -- View this message in context: http://nabble.documentfoundation.org/ApacheOpenOffice-and-LibrOffice-migration-and-sharing-acor-en-US-dat-tp4025019p4025056.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
[libreoffice-users] Re: FDF forms
On 12/18/2012 05:56 AM, Malcolm Moore wrote: Is there a guide somewhere to making FDF forms with Writer ? I know how to export a document to an FDF but how do I add editable fields to the document. ( is this actually possible ) 3.4 Writer Guide, Chapter 15: https://www.libreoffice.org/get-help/documentation/ Might also be of help: https://wiki.documentfoundation.org/Faq#Forms http://help.libreoffice.org/Common/Export_as_PDF Don't forget that you can save a PDF that is editable by LO: http://help.libreoffice.org/Common/Export_as_PDF#Embed_OpenDocument_file You can practice with the form included in this tutorial: http://foersom.com/org/HowTo/CreatePdfForm.html -- 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] LO Installation
Good day! When I try to install LibreOffice 3.5 in domen through script (msiexec /i \\test.vz\LOGIN\Install\LibreOffice3.5.msi SELECT_WORD=0 SELECT_EXCEL=0 SELECT_POWERPOINT=0 ADDLOCAL=ALL REMOVE=gm_p_Base,gm_p_Base_Bin,gm_p_Draw,gm_p_Draw_Bin /qn) it changes all file associations on WinXP form MS to LO (Win7 change extension docx, xlsx, pptx), but I don't need it. How can I correct script or installation ? Yet one question: users work in organization with MS and LO. Default extansion for file saving is docx and xlsx. Often happen problems when files created in MO after open and save in LO change formatting. Are expected improved supporting of this format in LO ? -- 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