Challenge

My business data is in spreadsheets, and I need to get it into Workfront.

Solution

Scheduled Excel Updater is one of the components offered by AtAppStore to help Workfront customers achieve cost effective integrations of Workfront with their existing systems (see our Workfront Integrations page). Most often, our customers use Scheduled Excel Updater in conjunction with AtAppStore’s SQLtoXLS.

Perhaps your business systems can export files to Excel. Perhaps you are using AtAppStore’s SQLtoXLS to export Excel spreadsheets.

Instead of having a person manually use AtAppStore’s Excel Updater, the Scheduled Excel Updater scans a source folder that you specify and automatically pushes any XLS or XLSX files into the Excel Updater on your behalf. As each file is processed, it is moved into a “Success” or “Error” folder, as appropriate. The results of processing each file are also recorded to the Windows Event Log.

Frequently Asked Questions

Q: How do I configure the Scheduled Excel Updater?
A: When Scheduled Excel Updater runs, it reads a text configuration file. This file specifies the source folder, “success” and “error” folders, as well as encrypted userid/password information.

Q: Can Scheduled Excel Updater process multiple spreadsheets in each run?
A: Yes.

Q: How do I configure Scheduled Excel Updater to be the scheduled?
A: The easiest way is to use Windows Task Scheduler to run Scheduled Excel Updater on whatever schedule your organization requires. There are numerous other commercial and free alternatives available that could be used instead.

Q: What operating systems are supported?
A: Microsoft Windows 7, Server 2008, Server 2008 R2. Requires .Net 3.5 or newer.

Screenshots

Scheduled Excel Updater is a console-based application. There are no screenshots.

Pricing

  • Contact us for details.

Related Products

Excel Updater

How do I import from Excel into Workfront? I have data in other business systems that I need imported into Workfront. I can generate Excel reports. A full data integration is overkill. Importing from Excel into Workfront seems like the simplest approach.
$0.50/Item

Excel Updater Generator

To generate an Excel file with a PROJECTS/TASKS/ISSUES/etc Tab that defines all core and Custom Parameter fields in a given Workfront Category for use in the Excel Updater AtApp.
Free