Update Users via Kickstarter | Community
Skip to main content
D
DawnmarieD
Level 5
February 16, 2021
Solved

Update Users via Kickstarter

  • February 16, 2021
  • 3 replies
  • 897 views

We have about 1000 users in our instance and would like to now add an employee number to each via a "user" custom form. Before I jump over to the Sandbox export the custom form for the correct fields etc. Does anyone know of another or better way to do this or if this can even be done? I saw on the community from 3 years ago this could not be done but so much has changed since then I'm hoping it can be done now.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by RandyRoberts

Kick-start only adds new records (when it works), it does not update existing records. Kick-start is like a Post API call where you add a new record or child-record. What you need a is a Put API call to modify an existing record. This could be done by a developer who is familiar with Workfront's REST API. There really isn't a way to do this directly in Workfront.

3 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
February 16, 2021

Hi Dawnmarie,

You could use our Excel Updater solution to update the specific User info.

Regards,

Doug

D
DawnmarieDAuthor
Level 5
February 16, 2021

Thank you, Doug. Unfortunately, I won't be able to incur additional costs to process this request. I may have to ask users to update it themselves or find a volunteer to enter them manually.

Thank you again for your speedy reply. =D

RandyRoberts
Community Advisor
RandyRobertsCommunity AdvisorAccepted solution
Community Advisor
February 23, 2021

Kick-start only adds new records (when it works), it does not update existing records. Kick-start is like a Post API call where you add a new record or child-record. What you need a is a Put API call to modify an existing record. This could be done by a developer who is familiar with Workfront's REST API. There really isn't a way to do this directly in Workfront.

D
DawnmarieDAuthor
Level 5
March 2, 2021

I appreciate your response. Thank you.

Christina_Jarosz
Christina_Jarosz
Level 9
July 30, 2021

Hey Dawnmarie. I had to backfill a number of projects with a new custom field. Since these projects existed already, I couldn't use a kickstart.

I did find a workaround however, although crude. I created a report and filtered on project # equals xyz or project # equals xyz. I then switched over to text mode and copied the code.

I pasted into excel and used =CONCATENATE to join the first line and project # (user ID in your case). Each new record was a new line. I added an equal number of second lines beneath these records. Then I added a number order to each area. (so each section had lines labeled 1-25). When I chose to sort by that number, it puts them in number order.

OR:1:referenceNumber=408000

OR:1:referenceNumber_Mod=eq

OR:100:referenceNumber=408000

OR:100:referenceNumber_Mod=eq

OR:101:referenceNumber=194500

OR:101:referenceNumber_Mod=eq

OR:102:referenceNumber=402060

OR:102:referenceNumber_Mod=eq

OR:103:referenceNumber=386340

OR:103:referenceNumber_Mod=eq

OR:104:referenceNumber=406653

OR:104:referenceNumber_Mod=eq

OR:105:referenceNumber=388770

OR:105:referenceNumber_Mod=eq

OR:106:referenceNumber=294948

Once those are all segmented in a report, you can mass edit as needed.

    Terms & ConditionsAccessibility statement

    Loading footer...