• All Files

    Export/Import Step

    The Export/Import step is mainly used to run functions in an end-system after exporting data to this end-system. The data that results from the function run is returned to the Schema table. For Microsoft Exchange 2016, IConduct allows tacking user availability at a specific time.

     

    To create the Export/Import step, navigate to Interfaces> {Specific Interface}> Tasks> {Specific Task}> Steps >New >New Export/Import Step.. For more information about steps, see Defining Steps

     

    To manipulate your data, follow the steps below:

    1. Select your target connection from the Connection drop-down list.
    2. Select the required function from the Function drop-down list.
    1. Using the Action drop-down list, choose the action you want to perform.
    • Insert: Put data into the schema.
    • Update: Add the latest data to the existing schema fields.
    • Delete: Delete data from the schema.
    • Upsert: Select to either update or insert rows of data depending upon whether a specific set of conditions are met (or not).

    Note: On selecting Update, Delete, Upsert from drop-down list, the Schema Column and Source Column appear. These fields associate a specific field in the source system to a specific field in the Schema. The rows from the source system will Update/Delete or Upsert rows in the Schema based on this association. Select required columns to enable automatic updates.

    1. Once done, press Create and proceed with mappings.

    Warning: For appropriate function execution and accurate data on user availability, make sure to map corresponding Schema columns to the TimeEnd, TimeStart and UserMail target columns in Export Mappings. The function result for user availability appears in the BusyStatus field of the Import Mappings.