On Mon, Feb 16, 2009 at 3:53 PM, DaSa <daniel.sandb...@gmail.com> wrote:
> > > Thx for your tips! > > I tried to update my Python version but it did not work. > Updating Python failed? Or changing to 2.6 did not affect your problem? > > Today I have my data in an Excel document, and I have a script that > parse the excel document and creates sql-commands that I paste in the > SQL shell. But as you know I have the problem with swedish signs. Well, you haven't actually said what the problems are, you just said "the windows command prompt does not support swedish signs." But then later you said that you do use chcp to set the encoding in the command prompt and the symbols appear properly, but aren't handled properly when you use "python manage.py shell", specifically, which rather well matches my experience with that Python issue. Now you say "the SQL shell" and I'm not sure if you mean the sqlite program or manage.py shell, so I'm a bit confused. Perhaps if you gave some specific details it would help. What codepage do you use for chcp, what exact commands are you issuing in the (and which) shell, what is the result? If the problem isn't fixed by that Python issue than perhaps the problem is that your data is not encoded in the character set you think it is encoded in. > > > I shall try to use the admin interface instead, but today I can only > add one item at the time. Do you know any example how to add several > items at the same time? > If you've got a script that parses the Excel file I'm not sure why you have a pasting via the shell part involved at all -- why not just change the script to issue directly whatever commands you are pasting into the shell instead? Doing anything interactive, whether in the admin interface or manage.py shell, is much more cumbersome than just having a script do the bulk data importing. You also then bypass any issues specific to the Windows command prompt and its character set issues. But if the root of the problem is the source encoding for your data, then bypassing the shell isn't going to help, so again more information about what exactly is going wrong would help people help you. Karen --~--~---------~--~----~------------~-------~--~----~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---