Home | Webstore
Latest News: OOTP 13 THIRD Update Available: Version 13.3.9! - OOTP 13 Released! Download Now! - iOOTP 2012 Available NOW on the AppStore - Title Bout Championship Boxing 2.5 released!

Download OOTP 13 Now! | Download iOOTP 2012 from the AppStore

Go Back   OOTP Developments Forums > Out of the Park Baseball 13 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools Display Modes
Old 07-18-2011, 04:19 PM   #1 (permalink)
Minors (Triple A)
 
hank9481's Avatar
 
Join Date: Jun 2002
Posts: 277
Thanks: 0
Thanked 2x in 2 posts
Headers on CSV Export

Has anyone noticed on the exported .csv files there's no header row to tell you what the #'s indicate? My row 1 is the actual first entry i.e. player id #1. This seems like a problem.
__________________
HH
www.mblsim.com
hank9481 is online now   Reply With Quote
Old 07-31-2011, 04:06 PM   #2 (permalink)
Minors (Single A)
 
Join Date: Dec 2001
Posts: 82
Thanks: 3
Thanked 7x in 5 posts
Yes - this happens for the mysql and access dumps as well. In ootp11 there were drop table and create table statements for the sql tables before the insert statements - now we just get insert statements with no clue what fields they are inserting into or what the data means! This is a huge problem and renders the sql dumps meaningless gibberish!

EDIT: Here is the support ticket number on this issue: JRG-133795

Last edited by landru; 07-31-2011 at 04:23 PM. Reason: Added support ticket
landru is offline   Reply With Quote
Old 08-08-2011, 04:51 PM   #3 (permalink)
Minors (Single A)
 
Join Date: Dec 2001
Posts: 82
Thanks: 3
Thanked 7x in 5 posts
Quote:
Originally Posted by landru View Post
Yes - this happens for the mysql and access dumps as well. In ootp11 there were drop table and create table statements for the sql tables before the insert statements - now we just get insert statements with no clue what fields they are inserting into or what the data means! This is a huge problem and renders the sql dumps meaningless gibberish!

EDIT: Here is the support ticket number on this issue: JRG-133795
This has been fixed in 12.3.22 - in the Configure SQL Dump (or the other corresponding Configure options for Access and CSV) there are now options for checking CREATE TABLE and DROP TABLE statements and they are "on" by default.
landru is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 02:36 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments