Skip to main content
New Idea

Update Field Names in S3 Export When Changed

Related products:CS Rules Engine
samantha_braastad
sagan_sherlin
Ravinder Singh
  • samantha_braastad
    samantha_braastad
  • sagan_sherlin
    sagan_sherlin
  • Ravinder Singh
    Ravinder Singh

bradley

Here’s the basic issue: Changing the field name/label/display of a field does NOT change what is exported in S3 in Horizon Rules.

 

Basic ask: Allow for field name changes to be reflected in S3 export.

 

Additional context:

You have a transformation task off of which you have an S3 export. You create a field on that transformation task and need to change the name after creating it. Regardless of if you change the label or display name, the original field name will always show. Renaming and resaving your tasks doesn’t help. It will only update how it is shown in the rule, not in the export of the data itself.

 

A suggestion from support was to build an action off of the task and see if that helps. Unfortunately that’s not currently how S3 exports work (plug for this: 

https://communities.gainsight.com/fid-183/tid-15347

)

so that isn’t helpful.

 

The existing workarounds are essentially to:

  • Never need to change the name in the first place
  • Delete any impacted fields and re-add them with new names before saving the task
  • Possibly adding extra unnecessary tasks, changing the names before saving the step and then exporting off of that

 

None of those workarounds are a particularly great or intuitive user experience, especially if you’re adjusting an already in place rule. Not to mention troubleshooting gets interesting if your file headers don’t match any of your field names.

10 replies

jordan_cook
Forum|alt.badge.img+2
  • Contributor ⭐️⭐️⭐️⭐️
  • 45 replies
  • June 22, 2023

I thought the community site was for ideas and enhancements and such. This 100% feels like a product defect. You would have to work really hard, and have some compelling arguments to make me believe that this is truly intended behavior. If you rename a field in the dataset, it should absolutely also carry that name forward to the export of that same dataset.

Again, this is a bug, not an “idea”.

I only landed on this page because I finally logged this as a ticket after suffering with the workarounds for a really long time, and finally deciding to log a defect. Then the support team closed my support case, and sent me here to upvote this enhancement request.


alizee
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 655 replies
  • June 26, 2023

🤔


shambhawi
Forum|alt.badge.img
  • Gainsight Employee ⭐️
  • 71 replies
  • July 13, 2023

Thanks for this feedback @bradley and really  sorry for the inconvenience @jordan_cook.

I have shared this feedback with my team and will soon get back to you on the ETA for this.


romihache
Forum|alt.badge.img+8
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 424 replies
  • July 17, 2023
bradley wrote:

Here’s the basic issue: Changing the field name/label/display of a field does NOT change what is exported in S3 in Horizon Rules.

 

None of those workarounds are a particularly great or intuitive user experience, especially if you’re adjusting an already in place rule. Not to mention troubleshooting gets interesting if your file headers don’t match any of your field names.


Haha, I submitted a very similar idea as I missed this one somehow. I said the same with different words 
“If you were to troubleshoot something in the future, basically you have to guess which column in the exported CSV you are looking at if at any point in time the Display Name was updated.”
 

​​
 

 Thanks for sharing @bradley !

 


rachelhibbardtmo
Forum|alt.badge.img+7
  • Contributor ⭐️⭐️⭐️⭐️
  • 45 replies
  • January 11, 2024

Phew found an annoying, but not too bad workaround! I made all my name changes, then did a transformation, literally made 0 changes, and enabled the export from this additional step, and voila the field names are respected. 

I fell into this trap because I was exporting a lot of picklist values and Gainsight defaults to exporting the gsid behind every picklist value and forces you into a weird duplicate the field to save it as a string if you want what most people would consider to be the “value”. But make sure the names unique before you try to and delete the original field so you don’t accidentally delete both when trying to get back to exporting this single field in your experience to get the picklist “label” too! If you use your final, desired display name on the gsid field, then you are out of luck getting the correct .csv column header without a complete rebuild or this transformation hack.

Overall, +1,000 on this being a very frustrating and unacceptable experience.


anirbandutta
Forum|alt.badge.img+2
  • Expert ⭐️
  • 1804 replies
  • January 23, 2024
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

christopher_sanderson
Forum|alt.badge.img+3

Bumping up the need for this to be addressed. We have lots of exports that are going to be impacted by transitioning from Bionic to Horizon rules. The receiving teams do not have bandwidth to update import scripts and we don’t have bandwidth to mess with rules to make them work this very narrow way.


amanda.caldwell
Forum|alt.badge.img+3
  • Contributor ⭐️⭐️⭐️
  • 22 replies
  • July 9, 2024

Um, this is a gap in functionality after the move to Horizon rules. Please fix this! I ran into several issues trying to replace an old rule to export a file to S3. We work with automation teams that have already configured their systems to pull in files w/ field names. 

Why does this screen say “Field Display Name” if it’s not going to display the names listed here? This is incorrect.

PLEASE FIX THIS ASAP!

 

 

 


Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • 17 replies
  • September 26, 2024

I just encountered this product defect today. This is so frustrating :(

When will this be fixed @shambhawi 


shambhawi
Forum|alt.badge.img
  • Gainsight Employee ⭐️
  • 71 replies
  • September 27, 2024

@Dheepak G Could you provide an update on this ? 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings