Jump to content

Ben Feingold

Members
  • Content Count

    28
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ben Feingold

  • Rank
    novice
  • Birthday 03/21/1978

Profile Information

  • Gender
    Male
  • Location
    Boston, MA
  1. This is a continuation of a question I had back in August about importing XML generated via an API. I listed the rest of the question in that thread, but then realized that people might not see it as that initial question was successfully answered. I hope you don't mind my reposting it as a new topic. My latest endeavor is getting my inventory to import. I modified the XSL for the EVE API, added a table with the corresponding names, and modified the script, but I get the following error from FileMaker when I run it and tell FM to retrieve the XML from "https://": If I tell it to get it from "http://..." I get: However, if I use an XML coding program to apply my new stylesheet to the the raw XML provided by EVE's API, and then save the result to it's own XML file, I can easily import the records from the menu File>Import Records>XML Data Source... Any idea what might return this error? Is FileMaker able to retrieve XML from https? I attached three files: 1. The XML from EVE http://fmforums.com/files/file/34-eve-api-asset-list/ 2. My XSL 3. The XML with the stylesheet applied
  2. File Name: EVE Asset List with Inventory Stylesheet applied File Submitter: Ben Feingold File Submitted: 27 Jan 2013 File Category: Samples FM Version: Not Applicable This is the result of applying the stylesheet I created to the XML from EVE. I am able to import it from the File menu. Click here to download this file
  3. 76 downloads

    This is the result of applying the stylesheet I created to the XML from EVE. I am able to import it from the File menu.

    Free

  4. 104 downloads

    The XSL I created so FileMaker will be able to read the XML data from EVE Online's Asset API. Just remove the ".txt" once you've downloaded it.

    Free

  5. File Name: My Inventory XSL File Submitter: Ben Feingold File Submitted: 27 Jan 2013 File Category: Samples FM Version: Not Applicable The XSL I created so FileMaker will be able to read the XML data from EVE Online's Asset API. Just remove the ".txt" once you've downloaded it. Click here to download this file
  6. File Name: EVE API Asset List File Submitter: Ben Feingold File Submitted: 27 Jan 2013 File Category: Samples FM Version: Not Applicable Straight dump of the EVE Online API for assets. Click here to download this file
  7. 54 downloads

    Straight dump of the EVE Online API for assets.

    Free

  8. As a matter of fact, I had a lot of success. I used the example provided by "comment" (Thank you so much!) and built a solution to automatically generate a build schedule based on profit margins.
  9. Taking a look at your example now. Thank you very much!
  10. Thank you for the quick reply. The XSLT is where I get stuck. After reading other people's posts about importing XML, I gather I'm not alone in this. Is there a good, "How to get started making your custom XSLT Stylesheet" forum or guide you can point me to? My friend Google helped me find the XSLT Tutorial at w3schools.com. I took a few minutes to play with the tutorial and I think I understand how it's supposed to work. Below is an excerpt of XML code. I take this: This XML file does not appear to have any style information associated with it. The document tree is shown below. <evec_api method="marketstat_xml" version="2.0"> <marketstat> <type id="9832"> <buy> <volume>6365114</volume> <avg>6481.53</avg> <max>7505.05</max> <min>1800.02</min> <stddev>1207.86</stddev> <median>6621.00</median> <percentile>7502.91</percentile> </buy> <sell> <volume>2679134</volume> <avg>8911.18</avg> <max>11300.00</max> <min>7549.66</min> <stddev>774.93</stddev> <median>8500.00</median> <percentile>7549.66</percentile> </sell> <all> <volume>9044248</volume> <avg>7201.25</avg> <max>11300.00</max> <min>1800.02</min> <stddev>1299.05</stddev> <median>7339.70</median> <percentile>3976.32</percentile> </all> </type> </marketstat> </evec_api> And apply something like this to it: <?xml version="1.0" encoding="ISO-8859-1"?> <!-- Edited by Me --> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html> <body> <h2>EVE-Central XML Import</h2> <table border="1"> <tr bgcolor="#9acd32"> <th>Volume</th> <th>Average</th> <th>Max</th> <th>Min</th> <th>Standard Deviation</th> <th>Median</th> <th>Percentile</th> </tr> <xsl:for-each select="marketstat/type id="?"> <tr> <td><xsl:value-of select="volume"/></td> <td><xsl:value-of select="avg"/></td> <td><xsl:value-of select="max"/></td> <td><xsl:value-of select="min"/></td> <td><xsl:value-of select="stddev"/></td> <td><xsl:value-of select="median"/></td> <td><xsl:value-of select="percentile"/></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet> Assuming I'm on the right path, I have no idea what to do with this line, as it changes for each item type and this XML has 12 items listed one after another: <xsl:for-each select="marketstat/type id="?"> As you can see in my XML example, the value is "<type id="9832">" but there could be any number in there.
  11. Greetings, This is a non-work related question, but any help you can offer would be much appreciated. When not fulfilling my daily role as an IT Coordinator, I indulge in the MMO EVE Online. I've been building complex GoogleDocs to check market rates on items when it dawned on me that I could do all that and a lot more with FileMaker. So here's my situation: I currently have a button in my FileMaker database that opens this URL. I then copy the content of the page and paste it into a field ("XML_Data"). I then use the custom function ExtractData to pull out the data I need for my calculations. What I would like: Each time I open the database, I would like it to automatically retrieve the XML data from the web and put it in the field. Any ideas? Thanks in advance, Commander Ben Feingold CEO of a virtual Corporation...in a virtual world of spaceships and laser guns... Here's the URL incase the link didn't work: http://api.eve-centr...nlimit=10000002
  12. Thank you for all your help everyone. It's always good to bounce problems off other people. I figured it out. The problem wasn't with my calculations. The problem was in my relationships. (No, my wife and I are fine) I was trying to pull data from an unrelated table. Once I corrected the relationship, I was able to get the desired result.
  13. I'm trying to change the color of a number calculation (total days in school divided by the total possible days) based on a predefined date field (the date the quarter ends) and the current date. If the current date is BEFORE the end of the quarter, the result of calculation should be grayed out. As I understand it, the command Get(CurrentDate) returns a number value based on how many days have passed since January 1, 0000. I think the problem is that my End of Quarter Date is not entered in this fashion. What I need to know is how to convert a "normal" date (M/D/Y) to the same format as Get(CurrentDate). At least I think that's what I need to know. :o
  14. Sorry for not being more descriptive: Rather then turn gray if the current date (Get(CurrentDate)) is less then the date of the end of the quarter (Q2_EndDate), which it is, the text stays black. If I reverse the "if" so it reads "Get(CurrentDate) > Q2_EndDate" (did it just to see what would happen) it works; the text changes color. This doesn't make sense to me as November 08 is certainly less then January 09.
  15. This is the formula I'm using and it doesn't appear to be working. The value "Q2_EndDate" is a date field and I think this might be the reason. How do I make a date field into a value like the one "Get(CurrentDate)" returns? The logic here is: If today's date is before the last day of the quarter, set the calculation text to gray. Otherwise, just do the calculation. Case( Get(CurrentDate) < Q2_EndDate; TextColor (calculation ; RGB(204;204;204)); calculation )
×
×
  • Create New...

Important Information

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