Auto number a list from metadata

Post Reply
User avatar
vernonvd
Member
Posts: 38
Joined: Tue Oct 09, 2012 9:21 am
Location: Pretoria, South Africa

Auto number a list from metadata

Post by vernonvd »

this is what i get form my metadata log.

Switch varibale '[Metadata.TextIndexed:Path="//info",Dataset="Mail",Model="XML",Separator="<br>"]'

this gives me a list which is very cool ;)

46278 Folder with pocket WR129238E
46279 Business Cards - 25 sets of 250 each WR129237E
46280 Letterheads WR129237E
47121 Business cards. 100 each of 9 different + 50 of another WR129170E

will it be possible to auto number the list?

1. 46278 Folder with pocket WR129238E
2. 46279 Business Cards - 25 sets of 250 each WR129237E
3. 46280 Letterheads WR129237E
4. 47121 Business cards. 100 each of 9 different + 50 of another WR129170E


PS. the number of items in the list will vary each time
dkelly
TOP CONTRIBUTOR
Posts: 658
Joined: Mon Nov 29, 2010 8:45 pm
Location: Alpharetta GA USA
Contact:

Re: Auto number a list from metadata

Post by dkelly »

Can you give us a little more information?

It appears that the incoming job has an XML attached as metadata. You locating the individual items by splitting on "<BR>" element.

What element are you using the variable? In a script or Condition with variables?
User avatar
vernonvd
Member
Posts: 38
Joined: Tue Oct 09, 2012 9:21 am
Location: Pretoria, South Africa

Re: Auto number a list from metadata

Post by vernonvd »

dkelly wrote: Wed Aug 08, 2018 5:00 pm Can you give us a little more information?

It appears that the incoming job has an XML attached as metadata. You locating the individual items by splitting on "<BR>" element.

What element are you using the variable? In a script or Condition with variables?
Hi dkelly

Ok, so my plan is to mail a active job list to our customers. a simple text file picks up the xml as a dataset from our MIS, then i use that metatdata in a mailsend element.

this variable gets incorporated in the mail as a list.
[Metadata.TextIndexed:Path="//info",Dataset="Mail",Model="XML",Separator="<br>"]
User avatar
vernonvd
Member
Posts: 38
Joined: Tue Oct 09, 2012 9:21 am
Location: Pretoria, South Africa

Re: Auto number a list from metadata :Solution

Post by vernonvd »

The use of <ol></ol> html tag does the trick ;)

what the Switch variable in the HTML mail looks like:

<ol><li>[Metadata.TextIndexed:Path="//info",Dataset="Mail",Model="XML",Separator="</li><li>"]</li></ol>


the result:

Image
Attachments
Capture.JPG
Capture.JPG (39.21 KiB) Viewed 8203 times
Post Reply