FC Software Blog

Email Marketing, CRM Solutions, Asset management, Campaign Tracking

MySQL Date format and PHP

This is just a very quick blog entry to provide a little snippet of code and hopefully help some people.

I offer coding help and advice on several PHP forms for beginners to the language.  One of the common problems they have seems to be date/time stamps and MySQL format and handling.  This seems to be especially relevant to UK coders where our dates take the format dd-mm-yyyy whereas MySQL stores the date in yyyy-mm-dd HH:mm:ss.

PHP is a wonderful language that makes working with dates etc actually very easy.  To resolve the format of date/times from MySQL to a more UK centric format I created a very simple function

function mysql2uk($date) {
      return date('d-m-Y H:i:s',strtotime($date));
} 
This brilliant little function in effectively a single line converts your mysql format date into a UK format date without you needing to wrap that entire line of code around every date you spit out.

So to use it your php page would simply be something like this

<?php
function mysql2uk($date) {
 return date('d-m-Y H:i:s',strtotime($date));
} 
$sql ="select * from table";
$result = mysql_query($sql) or die();
$values = mysql_fetch_row($result);
echo mysql2uk($values['column']);
?>

And as easy as that your date is now in a UK format.

You can edit the format by changing the 'd-m-Y H:i:s" part of the function and to save you having to have the function at the top of everyone of your pages you can put it in an include file and just include that file on your site/pages where you want the function available.

Hope this little snippet helps some.

August 11th, 2010 by admin

Thoughts on official RIM Twitter client for Blackberries

First up considering its a beta damn its stable.

I’ve not been able to find any problems with it yet even attempting to break it.  If it wasn’t for the invite only status I’d have thought this was a full blown 1.0 release.

There are however a few short comings in the client little things that could be improved or features added that aren’t currently added.

Firstly the buttons along the top its navigation effectively is lovely IF you’re using a BB with some kind of scroll wheel on the storm/storm2 they’re horribly small and if – like me – you have large fingers almost impossible to press accurately.

My suggestion for fixing this is left right motion switching.  Just like in BBM running your finger left or right across the screen cycles through the various chats. Can we not have the same for the twitter client?

Last I heard twitter were adding in Location support for tweets and users (http://blog.twitter.com/2009/08/location-location-location.html).  Now I don’t know if this came to pass but if it did then its certainly not supported by the BB client.

I don’t really have a solution to this however Ubertwitter resolves it in an interesting way.  They update the Location field with coordinates and then if you want to look at all users within say a 5 mile radius of yourself then you can do.  Its an interesting feature I’d like to see implemented – especially amusing on drunken nights out to find others making a fool of themselves :) – perhaps it could also be expanded to define some kind of BB user flag in there so you can perhaps say “show me all BB users within 5miles of me” leading perhaps to impromptu meets of fellow geeks/nerds and many gallons of ale….. Just a thought.

Multiple acount support is none-existant.

I have 2 accounts one for work and one for personal usage I’d like to be able to update them both while I’m out and about without having to log out log in and resync to each account manually.  Perhaps register multiple accounts and have a simple overview screen showing account name, number of new tweets, date of last tweet, number of @’s or DM’s.

Then simply clicking on that accounts icon takes you into what is currently the main page of the app.

Aside from those few things though RIM have done a superb job of the client and I think once its in final release I’ll be switching to using it full time instead of UT.

February 24th, 2010 by admin

Small Basic Opensource Jobboard

A while ago a friend asked if I could knock together a very basic job board for him just to post 4-5 roles he was currently recruiting for.

Being the good friend I am I agreed and 10 minutes later he had his job board.

It recently came about that others may find such a thing useful as well.  To this end I’m posting the Job Board zip file to this blog. Feel free to download it and use it if you want.  There is no license attached to this so do with it what you will.

Word of warning though to those of you that may be expecting an all singing and dancing system – this isn’t it! this is very basic and very simple and served its purpose.  There is no support with these files.

opensource-basic-jobboard

Good Luck

Dave

February 3rd, 2010 by admin

Busy Busy

Its been a hetic few months at FC Software.

We’ve upgraded our Stockbroker B2C CRM platform to support trade tracking and commission based payroll for users.  Added more advanced reporting features and fixed a slew of bugs found in the system.

We’ve updated the E-Commerce Package EZ-Shop to version 1.0.1 which fixes a few bugs found since it went open source.  You can download the latest installer pack from the open source section of our website.

We’ve implemented cashback features into the BlueLightCard website a service open for all Emergency Service workers in the UK.

We’ve also began planning and preparation to increase our hosted platform capacity and are currently looking at the feasability of blade’s instead of our current separate rack servers.

All in its been a bit mad around here recently.  We hope normal service will resume soon and are currently looking at other tools we’ve created that would be suitable for the open source world.

November 24th, 2009 by admin

EZ-Shop approved on Hotscripts and Scripts dungeon

Our EZ-Shop open source e-commerce platform has been approved on both the hot scripts website and the scripts dungeon website.

http://www.HotScripts.com/?RID=N782379

http://www.scriptdungeon.com/freephpscript/freescripts9142

We think this is a great step in the right direction to help us make more people aware that there are full featured and free alternatives out there to the commercial offerings that are so frequently missold to people.

October 14th, 2009 by admin

Is your website working hard enough?

Today’s websites have to work harder than ever to deliver opportunities to your desk. They can’t just be a billboard, they must gather information and present it efficiently to you for action.

A new business lead should be dealt with instantly rather than within 24 hours! The more efficient you are getting in touch with prospects and customers the more likely they will want to do business with you.

At First Contact Software we have over 20 years’ experience of getting the best from companies’ websites. We offer a free Audit of your Web Site and its content including any of these related business applications:

* Lead Management
* CRM Solutions
* Document Management
* E-Commerce
* Email Marketing
* Asset Tracking
* Bespoke Solutions
* Business Analysis

August 20th, 2009 by admin

Related to the previous post

It seems I’m not alone in finding little point to using Social Media for B2B sales.

http://www.destinationcrm.com/Articles/CRM-News/Daily-News/New-Social-Media-Not-Helping-Sales-53368.aspx

Again this seems to negate the amount of benefit gained from a “SocialCRM”

June 30th, 2009 by admin

Tips For Effective Email Marketing

Over the past few years, research has continued to prove the benefits of e-mail marketing for business: low costs, high conversion rates and detailed tracking are all notable features. But e-mail marketing is becoming much more than just a tool for spammers and e-businesses. Consumers are becoming increasingly savvy on the differences between spam and permission-based emails, and more and more of them are accepting permission-based e-mail marketing as a positive replacement for direct mail.

The best news is that the majority of people who receive permission-based e-mails open, on average, 78% of them.

Jupiter Research reports effective email marketing campaigns can produce nine times the revenues and 18 times the profits of broadcast mailings. But crafting an effective business email is both an art and a science. Here is a list of factors, potential problems and effective solutions to keep in mind:

1. Spam! Spam! Spam! I don’t need any Viagra!

The average consumer receives more than 300 emails a week, 62% of which are spam. No wonder there’s such hostility towards the industry. But spam filters, bulk folders and “report spam” features are helping consumers become more at ease about the perils of spam. While 89% of users cited spam as a major concern in 2003, that number dropped to 85% in 2004, proportionally to an increase in the use of spam-fighting tools.

So as a permission-based business email marketer, what can you do? One tip is to remind your subscribers to add you to their “safe senders” list. The second, and most important, tactic is to make sure your email marketing service provider has a good relationship with ISPs. This will ensure that your email marketing campaigns go into your subscribers’ inboxes, not their junk mail folders. When choosing an email marketing software, make sure the company has strict anti-spam policies and complies with the guidelines of Can-Spam.

2. Images and formatting: Why do my emails look broken?

Broken email campaigns are an increasing concern among email marketers, especially since several companies and web-based email providers now block graphics as a measure to combat spam. In fact, according to ClickZ, 40% of email marketing messages delivered to inboxes are “broken.”

This was actually something that came up during Eliteweb.cc’s beta-testing phases, as we had a client in the Canadian Government whose recipients were mostly using highly secure email programs. The solution we came up has now become one of our key competitive advantages.

What Eliteweb.cc does is it publishes every single email marketing campaign sent to a secure location on the web (a location only original recipients of the email can access, thanks to encrypted technology that automatically authenticates the user). The technology also ensures you can track your users’ behaviors, even if they are reading your email campaign at the secure web location.

3. Personalization and relevant content: In a business e-mail, one size does not fit all.

In a recent study by DoubleClick, email users were 72% more likely to respond to a business e-mail if its content was based on the interests they had specified. That number points out the absolute importance of allowing users to choose their own interest groups and have control over which business e-mails they receive. The most popular interest categories, according to the study, are coupons and household goods.

But your coupon is no good unless the user opens the email. Users in the study said the most compelling reason for them to open a business email is the name in the “from” field. So it’s a good idea to make sure your company name is clearly stated there. Another major factor is the “subject” line. Users cite discount offers and interesting news as the most compelling subject lines, followed by new product announcements and free shipping offers.

4. Click-through and conversion: Show me the money!

So the user has opened your email and read the content. Great. But where’s the sale? There’s good news here. For one, consumers are increasingly likely to make purchases as a direct result of a business email campaign. One-third of users in the DoubleClick study had purchased something by clicking a link on an email. Another 42% clicked on an email link for more information, then purchased the product at a later time. Second, online couponing is booming: 73% of consumers have redeemed an online coupon for an online purchase, and 59% have redeemed an online coupon offline.

In terms of industries, the top performers are travel, hardware/software, electronics, apparel, food, home furnishings, gifts/flowers and sporting goods. All companies sending business emails in those categories said between 71% and 80% of recipients have purchased their products because of an email campaign.

There’s no need to fret if your company doesn’t fit in to one of those industries. The overall landscape for email marketing conversions is looking brighter every day. The average click-to-purchase rate has increased nearly 30% since 2004 and the average orders-per-email-delivered rate has increased more than 18% since last year.

5. Stats tracking: Who are my real consumers?

E-mail marketing is an increasingly popular tool in effective CRM, and it’s about time more businesses recognize that. First off, if your provider’s email services for business do not include detailed, real-time tracking, you’re getting a raw deal. Real-time tracking is now an industry standard, and it’s highly valuable, as it allows you to see the exact moment a user opens your campaign, clicks on your link and makes that purchase. Studying your users can help you improve your communications efforts, so each campaign performs better than the last (several email service providers also let you compare the performance of your campaigns).

But many marketers are still in the dark. According to a recent WebTrends research, only 5% of marketers are very confident in the measurement of their online marketing efforts, while 26% admit they’re “flying blind.” WebTrends says the low confidence comes from a lack of knowledge when it comes to measurement, which means there’s still a lot of work to be done.

In email marketing, a blind shot won’t take you very far. But if you aim properly by following these essential rules of play, you should soon be reaping the same major results as so many online and offline businesses.

Article by

Robert Burko

http://www.articlesbase.com/email-articles/tips-for-effective-email-marketing-83868.html

June 14th, 2009 by admin

False economies of using Indian Code Shops

Most of you will have seen the emails before.  If you’re a software development company most of the time its asking you to outsource your projects to them to cut your costs, if you’re a software purchaser it’ll be telling you how they can deliver your project on-time in budget and with brilliant code.

You guessed it I am of course talking about the broken English emails of the Indian code shop.

This is a typical email you’ll receive from them

It’s Jennifer,

Brief about our company:

We are a professional web development company based in India with a team of experienced web/internet programmers and designers. We have over 5 years experienced in this field with a number of high profile customers. Our skill set includes Microsoft technologies, asp, .NET, php, java, xml and major data bases. We have a good design team with extensive knowledge of macromedia products include photo shop, dream weaver, fireworks and flash. We have over a period of time developed than 200 websites and applications for various industries and sectors.

As a solution provider we develop custom web applications including e-commerce solutions and intranet applications. We have number of satisfied customers in the US and Europe. The majority of work is outsourced from these customers. Our company ethos is to deliver high quality solutions while being cost effective.

We believe that you can save up to 40-50% on your project cost per project by working with us in partnership.

With the services we offer we believe we can add value to your company and organization and would hope that you would be interested informing a working partnership with our offshore company.

We understand that this type of work may be new to you so why not try our services with a small job to start with. This will help you to understand our working methodology and ethos for high quality and cost effective pricing

If you would like more information about our company please visit www.BLAH.com

Here’s some of the links below:

*LINKS REMOVED

Upcoming sites

*LINKS REMOVED*
If you have any questions or queries please do not hesitate to contact me.

Regards,

Jennifer
Business Development Manager

Contact:-
E-mail :- jennifer@BLAH.com
Skype :- jennifer
Mobile :- 0123456789

No to most that will sound all well and good and you’ll be sat there thinking to yourself “why should I pay 3 grand for a UK supplier when I can go to India and have it done for £800″.

There’s nothing wrong with that thought of course that’s what these companies rely on you thinking.  One of our clients recently got taken in by a very professional looking Indian code shop promising to deliver his e-Commerce package for a fine £800 all within deadlines and fully functioning.

A month after his deadline had passed he finally realised that the project wasn’t going to be complete and asked FC Software to finish it off and prepare it for live for him.  He was emailed the code from the code shop and forwarded it straight onto me.

Now I’ve been aware of Indian code shops for ages and have heard horror stories but I’ve never actually seen any code generated by them.  I now wish I hadn’t.

I’ll skip the gory details (if you want them though feel free to contact me or post in the comments) and just give you a summary.

  • Broken Code
  • Missing Files
  • 400k+ individual .php files with 1k lines of commented out code
  • Unused DB tables
  • Vulnerable to SQL Injection
  • Unfinished pages

After 2 weeks of working on the site I’ve just about got the front end (customer side) up to scratch I haven’t even got 10% of the way through the admin panel yet.  There’s still some bits of the front end code which are almost like black magic as in they’re there but I can’t work out what they’re supposed to do or even where some of them are calling their variables from!

To top it all off the payment system setup was PayPal so you need some kind of PayPal return page after transaction complete this was missing all together and when asked for the file instead they sent us through images of their offices.

This was the icing on the cake and really opened my eyes as to exactly what the code shops are like.  I’ve attached the images below notice the damp on the walls, the newspaper on the windows, the precariously balanced air con unit, bundles of wires and of course how can you forget the office door sign!

In the end this project has cost our client not only the price for us to write him an e-Commerce package from scratch but also the £800 for the Indian code shop.

The morale of this story is simple. DON’T DO IT.  It seems like you’ll be able to save yourself and your company money but in the long run you end up costing yourself money and with a substandard solution.

Don’t outsource under the false pretense of saving yourself some time/money while UK firms sound more expensive we are more regulated to deliver a product fit for purpose and take more pride in our work.

The Door

Nice BlindsThe perfect working environmentHealth and Safety at its finest

If any of you have any further experience with Indian code shops please get in touch I’m quite interested now if its just my luck providing me with this experience or are they all as bad as this.

June 13th, 2009 by admin

Welcome to the FC Software Blog

This small corner of the FC Software website is a place to allow the FC staff to post about their lives at FC Software.

What is it really like to work on an Email Marketing and Campaign tool that is capable of sending millions of emails a minute?

Just how much depends on you getting it right the first time when your product sits at the very heart of someone else’s business as our CRM products do?

All should become clear over time via the FC blog

April 13th, 2009 by admin