Re: Django app for data management and visualization

Hi Chris,
there stuff looks pretty nice. I'll add that link to my research.

Marwan

On Fri, Apr 8, 2011 at 9:22 AM, Chris Matthews <chris@bbd.co.za> wrote:
> Hi Marwan,
>
> Another option that I'll investigate is Google Chart Tools / Image Charts (aka Chart API) see http://code.google.com/apis/chart/
> Regards
> Chris
>
> -----Original Message-----
> From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Marwan Al-Sabbagh
> Sent: 07 April 2011 09:59
> To: django-users@googlegroups.com
> Subject: Re: Django app for data management and visualization
>
> Hi Chris,
>  thanks so much for all the information and the links, Its really
> helpful. I really like xlwt it's easy, fast, and powerful. I'll most
> likely start with allowing the user to export a table of results to an
> excel sheet where they can do whatever additional calculations,
> formatting, or analysis they want.
>  I'm very interested in dealing with charts and graphs but I must say
> at this stage its more of a bonus then something our users are
> demanding. I'll keep you guys updated on my progress and would love to
> get all your feedback on the direction I'm taking and if it's
> something that any of you can use on your projects. looking forward to
> it.
>
> cheers,
> Marwan
>
> On Thu, Apr 7, 2011 at 9:50 AM, Chris Matthews <chris@bbd.co.za> wrote:
>> Hi Marwan,
>>
>> I am considering an "Excel Export" button wherever I have a table (or jQuery-UI grid).
>>
>> If you just want data sheets, before writing something, consider this:
>> xlwt 0.7.2 Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform, with Python 2.3 to 2.6
>> http://pypi.python.org/pypi/xlwt
>>
>> Example (using xwlt) to do export_selected_objects http://davidmburke.com/tag/django/
>>
>> Xwlt does not do graphs.
>>
>> There is probably a lot on graphs but I just saw this:
>> http://www.gnuplot.info/ and then also a Python interface http://gnuplot-py.sourceforge.net/
>>
>> Or
>> http://sourceforge.net/projects/django-dataplot/
>>
>>
>> For a interesting take on spreadsheets:
>> Use Django and jQuery to create a spreadsheet application http://www.ibm.com/developerworks/web/library/wa-django/?ca=drs-
>>
>> http://www.spreadsheetgear.com/ seemed cool but you net .Net and it will cost you (not sure if it will save you some money).
>>
>> Regards
>> Chris
>>
>> -----Original Message-----
>> From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Marwan Al-Sabbagh
>> Sent: 06 April 2011 16:59
>> To: django-users@googlegroups.com
>> Subject: Re: Django app for data management and visualization
>>
>> this sounds very interesting to me too. I'm working at a financial
>> institution and I'm facing a similar challenge of allowing the users
>> to generate ad hoc reports and export those reports to excel. I've
>> already implemented this requirement in PHP and I'm in the process of
>> migrating these reporting systems to django. I'm very interested to
>> see how you plan to do excel exports. I'll also be righting a library
>> within the next two months to do that, because I haven't found
>> anything that meets our requirements. If it's something you are
>> interested in please shoot me an email.
>>  as far as importing data from excel sheets into a database check out
>> www.python-excel.org and specifically their xlrd package that lets you
>> read excel files and traverse the cells. You could use this to extract
>> values and populate your database.
>>
>> Marwan
>>
>> On Tue, Apr 5, 2011 at 7:03 PM, Gianluca Riccardi
>> <riccardi.gianluca@gmail.com> wrote:
>>>
>>>
>>> On 5 Apr, 17:06, alessio c <viandant...@gmail.com> wrote:
>>>> Ciao,
>>>
>>> ciao Alessio,
>>>
>>>>
>>>> yes I do. I need more basic stuff then that and I need tables. Think of this
>>>> as tentative to reduce Excel use (which is killing me).
>>>>
>>>> I can use matplotlib or openflash if I want to go really fancy. However, now
>>>> I need to set up the framework. After that, I have a platform from which I
>>>> can run all my scripts.
>>>>
>>>> Let's say I have a database with invoice data from different subsidiaries. I
>>>> want to be able to: 1) create different views (subsidiary level, macro
>>>> level, invoice level, first 10 invoice, first 10 customers, etc.); 2) upload
>>>> data from different formats (because people are lazy and it is impossible to
>>>> impose a single format); 3) allow some users to upload data (to avoid them
>>>> to send me excel files by email, this is a huge feature...); 4) allow some
>>>> other users (managers) to access and download online reports (tables and
>>>> graphs).
>>>>
>>>> Theoretically, when I get this right I am hoping to start a project on git.
>>>> The main idea is to create a shared reporting tool.
>>>
>>> sounds like your going to have some fun ;) good luck, especially if
>>> you can get rid of dealing with spreadsheets and automate it I'm sure
>>> users will be happier(you at first;)
>>>
>>> if You start a public git repo i'd like to read your progresses
>>>
>>> regards,
>>> Gianluca Riccardi
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups "Django users" group.
>>> To post to this group, send email to django-users@googlegroups.com.
>>> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
>>> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>>>
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Django users" group.
>> To post to this group, send email to django-users@googlegroups.com.
>> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
>> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Django users" group.
>> To post to this group, send email to django-users@googlegroups.com.
>> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
>> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>
>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.