SUPERGATE MANUAL ADMINISTRATION TOOLS

CGI Developed by Drewstar's Superscripts

EMAIL ADDRESS
EMAIL ADDRESS
PASSWORD
EXPIRE IN

Database to upload:

Database to upload:

ADMINISTRATION INFORMATION

Search Database:  Allows you to retrieve member information and subsequently modify or delete member accounts from the search results.  Currently you may search by credit card number (no spaces or dashes) or email address (case sensitive).  Email addresses are ALWAYS changed to ALL LOWER CASE by the cgi software.  Extra characters (space, /, -) are also removed by the cgi.

Manually Add User:   Allows you to add users manually to the databases.  This is just a simple way to add free accounts.  If you want to later add billing information you can search for the account information by email address and modify/delete the information.  When you manually add a user the USERNAME is set to EMAIL ADDRESS.  Expire is a numerical value equal to the NUMBER OF DAYS the account should last.  For example a 30 day account you should enter 30 into the expire field, a 60 day account you would enter 60, etc.

Delete Account:  A quick way to delete users based on email address.

Export Databases:  Used to download a flatfile database of your currently billed clients.  Databae is pipe (|) delimited.  Field descriptions are at the top.  Make sure to "view source" by the browser and save the resulting txt file. 

Import Database:  Used to manually import flatfile pipe delimited (|) text databases.  Field structures are as follows.

today|invoice|description|amount|custid|method|type|cardnum|expdate|authcode|acctno|abacode|bankname|name|address|city|state|zip|country|phone|fax|email|membership|expire|cycle|status|username|password|interval|delay

FIELD DESCRIBE FORMAT REQUIRED?
today signup date cgi uses julean dates optional
invoice unique number per username required
description describe transaction required
amount dollar amount with 2 decimal places required
custid customer id required
method method required
type transaction type usually set to NA required
cardnum credit card number no dashes or spaces depends on method
expdate credit card expiration date no spaces or / depends on method
authcode value returned by authorize.net not used
acctno bank account number depends on method
abacode check routing number depends on method
bankname bank name depends on method
name client name required
address client address required
city client city required
state client state required
zip client zipcode required
country client country optional
phone client phone optional
fax client fax optional
email client email required
membership name of membership sold varies required
expire number of days membership lasts 99999=recurring required
cycle number of days since last billed increments daily required
status status of account not used not used
username username set to email address required
password password generated by cgi required
interval billing interval in days set in configure.cgi required
delay billing delay for new accounts set in configure.cgi required