Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Can I view form submissions on the MBA server?

9 posts in General Discussion Last posting was on 2005-10-26 07:44:13.0Z
Chris M Posted on 2005-10-24 07:58:10.0Z
Sender: 2033.435c9340.1804289383@sybase.com
From: Chris M
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Can I view form submissions on the MBA server?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <435c9412.2038.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Oct 2005 00:58:10 -0700
X-Trace: forums-1-dub 1130140690 10.22.241.41 (24 Oct 2005 00:58:10 -0700)
X-Original-Trace: 24 Oct 2005 00:58:10 -0700, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:606
Article PK: 8981

Hi All,

We use the MBusiness form manager quite frequently as a
means of getting users to update information in our central
database, however, sometimes we get users call up saying
that their submissions have gone missing. We do log incoming
submissions on the server but I think that an error may
occur before we get to do the logging.

Is it possible to extend the MBusiness sync logs to show
form submissions as well?

I noticed there is some other database on the server that we
can query using dbisqlc.exe. Do you know if any of the
tables in this database would be of use? I had a look at the
list of tables and saw one called FORM, but it didn't seem
to help.

At the very least, it'd be nice to know how many forms are
submitted on a given day and how many of those were
successful. Doing this on a user by user basis would be even
more beneficial.

Any ideas on this would be appreciated.

Thanks in advance,
Chris


tony pigram Posted on 2005-10-24 13:39:42.0Z
Reply-To: "tony pigram" <tony.pigram@nospam.com>
From: "tony pigram" <tony.pigram@nospam.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <435c9412.2038.1681692777@sybase.com>
Subject: Re: Can I view form submissions on the MBA server?
Lines: 47
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
X-Original-NNTP-Posting-Host: host81-139-146-57.in-addr.btopenworld.com
Message-ID: <435ce31b@forums-2-dub>
X-Original-Trace: 24 Oct 2005 06:35:23 -0700, host81-139-146-57.in-addr.btopenworld.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Oct 2005 06:35:24 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Oct 2005 06:39:42 -0700
X-Trace: forums-1-dub 1130161182 10.22.108.75 (24 Oct 2005 06:39:42 -0700)
X-Original-Trace: 24 Oct 2005 06:39:42 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:607
Article PK: 8980

Hi Chris,

is your <form post> going to a specific page in your backend system?
is it a server-side processing page, such as ASP/JSP/PHP?

or are you having many server-side pages to process forms and place data
into the database?

either way, you can add coding into these pages that captures the auditing
info. and stores it into your own backend DB in an auditing table.

this would bypass any need to touch the MBiz server.

thanks

tony

<Chris M> wrote in message news:435c9412.2038.1681692777@sybase.com...
> Hi All,
>
> We use the MBusiness form manager quite frequently as a
> means of getting users to update information in our central
> database, however, sometimes we get users call up saying
> that their submissions have gone missing. We do log incoming
> submissions on the server but I think that an error may
> occur before we get to do the logging.
>
> Is it possible to extend the MBusiness sync logs to show
> form submissions as well?
>
> I noticed there is some other database on the server that we
> can query using dbisqlc.exe. Do you know if any of the
> tables in this database would be of use? I had a look at the
> list of tables and saw one called FORM, but it didn't seem
> to help.
>
> At the very least, it'd be nice to know how many forms are
> submitted on a given day and how many of those were
> successful. Doing this on a user by user basis would be even
> more beneficial.
>
> Any ideas on this would be appreciated.
>
> Thanks in advance,
> Chris


tony pigram Posted on 2005-10-24 13:53:59.0Z
Reply-To: "tony pigram" <tony.pigram@nospam.com>
From: "tony pigram" <tony.pigram@nospam.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <435c9412.2038.1681692777@sybase.com> <435ce31b@forums-2-dub>
Subject: Re: Can I view form submissions on the MBA server?
Lines: 72
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
X-Original-NNTP-Posting-Host: host81-139-146-57.in-addr.btopenworld.com
Message-ID: <435ce674$2@forums-2-dub>
X-Original-Trace: 24 Oct 2005 06:49:40 -0700, host81-139-146-57.in-addr.btopenworld.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Oct 2005 06:49:41 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Oct 2005 06:53:59 -0700
X-Trace: forums-1-dub 1130162039 10.22.108.75 (24 Oct 2005 06:53:59 -0700)
X-Original-Trace: 24 Oct 2005 06:53:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:608
Article PK: 17737

d'oh..... flame me......

yes, you already do the auditing within your server-side app.

I do see your point though:
you just want to know if you can verify that the data has got from
PDA-->MBiz and then from MBiz-->web app

>We do log incoming submissions on the server but I think that an error may
occur before we get to do the logging

I'd be interested to know what can cause these errors and make data
"disappear"?

I see you are using MBiz v5.7 - is this the App edition?

thanks

tony
(*flame me like a BK Whopper*)

"tony pigram" <tony.pigram@nospam.com> wrote in message
news:435ce31b@forums-2-dub...
> Hi Chris,
>
> is your <form post> going to a specific page in your backend system?
> is it a server-side processing page, such as ASP/JSP/PHP?
>
> or are you having many server-side pages to process forms and place data
> into the database?
>
> either way, you can add coding into these pages that captures the auditing
> info. and stores it into your own backend DB in an auditing table.
>
> this would bypass any need to touch the MBiz server.
>
> thanks
>
> tony
>
> <Chris M> wrote in message news:435c9412.2038.1681692777@sybase.com...
> > Hi All,
> >
> > We use the MBusiness form manager quite frequently as a
> > means of getting users to update information in our central
> > database, however, sometimes we get users call up saying
> > that their submissions have gone missing. We do log incoming
> > submissions on the server but I think that an error may
> > occur before we get to do the logging.
> >
> > Is it possible to extend the MBusiness sync logs to show
> > form submissions as well?
> >
> > I noticed there is some other database on the server that we
> > can query using dbisqlc.exe. Do you know if any of the
> > tables in this database would be of use? I had a look at the
> > list of tables and saw one called FORM, but it didn't seem
> > to help.
> >
> > At the very least, it'd be nice to know how many forms are
> > submitted on a given day and how many of those were
> > successful. Doing this on a user by user basis would be even
> > more beneficial.
> >
> > Any ideas on this would be appreciated.
> >
> > Thanks in advance,
> > Chris
>
>