Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

XSLT put same value in every row?


This topic is 5271 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi All,

I have an XML file I need to convert to FMPXMLRESULT for import into Filemaker.

I've written an XSLT, and for the most part it's working, but one thing is tripping me up.

I have one value in the header of the original XML that I want placed in every row of the resulting FMPXMLRESULT XML, and for the life of me I can't figure out how to do it.

The value I want from the header is "Title" which contains the text "112_Version 6/17/10." I've set up a column for it in the XSLT named "Version_Name."

Here's the original XML:


<?xml version="1.0" encoding="UTF-8"?>







112_Version 6/17/10

V1

3

0

0

48600

3037+08

00:33:44:29







KN Start

Aux Ink

3037+08



24

24











01:00:00:00

A

0000+00

0





01:11:14:29

D

1012+07

16199







1

060a2b340101010101010f00-13-00-00-00-{4c1a4d37-927a-00c9-060e2b347f7f2a80}



141750

01:18:45:00





161999

01:29:59:29



5/28/2010

DAY



Script_Final Revision

INT. HOUSE

Julia wakes up

001_Julia

112

112_2010-05-28











01:11:15:00

A

1012+08

16200





01:22:29:29

D

2024+15

32399







2

060a2b340101010101010f00-13-00-00-00-{4c1a4d34-8649-00c9-060e2b347f7f2a80}



141750

01:18:45:00





161999

01:29:59:29



5/28/2010

DAY



Script_Final Revision

EXT. HOUSE

Julia gets in her car

001_Julia

112

112_2010-05-28











01:22:30:00

A

2025+00

32400





01:33:44:29

D

3037+07

48599







3

060a2b340101010101010f00-13-00-00-00-{4c1a4d34-868e-00c9-060e2b347f7f2a80}



141750

01:18:45:00





161999

01:29:59:29



5/28/2010

DAY



Script_Final Revision

EXT. BEACH ROAD

Julia drives to the library

001_Julia

112

112_2010-05-28

















And here's my XSLT:





<?xml version='1.0' encoding='UTF-8' ?>







    



    

    

    

    

    

    



    





	

		0

		

		

		

			

			

			

			

			

			

			

			

			

			

		

		

			

				

					

					

					

        			

        			

        			

        			

        			

        			

				

			

			

				

					

				

			

		

	







Anyone have any idea what I'm doing wrong?

Thanks,

Mike

Posted

Thanks, Comment. That works perfectly.

I swear, I tried that early on, but couldn't get a value to be pulled. I think I was just omitting that first backslash before "FilmScribeFile."

Thanks again!

This topic is 5271 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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