Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Discussions :

What happened to my DBMan?

Aug 28, 2002, 4:41 PM
joebagodonuts
User (258 posts)
Aug 28, 2002, 4:41 PM
Post #1 of 5
Views: 4085
Shortcut
Quote Reply
What happened to my DBMan?
I got an email stating
Quote:
Hello, On 8/28, I was checking the site listings, and found that my listing says Mr. where my last name should appear. I updated my listing, but it still shows Mr. instead of Williams. Am I diong something wrong.? Please advise.
I checked and sure enuff, all of a suddent I'm getting things like
Quote:
Ms. Watkins 24-Apr-2000 Welch Rachel 2005 Wellman Kevin 1986 Wheeler Smith Susan & Russell 1979 White Jeremy (Chad) and Alana 1992 White Gary & Darlene 1970 Mr. Wiggins 19-Jun-2000 1984 Mr. Wigness 229 Ms. Wike Watkins 24-Jun-2001
What happened?
Webmaster
http://www.izmirhigh.com/index.shtml
Webmaster
http://www.izmirhigh.com/
Aug 28, 2002, 4:49 PM
Watts
Veteran (1141 posts)
Watts's avatar
Aug 28, 2002, 4:49 PM
Post #2 of 5
Views: 3916
Shortcut
Quote Reply
Re: [joebagodonuts] What happened to my DBMan? In reply to
How many records do you have?
How big is your database (in Mb's)?
Have you made any changes? (specifically have you added any fields?)

You may need to pull the whole thing into excel and see where your records started getting messed up and correct by hand.
Aug 28, 2002, 5:36 PM
joebagodonuts
User (258 posts)
Aug 28, 2002, 5:36 PM
Post #3 of 5
Views: 3927
Shortcut
Quote Reply
Re: [Watts] What happened to my DBMan? In reply to
555 records, only 119K of a db. You talking exporting the db as a csv and one by one checking? I use Edit Plus, but need that Perl checker thing I think...
Webmaster
http://www.izmirhigh.com/
Aug 28, 2002, 8:27 PM
LoisC
Veteran / Moderator (3034 posts)
LoisC's avatar
Aug 28, 2002, 8:27 PM
Post #4 of 5
Views: 3916
Shortcut
Quote Reply
Re: [joebagodonuts] What happened to my DBMan? In reply to
You should be able to just open up your database file in excel (if you have that) and check to see that all the fields are aligned correctly.

You can then actually modify the database in Edit Plus so you don't do any further damage.

It does sound like your database has been corrupted, perhaps by a character entered within an entry.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Aug 28, 2002, 8:37 PM
joebagodonuts
User (258 posts)
Aug 28, 2002, 8:37 PM
Post #5 of 5
Views: 3926
Shortcut
Quote Reply
Re: [LoisC] What happened to my DBMan? In reply to
I FOUND IT! I tried the csv way, but it showed as one cell, wasn't 'til I opened it as a *.db in excel, and got the prompt to sort by delimiter that I found my 5th record as 18 Sep.....when it should've been |18 Sep.....

Thx!

JR
Webmaster
http://www.izmirhigh.com/