Managing Your tXtFL Database

If you've checked out a tXtFL pre-release, you've probably noticed the new database for storing all the team and player information. We're really excited about the database because it provides a lot more potential for expanding the game. Our last pre-release included a way to keep track of seasons, and we have just added the ability to create new leagues, each with its own rule set.

Of course, a database is only as good as the ability to get data into and out of it. The tools included in tXtFL so far allow you to import player and team information from spreadsheets, but nothing more fancy. Fortunately there's another tool that you can use to access and update the database, from modification of individual player stats to addition of whole new teams and leagues. We'll take you through the setup to hook up with your database and make modifications.

There are a number of ways to access the database, but the way we recommend here is to use OpenOffice.org (OOo). The advantage of OOo is that the same program includes a spreadsheet editor for player and team spreadsheets, and the entire program is completely free (not to mention an awesome alternative to Microsoft Office). OOo runs on every platform on which tXtFL is supported (Windows, Mac, and even Linux).

Here are the steps to access your tXtFL database. It looks long, but once you've completed the steps once, you'll have a file that you can simply double-click to re-access the database.
  1. If you haven't already done so, download and install OpenOffice.org.
  2. Run OOo, open Tools > Options > Java.
  3. Click on Class Path > Add Archive. Select the file derby.jar, found in your tXtFL directory (e.g. Libraries\Documents\tXtFL-2.0.0alpha3-win\derby.jar). Press OK in the Class Path and Options windows. UPDATE: If you're using the Java Web Start download, you can grab the derby.jar file from the Derby website (the lib.zip file should suffice).
  4. Select File > New > Database.
  5. Choose "Connect to an existing database", select JDBC, and press Next.
  6. In the Datasource URL field, enter derby:C:\Users\[username]\.txtfl\FootballDB. Adjust the path to point to the copy of .txtfl\FootballDB on your computer. UPDATE: As of tXtFL 3, the .txtfl folder changed to .txtfl3, so the full path is  derby:C:\Users\[username]\.txtfl3\FootballDB.
  7. In the JDBC driver class field, enter org.apache.derby.jdbc.EmbeddedDriver, and press Next.
  8. Press Next again, as you do not need a username/password.
  9. Save the file with whatever name you like. This file will allow you to access the database without having to enter all of these steps again!
  10. Click on Tables on the left hand side, and start viewing/editing the database as you like.
  11. When you're done, don't forget to completely exit OOo, as tXtFL won't be able to connect to the database while OOo is still connected.
 Now you can tweak your team at will and micromanage every aspect of it...and just create every fancy league with the most exotic rule sets you can think of.

    Comments

    1. Jeff C8:23 AM

      I love the sim. Is there a way to assign a different "plays" table to each team?

      ReplyDelete
    2. Thanks! I haven't added that feature yet but am planning on it. It'd be nice to have a customizable playbook for each team.

      ReplyDelete
    3. Andreas1:57 AM

      Hi, this program is very interesting for a little project I have. However I'm not really so good at computers. Is it possible to get a DB walk through for a mac? All i get is a txtFL.app that seems not to contain a FootballDB. I'm a bit lost.
      Another question also; does the engine account for injuries at all?

      Thanks
      Andreas

      ReplyDelete
    4. Hi Andreas - thanks for asking! The FootballDB folder is created after first launching the game, and you can find it in the .txtfl folder in your home directory. On the Mac it won't show up in Finder because they normally hide the "dot" folders, but if you open a Finder window and then go to the menu entry, "Go > Go to folder...", you can type in ".txtfl", and it'll pop up into the Finder window.

      Regarding injuries, that's another feature I'll need to incorporate. It would certainly add to the sim!

      ReplyDelete
    5. Andreas1:13 PM

      Hi David and thanks for the fast reply, I found the file just where you said it would be. However, as I said I'm not good with computers and certainly not with Apple. Since the derby file is somehow "inside" the txtfl.app itself, I find myself physically hindered to give OO the path. Never mind. I have some mac friends to ask, i don´t expect you to help me with this. I'll just type this to let you know the DB tweaking in combination with a solid football sim is just awesome, and I let you know when I get in, this is gonna fun!

      ReplyDelete
    6. Hi Andreas - glad you found the file! To access the derby.jar file, you can right-click on the app file (eg tXtFL-2.0.0.app, from the .dmg file) and then choose Show Package Contents. From there the derby file can be found in Contents > MacOS > lib.

      If you downloaded the program by Java Web Start, the derby file gets placed somewhere else, but you can actually get it from the Derby site as well!

      ReplyDelete
    7. Happy to see the version 3 release! Unfortunately, I am having trouble with the database.

      I've simulated an entire season, but cannot access the database (or the stats, but that is a different topic)

      I am running Windows7. Downloaded the debry lib to get the derby.jar file.

      I have mapped to the database to C:\(nameofuser)\.txtfl\FootballDB

      However, I see nothing there. seg0 has a dat file and the other folder does as well.

      Something I am missing?

      ReplyDelete
    8. For tXtFL 3 the database is now in the .txtfl3 folder (instead of .txtfl). I'll need to update that in the instructions--thanks for pointing it out!

      I've been planning to make an easier interface for accessing stats once tXtFL 3 was out, so I'll be getting started on that soon. In the meantime, you can find the stats for each player in the Player_Game_Stats table.

      Let me know how it goes!

      ReplyDelete
    9. And actually for automated games, right now it doesn't record player stats (because of the 100,000s of games that might be run), though I could definitely provide an option for that or at least to output to a text file if you're interested.

      ReplyDelete
    10. I would like to output stats. An option to dump it out to a text file would be great!

      Part of what I like to do it write up reports of games based on the stats similar to little blurb I used to see in the newspaper.

      Is there anything I can do to help?

      ReplyDelete
    11. I can certainly add that option. I've been planning to have some sort of preferences pane for choosing and remembering these types of selections.

      It would be awesome to have you involved! Perhaps we could have your write-ups on the blog if you like. Let me know what kinds of things you might be interested in, and we can work it out.

      ReplyDelete
    12. To become an expert sales coordinator, high grades in your sales management course are mandatory. If you’re burdened with assignments, rely on the academic writing help service providers online. They will help you out. Apart from grades, you’ll also need unbeatable skills in client management, proficiency in query software, CRM and database user interface. Choose Myassignmenthelp.com.
      Academic essay writing has been a parameter to judge the merits of the students for a long time. The present time is none the less. In fact, as time is passing by, students are having more and more requirements to write an essay that will be graded. Hence seeking Do my essay online help is on the rise and it will be.

      ReplyDelete
    13. Use Finance assignment help to finish your finance or accounting papers without messing yourself. You will get assured solutions to your numerical questions within your defined date or time.
      Accounting assignment help

      ReplyDelete
    14. To fix the HP printer in error state, you need to work on various aspects. Firstly you need to check for any lose or frayed wire connections. If you find any flaws, then you may replace it with the new one. Also, if you haven't updated the printer driver software, then consider getting the latest release from the HP website. Sometimes the problem occurs because you have connected your computer and printer to different networks, hence ensure to connect to the same local network. Hopefully, all these steps will help you with the HP printer is in error state issue.hp printer in error state

      ReplyDelete
    15. Assignment Help Hong Kong is the best option to complete academic papers without any stress. If you don’t want to degrade your academic performance, make sure to connect with the professional service provider of assignment writing help.
      Assignment Help Online
      Online Assignment Help

      ReplyDelete
    16. We are a certified, reliable, and self-governing third party tech support guide, which is providing unlimited technical support services for canon printer users. We have the technical capability of dealing minor or major technical errors associated to canon printer. If you are experiencing canon printer not printing problem, you can call our experienced printer technicians to get full technical guidance for identifying the major reasons of this technical issue and apply the appropriate technical skills for solving this error. Our canon printer troubleshooting team is ready to provide the specialized technical assistance for solving any technical error within a few seconds.

      ReplyDelete
    17. Wonderful Article, Thanks for Putting This Together! This Is Obviously One Great Post. MyAssignmentHelpAu is Providing Assignment Help in Australia From the Qualified Expert. To Get Authentic Assignments Within Deadlines, Hire Us Today!

      ReplyDelete
    18. sbcglobal email settings is known to be an online area name. They are email addresses gave by SBC interchanges famously known as Southwestern ringer participation. These administrations are presently offered by AT and T. on the off chance that you have a record on it has it is converged with viewpoint and you are attempting to make sense of it. You can essentially check the bit by bit guidelines. Note that to design Sbcglobal account on Outlook you should know the setting of Sbcglobal on the standpoint.

      ReplyDelete
    19. Alright, let’s check why the error Printer driver is unavailable occurred. Basically, there are two common reasons, first – you have not updated your windows to the latest version and second – you are using an outdated version of printer drivers. To update windows, type update in the search bar and click “check for updates”, finally restart your Printer after updating your windows. To update printer driver press “Windows+R” together and type devmgmt.msc, further right-click on your printer name and click uninstall device. Thereafter reinstall the latest drivers from HP website for your particular printer model. And the Printer driver is Unavailable problem solved

      ReplyDelete
    20. Hrsinfrastructure is a top-leading Pre Engineered Building Manufacturers in India, which is offering affordable PEB solutions for all residential and commercial units as per customer’s needs and demands. We specialize in offering the best quality PEB sheets for all your structural requirements in the reasonable prices. Having many years of experience into PEB industry, our trained professionals will provide you the best sheets that meet your needs in the perfect ways. Hrsinfrastructure use the best quality materials in manufacturing the best sheets along with complete safety. Our trained experts are technically experienced to install the sheets quickly and safely. If you look for the affordable PEB sheets, you can book online orders today.

      ReplyDelete
    21. I don’t have the technical capability of resolving common issues associated to Epson printer. I am trying my technical skills or Epson printer troubleshooting solutions for resolving the minor or major technical problems. Therefore, I am looking for technical expert’s help for resolving the issues as soon as possible. Can you suggest me the easy tricks for resolving this technical error?

      ReplyDelete

    22. How to solve Century link emails don't work in Outlook?

      I have created a centurylink email account with the help of centurylink email settings. I have applied all the steps of the settings in the right ways, so I have successfully configured the centurylink email account. Now, I want to open my CenturyLink emails in outlook, but my centurylink email account does not provide IMAP. So I can’t access my emails in MS outlook. Certainly, I do not want to attempt to redirect it via many emails or outlook.com as it is not certainly trustworthy and each path goes through the risky situation. By seeing this entire situation, I am not able to access my all centurylink emails in MS outlook. I am in big technical trouble. I don’t have ideas how to come out from this critical situation. I am applying all my technical skills to sort out this error, but nothing is very helpful. I am very serious at this point because of the urgent tasks. I need to complete the urgent tasks just by accessing emails in MS outlook. So I am going to share this concern with all of you guys. So anyone can share the best ways to solve centurylink emails that do not work in outlook.

      ReplyDelete
    23. If you want to use any type of model of HP printer for your printing needs, you can set up your preferred model number of HP printer using 123.hp.com/setup. This website helps you to set up the preferred model number of your HP printer in the appropriate ways. First of all, you need to open this link in your preferred browser and download the software step by step. After that, you need to perform displaying steps in the correct ways. If you get stuck in the process, you can take the specialized guidance from online technical experts.

      ReplyDelete
    24. Use Assignment Help Online services if you don’t find anything to compose your academic paper or homework. Sometimes, you can’t concentrate on your studies because of being busy with many activities and find hard to write your assignment. So, take the online help of experts and find some more hands for drafting the documents. When you don’t find sufficient time for managing the different activities of assignment writing, then you have to make the right option. This is the best option to finish your papers without any tension.
      Online Assignment
      help with my assignment

      ReplyDelete
    25. Thanks for sharing this post, Hello! I am James Famuliner, a talented techie with over 15 years of experience in delivering quality assistance regarding Brother Printer error issues. Many of the users have reported that their Brother printer not printing and they seek guidelines to know why this happens and how to fix it. So, I am always ready to assist those helpless candidates for providing instant solution at doorstep. If your printer is not printing for any reason, you can make immediate connection to me via dialing helpline number and stay tuned with no hassle. In the blink of an eye your Brother printer will start printing without any hindrances.

      ReplyDelete
    26. Assignment Help in Canada works well for many students who can’t complete their papers on time. For more information, visit the website and access all essential about online assignment help.

      ReplyDelete
    27. MkvPoker Adalah Situs Judi Poker Terbaik Dengan Taruhan Uang Asli Yang Menjaminkan Kemenangan Yang Tinggi

      Wa : +855 9637 31855

      ReplyDelete
    28. I am really very happy to visit your blog. Very powerful and have true and fresh information. Thanks for the post and effort! Please keep sharing more such a blog.
      mcafee.com/activate | mcafee login | install mcafee with activation code

      ReplyDelete
    29. Thank you for sharing your great article…this is very helpful and informative for everyone. Give a chance to make a great compaign..
      mcafee.com/activate | www.mcafee.com/activate | mcafee download | mcafee activate

      ReplyDelete
    30. Roku varies from TV sets and set-top boxes with respect to the services that run on them. How? there are a number of Movie streaming services loaded on Roku just like the apps on your smartphones. roku.com/link | roku activation code | roku link

      ReplyDelete
    31. office.com/setup : Microsoft Office is utilized by the greater part of the individuals to complete their work in an orderly and sorted out way. office setup comes with various adaptations like Office 2019, Office 2016, Office 2013, and Office 365. Each Microsoft program is utilized for various assignments. Every adaptation of the Microsoft Office Setup needs an item code to complete its actuation procedure.

      ReplyDelete
    32. Due to some AOL IMAP Settings problems, I am getting problems to open them appropriately. I have taken online help from AOL technicians, but nothing is successful. Hence, it has become a big issue for me. Can you advise the best solutions for solving settings problems?

      ReplyDelete
    33. Thanks for taking the time to share with us such a great article. I found such a significant number of fascinating stuff with regards to your blog particularly its discussion. Keep doing awesome. Visit:- | office.com/setup | install vipre | Telstra Webmail | totalav antivirus | advisor for you

      ReplyDelete
    34. I use AOL emailing service for smooth and clear communication. But from the last three or four weeks, my AOL mail is not working, so I am extremely disappointed.

      ReplyDelete
    35. Your article is attractive and informative. Thank you for sharing. Any student pursuing nursing should be passionate about it. Even though it is important to attain high scores, there’s a need to go the extra mile in delivery of services to the patients which is a skill that may not be learned in school. Also, nursing students need to understand nursing concepts and be able to implement them in real life. They have to carry out a lot of research especially when they have assignments to handle. Learn more from Nursing Paper Writers .

      ReplyDelete
    36. Kampusbet selalu berusaha mengikuti perkembangan zaman agar dapat memberikan pelayanan terbaik.
      Sehingga semua player yang daftar situs kampusbet online dapat bermain dengan aman dan nyaman.
      Serta melakukan proses deposit withdraw dengan cepat, dana sudah terkirim ke rekening tidak sampai 5 menit

      KampusBET

      ReplyDelete
    37. Thanks for sharing this post, Hello, I am Nisha, the easiest way to use CBD is in the form of Full Spectrum CBD Gel Caps 25mg as it the softgels contain rich CBD help plant extraction. We have made CBD softgel capsules from true agriculture hemp with the inclusion of terpenes, fatty acids, and minor cannabinoids. We have made these 25mg CBD capsules with the right dosage amount in consultation with the expert team. It helps in balancing the endocannabinoid system which works as a dietary supplement that helps in building a strong immune system and used for other problems too. It is also used for problems like heart, high BP, depression, etc.

      ReplyDelete
    38. This comment has been removed by the author.

      ReplyDelete
    39. If you are new to Quickbooks, it is natural for you to face some difficulties during the learning curve. However, there is no need to worry as you can use our popular and trusted Quickbooks technical support number. https://www.assistanceforall.com/services/quickbook-support/

      ReplyDelete
    40. love your passion of writing great content like this. Massage is most noted for its ability to help alleviate stress, anxiety, depression, pain, and stiffness. Athletes often use massage as a method to help prevent sports-related injuries. Cancer patients have reported massage therapy as a critical aspect of their treatment plan stating that massage makes chemotherapy a gentler process. Learn more on Professional Handheld Massagers

      ReplyDelete
    41. There could be various reasons for the occurrence of HP fax error 388, and the primary one includes sudden shutdown due to power off or malware attack. You can see this when you are trying to send the fax on a disrupted line. To know the troubleshooting steps, you can print the fax test. To get the report turn on your fax machine and then click the setup button, now navigate to service option you can use the arrow button to scroll and then click Ok. The next step is to locate the option Run fax test and press the Ok button. Now, wait for the test report to print, which includes the troubleshooting steps to get rid of HP fax error 388.

      https://www.hpprintersupportpro.com/blog/expert-guide-how-to-fix-hp-printer-error-388/

      ReplyDelete
    42. For more details about HP Printer Setup, Driver Download and Troubleshooting just visit our site 123.hp.com/setup or call our support number +1-800-237-0201
      Read More:
      123.hp.com/setup
      123.hp.com
      www.123.hp.com/setup
      How to connect HP Deskjet 3755 to wifi
      HP Envy photo 7155 setup
      123.hp.com/dj3632 install

      ReplyDelete
    43. PNJ Sharptech, one of India's quickest Responsive Web designing services provider. Our Low cost Web designing services team is fully equipped with the top set of skills, tools, and sources. With appealing graphics and accessible, complete user-friendly navigation our website designers team guarantees that your site not only brings just traffic but also engages and helps you to convert them to clients.

      Also Read: Top Reasons To Choose React Native for Mobile App Development

      ReplyDelete
    44. While writing the PEEL paragraph, you need to express your thoughts and opinions to the reader precisely. When you wish to express your ideas correctly, you should keep the format in the mind that helps readers to understand what message you want to convey.

      ReplyDelete
    45. Digital Expert solution is one of the best and top digital marketing expert in india having a team of professionals digital marketing experts. Here you'll find the professional digital marketing services to your business that helps to go for the best rankings over google for your business. It really helps you to generate leads to your business and you'll get best output from it. If you want to know more then you should visit the official website of digital expert solution. If you want to see the work of life example of digital expert solution visit the official website of ph uv printer - authorized uv printer supplier in India provide best uv printer in india at affordable digital uv flatbed printing machine price in india.

      ReplyDelete
    46. Great post and I got extremely information from your article. I appreciate your work and requesting you to please keep posting other articles. and like you, I am also here to provide information about suddenlink login service. So if you need and if you want to get information about any email problems then click and visit the given links. Remember we are here for independent help and using product names for the referent only.
      suddenlink email login
      suddenlink.net login

      ReplyDelete
      Replies
      1. 192.168.l.l is an IP address used by many routers and modems as the default gateway. 192.168.1.1 address can be used by the users to gain the router admin access and configure their routers and networks.
        192.168.1.1

        We Provide Complete HP Printer Setup Configuration. Our Service Starts from 123.hp.com/setup Printer unboxing, Ink cartridge Setup, Hp Printer Driver Software Download & Installation. We Support you for 123 hp com Setup Network Printer Connection which can be done by either USB or Wireless Connection. If you are facing any Issues with Hp Printer Installation Contact our Printer experts for Troubleshooting. We are here to resolve your Issues round the clock.
        For More Information Visit Our Site: 123.hp.com/setup

        Delete
    47. The blog written is extremely impressive, with a great topic. However, a bit more research could have strengthened it even further. You can explore the services as offered by livewebtutors.com, a premium academic writing services platform offering the best of Plagiarism Checker Tool teamed with knowledge and experience.

      ReplyDelete
    48. My brother suggested I might like this blog. He was totally right. This post truly made my day. You can not imagine simply how much time I had spent for this info! Thanks!

      ReplyDelete

    Post a Comment

    Popular Posts