Re: [Arches] Re: Error Exporting Business Data from Arches 4.4.2

Another approach would be to use the django ORM in the python shell. >From your project run python manage.py shell Now you can paste this code in from arches.app.models.tile import Tile tiles = Tile.objects.all() for tile in tiles: for value in tile.data.values(): if isinstance(value,

[Arches] Re: Error Exporting Business Data from Arches 4.4.2

I realized that I inadvertently took this discussion offline to just Martha and I. Here's some missing thread: Martha, (I think) you can issue this sql statement against the Postgres database behind arches to identify the specific resource instance and “card” that contains a given offending

[Arches] Re: Error Exporting Business Data from Arches 4.4.2

Do anyone have a recommendation for the best way to go through the database of >110,000 records to find all instances of the '|' in any field it might occur? I am told this was the delimiter used in .arches files, so there could be other instances sprinkled throughout the database. Needle in a

[Arches] Re: Error Exporting Business Data from Arches 4.4.2

Thank you, Alexi, I'll just have to hope that's the only "special" character in the data. Martha On Friday, September 27, 2019 at 5:13:59 PM UTC-7, 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

Re: [Arches] Error Exporting Business Data from Arches 4.4.2

Hi Martha, It looks like somewhere you have a "broken bar" character in your data ( https://www.fileformat.info/info/unicode/char/00a6/index.htm) If you can find it and remove it then that might solve the problem. Hope that points you