Whether you are looking to advertise your products online or want to improve your current ecommerce website, here are the top 10 must-haves that we recommend inputting onto your platform!
As a digital business, we acknowledge the importance of optimising our website for users online. Amongst marketing strategies and brand design, customers and target audiences are some of the most important parts of any business. Because of this, creating a user-friendly platform is essential for a successful ecommerce website. In order to achieve this, you will want to make your customers purchasing experience as easy as possible. One way you can do this is by improving search functionality. When a customer looks up a product, providing them with autocompleted suggestions will not only make the process as quick and easy for the customers, but it will also highlight other products that they may be interested in!
Most online shopping is conducted on a mobile device. Therefore, it is important to make sure your ecommerce website is optimised for this. Not only will this help to create a better purchasing experience for the buyer, but it will also lead to an increase in sales for your business!
To accompany your product descriptions, you will need to upload visually appealing product images to attract and target your audience. Making sure to include a variety of images showing different angles and close ups will also help to satisfy the buyer, resulting in a greater chance of purchase.
Incorporating 'candid' images of customers using or wearing your product will help to persuade the buyer whilst also bringing authenticity to your website.
As you will be uploading several images to your site, it is crucial that these files are optimised to ensure the loading speed isn't affected.
Product reviews are just as important as applying plenty of images to your site. This is because they can emphasise the quality of what you are selling. Using genuine customer reviews to market your products is a great way of adding credibility to your brand whilst also encouraging completion of the users purchasing experience.
Offering customers money off selective products/services will motivate them to buy more from your website. Most ecommerce websites nowadays have a constant flow of offers on a variety of products. This helps to retain your customers as they will keep coming back to your great sales! It will also entice users to learn more about your competitive prices.
Inputting a plugin that allows users to see related or suggested items below a product is another great feature that can encourage additional purchases. This also helps to highlight other products that you have available without users needing to use the search tool.
Frequently asked questions may help to resolve issues that a customer is having. Whether this be about the return policy, delivery options or tracking their order, including an FAQ's page is an easy way of generating customer service more efficiently.
By sharing your products across social media, you will be able to obtain a better reach towards your target audience. Implementing social media plugins onto your ecommerce website will also allow customers to follow your content which will in turn, help to build up authority and online performance.
To ensure your customer information is protected, it is important to use a secure ecommerce platform to ensure privacy and allow users to trust your website. Sites such as Magento, WordPress and WooCommerce are recommended as some of the most secure ecommerce platforms.
To create a secure ecommerce website, make sure you have access to and enable the following:
To complete a user's purchasing journey, it is a good idea to offer a range of payment options. Doing this provides customers with flexibility and will likely make them complete a sale. Some advanced payment options you could include are:
Web development is often referred to as the backbone of every website. This is because it is responsible for all of the following:
Based on this, it is important that businesses in the digital industry keep up to date with web development trends. Not only can this potentially help to improve the performance and visibility of your company online, but it can also provide users with insights into your developing skills, especially if you are involved in this speciality.
As we gradually close the doors on what has been a very strong year in terms of development, why not check out a few trends that will be expected to make an appearance in 2022:
Artificial Intelligence has become a great way for businesses to advertise and promote their services. This year, we have seen a considerable increase in chatbots across the web. This is expected to continue into the new year with AI technology being able to do a number of other tasks. This varies from simply communicating with new visitors and collecting data to solving problems and answering user enquiries. Because of this, we will see chatbots controlling a large portion of websites as well as helping to simplify user experience online.
PWA, also known as Progressive Web Applications alows users to view content on a mobile device and alter to the size of their phone. Using this platform means that whatever device the user is accessing the browser, the page loading speed remains the same as if it were on computer. This means that the visibility and ranking of your website won't be impacted.
Other benefits of using Progressive Web Applications include:
AMP is an alternative to this platform and makes it possible to speed up the page loading in comparison to HTML options. This system also works well when using animation and video content as it doesn't overload when activated.
Voice control allows users to quickly find answers to long search queries in just a matter of seconds. This system has grown across the web and is now used on most mobile and home devices. Because of this, it is expected that next year, we will see the implementation of voice control being developed onto several websites and applications.
Next year will see a dominant focus in user experience as developers begin simplifying site navigation, making it easier for users to gain information and work through webpages. The use of Single-Page Application helps to also achieve:
The content on a SPA site is completely loaded through JavaScript which helps to avoid reloading and allows for a faster page loading speed.
The TypeScript programming language not only helps to fix bugs in JavaScript but is also used by developers for a number of other reasons. These include:
This programming language will therefore help to improve the user experience whilst also simplifying workflow for developers.
Although most applications are written in JavaScript, using this programming language can sometimes affect the speed of work especially when it comes to large and fully developed calculations.
WebAssembly is a technology that helps to resolve this issue by allowing developers to write code using any programming language. This is then compiled into bytecode before being launched using the browser.
Perfect for compute-heavy applications, this tool provides a range of benefits:
Whilst some websites will continue using traditional development strategies, it is clear that next year, we will begin to see a dramatic improvement in site speed and user experience. Developers will do this by combingin minimalism with simplified code to create a much easier and more efficient platform.
Whether you are a small business or just starting out, one of the most important things to consider when working on projects is to find the right tools, techniques and management software. This will help to ensure your work is monitored, up to date and completed efficiently. Especially if you are a part of a B2B business, you will have quite a lot of deadlines to meet for your clients. Using a project management tool that can help with this will not only keep your clients happy, but it will also show others that you are reliable and well-organised with your work.
Here's a few things to consider when looking for the right project management software for your business:
It is crucial that the user interface within your chosen project management software is easy to navigate and provides your team with fast loading speeds and updates. This is one of the main factors when dealing with client work as you will need to be efficient with completing projects. Without an easy to use and quick interface, it will be difficult to meet your client's targets.
To ensure you can complete tasks as quickly as possible, you will need a software that is easy to learn just as efficiently. Does the tool have good tech support if you need it? Are there tutorials or training guides that you can watch to help you learn more quickly? There's nothing worse than trying to organise your work and complete projects for clients all while tying to understand what should be a basic project management system.
As well as this, the tool that you decide to use should also have good functionality in order to provide you with a simpler working experience. This should include:
As much as project management tools are great for small, starter businesses, whatever platform you choose should always be capable of allowing for company growth. Whether that means the size of projects you take on or the number of clients you acquire. Similar to this, the tool should also be affordable with scalable options available in case of team expansion.
You may need to link some projects of information to other digital platforms such as Google or Microsoft. Because of this, it is important to make sure the platform you choose can integrate with these websites.
Some other key features that you should look out for include:
Based on the information we have listed, here are a few project management tools that we would recommend:
From social media networking to artificial intelligence and voice recognition, this last decade has seen a huge growth in technology development. Especially for these digital platforms, we can't imagine the impact this will have on the next 10 years. Here's our prediction...
In the last 10 years, the growth of Artificial Intelligence has allowed us to witness its vast capability in many ways. From automobiles, computers, phones and marketing, we predict that this technology will quickly expand as AI machines continue to learn, act and transform the world around us.
5G has been a dominant feature these past few years and will continue to grow due to the manufacturing of more 5G compatible devices. This technology has already provided its users with faster broadband speeds as well as reliable wireless and mobile networks. Because of this, it is in no doubt that 5G will impact the future of wireless technology. Not only this, but with high data transfer, 5G will also help improve the performance of self-driving cars due to real-time data being received whilst you drive.
Alexa, Siri and Google are just a few examples of voice systems that have impacted the last decade. Starting at a simple chatbot on our phones, to a reliable system that many household members use in their day-to-day lives. Chatbots are now featured across most websites online as it is assumed to be a common feature for helping to improve user experience.
Since its development, this technology has also helped users by providing endless sources of information from trusted search engines. This quick and easy method has improved the performance of many businesses as it has given them the ability of completing tasks through the help of these voice systems. We predict that this technology will continue to become a dominant feature across many digital platforms.
The idea of autonomous cars has really taken flight in the last few years. However, this decade we will expect the trend to expand across all types of vehicles such as taxis, trucks and ships. The development of autonomous vehicles has truly impacted the definition of transportation as we begin to see the introduction of self-driving cars, taking comfort and futurism to the next level!
This next decade, we will see a huge development when it comes to robots and their great intelligence. Not only can they already learn, understand and respond to different environments, but robots now have the ability of performing tasks without human assistance. This will definitely see an impact in certain working industries as the term "cobot" (collaborative robot) continues to rise.
Digital platforms such as Facebook, Uber and Airbnb have grown in popularity since the beginning of last decade. Because of this, many digital users have started using these platforms as another form of marketing for their business. We predict that this platform-based method will become imperative for many online companies when it comes to their business strategies.
Whether you are building a brand-new website or are thinking of redesigning for your business, there are many factors to take into consideration in order to achieve effective results and reach your target audience. Take a look at these tips into developing a successful platform for your brand!
Picture this, a client has come to you with a project idea with the hopes of receiving an effective solution to improve their online business.
As a development company, it is always important to create a clear project management plan that helps to identify the key strategies of your development process. Doing this can determine the performance and effectiveness of your project and will allow you to create a finaly product that greatly meets the client's expectations. Here are a few tips that you can follow when it comes to managing your project:
In order to make a project successful, you will need a wide range of knowledge about the customer's needs and expectations for the final product. This should include things like:
By identifying these key points, you will be able to build a strong foundation for the development process. Once you have a clear idea of the client's expectations, it is important to assign key responsibilities for everyone involved in the project. Allocating work to those with certain strengths and skills can ensure the project gets done to the best ability. As well as this, it is important to establish various tracking methods so you know how well the project is performing in real-time.
Whether you are a small or large company, there should always be one individual assigned as the project manger to ensure that all the jobs get done within the client's expected time. You can also benefit from a project manager to keep track of the work and make sure that everyone is set to complete the project effectively.
Throughout the development process, it is imprtant to define key milestones so you can identify the process and performance of your project. Creating a 'bit-by-bit' attitude can help you to better establish everyone's progress as well as any issues that arise. By doing this, you will be able to resolve any problems and in-turn, create a stronger project for your client. Testing your project after every milestone can also help to make sure that you are on the right track to completing the project successfully!
In order for the points above to work effectively, it is important that everyone communicates well throughout the project as this can help you to manage the process more successfully and clearly pinpoint the strength and weaknesses of the project.
Always finish the project by evaluating the final product and identify any issues that need to be fixed before submitting to the client. This ensures that you can provide the client with the best possible outcome for their business, creating a great user experience which is guaranteed to generate positive feedback and potential growth for your company as well!
There are a range of project management tools and software available to help with the process. Some include:
Afternoon, just a quick tutorial about the File Input Field using twitter styling and Jquery to keep the look of your site. Bootstrap by Twitter - http://twitter.github.com/bootstrap/, is an excellent Framework of css, jquery and html5 including lots of plugins and style options
Using their form css styling is very easy and very well thought out, using simple class names to make the field elements to look standard across your whole site.
<input class="input-xlarge" name="text" type="text" />
will give you a nice look input box:
However, as I discovered on a recent project there is not an input style available for a file input field…
So I researched good old google and this is what i came up with..
first the HTML:
<label>Brochure File</label>
<input id="pdffile" style="visibility: hidden;" name="file" type="file" />
<div class="input-append"><input id="subfile" class="input-xlarge" name="subfile" type="text" /> <a class="btn">Browse</a></div>
The div class=”input-append” will attach a button to the input field to make it look nice.walkthrough :
Firstly create a normal input type=”file” but we set it to not display (display:hidden)
We are going to use jquery magic to fill the value of this box…
we add an ‘onclick’ catch to the btn to trigger the file input hidden field.
onclick=”$(‘#pdffile’).click();”
So we now get a browse box up to choose a file, in this case a pdf..
Once a file is chosen the input file receives a value, but is still hidden..
Using another jquery event ‘change’ we now use this to fill in the ‘pretend’ text field..
$('#pdffile').change(function(){
$('#subfile').val($(this).val());
});
Basically , if input with id of pdffile changes we get ‘this’ value and put it in the the input field ‘subfile’
So we have a nicely styled input box that actually has no affect on the form at all.
In my next tutorial I am going to show you how to use html5 with an input box similar to above to resize an image client-side using canvas.
Please feel free to comment on this.
So occasionally it happens…
Someone will leave caps lock on and accidentally enter a url in UPPER case and we all know you will end up at 404 error page, file does not exist..
That is unless you have root access to your server and are able to turn the mod_spelling..
If you have access to root modify the httpd.conf file..
if you do add the following lines and this will make it work:
CheckSpelling On
CheckCaseOnly On
but what about if you do not have ssh access ?
basically this happened on a project I was working on recently (Today to be precise).
Firstly edit your .htaccess file and add these lines..
ErrorDocument 404 /404.php
basically this declares the error 404 page to be 404.php
Now create a 404.php in the root directory..
Add this code
Quick code runthrough…
User goes to yoursite.com/HELLOWORLD.php
the file is helloworld.php
$aurl will be the refering domain in this case : yoursite.com/HELLOWORLD.php
$lurl is then a lowercase version of the url : yoursite.com/helloworld.php
We then redirect to the lowercase page..
But if the page actually does not exist this would send the search into a continual loop.
So we add the next few lines..
if($aurl != $lurl) this line sees if the referring page is the same in uppercase as lowercase..
if it is nt it will redirect to the lowercase url.
If the lowercase url does not exist we end up back on the same page..
This time the referring url will be lowercase and the same…
So we know this time it is a true 404 error and redirect to the 404.html page.
This may not work in all cases as some php setups do not read the ‘REQUEST URI’ properly.
But this solution worked for me and was very easy to setup..
Hi in today’s tutorial I will show a quick bit of code that will swap a thumbnail to the large image with a nice fade effect.
Firstly I am going to have to create a Large image with a unique id (#mainpic) and underneath that a couple of smaller
thumbnails which on mouseover swap to the larger image…
I am hoping you all know how to add the jquery library and a external javascript file to your page..
Basic html code (without styling):
| <pre class="syntax"><img id="mainpic" alt="Image" data-src="images/image1.jpg" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img id="mainpic" src="images/image1.jpg" alt="Image" /></noscript> | |
| <img alt="Image1" data-src="images/image1.jpg" class="thumbnail lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img class="thumbnail" src="images/image1.jpg" alt="Image1" /></noscript> | |
| <img alt="Image2" data-src="images/image2.jpg" class="thumbnail lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img class="thumbnail" src="images/image2.jpg" alt="Image2" /></noscript> | |
| <img alt="Image3" data-src="images/image3.jpg" class="thumbnail lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img class="thumbnail" src="images/image3.jpg" alt="Image3" /></noscript> | |
| </pre> |
And a few basic styles :
#mainpic {
max-width:400px;
max-height:250px;
border:1px solid #000;
}
.thumbnail {
max-width:100px;
max-height:100px;
border:1px solid #000;
}
And now a bit of jquery magic…
The aim is to when you move the mouse over the thumbnail it will fade the mainpic out and replace it with the thumbnail you are currently hovering over.
$(document).ready(function() {
$(".thumbnail").mouseover(function(){
var smallthumb = $(this).attr("src");
$("#mainpic").fadeOut(function(){
$('#mainpic').attr("src",smallthumb).fadeIn();
});
});
});
I will explain the code,
the first line means that once the document is ready the function is ready to work.
the next line catches any mouseover of anything with a class of thumbnail.. in this example our thumbnail images.
we now get the value of the item contained within the mouseover and set this to the smallthumb variable.
Now we set the item with id #mainpic to fadeOut.
We apply a function within the fadeOut to set the #mainpic value to smallthumb.
Once the fadeout effect has completed we must fadein the new mainpic.
And at first this was great.. It did exactly what i wanted it to…
however if i went over the thumbnail of the mainpic it would fadeOut and backin again.
Not very professional!
So i added a couple of lines within the function.
Firstly to get the mainpic value..
If the mainpic is the same as the thumbnail value it would not do anything..
Here is the completed jquery code and it works perfect..
$(document).ready(function() {
$(".thumbnail").mouseover(function(){
var smallthumb = $(this).attr("src");
var bigthumb = $('#mainpic').attr("src");
if(bigthumb != smallthumb){
$("#mainpic").fadeOut(function(){
$('#mainpic').attr("src",smallthumb).fadeIn();
});
}
});
});
I hope this will help..
Good Afternoon everyone….
Another day or has passed and time is flying by this year..
Here is my next PHP code snippet (as promised) where I am going to pull data from a MYSQL database to fill a dropdown box.
I have been asked to take it a step further and display the full information from the database that is chosen from the option box.
So here we go..
For now create a sample database..
I am going to put some names and numbers as an example to help demonstrate the case..
CREATE TABLE `sample` (
`id` int(6) NOT NULL auto_increment,
`firstname` varchar(50) NOT NULL default '',
`color` varchar(50) NOT NULL default '',
`number` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
so thats the table created, now to put some data into it.
INSERT into sample VALUES('1','bob','red','86');
INSERT into sample VALUES('2','ben','blue','6');
INSERT into sample VALUES('3','bill','green','8');
INSERT into sample VALUES('4','jon','pink','44');
INSERT into sample VALUES('5','mike','yellow','58');
So that’s a small database made with a few different values in it.
This demo is not for any set purpose other than to provide you with an example
on how to achieve what is needed.
First of all you are going to need to connect to your database..
You should have your usernames and passwords all setup so replace the stars with your data.
Now providing you have filled out all your information correctly you should be able to connect to the database ready to get a result.
I personally would save this as its on php file called connect.db.php or similar. Everytime you need to you can call upon the file rather than retype the connection lines over and over again.
So thats the basic database and table and connection all setup so now for the main file..
Example Of PHP Snippet 3 - DSM Design
| </pre> | |
| <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST" name="optionform"><input name="submitted" type="hidden" value="yes" /><select name="changedata" onchange="this.form.submit();"><option selected="selected" value="NULL">Choose One</option><!--?php while($row = mysql_fetch_array($result)) { echo "<option>".$row['firstname']."</option>" ; } ?--><br /> | |
| </select></p> | |
| </form> |
To briefly cover what has happened…
We have connected to the database.
We have done a sql query on that database to get all values from the sample table.
If $num = 0 it means no data was found so it displays a message not an option box.
If we have a result
We have made a form that when submitted reloads itself…
We have included a hidden data of submitted = ‘yes’
(You will see why in next step)
We have created a SELECT / DROPDOWN box that ‘onChange’ will automatically submit the form.
The select box is populated with the firstname field from our sample table.
So what happens next ???
You choose a name from the drop down option box,
this sumits the form and sends 2 variables back to the same page..
The variables are : submitted with a value of yes
and : changedata with a value of the chosen name.
Next step is to display the information :
ID : ".$data['id'];
echo "
Name : ".$data['firstname'];
echo "
Favourite Colour : ".$data['color'];
echo "
Favourite Number : ".$data['number'];
echo "
Please select a different name to view their details";
} else {
// if form is not submitted
echo "Please select a name from the list to view data";
}
?>
So if you have chosen Bob from the list the result should look like :
ID : 1
Name : Bob
Favourite Colour : Red
Favourite Number : 86
Please select a different name to view their details
So there you have it…
I hope you have understood this tutorial and please feel free to leave a comment/improvements
you may have.
Morning all,
I just would like to tell you about a little product that I have found that deals with everything that you need to become a basic web host.
You look at many products, and there are alot out there, these range from WHMCS to WHMautopilot. I have tried many but being a PHP coder and like to do things for myself I keep coming back to the same thing…
This answers virtually everything I need, but it allows me to get in and change the things I need to make it work for my site.
The latest version is Autohost 5.0
My last version I used was 1.19 and I can see a lot of thought has gone into the upgrades:
The GUI is a lot clearer, unfortunately it still uses tables rather than divs in alot of places, but it works very effectively. The product runs very fast and seems to connect through to WHM without any problems at all.
The added feature of being able to import accounts direct from the server is an excellent addition. The customer panel is very clean and easy to follow, although again lacks some personal features I would like to see. This product is designed for selling of hosting with existing domain names, and there is no feature for adding domain registration to products. I myself have written an addon into my site to do this for all new accounts. But for $29.99 what would you want ? I also think with the great jQuery a few extra validations could make this product even more customer friendly. Stick around to learn a few additions i have made to the site…
I have also been using WHM autopilot which I believe is a great product, but is also very complex to use.
You can purchase it here : idev-autohost
This product is amazingly good value for money…
I am not going to tell you how to install the product as the instructions are all there..
In my next POST I am going to go through a few alterations that I have made to
my idev-autohost 5.0 to make
it (what I believe more user friendly).
I do believe that even without these changes, anyone that is setting up there own little hosting company would do well to try out a demo, or purchase it.
On a final note this product is only $29.99 including support.
For other products you can pay $200 + or rental at $29.99 a month.
These product may do more and self run, but like I say with a few
personal tweaks this product can be just as good.
Again the download link is : idev-autohost
In this post I am going to show you how to take the values from an array and use them, in a form option box. First of all we are going to make a simple array…
For this example i will just make a basic array, however you could use a<em> mysql_fetch_array()</em> to read data from a database to make your array then continue with step 2.
I will show you the basics of this in my next tut.
<pre class="syntax"><!--?php $options = array("option_1","option_2","option_3","option_4","option_5","option_6"); ?-->
</pre>
<form><select name="example"><!--?php foreach($options as $choice) { echo '<option value="'.$choice.'">'.$choice.'&lt;/option>'; } ?--></select></form>
As you can see this will give you all the options from the array into your option choices.
I hope this little snippet will help.
Over the course of the next couple of weeks I’m going to place a couple of blogs with a few little PHP Snippets.
These are here more for reference however they are open for discussion so feel free to reply with alternativesor comments or short cuts for my code.
I will try to describe exactly how it works as I go along.
So with this little PHP function you can put a filename into it and it will return you the FILETYPE
function file_extension($filename){
$path_info = pathinfo($filename);
return $path_info['extension'];
}
So the funtion is quite simply using the PHP function pathinfo()
As you can see you put the name in and pathinfo makes an array and from that you pull the ‘extension’
To call this function :
$filename = 'thisisanexample.pdf' ;
$filetype = file_extension('$filename');
echo $filetype;
Simple as that !
Today I am going to explain to you the basics of WinSCP.
WinSCP is a FREE FTP program and can be downloaded from their website.
It is an open source program that is very easy to use to with many features.
Its features include:
Firstly head over to their website and download the file. It’s around 3mb so depending on your connection it should take less than 1 minute to download. After the download finishes run the .exe file you have downloaded and install the program. You may need a quick reboot to finish the install. Now on your desktop you should have an shortcut icon. Feel free to go ahead and open the program up.
The first screen you come across should be :
This is where you need your FTP username and password from your host provider or from your cpanel.
Fill in the appropriate spaces provided for example :
If you noticed its normally : ftp.
And if you change the type to : FTP
And the Port to : 21
Unless you have been told otherwise.
If this is your own computer and no one has access to it, click the save button.
This will ask you to save the session for future use. You may want to save the password as well, to save having to type it in future.
After you click the save button (if you choose to) you will go to the stored session screen.
Now me personally I like to create a Shortcut on the desktop to go straight into the stored session.
To do this click > Shell Icon > Desktop Icon confirm the request and then change the name to an easy one to remember.
Now to start your FTP , highlight your session in the screen or click the new desktop icon.
Providing you have entered all the correct details you should connect to your web host in your folder
Now this is a simple drag and drop GUI very similar to Windows.
WinSCP . FTP , FREE & BRILLIANT!!
This is just touching on the many different possibilities available with WinSCP. This is used daily throughout the world.
My eldest daughter was sat at home today when I got home from work copy-pasting emails from her Yahoo mailbox into an Excel sheet. She needed the email in this format for some part of her work and she was on email 157 of 656 and also on her 6th hour. The spreadsheet needed to comprise of Date Sent, From, Subject and message. So I walked in and said that
why did she not just export from yahoo to Microsoft Excel ?
Well easier said than done…
After 10 mins research I discovered there was no easy way it seems of doing this..
I came across an article on Apple Support Forums that lead me the right way..
Thanks to ‘Barney-15E’ if he still online as the article is dated back in 2010.
Firstly I setup her Yahoo account on my mac mail as an iMap account.
Downloaded all the messages she needed.
Opened up AppleScript Editor (once I sussed out what it was)
Now this was new to me as I had never even looked at Applescript because as quoted on the net :
You can fit the people that love applescript in a small car or even a bike..
Anyway thats about as much as I can tell you about applescript..
I now have the email stored in a mailbox inside my INBOX.
This is the script I then used to get the results into Microsoft Excel:
tell application "Microsoft Excel"
set LinkRemoval to make new workbook
set theSheet to active sheet of LinkRemoval
set formula of range "D1" of theSheet to "Message"
set formula of range "C1" of theSheet to "Subject"
set formula of range "B1" of theSheet to "From"
set formula of range "A1" of theSheet to "Date"
end tell
tell application "Mail"
set theRow to 2
set theAccount to "Sales"
get account theAccount
set theMessages to messages of inbox
repeat with aMessage in theMessages
my SetDate(date received of aMessage, theRow, theSheet)
my SetFrom(sender of aMessage, theRow, theSheet)
my SetSubject(subject of aMessage, theRow, theSheet)
my SetMessage(content of aMessage, theRow, theSheet)
set theRow to theRow + 1
end repeat
end tell
on SetDate(theDate, theRow, theSheet)
tell application "Microsoft Excel"
set theRange to "A" & theRow
set formula of range theRange of theSheet to theDate
end tell
end SetDate
on SetFrom(theSender, theRow, theSheet)
tell application "Microsoft Excel"
set theRange to "B" & theRow
set formula of range theRange of theSheet to theSender
end tell
end SetFrom
on SetSubject(theSubject, theRow, theSheet)
tell application "Microsoft Excel"
set theRange to "C" & theRow
set formula of range theRange of theSheet to theSubject
end tell
end SetSubject
on SetMessage(theMessage, theRow, theSheet)
tell application "Microsoft Excel"
set theRange to "D" & theRow
set formula of range theRange of theSheet to theMessage
end tell
end SetMessage
Run the script and after a minute (depending on amount of messages) your excel sheet is complete.
Laravel 5.4 made a change to the default database character set, which will cause issues for anyone that is trying to run their new project using Older versions of MySQL (5.7.7 and below) or MariaDB.
It’s default charset is now utf8mb4 which includes support for storing emojis.
Recently I have tried migrating a project across from local development server to a production server running PHP 5.6 and MySQL 5.6 which are classed as STABLE RELEASE.
On trying to import the DB into phpmyadmin it crashes with the following error:
Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
However there is a migration fix which is listed within the documentation here (towards the bottom of the page)
Just open your project and find the AppServiceProvider.php inside app\providers directory.
And add the following line within the boot function:
However as practice we now add this line by default within our projects as most production servers are running the STABLE releases by default.
1 North Street, Poole,
Dorset, BH15 1NX
Mon-Thur: 9:00am - 5:00pm
Fri: 9:00am - 4:00pm
DSM Newsletter