On 8/31/06, Ocke Janssen <[EMAIL PROTECTED]> wrote:
Hi Don, > > I did manage to successfully use the paste operation to re-create > tbl_BizContact - with all the data intact. The actual number of > records is > 650. However, when I attempt to re-create tbl_Survey2006, I can only get > 315 records into the table successfully, using the paste operation to > create > the table. #316 - #360 are dropped. Copying the remaining data from > Calc > and using Paste --> Append Data in Base doesn't add even one new > record to > the table. > > My question now is, how to get the rest of the data into the table > quickly? Did you try to use the paste special from the menu Edit->Paste Special? Normally the html format is used, you could try the rtf format. May be this works. Nether the less please submit an issue for this perhaps you could attach some sample data to reproduce it.
O.k., I took a day off from working on this issue. Last night (at work), copied the survey data into a fresh (blank) database. It worked. Then (at home)I tried copying the contact data into the new database, and got more crashes. So I then tried copying the table I successfully created in the old copy of the DB into the new one, and that worked. Then I was able to create a relationship between the two tables. Woohoo!
I am facing a major issue in that, frequently, attempts to copy data > in Calc > (for pasting into Base) lead to OpenOffice.org (2.0.3) freezing up on me. > I'll copy the data, and then attempt to switch from the Calc window to > the > Base window. Nothing happens, although I can minimize/maximize the Calc > window. With Calc minimized, Base is just a white screen. I can use > other > apps as well, though I have tried this without any other apps open. I > have > also experienced issues where OOo just shuts down suddenly, and asks if I > want to restart it automatically. These things happen whether using > Ubunt > Dapper (1.2GHz/256MB RAM laptop) or Windows (3GHz/504MB RAM workstation). > I'm willing to say it's crashed 20 times today, altogether. And of course you send all crash reports :-) By the way one crash report you send is already fixed in the cws dba205b < http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Id=4158&Path=SRC680%2Fdba205b > :-) >
Ocke, thanks for this. I didn't get to see it, as it expired before I looked at it, but I'll take your word for it. As a test, I created a blank db this evening at work, and then attempted the copy/paste operation using only 25 records. I still got some crashing, but it was successful. I created the contact table, suffered a crash when copying the data for the survey table, and then succeeded after re-launching OOo. That leads me to a question. How much of my problem could be memory-related? At first, I thought that RAM - or at least the amount of data I was working with - might be a (or the) key factor. Now I am not so sure, since the operation fails regardless of the amount of data I work with. Any thoughts?
