Cuthbert Rumbold Posted February 14, 2011 Share Posted February 14, 2011 I have an Excel XML file that we'd like to import directly into FileMaker. I understand that this requires an XSLT file, but I'm unclear on how I would get or create that file. The XML file isn't actually created by Excel, it's the output from the Wufoo.com online forms provider. As this is going to be a recurring task, we'd like to import the XML directly into FileMaker (rather than take extra steps of importing into Excel, saving, and importing again into FM). Thanks for any suggestions. Link to comment Share on other sites More sharing options...
comment Posted February 14, 2011 Share Posted February 14, 2011 Do you mean Excel 2003 XML format? Link to comment Share on other sites More sharing options...
Cuthbert Rumbold Posted February 15, 2011 Author Share Posted February 15, 2011 Thanks for the reply. Judging by that example I'd say yes. I'm attaching a snippet from the XML file. test.xml Link to comment Share on other sites More sharing options...
comment Posted February 15, 2011 Share Posted February 15, 2011 Yes, that's what it is. So how familiar are you with XSLT? You need to write a custom stylesheet to transform your XML into Filemaker's FMPXMPRESULT grammar. BTW, doesn't your service provide a CSV or tab-delimited format? 1 Link to comment Share on other sites More sharing options...
Cuthbert Rumbold Posted February 16, 2011 Author Share Posted February 16, 2011 Yes, that's what it is. So how familiar are you with XSLT? You need to write a custom stylesheet to transform your XML into Filemaker's FMPXMPRESULT grammar. Not very. So each unique spreadsheet would require a custom stylesheet, there is no generic use-this-for-Excel stylesheet? BTW, doesn't your service provide a CSV or tab-delimited format? They might, I'll have to talk to the user that is generating the data. Thanks! Link to comment Share on other sites More sharing options...
comment Posted February 16, 2011 Share Posted February 16, 2011 there is no generic use-this-for-Excel stylesheet? Perhaps one could be written - but it would be an awful lot of work to cover all possible variations. The format is already complex enough for even a tailor-made stylesheet. So how familiar are you with XSLT? Not very The question is whether you'd able to adapt an example to your needs. Link to comment Share on other sites More sharing options...
Cuthbert Rumbold Posted March 1, 2011 Author Share Posted March 1, 2011 The question is whether you'd able to adapt an example to your needs. Oh probably, yes. A pointer to an example would be welcome. Thank you! Link to comment Share on other sites More sharing options...
comment Posted March 1, 2011 Share Posted March 1, 2011 Try this one: example.zip 1 Link to comment Share on other sites More sharing options...
Cuthbert Rumbold Posted March 10, 2011 Author Share Posted March 10, 2011 Try this one: Brilliant, that worked wonderfully. I just modified the <METADATA> and <ROW> sections to reflect the actual columns I have in the input file. Thank you very much! Link to comment Share on other sites More sharing options...
eljotor Posted April 30, 2015 Share Posted April 30, 2015 (edited) Try this one: example.zip The example.zip file seems to be broken. Can you please upload it again? Edited April 30, 2015 by eljotor Link to comment Share on other sites More sharing options...
comment Posted April 30, 2015 Share Posted April 30, 2015 The example.zip file seems to be broken. Can you please upload it again? Sorry. After 4 years, with "example.zip' being the only clue... Post a new question. Link to comment Share on other sites More sharing options...
Kris M Posted April 30, 2015 Share Posted April 30, 2015 Zombie alert!!!! Call Rick Grymes Link to comment Share on other sites More sharing options...
comment Posted April 30, 2015 Share Posted April 30, 2015 Zombie alert!!!! Call Rick Grymes This is no laughing matter. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3255 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now