topic Re: User Input for a Date: how to show a date widget? in Talend Studio

User Input for a Date: how to show a date widget?

_AnonymousUser — Sat, 16 Nov 2024 12:22:20 GMT

Hello again,
In a job I am developing, the data to be extracted should be filtered according to a "beginDate" and "endDate", which should be provided by the user.
The job is going to be executed as a DOS batch (i.e. outside TOS) so I don't think I can use the prompt option in the context because
it seems it prompts for the date only INSIDE TOS.
So my best option so far seems to be using 2 tMsgbox at the beginning of my Job, asking for BeginDate and EndDate.
The problem is that inserting a date as a String is very error prone, so I would like to have a date widget instead of a simple text window.
Is there a way to obtain that? Is there anyone which has developed a component for this kind of need or knows a good solution for this?
Thanks in advance for any advice
VindalooMan

Re: User Input for a Date: how to show a date widget?

Anonymous — Thu, 16 Feb 2012 11:23:39 GMT

you can use the database function to convert it.

Re: User Input for a Date: how to show a date widget?

_AnonymousUser — Thu, 16 Feb 2012 11:52:27 GMT

you can use the database function to convert it.

Yes, I could... and it will be what I will do together with some sanity check in order to check the correctness of the dates
if nothing better will come out
but allow me to point out that it is not what I asked.
The question is: is there a way (a built-in component or something else) in Talend which allows me to ask the user a date, showing him/her a data widget
(i.e. a calendar like those you can see in any booking web page).
VindalooMan

Re: User Input for a Date: how to show a date widget?

Anonymous — Thu, 16 Feb 2012 12:00:59 GMT

Hi,
To have a date input dialog I think you need to create your own tMsgBox component with an alternative date entering possibility. Maybe someone already made this component, but I couldn't find it in the Talend Exchange.
I think it's not that difficult, it's just that I don't have the time to do it right now.
Regards,
Arno

Re: User Input for a Date: how to show a date widget?

Anonymous — Thu, 13 Sep 2012 13:26:57 GMT

you can use the database function to convert it.

Can you explain that?