Qdabra Database Accelerator

Re: Problems going from my infopath forms in sharepoint to dbxl as follows.

homeslacks — Sat, 12 Sep 2009 15:09:25 GMT

Thanks Ernesto,

I'll spy out your advice/solution next monday and see how it goes.

Re: Problems going from my infopath forms in sharepoint to dbxl as follows.

ErnestoM — Fri, 11 Sep 2009 19:22:31 GMT

I think the problem is the SharePoint workflow. I think that if we remove that piece, the rest of the puzzle pieces will fit together nicely.

In general, these are the necessary steps:

1. Modify your InfoPath form template such that is submits to the DBXL Document service. Remove any connections that submit to SharePoint directly.
2. Create a new document type in DBXL using this xsn form.
3. Create SQL mapping.
4. Create SharePoint mapping. (Note: You can use the same SharePoint form library you were using, but DBXL needs to own the mapping, so you'll need to empty the form library first and allow DBXL to recreate the documents. Of course, it's safer to simply use a new SharePoint form library.)
5. Submit one document to test your SQL mapping and SharePoint mapping. Tweak (#3 and #4) as necessary until you are satisfied with the mappings.
6. Save your existing xml documents and import them into DBXL. I wrote some steps today to cover one way to do this. The documents will be auto-mapped to SharePoint and SQL (but if they aren't, a quick Reshred All will do it).

From reading your other questions, it seems like you need DBXL to perform a SharePoint-UPDATE operation; that is, DBXL needs to inherit the workflow and the existing library/documents. I don't believe DBXL was designed specifically for that scenario, because DBXL needs to own the xml documents. Patrick wrote a blog post that may be related, but it concerns SQL. Read it here. Perhaps he can provide more of a philosophical perspective next week.

Problems going from my infopath forms in sharepoint to dbxl as follows.

homeslacks — Fri, 11 Sep 2009 18:32:13 GMT

Long long long story short. I have forms in sharepoint that are happy ever after. They submit to sharepoint, have dataviews, run designer workflows etc. I need to migrate them to be submitted to DBXL then from dbxl to a SQL DB and to SP. No matter what I've done, no matter what sequence I follow I have issues. I have tried to many routes, have had so many issues it would be silly to list.

My question is, what steps should I follow to get my current Infopath forms submitting to sharepoint to be submitted to DBXL so that DBXL submits them to SQL and to SP without hosing my solutions up. I know for one that I'll be stuck with a DocID for the form name versus my very nice formatted form name, but I'll deal with that.

I know how and have without error created a form from scratch that submits to DBXL "only" and DBXL sends it to SQL and SP. That's not an issue, it's just when I have a form/template to start with that's already published in sharepoint where things get thrashed.

Any advice would be great being that I'm currently faced with DBXL only being good for new solutions.

Thank you kindly.