PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/21/2015 10:02 AM by  Dave Curtis
Smart Note with CSV file
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
brainet
Private
Private
Basic Member
(48 points)
Basic Member
Posts:18


Send Message:

--
03/16/2015 2:20 PM
    I am wanting to setup a Smart Note with a dataset of selected records and a second one that is from a csv file. The csv file will have the different email address I want the SN to go to. How would I tied the two infosets together where each record in the first infoset could be sent to each of the email address in the second infoset? I am trying to just change the csv file and not have to remove and add new devices when a person leaves the company.:D
    The.Sam.Groves
    Programmer Analyst
    St Lukes Hospital
    Veteran Member
    (265 points)
    Veteran Member
    Posts:89


    Send Message:

    --
    03/16/2015 3:46 PM
    If you are bursting, and assuming that both infosets can be tied together, then when you set up the infoset based on the csv file, make sure the field you are correlating against on the csv file is marked as "Burst On" and has a category assigned to it.

    On the actual data infoset, also ensure the field you are correlating against is set up with the same category as it's mate in the CSV file.

    Once you've done that, if you set up a notification using the data infoset, you should be able to go to the Delivery step, switch to the Bursting tab, and select the approrpriate choices in the first two fields to pick your data infoset's correlation field. In the third field, select "Looking up address in an Infoset" and that should unhide a field where you can select your CSV infoset.
    Dave Curtis
    HRIS Lead
    University of Maryland Medical System
    Veteran Member
    (292 points)
    Veteran Member
    Posts:102


    Send Message:

    --
    03/21/2015 10:02 AM
    I toyed with doing this but decided to go a differnt route. I use an employee group to control who gets certain smart notes. That way I can build the group so when someone is no longer active or in the specific jobs that need the notice, they just fall out of the group ( no maintenence needed ).

    I tie the group into the SQL that is pulling the data.
    You are not authorized to post a reply.