Importing simple xml file cant see the source Match Field

[Walter-MainFrame]

Hi 

I Hope somenone can helpe me, My client has a print shop and wants to import a xml log file from the printer

 to our current filemaker pro12 Adv, solution, since im new to xml file,

 

And I know i need a xslt file to import the xml, i just found a xslt file from filemaker xml examples, and i try it

againt the printer xml.log file and it works but not very well.

 

And the Problem is

- First i cant see the field for mapping at the import time

- Some fields import but they come with spaces Ex: "     4  " before each character

 

I know because something is wrong with the xslt. because it isnt right for this, 

Any help would be very apreciated.

 

Im sending the small  files so anybody could help.

 

Thank you

WN

 

 

PrintShop.zip

[comment]

Which properties do you want to import?

[Walter-MainFrame]

Hi Comment

 

Properties  ok let me try to explain Since I cant chang the xml, log file because its saved by the printer always the same way i need to import 

the result in the xml file as you can see in the file 2012-12-1.xml

 

Example

<void property="copies">
<int>4</int>
</void>
<void property="cyan">
<int>10</int>
</void>
<void property="mangenta">
<int>5</int>
</void>
<void property="deviceProfileName">
<string>FLYERS PAPER.icc</string>

</void>

....

 

I Need the result under copies ex:4

I Need the result under cyan ex:10

I Need the result under mangenta ex:5

I Need the result under deviceProfileName ex:"FLYERS PAPER.icc"

 

And so i could mapp the source fields in filemaker import 

the fields source should appear.

 

Copies

Cyan

mangenta

deviceProfileName

 

Please Help. thanks in Advance

WN

[comment]

Try the attached.

 

printsvc.xsl.zip

 

 

---

P.S. "mangenta"??

[Walter-MainFrame]

Try the attached.

 

printsvc.xsl.zip

 

 

---

P.S. "mangenta"??

 

Hi Comment,

 

This helped very much, I can match the fields correctly now, 

 

but for some reason i fill in the rest off the original xml and used your xsl

and not all the field are imported.i dont see why

 

 

Iam attaching the new file  if someone can help ??

 

Thank you very much

WN

 

P.s. Sorry it was wrong its magenta 

PrintShop2.zip

[comment]

As an example:

<COL><DATA><xsl:value-of select="void[@property='height']/int"/></DATA></COL>

This cannot work because <void property="deviceProfileName"> contains a <string> element, not <int>.

[Walter-MainFrame]

Hi Comment

 

Ok but the first Line of "_VERSION" contains string  element and it imports, or am i missing something

 

<COL><DATA><xsl:value-of select="void[@property='_VERSION']/string"/></DATA></COL>

 

Do you think its possible to import any other field like Width or Height or overprint.

 

Thank you for your patient

WN

[comment]

but the first Line of "_VERSION" contains string  element and it imports,

 

True, but the stylesheet also reads explicitly from the <string> element in this case:

 

<xsl:value-of select="void[@property=_VERSION]/string"/>

 

 

OTOH, the attempt to read from:

<xsl:value-of select="void[@property=height]/int"/>

fails, because <void property="deviceProfileName"> contains a <string> element, not <int>. The correct call should read:

 

<xsl:value-of select="void[@property=height]/string"/>

 

 

IOW, it's a matter of matching the stylesheet to the XML document.

[Walter-MainFrame]

Hi Comment 

 

Im sorry my mistake i was yesterday looking at the xml file and because i sent to you just part of the xml i maybe

broke the xml logic can you see this new xml file if it is possible to make the xslt file work.

 

Thank you very much

WN

 

Printshop5.zip