StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORename a batch of values with xslt
primarykey
Id
16936410
data
AcceptedAnswerId
16939650
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-06-05T09:34:25.400
FavoriteCount
0
LastActivityDate
2013-06-05T12:11:53.360
LastEditDate
2013-06-05T10:55:06.693
LastEditorUserId
363224
OwnerUserId
363224
ParentId
0
PostTypeId
1
Score
1
ViewCount
83
LastEditorDisplayName
text
Body
We have a program that uses xml to save configurations of our program. Someone decided to rename a couple of values in our database and these renames should now also be backwards compatible in the configurations of our customers. An example of a configuration <pre><code><configuration> <fruitToEat>yellow_curved_thing</fruitToEat>  </configuration> </code></pre> A simple match would be (not tested, just an example): <pre><code><xsl:template> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template> <xsl:template match"/configuration/fruitToEat/text()"> <xsl:text>banana</xsl:text> </xsl:template> </xsl:template> </code></pre> But this is just one example and I want to do this 150 times. <blockquote> Is it possible to make an xsl that reads a simple text file or ini file that tells me how the 150 matches should look alike? </blockquote> <pre><code><xsl:template> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template>  <xsl:template match"/configuration/fruitToEat/text()[.='yellow_curved_thing']"> <xsl:text>banana</xsl:text> </xsl:template> </xsl:template> </code></pre> An example of my mapping file could be simply: <pre><code>yellow_curved_thing = banana round_thing = tomato round_dotted = strawberry </code></pre> And I would simply want a small xslt that tells me: <pre><code><xsl:template> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template>  <xsl:template match"/configuration/fruitToEat/text()[.=$fileRow0]"> <xsl:text>$fileRow1</xsl:text> </xsl:template> </xsl:template> </code></pre>
Tags
<xslt><xslt-1.0><backwards-compatibility>
Title
Rename a batch of values with xslt
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMarnix
UserOwnerUserId
1. USMarnix
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PORename a batch of values with xslt
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThis shouldn't be a big deal if you consider your "ini file" as xml file. Use something like `select="document('ini_file.xml').."` to access this filter. But your request is far to vague to know if either this makes sense, or if it would be better to implement this rules explicit in xlst.
 singulars
 PostPostId
 PORename a batch of values with xslt
 UserUserId
 UShr_117
2. COSo I would have to make a new xml and could simply just make the xslt explicit for all rules?
 singulars
 PostPostId
 PORename a batch of values with xslt
 UserUserId
 USMarnix

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.