Data stores exercise
- Topics:
- Workfront Fusion
CREATED FOR:
- Beginner
- User
Learn how to synchronize company names between two systems.
Exercise overview
This is the first part of a one-directional synchronization of companies in Workfront and another system. For now, it only syncs between a Fusion data store and Workfront. A table in a data store keeps track of the Workfront ID (WFID) and the company ID in the CSV file (CID) for each company. This allows for a bi-directional synchronization at some point in the future.
Steps to follow
Download the file from Workfront.
-
In the Workfront “Fusion Exercise Files” folder, select “_Companies.csv” and click Document Details.
-
Copy the first ID number from the URL address.
-
In Fusion, create a new scenario named “Using data stores to sync data.”
-
For the trigger module, select the Workfront Download Document module.
-
Set up your Workfront connection and include the document ID copied from the Workfront URL.
-
Name this module “Get companies file.”
-
Now add a Parse CSV module.
-
For the Number of columns field, type 2.
-
Map Data from the Download document module in the CSV field.
-
Name this module “Parse companies file.”
-
Save your scenario and click Run once.
Create a data store and a data structure.
-
Add a data store Search records module.
-
Create a new data store named “Company sync.”
-
Within the data store, create a data structure named “Company sync (struc).”
-
Create four fields.
- CID - The company ID in the CSV file
- Company name
- WFID - The Workfront company ID
- Created date -Make sure that the data type is date
-
Click Save on the data structure, then set the data storage size to 1 and save the data store.
-
Continuing in the Data store module, set up a Filter where the CID is equal to the ID of the company from the Parse CSV module (Column 1).
-
Click Show advanced settings and select the option to “continue the execution of the scenario or the route, even if this module returns with no results.”
-
Rename this module “Matching companies.”
-
Add a Workfront Search records module.
-
Choose Company as the record type.
-
Search criteria is the company name within Workfront is equal to the company name in the CSV file.
-
For outputs, select the company name and the ID.
-
Click OK and rename this module “Matching companies.”
Create different paths based on whether the company exists within Workfront or the data store.
Routing path 1 - Create a company.
-
Add a router module to the right of the Workfront Search records module.
-
Add a Workfront Create Record module to the top path.
-
Set the record type to Company.
-
Select Name from Fields to Map. Map the name field to the output from the Parse CSV module (Column 2).
-
Rename this module “Create company.”
-
Add a filter after the router to only create a company if it’s not already in Workfront. Name it “Not in Workfront.”
-
Set the Condition to the ID from the Workfront Search module and does not exist.
Prepare to update the data store in the next path.
-
Add a Set variable module to the end of the top path.
-
Set the Variable name to “Workfront ID.”
-
Set the Variable value to the ID from the Create company module.
-
Rename this module “Set Workfront ID.”
Routing path 2 - Update the data store.
-
Create a filter on routing path 2. Name it “Not in data store.”
-
Set the Condition to the Key from the Data store module and does not exist.
-
The first module in this path is the Get variable module.
-
Set the Variable name to “Workfront ID.”
-
Rename this module “Get Workfront ID.”
-
Add another module from the Data store app, Add/replace a record.
-
In the Data store field, choose Company sync. This is the data store you created earlier.
-
Leave the Key field blank.
-
Map the CID field from Column 1 in the Parse CSV module.
-
Map the company name field from Column 2 in the Parse CSV module.
-
Map the WFID field from the Get Workfront ID module.
-
For the Created date field, use the formatDate function from the Date and time tab to format the current date as MM/DD/YYYY.
-
Click OK and rename this module “Create company entry.”
Routing path 3-Sync the data store between systems.
-
Start by creating a filter on routing path 3. Name it “Company exists, not in data store.”
-
Set the Condition to the Key from the Data store Search records module and does not exist.
-
Click the Add AND rule button and designate that the company name from the CSV file (Column 2) is equal to the name of the company found in the Workfront Search module.
-
Now add another Add/replace a record module by cloning the one at the end of routing path 2.
-
Drag the cloned module into place at the end of routing path 3. Delete the empty module that was there.
-
Click on the cloned module. All fields should stay the same except the WFID field. Map it from the Matching companies Search module.
-
Click OK and rename this module “Create company entry.”
Workfront
- Workfront Tutorials
- Administration and Setup
- Organizational setup
- Manage deleted items
- Configure system defaults
- Layout templates
- What are layout templates?
- Find layout templates
- Customize terminology with layout templates
- Customize the Main Menu with layout templates
- Add and manage pins through a layout template
- Customize Home with layout templates
- Assign and manage access to layout templates
- Customize object areas with a layout template
- Customize project details with layout templates
- Customize project headers with layout templates
- Customize reporting lists with layout templates
- Email and In App Notifications
- Create and manage users
- Approval processes and milestone paths
- System performance and maintenance
- Project finances
- Custom Data
- Custom Forms
- Calculated expressions
- Get started with calculated fields and expressions
- Learn the data expression structure
- Understand Date & Time and Mathematical expressions
- Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions
- Use the Calculation Editor
- Create DATEDIFF and WEEKDAYDIFF expressions
- Create a SUB, SUM, DIV, or PROD data expression
- Use the CONCAT expression in a calculated field
- Create LEFT/RIGHT expressions
- Use the ISBLANK and CONTAINS expressions
- Create an IF text expression
- Things to know about calculated field expressions
- Manage work
- Projects
- Understand basic project creation
- Navigate the project page
- Learn four ways to create a project
- Fill in the project details
- Get started planning a project
- Take a project live
- Get started managing a project
- Find projects
- Share a project
- Understand the project team
- Understand project communication
- View project information
- Track overall project progress
- Track work progress with project metrics
- Understand the Gantt view
- Understand the Board view
- Tasks
- Issues/requests
- Request queues
- Portfolios
- Approval processes and milestone paths
- Create and manage project templates
- Project timelines
- Close a project
- Project finances for users
- Intermediate projects
- Projects
- Reporting
- Basic reporting
- Understand reporting elements
- Understand reporting components
- Create a basic grouping
- Create a basic view
- Add basic conditional formatting to a view
- Create a basic filter
- Understand the new filter experience
- Create basic filter activities
- Create a simple report
- Create a task report
- Copy a report
- Create reports with charts
- Create a matrix report
- Create dashboards
- Send and share reports
- Understand report settings
- Intermediate reporting
- Create filters with user-based wildcards
- Create filters with date-based wildcards
- Create OR statements in filters
- Understand built-in project filters
- Understand built-in task filters
- Understand built-in issue filters
- Understand basic text mode for filters
- Understand basic text mode for views
- Understand basic text mode for groupings
- Create custom prompts
- Advanced reporting
- Calendar reports
- Basic reporting
- Manage resources
- Workfront Goals
- Workfront Planning
- Integrations
- Adobe Creative Cloud
- Adobe Experience Manager Assets Essentials
- G Suite
- Jira
- Microsoft Outlook
- Microsoft Teams
- Adobe Workfront for Microsoft Teams Overview
- Install Adobe Workfront for Microsoft Teams
- Access Adobe Workfront from Microsoft Teams
- Search for and share Adobe Workfront items in Microsoft Teams
- Create Adobe Workfront tasks from Microsoft Teams
- Submit Adobe Workfront requests from Microsoft Teams
- Manage Adobe Workfront notifications in Microsoft Teams
- Slack
- Fusion
- Welcome to Workfront Fusion
- Understand the basics
- Initial scenario design walkthrough
- Initial scenario design exercise
- Mapping panel and formula editor
- Mapping panel important notes
- Beyond basic mapping walkthrough
- Beyond basic mapping exercise
- Use filters
- Filters walkthrough
- Filters exercise
- Access previous versions walkthrough
- Access previous versions exercise
- Universal connectors and routing
- Universal connectors exercise overview
- Introduction to universal connectors walkthrough
- Introduction to universal connectors exercise
- Understand routers
- Routers walkthrough
- Routers exercise
- Common routing patterns
- Routing patterns walkthrough
- Routing patterns exercise
- Set-it and get-it
- Get/Set variables walkthrough
- Set/Get variables exercise
- Iteration and aggregation
- Execution history and scheduling
- Beyond basic modules
- Data structures and data stores
- Final functional bits and bobs
- Troubleshooting and error handling
- Workfront Fusion administration
- Design optimization and testing
- Workfront Proof
- Learn the benefits of proofing
- Understand the difference between a document and a proof
- Proofing viewers explained
- Administration and setup
- What is an automated workflow template
- Customize proof comment actions
- Customize proof decision options
- Understand email alerts and proof notifications
- Proof roles and email alerts
- Report on proofs
- Set default at risk proof settings
- Set up global proof settings
- Set default proof roles
- Set up proof account default settings
- Settings for proof users
- Upload proofs
- What is a proof version
- Who uploads the proof versions
- Convert a document to a proof
- View and compare proof versions
- Upload a proof version
- Manage proof versions
- Upload a proof of a video
- Upload a proof of a website
- Upload a proof with a basic workflow
- Upload a proof with an automated workflow
- Upload with a drag and drop
- Combine multiple files into a single proof
- Proof workflows
- Review and approve work
- Workfront DAM
- System setup
- Metadata and keywords
- Brand Connect customization
- Workfront DAM user: Contributor
- Understand Workfront DAM as a contributor
- Understand asset management as a contributor
- Understand finding assets as a contributor
- Understand lightboxes as a contributor
- Understand metadata and keyword best practices
- Work with assets as a contributor
- Send a file as a contributor
- Publish assets as a contributor
- Add a Workfront DAM link
- Brand Connect user
- Home
- Agile
- Best Practices
- Agile
- API Explorer
- Business case and portfolio optimizer
- Communication
- Custom forms
- Custom reports
- Dashboards
- Documents
- Filters, views, and groupings
- Job roles
- Layout templates
- Licenses and access levels
- Onboarding and adoption
- Organization units
- Portfolios and programs
- Preview sandbox
- Project, task, and issue preferences
- Project templates
- Proofing
- Request queue
- Resource Planner
- Resource pools
- Scenario Planner
- Schedules
- Statuses
- System performance and maintenance
- Text mode reporting
- Timeline planning and management
- Timesheets and logging time
- Utilization
- Workfront Goals
- Workload Balancer
- Workfront for executives