incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "john@terabyte-hosting.com" <j...@terabyte-hosting.com>
Subject Re: having major problem with a database, please help quickly!
Date Mon, 08 Oct 2012 15:17:10 GMT
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)" <shannonwequine@aol.com>
To: <ooo-users@incubator.apache.org>, <john@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 <john@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
> Maurice@stny.rr.com
>   
>
>
> -----Original Message-----
> From: john@terabyte-hosting.com [mailto:john@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)" <shannonwequine@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 <john@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)" <shannonwequine@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 <john@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)" <shannonwequine@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 <john@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)" <shannonwequine@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 <john@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" <elderdanlewis@gmail.com>
> To: <ooo-users@incubator.apache.org>
> Cc: "Wellington Equine Associates (Shannon)" <shannonwequine@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-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@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-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@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-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message