Writing to external database

[Prachi]

Hi, I want to write information from my WI form to an external database at the end of each process. I have SEC connectors and retrieving and inserting data to external database works through connector test window.

How can I send variables from my WI to this connector? I'm not sure if I can achieve this by including this connector in API listener or by calling the connector from the process?

Thanks!

Prachi
--


teknion.com <http://www.teknion.com>

<http://www.teknioncre8.com/> <http://www.facebook.com/Teknion>
<http://www.linkedin.com/company/teknion> <http://twitter.com/teknion>
<http://www.youtube.com/teknion>

Please consider the environment before printing this e-mail.

CONFIDENTIALITY NOTICE: This communication, including any attachments, may
contain information that is confidential and privileged. [It may constitute
non-public information and is intended to be conveyed only to the
designated recipient(s).] If the reader or recipient of this communication
is not the intended recipient, or you believe that you have received this
communication in error, please notify us immediately by return e-mail and
promptly delete this e-mail including any attachments without reading or
saving them in any manner. Any other distribution, copying or disclosure is
prohibited and may be unlawful. We accept no responsibility for changes
made to this e-mail or to any attachments after transmission from our
office.

[Takafumi Hoshino]

Hi,

"At end of each process" sounds like it should be in process.
Process is better also in case call fails, you can restart easily.

You should have a restart-point (where output script is empty) before
the connector activity.

Best regards,

Taka

Sent from my iPhone

> --
> Fujitsu - RunMyProcess
> ---
> You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
> To post to this group, send email to suppor...@runmyprocess.com.
> Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
> To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/5eec5aa6-34df-4ce3-b26a-e2e74b5bfc86%40runmyprocess.com.
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Prachi Raibagi]

Hi Taka,

Thanks for your fast response. What do you mean by output script is empty? 

I am calling the connector in the process and I've included WI variables I want to write to db under 'input variables'. The call to connector is successful in process report but its not writing any data to the database. I'm using the variables I'm passing to connector in mysql statement. Is that correct?

Prachi

On Fri, Feb 13, 2015 at 10:18 AM, Takafumi Hoshino <thos...@runmyprocess.com> wrote:

Hi,

"At end of each process" sounds like it should be in process.
Process is better also in case call fails, you can restart easily.

You should have a restart-point (where output script is empty) before
the connector activity.

Best regards,

Taka

Sent from my iPhone

> On Feb 13, 2015, at 7:08 AM, Prachi <prachi....@teknion.com> wrote:
>
> Hi, I want to write information from my WI form to an external database at the end of each process. I have SEC connectors and retrieving and inserting data to external database works through connector test window.
>
> How can I send variables from my WI to this connector? I'm not sure if I can achieve this by including this connector in API listener or by calling the connector from the process?
>
> Thanks!
>
> Prachi
> --
>

>

> Please consider the environment before printing this e-mail.
>
> CONFIDENTIALITY NOTICE: This communication, including any attachments, may
> contain information that is confidential and privileged. [It may constitute
> non-public information and is intended to be conveyed only to the
> designated recipient(s).] If the reader or recipient of this communication
> is not the intended recipient, or you believe that you have received this
> communication in error, please notify us immediately by return e-mail and
> promptly delete this e-mail including any attachments without reading or
> saving them in any manner. Any other distribution, copying or disclosure is
> prohibited and may be unlawful. We accept no responsibility for changes
> made to this e-mail or to any attachments after transmission from our
> office.
>
> --
> Fujitsu - RunMyProcess
> ---

> You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.

> To post to this group, send email to suppor...@runmyprocess.com.
> Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
> To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/5eec5aa6-34df-4ce3-b26a-e2e74b5bfc86%40runmyprocess.com.
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--
Fujitsu - RunMyProcess
---

You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/lNzNlOWpMrU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/3794336930256451723%40unknownmsgid.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

teknion.com

        

[Takafumi Hoshino]

Hi,

The "output empty" thing is to prepare for production errors, if any.

Supervisor can restart process instance from any point in process. If the activity restarting at has some scripts in output variables, then it will error immediately and not move forward.

You can avoid this by making an empty activity, so there is zero chance that output variable will abort with error.

Then to your question.

Does your process complete? (green status)

But you don't see any data database?

You have to check from bottom up.

Check process instance variables, test your Connector with the same variables, then test your activity (restart process instance there), then test end to end.

Best regards,

Taka

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B8z3pzbnTg2bnot_hD3whpf9Jzz6c9RoHmidabLNKPCcWNrMA%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

---------------------------------------------------

Taka Hoshino

Fujitsu RunMyProcess

+1-(408)-940-6873

Google Account: thos...@runmyprocess.com

<Sent from Gmail web client>

[Prachi Raibagi]

Hi Taka,

Thanks, I'm testing the way you suggested. Seems like my WI variable values are not being passed on to the connector. I know variables I'm passing in the process are correct because the same variables are working in custom report. 

I assigned default values to the variables for testing purpose. I'm using ${variable} to get variable value in connector but it's not retrieving the value. How can I test if the variable is being sent to the connector?

Prachi

On Fri, Feb 13, 2015 at 11:25 AM, Takafumi Hoshino <thos...@runmyprocess.com> wrote:

Hi,. 

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAEYDksgWAtnksEdfLaXU8uc9PnKerApPRKDsnPAK_-_g1NcTTg%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Takafumi Hoshino]

Hi,

You can test the Connector itself.

In Connector configuration screen (where you make the connector), there is "Launch Test" button, and it should show you all the variable that it accepts, and you can test.

Make sure this works.

Making sure this works means, when you execute this, it does not give any error.

When connector is executed, SEC manager should show a log about the request.

And data is written to you database.

Best regards,

Taka

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B8z3pxdUXHxvGR9W448a0hNyft0ZysnXtmfZHAUdZiYtFA-gA%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.