converting MS Access table to import into receipients

[fdnyfish]

Can someone share their technique on importing receipients into pagegate from a Access database?

[Tech Support]

Importing directly from an Access database into PageGate might be a little tricky, really. Regardless of what format you choose, you need to make sure that you use the specific structure that PageGate Database needs:

user: Enter the 'short' name of the recipient.

full_name: Enter the full name of the recipient.

id: If this recipient uses a NON-SMTP Carrier, use this field. Enter the ID/PIN of the device to be contacted. If this field is not used, set it to: ""

EmailTo: If this recipient uses an SMTP Carrier, use this field. Enter the email address of the device or person to be contacted. If this field is not used, set it to: ""

carrier: Enter the name of an existing carrier in PageGate.

maxchars: Enter the maximum number of characters this recipient should be able to receive.

alpha: True or False. If the device is alphanumeric, set it to True. If the device is numeric only, set it to False.

notify_only: True or False. If you only ever want this recipient to receive the number sequence entered into the Notify Code field, set it to true. Otherwise, set it to false.

notify_code: Set this to a numeric sequence of 10 or fewer digits.

remove_from: True or False. If you do not wish the Sender's Information to be viewable by this recipient, set it to True, otherwise, set it to False.

remove_domain: True or False. If you do not wish the Sender's Domain to be viewable by this recipient, set it to True, otherwise, set it to False.

on_call: This field is only ever used for Groups. True or False. If this is an on-call group, set it to true, otherwise, set it to False.

reliapage: True or False. The reliapage option sequentially numbers each message sent out for this recipient. A numbering sequence is maintained for each individual recipient. This way, if a recipient receives messages with a number missing, they will know that they have missed a message.

reliapage_index: A numeric value assigned as the 'starting' point for the Reliapage numbering sequence.

forward: If the GetMail module is enabled and this recipient needs a copy of every message sent to an email address, enter that email address into the forward field. Otherwise, set the field to: ""

ascii_service: True or False. This field determines whether the GetAscii module is enabled for this recipient.

gui_service: True or False. This field determines whether the GUI Client module is enabled for this recipient.

mail_service: True or False. This field determines whether the GetMail module is enabled for this recipient.

serial_service: True or False. This field determines whether the GetSerial module is enabled for this recipient.

tap_service: True or False. This field determines whether the GetTAP module is enabled for this recipient.

web_service: True or False. This field determines whether the GetWeb module is enabled for this recipient.

ad_hoc: True or False. This field determines whether the recipient is an ad-hoc recipient or not.

drop_control: True or False. This field determines whether the "Drop non-printable characters" option is enabled for this recipient.

multi_page: True or False. This field determines whether the recipient is a multi-page recipient and should be set to False.

email_only: True or False. This field determines whether the recipient is an Email Only recipient for use with the GetMail service as a POP3 service. This field should be set to False.

group: True or False. This field determines whether this is a group.

display_group: True or False. This field determines whether this is a display_group.

template: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text1: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text2: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text3: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text4: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text5: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text6: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text7: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text8: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text9: This field is only ever used in tandem with the GetWeb module and should be set to: ""

text10: This field is only ever used in tandem with the GetWeb module and should be set to: ""

image1: This field is only ever used in tandem with the GetWeb module and should be set to: ""

image2: This field is only ever used in tandem with the GetWeb module and should be set to: ""

image3: This field is only ever used in tandem with the GetWeb module and should be set to: ""

image4: This field is only ever used in tandem with the GetWeb module and should be set to: ""

image5: This field is only ever used in tandem with the GetWeb module and should be set to: ""

custom: This field is only ever used in tandem with the GetWeb module and should be set to: False

group_list: This field is only ever used in tandem with the GetWeb module and should be set to: False

GLFullNames: This field is only ever used in tandem with the GetWeb module and should be set to: False

Failover: If this recipient has a Failover recipient, enter the other recipient's name here.

SendSubject: True or False. This field determines whether a Subject line is included on messages sent to this recipient.

extra1: This field is only ever used in tandem with the GUI Client module and should be set to: ""

extra2: This field is only ever used in tandem with the GUI Client module and should be set to: ""

extra3: This field is only ever used in tandem with the GUI Client module and should be set to: ""

extra4: This field is only ever used in tandem with the GUI Client module and should be set to: ""

hold: True or False. This field determines whether or not this recipient should have its messages "held" between certain times. For example, if a recipient should not receive any messages from 6PM to 5AM, you would set this field to True. Otherwise, set it to False.

hold_start: The starting date/time that this recipient should not receive messages entered in this format: 8/21/2007 10:00:00 PM If the Hold Schedule is not used, set this field to the current date and set the time to 10:00:00 PM

hold_stop: The ending date/time that this recipient should not receive messages entered in this format: 8/21/2007 8:00:00 AM If the Hold Schedule is not used, set this field to the current date and set the time to 8:00:00 PM

creator: This field is used in conjunction with certain security and administrative portions of Pagegate. If this user should be editable by a specific 'limited' administrator, enter that administrator's Pagegate username in this field. Otherwise, set the field to: ""

[fdnyfish]

Can anyone share how you are getting your databases to convert to the above format?

[Tech Support]

What format are you coming from? The above format is the Pagegate database format, it's already configured in the pagegate.mdb file.

[fdnyfish]

MS Access

[fdnyfish]

I tried importing the user table unto my database, I populated the fields with names and services, and pin numbers, then exported to text to import back to pagegate, and i got errors.

I can't just copy and paste data into the pagegate user table becase there are some users in there that are not from my main database, and I will loose them if i delete all the users prior to paste.

There are only 4 or 5 fields that need to be imported, why must we play with all 56 fields?

There has to be an easier way!

[fdnyfish]

I tried importing the user table unto my database, I populated the fields with names and services, and pin numbers, then exported to text to import back to pagegate, and i got errors.

I can't just copy and paste data into the pagegate user table becase there are some users in there that are not from my main database, and I will loose them if i delete all the users prior to paste.

There are only 4 or 5 fields that need to be imported, why must we play with all 56 fields?

There has to be an easier way!

[Tech Support]

The reason all 56 fields need to be there is that you can't have null values in an Access database. Now, a null value is different than a blank string value, which is why each field has to have something in it. Each field needs the information.

If you're going to be doing importing like that, you may want to try converting yoru data into a CSV/Text file and then using the import function in PageGate to read that file in. It may save you some trouble in the long run. To know the format the text document needs to maintain, use the PageGate Admin to export your recipients, that way you can see the format PageGate Exports/Imports.

[fdnyfish]

does this text format look good?

"505","DAmato_Frank_Nextel","DAmato, Frank - Nextel","9175551212"," ","Nextel","240","#TRUE#","#FALSE#","999","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#",,"#FALSE#","#TRUE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#","#FALSE#"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ","#FALSE#"," ","#FALSE#",," ",," "," "," "," ","10:00:00 PM","8:00:00 AM"," "

Try importing and let me know if it works..

[Tech Support]

This is what you'd want to use:

"506","damato_frank_nextel","Damato Frank - Nextel","9175551212","Nextel","","240",#FALSE#,"999",#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,"0",#FALSE#,#FALSE#,"",#FALSE#,"","","","","","","","","","","","","","","",#FALSE#,#FALSE#,#TRUE#,"",#FALSE#,#FALSE#,"",#FALSE#,"","","","",#FALSE#,"10:00:00 PM","8:00:00 AM",""

Note that the name fields should NEVER have a comma - the comma is a 'command' character for the CSV file format.

[fdnyfish]

where is the EmailTo: field? dosn't that go between the ID & Carrier field?

[Tech Support]

Since Nextel is an SNPP based carrier, it doesn't use the Email To: field, it uses the ID/PIN field, so the Email To field is set to a blank string value: ""

[fdnyfish]

where is that blank value located in the string?

Your directions in post #2 put that field between ID & carrier.

[Tech Support]

I'm not sure? I created a new installation of PageGate, created one carrier called Nextel, created one recipient that matched the information you'd posted, then used the export function in the Admin to get what I posted. I guarantee you, what I posted is the exact sequence Pagegate needs.

[fdnyfish]

maybe thats why my imports are not working, I was using what was posted in post #2.

Is there a new detailed post like #2 that i can follow? I am getting dizzy just looking at ",#FALSE#,#FALSE#,"",#FALSE#,"","","","","","","","","","","","","","","",#FALSE#,#FALSE#,#TRUE#,"",#