mbarsic’s blog

This is good thing to know – Banner’s ICGORGMK process creates a file that can be loaded into Luminis as an imported group

1. Create a popsel
2. Run ICGORGMK using your popsel
3. Transfer the resulting XML to a Luminis admin
4. Luminis admin runs: “cptool import segment XML_FILE”
5. Communications sends a targeted announcement to the newly imported group

I find it just as simple to run some SQL to create the XML file or to create the file based off a spreadsheet containing banner IDs.  The format is pretty simple:

<SEGMENTS>
<SEGMENT name=”SomeName” description=”Some description” expiration=”YYYY-MM-DD”>
<MEMBER field=”SCT.ID”>[FULL_BANNER_ID_1]</MEMBER>
<MEMBER field=”SCT.ID”>[FULL_BANNER_ID_2]</MEMBER>
</SEGMENT>
</SEGMENTS>

So via SQL, do something like this, then add your opening and closing SEGMENT and SEGMENTS:

select ‘  <MEMBER field=”SCT.ID”>’ || SPRIDEN_ID || ‘</MEMBER>’ from spriden where CONDITIONs…

Finally, if it’s a group that needs to be added regularly, write some SQL, name the group and add it to wokscad.P_GenerateTargetedGroups.  It will be added to our Luminis instance once a week on Tuesday mornings.