Write a management command that downloads the CSV from email and loads it in your database. Set up a cron job that calls the management command. This is how I would do it.
There may be some unnecessary complication with that approach, like figuring out which emails contain the CSVs of interest etc. Accessing the database those CSVs come from is another option which just became much easier to do with Django 1.2 with multiple database supportl Keep in mind that if that database is on a remote server there would be a need to punch holes through firewalls and opening connections and executing queries against that database may take significant amount of time. On Wed, Feb 24, 2010 at 1:05 AM, Victor Hooi <victorh...@gmail.com> wrote: > heya, > > I have a Django app that will need to grab CSV data being sent to an > email address into it's own database. > > I'm assuming if I can get IMAP access to the mailbox, I can just > script all of that part in Python. However, what's the best way of > scheduling the process, so that it'll regularly check the mailbox? > Just make it a cron job, or is there a more integrated way of doing it > inside of Django? > > Actually, is this the best way of doing it, importing the data this > way? Or if say, I could get access to the underyling database behind > those CSV files, would I be better off trying the approach here > (http://docs.djangoproject.com/en/dev/howto/legacy-databases/). Or > should I just import the data into a clean Django-originated database > and leave it at that? > > Cheers, > Victor > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@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-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
