Auto number a list from metadata

Post Reply
vernonvd
Newbie
Posts: 17
Joined: Tue Oct 09, 2012 9:21 am

Auto number a list from metadata

Post by vernonvd » Wed Aug 08, 2018 2:31 pm

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: 648
Joined: Mon Nov 29, 2010 8:45 pm
Location: Alpharetta GA USA
Contact:

Re: Auto number a list from metadata

Post by dkelly » 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?

vernonvd
Newbie
Posts: 17
Joined: Tue Oct 09, 2012 9:21 am

Re: Auto number a list from metadata

Post by vernonvd » Thu Aug 09, 2018 9:54 am

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>"]

vernonvd
Newbie
Posts: 17
Joined: Tue Oct 09, 2012 9:21 am

Re: Auto number a list from metadata :Solution

Post by vernonvd » Mon Aug 13, 2018 1:41 pm

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 100 times

Post Reply