- Posts: 11
- Thank you received: 0
Collecting user input
3 months 2 weeks ago #22624
by Neil
Collecting user input was created by Neil
I have a package which I use to process user emails
The package parses "From email" and depending o the value performs data transformation
It is not always possible to do it correctly because email may have multiple "Froms" (When the user forwards it)
So I have created another package where I set "From email" manually using the set variable package action.
So I was wondering if it is possible to show the user the input box and ask the user to enter the value.
Similar to "Ask question package action" but with the input text
The package parses "From email" and depending o the value performs data transformation
It is not always possible to do it correctly because email may have multiple "Froms" (When the user forwards it)
So I have created another package where I set "From email" manually using the set variable package action.
So I was wondering if it is possible to show the user the input box and ask the user to enter the value.
Similar to "Ask question package action" but with the input text
Please Log in or Create an account to join the conversation.
3 months 2 weeks ago #22626
by admin
Mike
ETL Architect
Replied by admin on topic Collecting user input
Hello
Thank you for the feedback.
We will input the box to the next release for you.
Should be ready by the end of the week
Thank you for the feedback.
We will input the box to the next release for you.
Should be ready by the end of the week
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
3 months 2 weeks ago #22630
by admin
Mike
ETL Architect
Replied by admin on topic Collecting user input
Good Evening Neil.
Just letting you know that your suggestion was implemented in the latest release.
(Much earlier than at the end of the week)
Just letting you know that your suggestion was implemented in the latest release.
(Much earlier than at the end of the week)
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
3 months 2 weeks ago #22635
by Neil
Replied by Neil on topic Collecting user input
Thank you for assisting me with this matter
Please Log in or Create an account to join the conversation.
- bruce.gibbins
- Offline
- Platinum Member
-
Less
More
- Posts: 568
- Thank you received: 72
3 months 2 weeks ago #22636
by bruce.gibbins
Replied by bruce.gibbins on topic Collecting user input
Hello Neil. Unless I am misinterpreting your query and BTW, I think the new enhancement from the ETL team is worthwhile I am curious if you had considered using a regular expression in the mail filter FROM field to cater for multiple from domains which could be extended to handle your own end-user domain?
something like...
Something like this will process a message if it comes from
domain1.com or
domain2.com or
our-domain.com
You may also need to include an enhanced filter to manage the "FW:" in the subject line but that depends on your specific processing needs.
Sorry for hijacking the post but was curious as this sounded very similar to what we had to cater for.
Regards
Bruce
something like...
Code:
(?i)((^[a-zA-Z0-9\.\-]+@domain1\.com$|^[a-zA-Z0-9\.\-]+@domain2\.com$|^[a-zA-Z0-9\.\-]+@our-domain\.com$))
Something like this will process a message if it comes from
domain1.com or
domain2.com or
our-domain.com
You may also need to include an enhanced filter to manage the "FW:" in the subject line but that depends on your specific processing needs.
Sorry for hijacking the post but was curious as this sounded very similar to what we had to cater for.
Regards
Bruce
Please Log in or Create an account to join the conversation.
3 months 2 weeks ago #22637
by Neil
Replied by Neil on topic Collecting user input
Thank you for your suggestion but in our case it is not going to work
The logic is based on from domain inside the email text.
It works fine most of the time
A very small number of emails are forwarded multiple times.
"User 1" forwards the Email to "User 2" and "User 2" forwards the Email to "User 3"
For User 1 domain we have Logic 1
For User 2 domain we have Logic 2
For User 3 domain we have Logic 3
But when we have multiple domains inside the email text it is not possible to choose which logic to use automatically
The logic is based on from domain inside the email text.
It works fine most of the time
A very small number of emails are forwarded multiple times.
"User 1" forwards the Email to "User 2" and "User 2" forwards the Email to "User 3"
For User 1 domain we have Logic 1
For User 2 domain we have Logic 2
For User 3 domain we have Logic 3
But when we have multiple domains inside the email text it is not possible to choose which logic to use automatically
Please Log in or Create an account to join the conversation.