NFBC Message Boards

Several NFBC owners have been asking for an easier way to view all Free Agents in their leagues and one of the suggestions was to add an Export To Excel function. Well, today if you go to the Free Agents New page under Transactions, you will find that Export To Excel button on the right hand side. Enjoy.

Once you open that Excel file, you'll see that all of the players are loaded by position and each position is a separate tab. All categories are right there for you and everything is loaded immediately. In fact, all three sets of stats (Fantasy, Standard and Overview) are displayed on each position's tab. It looks pretty sweet from first glance.

Take a look at it and let us know what you think. Hopefully this again saves you time each week as you manage all of your NFBC teams. Thanks all and good luck.

Awesome.

That is freakin' great!

I am not very good at much, and technology is not on that short list. Getting a message that says "The file you are trying to open is not a valid Excel XML Speadsheet."

You can open the file as text in Excel. Then a bunch of jibberish comes up that is not free agent information. If anyone has any simple tip that might help, it would be much appreciated.

Cocktails and Dreams wrote:I am not very good at much, and technology is not on that short list. Getting a message that says "The file you are trying to open is not a valid Excel XML Speadsheet."

You can open the file as text in Excel. Then a bunch of jibberish comes up that is not free agent information. If anyone has any simple tip that might help, it would be much appreciated.

I get the same message.

I was able to open the file, but the stats were not sortable.
I would guess there is a way to do it, but this file doesn't seem to be a straight forward EXCEL download.

It works fine for me

I saw the export message and got excited and like Chad, not very good at excel (maybe I'll take a class, NOT)

Worked fine for me too. Everything is sortable in excel, just use the sort function.

There is nothing to sort is the problem. Thus the message.

The computer I have tried the function with uses Excel 2007. I get a message saying that the file format is different from what is expected from the extension (*.xls). I can open the file by confirming the source is reliable. When I go to save the file, the default extension on the file I am trying to save is XML 2003. I can convert to XLS, but the cell formats are "General" (i.e. not "Number" or "Custom" as you would expect). I can work with it and it is quasi-sortable, but I guess there are file format issues of varying degrees depending on what version of excel you use.

.

May I suggest an Export to CSV would serve many more people than Export to Excel?


.

We are meeting with IT in the next hour and have sent your posts to them. I'm sure it has something to do with newer Excel files, but we'll definitely figure it out and find a way to make this an easy download for everyone. When it's working for you, it really works nicely and all stats are right there with tabs for each position. It's a nice feature, but now we have to get this accessible for everyone. We're on it.

No problem with the excel feature; I was able to access and sort; great feature

This is very helpful, thank you.

mattjb wrote:This is very helpful, thank you.

Thanks. We do realize that the issue some folks may be having is with older Excel documents on their computers. We are looking at ways to make sure everyone can download this easily, but it's obvious that those who can download these files to Excel are saving time on FAAB. That was the goal.

Greg Ambrosius wrote:
Thanks. We do realize that the issue some folks may be having is with older Excel documents on their computers. We are looking at ways to make sure everyone can download this easily, but it's obvious that those who can download these files to Excel are saving time on FAAB. That was the goal.

I've downloaded the very latest version of Microsoft Excel from the App store and when I try to use it to open the file which downloads from my Export to Excel I get the message: "Excel can't open this workbook"

This should be fixed now and you won't get that error message again. It wasn't popping up because of old Excel documents; I'm not sure exactly why that was popping up. But everyone should be able to use this now without any problems. If you see any issues, let me know, but take advantage of this nice feature. Good luck all and enjoy.

Greg Ambrosius wrote:This should be fixed now and you won't get that error message again. It wasn't popping up because of old Excel documents; I'm not sure exactly why that was popping up. But everyone should be able to use this now without any problems. If you see any issues, let me know, but take advantage of this nice feature. Good luck all and enjoy.

I still can't export to Excel. I get the same problems that Cocktails referenced above.

Red Sox Nation- wrote:

Greg Ambrosius wrote:This should be fixed now and you won't get that error message again. It wasn't popping up because of old Excel documents; I'm not sure exactly why that was popping up. But everyone should be able to use this now without any problems. If you see any issues, let me know, but take advantage of this nice feature. Good luck all and enjoy.

I still can't export to Excel. I get the same problems that Cocktails referenced above.

Shoot me an email Jason with the error message you're getting and any other info. I will send to IT once again. Thanks and sorry.

MS Excel on iOS still won't open it.

OpenOffice reads XLS files but says this is an XML file and just shows the first page of code.

Perhaps raw data rather than a fancy workbook would be helpful to more people than the handful using the correct version of Excel?
Is it possible to ask IT to make it a true XLS file with no XML code in it? I think that's the "gobbledy gook" some people are reporting.

.

This was my fault: During Friday's meeting I was told this was completed and would go live this week. I guess I tuned out the "live next week" part. I'll post when this is live, but it should work for everyone this week.

Okay, now try the Export Free Agent list to Excel. This has been adjusted so that the error message won't occur. Now hopefully everyone should be able to download this.