Zoho Projects underwent an update just now and the below features are now available.

Multiple Admins : Till now, Zoho Projects followed the single admin concept. But from now on, there can be multiple admins. The one who created the Zoho Projects account is assigned the super-admin / portal owner role. And he/she can designate other members as Administrators. These administrators have all the privileges as the portal owner except upgrading/downgrading the Zoho Projects account & changing the credit card details.

Task-Documents and Task-Forums Mapping : Along with adding Notes to a task (which is useful for knowing a task’s status etc), documents uploaded to Zoho Projects and discussion forums created for a project can now be associated with tasks. Multiple documents/forums can be associated with a task and a forum/document can be associated with any number of tasks.

Managers can add Clients : Project members in Manager role can now add (external) client members to the projects they manage. This gives a Manager fuller control over the project(s) he/she manages.

Separate iCal link for Google Calendar : Google Calendar follows the VEVENT component versus the VTODO component that needs to be followed for tasks/tasklists/milestones. To support GCal, Zoho Projects now has a separate GCal link. Clicking on the links, you can download an .ics file which you can import into your iCalendar / Google Calendar.

Test drive the new features in Zoho Projects and we would be glad hearing your comments.

We have featured the friendly Technologist cum Educator, Barry Dahl of Lake Superior College before. Barry continues to be a strong Zoho (and ToonDoo, Jambav) advocate for more than a couple of years now. From a recent post of his,

At the risk of sounding too much like a fanboy – I just have to say it one more time - love Toondoo and Zoho. This is nothing new for me since I’ve been sort of an evangelist for the past couple of years now. However, they continue to surprise me with how much they pay attention to their users and how responsive they are to suggestions or comments. With regard to Toondoo, back in Dec. 2007, I included them in my end of year list of the Top 12 Web 2.0 Tools. In that post I lamented the fact that I had wanted to use Toondoo with the elementary schools kids where I run the after-school Tech Club, but that I wouldn’t do it because there was too much inappropriate content on the site – mostly lame attempts at adult humor in cartoon format. Within a day or two of that post I received an email from Toondoo telling me that they had added a safe search button at the top of each page and a personal setting that can be turned on to not show any content that has been flagged as inappropriate. I was impressed with their responsiveness, but not terribly impressed with the solutions.

Then, earlier this month I included Toondoo in my post of the free web tools that I would be willing to pay for. My caveat here was that I would be willing to pay for the tool in order to use it with the youngsters if they could give me a protected environment

Lo and behold, I received an e-mail from Rajendran D. of Jambav within just a few days of making that post. TPTB at Jambav thought that was a good idea and were especially intrigued that I had even offered to pay for it. They are proposing that I be a beta tester for their new branded sites opportunity. They will provide a unique URL such as LakeSuperior.toondoo.com and allow me to host the members of my choosing. They are thinking that this service will probably sell for about $50 US per year, but they are offering it for free to me as a beta tester to use it with the students and to report back to them with suggestions and comments. This isn’t yet a totally done deal, but I’m confident that I will be able to try this out with the Tech Club when school starts up again in the fall.

Jambav is owned by Adventnet, which is a profitable software development company. Zoho is also owned by Adventnet, which gives them a potent 1-2 punch in my book. The most recent moment of Zen for me regarding Zoho tools was when I was presenting at the Tennessee Board of Regents Summer Institute last month (TBR08). I did two sessions on Zoho tools that were well attended and well received. There were many times that jaws dropped during those sessions as people saw some of the functionality that they didn’t know existed, or hadn’t taken the time to investigate. I always say that I think the Zoho suite is far advanced over Google Docs and Spreadsheets, and a few Google users confirmed what I was thinking about the power that is Zoho. I also did a session there about Toondoo, and there were so many great ideas about how to use comic strips for both student projects and for other purposes related to online courses and programs. For example, (1) make a Toonbook of frequently asked questions, (2) have students prepare a comic strip to introduce themselves at the beginning of the class, (3) instructor-created comic strip or toonbook as a topic teaser (introducing a new topic before more in-depth study), and several others.

Deepa, who uses Zoho for her day-to-day activities, writes about her usage of Zoho Creator, “Zoho Creator :- Only intuition, no programming”

I came across Zoho Creator, and have been trying it out for the past 6 months before making my first post about it here. I proudly admit the fact that I have integrated Zoho into my actual working environment, which has taken the load of report maintenance off my shoulders. These days, I spend only 2 hrs a week to consolidate my report. I use the free version, but sure have the plan to switch to business version soon enough.

The advantage of Zoho [Creator] lies in the fact that

1. There is no huge download or installation.. Because this is a WEB APPLICATION
2. The Registration is free
3. You need not have any programming knowledge
4. The interface is exceptionally intuitive
5. Drag – and – drop allows you to design custom forms
6. Logical flow of events will guide you to do the scripting.
7. Embed the form in your blog and collect data
8. Various choices on how you wish to process the data collected ( HTML, Excel, JASON, AJAX, Pdf , ) for novices and advanced users alike.
9. The feeds can be integrated into feed readers, HTML displayed within iframe,.. possibilities are immense.
10. Applications can be shared with any number of users ( say you have created the application and want you friend to moderate the content… go ahead and share it)

You can develop a simple form like Guest Book , which has minimum scripting ( auto date ), or , developing a complex form that allows you to generate and send email-verification code right from zoho form, which involves more complex scripting.

Bloggers have long loved interaction with their readers. After all, isn’t that why we enable comments? Here is something to take this level of interaction a step further. How about developing a custom application to cater to your needs?. Well, if you feel lack of programming knowledge, and the mind boggling software installation ( not to mention the price) is pinning you down, not anymore. Try Zoho Creator, I am sure you will eventually end up using it.

Thanks Barry & Deepa!

Do tell us how you are using Zoho, ToonDoo or Jambav. Email us or leave your comments below.

Zoho Sheet has this “Link External Data” functionality, which can be used to mashup with data on the web. It can sync your Zoho spreadsheet with data in public CSV files, HTML tables and RSS feeds. Zoho Sheet will basically fetch data periodically from the configured URL and update the spreadsheet automatically. You can then analyze on the external data by applying formulas or drawing charts. You can also publish / embed the resultant chart or a specific range or the whole spreadsheet. It gives you ample possibilities to mashup data from the web. A word of caution: While fetching data periodically from external websites, especially HTML pages, make sure you agree to the terms and conditions of the website.

Here is a short presentation which walks you through the various steps involved in configuring External Data in Zoho Sheet. It takes an example of automatic import of data from a public Zoho Creator view. The same can be done on a private Zoho Creator view by enabling private permalinks in Zoho Creator.

(view the presentation in full screen for better clarity)

Are you using this feature already? If so, let us know how you are using it.

Zoho DB & Reports offers a wide range of data types (column types) to store your tabular data. So far, the options offered for formatting the data stored in these column types have been limited. We have addressed this in our latest update.

Zoho DB & Reports now offers a wide variety of formatting options for each data type. With these options you can choose how you would like to have your data displayed in the various reports created.

How to format a column?

1. Select the table or tabular view in which the columns are to be formatted
2. Right click on the column that is to be formatted
3. Set the necessary formatting option in the dialog that pops up
4. Click OK to apply the formatting changes

Immediately you will see the formatting options being applied over the column. Zoho DB & Reports also ensures to carry over this formatting set for a column across all the reports (chart, pivot, summary & tabular) created including this column.

Formatting options supported include Text Alignment, No. of Decimal places (for all numeric data types), Currency Symbol (for currency type), Negative Number Display (for currency type), Date display format and Include thousand separator (for all numeric data types).

Customize Chart Coloring:

In Zoho DB & Reports the colors used in charts have been system generated so far. With the latest update you can now change the colors used in a chart to suit your taste. Follow the below given simple steps to customize the color in a chart:

1. Select the Chart whose colors are to be customized
2. Click Edit Design and go to edit mode
3. Click on any of the category colors listed in the legend (seen on the right side of the chart) to change the same.
4. A color chooser will pop up
5. Choose the color required
6. Click Apply to apply the color Or Click on Use Default if you would like to revert to system generated colors.

Auto-recognizing currency data during Import:

Now Zoho DB & Reports has included the intelligence to auto-identify a data column as currency when you import it into Zoho DB & Reports. You do not have to manually set the data type of those columns as currency, which had been the case so far. The data could be in any of the accepted currency formats (with currency symbol or abbreviation eg., $, USD etc.,) of any country. Auto-recognition would be applied when you import data into Zoho DB & Reports from any of CSV or .XLS or HTML files

Hope you find the above features useful. As always do give it a try and let us know your comments….

With regards,
Clarence
Zoho DB & Reports - Online Reporting & BI Service

Henry Thiele’s notebook titled, Should I know Web 2.0? Nice aggregation of text, links, images, audio & video from the world wide web combined with one’s own thoughts. Simply awesome! Another cool notebook from him : Digital Storytelling. Thanks Henry!

To our readers & Zoho users : Do leave your comments on how you are using Zoho Notebook.

Now you have complete flexibility and freedom to move your data in and out of Zoho Invoice at your will.  Yes, we are happy to announce the support for import and export functionality in Zoho Invoice, a feature long awaited but well worth the wait.

What can you import or export?

Your complete set of data!

Yes, you can import or export your customer information, contacts, the items you sell (products or services), invoices and quotes.

What are the formats supported?

We have support for most of the standard formats.

• Data can be exported in CSV (Comma Separated Values), TSV (Tab Separated Values), XLS (Spreadsheet) and JSON formats.  Additionally we also support exporting of customer and contact information in vCards (.vcf files) format.
• You can import your data in CSV (Comma Separated Values) or TSV (Tab Separated Values) formats.  Additionally we also support vCard format for importing your contacts or customer information

If you feel, we have missed out any important format drop us a note.  We will be more than happy to add support for that format.

Couple of screenshots for a quick look:

Importing contact information into Zoho Invoice:

Exporting invoices from Zoho Invoice:

Please feel free to share your comments.  You can try out this feature by signing into Zoho Invoice now.

Happy invoicing,
Siva