Thursday, November 22, 2007

Open Data Standards

I was listening to a podcast on IT Conversations and the subject of Open Data Standards came up. It is very important that OrangeHRM does not lock in its data. Users of OrangeHRM should be able to switch to another system of their choice. At the same time users of other HR applications should be able to switch to OrangeHRM easily. This prompts us to look for an open data standard for HR data.

HR-XML comes the closest. We have been considering the idea of importing and exporting data using HR-XML for some time. However, OrangeHRM is community driven. Our users define its features on our forum and on our Wiki. We have had very few request from users for HR-XML. Most users seem to prefer import and export of data using simple CSV files.

CSV import and export feature is currently in development and we plan to make this available for the first time on the open source product in January.

We would like to hear your thoughts on this.

12 comments:

Chuck said...

CSV or HR-XML? I'm not sure this is really a useful question. There is a bit of the apples and oranges (no pun intended) problem with the question. Your platform likely needs to support both where suitable.

CSV has suitability for many purposes. I'd imagine that it would be useful for OrangeHRM to have CSV export capabilities. CSV is a good fit for many reports. You can move CSV data into spreadsheets and into other applications.

On the otherhand, not all HR data is tabular. Frankly, looking at things like jobs, positions, people, and competencies in a flat, tabular way is a giant step backward. Moreover, CSV isn't likely something with which you want to build service interfaces with.

I have a few suggestions:
* Choose data formats based on suitability to the task.
* Explore supporting the forthcoming 3.0. The 2.* generation of specifications really were more suited in terms of connecting arms-length trading partners. It would be difficult for OrangeHRM to use the 2.* standards as a general-purpose export format.
* Look to HR-XML primarily when you are looking to build services interfaces - e.g., getting new hire data from an ATS, sending enrollment data, etc.

Chuck Allen
Director, HR-XML Consortium, Inc.

Himath said...

Most users want CSV for a few main purposes:
(1) When they switch to OrangeHRM from spreadsheets or starting to use it as their first HR Software, they want to bulk import employee records to the system.
(2) Export report data.
(3) Export selected employee fields required for payroll systems.

Although employee data could be hierarchical, importing and exporting a subset of the core fields would be sufficient for most purposes. Therefore, we have identified that we need CSV import/export of data at least for employee records and reports.

We're following agile development methodologies. This selection is based on the principle that we should release what makes most values to the users in increments.

Having said that, I agree with you that CSV may not be the best way to go if we're to build a service interface. The next step for OrangeHRM is to move more toward an
SOA. We're considering exposing its data over a web services API especially for the purpose of interoperability (and possible mash-ups) with other enterprise systems. We haven't yet decided on the format of the data exchange and
HR-XML will be something we strongly consider.

I'm yet to have a look at HR-XML 3.0 although I spent some time studying the previous version sometime back.

Sharika Sharma said...

Hey very nice blog!! Man .. Beautiful .. Amazing .. I will bookmark your blog and take the feeds also…
HR Software

Brijmohan said...

If you had some way of rating posts I would for sure give you a high rating my friend! outbound call center

Unknown said...

There are certainly a lot of details like that to take into consideration. That’s a great point to bring up.
Auto Accident Attorney Houston,Texas

Unknown said...

A fantastic read….very literate and informative. Many thanks
Hypnose or hypnosis

Anonymous said...

ok - I have noted the name of the spa - was not planning on returning to Barbados anytime soon (too many places I need to travel to)

car parking games

parking games

Anonymous said...

Hey very nice blog!! Man .. Beautiful .. Amazing .. I will bookmark your blog and take the feeds also…

sports games

sniper games

Anonymous said...

I am very glad to see such information which I was searching for a long time.

promotional gifts

babbit said...

Great info keep up the blog posts
Chair covers

Unknown said...

I believe "Open Data Standards" makes the complete employee's task easier. Its easy to update, approve and maintain and this is very useful to many of us.


Time attendance systems

Unknown said...



Hey, thanks for that great investigation work on biosilk, i've been using it for some time now but always wondered what was in it. I don't see why our whores would smell worse than yours though.




Open Source Management Software