![]() If the path starts with 'C:\Program Files (x86)\' the Java version is compatible. is there a process to go through to create a bug report? This problem was really hurting me because I just could not get the text in the tables to save and in the end I had to create a "table effect" by using text boxes which was really tedious. Posts: 31172 Joined: Mon 1:35 am Location: Germany Re: Lost database table and queries by Villeroy Tue 1:49 pm When you select a version in the options dialog, you see the path of the selected version below the list. I had no problem for the first 516 lines but after that as many as a hundred entries have vanished after closing the file. Twice I have lost data from a table in the org.base. Indeed I am sure that OOo 3.0 could not have got released with such a blatantly obvious bug.īeing new to these boards etc. 2udad wrote: Edit: This paragraph removed but it might indicate that the problem below was prior to updating to 2.3.1. In other tests I have done it seems that the text from tables is not always lost. I have got a file that can be used to demonstrate this behaviour. A function is a predefined calculation entered in a cell to help you analyze or manipulate data in a spreadsheet. ![]() It is by far easier to create the exact database table you need with proper field types, field lengths, relations and indices and then paste data into that table appending the data. In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed. Pasting spreadsheets into Base is a mistake because the Base GUI is so badly organized, buggy and cumbersome while spreadsheet data tend to be inconsistent by design. Obviously I had saved the file on closure. Formulas are equations using numbers and variables to get a result. Unanswered topics Active topics Search FAQ Login Register Board index. On several ocasions I have had a problem of data missing from my database, even though I have printed proof (with table ID number and all) of the entry. I then recreated some of the rows in the table, save the file again, closed the presentation and re-opened it and yet again text was missing from the table. press the browse button near 'Classpath' and browse for the. User community support forum for Apache OpenOffice, LibreOffice and all the derivatives. On re-opening the file later in the day I found that some fonts had changed to Times New Roman but more worryingly the table was empty! All the text had disappeared. I saved the presentation without giving it any thought, and because the presentation was important before I shut down my laptop I copied the presentation file (I saved it in ODP format, although the slides I based the presentation on originally came from a PPT) to a USB key. I created a table of 2 columns and several rows and added and formatted text. System: OO 2.3 (could change to 2.4 if it would help) on Win XP machine.I had a really nasty problem with Impress the other day which I am able to recreate with a particular presentation file. I found a lot of posts on OO Forum and OO community forum related to connecting OO to MySQL database, but nothing useful of transferring database from OO to MySQL. But now my purpose is: Form connected with the only one table tbCustomers in the MySQL database. Then a OpenOffice base application connected with the MySQL database. My question is it possible to migrate data from OO directly to MySQL (there is no such an option offered, maybe it coud be done as generic JDBC?), and how to do it. MySQL database with just one table: tbCustomers, with name, phone and address. Toward the bottom of the window is the Field properties pane. Select the sample table you want to use from the drop-down menu. Each table has a list of available fields. Each category contains its own suggested tables from which to choose. Select the the Field named ID, it should be at the top of the list. You have a choice of two categories of suggested tables: Business and Personal. I am not very fond of this idea because I really like how OO works with forms, but simply could not risk more data losses. Right click on the new table and select Edit to open the Table Design dialog. I am MD in small ED, and I do not have enough knowledge of administering databases, nor I have time to spend days looking for information I need or help, and at this moment I am considering moving database file to MS Access (at least I manage to do that). I also tried exporting data as CSV, then importing into the Access, but could not transfer them (single table) into the MySQL, due to the problem in a set-up of MySQL (my guess based on error message). I installed MySQL 5.0, JDBC and ODBC driver and migration kit, but I did not find a way to directly export data form OO to MySQL. Due to the data loses (Emergency department database, running 24 h a day) mentioned in my post regarding the problems with exporting CSV file I have to migrate data from embedded HSQL database to some server, my choice was MySQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |