Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After you have set up prerequisites in Excel, you can prepare the actual extract.

To prepare the extract:

  1. In Excel, open the main Excel workbook.

...

  1. Image Added
  2. To authorize the extract, provide a valid login username and password.

  3. To filter the extracted data, complete the appropriate extract parameters for each supported object type. Use the specified formats or click the field and select from the drop down list.

...

  1. Image Added
  2. Under Profile, check each field that should be included in the extract.
    A profile is a set of fields to be included in the extract. If the checkbox next to the field is checked, this field will be included in the extract results, if at least one of the extracted objects contains this field.
    If the field is not checked, the column linked with this field will be removed from the extract results.

...

  1. Click Unselect all

...

  1.  to remove all fields from the extract,

...

  1. click Select

...

  1. all to include all fields in the extract.

  2. Select the object type by clicking the appropriate bottom tab. For example, click

...

  1. the Extract SMF

...

  1.  tab.

...

  1. Image Added
  2. Proceed to the steps

...

  1. for creating the extract.