XSLT to transform Pitstop XML report with just the Doc Info

Post Reply
mark.jetzer
Newbie
Posts: 7
Joined: Wed Mar 27, 2013 12:46 pm

XSLT to transform Pitstop XML report with just the Doc Info

Post by mark.jetzer »

I've been searching and trying to write this myself. I am by no means an XML expert. I looking for help with an XSLT to transform a Pitstop XML report to an XML with just the Doc Info portion. Basically this section the the parts in bold:







_0002T_Art_Lay_Exact_Demo_02crops.pdf



%FileInfo%

GeneralDocInfo

-1





/C/Documents and Settings/araxi/Application Data/Enfocus/Switch Server/backing/XML Out/automanaged/Folder 1/_0002T_Art_Lay_Exact_Demo_02crops.pdf

D:20131121101030-05'00'

D:20131121120624-05'00'

Adobe PDF Library 10.0.1

Adobe InDesign CS6 (Macintosh)

Var name="Author"/>







3

12

1

4

0

0

0

1

0

1

-1

3













Any help, guidance. In the end I want to feed that transformed XML into Prinergy and use it to build a job based on those fields.
dkelly
TOP CONTRIBUTOR
Posts: 658
Joined: Mon Nov 29, 2010 8:45 pm
Location: Alpharetta GA USA
Contact:

XSLT to transform Pitstop XML report with just the Doc Info

Post by dkelly »

These values are also available via Switch variables for job statistics and metadata.



Here are the variables:



Author: [Doc.Author]

Title: [Doc.Title]

Subject: [Doc.Description]

Keywords: [Doc.Keywords]

Number of pages: [Stats.NumberOfPages]
mark.jetzer
Newbie
Posts: 7
Joined: Wed Mar 27, 2013 12:46 pm

XSLT to transform Pitstop XML report with just the Doc Info

Post by mark.jetzer »

Yes, I know. I don't have the scripting module. I do have the Metadata. The problem is I need those parts as an XML file I can feed into my Kodak Workflow. To my knowledge there isn't any way to pull that from the Switch variables for job statistics and turn it into an XML file without the scripting module.
dkelly
TOP CONTRIBUTOR
Posts: 658
Joined: Mon Nov 29, 2010 8:45 pm
Location: Alpharetta GA USA
Contact:

XSLT to transform Pitstop XML report with just the Doc Info

Post by dkelly »

Scripting would make it easy but you could create a simple XML file using the Execute command configurator.
mark.jetzer
Newbie
Posts: 7
Joined: Wed Mar 27, 2013 12:46 pm

XSLT to transform Pitstop XML report with just the Doc Info

Post by mark.jetzer »

Ay tips on how to do that?
freddyp
Advanced member
Posts: 1023
Joined: Thu Feb 09, 2012 3:53 pm

XSLT to transform Pitstop XML report with just the Doc Info

Post by freddyp »

Here is the XSL that you need:



























I put in there as the top level of the transformed XML. If you need something else, change it. And there is just one line in there to illustrate how to do it for Author, the rest is just copy and paste. Take care of double and single quotes, uppercase and lowercase, slashes, . One mistake and it does not work. Good luck.



Freddy
mark.jetzer
Newbie
Posts: 7
Joined: Wed Mar 27, 2013 12:46 pm

XSLT to transform Pitstop XML report with just the Doc Info

Post by mark.jetzer »

Worked great thank You!
DanieP
Newbie
Posts: 1
Joined: Wed Mar 18, 2015 1:30 pm

Re: XSLT to transform Pitstop XML report with just the Doc Info

Post by DanieP »

freddyp wrote:Here is the XSL that you need:

Hi Freddyp,

Cant see the quote, could you please forward it to me as i'm sitting with the exact same problem...

Tahnx



























I put in there as the top level of the transformed XML. If you need something else, change it. And there is just one line in there to illustrate how to do it for Author, the rest is just copy and paste. Take care of double and single quotes, uppercase and lowercase, slashes, . One mistake and it does not work. Good luck.



Freddy
Post Reply