Qdabra Database Accelerator

Re: DBXL Help

snyderjd — Wed, 02 May 2007 00:56:23 GMT

Thanks Clay, I will PM you with my email address..

Thanks again

Re: DBXL Help

Clay Fox — Tue, 01 May 2007 22:55:53 GMT

It appears you have not been succesfull getting this form to submit via DBXL.

I think we should focus on that first.

Definitely your scenario of sharing information between the forms is viable. You can submit the main form and through the dat update a table or two and then use that data while filling out the related form.

I will send you some additional tutorials.

Re: DBXL Help

snyderjd — Tue, 01 May 2007 22:44:59 GMT

Clay,

Thanks for the post. I will include a screen shot of the form I have created and using. This form is being used as a shift turnover form for our production support group. Currently I have the form coded to be sent in email and we save form on a SharePoint. The object is to continue with the email but to submit to a SQL Database, currently running SQL Server 2005. As we have long data types in the form, we first went the route of a web service, but had issue with repeating sections getting submitted to the database. We currently fill this form out for turn over and then turn around and have to fill out a separate report with the same information. Our goal is to be able to use a SQL DB to store all of this information to better allow us to streamline our reporting and stop redundant processes....

Here is a snap shot of a single issue with a single application issue. As you can see there are several repeating sections within repeating sections. I do hope the database accelerator is a tool we can use... if so we will look at implementing it with our other forms.

http://server6.pictiger.com/img/27413/other/form.jpg

Re: DBXL Help

Clay Fox — Tue, 01 May 2007 21:46:35 GMT

Hey Jason, sorry you are having trouble.

InfoPath would be required for manipulating the DAT form and opening the template xsn via a browser should initiate InfoPath by default.

Can you explain what you are trying to accomplish with your form so we know what you are trying to accomplish.

I appologize for the documentation, I am going to be posting more this week.

If there is something specific you need please let me know.

Re: DBXL Help

snyderjd — Tue, 01 May 2007 04:18:59 GMT

OK, So at this point, I am lost with the whole DBXL etc... Is there any documentation that would assist in allowing me to use the database accelerator with a custom form that I have. As you stated in a previous post of mine, the work I am doing should be easly handled by the database accelerator...

Also, I am opening DAT from a browser, but it by default opens the form in infopath

Thanks very much!
Jason

Re: DBXL Help

Matt Faus — Mon, 30 Apr 2007 22:50:46 GMT

Hi snyderjd,

From the screenshot, it looks like you are trying to work with DAT from within a web browser. This has never been tested and the form relies on several InfoPath-specific functions to render correctly. After opening DAT in the InfoPath rich client you can click the '?' button to view a contextual help pane that will help. Also, hovering over all of the titles to the fields will bring a tooltip explaining each field.

Everything in the Getting Started document should be enough to get things rolling, but feel free to post back with any more questions! I hope this helps!

DBXL Help

snyderjd — Mon, 30 Apr 2007 13:42:09 GMT

OK, so after all of the posts regarding using the database acceslerator I have been trying to work with it. I am onclear on how to use my own custom form to connect back to a SQL database.

OK So starting from the begining...

General Tab:
1. I am able to add my form template
2. Able to add my data source... took me a bit to figure that out...
3. Reference ID Section ??? Not sure what I need to do here if anything
4. Indexes ??? Also not sure what I need to do here?

Permissions Tab:
1. have not really delt with this yet

Promoted Tab:
I am not using any sharepoint lists, so I do think I need to do this... am I wrong

Database Mapping:
1. I can see the following:

Namespaces
Prefix	URI
my	http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-04-27T16:06:40
tns	http://qdabra.com/webservices/

Database Map

Table NameColumn Name	Type	Node Path
tblApplication	Table	/my:myFields

Table NameColumn Name	Type	DB Type	Key	Node Path
AppName	Column	Select...System.BooleanSystem.ByteSystem.CharSystem.DateTimeSystem.DecimalSystem.DoubleSystem.GuidSystem.Int16System.Int32System.Int64System.SByteSystem.SingleSystem.StringSystem.UInt16System.UInt32System.UInt64		my:txtAppName

Table NameColumn Name	Type	DB Type	Key	Node Path
AppType	Column	Select...System.BooleanSystem.ByteSystem.CharSystem.DateTimeSystem.DecimalSystem.DoubleSystem.GuidSystem.Int16System.Int32System.Int64System.SByteSystem.SingleSystem.StringSystem.UInt16System.UInt32System.UInt64		my:intAppType

Insert Table or Column

when using a repeating section I am not sure sure which node path to use in the TableName

Lastly, Should I be using the same web service as in the getting started document? if so what am I missing when I try to add the web service to my form, submit button, the only options I have to map are the datasources from the getting started document. what I am I missing?