Jump to content


  • Posts

  • Joined

  • Last visited

eyepro's Achievements


Newbie (1/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges



  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.
  • Create New...

Important Information

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