Jump to content

Importing Excel XML file


This topic is 3255 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

  • 2 weeks later...
  • 2 weeks later...
  • 4 years later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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