Knowledge: Importing Data into a Data Room via Excel
Back
    Title*Importing Data into a Data Room via Excel
    ManualAdministration
    Manual Level TwoData Rooms
    Manual Level ThreeImporting
    Created15/12/2021
    Detail

    Before using this method of data import we recommend talking to Sysero, as we might have other options that suit your requirement. 

    Please do the below steps in a test Data Room first, to make sure any date formats etc. are in acceptable format.

    1. Go to Admin > Data Rooms > Edit Data Room > Advanced Settings > Import Bulk Data.
    2. Download Excel Template.
    3. If document upload is required add another column called (DocumentUNC).  Or if a http link is required as attachment add column (Link).
    4. Populate Data.
    5. Note if DocumentUNC path used it must be accessible by the Sysero server.
    6. Save XLS and upload it on same page as you Downloaded Excel Template from.

    Note:

    • Multiple Repeater Rows : To import multiple values into repeater the import template will create the first set of columns for the first row.  Simply duplicate those columns directly after the first set in same order first set are, but rename the description outside of brackets to identify row number e.g. Repeater2(XMLField1/TextField1).
    • CheckBox Fields : If you had for example choices Example1, Example2 and Example3 and needed to check Example1 and Example3, you would put Example1;Example3 in column.  So the delimeter is a ;.
    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    Back to Top
    View or hide all system messages