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. The pop up regarding links no longer appeared. 2udad wrote: Edit: This paragraph removed but it might indicate that the problem below was prior to updating to 2.3.1. When "Find and Replace" did not find any more instances of "file" in forumulas, I saved and re-opened the sheet. 'file///c:documents/myusername/example.ods'B62Īnd I removed the file reference within the single quotes to leave (which then refer to the current sheet) EXAMPLE: the search found the formula: In the "Find:" text I typed in "file" (without the quotations).īy clicking on "Find Next" I was able to step through the sheet, finding each cell that had a formula with the text string "file" in it (which represents a link to another file), and removed the complete link to the other file, typically only leaving the actual cell references. Used Find and Replace, I changed the options to look in "Formulas", and to look at "All sheets" in the book. If the database has no cached tables, the. All these files are essential and should never be deleted. backup file is a zipped backup of the last known consistent state of the data file. data file contains the data for cached tables and the. Search Solved Lost database table and queries. How can I find cells in my spreadsheet that have formulas linked to other files, so I can change the contents of THOSE cells so that they no longer link to other files?įollowing snippets of the conversation here, I tried this: log file contains recent changes to the database. User community support forum for Apache OpenOffice, LibreOffice and all the derivatives. I came to this page looking how to get rid of that pop up - that is: The spreadsheet I was opening was copied from another one, but each spreadsheet should stand on its own. So it seems that there is a hidden sheet in my file.Įvery time I opened up a Calc Sheet I had copied, I received the same pop up "This file contains links to other files. fods file, so searching through the xml source is something I can do I found. So: how do I find and remove the alleged external links.ĮDIT: I am using a. Searching for ///, ://, *.*s did not return any results.My OO base seems in 'half' read-only mode. OO objects: I can create select queries but no forms. This new table is visible in MS-Access, where I can add & modify records. So I created a new table in OO (with primary key ) Can not add records neither. (Edited, had erroneous External > Links before.) The data of the tables is visble, however can not be modified. The only hints I found were on the LibreOffice Forums: īased on these hints, I investigated and found out the following: Search Tips to avoid BASE Crashes with data loss. Unanswered topics Active topics Search FAQ Login Register Board index. (I assume this issue is not specific to LibreOffice, but also present in OpenOffice.) User community support forum for Apache OpenOffice, LibreOffice and all the derivatives. I did not add external links myself, but did copy data from another Calc window at one point, after which this issue started. Base is a fully featured desktop database management system, designed to meet the needs of a broad array of users, from tracking a personal CD collections, to producing a corporate monthly departmental sales reports. System: OO 2.3 (could change to 2.4 if it would help) on Win XP machine.I have a LibreOffice Calc spreadsheet which pops up a message asking me whether I wish to update external links. 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. 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. 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. 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 |