Qdabra qRules

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

chasquad — Thu, 16 Jun 2011 21:31:32 GMT

Perfecto! Thank you! Now I can move forward a bit.

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

ErnestoM — Thu, 16 Jun 2011 21:03:10 GMT

Ok, so if the DS name was changed maybe that's not the issue.

Can you try this?: CopyTable /dsnamesrc=ACTWorkHistoryRetrieve /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=d:SharePointListItem_RW

(no leading slash in /rowsrc)

Any changes in the error message?

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

chasquad — Thu, 16 Jun 2011 20:56:56 GMT

Thanks

I reordered the fields to match.

The secondary data connection ACTWorkHistoryRetrieve used to be called "ACT Work History retrieve" but I renamed it to remove the spaces.

Could this be causing the issue? Should I use the old name with the spaces in the Command? If so, do I need to put quotes around the name?

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

ErnestoM — Thu, 16 Jun 2011 20:17:35 GMT

I don't see a data source named "ACTWorkHistoryRetrieve" in your form. I do see the xpath /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW so that portion of the command looks ok.

After that you might run into an issue making sure that the fields match. See the attached screenshot; you might need to reorganize some fields.

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

chasquad — Thu, 16 Jun 2011 19:41:20 GMT

Alrighty ... now that the licensing issue is resolved I was able to retest the form after adding the dsnamesrc value:

Command: CopyTable /dsnamesrc=ACTWorkHistoryRetrieve /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=/d:SharePointListItem_RW /tabledest=/my:myFields/my:group1 /rowdest=/my:dpAWHGroup

Result: <null>

Success: false

Error: Failed to select the source row to copy from.

Sometimes a picture is worth a 1,000 words, so I've attached a pic of the source secondary data connection

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

chasquad — Thu, 16 Jun 2011 01:27:58 GMT

I get an error now. "Trial has passed the expiration date. Please contact Qdabra Software"

I got an email today from our Technology Purchasing dept that indicated that a PO had been issued for the purchase, but I did not hear back anything else from them. I guess I'm dead in the water until they tell me where the purchased license is. Thanks.

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

ErnestoM — Thu, 16 Jun 2011 00:51:27 GMT

Because your source is coming from a secondary data source, you'll need an additional parameter: dsnamesrc. Can you modify your command and try it again?

Also, when working with qRules we suggest you display the error, result and success nodes somewhere (for example, a view called Debug) so that you can see the errors and messages returned by your commands.

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

chasquad — Wed, 15 Jun 2011 21:44:47 GMT

I tried the copytable command, but being my first time using it, I probably did not do it right. I attached the template to this reply. Basically, if I understand you correctly, the user would click the button and that would send the data from the first repeating table to a second one that is in another view.

First Repeating Table: Secondary Data Source

Second Repeating Table: Main data source

Command: CopyTable /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=/d:SharePointListItem_RW /tabledest=/my:myFields/my:group1 /rowdest=/my:dpAWHGroup

Re: Writing Data From Repeating Table (secondary data source) back to SharePoint

ErnestoM — Wed, 15 Jun 2011 19:38:16 GMT

Can you use CopyTable to move the data from the 2ds to the main DOM and then have the mapping submit from the main DOM to the SharePoint list?

Writing Data From Repeating Table (secondary data source) back to SharePoint

chasquad — Wed, 15 Jun 2011 19:07:38 GMT

It seems simple, but here it goes ...

I have a IFS 2010 form with qrules that submits to a SharePoint 2010 Form Library. I have a secondary data source (ShaerPoint 2010 List) in the form that populates a repeating table in the form with the data from the secondary data source. I would like for each employee who opens the form to be able to modify the information in the repeating table and then click a button to send the modified data back to the SharePoint 2010 list.

I thought that the SubmitToSharePointList qrules would do this, however this is a repeating table that is a secondary data connection and not a main data source. Thus, I am not able to use the SharePoint List Tool to map the xml.

Ideas?