AnsweredAssumed Answered

Import/export users/groups

Question asked by srowsell on May 6, 2014
Latest reply on May 7, 2014 by srowsell
I'm trying to be able to export my datalist to .csv.  I have a specific solution already built as a web script (though I'm finding a more general solution troublesome), but for now specific will do.  The problem is that two of the properties of the datalist are a group and user (respectively) as can be seen from the excerpt from the model at the end of this post.  The "recipientUser" and "recipientGroup" properties work just fine in the datalist, but don't know how to export or import values for them which can be stored in a .csv file.

Any thoughts?


<types>
   <!–   Data list defintions For this model go here –>
   <type name="reportdl:reportRecipientsDatalist">
      <title>Reports Data List</title>
      <description>Report Recipients Data List</description>
      <parent>dl:dataListItem</parent>
      <properties>
         <property name="reportdl:department">
            <title>Department</title>
            <type>d:text</type>
            <mandatory>true</mandatory>
            <constraints>
               <constraint ref="reportdl:departments" />
            </constraints>
         </property>
         <property name="reportdl:reportName">
            <title>Report Name</title>
            <type>d:text</type>
            <mandatory>true</mandatory>
         </property>
         <property name="reportdl:uniqueIdentifier">
            <title>Report Unique Identifier</title>
            <type>d:text</type>
            <mandatory>true</mandatory>
         </property>
         <property name="reportdl:frequency">
            <title>Report Frequency</title>
            <type>d:text</type>
            <mandatory>true</mandatory>
            <constraints>
               <constraint ref="reportdl:frequencies" />
            </constraints>
         </property>
         <property name="reportdl:suffix">
            <title>Suffix</title>
            <type>d:text</type>
            <mandatory>false</mandatory>
         </property>
      </properties>
      <associations>
         <association name="reportdl:recipientGroup">
            <title>Recipient Group</title>
            <source>
               <mandatory>false</mandatory>
               <many>true</many>
            </source>
            <target>
               <class>cm:authorityContainer</class>
               <mandatory>false</mandatory>
               <many>true</many>
            </target>
         </association>
         <association name="reportdl:recipientUser">
            <title>Recipient User</title>
            <source>
               <mandatory>false</mandatory>
               <many>true</many>
            </source>
            <target>
               <class>cm:person</class>
               <mandatory>false</mandatory>
               <many>true</many>
            </target>
         </association>
      </associations>
   </type>
</types>

Outcomes