Django based reporting tool

We have a web based reporting system that we'd like to scrape. The system is built and hosted by another company, so we'd like to build a Django application that can do this.

So far I have built a quick proof of concept PHP script using the PHP cURL bindings to login and run these reports and return a print out of the results. So I have already uncovered some of the non standard things this web app does (like actually returning a response after returning a 301 header) and proven that we can automate pulling reports. I have also built some Django models for this project to get signoff from my stakeholders and also to communicate to the person doing the work what we want at the end. My proof of conecpt is just that. I did it to make sure that we could do what we needed to do.

So what you will need to do.

1. Use cURL for Python to do what I have done in PHP and build an object structure in Python to do what I have done structurally.

2. Take the response from the current web reporting system which is basically a HTML table and store the results in a MySQL database. I have been advised that BeautifulSoup is probably a good tool for this. See [url removed, login to view] The only change that I'd make to how I currently do things is to chunk the reporting time frame down to a month at a time. So for example if we run a report that spans 2 years we actually run 24 reports against the reporting server and log each piece of data to the database and then return the whole 24 month period to the user.

3. Once the report is run it needs to be emailed to the report owner email address with an excel attachment.

4. Make these reports able to be executed as Django Admin tasks

5. Make a django admin command to import all customers into the system from the reporting system. There are probably < 1000 customers.

Notes this application must run under:

Python 2.6

Django 1.3

Apache 2x running mod_wsgi

MySQL 5.1


Build using buildout (sample django app already does this)

I have included the sample [url removed, login to view] that I have built. It is pretty much complete. I'm happy to not use the generic relations if they prove difficult to implement.

Brief description of models.

reportingUserAccount: These are the user accounts that we use to connect to our reporting server.

These two tables are not complete but are just the fields that we pass up to the reporting server to get it to return data to us. I have a list of these fields I just have not got to making a DJango model for them yet. There are currently two types of reports that are run product and sales lists.





These tables specify the report jobs, where the data is sent to and which user we run the reports as. Reflecting on this it might be better to be modelled in one model.

customer: This model stores the name and customer id of the customers in the remote reporting system.

reportingRun: Every time a report is run there is an entry in this table.

These tables store the data returned from the remote reporting system. Because the data in the remote system changes over time we may store the same data across multiple runs. This is not going to be an issue.



Compétences : AJAX, Django, MySQL, Python

en voir plus : django reporting tool, python reporting tool, web based reporting python, mysql web based reporting tool, django based reporting tool, web reporting django mysql, python reporting system, work remote jobs, where do you get a python, where can i get python, what we have to do in data entry jobs, what does data entry do, what does a data entry person do, what are the types of data structure, what are the application of data structure, what are sales jobs, web relations, web based jobs, us based data entry jobs, up jobs login, under the table jobs, types of sales jobs, types of jobs, types of data structure, types of data entry software

Concernant l'employeur :
( 0 commentaires ) South Melbourne, Australia

Nº du projet : #1072254

12 freelance font une offre moyenne de $3581 pour ce travail


Dear Sir, Please see my personnel message. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 45 jours
(6 Commentaires)

let's start

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 45 jours
(12 Commentaires)

Check My PMB boss

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 45 jours
(8 Commentaires)

Ready to start work on this interesting project.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(11 Commentaires)

Hi, I just sent you more details over the pvt. message board. -Sid

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 60 jours
(4 Commentaires)

Hi, This is Azhagu Selvan from India. I have worked on a handful number of production ready django products. I also have hands-on experience on doing scraping with Python.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 45 jours
(0 Commentaires)

we have a team of 25 members with expertise in their profession. We have made a similar kind of projects. For further information please view your PMB. Ready to work with you Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 40 jours
(0 Commentaires)

Hi there, I have some experience in doing this kind of task. Do check my PM for full details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 25 jours
(0 Commentaires)

please check PMB. thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 21 jours
(0 Commentaires)

dear sir, we are a chinese team and so glad to know your project at here. we have 25 programmers and 14 web designers works at the same office, completed a lots of web site using Django.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 20 jours
(0 Commentaires)

I have a lot of Django/Python experience.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(0 Commentaires)

4+Year Exp. In Software and Web Development , Believe in quality output . My service offer you a Custom Web Development solution built using time tested technologies and add more value to the product by providing fan Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 26 jours
(0 Commentaires)