Difference between revisions of "Part 4: Export Data"
From AgileApps Support Wiki
Wikieditor (talk | contribs) |
Wikieditor (talk | contribs) |
||
Line 16: | Line 16: | ||
## In the '''Text Import Wizard''', select '''Delimited''' and click '''Next'''. Select '''Comma''' for the '''Delimiter''' and click '''Finish'''.<br><br>[[File:Text_Import_Wizard.PNG|800px]]<br><br>[[File:Orders_CSV.PNG|800px]]<br><br> | ## In the '''Text Import Wizard''', select '''Delimited''' and click '''Next'''. Select '''Comma''' for the '''Delimiter''' and click '''Finish'''.<br><br>[[File:Text_Import_Wizard.PNG|800px]]<br><br>[[File:Orders_CSV.PNG|800px]]<br><br> | ||
##: This file can be used as a source to generate records for import back to a webMethods AgileApps Cloud Object. | ##: This file can be used as a source to generate records for import back to a webMethods AgileApps Cloud Object. | ||
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |||
:{| border="0" align="left" cellpadding="5" cellspacing="1" | |||
| | |||
[[Part 3: Create a Dashboard|Previous]] | |||
|} | |||
:{| border="0" align="right" cellpadding="5" cellspacing="1" | |||
| | |||
[[Exercise 10: Using Packages for Deployment|Next]] | |||
|} |
Latest revision as of 11:15, 14 December 2022
In this part of the exercise you export the test Order and Line Items records you created during the previous exercises in this course.
- Navigate to Configuration > Administration > Data Management > Export Data.
- On the Export Data page:
- To navigate to the Export Queue, select Configuration > Administration > Monitoring > Export Queue.
- Check your email inbox for the status update.
- 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).
< - To open the file in Microsoft Excel:
- Extract the Order.csv file from the zip file to your local file system.
- Start Microsoft Excel (the following instructions assume you have MS Excel 2010 installed).
- In Microsoft Excel, on the Data tab, click the From Text option.
- Navigate to your extracted Order.csv file and click Import.
- In the Text Import Wizard, select Delimited and click Next. Select Comma for the Delimiter and click Finish.
- This file can be used as a source to generate records for import back to a webMethods AgileApps Cloud Object.