Hello

I'm trying to export the shippments from FM6 to UPS WorldShip.

It can be done by .xml file. But the result of my export "para_ups.zip" and the .xml necesary "New Feature - Shipper Account Number Auto Import.zip" doesn't match.

Can somebody help me to create one XSL?

Note: In New Feature.xml Appears the section, but i don't need to create Invoices in ups software, so i don't need that segment.

Thank you!!!

New_Feature_-_Shipper_Account_Number_Auto_Import.zip

para_ups.zip

Edited February 24, 200619 yr by Guest

This is just bare-bones and assumes you have a field for each node in "openshipment". If not delete the relevant "" lines

<?xml version='1.0' ?>



 

  

   

    

     

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

      

       

      

     

    

   

  

 

thank you very much for your help.

I try it and gives me one error

(I translate from spanish)

Incorrect Combination in the input XML file

0<>/LineNumber>

It can be because on the .xml sample is

and when i export returns me

¿¿¿

Thank you for your help!!!

You can remove the FileMaker namespace by adding:

exclude-result-prefixes="a"

to the stylesheet element:

xmlns:a="http://www.filemaker.com/fmpxmlresult"

exclude-result-prefixes="a">

Thank you very much!!

Now all works PERFECT!

I owe you a pair of beers! ???

Someday I'll remember to always include that by default in my stylesheets ???

On imports you tend to have a similar but converse problem. Then it's the other guy's namespace that you need to prefix, then exclude. This is only necessary when they define their own specific namespace on their xml. But this is fairly common, esp. with large companies (such as Amazon).

Awesome Awesome Post. I've been trying to work out how to reparse the xmldoresult export from scratch for ages. I didn't realize we could parse another xml file based on a referenced style sheet. Wim you've saved me another 2 weeks of my young life with that example, thanks.

I hope that my question is on the same topic. The spanish language part is throwing me off track ...

I am looking for a stylesheet that will permit me to export data from FIleMaker so that it conforms to the schema required by OpenShipments.xdr (attached)

The idea is to substitute XML processing for the ODBC method of making shipments using FileMaker data.

the schema required by OpenShipments.xdr (attached)

I don't see an attachment.