Call   0208 3131682   Mon-Fri 9am-6pm
Monthly Archives

August 2019

Why it’s important for charities to have an online presence

By | Charities, Digital | No Comments

Many charities have started making their online presence high priority. Creating an online home and go-to has proven to help in making the charity more visible and accessible to the public. For many charities though, there has been some difficulty in transitioning to a more digital presence. Many have had difficulties adjusting and going with the flow of technological advancement. To be honest, change is difficult –maybe more so for organisations that have long done their processes a certain way and are now faced with the reality that they must slowly adjust and put importance to a website and presence online. It is a necessary move though since the advantages are too many to just put aside.

So, why is it important for charities to trudge on and create an online presence? Let me give you a few reasons why:

 

Being online much improves the possibility for audience reach

If for anything else, improving a charity’s audience reach is reason enough to focus on getting a great website and strengthening its online presence. Being a charity, having a bigger audience available to it and in support of its advocacies and goals is a great advantage. A great website that is designed well can help with that. A bigger audience reach also makes it possible for charities to host and hold bigger events for their cause. Overall, a bigger audience reach can help a charity succeed even more.

 

An online presence makes it possible to reach the right audience

Very much related to an increased audience reach, more specifically, having an online presence and website makes reaching the right audiences easier and more attainable. Having a wide net is great and it gets the attention of a lot of people, but making sure that the right people pay attention is even more important. Charities that have their websites made well and strong online presence set up have a bigger probability of getting the right attention from people that can help and support the charity and its cause. It can also reach the right people who need their help the most. It very well done website also allows people that have, in the past, problems with getting the help and support they need a chance to be seen and heard and noticed. An example of this is how those that may have challenges for travel or mobility can be allowed to reach out and receive the services they need. 

 

An online presence gives an opportunity to create and build relationships

It makes sense –bigger reach means a bigger audience, and a bigger audience means a bigger chance to touch base with the right people for the charity. Connecting with the right people, more importantly, gives the opportunity for charities to create and build relationships with them and 1) be more available and attuned to their needs, and 2) learn more about how to improve what services the charity provides. The other side of this is that it allows, too, for charities to connect and build relationships with more people that are willing to help.

Having a custom, well-designed website also adds a more personable and approachable “face” for the charity. Creating a relationship with its audience allows it to be perceived as less daunting and stiff as it would be if the charity were viewed as just an organisation. This has been shown to have a positive effect on the people interacting with the charity and is an advantage in itself.

 

Marketing and fundraising becomes easier and it becomes easier for people to give

One very important reason for a charity to have a great website and an online presence is that it opens doors and channels for marketing and fundraising. Presently, there are many available services that charities can utilise to help them in raising funds, or a page or a part of the website can be dedicated to helping people better understand its cause and make them more open to share and donate. Merely having the means to donate present on the website of a charity does wonders in helping raise funds for projects and advocacies. Utilising other channels such as social media creates even more possibilities for charities to be known and to raise funds.

Having an online presence for charities should very well be at the very top of their priority list. The advantages are many and it would be good not only for the charity but also for the cause that they serve. There may be challenges to making this possible and finding a great partner to work with for custom websites is a must. Having an online presence now is a need for charities. It is a need that must be addressed for charities to better succeed.

 

-This article was written by Abby Villarica from Green Box

SQL for use in migrating a Drupal website to WordPress

By | Drupal, Drupal to Wordpress Migration, SQL | No Comments

Currently I’m working on migrating a Drupal 7 website to WordPress, in the process I’ve learned alot about the Drupal database schema. So this post is a place for me to store handy queries and notes. Its a Work in Progress so I’ll add more over the coming weeks.

Content types in Drupal are similar to post types in WordPress where fields can be added, however in the database how the fields are handled is very different from WordPress. In Drupal fields are added as separate tables.

SQL to get multiple images ( stored as a collection item field in Drupal)

The field is called field_images stored in the table field_data_field_images table. Because the field is collection there is only 1 value stored in the field_data_field_images table ( the collection id). To get the individual items of the collection (images in this case), we need to join to file usage table on that id then to file_managed table on the fid. Then we have the information about the images ( filenames etc ).

select n.nid, n.title,  m.* from node n
left join field_data_field_images f on n.nid = f.entity_id
left join file_usage u on f.field_images_value = u.id
left join file_managed m on u.fid = m.fid
where n.nid = node_id

Get all fields on a content_type 

eg for content type ‘bobs_tyre’

SELECT field_name FROM field_config_instance ci WHERE ci.bundle = ‘bobs_tyre’