Possible to delete last Import Stats from OOTP History database?

WSR · 05-14-2004, 12:50 PM

I was trying to update my Career league using OOTP History last night and I screwed up.

I had just finished the second season in my league then used Export 5 to create the .csv files. However, I tried to Import Stats with OOTP History before I created the HTML pages using OOTP 5. I realized my error after OOTP History prompted me for the location of the HTML files, so I hit Cancel and exited the program. After creating the HTML pages, I went back to Import Stats, but during the process I got an error message telling me that I had duplicated fields or data in the database.

Is there a work around to this? Is there a way to reset the career database to delete the second season info that was partially imported? Any help would be appreciated.

IatricSB · 05-14-2004, 01:07 PM

.... always backup the file before importing. It's saved me a couple of times.

gcsii99 · 05-14-2004, 02:37 PM

i would imagine you could use MS Access to open the database (.mdb) file and manually search and delete all the records for that year, of course I have never tried it so I can't guarantee that all the work it would take to do this would be rewarded...

backups are the way to go...

Good Luck

05-14-2004, 12:50 PM	#1
WSR Minors (Triple A) Join Date: Jan 2002 Location: Tarzana, CA Posts: 211	Possible to delete last Import Stats from OOTP History database? I was trying to update my Career league using OOTP History last night and I screwed up. I had just finished the second season in my league then used Export 5 to create the .csv files. However, I tried to Import Stats with OOTP History before I created the HTML pages using OOTP 5. I realized my error after OOTP History prompted me for the location of the HTML files, so I hit Cancel and exited the program. After creating the HTML pages, I went back to Import Stats, but during the process I got an error message telling me that I had duplicated fields or data in the database. Is there a work around to this? Is there a way to reset the career database to delete the second season info that was partially imported? Any help would be appreciated.

05-14-2004, 01:07 PM	#2
IatricSB Hall Of Famer Join Date: Dec 2001 Location: California Posts: 3,493	.... always backup the file before importing. It's saved me a couple of times. __________________ Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body; but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming, "Wow! What a Ride!" Chicago(N) - Boys of Summer Oakland - 20th Century League Bakersfield - Wild Things Brooklyn - QBA Dodge City - NBSL California - ABC Dodger's Senioriest fan on the OOTP Boards

05-14-2004, 02:37 PM	#3
gcsii99 Minors (Triple A) Join Date: Nov 2002 Location: Acworth, GA Posts: 220	i would imagine you could use MS Access to open the database (.mdb) file and manually search and delete all the records for that year, of course I have never tried it so I can't guarantee that all the work it would take to do this would be rewarded... backups are the way to go... Good Luck __________________ Be still Taggert...My mind is a raging torrent, flooded with rivulets of thought, cascading into a waterfall of creative alternatives.