Skip to content

Exporting Projects from Dovico Timesheet

This task will export project information from your Dovico Timesheet account to an XML file.

Settings

Dovico Timesheet Connection

Required
The Dovico Timesheet connection to use. See the Connecting to Dovico Timesheet article if you require more information on how to create/manage connections.

Export Clients

Required
Set to True to include related client records in the exported data.

Export Currencies

Required
Set to True to include related currency records in the exported data.

Export Employees

Required
Set to True to include related employee records in the exported data.

Export Settings

Required
Settings to control whether new, modified or all records will be exported from Dovico Timesheet. The following options are available:

  • Date Created - The date to use when exporting new records. Records created since this date will be exported. The date will update automatically each time the task runs.
  • Date Modified - The date to use when exporting modified records. Records updated since this date will be exported. The date will update automatically each time the task runs.
  • Export New, Modified or All Records - Choose whether the task should export new, modified or all records.

Filters

Optional
Filter the export based on the value of specific fields. Please note that Dovico Timesheet only supports filtering on specific fields. Please refer to this article for details on which fields are supported, and the filter syntax.

Timeout

Optional
The length of time (in seconds) to wait for responses from the Dovico Timesheet API. If not specified, the timeout will default to 100 seconds.

Output File

Required
The name of the file to export the data to. The data will be output in XML format, a sample of which is shown below.

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<Projects xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Project>
    <ID>3363</ID>
    <ExternalID />
    <Created>2023-11-23T17:02:48</Created>
    <Modified>2023-11-23T17:05:39</Modified>
    <Client>
      <ID>923</ID>
      <GetItemURI>https://api.dovico.com/Clients/923/?version=7</GetItemURI>
      <Record>
        <ID>923</ID>
        <Name>ACME Ltd</Name>
        <Abbreviation>ACME</Abbreviation>
        <Contact />
        <Email />
        <Region>
          <ID>0</ID>
          <Name>[None]</Name>
          <GetItemURI>N/A</GetItemURI>
        </Region>
        <Archive>F</Archive>
        <CustomFields />
      </Record>
      <Name>ACME Ltd</Name>
    </Client>
    <Name>IT</Name>
    <Leader>
      <ID>123</ID>
      <GetItemURI>https://api.dovico.com/Employees/123/?version=7</GetItemURI>
      <Name>John Smith</Name>
    </Leader>
    <Description />
    <Status>1</Status>
    <ProjectGroup>
      <ID>0</ID>
      <Name>[None]</Name>
      <GetItemURI>N/A</GetItemURI>
    </ProjectGroup>
    <StartDate>2023-11-23T00:00:00</StartDate>
    <EndDate>2024-11-23T00:00:00</EndDate>
    <ProjectObjective>3</ProjectObjective>
    <BillingBy>1</BillingBy>
    <BillingByProjectRate>0</BillingByProjectRate>
    <FixedCosts />
    <BudgetedHoursType>1</BudgetedHoursType>
    <BudgetedHoursProjectHours>0</BudgetedHoursProjectHours>
    <Currency>
      <ID>-1</ID>
      <GetItemURI>N/A</GetItemURI>
      <Symbol>$</Symbol>
    </Currency>
    <BudgetRateDate>2023-11-23T00:00:00</BudgetRateDate>
    <HideTasks>F</HideTasks>
    <ExpensesBillableByDefault>T</ExpensesBillableByDefault>
    <Linked>F</Linked>
    <MSPConfig />
    <RSProject>F</RSProject>
    <Archive>F</Archive>
    <CustomFields>
      <CustomField>
        <ID>1</ID>
        <TemplateID>114</TemplateID>
        <Name>Sage Project</Name>
        <Values>
          <Value>PROJ0001</Value>
        </Values>
        <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/114/?version=7</GetCustomTemplateURI>
      </CustomField>
    </CustomFields>
  </Project>
</Projects>