Added SQLite support to replace /news/txt files. Effects on imported leagues?

Sweed · 03-19-2016, 01:38 AM

Imported my v 16 league into v17 and all of the text histories of my players and current news items and manager mail were not imported.....

-Added SQLite support to replace /news/txt files

Does this new feature mean there is no way to import player histories, news stories, etc. from v16 to v17?

This is a tough pill to swallow on a league I have played out all of the games from v4 to v16. I'll live with it if I have to but wanted to make sure it wasn't something with my import or wasn't something that could be worked around?

endgame · 03-19-2016, 01:39 AM

Think I read something on this earlier, but I'm not positive. Looking. Back at ya in a few.

endgame · 03-19-2016, 01:41 AM

Okay, wee hours are messing with me. This may or may not have anything to do with your situation, but it is the post I was recollecting. If it makes sense to you, then you can make it make sense to me. Ha!

http://www.ootpdevelopments.com/boar...ml#post3999394

And OTOH, can those files just be moved over, copied and pasted? I don't know. After coffee in the morning, I might.

By that time, Markus or Matt will have replied anyway probably. Sure there's an answer. We're not going to lose history, I'm certain.

Sweed · 03-19-2016, 02:13 AM

Thanks endgame for trying to help. The v16 text files did import into the v17 game but are not read\displayed, so...

I did what Markus suggested in the linked post and got a message saying OOTP would convert the text files to the new sql database and if successful would then delete the text files. Got the successful conversion message ant thought "that was easy" only to find the histories still did not display and OOTP deleted the files because the conversion was successful. I do have a backup so no harm done there.

Now I have to wonder if the file converter is not working as intended or is it something particular to my setup? Need to get some sleep so will hopefully wake up to an answer that will get me my player histories readable in v17.

Thanks again.

endgame · 03-19-2016, 02:29 AM

Sure. Now that you've frightened me, sleep well.

Sweed · 03-19-2016, 10:36 AM

I'll be gone shortly for the day but wanted to add to my post and see if I am the only one seeing this?

The v16 text files do move into my v17 save folder, I can navigate to them. Should the game be able to read the old texts until one decides to convert to sql? If so that doesn't work for me as the game can't read the files before or after the sql conversion.

On the news tab the dates of the messages show up but no texts.
The player cards show no text entries at all.

In the data tab is says something like "this game uses text files..." but you can switch to the new sql system by hitting the edit button and the game will transfer your text files to the new system and if successful will delete the old text files. My game says the switch is successful and deletes the files but still no text appears in my game. Yes I have backups.

I have to think this is somewhat isolated or surely there'd be other posts? Not really sure if this is a bug or working as intended and is only hiccuping on my system?

Just looking for input, advice, and hopefully a solution.

Thanks.

endgame · 03-19-2016, 10:45 AM

I'll link this in the Bug Report forum and in our internal PT model for review.

Thanks, Sweed. We have to keep that history intact, friend. You've been at too long.

Andreas Raht · 03-19-2016, 12:22 PM

All is well - there is an import feature for the text data

You'll find it on the Game Settings -> Database Info page. On that page you'll see information about the current mode (if your saved game uses text files or text database). And if your saved game uses text files, you can switch to using the text database. Your text files will be deleted after successful import. If anything goes wrong, the import will stop, all text files will still be there, and the text database will not be activated.

EDIT: If you're running an online league, you should first make sure if your league uses any 3rd party tools and if these tools are compatible with the text database system or if they require text files.

endgame · 03-19-2016, 12:25 PM

Quote:

Originally Posted by Andreas Raht

All is well - there is an import feature for the text data

You'll find it on the Game Settings -> Database Info page. On that page you'll see information about the current mode (if your saved game uses text files or text database). And if your saved game uses text files, you can switch to using the text database. Your text files will be deleted after successful import. If anything goes wrong, the import will stop, all text files will still be there, and the text database will not be activated.

EDIT: If you're running an online league, you should first make sure if your league uses any 3rd party tools and if these tools are compatible with the text database system or if they require text files.

Didn't he say that here, though?

Quote:

Originally Posted by Sweed

In the data tab is says something like "this game uses text files..." but you can switch to the new sql system by hitting the edit button and the game will transfer your text files to the new system and if successful will delete the old text files. My game says the switch is successful and deletes the files but still no text appears in my game. Yes I have backups.

Doesn't sound like that operation did what it should? Am I not reading well? (knock it off, Matt.

)

Habsfan18 · 03-19-2016, 12:29 PM

That's concering, as player histories/news are a huge part of the immersion for me with my fictional league.

I may just play my old file on OOTP 16 rather than import it to 17.

endgame · 03-19-2016, 12:30 PM

Quote:

Originally Posted by Habsfan18

That's concering, as player histories/news are a huge part of the immersion for me with my fictional league.

I may just play my old file on OOTP 16 rather than import it to 17.

I'm sure it'll get sorted out or explained shortly. Be cautious, certainly, but answers always come.

Andreas Raht · 03-19-2016, 12:31 PM

Quote:

Originally Posted by Habsfan18

That's concering, as player histories/news are a huge part of the immersion for me with my fictional league.

I may just play my old file on OOTP 16 rather than import it to 17.

I suggest you import it to OOTP 17 and just don't switch to using the text database. No worries, OOTP will not do it automatically. You'd have to do the switch manually.

Sweed · 03-19-2016, 05:41 PM

Quote:

Originally Posted by endgame

Didn't he say that here, though?

Doesn't sound like that operation did what it should? Am I not reading well? (knock it off, Matt.

)

Home now for just a bit so time for a quick reply...

Yes, I did go through the process that Andreas described. I did get the message the conversion was successful and the text files were deleted. And yet I have not history to look at. I have re-imported the league 4 or 5 times with the same result. I'll try again late tonight (have to leave again shortly) or tomorrow and post a screen shot of the database page and what comes up after transfer.

I still wonder, by the way the instructions are worded, if it is possible to just continue with the original way IE text files instead of sql? Problem is though that even when the text files are in my v17 save folder and I have not touched the edit button to convert I still have blank history. Looking around more I also have no boxscores, or transactions listed. My newspaper is has no text but player photos are still there

My next step tomorrow might be to uninstall and reinstall? Maybe something messed up on install?

Don't worry I won't give up

Sweed · 03-19-2016, 05:45 PM

Quote:

Originally Posted by Habsfan18

That's concering, as player histories/news are a huge part of the immersion for me with my fictional league.

I may just play my old file on OOTP 16 rather than import it to 17.

I think you should import it. It doesn't risk your v16 text files as they are simply imported into v17 but still intact in your v16 folder. Of course make a backup for safety ( I did

)

If you import and have history it means it's on my end. If you import and don't have history than there is one more example to work from to fix the issue.

As for me I'll continue to play my game in v16 until I find the answer for my history problem in v17. I'm pretty sure it will get sorted and hopefully it's something easy like the uninstall\reinstall I'm planning on trying.

endgame · 03-19-2016, 10:23 PM

Waiting out my import right now, Sweed. Report to follow on completion and after a review. :crossfingers:

endgame · 03-19-2016, 10:31 PM

Well, didn't stay too long. 17-year-old league in the offseason and if wandered around too much The Covenant would suck me into the abyss before I was ready for the fall. But the histories all look intact. I just hit the Import function, waited it out, didn't even look at a database setting, went to my lineup (which I haven't looked at, I think since the beta period began......oh, I have some work to do) and opened up a profile. Had everything I was hoping to see; even the retired players had history, so......now to figure out what's up with you. Think I'm going to be ... knock on monitor ... good.

Sweed · 03-19-2016, 11:33 PM

Quote:

Originally Posted by endgame

Well, didn't stay too long. 17-year-old league in the offseason and if wandered around too much The Covenant would suck me into the abyss before I was ready for the fall. But the histories all look intact. I just hit the Import function, waited it out, didn't even look at a database setting, went to my lineup (which I haven't looked at, I think since the beta period began......oh, I have some work to do) and opened up a profile. Had everything I was hoping to see; even the retired players had history, so......now to figure out what's up with you. Think I'm going to be ... knock on monitor ... good.

Thanks endgame. Long day for me so probably tomorrow morning I'll try an uninstall\reinstall and see what happens.

It's just funny the game must be finding the texts when it tries to convert them as they are deleted after the process. But the game can't find them to read them before trying the conversion. I'm mystified

endgame · 03-19-2016, 11:35 PM

Quote:

Originally Posted by Sweed

Thanks endgame. Long day for me so probably tomorrow morning I'll try an uninstall\reinstall and see what happens.

It's just funny the game must be finding the texts when it tries to convert them as they are deleted after the process. But the game can't find them to read them before trying the conversion. I'm mystified

Guessing at least one or more of the boys'll be around tomorrow. If you still strike out after the new build, sure someone'll chime in. Have a good night, friend.

Sweed · 03-20-2016, 12:51 AM

Thanks endgame so much for all of your help. Good news!!!!!!

Uninstall and reinstall has fixed the history issue

I'm tired after a long day but decided there was no way I was going to get to sleep if I didn't at least try before going to bed.

They told us how fast v17 was and my initial imports of my league were being completed in about 5 minutes. I thought wow, this is great. My first import on the reinstalled OOPT17 took a lot longer. Not sure how long didn't think of checking when I started. I do know it had been going for a bit and still took 8 more minutes after I started to keep the time so I would guess ~15 minutes or so. I thought this was a good sign that maybe things were going to work out.

Also my initial import had a couple of graphics quirks IE logos, caps, and unis for my Cubs, the Mets, White Sox, and Yankees were not the real MLB gear. They were all game created. On my first import on the reinstalled v17 all of the teams had their real MLB gear and logos. I thought this was another good sign. Clicked on one of my veteran players, crossed my fingers, and hit the history tab.... It was all there

So, yeah something must have happened during installation that corrupted the game. Or maybe the first installation file I got was corrupted during the original d'load?

I don't know but whatever it was has been sorted and I'm up and running again.

Thanks also to Andreas for taking the time to help.

You have a good weekend endgame, thanks again.

Sweed · 03-20-2016, 10:01 AM

One last update....

So glad to be up and running with v17. Have barely scratched the surface but I can tell this is going to be, easily, the best version yet.

I do want to add, in case others have doubts about going to SQL, that after getting the import to work and being able to read texts I backed up the game and proceeded to try the SQL conversion.

Figured I just as well be "up to speed" with the new technology and it worked flawlessly.

The sky isn't falling, all is well in OOTP'ville, and once again the calm approach to a problem works wonders. Especially with the great community that is the OOTP forums with users, like endgame, that are always helping others and of course the OOTP development team (Andreas in this case) that are also here day in and day out.

03-19-2016, 01:38 AM	#1
Sweed Hall Of Famer Join Date: Apr 2002 Location: Iowa Posts: 6,732	Added SQLite support to replace /news/txt files. Effects on imported leagues? Imported my v 16 league into v17 and all of the text histories of my players and current news items and manager mail were not imported..... -Added SQLite support to replace /news/txt files Does this new feature mean there is no way to import player histories, news stories, etc. from v16 to v17? This is a tough pill to swallow on a league I have played out all of the games from v4 to v16. I'll live with it if I have to but wanted to make sure it wasn't something with my import or wasn't something that could be worked around?

03-19-2016, 01:39 AM	#2
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	Think I read something on this earlier, but I'm not positive. Looking. Back at ya in a few. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-19-2016, 01:41 AM	#3
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	Okay, wee hours are messing with me. This may or may not have anything to do with your situation, but it is the post I was recollecting. If it makes sense to you, then you can make it make sense to me. Ha! http://www.ootpdevelopments.com/boar...ml#post3999394 And OTOH, can those files just be moved over, copied and pasted? I don't know. After coffee in the morning, I might. By that time, Markus or Matt will have replied anyway probably. Sure there's an answer. We're not going to lose history, I'm certain. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________ Last edited by endgame; 03-19-2016 at 01:44 AM.

03-19-2016, 02:29 AM	#5
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	Sure. Now that you've frightened me, sleep well. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-19-2016, 10:45 AM	#7
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	I'll link this in the Bug Report forum and in our internal PT model for review. Thanks, Sweed. We have to keep that history intact, friend. You've been at too long. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-19-2016, 02:13 AM	#4
Sweed Hall Of Famer Join Date: Apr 2002 Location: Iowa Posts: 6,732	Thanks endgame for trying to help. The v16 text files did import into the v17 game but are not read\displayed, so... I did what Markus suggested in the linked post and got a message saying OOTP would convert the text files to the new sql database and if successful would then delete the text files. Got the successful conversion message ant thought "that was easy" only to find the histories still did not display and OOTP deleted the files because the conversion was successful. I do have a backup so no harm done there. Now I have to wonder if the file converter is not working as intended or is it something particular to my setup? Need to get some sleep so will hopefully wake up to an answer that will get me my player histories readable in v17. Thanks again.

03-19-2016, 10:36 AM	#6
Sweed Hall Of Famer Join Date: Apr 2002 Location: Iowa Posts: 6,732	I'll be gone shortly for the day but wanted to add to my post and see if I am the only one seeing this? The v16 text files do move into my v17 save folder, I can navigate to them. Should the game be able to read the old texts until one decides to convert to sql? If so that doesn't work for me as the game can't read the files before or after the sql conversion. On the news tab the dates of the messages show up but no texts. The player cards show no text entries at all. In the data tab is says something like "this game uses text files..." but you can switch to the new sql system by hitting the edit button and the game will transfer your text files to the new system and if successful will delete the old text files. My game says the switch is successful and deletes the files but still no text appears in my game. Yes I have backups. I have to think this is somewhat isolated or surely there'd be other posts? Not really sure if this is a bug or working as intended and is only hiccuping on my system? Just looking for input, advice, and hopefully a solution. Thanks.

03-19-2016, 12:22 PM	#8
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 8,992	All is well - there is an import feature for the text data You'll find it on the Game Settings -> Database Info page. On that page you'll see information about the current mode (if your saved game uses text files or text database). And if your saved game uses text files, you can switch to using the text database. Your text files will be deleted after successful import. If anything goes wrong, the import will stop, all text files will still be there, and the text database will not be activated. EDIT: If you're running an online league, you should first make sure if your league uses any 3rd party tools and if these tools are compatible with the text database system or if they require text files. __________________ Andreas Raht andreas@ootpdevelopments.com Out of the Park Developments Last edited by Andreas Raht; 03-19-2016 at 12:25 PM.

03-19-2016, 12:29 PM	#10
Habsfan18 Hall Of Famer Join Date: Apr 2012 Location: Canada Posts: 2,249	That's concering, as player histories/news are a huge part of the immersion for me with my fictional league. I may just play my old file on OOTP 16 rather than import it to 17.

03-19-2016, 10:23 PM	#15
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	Waiting out my import right now, Sweed. Report to follow on completion and after a review. :crossfingers: __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-19-2016, 10:31 PM	#16
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	Well, didn't stay too long. 17-year-old league in the offseason and if wandered around too much The Covenant would suck me into the abyss before I was ready for the fall. But the histories all look intact. I just hit the Import function, waited it out, didn't even look at a database setting, went to my lineup (which I haven't looked at, I think since the beta period began......oh, I have some work to do) and opened up a profile. Had everything I was hoping to see; even the retired players had history, so......now to figure out what's up with you. Think I'm going to be ... knock on monitor ... good. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-20-2016, 12:51 AM	#19
Sweed Hall Of Famer Join Date: Apr 2002 Location: Iowa Posts: 6,732	Thanks endgame so much for all of your help. Good news!!!!!! Uninstall and reinstall has fixed the history issue I'm tired after a long day but decided there was no way I was going to get to sleep if I didn't at least try before going to bed. They told us how fast v17 was and my initial imports of my league were being completed in about 5 minutes. I thought wow, this is great. My first import on the reinstalled OOPT17 took a lot longer. Not sure how long didn't think of checking when I started. I do know it had been going for a bit and still took 8 more minutes after I started to keep the time so I would guess ~15 minutes or so. I thought this was a good sign that maybe things were going to work out. Also my initial import had a couple of graphics quirks IE logos, caps, and unis for my Cubs, the Mets, White Sox, and Yankees were not the real MLB gear. They were all game created. On my first import on the reinstalled v17 all of the teams had their real MLB gear and logos. I thought this was another good sign. Clicked on one of my veteran players, crossed my fingers, and hit the history tab.... It was all there So, yeah something must have happened during installation that corrupted the game. Or maybe the first installation file I got was corrupted during the original d'load? I don't know but whatever it was has been sorted and I'm up and running again. Thanks also to Andreas for taking the time to help. You have a good weekend endgame, thanks again.

03-20-2016, 10:01 AM	#20
Sweed Hall Of Famer Join Date: Apr 2002 Location: Iowa Posts: 6,732	One last update.... So glad to be up and running with v17. Have barely scratched the surface but I can tell this is going to be, easily, the best version yet. I do want to add, in case others have doubts about going to SQL, that after getting the import to work and being able to read texts I backed up the game and proceeded to try the SQL conversion. Figured I just as well be "up to speed" with the new technology and it worked flawlessly. The sky isn't falling, all is well in OOTP'ville, and once again the calm approach to a problem works wonders. Especially with the great community that is the OOTP forums with users, like endgame, that are always helping others and of course the OOTP development team (Andreas in this case) that are also here day in and day out.