View previous topic :: View next topic |
Author |
Message |
Guest
|
Posted: Tue Oct 14, 2003 10:37 am Post subject: PageGate SQL database |
|
|
Is there anyway to have the PageGate DB, and a SQL database to sync up?
I just posted a few days ago about sending anonymous pages, and the responce I got was that you need a licence of 5000+ to get this feature.
At my office we will not need a licence this large, so paying for the 5000+ licnece is a waste for us.
Now my question is whether this is anyway to pull data form a SQL database that we already have with all our contact information into pagegate so that we can have them constantly synced up.
|
|
Back to top |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4354
|
Posted: Tue Oct 14, 2003 1:53 pm Post subject: PageGate SQL database |
|
|
PageGate uses a database format that can be read by MS Access 2000. I believe that MS SQL servers can read/write to MS Access database tables.
Some customers have created linked tables within the PageGate database, so the data is actually stored in their SQL server, and PageGate doesn't know the difference.
Although things like this can, and have been done, our tech support may not be able to help much with these types of setups. |
|
Back to top |
|
Guest
|
Posted: Thu Oct 16, 2003 10:30 am Post subject: |
|
|
Ok, I've been able to link my SQL DB to the access database. However, the format of the two DB's is obviously diferent.
Any help you could provide me with getting the SQL table I linking to transform into the users table would be great.
|
|
Back to top |
|
Guest
|
Posted: Fri Oct 17, 2003 8:24 am Post subject: |
|
|
When ever I try to add a user using access instead of pagegate admin I always get this error
Error # 94 Invalid use of
|
|
Back to top |
|
Guest
|
Posted: Fri Oct 17, 2003 8:26 am Post subject: |
|
|
sorry I hit enter by mistake, here is the complete message
When ever I try to add a user using access instead of pagegate admin I always get this error when I try to access the settings for the user I added
Error # 94 Invalid use of Null Procedure: edit_user load
Why is this?
|
|
Back to top |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4354
|
Posted: Fri Oct 17, 2003 9:53 am Post subject: PageGate SQL database |
|
|
When PageGate creates a new record in any of its tables, it will never leave any field with a NULL value. Many database environments (like MS Access, and MS SQL) will leave any unassigned text fields as NULL. These fields should always be initialized to a zero length string (i.ie ""), never left as NULL. |
|
Back to top |
|
Guest
|
Posted: Fri Oct 17, 2003 11:30 am Post subject: |
|
|
Great, that fixed one of my problems
Now I have to still figure out how to transform the db into something PageGate can understand.
|
|
Back to top |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4354
|
Posted: Fri Oct 17, 2003 11:40 am Post subject: PageGate SQL database |
|
|
What do you need to make this easier?
Is there some sort of information I can send you? |
|
Back to top |
|
Guest
|
Posted: Fri Oct 17, 2003 12:07 pm Post subject: |
|
|
Well, I am able to link my table's from the SQL server into the pagegate db. Now I just need a way to transform the table I have into something that pagegate can understand
These are the tables I have to work with
Table Name: Owner
Feild 1: Owner ; The name of the person
Feild 2: WorkN ; The persons work number
Feild 3: PagerN ; The persons pager number
Feild 4: DispatchN ; The pagers dispatch number
Feild 5: DMail ; The persons email
And the second table
Table Name: Escalation
Feild 1: Escalation; The name of the person
Feild 2: WorkN ; The persons work number
Feild 3: PagerN ; The persons pager number
Feild 4: DispatchN ; The pagers dispatch number
Feild 5: DMail ; The persons emaile is
Now I need to create a users table which will get the name, and page number from these tables.
|
|
Back to top |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4354
|
Posted: Mon Oct 20, 2003 8:17 am Post subject: PageGate SQL database |
|
|
The first step will be to create a record for each carrier in PageGate's carriers table. You will need the following information about each carrier:
A unique carrier name
The protocol to use to communicate with the carrier (TAP, UCP, SNPP, WCTP, SMTP, GSM)
The phone number (TAP) or host name (SNPP, WCTP, SMTP) to the carrier's gateway
Communicaiton settings (i.e. baud, parity, data bits, etc., or port number for Internet protocols)
Most of the other fields can be filled in with default information.
Next you will need to create a recipient record for each pager/phone in the user table. You will need the following information about each recipeint:
A unique recipient name (short name) with no spaces or special characters ( _ and - are ok)
A full recipient name (long name)
The pager's/phone's ID, PIN, or email address
The carrier for the pager (see above)
Most of the other fields can use standard default info |
|
Back to top |
|
Guest
|
Posted: Mon Oct 20, 2003 8:38 am Post subject: |
|
|
I *think* I have figured it out.
My problem was that I was trying to transform the table after I had linked it to access. I'm now trying to transform it from the SQL server, and I'm at least making some progress.
|
|
Back to top |
|
|