Add ability to select header row from S3 ingest
None
Use case: I have an external application that I want to integrate with Gainsight. It produces a flat file that I want to import into Gainsight MDA. It's produced in a standard format, but contains some summary data in the first few rows (eg, report name, date, etc.) that I cannot remove. The actual data begins on row X, and is properly structured with uniform headers. If this were a 1 off upload I could easily remove the few extra rows. However, to set up a proper integration, I need to specify the row that contains column headers so that the data can be read on an ongoing basis. Currently this is possible in either the managed S3 bucket or the S3 Bionic Rule import feature.
At a very minimum, I'd recommend upgrading the error alert that's thrown when headers are not recognized in the source file (from S3 Bionic Rule) as it is not human readable and requires a support touch to decipher.
At a very minimum, I'd recommend upgrading the error alert that's thrown when headers are not recognized in the source file (from S3 Bionic Rule) as it is not human readable and requires a support touch to decipher.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
I agree it can be painful to few rows every time you do an S3 ingest.
"Selecting the header row" during S3 ingest in Bionic Rules is one of the features on our roadmap but not yet prioritized .
I will keep you updated on the same.
Any more movement on this? I have the same problem and would like a solution.
Hi Andrew,
This is on the medium/long-term roadmap and is not prioritized at the moment.
@All Do upvote if you face this challenge as well.