Hi Martha - I'm not sure this will is what you are after, but if you are having problems importiing/exporting non-ascii characters to/from Arches, this may help. We uploaded a cyrillic data set by CSV successfully using this.
https://github.com/archesproject/arches/issues/2831 For those who have this issue on Apache2, here is what solved my problem: ( https://code.djangoproject.com/wiki/django_apache_and_mod_wsgi#AdditionalTweaking ) If you're taking advantage of the great Internationalization features of Django you may come across a curious problem. Namely, uploading of non-ascii filenames with the Django storage system with the default apache settings on most systems will trigger UnicodeEncodeError exceptions when calling functions like os.path(). To avoid these issues, ensure that the following lines are included in your apache envvars file (typically found in /etc/apache2/envvars). export LANG='en_US.UTF-8' export LC_ALL='en_US.UTF-8' This error likely wont rear its head during development on the test server as, when run from the command line, the ./manage.py script inherits the users language and locale settings.' Not sure this is what you want, but I thought it may help. Bryan On Saturday, 28 September 2019 01:13:59 UTC+1, Martha S wrote: > > I am trying to export all the data for a particular resource model to CSV > for review and modification and ran into an error during the process -- > UnicodeEncodeError: > 'ascii' codec can't encode character u'\xa6' in position 51: ordinal not in > range(128) > > *My command* > python manage.py packages -o export_business_data -d > '/hpladata/Projects/Downloads/Historic District Mapping Files' -f 'csv' > -c '/hpladata/Projects/Downloads/Historic District Mapping Files/Historic > District.mapping' > > *Here's the full error dump* > operation: export_business_data > Traceback (most recent call last): > File "manage.py", line 29, in <module> > execute_from_command_line(sys.argv) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", > line 364, in execute_from_command_line > utility.execute() > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", > line 356, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", > line 283, in run_from_argv > self.execute(*args, **cmd_options) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", > line 330, in execute > output = self.handle(*args, **options) > File "/Projects/prod/arches/arches/management/commands/packages.py", > line 190, in handle > self.export_business_data(options['dest_dir'], options['format'], > options['config_file'], options['graphs'], options['single_file']) > File "/Projects/prod/arches/arches/management/commands/packages.py", > line 770, in export_business_data > data = resource_exporter.export(graph_id=graph, > resourceinstanceids=None) > File > "/Projects/prod/arches/arches/app/utils/data_management/resources/exporter.py", > > line 37, in export > resources = self.writer.write_resources(graph_id=graph_id, > resourceinstanceids=resourceinstanceids) > File > "/Projects/prod/arches/arches/app/utils/data_management/resources/formats/csvfile.py", > > line 194, in write_resources > csvs_for_export = csvs_for_export + self.write_resource_relations( > file_name=self.file_name) > File > "/Projects/prod/arches/arches/app/utils/data_management/resources/formats/csvfile.py", > > line 215, in write_resource_relations > csvwriter.writerow({k:str(v) for k,v in relation.items()}) > File > "/Projects/prod/arches/arches/app/utils/data_management/resources/formats/csvfile.py", > > line 215, in <dictcomp> > csvwriter.writerow({k:str(v) for k,v in relation.items()}) > UnicodeEncodeError: 'ascii' codec can't encode character u'\xa6' in > position 51: ordinal not in range(128) > > Any suggestions? > > Thanks, > Martha > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/5e35127d-b1a0-4da6-a109-be901a36ae1c%40googlegroups.com.
