1/18/2024 0 Comments Openoffice base table loses data![]() 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. Obviously I had saved the file on closure. 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. 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. I then edited the table to change the new ID field to “AutoValue” is YES.I had a really nasty problem with Impress the other day which I am able to recreate with a particular presentation file.In order to see which fields needed a larger length, I inserted columns in the Calc spreadsheet source with the formula =LEN(cell) Does anyone know? [!!! UPDATE: My data was NOT all there because a few of the records contained fields with more characters than defined in the Base table. Value too long in statement īecause my data is there, I’m not sure whether I still need to adjust something in order to avoid any problems in the future. Although it appears that all my data copied over, I still got the following Warning message:.The table was created… but now I have a few followup questions: I received a message that asked whether a Primary Key should be created now? I chose “YES,” despite the fact that I already had a field for the Primary Key. – Left all the remaining fields at the default Text [VARCHAR} type. – Changed a few numeric fields to the Number field type. – Changed a few numeric fields to the Tiny Integer field because they are whole numbers that will not be used in calculations. – Changed a field that contains a lot of text to Memo field type. – Changed a few Foreign Key IDs to the Integer field type. – Changed many fields to the Yes/No Boolean type. – Changed the ID field to Integer type… Entry Required. ![]() In the Type Formatting window, I made the following changes: I moved all the Existing Columns to the right column. In the “Tables” pane of Base, I right-clicked to PASTE the clipboard contents (that I copied from the Calc export).įrom the “Copy Table” option, I chose “Definitions and Data”, and “Use first line as column names.” NEXT > I copied all the records (rows & columns) in the Calc spreadsheet. Because of everyone’s comments, I switched to the internal database HSQLDB (instead of the default Firebird). I then created a new database in LibreOffice Base. (The original Access table contains 55 fields that already includes a unique ID, many Yes/No Boolean fields, some short text, a few integer fields, and one really long text Memo field.) I exported one of the tables in my original MS Access database to a Calc spreadsheet. The exact steps I took, and the error message I received, is as follows: I did make some progress, but still have a few questions. Create backups often.Īfter reading everyone’s comments, I tried the import again. odb-file and is unpacked on opening/repacked on closing. In case of HSQL-embedded the data resides inside the. This is done not by the database, but by the admin - usually YOU. Last point: Safety of your data is maintained by having backups, versioned backusps and external backups. In most cases you should see this inconvenient ways as features to ensure integrity of your data. Then you have to remove the relation first, make your changes and re-create the relation. If your columns are part of relations you may face situations where you can not delete columns at all, because they are required in the other table. You should check before deleting anything, if your conversion was flawless. After this is done you can delete the original column and rename the new one to the old name. If you dont wish to loose data YOU need to make precautions: Instead of delete and recreate you could create an additional column with new type and transfer all data in the new column. LibreOffice installs 2 database systems, you will at the moment usually deal with a embedded HSQL V1.8 as default, but Firebird is also possible to use (and it may be noted the default bilbliography is actually dBase) Other stuff may need other solutions, for example an ALTER TABLE statement in the SQL-Window. What can be done is limited to the elements Base AND database can handle in a common language. It is some kind of GUI to handle a database. The main concept to absorb is: Base is no database, it connects to databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |