0 Replies Latest reply on Jun 13, 2011 12:23 PM by Kobyashi

    Importing XML with XSLT

    Kobyashi

      Title

      Importing XML with XSLT

      Post

      Using FM Pro 10, I'm trying to import some address data from using a link to a web service in to an existing table.and am having a lot of trouble with the import. Filemaker generally provided the error message "Message could not open file: [0]" (attached)

      XML is something new and to complicate matters I'm confused over the format of the data returned which is pasted below. It looks different to other xml I've looked at. Can anyone help by pointing me someplace where I can see how to build a successful xsl stylesheet? Incidentally, there should only ever be one record.

      <?xml
      version="1.0" encoding="UTF-8"?>

      <Table>

      <Columns Items="29">

      <Column Type="Integer" Name="Udprn"/>

      <Column Type="String" Name="Company"/>

      <Column Type="String" Name="Department"/>

      <Column Type="String" Name="Line1"/>

      <Column Type="String" Name="Line2"/>

      <Column Type="String" Name="Line3"/>

      <Column Type="String" Name="Line4"/>

      <Column Type="String" Name="Line5"/>

      <Column Type="String" Name="PostTown"/>

      <Column Type="String" Name="County"/>

      <Column Type="String" Name="Postcode"/>

      <Column Type="Integer" Name="Mailsort"/>

      <Column Type="String" Name="Barcode"/>

      <Column Type="String" Name="Type"/>

      <Column Type="String" Name="DeliveryPointSuffix"/>

      <Column Type="String" Name="SubBuilding"/>

      <Column Type="String" Name="BuildingName"/>

      <Column Type="String" Name="BuildingNumber"/>

      <Column Type="String" Name="PrimaryStreet"/>

      <Column Type="String" Name="SecondaryStreet"/>

      <Column Type="String" Name="DoubleDependentLocality"/>

      <Column Type="String" Name="DependentLocality"/>

      <Column Type="String" Name="PoBox"/>

      <Column Type="String" Name="PrimaryStreetName"/>

      <Column Type="String" Name="PrimaryStreetType"/>

      <Column Type="String" Name="SecondaryStreetName"/>

      <Column Type="String" Name="SecondaryStreetType"/>

      <Column Type="String" Name="CountryName"/>

      <Column Type="Float" Name="Confidence"/>

      </Columns>

      <Rows Items="1">

      <Row Type="SmallBusiness" Confidence="1.04" CountryName="England" SecondaryStreetType="" SecondaryStreetName="" PrimaryStreetType="Street" PrimaryStreetName="Oxford" PoBox="" DependentLocality="" DoubleDependentLocality="" SecondaryStreet="" PrimaryStreet="Oxford Street" BuildingNumber="100" BuildingName="" SubBuilding="" DeliveryPointSuffix="1A" Barcode="(W1D1LL1AN)" Mailsort="76115" Postcode="W1D 1LL" County="" PostTown="London" Line5="" Line4="" Line3="" Line2="" Line1="100 Oxford Street" Department="" Company="One Hundred Club" Udprn="25736693"/>



      </Rows></Table>

      img_1.jpg