Shannon, Yeah I went to fix my power port on the laptop with open office installed on it, and worsened the condition of the crack on the case. I now have the laptop torn down waiting on delivery if the LCD left rail, so I can put this thing back together. There has to be access to the file that you backed up. If nit SQL, then I would presume it is an xml or csv, that gets processed and parsed for viewing. I will go read about how the mailing list gets stored.
Sent from my Verizon Wireless 4G LTE Smartphone ----- Reply message ----- From: "Wellington Equine Associates (Shannon)" <shannonwequ...@aol.com> To: <ooo-users@incubator.apache.org>, <j...@terabyte-hosting.com> Subject: having major problem with a database, please help quickly! Date: Mon, Oct 8, 2012 11:00 Hi John, Dave, Maurice and Graham. Thanks to all for trying to help me, but I decided this morning it may be best to just start all over and create a new mailing list database (enabling backup) instead of spending more time trying fix what I messed up. I still think all of my information is somewhere in the original, I just don't know how to find it and get it back. Perhaps a project for me in the future when I am a bit more experienced with Open Office. Again, thank you all. Have a great day! Shannon -----Original Message----- From: John Miller <j...@terabyte-hosting.com> To: ooo-users <ooo-users@incubator.apache.org> Sent: Fri, Oct 5, 2012 6:23 pm Subject: Re: having major problem with a database, please help quickly! On 10/5/2012 5:39 PM, Maurice Howe wrote: > You OOo/AOo guys & gals are really something. A novice user like Shannon > reports that she's in catastrophe mode, and help jumps in from all > directions! So I guess your geek-speak can be forgiven. > > Glad to hear that you suggested TeamViewer, although it might not help this > time. For the free "for private use" version, go to: > http://www.teamviewer.com/en/index.aspx > > Maurice D. Howe > General MacArthur Honor Guard Assn > 616 Lacey Drive > Endwell, NY 13760 > 607-754-0469 > maur...@stny.rr.com > > > > -----Original Message----- > From: j...@terabyte-hosting.com [mailto:j...@terabyte-hosting.com] > Sent: Friday, October 05, 2012 5:01 PM > To: ooo-users@incubator.apache.org > Subject: Re: having major problem with a database, please help quickly! > > Dan, > Sorry to report that I may have given you false hope here. The machine that > has OpenOffice on it, I mucked up the power port, in usual circumstances I > would just install it here on another machine. My issue there is my internet > is on portable WiFi, and I am redlining my allotted monthly usage. > > I will start working on this other machine here directly. And see if I can > get you an answer. > > > > Sent from my Verizon Wireless 4G LTE Smartphone > > ----- Reply message ----- > From: "Wellington Equine Associates (Shannon)" <shannonwequ...@aol.com> > To: <ooo-users@incubator.apache.org> > Subject: having major problem with a database, please help quickly! > Date: Fri, Oct 5, 2012 16:23 > I'll try to answer as best I can. I was in OpenOffice.org Base. I > highlighted my mailing list and then selected edit from the drop down, which > took me into the table design and I made the changes from there. > > > > > So, here is where I become really computer illiterate, how do I find out the > application from incubator? And how do I share the current SQL? I'll > attach a copy of the file if that is helpful. My head is getting completely > done in at this point. > > > > > > John, thank you so much for your patience and willingness to help! > > > > > > > -----Original Message----- > > From: john <j...@terabyte-hosting.com> > > To: ooo-users <ooo-users@incubator.apache.org> > > Sent: Fri, Oct 5, 2012 4:09 pm > > Subject: Re: having major problem with a database, please help quickly! > > > > > > > > > > > > > Yes I suppose it does thank you. Ok now for the other part of the question; > what application are you running from incubator. > > And when the database file was edited what did you use to edit it, I.e.. > deleting the item_I'd on the table, Also can you dropbox or google share the > current SQL file. The current sql file in conjunction with looking at the > original script, I believe I can fix this. > > Sent from my Verizon Wireless 4G LTE Smartphone > > ----- Reply message ----- > From: "Wellington Equine Associates (Shannon)" <shannonwequ...@aol.com> > To: <ooo-users@incubator.apache.org> > Subject: having major problem with a database, please help quickly! > Date: Fri, Oct 5, 2012 15:47 > > > Hi John. > > > I hope this helps. > > OS Name Microsoft Windows XP Professional Version 5.1.2600 Service Pack 3 > Build 2600 OS Manufacturer Microsoft Corporation System Name DELL1 System > Manufacturer BIOSTAR Group System Model GF8100 M2+ TE System Type X86-based > PC Processor x86 Family 15 Model 127 Stepping 2 AuthenticAMD ~2700 Mhz BIOS > Version/Date American Megatrends Inc. 080015, 2/23/2009 SMBIOS Version 2.5 > Windows Directory C:\WINDOWS System Directory C:\WINDOWS\system32 Boot > Device \Device\HarddiskVolume1 Locale United States Hardware Abstraction > Layer Version = "5.1.2600.5512 (xpsp.080413-2111)" > User Name DELL1\Admin > Time Zone Eastern Daylight Time > Total Physical Memory 2,048.00 MB > Available Physical Memory 920.45 MB > Total Virtual Memory 2.00 GB > Available Virtual Memory 1.96 GB > Page File Space 3.60 GB > Page File C:\pagefile.sys > > > > > > -----Original Message----- > From: john <j...@terabyte-hosting.com> > To: ooo-users <ooo-users@incubator.apache.org> > Sent: Fri, Oct 5, 2012 3:16 pm > Subject: Re: having major problem with a database, please help quickly! > > > Ok then hmmm, who installed, and is the winxp running wamp? What is the > database > > platform that you are running on, mssql, mysql, or which. That's what I was > saying, is that I need to know the setup. > > > > Sent from my Verizon Wireless 4G LTE Smartphone > > ----- Reply message ----- > From: "Wellington Equine Associates (Shannon)" <shannonwequ...@aol.com> > To: <ooo-users@incubator.apache.org> > Subject: having major problem with a database, please help quickly! > Date: Fri, Oct 5, 2012 14:46 > > > This may sound dumb, but I don't think there is a server setup. This is > just an > > old Windows XP. We are a very small office, which is why I don't think > there is > > one. > > > > > -----Original Message----- > From: john <j...@terabyte-hosting.com> > To: ooo-users <ooo-users@incubator.apache.org> > Sent: Fri, Oct 5, 2012 2:39 pm > Subject: Re: having major problem with a database, please help quickly! > > > Yeah I presumed you were using phpmyadmin or some other GUI to manage the > database. If not then it would be done on command line. > > I guess you need to explain the server setup, because I am just guessing > its > linux > > Sent from my Verizon Wireless 4G LTE Smartphone > > ----- Reply message ----- > From: "Wellington Equine Associates (Shannon)" <shannonwequ...@aol.com> > To: <ooo-users@incubator.apache.org> > Subject: having major problem with a database, please help quickly! > Date: Fri, Oct 5, 2012 14:24 > > > Hi John. > > > There is a recent backup now, but not from before the problem happened.. As > I > have a little more than basic computer knowledge, what and how do I "dump > the > SQL"? > > > Thanks guys for trying to help. Much appreciated! > Shannon > > > > > -----Original Message----- > From: john <j...@terabyte-hosting.com> > To: ooo-users <ooo-users@incubator.apache.org> > Sent: Fri, Oct 5, 2012 2:18 pm > Subject: Re: having major problem with a database, please help quickly! > > > Stupid question here, ia there no recent backup of the database? > > Also, you can dump the SQL the way it is right now, then in an editor and an > > empty column in the location where the column that got deleted, and just set > the > > > > field to null. > > Back to the database and drop the table, then import your modified SQL file > > Sent from my Verizon Wireless 4G LTE Smartphone > > ----- Reply message ----- > From: "Dan Lewis" <elderdanle...@gmail.com> > To: <ooo-users@incubator.apache.org> > Cc: "Wellington Equine Associates (Shannon)" <shannonwequ...@aol.com> > Subject: having major problem with a database, please help quickly! > Date: Fri, Oct 5, 2012 13:44 > > > On 10/05/2012 01:08 PM, Wellington Equine Associates (Shannon) wrote: >> I think I maybe have a big "fubar" on my hands. And pardon my ignorance > because I don't "speak" computerese. Yesterday I created a Table Mailing > List > database. All was well. Today I needed to add some more people to the > list. > That was fine. Was also able to sort it to keep it alphabetized by last > name. > My problem started when I wanted to change the ID field to automatic. I > think > that it accepted the change, but didn't change when I opened the table > again. I > > > > went back into edit to change it back and somehow I deleted the ID field, > which > to me was not that big of a deal, but it moved all of my information over a > field i.e., my "first name" was now in the Title field and all of the Title > information was gone. So, I went in and renamed the fields to what they > were > now showing. When I went back to look at the table again, the information > had > shifted again and this time the first names were missing. Each change I > made in > > > > the field titles resulted in more missing information. How do I get ALL of > my > info back??? I don't want to have to start all over and I did not have the > backup copy option selected. I have in the meantime chosen it. Please help > > soon! Thank you! >> Shannon > Try this: With Writer open, use the F4 key to open the Data Source > window. You should see a list of databases on the left side including Table > Mailing List. If you see it, click the arrow to its left to reveal > the queries and tables it contains. Click the arrow in front of Tables to > reveal > > > > the tables (there is probably only the one table). Click the table. The > right > side of the Data Source window contains a table with the field names for the > > column headings. In spite of what you wrote, all > of the fields and their data is likely in this table. > This is another possibility: What you did was to change the settings in > Mail Merge. If this is the case and you still have the table > with the data, you probably should Begin mail merge from the beginning > selecting > > > > the fields needed and placing them where you need them. > > --Dan > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org > For additional commands, e-mail: ooo-users-h...@incubator.apache.org > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2013.0.2677 / Virus Database: 2591/5810 - Release Date: 10/04/12 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org > For additional commands, e-mail: ooo-users-h...@incubator.apache.org > > > > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2012.0.2221 / Virus Database: 2441/5311 - Release Date: 10/05/12 > > well i wouldnt know why the non-commercial version wouldnt work, and if not i have other options, such as OpenMeeting and BigBlueButton, but I ran into a snag, the machine i have with openoffice on it, has a busted power port, so i have that taken apart now, trying to get it fixed, and then I will get back with this inquiry. I have a commercial version of TV, but i am on a stupid portable wifi, so speed is like uh not moving. --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional commands, e-mail: ooo-users-h...@incubator.apache.org