Prototype SocialCalc integration

[Ludovic Dubost]

I've done a nice experiment with SocialCalc and I'm pretty happy of the
results:

It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
server-side transformation of the spreadsheet to a Wiki table for
rendering, printing and pdfs, but it's already interesting.

http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc

Ludovic

--
Ludovic Dubost
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost


[ludovic.vcf]

---

begin:vcard
fn:Ludovic Dubost
n:Dubost;Ludovic
org:XWiki
adr:;;10 Rue Pernety;Paris;;75014;France
email;internet:[hidden email]
title:CEO
tel;work:01 45 42 40 90
tel;fax:[phone]
tel;home:09 54 26 92 14
tel;cell:06 09 34 92 14
x-mozilla-html:TRUE
url:http://www.xwiki.com
version:2.1
end:vcard

---

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Asiri Rathnayake]

Hi Ludovic,

On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[hidden email]> wrote:

>
> I've done a nice experiment with SocialCalc and I'm pretty happy of the
> results:
>
> It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
> server-side transformation of the spreadsheet to a Wiki table for rendering,
> printing and pdfs, but it's already interesting.
>
> http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>

Looks cool :)

Is there a way we can use social-calc / gdocs (or both) to allow users to
edit / save attached excel documents? . Didn't do any research myself, just
asking in case you have already done that part ;)

Thanks.

- Asiri

>
> Ludovic
>
> --
> Ludovic Dubost
> Blog: http://blog.ludovic.org/
> XWiki: http://www.xwiki.com
> Skype: ldubost GTalk: ldubost
>
>
> _______________________________________________
> devs mailing list
> [hidden email]
> http://lists.xwiki.org/mailman/listinfo/devs
>
>

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Pascal Voitot]

I don't know socialcalc model but it would be simple to integrate
GoogleSpreadsheet even if it would be done with something such an iframe for
the editor. One limitation: the doc will be stored in google not in xwiki.
I have been studying google api with groovy also and this works, you can
even create a spreadsheet from your script...

Pascal



---------- Forwarded message ----------
From: Asiri Rathnayake <[hidden email]>
Date: Thu, Oct 22, 2009 at 5:35 AM
Subject: Re: [xwiki-devs] Prototype SocialCalc integration
To: XWiki Developers <[hidden email]>


Hi Ludovic,

On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[hidden email]> wrote:

>
> I've done a nice experiment with SocialCalc and I'm pretty happy of the
> results:
>
> It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
> server-side transformation of the spreadsheet to a Wiki table for
rendering,
> printing and pdfs, but it's already interesting.
>
> http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>

Looks cool :)

Is there a way we can use social-calc / gdocs (or both) to allow users to
edit / save attached excel documents? . Didn't do any research myself, just
asking in case you have already done that part ;)

Thanks.

- Asiri

>
> Ludovic
>
> --
> Ludovic Dubost
> Blog: http://blog.ludovic.org/
> XWiki: http://www.xwiki.com
> Skype: ldubost GTalk: ldubost
>
>
> _______________________________________________
> devs mailing list
> [hidden email]
> http://lists.xwiki.org/mailman/listinfo/devs
>
>

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Guillaume Lerouge]

Hi,

On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake <
[hidden email]> wrote:

> Hi Ludovic,
>
> On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[hidden email]> wrote:
>
> >
> > I've done a nice experiment with SocialCalc and I'm pretty happy of the
> > results:
> >
> > It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
> > server-side transformation of the spreadsheet to a Wiki table for
> rendering,
> > printing and pdfs, but it's already interesting.
> >
> > http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>

Very very nice, seems like you made interesting progress since yersterday
:-)

Can the macro already be published on code.xwiki.org as is? Does it
require more than the macro page
to work? If not I can publish
http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro
on code.xwiki.org right away - although I'm not sure where the underlying JS
code is located right now.


> Looks cool :)
>
> Is there a way we can use social-calc / gdocs (or both) to allow users to
> edit / save attached excel documents? . Didn't do any research myself, just
> asking in case you have already done that part ;)
>

Not yet. I guess we'd need to write some kind of transformation thing on the
backend to allow editing an attached Excel spreadsheet right from the wiki
page but that would be pretty cool :-)

From http://www.socialtext.net/m/page/exchange/socialcalc_faq :
*
*

*Can I import an Excel spreadsheet into SocialCalc?**
**Right now you can import data from Excel by selecting a range in Excel,
copying it to the clipboard, and then doing a "Ctrl-V" paste in SocialCalc.
The values are pasted - no formats and no formulas. In the future we plan to
have more extensive Excel import, so that you can upload an Excel file and
turn it into a SocialCalc page, preserving some of the formatting and
(hopefully) formulas (where there is functional overlap). Macros will not be
imported. CSV file format import is also planned at some point.**
**Can I export from SocialCalc to Excel?**
**You can copy a range of data in SocialCalc (e.g., Ctrl-C) and then paste
it into Excel. CSV export will be available by July 17. Excel export is on
roadmap

*

So it looks like there's still some work to do for this to work.
*
*
Anyway, that's a good start!

Guillaume
*
*

> Thanks.
>
> - Asiri
>
>
> >
> > Ludovic
> >
> > --
> > Ludovic Dubost
> > Blog: http://blog.ludovic.org/
> > XWiki: http://www.xwiki.com
> > Skype: ldubost GTalk: ldubost
> >
> >
> > _______________________________________________
> > devs mailing list
> > [hidden email]
> > http://lists.xwiki.org/mailman/listinfo/devs
> >
> >
> _______________________________________________
> devs mailing list
> [hidden email]
> http://lists.xwiki.org/mailman/listinfo/devs
>

--
Guillaume Lerouge
Product Manager - XWiki SAS
Skype: wikibc
Twitter: glerouge
http://guillaumelerouge.com/
_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Ludovic Dubost-2]

Guillaume Lerouge a écrit :

> Hi,
>
> On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake <
> [hidden email]> wrote:
>
>  
>> Hi Ludovic,
>>
>> On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[hidden email]> wrote:
>>
>>    
>>> I've done a nice experiment with SocialCalc and I'm pretty happy of the
>>> results:
>>>
>>> It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
>>> server-side transformation of the spreadsheet to a Wiki table for
>>>      
>> rendering,
>>    
>>> printing and pdfs, but it's already interesting.
>>>
>>> http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>>>      
>
> Very very nice, seems like you made interesting progress since yersterday
> :-)
>
> Can the macro already be published on code.xwiki.org as is? Does it
> require more than the macro page
> to work? If not I can publish
> http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro
> on code.xwiki.org right away - although I'm not sure where the underlying JS
> code is located right now.
>
>  

Right now the JS and Images are in

xwiki/js/resources/socialcalc

We could turn all this into JSExtensions but I'm not sure it is a good
idea. It would make us fork the socialcalc codebase.
At this point I've been able to only add some JS and add some CSS and it
could even be in separate files.

I was thinking I could have made a zip of that directory and have it as
an attachment, but I don't think I can use the JSExtensions system with
zips attached in the Wiki

Ludovic


--
Ludovic Dubost
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Ludovic Dubost-2]

SocialCalc uses it's own format to declare the spreadsheet. I'm not sure
what is available to make a conversion from XLS to that format.
We could use our Excel plugin to do that if there is nothing in SocialCalc

For Google Docs, it's a very different Integration and we already did it
(it would need to be polished)

http://code.xwiki.org/xwiki/bin/view/Plugins/GoogleDocsPlugin

It sends an XWiki table to Google Docs for editing and has a method to
retrieve it.

Now Google Docs is the best editor (more powerfull than SocialCalc) but
it's not an option if you want to 100% keep your data inside.
SocialCalc is one of the best solutions for internal usage for simple
spreadsheet.

Ludovic

Asiri Rathnayake a écrit :

> Hi Ludovic,
>
> On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[hidden email]> wrote:
>
>  
>> I've done a nice experiment with SocialCalc and I'm pretty happy of the
>> results:
>>
>> It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
>> server-side transformation of the spreadsheet to a Wiki table for rendering,
>> printing and pdfs, but it's already interesting.
>>
>> http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>>
>>    
>
> Looks cool :)
>
> Is there a way we can use social-calc / gdocs (or both) to allow users to
> edit / save attached excel documents? . Didn't do any research myself, just
> asking in case you have already done that part ;)
>
> Thanks.
>
> - Asiri
>
>
>  
>> Ludovic
>>
>> --
>> Ludovic Dubost
>> Blog: http://blog.ludovic.org/
>> XWiki: http://www.xwiki.com
>> Skype: ldubost GTalk: ldubost
>>
>>
>> _______________________________________________
>> devs mailing list
>> [hidden email]
>> http://lists.xwiki.org/mailman/listinfo/devs
>>
>>
>>    
> _______________________________________________
> devs mailing list
> [hidden email]
> http://lists.xwiki.org/mailman/listinfo/devs
>
>  

--
Ludovic Dubost
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Sergiu Dumitriu-2]

On 10/22/2009 10:29 AM, Ludovic Dubost wrote:

> Guillaume Lerouge a écrit :
>> Hi,
>>
>> On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake<
>> [hidden email]>  wrote:
>>
>>
>>> Hi Ludovic,
>>>
>>> On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost<[hidden email]>  wrote:
>>>
>>>
>>>> I've done a nice experiment with SocialCalc and I'm pretty happy of the
>>>> results:
>>>>
>>>> It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
>>>> server-side transformation of the spreadsheet to a Wiki table for
>>>>
>>> rendering,
>>>
>>>> printing and pdfs, but it's already interesting.
>>>>
>>>> http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>>>>
>>
>> Very very nice, seems like you made interesting progress since yersterday
>> :-)
>>
>> Can the macro already be published on code.xwiki.org as is? Does it
>> require more than the macro page
>> to work? If not I can publish
>> http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro
>> on code.xwiki.org right away - although I'm not sure where the underlying JS
>> code is located right now.
>>
>>
> Right now the JS and Images are in
>
> xwiki/js/resources/socialcalc
>
> We could turn all this into JSExtensions but I'm not sure it is a good
> idea. It would make us fork the socialcalc codebase.
> At this point I've been able to only add some JS and add some CSS and it
> could even be in separate files.
>
> I was thinking I could have made a zip of that directory and have it as
> an attachment, but I don't think I can use the JSExtensions system with
> zips attached in the Wiki

But this could be a new feature.

--
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs

[Jerome Velociter-2]

On 10/22/09 10:29 AM, Ludovic Dubost wrote:

> Guillaume Lerouge a écrit :
>> Hi,
>>
>> On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake<
>> [hidden email]>  wrote:
>>
>>
>>> Hi Ludovic,
>>>
>>> On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost<[hidden email]>  wrote:
>>>
>>>
>>>> I've done a nice experiment with SocialCalc and I'm pretty happy of the
>>>> results:
>>>>
>>>> It allows to edit a spreadsheet stored in a Wiki Page. It lacks a
>>>> server-side transformation of the spreadsheet to a Wiki table for
>>>>
>>> rendering,
>>>
>>>> printing and pdfs, but it's already interesting.
>>>>
>>>> http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc
>>>>
>>
>> Very very nice, seems like you made interesting progress since yersterday
>> :-)
>>
>> Can the macro already be published on code.xwiki.org as is? Does it
>> require more than the macro page
>> to work? If not I can publish
>> http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro
>> on code.xwiki.org right away - although I'm not sure where the underlying JS
>> code is located right now.
>>
>>
> Right now the JS and Images are in
>
> xwiki/js/resources/socialcalc
>
> We could turn all this into JSExtensions but I'm not sure it is a good
> idea. It would make us fork the socialcalc codebase.
> At this point I've been able to only add some JS and add some CSS and it
> could even be in separate files.
>
> I was thinking I could have made a zip of that directory and have it as
> an attachment, but I don't think I can use the JSExtensions system with
> zips attached in the Wiki

There are ways to achieve this (this is what I did for the bespin editor
for example).

I used a hack writing the <script> dependency to dojo (which is in the
zip) in javascript using document.write().

Jerome.
>
> Ludovic
>
>

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs