Re: My Review For HXL Project - from spaceapps_jakarta - james

[David Saunders]

David Saunders
Chief ISS (interim) OCHA

---

  From: James Kachiro Sarumaha [jkac...@gmail.com]
  Sent: 05/09/2012 05:21 PM MST
  To: hxlpr...@googlegroups.com
  Subject: Re: My Review For HXL Project - from spaceapps_jakarta - james

Hi CJ,

I'm sorry for not contacting you.

I will show you my application next week. as you know, my application built using ROR but the view is constructed using javascript.

the excel view, HXL translation , exporter function/module is created using javascript.

So, I can integrate/merge them later to your main application if you find it interesting.

I love to work with this open source project.

In the future, I plan to built a visual data browser using semantic data source for my application, HXL Exporter. After I finish with it, I will sent it to you. if you like it, I can integrate to your main application.

Just keep me updated about your main application. If you want me to work together on your application, I can do that.

I promise you to show my application next week.

thanks

On Tuesday, April 24, 2012 4:54:35 AM UTC+7, James Kachiro Sarumaha wrote:

Hi CJ,

 

I have submitted my idea to spaceapps challenge (called, HXL) and I want to review my knowledge during the hackathon.

Hopefully, this can help you :

1. I have reviewed google application http://www.slideshare.net/danpaulsmith/linkedgov-extension-for-google-refine  --> code.google.com/p/google-refine/

   - It use java technology

   - It provides excel view after you have upload it, later you can re-edit and take the data that you need. --> basically, it is for parsing the excel, clean it , and collect the data to export.

   - it does not provide HXL translation yet

   - it use apache POI for parsing the excel - poi.apache.org 

--> we can work on provide the extenstion for HXL/ add 'generic adapter' for HXL

2. During the hackaton, I'm creating the application like google-refine but using ruby on rails (https://github.com/jammie/spaceapps_hxl).

   - it use ruby on rails

   - it provides excel view after you have upload it -

   - it does not support cleaning the data  -- I'm working on it

   - it provide HXL translation function -- need improvement

   - it does not check the data type -- I'm working on it

   - it use ruby-ole (OLE2) and spreadsheet gem to parse the excel - http://code.google.com/p/ruby-ole/

And I'm sorry that I hack your Sparql server for testing my application. I want to get the clear picture how HXL push to server :D ...

3. I heard from my friend (the creator of 'HXLator'), you want the application built in phyton. can you let me know about the progress?

If you plan to use phyton, I am able to help you.

4. I found out that there is another data storage server other than sparql, it called 'Sesame' (www.openrdf.org/) ... 

That's all.

Please let me know your current problem and next move.

looking forward for your response

thanks

James k

[James Kachiro Sarumaha]

Hi CJ,

I attach a file about my solution for HXL.

I can only give you this now. I hope you get my idea.

I can not work on the script and deploy my application because I have to take another rest for couple days.

I see that you will use HXLator, if you find an interesting feature from my application, let me know. 

thanks