<p>Cloudstreet Portal works by accepting XML documents from an external source then importing them into the CloudStreet Portal database. Access to the documents is controlled via a security mechanism known as subscriptions. An export of the subscriptions table will provide you with the information necessary to determine which documents should be uploaded to the web site as users register for the site. By uploading only the documents to which users are subscribed, you can determine which documents to send to CloudStreet Portal. The other approach is to begin sending all documents and then review subscriptions to determine which documents can be removed from CloudStreet Portal. The choice is up to you.</p>
<p><strong>The Procedure</strong></p>
<ol>
<li>You must be a site administrator to perform this function.</li>
<li>Login to your CloudStreet Portal web site</li>
<li>Choose Site Administration > Site-Wide Subscriptions from the menu</li>
<li>At the top of the subscriptions list page, you will see a toolbar</li>
</ol>
<p><img src="/images/cloudstreet/Help/subscriptions_list2.PNG" width="75%" /></p>
<p>The <img src="/images/cloudstreet/Help/subscriptions_csv.PNG" alt="" />button will export the selected scriptions to excel and allow you to download the list.</p>
<p><img src="/images/cloudstreet/Help/export_CSV.PNG" width="391" height="274" /></p>
<p> <img src="/images/cloudstreet/Help/subscriptions_save.PNG" width="540" height="403" /></p>
<p>Once it opens in excel, the data may be explored but it may open all in one column instead of broken into individual columns like this:</p>
<p><img src="/images/cloudstreet/Help/subscriptions_inexcel.PNG" width="75%" /></p>
<p> In excel, you can break the data into individual columns by <strong>selecting column A</strong> (where the data is stored), then choosing the <strong>Data</strong> menu then <strong>Text to Columns</strong>.</p>
<p><img src="/images/cloudstreet/Help/excel_textToColumns.PNG" width="50%" /></p>
<p>Choose the <strong>Delimited</strong> option then press <strong>Next</strong>.</p>
<p><img src="/images/cloudstreet/Help/subscriptions_delimiter.PNG" width="50%" /></p>
<p>Press Finish and the data will be broken into individual columns.</p>
<p>A program can be written to parse this CSV output then to compare it with the the controls on the ERP server the determine which division, document type and customers should have their documents uploaded to the cloudstreet portal server.</p>
<h2>Another use for Subscriptions Export</h2>
<p>Another use for this export would be as a feed for a bulk mail or email system. You can extract the required information to generate outbound messages using the site email tool or another tool of your choosing.</p>
<p> </p>