Banner, Luminis and Imported Groups
This is good thing to know – Banner’s ICGORGMK process creates a file that can be loaded into Luminis as an imported group
- Create a popsel
- Run ICGORGMK using your popsel
- Transfer the resulting XML to a Luminis admin
- Luminis admin runs: “cptool import segment XML_FILE”
- 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.