Write data back to the database via a webform

VisionBI | Jurgen shared this idea 6 years ago
Not Planned

Users are hooked to Excel to keep data and alter it. But why not maintain that data in Yellowfin? For instance a salesbudget of store information. When it's possible to insert/update/delete the data in a table via a webform, then there is less need for Excel sheets.

For instance via this: https://fancygrid.com/samples/edit/form


Maybe it could be integrated in the new 7.4 ETL module as a webform component?

Replies (7)

photo
1

Thanks for the feedback Jurgen. hope you had a good weekend!


I hear what you're saying, and something that has been discussed in the past. Unfortunately at this point in time YF will remain to focus on BI reporting, and not delve to deep into data manipulation.

We have just got our toes wet with the new Data Transformation, and something we will continue to invest time in, though no plans to manipulate existing data directly.

...if we do get more of a demand for this, we will definitely revisit.


Sorry for the bad news on this!


Regards,

David

photo
2

Hi David,


thank you for your reply. I hope it gets enough votes :-)

I was hoping this was easy to integrate with the new Data Transformation option within Yellowfin 7.4, it would really be something that makes Yellowfin unique.


Maybe third parties are able to build such a feature?


Regards,

Jurgen

photo
1

"Maybe third parties are able to build such a feature?"


Yes we can help.

We are open to be hired for such task.

photo
photo
1

I am CTO at FancyGrid.

For us it would very pleased to have such cool client as Yellowfin.

photo
1

David,

This has not been addressed in 6 years. Is this still not planned? In fact, I believe with the Yellowfin 8.0 release it was possible, just not native. Let me ask it this way.. I have had a couple of users ask if there is a way to add a note to a table or a checkbox to address issues.


Thanks,
Zack

photo
1

Hi Zack,

I hope all is well,

From what I can see this did not move forward with getting said Idea implemented. Going forward let me discuss this with the wider team to see if there is any updates.

Regards,

Mark

photo
1

Hi Zack,

I hope all is well,

I have since discussed this with the wider team here at Yellowfin, from what we discussed we very much doubt said feature will make it to Yellowfin (as David stated), however, we have seen some clients implement something similar by building their own web form, and calling that using a custom url.

This can be enabled in a report by formatting a column as a link to url or even an action button; https://wiki.yellowfinbi.com/display/yfcurrent/Column+Formatting#ColumnFormatting-Actionbuttonformattersettings

The url can include values from the report row that is clicked, of which you can have a button that says "update" or "add a note" or something along the ideas of that. By doing this, the client is then in control of coding safely the update to their data, including confirming any security the user would be required to have.

In addition Zack, it might also be possible to build a write back using code mode on a Dashboard but I suspect that is probably overkill for this requirement.

Let me know your thoughts on this.

Regards,

Mark

photo
1

Hi Zack,

I hope all is well,

I just want to touch base to see if you had chance to read through my last response. In addition we can see that Jurgen has since implemented a way of doing this.

Regards,

Mark

photo
1

Hi Zack,

I hope all is well,

I just want to touch base to see if you've had chance to read through my updates on what options we have, if you can get back to me that would be great.

Regards,

Mark

photo
1

I suppose I will have to go down the route of figuring it out via web form or something.


Thanks,

Zack

photo
photo
1

Hi Zack,

I hope all is well,

I just want to touch base to see if you had chance to read through my previous response, if you could get some feedback back to me, that would be great.

Regards,

Mark

photo
1

Hi Mark,

this is an old ticket, since we have developed our own Excel import module, it's build in Code Mode.
A user can upload Excel files, specify the columns, etc. and Import/Append the files when they want from a dashboard.

So we made our own fix for this.


Regards, Jurgen

photo
1

Hi Jurgen,

Thank you for updating us with where you stand and for informing us that you have since been able to achieve desired results.

Regards,

Mark

photo
Leave a Comment
 
Attach a file