Getting Osticket to email reports daily to staff
Required skills: MySQL, PHP
We use Osticket 1.6 ST for our helpdesk. We want to have Osticket email us a daily report telling us which tickets are open, by which user they are open and when the tickets were opened. We can work out the SQL quer to get us the data from the MYSQL database but don't know how to have this query run and email us automatically.
There is currently a cron job that is scheduled that gets Osticket to fetch emails from a mailbox to automatically create tickets and Osticket already emails us when there is a new ticket so all the components we need should already be set up.
We would like to have a job that runs once a day that will run a predefined SQL statement, formats the data into a table, and emails a single email address.
If it could be set up such that we can duplicate it and add another type of email alert with a different SQL statement that would be preferable.
Osticket is hosted externally by the same place that hosts our web site and uses a MYSQL database. We use cpanel to access our web site.
Thanks for reading.
Posted In:MySQLPHP |
Related projects:
Rss To Email Web App
first page would have an input box for a title, feed, and one for an email address... and of course a submit button. (option to add more would be even better but not required)
It also needs to have an area called "subscriptions" where you can delete these subscriptions.
I'm curious to know your thoughts on this and any suggestions you might have...and of course how much would you charge. Please see attached image for an example.
Thanks
Jason
It also needs to have an area called "subscriptions" where you can delete these subscriptions.
I'm curious to know your thoughts on this and any suggestions you might have...and of course how much would you charge. Please see attached image for an example.
Thanks
Jason
NEED CRAIGSLIST POSTER TO POST ADS DAILY FOR 30 DAYS
o make sure it is not Flagged, Ghosted or Removed in the first 24 hours.
-Please respond with your price per day and experience with craigslist postings.
We will pay daily through Freelancer/Moneybookers
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK. Thank You.
-Please respond with your price per day and experience with craigslist postings.
We will pay daily through Freelancer/Moneybookers
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK. Thank You.
NEED CRAIGSLIST POSTER TO POST ADS DAILY FOR 30 DAYS
sted and links to each of our ads. We will check each ad to make sure it is not Flagged, Ghosted or Removed in the first 24 hours.
-Please respond with your price per day and experience with craigslist postings.
We will pay daily through Freelancer/Moneybookers
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK. Thank You.
-Please respond with your price per day and experience with craigslist postings.
We will pay daily through Freelancer/Moneybookers
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK. Thank You.
Form to email and changes to index page
Hi,
I need a form to email for the contact us page and also a confirmation page including a server side validation for the fields.
Apart from this, as mentioned in the screenshot the extra module needs to be added to the homepage.
Priority 1: Index page
Priority 2: Form to email
Thanks.
I need a form to email for the contact us page and also a confirmation page including a server side validation for the fields.
Apart from this, as mentioned in the screenshot the extra module needs to be added to the homepage.
Priority 1: Index page
Priority 2: Form to email
Thanks.
Rss To Email Newsletter Tool
ed:
1. Automated RSS to Email weekly newsletter.
2. Mailing to approx 10,000 members using website server.
3. Anti-spam measures to ensure delivery.
4. Neat looking template in which blog posts and photos will be sent.
5. Ability to check newsletter open rate.
6. Unsubscribe feature which autmatically deleted that member from the email list.
7. Partial article in the e-mail with link to online article.
8. Anything else that you can suggest.
1. Automated RSS to Email weekly newsletter.
2. Mailing to approx 10,000 members using website server.
3. Anti-spam measures to ensure delivery.
4. Neat looking template in which blog posts and photos will be sent.
5. Ability to check newsletter open rate.
6. Unsubscribe feature which autmatically deleted that member from the email list.
7. Partial article in the e-mail with link to online article.
8. Anything else that you can suggest.
Form To Email
Hi,
I needed a form to email script similar to:
http://formtoemail.com/formtoemail_pro_version.php
and the content will be similar to:
http://www.avltravelphilippines.com/reserve.htm?hotelid=10
Create seo static php or html pages
W/ mySQL backend can select room type and random featured property
Our current webform is located at:
http://booking.philbuyersguide.com/
and want to update it w/ the features listed above.
I needed a form to email script similar to:
http://formtoemail.com/formtoemail_pro_version.php
and the content will be similar to:
http://www.avltravelphilippines.com/reserve.htm?hotelid=10
Create seo static php or html pages
W/ mySQL backend can select room type and random featured property
Our current webform is located at:
http://booking.philbuyersguide.com/
and want to update it w/ the features listed above.
Email Marketer Needed: Mass Email @craiglist Daily
I am looking for someone that can mass targeted emails @craigslist emails. I would like to email between 2k to 10k per day depending on your price. I need the replies forwarded to my specified email address. Please reply to this project only if you have emailed @craigslist before WITH inbox success!
Email Marketer Needed: Mass Email @craiglist Daily
I am looking for someone that can mass email @craigslist emails. I would like to email between 2k to 10k per day depending on your price. I need the replies forwarded to my specified email address. Please reply to this project only if you have emailed @craigslist before WITH inbox success!
Lead Generation/ Appointment Setter
ay-check-loan company.
This is an urgent requirement so please pm your bid, price and guaranteed amount of qualified leads per day.
Bidders should send their profile (if company) or CV (if individual).
We are looking for those team/individual to send reports daily to be verified the next day.
Payments will be sent via paypal weekly.
We can pay $ 3 per qualified lead and $ 7 for appointments set.
This is a long-term business!
This is an urgent requirement so please pm your bid, price and guaranteed amount of qualified leads per day.
Bidders should send their profile (if company) or CV (if individual).
We are looking for those team/individual to send reports daily to be verified the next day.
Payments will be sent via paypal weekly.
We can pay $ 3 per qualified lead and $ 7 for appointments set.
This is a long-term business!
Need email subscribers bulk to my comics, animation website
sic videos and shows daily. I don't post up spam materials - only funny stuff.
I will be able to check if they are real as well by seeing how many people actually end up viewing the list through stats in feedburner (which means how many people who have signed up have actively used and checked emails).
If fake then the contract will be terminated and cancelled. I am looking for help finding real email subscribers daily.
I will be able to check if they are real as well by seeing how many people actually end up viewing the list through stats in feedburner (which means how many people who have signed up have actively used and checked emails).
If fake then the contract will be terminated and cancelled. I am looking for help finding real email subscribers daily.
Easy PSD to EMAIL
Need PSD to email with proper html / css for best email compatibility/delivery.
*** Must be done within 1.5 hours of being awarded ***
This is a very simple image and should be real quick, PSD attached.
*** Must be done within 1.5 hours of being awarded ***
This is a very simple image and should be real quick, PSD attached.
Willing to sell a ready to made website for freelancers
ers
* Search members
* Add/edit/ delete categories
* Manage static pages
* System wide forced escrow
My desire to sell this ready made website with domain is for 1200 USD. Any bid above this price is highly appreciated. No negotiations below 1100 USD, Please do not waste my and your time in negotiations.
regards
* Search members
* Add/edit/ delete categories
* Manage static pages
* System wide forced escrow
My desire to sell this ready made website with domain is for 1200 USD. Any bid above this price is highly appreciated. No negotiations below 1100 USD, Please do not waste my and your time in negotiations.
regards
jpg to email template
Need jpeg to email newsletter template. Experts only need to see examples.
Grab images and RSS feeds to email daily.
Grab some images from a website (jpg) that changes daily as well as some RSS feeds to compose a daily email with custom news. The Images addresses and Rss feeds are known and open to the website. Have a public website and a site that automatically runs scripts, maybe this can be used.
RSS feeds are fixed and only the creator of the mails can set them.
RSS feeds are fixed and only the creator of the mails can set them.
Converting .psd to Email Template HTML (MailChimp)
l need to code each template into html/inline css. The code will need to display properly in Outlook 2003, Outlook 2007, Outlook Express, Eudora, Thunderbird, Mac Mail, Hotmail, AOL, Gmail and Yahoo Mail. (We will be using MailChimp to manage email campaigns.)
Budget is $ 60. I would like to award this project to someone by Sunday at 11PM GMT.
If I like your work I will have another similar project in the next couple of days.
Thanks!
Budget is $ 60. I would like to award this project to someone by Sunday at 11PM GMT.
If I like your work I will have another similar project in the next couple of days.
Thanks!
Traffic Stats php Script Customization to Include Email Reports by thatone1785
ficstats/login.php username and password are both demo
I’m need this done within a 3-5 hours of awarding the bid to the most qualified person.
I do not want to spend more than $ 30-40.
That is what I am looking for out of this customization. Please let me know
if you need any further clarifications!
Additional files submitted:
traffic_stats_script.zip
I’m need this done within a 3-5 hours of awarding the bid to the most qualified person.
I do not want to spend more than $ 30-40.
That is what I am looking for out of this customization. Please let me know
if you need any further clarifications!
Additional files submitted:
traffic_stats_script.zip
Create a website form that will send results to access and email by mnapieralski
add a quantity. I'd then like the results to email our office admin staff and dump to an Access database. I'd like the access database that could produce some simple reports like: Requests by user; requests by date or date range; total number of requests for certain items, etc, etc....
I've attached the supply list...
Additional files submitted:
Supply List.doc
I've attached the supply list...
Additional files submitted:
Supply List.doc
Add Clickable Hyperlinks To Email Template Design
but clickable to take them to the URL of another site. There will be about 40 hyperlinks behind text.
I have a designer who can make the Template, I just need a programmer to add the hyperlinks behind the text without changing the layout or format of the template. Email Template will be customized, but look similar to CONSTANT CONTACT's Email Templates.
If you think you can do BOTH the template and hyperlinks, let me know. TEMPLATE MUST look professional.
I have a designer who can make the Template, I just need a programmer to add the hyperlinks behind the text without changing the layout or format of the template. Email Template will be customized, but look similar to CONSTANT CONTACT's Email Templates.
If you think you can do BOTH the template and hyperlinks, let me know. TEMPLATE MUST look professional.
I need to post on CL in 5 cities ,20 ads daily on going
d to email us daily with Excel spreadsheet of all the online classified ads that
have been posted and links to each of our ads. We will check each ad to make sure it is not
Flagged, Ghosted or Removed in the first 16 hours.
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK.
Will pay through PayPal/Freelancer.
I am able to provide a live sample ad.
We appreciate your business.
have been posted and links to each of our ads. We will check each ad to make sure it is not
Flagged, Ghosted or Removed in the first 16 hours.
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK.
Will pay through PayPal/Freelancer.
I am able to provide a live sample ad.
We appreciate your business.
I need to post on CL in 25 cities ,35 ads daily on going
d to email us daily with Excel spreadsheet of all the online classified ads that
have been posted and links to each of our ads. We will check each ad to make sure it is not
Flagged, Ghosted or Removed in the first 16 hours.
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK.
Will pay through PayPal/Freelancer.
I am able to provide a live sample ad.
We appreciate your business.
have been posted and links to each of our ads. We will check each ad to make sure it is not
Flagged, Ghosted or Removed in the first 16 hours.
Please only bid if you are EXPERIENCED and have POSITIVE FEEDBACK.
Will pay through PayPal/Freelancer.
I am able to provide a live sample ad.
We appreciate your business.
