Part 4: Export Data

From AgileApps Support Wiki
Revision as of 11:15, 14 December 2022 by Wikieditor (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

In this part of the exercise you export the test Order and Line Items records you created during the previous exercises in this course.

  1. Navigate to Configuration > Administration > Data Management > Export Data.
  2. On the Export Data page:
    1. Specify/check your email address.
    2. Uncheck Include All Data.
    3. Check the Orders and Line Items checkbox.

      Export Data Orders Line Items.PNG

    4. Click Save. A success message appears:

      Export Status.png

  3. To navigate to the Export Queue, select Configuration > Administration > Monitoring > Export Queue. 
  4. Check your email inbox for the status update.

    Db backup.PNG

  5. Click on the Export Data Zip File link in the email. Depending on your local configuration, the zip file will be opened or downloaded using a zip archive tool (for example, 7-Zip).

    Db backup files.PNG<

  6. To open the file in Microsoft Excel:
    1. Extract the Order.csv file from the zip file to your local file system.
    2. Start Microsoft Excel (the following instructions assume you have MS Excel 2010 installed).
    3. In Microsoft Excel, on the Data tab, click the From Text option.
    4. Navigate to your extracted Order.csv file and click Import.
    5. In the Text Import Wizard, select Delimited and click Next. Select Comma for the Delimiter and click Finish.

      Text Import Wizard.PNG

      Orders CSV.PNG

      This file can be used as a source to generate records for import back to a webMethods AgileApps Cloud Object.

Previous

Next