Newbies rickyg75 Posted February 21, 2005 Newbies Posted February 21, 2005 I am using Netsuite CRM software and I'm compelled to convert Filemaker files to smbxml (an xml version of Oracle's Netsuite program). Problem is when I export xml using FM7, the DTD of Netsuite cannot seem to validate the xml export. I'm using xml spy to validate the exported FM file but it does not even contain the right data structure (i.e. headers and body) of a correct xml acceptable for smbxml import to Netsuite. Any clues as to what could be wrong? Thanks. Rick- an xml Newbie
Fenton Posted February 21, 2005 Posted February 21, 2005 XML means "extensible markup language." Extensible means you can create your own tags and validation. I imagine Oracle has quite a slew of them. FileMaker has its own also, but they're fairly simple. Look at the xml you get by default out of FileMaker. Lots of stuff at the top. So you have to use an XSL stylesheet in-between, to transform the default FileMaker output to what Oracle xml should look like. And you have to build the stylesheet, unless you can find one. The entire "header" part which Oracle requires can probably be just pasted near the top of the XSL, just under the 1st template tag. It will then be transferred to the resulting xml file. The FileMaker headers will not, unless you specify them. If it's not too complicated we might be able to help. I don't know though. Oracle may have a complex format. I didn't see anything at the FileMaker XSLT Library for Oracle.
Recommended Posts
This topic is 7216 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