WebCOBRA.com Community Message Boards

jsterling
Posts: 3
Since: 11/15/2007

We're experimenting with the Access DB. When we review the table content downloaded, it doesn't appear all data is downloaded to the DB. Does anyone have any advice on what the issue might be?

Thank you.

jwolgamott
Posts: 257
Since: 09/26/2005

When you say all data, do you mean that some participants are in the live WebCOBRA system, but not in the access file?

Or do you mean that you see a field in the live system that you expected to be in the access file?

I anticipate you mean that there is data in the live system that you'd like to see in the API. If that's the case, please fill out an enhancement request through Travis Support.

jsterling
Posts: 3
Since: 11/15/2007

I mean that when I run a query via the API query tool I get different results than when I run a query via the access data base. I don't appear to be pulling all payments that are currently posted in WEBCOBRA, only a handful actually make it down to the database. Any thoughts on why I might be getting different results than what is actually in WEBCOBAR?

jwolgamott
Posts: 257
Since: 09/26/2005

That does sound like a support issue --- If you see a payment on the screen, you should see a payment in the Access database.

However, one thing to make sure if that you're talking about payments (cash in) versus premiums paid, especially if you mark a QB as being Paid Through a certain date.

jsterling
Posts: 3
Since: 11/15/2007

Jwaolgamott

This still doesn't appear to be working correctly. I download data via the access data downloader and not all QB's are being downloaded. For example, when I run a report in WEBCOBRA and view all enrolled for one of my clients, not all of those QBs are being downloaded into the QB table. Please advise, this is causing serious issues with our ability to report to our clients.

Thank you.

jwolgamott
Posts: 257
Since: 09/26/2005

For us to be able to diagnose the issue, we'll need to have your login information and an example of the QB that isn't downloading.

This forum is not the best place for that -- please email spt@travisoft.com with that information (paste in this devcenter conversation link as well), and we'll hopefully be able to diagnose for you.

One thing to make sure of -- the QB should be in Access tables themselves -- sometimes if you write custom reports or queries they will exclude records even though they are really there.