Jump to content

eyepro

Newbies
  • Content Count

    5
  • Joined

  • Last visited

Community Reputation

0 Neutral

About eyepro

  • Rank
    newbie
  1. eyepro

    XML export

    it's working By the way do you know ho to remove spaces between lines. When open the xml with notepad++ i get this: ....sorry for dumb questions
  2. eyepro

    XML export

    Thanks. You mean that can't export from different related tables? What can't understand is why exporting without stylesheet works fine and with stylesheet no, exporting fields are the same. There is something wrong in stylesheet (attached)? Concerning the script is possible going from layout to layout and then append data to the xml? stylesheet.xsl
  3. eyepro

    XML export

    I have a issue: not all fields above xsl:for each are exported, some rows stays blank. If I export without stylesheet (using just FMPXMLRESULT) every row is exported correctly, but in wrong format. Where I'm wrong? I have discovered that the export changes according to the form where I am. If I'm on invoices some field are exported and some not, if I'm on Invoice details some exported and some not...possible? Thanks
  4. eyepro

    XML export

    Yes it is and works like a charm!!! Thanks for your prompt reply.
  5. eyepro

    XML export

    I'm very very very newbie on xml. What I need to understand is if it's possibile export in this way. I use a xsl stylesheet to export from FM. I was able to use the <xsl:for-each to export details in the way I want: <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <Details> <Code><xsl:value-of select="fmp:COL[2]/fmp:DATA"/></Code> <WTN><xsl:value-of select="fmp:COL[3]/fmp:DATA"/></WTN> <Date><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></Date> result: <Details> <Code>0280c1</Code> <WTN>1</WTN> <Date>10/04/2018</Date> </Details> <Details> <Code>0280c2</Code> <WTN>2</WTN> <Date>10/04/2018</Date> </Details> <Details> <Code>0280c3</Code> <WTN>3</WTN> <Date>10/04/2018</Date> </Details> what i need to know is how put the fmp:COL[1] above the <xsl:for-each to get this: <CUSTOMER>ABC</CUSTOMER> <INVOICE>01</INVOICE> <Details> <PrimaryKey>0280c1</PrimaryKey> <WTN>1</WTN> <Date>10/04/2018</Date> <Colours/> </Details> <Details> <PrimaryKey>0280c2</PrimaryKey> <WTN>2</WTN> <Date>10/04/2018</Date> <Colours/> </Details> <Details> <PrimaryKey>0280c3</PrimaryKey> <WTN>3</WTN> <Date>10/04/2018</Date> <Colours/> </Details> Thanks in advance.
×

Important Information

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