417906 Email admin system

Details about jingCo admin – GR taking in the info Please try to create script first on your server to enter 45 emails every 20 seconds to make sure it works before building the code. Planetbowl cpanel: [login to view URL] cpanel: Get Response Admin Features: 1. Create/update/delete GR accounts a. GR accounts will be the ID that connects to the database 2. Import name and email from excel sheet into DB a. Select the account b. Enter into database (ID (auto generate), Account, name, email, enter status (default = false), enter date, servername, server IP) 3. Once a day the script checks for Status = false entries and submits the account to GR database. Once submitted the status is changed to “true” and submits the datetime in the “enter date” field, also submit the servername, and server IP. a. Only does 45 entries a day b. Create loop to enter one every 20 seconds 4. Independent server scripts – scripts that are on a different server, once a day connect to the sever, pulls the next 45 entries, enter it into GR server then update server (1 entry every 20 seconds), change the status to “true” and submit the “datetime“, “servername”, “serverIP” [login to view URL] -Please create admin like the attached file. It is base on admin of popular software, [login to view URL] and highrisehq.com. -See design and css from [login to view URL] for the colours and styles -Dashboard page list the active getresponse elements, i.e. those that still need to upload data -when “GetResponse” tab is clicked show all GetResponse accounts with “Add new” button on the right -When “Add New” is clicked, enter the name and attempt to connect to the server to validate that is it correct. If correct then create “account” -import excel button will get file and validate excel file, if it is correct put the filename to the right of button and list 5 accounts below -have process button – once press the data will be entered into database for processing -Report pane on the right shows the total entries, how many is processed, how many is outstanding, and the expected completion date Completion date is based total days from today that is required = Outstanding emails/(# of server scripts +1)/45 Get Response for Planet Bowl: Tracking ID: 1. In admin get “GetReponse (GR)” tab – enter the GR id 2. When signing up for email connect to GR account, check email to see if it's in account. a. If yes then have pop up saying “Thank you. You are already a member” b. If “no” the proceed to send to database and to GR: i. Name, email, datetime, birthdate (optional), TrackingID, ExpireDate ii. Datetime= current date and time iii. Birthdate – if enter then have date format iv. TrackingID – auto number starts at 4000 v. ExpireDate – add 14 days to todays date. If today is a Friday add 13 days, if today is a Saturday add 12 days. 3. Add module to [login to view URL], add birthdate option 4. Recreate pop up module to do the same: [login to view URL] Corporate Email list: -[login to view URL] - add check out on the bottom of form, select by default with text “Add me to the corporate email list for future exclusive promotions and news.” -If selected then send info to GR email list once clicked “book now”