Working with DDS history

Data Delivery Service (DDS) provides a history of objects that were exported, when and how the data was exported, and if there were any errors.

DDS history is a log of all DDS activity with comprehensive job details. The details can include a list of files, the number of new, updated, and deleted objects, and whether or not the delivery encountered errors.

Job history

There are two sections of DDS history:

  • Job history: provides a list of jobs run on DDS along with a brief description of each.
  • Service history: provides details of the job, including the file names and the number of new, changed, and deleted objects.

To view the history for a delivery, follow these steps:

  1. Go to Company > Setup > Data Delivery Service.
  2. Select History.
  3. Review the list of jobs queued for DDS. The following details are shown for all items.
    DDS job queue details
    Job queue detailDescription
    RuntimeThe time and date that DDS was run.
    TypeWhether the run was Auto (a scheduled run) or Manual (an on-demand run).
    NameIf this delivery is scheduled, the schedule name appears here.
    ObjectsThe number of objects that were included in the run.
    StatusThe job status. Values are Processing, Completed, and Failed.
    ErrorsShow the number of errors (if any) that occurred during the run.
  4. Select View next to a job to review the details about the run. The Service history page provides a more detailed look at a DDS delivery job.
  1. Go to Company > Setup > Data Delivery Service.
  2. Select History.
  3. Review the list of jobs queued for DDS. The following details are shown for all items.
    DDS job queue details
    Job queue detailDescription
    RuntimeThe time and date that DDS was run.
    TypeWhether the run was Auto (a scheduled run) or Manual (an on-demand run).
    NameIf this delivery is scheduled, the schedule name appears here.
    ObjectsThe number of objects that were included in the run.
    StatusThe job status. Values are Processing, Completed, and Failed.
    ErrorsShow the number of errors (if any) that occurred during the run.
  4. Select View next to a job to review the details about the run. The Service history page provides a more detailed look at a DDS delivery job.

Filter your history

You can use the Advanced Filters option at the upper right of the page to quickly find an item. Applying a filter typically reduces the number of items in the list.

  1. Go to Company > Setup > Data Delivery Service > History.
  2. Select the Advanced filters link.
  3. Choose a column name from the dropdown menu to use with the filter.
  4. Choose an operator from the dropdown menu, such as "starts with," "equals," "contains," and so on.
  5. Add a value to the value field.

    The value can be a number or a string of text depending on the selected operator. If you chose Includes or Excludes, use a comma-delimited list of numbers or text strings.

  6. Optionally, select the Add filter to add another filter.
  7. Select Apply to apply the filter.
  1. Go to Company > Setup > Data Delivery Service > History.
  2. Select the Advanced filters link.
  3. Choose a column name from the dropdown menu to use with the filter.
  4. Choose an operator from the dropdown menu, such as "starts with," "equals," "contains," and so on.
  5. Add a value to the value field.

    The value can be a number or a string of text depending on the selected operator. If you chose Includes or Excludes, use a comma-delimited list of numbers or text strings.

  6. Optionally, select the Add filter to add another filter.
  7. Select Apply to apply the filter.

Export the history record

You can export a list of the delivery history from the History page.

  1. Go to Company > Setup > Data Delivery Service > History.
  2. In the upper left of the page, select Export.
  3. Choose the format in which to save or view the history: CSV, Word, Excel, or PDF.
  1. Go to Company > Setup > Data Delivery Service > History.
  2. In the upper left of the page, select Export.
  3. Choose the format in which to save or view the history: CSV, Word, Excel, or PDF.

Export a single object history

You can export a single object for the History page.

  1. Go to Company > Setup > Data Delivery Service.
  2. Choose Automatic or Manual.
  3. Find the schedule for a scheduled delivery.
  4. Choose the object from the list and select View.
  5. In the upper left of the page, select Export.
  6. Choose the format in which to to save or view the history: CSV, Word, Excel, or PDF.
  1. Go to Company > Setup > Data Delivery Service.
  2. Choose Automatic or Manual.
  3. Find the schedule for a scheduled delivery.
  4. Choose the object from the list and select View.
  5. In the upper left of the page, select Export.
  6. Choose the format in which to to save or view the history: CSV, Word, Excel, or PDF.

Service history

The service history contains details about a particular delivery. To view the details of a delivery, follow these steps:

  1. Go to Company >  Setup > Data Delivery Service.
  2. Select History.
  3. Select View next to a job to review the following information.
    DDS run section column descriptions
    ColumnDescription
    Run timeShows the job title, data, and time it was run
    TypeWhether the job was a scheduled or manual delivery
    StatusQueue status: In queue, Processing, Completed, or Failed
    Total errorsA link to any errors encountered during the job
  1. Go to Company >  Setup > Data Delivery Service.
  2. Select History.
  3. Select View next to a job to review the following information.
    DDS run section column descriptions
    ColumnDescription
    Run timeShows the job title, data, and time it was run
    TypeWhether the job was a scheduled or manual delivery
    StatusQueue status: In queue, Processing, Completed, or Failed
    Total errorsA link to any errors encountered during the job

View the job information

You can review the following details about a job in the DDS run section.

Job details column descriptions
Column Description
DDS Job Job title, data, and time it was run.
Object Objects included in the job.
Type

Job types:

  • All: complete records

  • Changed: records that have been changed after the last time that the data was exported.
New objects Number of new objects in the run.
Updated objects Number of updated objects in the run.
Deleted objects Number of objected deleted from the existing data.
Status

Queue status:

  • In a queue

  • Processing

  • Completed

  • Failed
Error Link to any errors encountered during the job
File list List of all the files that were packed up and added to the queue. For multiple objects, the file is a compressed (.zip) file. For single objects, you see the individual file name. If there are multiple files, Intacct displays all files

Find file names

The following task shows you how to find the names of files included in a delivery.

  1. View the history for that job: Company > Setup > Data Delivery Service > History.

  2. Select the job and then select View.

In the DDS jobs section, the rightmost column shows a list of all the files included in the delivery. If you enabled file naming indicators, the file names include the type of change: created, updated, or deleted.

Next steps