Qdabra qRules

Re: Submit to DBXL

Catharine — Fri, 21 May 2010 15:14:18 GMT

New version received. Submit now working.

Thank you!

Catharine

Re: Submit to DBXL

Catharine — Thu, 20 May 2010 16:20:43 GMT

No I haven't received anything... Hilary has had problems sending me stuff in the past.

Even the notification that someone has replied to my post on this forum is 'censored'.

I think Hilary put it on a "secure download" location for me to pickup last time.

Catharine

Re: Submit to DBXL

Jimmy — Thu, 20 May 2010 15:48:17 GMT

I believe a member of our team sent you version 2.1 a few hours ago. Did you not receive it?

Re: Submit to DBXL

Catharine — Thu, 20 May 2010 15:26:03 GMT

Hi, I have double checked the version I have injected is the latest version I have been sent.

How do I get the newer version ?

Catharine

Re: Submit to DBXL

Jimmy — Thu, 20 May 2010 13:52:04 GMT

Hello Catharine,

From inspecting your form, I have determined that you have a version of qRules in which SubmitToDbxl's /doctype parameter was not available. I believe a member of our support team has sent you a newer version, that includes this option.

Re: Submit to DBXL

Catharine — Thu, 20 May 2010 08:32:25 GMT

Here is the file

Re: Submit to DBXL

aruna akella — Wed, 19 May 2010 16:29:35 GMT

Hi Catharine,

Can you please post your template? - so that it will be easy to figure out the problem.

Thanks!

Re: Submit to DBXL

Catharine — Wed, 19 May 2010 15:34:06 GMT

The submit button had the set value minus the doctype, and I got the error I showed a couple of posts ago.

I have changed that set value to include the doctype, and now I don't get anything - no error, no docid .... as if nothing has fired.

I have done some investigation...

concat("SubmitToDbxl /submit=FirstSubmit /name=", CalculatedDescription, " /author=", DisplayName, " /desc=", RequestSummary, " /doctype=NewSKURequest") - no error - no docid

concat("SubmitToDbxl /submit=FirstSubmit /name=", CalculatedDescription, " /author=", DisplayName, " /desc=", RequestSummary, "/doctype=NewSKURequest") - error no doctype

concat("SubmitToDbxl /submit=FirstSubmit /doctype=NewSKURequest /name=", CalculatedDescription, " /author=", DisplayName, " /desc=", RequestSummary) - no error - no docid

it is obvious this is very sensitive as to where spaces are and where the doctype parameter is....

I still cannot get it to submit.

Catharine

Re: Submit to DBXL

Jimmy — Wed, 19 May 2010 15:01:36 GMT

Yes, that was what I meant. What do you mean when you say you don't get any values returned? Is there no Result or Error value? I'm assuming that you're assigning the value of that formula to qRules' Command node when the Submit button is clicked, right?

Re: Submit to DBXL

Catharine — Wed, 19 May 2010 14:46:47 GMT

None of the users will be accessing from dbxl. My doctype is called NewSKURequest

I have changed my command to

concat("SubmitToDbxl /submit=FirstSubmit /doctype=NewSKURequest /name=", CalculatedDescription, " /author=", DisplayName, " /desc=", RequestSummary)

Is this what you mean? When I press the submit button I don't get any values returned.

I have also tried adding the doctype to the FirstSubmit data connection and that did not work.

Catharine

Re: Submit to DBXL

Jimmy — Wed, 19 May 2010 13:11:41 GMT

You should use the /doctype= parameter to specify the name of your document type if you or your users will be opening the form template from somewhere other than DBXL.

Re: Submit to DBXL

Catharine — Wed, 19 May 2010 12:23:57 GMT

Hi,

I have finally got round to using the SubmitToDbxl qrules - I have used the information located here http://www.infopathdev.com/files/folders/qrules/entry35303.aspx

I have set up my (Receive) DataConnection (called FirstSubmit).

I have got my button with the rule which sets the command field in qrules to be concat("SubmitToDbxl /submit=FirstSubmit /name=", CalculatedDescription, " /author=", DisplayName, " /desc=", RequestSummary) which does not give any errors.

When I click the button I get the following information returned to the secondary data. Code I0001 Description No DocumentType found for '3706db86489748e0'.

In the instructions I cant find any reference to DocumentType. I have edited the DataConnection and put my documentType into the appropriate parameter but that did not solve the problem. Where should I be putting DocumentType ?

Catharine

Re: Submit to DBXL

Catharine — Wed, 12 May 2010 17:59:31 GMT

Brilliant - Thank you. Just what I wanted.

A job for tomorrow

Catharine

Re: Submit to DBXL

Jimmy — Wed, 12 May 2010 17:57:35 GMT

To clarify what Mel said, SubmitToDbxl does inject the docId into the form's XML so that subsequent submits will update the form that was initially submitted.

Re: Submit to DBXL

Mel Clemente — Wed, 12 May 2010 17:50:15 GMT

Hi, Catharine - yes, the qRules SubmitToDbxl command indeed submits documents to DBXL and returns the DocId and the RefId on submit. Please post back if you have additional questions.

Thanks!