Database Export
Explanation of how to export your Membership Management Database via an outside server
In order to automate your server to export your Membership Management Database, you will need to securely “Post” to the below URL with the necessary form fields.
https://{your-secure-payment-server-domain}/payment/recurring/MERCHANT/admin/editcust.cgi
You will need to replace “MERCHANT” in the URL with your account username in order for this function to work correctly
Please Note: In order to Post to scripts behind our firewall, your script will need to use the “Basic Authentication” library functions of your scripting language. Please see your languages instruction guide in order to implement and use these security features.
Additionally, your script will need to enclose the necessary form fields below for the Membership Management Database Export function to work correctly.
| Variable | Required | Value | Notes |
| function | Required | transfer | |
| format | Required | ‘ftp’ or ‘download’ | Sets the method our system will use to export the database with.“ftp” will FTP the file using the FTP related fields. “download” will create a data file on our server to be downloaded. (See notes below) |
| FTPun | Required | FTPUSERNAME | Replace the “FTPUSERNAME” field value with your server’s FTP username (use the same FTP username your company provided to us) |
| FTPpw | Required | FTPPASSWORD | Replace the “FTPPASSWORD” field value with your server’s FTP password (use the same FTP password your company provided to us) |
| remotedir | Required | database | |
| destfile | Required | memberinfo.txt | |
| orderid | Optional | export | |
| plan | Optional | export | |
| purchaseid | Optional | export | |
| password | Optional | export | |
| name | Optional | export | |
| company | Optional | export | |
| addr1 | Optional | export | |
| addr2 | Optional | export | |
| city | Optional | export | |
| state | Optional | export | |
| zip | Optional | export | |
| country | Optional | export | |
| shipaddr1 | Optional | export | |
| shipaddr2 | Optional | export | |
| shipcity | Optional | export | |
| shipstate | Optional | export | |
| shipzip | Optional | export | |
| shipcountry | Optional | export | |
| phone | Optional | export | |
| fax | Optional | export | |
| Optional | export | ||
| billcycle | Optional | export | |
| startdate | Optional | export | |
| enddate | Optional | export | |
| monthly | Optional | export | |
| cardnumber | Optional | export | |
| exp | Optional | export | |
| lastbilled | Optional | export | |
| status | Optional | export | |
| username | Required | export | |
| submit | Required | Export & Upload Member Database |
Notes:
Posting into the above URL & including the necessary form fields will export all fields from your Membership Management Database to your server. The database file will be in a ‘,’ [comma] delimited format with a ’ " ’ [quote] qualifier.
Each line in the flat file will represent 1 member of your membership management database.
If you wish to exclude a specific field from database, remove the field name from the form or set the field’s value to NULL.
If you have selected the ‘download’ format, after running the database export, you can download the data file from ‘https://{your-secure-payment-server-domain}/payment/recurring/MERCHANT/admin/tempxfer.txt'