Re: Patterns / Best practice for automated data refreshes

2010-09-26 Thread ALJ
Hi Shawn, Thanks for that. I'll have a look at using models then. Cheers ALJ On Sep 26, 7:32 pm, Shawn Milochik wrote: > If you're updating a database created by Django, I recommend that your import > script import your Django models and update them with the data. Otherwise you > run the ris

Re: Patterns / Best practice for automated data refreshes

2010-09-26 Thread Shawn Milochik
If you're updating a database created by Django, I recommend that your import script import your Django models and update them with the data. Otherwise you run the risk of running SQL that breaks your Django app (or worse, causes it to run with corrupted data and no errors). I'd do something wi

Patterns / Best practice for automated data refreshes

2010-09-26 Thread ALJ
We have an extranet web application (using sqlite) that is hosted outside our network. One of the tables it uses is an excel report from our main accounting system that contains a list of our customers. To begin with this was imported manually but now I want to set up an automated monthly refresh o