Drupal

Drupal is a free software package that allows an individual, a community of users, or an enterprise to easily publish, manage and organize a wide variety of content on a website. Hundreds of thousands of people and organizations are using Drupal to power an endless variety of web sites, including

• Community web portals
• Discussion sites
• Corporate web sites
• Intranet applications
• Personal web sites or blogs
• Aficionado sites
• E-commerce applications
• Resource directories
• Social Networking sites

Read more

If you are a company based in NCR and looking for professional consultancy in Drupal then call me at 9810949699. We at Sparxsys Solutions work on Drupal and have build some really cool websites. If you are a web development company and want to train their employees then do let us know.

Also subscribe to our blog http://www.sparxsys.com/blog where we write mostly on Drupal and other Open Source Technologies.

Sparxsys is a professional Drupal consultancy company, specializing in custom development of high quality websites. Our rapid development process allows us to build feature-rich web solutions for our clients quickly and affordably. We offer full-service web development including custom Drupal development, logo design and branding, visual design, Drupal theming, user training, and site maintenance.

We are a startup company and use Open Source heavily for all our development. This is one of the main reason that we offer affordable services.

Check out some really cool websites created by us:

Timerays: http://www.sparxsys.com/projects/timerays
Creative Infra: http://www.sparxsys.com/projects/creative-infra
WeddingAlliances: http://www.sparxsys.com/projects/wedding-alliances

Read more

I am blogging after so many days, but there is a good reason for it. We revamped our company website completely and we tried to gave it a complete different look.

Check this out.

Read more

I downloaded the latest drupal from the cvs using the command below.

When I tried to install the drupal it gave me a blank page when I clicked on "Install drupal in english". I tried everything from re-downloading the code to commeting some lines in the install.inc file but all in vain but finaly I have fixed it. I know it is kinda dirty way of fixing things. I saw this page http://drupal.org/node/298391 while searching for solution. Though I did not apply the patch. I made the change in the includes/install.inc file manually.

In the function "function drupal_detect_database_types()" Replace this portion of the code.

Read more

These days I am working on my other site www.ggsipu.info to build the database of all the colleges affiliated to GGSIPU. I created a Custom Content Type to have various fields like college address, phone, fax, email, rating, etc. During the counselling time the students wants to compare various colleges based on various parameters like infrastructure, campus and other things. Now I wanted to create a view where a table is shown with the names of the colleges in the header and these parameters on rows.

I created a view table, but obviously it showed the college names in the rows as it is the dynamic part. I searched around a lot on drupal and google and found this amazing piece of code that transpose the rows/columns.

You just need to replace YOURTHEME with the name of the theme and VIEWNAME with the view name and that's it!

Read more

Drupal is an English rendering of the Dutch word “druppel”, which means “drop” (as in “a water droplet”). The choice of “drop” was merely coincidental, Dries Buytaert the original writer wanted to register dorp.org (meaning “village” in Dutch, in reference to his program’s community aspect) Dries made a typo when checking the domain name and thought it sounded better.

Source: http://hehe2.net/apps/etymology-of-an-open-source-appproject/

Drupal Delhi meetup is a gathering of drupal enthusiasts in Delhi. This meetup is focused at getting together and coding for drupal. The event will focus on module development and theme development for drupal. There will be two talks, one focused on drupal module development and another one focused at drupal theme development. Following the talks we will have hacking session for coding a module and a theme.

Read more

I installed Drupal 6 today on my windows machine in office. After creating the first user I tried to access the Administration Page, but a blank page was returned. I searched google to fix this problem and got this link.

http://www.tmsnetwork.org/blog/content/2008/08/22/drupal-6-slow-administ...

Go to system table and change the value of 'status', 'bootstrap' and 'throttle' to 0

Now you should be able to access the ./admin area :)

What a day it was!! Hectic!!

1. Got up early.
2. Exercised.
3. Tried couple of Open Source web based Project Management Softwares like dotproject and tutos.
4. Left home at 12 for barcamp.
5. Barcamp was nice, saw many familiar faces there and finally met Daksh Sharma :) nice to meet him.
6. Went to Ansal Plaza and met Mr. Anoop Yogi, he is a famous yoga and meditation teacher. He needs a website to showcase his work. It would be a simple site and you guessed it right, I will be using Drupal!!.
7. Went to South Ex, roamed around.
8. Went to CP again roamed around and had dinner at Sagar Ratna there, I love going there. Nice food and I like Sambhar :p.
9. Came back to home and I am tired now, going to sleep now.

I was looking for a good Project Management Open Source tool for managing my Project and Tasks. I tried many tools like SugarCRM, dotProject and couple of other. I tried them but did not like them, I mean these tools could be very good for someone but not me.

I just need a simple tool where I can manage Project and Project Tasks. These tasks can be assigned to Resources. I don't really need Advanced features like Gantt Charts etc.

The other day I saw a post on Drupal.org where someone has mentioned that you can use Organic Groups and Case Tracker Module together and achieve a simple Project Management system. I liked the idea. I installed both the modules and to my surprise I was able to do exactly what I wanted to do.

The trick is actually very simple.

1. Use Organic Group to create Projects.
2. Add Group members that will act as resources
3. Use Case Tracker as a Post in Organic Group. This means that Cases can be associated with the Organic Groups (Projects).

When you create any case (task) and assign it to a member of that group (project) a mail is sent to the member. Which is great. It is like a Notification.

I will post a detailed tutorial soon. In the mean time if you are stuck somewhere please post your comments here. I am sure with some more experimenting you can setup a good Project Management system in our beloved Drupal.

One again Drupal saved my day.

If you are hosting your Drupal website on Dreamhost then you may not be aware that Dreamhost provides a nice stats feature for all the domains.

It is normally accessible at www.yoursite.com/stats but the problem is that with Drupal's clean_url enabled you will get "Page not found" error.

Their is an easy resolution for this. Just add the following three lines on top of your .htaccess file.

RewriteCond %{REQUEST_URI} ^/stats/(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^/failed_auth.html$
RewriteRule ^.*$ - [L]

Now you can access www.yoursite.com/stats, you need to set a password for it in your Dreamhost Control Panel.

Internet Explorer does not display transparent PNG images, there is a drupal module "pngfix" to fix this.

Image without installing pngfix

Image after installing pngfix

Step to enable PNGFIX Module and its configuration.

1. Upload the Module "pngfix" to your Drupal Modules directory
2. Enable the Module
3. Go to /admin/settings/pngfix and enter ".pngfix" in the CSS Classes and Save Configuration.

4. Put the IMG tag under DIV block use pngfix class like this <div class="pngfix"><img ... /></div>

Creating my own Database Driven Dynamic website was a dream for me, yeah I know it is not that difficult, but when you want a Blog, a Powerful CMS, User Registration, Email, Forums, Comments, Access Restriction based on User Roles and bla bla bla other cool things in your website then it get little tough. The very though of making a website with all these features used to Haunt me. I think I am a good Programmer but I am a Lazy person. I do not like do same things again and again.

Read more