Google Search Results

Clear Results

WebCOBRA.com Community Message Boards

Access Data Loader

jwolgamott
Posts: 257
Since: 09/26/2005

How does the Access Data Loader Work?
01/07/2007 12:19 PMReply

We've provided sample code to create a local read-only version of your database in Microsoft Access.

To run the Data Loader, you'll need to create an account, then visit the Sample Code section and:

1) Download the zip file.
2) Unzip the contents
3) Run the Webcobra_Loader.exe
4) Click on Access Database
5) Enter your webcobra administrator code, username, and password
6) Click Load

From here, the application will download your Client/Employers, Benefit Plans, QBs, and their payments into an Access Database.

To refresh your data, follow the same 6 steps. It will clean out your Access DB and download all new data.



Systems should be free (to interact with others)

kippfeldt
Posts: 18
Since: 02/08/2007

RE: How does the Access Data Loader Work?
03/29/2007 02:33 PMReply

We downloaded the Webcobra Loader opened the project and ran the code in debug mode and get this error:

Your login failed due to unhandled exception: The request failed with an empty response.

Error occurs in login.cs:
F.Credentials = F.APIObject.Login(tx tAdminCode.Text.Trim (), txtUsername.Text.Trim(), txtPassword.Text.Trim());

The compiled version that was downloaded works and can login to download access data.

Any help would be greatly appreciated.
kfeldt@tekniq.com



kippfeldt
Posts: 18
Since: 02/08/2007

RE: How does the Access Data Loader Work?
03/29/2007 03:14 PMReply

I guess I posted to quickly!

This article is how I solved the problem:
http://www.mischefam ily.com/nathan/index .cfm/2007/2/6/ColdFusion-and-ASPNET-Web-Service-Interoperability-or-Lack-Thereof-Part-I

All I had to do is going into the projects app.config file and change:

http://app.webcobra.com/exec/api.asmx

to:

https://app.webcobra.com/exec/api.asmx

Hope this helps someone else or webcobra will release a new Data Loader download.

Kipp



amyapplewhite
Posts: 5
Since: 05/02/2008

RE: How does the Access Data Loader Work?
05/02/2008 10:25 AMReply

My log-in and password do not work. Do I use the same info as when I log into WebCOBRA??



amyapplewhite
Posts: 5
Since: 05/02/2008

RE: How does the Access Data Loader Work?
05/02/2008 10:53 AMReply

I unzipped the file and am trying to run the Webcobra_loader.exe, but my log-in information does not work. I am using the same info that I log into WebCobra with.



jwolgamott
Posts: 257
Since: 09/26/2005

RE: How does the Access Data Loader Work?
05/02/2008 12:43 PMReply

Does it popup an error message? Also, please make sure your account is an Enterprise level account with WebCOBRA.



Systems should be free (to interact with others)

amyapplewhite
Posts: 5
Since: 05/02/2008

RE: How does the Access Data Loader Work?
05/02/2008 03:48 PMReply

The popup message is "Your login failed with the following message: Server was unable to process request. ---> Could not find server location for customerid 0."
Yes, I am Enterprise level.



jwolgamott
Posts: 257
Since: 09/26/2005

RE: How does the Access Data Loader Work?
05/03/2008 10:11 AMReply

It sounds like your administrator code is incorrect; which are you using?



Systems should be free (to interact with others)

amyapplewhite
Posts: 5
Since: 05/02/2008

RE: How does the Access Data Loader Work?
05/05/2008 08:28 AMReply

I'm using LAMAR.



jwolgamott
Posts: 257
Since: 09/26/2005

RE: How does the Access Data Loader Work?
05/05/2008 08:35 AMReply

Yep -- that's the problem. Your Admin Code isn't LAMAR, its 'LAM'

you can tell this from when you've logged into webcobra, your URL is https://{admincode}.webcobra.com



Systems should be free (to interact with others)

amyapplewhite
Posts: 5
Since: 05/02/2008

RE: How does the Access Data Loader Work?
05/05/2008 08:42 AMReply

It worked - thanks!!



Return to Forum