New Import/Export Feature???

texasmame · 04-28-2018, 06:59 PM

Okay. I exported my free agents to the .txt file then tried to import them to my first year player draft pool. It says it worked but none of them showed up. Also tried vice-versa (draft pool guys to free agents - no go).

Isn't that what this is supposed to do? What am I missing here?

endgame · 04-28-2018, 07:05 PM

The way I had to make it work- trial and error -was to do the export, then open Excel, select Import from Other (something like that), select text, and locate the file. Then it went through the typical delimited choices, mostly default I think, then finished. Done. There it is.

mitchkenn · 04-28-2018, 08:04 PM

Quote:

Originally Posted by texasmame

Okay. I exported my free agents to the .txt file then tried to import them to my first year player draft pool. It says it worked but none of them showed up. Also tried vice-versa (draft pool guys to free agents - no go).

Isn't that what this is supposed to do? What am I missing here?

don't know about that feature, but you could have had a Free Agent Draft, of all the free agents by merely selecting that feature from the league settings > functions (on left side under Functions first grey header "Schedule Free Agent Draft."

i never knew about this until it was pointed out to me last year. Might not be what you were after, but thought i'd point it out in case it might be.

texasmame · 04-28-2018, 08:15 PM

Quote:

Originally Posted by endgame

The way I had to make it work- trial and error -was to do the export, then open Excel, select Import from Other (something like that), select text, and locate the file. Then it went through the typical delimited choices, mostly default I think, then finished. Done. There it is.

Hmm. . . that doesn't seem to get them in to the draft pool. If I edit the draft pool .txt file (for example, change A.J. Happ to CRAPPPP) then reimport - it works. A.J. CRAPPPP is now there.

If I take an entry from the free agent.txt and add it to the draft pool.txt file, then reimport, it does not add that additional player.

Ugh.

endgame · 04-28-2018, 08:36 PM

I don’t think you can cross txt files like that. I could be wrong. They’d need their status or eligibility changed or the sort.

texasmame · 04-28-2018, 08:59 PM

Quote:

Originally Posted by endgame

I don’t think you can cross txt files like that. I could be wrong. They’d need their status or eligibility changed or the sort.

Bummer. My 1st year draft is today. Guess I'll just have to do the free agent draft after that instead of putting them in on the first year list.

NoOne · 04-29-2018, 04:10 AM

is that a column header? eligibiity? if so could mass edit it for all in the export.

second option:

shortlist all the FA you intend to add -- for later use.

allow pool to be created -- make sure its #'s exceeds or matches the # of FA you want to add. (we intend to re-use their playerID's)

export playrs (includes the FA) as well as teh draft pool.

paste over all the columns Except player id from just the FA poriton of the exported draft players.

you have basically replaced those new playerid's with their ratings/names and such -- if there is a column realting to eligibility, you won't be doing this anyway.. but make sure there isn't one first before pasting.

now, since they are duplicated and part of the draft pool, delete the entire shortlist of FA. any excess non-FA leftover in draft pool would need to be taken care of too. sorting before pasting could help you do this in a quick and easy manner too. oh, just change all first names to "z" or something -- easy to select/delete a large group in game that way. (anything that can be filtred, paste somethign unique in exported file to find them in game after import). do not just delete rows from exported draft class.. that will almost assuredly cause problems in teh database.

obviously, use a restored backup to test this. don't screw up your league wihtout knowing it will work 100% as intended.

one thing that used to be a potentially bad thing about the FA draft function -- when i tried one it always included the draft class... maybe that was nly with "real" players, but it would cause a huge pool of additional talent i ddin't intend to have in the draft. just one more reason to kick it around in a restored, throw-away league in case it gets f'd in the a, so to speak..

texasmame · 04-30-2018, 09:16 AM

Quote:

Originally Posted by NoOne

obviously, use a restored backup to test this. don't screw up your league wihtout knowing it will work 100% as intended.

Yeah, was worried about botching the league, so I just went ahead and did two separate drafts. All went as intended.

04-28-2018, 06:59 PM	#1
texasmame All Star Starter Join Date: Apr 2007 Location: Planet Texas Posts: 1,631	New Import/Export Feature??? Okay. I exported my free agents to the .txt file then tried to import them to my first year player draft pool. It says it worked but none of them showed up. Also tried vice-versa (draft pool guys to free agents - no go). Isn't that what this is supposed to do? What am I missing here? __________________ Managing and rebuilding the 100-loss BURBANK BLACK BARONS. 1st Place (40-18) as of June 1st. 10 game lead in the AL Central.

04-28-2018, 07:05 PM	#2
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	The way I had to make it work- trial and error -was to do the export, then open Excel, select Import from Other (something like that), select text, and locate the file. Then it went through the typical delimited choices, mostly default I think, then finished. Done. There it is. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

04-28-2018, 08:36 PM	#5
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	I don’t think you can cross txt files like that. I could be wrong. They’d need their status or eligibility changed or the sort. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

04-29-2018, 04:10 AM	#7
NoOne Hall Of Famer Join Date: Apr 2015 Posts: 7,228	is that a column header? eligibiity? if so could mass edit it for all in the export. second option: shortlist all the FA you intend to add -- for later use. allow pool to be created -- make sure its #'s exceeds or matches the # of FA you want to add. (we intend to re-use their playerID's) export playrs (includes the FA) as well as teh draft pool. paste over all the columns Except player id from just the FA poriton of the exported draft players. you have basically replaced those new playerid's with their ratings/names and such -- if there is a column realting to eligibility, you won't be doing this anyway.. but make sure there isn't one first before pasting. now, since they are duplicated and part of the draft pool, delete the entire shortlist of FA. any excess non-FA leftover in draft pool would need to be taken care of too. sorting before pasting could help you do this in a quick and easy manner too. oh, just change all first names to "z" or something -- easy to select/delete a large group in game that way. (anything that can be filtred, paste somethign unique in exported file to find them in game after import). do not just delete rows from exported draft class.. that will almost assuredly cause problems in teh database. obviously, use a restored backup to test this. don't screw up your league wihtout knowing it will work 100% as intended. one thing that used to be a potentially bad thing about the FA draft function -- when i tried one it always included the draft class... maybe that was nly with "real" players, but it would cause a huge pool of additional talent i ddin't intend to have in the draft. just one more reason to kick it around in a restored, throw-away league in case it gets f'd in the a, so to speak.. Last edited by NoOne; 04-29-2018 at 04:18 AM.