Jump to content

Jason Hefley

Members
  • Content Count

    17
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jason Hefley

  • Rank
    member
  1. Jason Hefley

    I've fallen and I cant get up!

    I am trying to create a data base for fantasy football. Â I am sure I am not the first nor am I the last. Â Â I am attempting to take all available players at a given site, and calculate value for each player. Â I am then going to sort by position to help the selection process each player. Â I have my tables getting data from a specific excel spreadsheet and importing it into a FM table. Â I am then performing calculations to come up with predicted performance. Â I next want to take that predicted performance and calculate to "fantasy points per dollar" thus finding the most value. Â Â I have two tables set up as seen in the .jpg. Â I can not relate the two tables and I am stuck. Â I have tried a join table using position, but no luck. Â When I connect to available players, and ESPN predictions using players as my primary key, it results in a many to many relationship and I can do nothing with the results. Â Â Â In summary I want to create a report that sorts by position, takes data from two tables for each player (salary and proj points) and calculate value. Â What join table do I need to accomplish? Â Thanks. Â I hope my lack of understandingof FM does not frustrate the community. Â You guys have been awesome in the past. Â I am mostly doing this to practice using filemaker.Â
  2. Jason Hefley

    Relationships while importing data from .csm files

    I do have those unique identifiers as stated in your reply. For playername_id I have ensured a unique identifier for each player by performing a calculation to make player_nameid and player_nameidfk to be the first two letters in a players first name and his last name (i.e Mike Trout = MiTrout) Thanks again.
  3. Jason Hefley

    Relationships while importing data from .csm files

    stat 1 and stat 2 were used for example only.  On the stats table I have 10 different stats.  I am trying to use a portal on the position table to display all players that play that particular position and their statistics (from the stat table)  The data that I am importing is a spreadsheet that has a players name, a player id and about 10 different stats.  When I attempt to create a relationship between the stats table to a player, I am getting a many to many relationship.  Here is a pic of my table structure if it makes it more clear.  Thanks for your patience as I am new to Filemaker, and very eager to learn
  4. Im in the process of just learning Filemaker, so please bear with me. Everytime I think I have a grasp on the process, I get humbled. So here is the latest: I am trying to create a report about baseball. My goal is to have a report by position and display all the stats for players that play that position. I have downloaded a .csm file that has every player since 1871 and their associated stats. So here is my thought process. First I created a table for Position: Position pos_name pos_id Next I created a table of players in that postition. I imported these players from a .csm file through the import records: Since I did not care about LF, CF, or RF (instead of), I created a field that if pos was lf, cf, or Rf it would automatically read of. Player_pos player_name player_nameid imported_pos pos pos_id Player_nameid, is a derived from a calculation to use the first two initials of a players name combined with his last name to uniquely identify said player The table positions is the parent and player_pos is the child and a succesful relationship was established. Now the problem!!! I created another table to import a players raw stats stats player name player nameidfk stat_1 stat_2 I was hoping that player_pos could act as a parent (as one player has one position) and the stats table the child (one player has many stats). When I try to establish the relationship I get a many to many relationship, and my macbook almost takes flight in my frustration I know that I had a stat column with only the player_nameidfk and entered the data manually using a portal I could do this using an intermediate table. The idea of manually entering literally thousands of lines of data makes me sad. What am I missing? I may be just having a fundamental filemaker concept error, so some expert help is appreciated. Thank You J
  5. Jason Hefley

    A typical inventory database with a twist...

    I worked through those power points and watched a couple videos on youtube...It was all a relationship problem. Thank you very much...I just had to get the relationships correct and use a portal to show the ingredients everytime I select a new rub.
  6. Jason Hefley

    A typical inventory database with a twist...

    The specific question I have is that I want to prepare a rub (with a button). When I do that I want it to import all the associated ingredients with that rub. I do not have a problem with changes in price over time, because I have a weighted average of how much each ingredient costs. I know that is going to change with time, and I do not have a problem with that. I am more worried about keeping track of inventory then I am price. Once I import all the associated ingredients, I want to be able to dictate how much rub I am going to make and then be able to calculate the exact quantity of each ingredient to make a "recipe" card. I am stuck on the part of importing the specific ingredients. My vision is to be able to select the rub, and the records will be imported based on the recipe. I then type in how much I am going to make, and press calculate and it commits the record and calculates the amount removed from inventory. I know I have a long ways to go. That is as specific as I can get..
  7. In my continued quest to learn Filemaker the old fashion way (just dive in head first!), I have got stuck again. I am attempting to make a typical inventory database that consists of recipe ingredients for Dry Rubs. I have a table and have successfully created the ability to take a receipt and enter the data off the receipt to calculate "inventory in". Now the twist. I have created another table to add recipes to the database, using a portal to add related records to each recipe at a given amount for each recipe. I would like to create a button/link to push "make" recipe and have the ingredients calculated for a given size of recipe and those results be taken out of my inventory. Eventually I would like to calculate the cost of each ingredient and therefore how much it would cost to make a given rub at a given size. I will just attach my database and let you professionals look at it. I am sure there is a way to do this. I was trying to make a portal in the "prepare_rub" that would use the data from the "rub_recipe" table and make and amount used field for calculation in the ingredient table to make an inventory. I have reached my limited level of knowledge and can not make it work. I appreciate your help. smokeandbones.zip
  8. Jason Hefley

    A Troubling Relationship

    The problem I am have having, or maybe this is my misunderstanding, is that when I am trying to use the weighted average for a given ingredient's price the result is zero. I have a layout that is all the ingredients used, and the all the purchases of that ingredient. I have a subsummary part that calculated the weighted average of all the transactions of a particular ingredient based on the quantity of the ingredient and the actual purchase price. I am then trying to take that subsummary part using the getsummary function and multiple it by the amount used in a recipe to give me the cost of making a given recpe. I think my biggest misunderstanding is how to relate the tables and what function to use.
  9. Jason Hefley

    A Troubling Relationship

    In the Recipe table I am trying to make it so when I create a recipe it calculates the cost of said recipe. I must use a weighted average of all the purchase I make of a given ingredient as the price of ingredients change over time.
  10. Jason Hefley

    A Troubling Relationship

    I am pretty new to this so I apologize for my ignorance, but I have no idea what you are talking about. When entering date on a purchase order, I should have a script that runs the calculation and it will become stored data that can be later used in calculations.
  11. Jason Hefley

    A Troubling Relationship

    When trying to change the calculation using an aggregate function it makes it an unstored field. I am using the calculation of: Sum (purchaseorder::Amount Paid)/Sum (purchaseorder::Cost per Pound) It classifies it as an unstored field. I attempted to change the field to an stored field and it gives me the following error: "The calculation “total cost” cannot be stored or indexed because it references a related field, a summary field, an unstored calculation field, or a field with global storage."
  12. Jason Hefley

    A Troubling Relationship

    I understand that now, but now trying to use aggregate functions, it show that the calculation is unstored. How do I change this as it is giving me the same result (blank field)
  13. Jason Hefley

    A Troubling Relationship

    Wow great question....I think the answer is yes. As I purchase product the weighted average will change, and I am ok with that. To answer your question, yes.
  14. Jason Hefley

    A Troubling Relationship

    I am pretty new to Filemaker so I would like to apologize ahead of time..  I am trying to learn Filemaker the old fashion way, and just diving into it and asking questions when I get stuck.  I am making a data base that I plan on tracking expenses for BBQ.  In this data base, I have a table called ingredients that list of all ingredients that I use.  It is the parent to a table I call "recipeingredients".  (ingredientid -> ingredientidfk).  I also have another table called "purchaseorder".  This table is a list of transactions of buying ingredients.  I know that prices change over time, so this table has a list layout of all purchases sorted by ingredient with a subsummary of the weighted average of the list of ingredients.  It is also the child of the ingredient table. (ingredientid -> ingredientidfk).  I have another table called recipe.  Lastly I have a table called recipeingredients that is a list view and sorted by recipe name.  I have a relationship between recipe and recipieingredients (recipeid -> recipeidfk).  I have another relationship between "purchaseorder" and recipeingredients.  I have attached a screen shot to make sure I explained that correctly.  My goal is create a field in the recipeingredients table that calculates how much each recipe costs to make.  I must extract the subsummary data from the purchaseorder table and multiply it by the amount used in each ingredient for a given recipe and total the value for each recipe.  I have attempted to use the "getsummary" function as shown: (GetSummary ( purchaseorder::Avg Cost per Pound ; purchaseorder::Ingredients )) * amount.  When I do this, the only number I get is 0.  I am posting this here as I think I have a relationship problem...  I may be way off here, so please help  Hafa Adai  Jason      Â
  15. I am pretty new to Filemaker,and maybe trying to bite off more than I can chew...story of my ilfe.. I have used the GetUrl script and pasted html data into a field called "url_g". In this HTML I am attempting to get some data out of 4 tables and put them in their respective fields. I have tried numerous scripts to accomplish this, and am really struggling. A sample of the HTML code is below: <tr class="ysprow1" align="right" height="16"><td class="yspscores" align="left">&nbsp;2010-11</td><td class="yspscores" align="left">ATL</td><td class="yspscores">77</td><td class="yspscores">34:17&nbsp;</td><td class="yspscores">6.5</td><td class="yspscores">13.5</td><td class="yspscores">47.7</td><td>&nbsp;</td><td class="yspscores">0.7</td><td class="yspscores">2.0</td><td class="yspscores">33.1</td><td>&nbsp;</td><td class="yspscores">3.0</td><td class="yspscores">4.1</td><td class="yspscores">72.5</td><td>&nbsp;</td><td class="yspscores">1.7</td><td class="yspscores">6.8</td><td class="yspscores">8.5</td><td>&nbsp;</td><td class="yspscores">3.3</td><td class="yspscores">2.6</td><td class="yspscores">1.3</td><td class="yspscores">1.6</td><td class="yspscores">2.8</td><td class="yspscores">16.5</td><td>&nbsp;</td></tr> Every number in this code needs to be placed in a particular field. To start I was simply trying to parse this text to a separate field so I could attempt to parse each number. Now, I am here begging for help. Is this even possible? I watched a video of a somebody doing it, but he made assumptions I did not understand. I have googled "parse data" and most of the examples are very simple. What I have tried is to Set a variable at word "ysprow1" and "ysprow2" (the beginning of the next table). I then attempted set a variable using the Middle function. I ran the script and it crashed FM. Here is a copy of the script I was using last #Parse the Tables out of the Code #First Table Loop Go to Record/Request/Page[ First ] Set Variable [ $t1beg; Value:Position ( NBA Players::url_g; "ysprowl1" ; 1 ; 1 ) ] Set Variable [ $t1end; Value:Position ( NBA Players::url_g; "ysprowl2" ; 1 ; 1 ) ] Set Variable [ $table1; Value:Middle ( NBA Players::url_g; $t1beg ; $1tend-$t1beg ) ] Set Field [ NBA Players::url_l_table_1; $table1 ] Go to Record/Request/Page [ Next; Exit after last ] End Loop I know this is the part where experienced FM designers are laughing..I deserve it Any help would greatly be appreciated..
×

Important Information

By using this site, you agree to our Terms of Use.