Importing stock locations error "can't set attribute" #4592

Benjamin0001 · 2023-04-07T16:42:23Z

Benjamin0001
Apr 7, 2023

I tried using the admin import button for stock locations but I keep getting this error

Line number: 1 - can't set attribute
, Aisle 1, , 1, Main Warehouse, Main Warehouse/Aisle 1, 0, 0

Traceback (most recent call last):
File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
self.import_obj(instance, row, dry_run)
File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
self.import_field(field, obj, data)
File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
field.save(obj, data, is_m2m)
File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 113, in save
setattr(obj, attrs[-1], cleaned)
AttributeError: can't set attribute

I made sure to leave location ID blank since they are new locations.

I even once tried exporting and then re-importing the same CSV just to see what the errors were and I got the same error.

Here is a sample of what I am trying to import:

Location ID,Location Name,Description,Parent ID,Parent Name,Location Path,Stock Items,structural
,Aisle 1,,1,Main Warehouse,Main Warehouse/Aisle 1,0,0
,1A1,,2,Aisle 1,Main Warehouse/Aisle 1/1A1,0,0
,1A2,,2,Aisle 1,Main Warehouse/Aisle 1/1A2,0,0

SchrodingersGat · 2023-04-08T14:31:35Z

SchrodingersGat
Apr 8, 2023
Maintainer

@Benjamin0001 can you provide a full error log and version information?

4 replies

Benjamin0001 Apr 10, 2023
Author

Version 0.10.1
If by error log you mean the rest of the errors that appeared on the import page, here is an abridged version unless you really want all 870 instances of the same 2 errors.

Errors

    
Line number: 1 - can't set attribute
    , Aisle 1, , 1, Main Warehouse, Main Warehouse/Aisle 1, 0, 0

    Traceback (most recent call last):
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
    self.import_obj(instance, row, dry_run)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
    self.import_field(field, obj, data)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
    field.save(obj, data, is_m2m)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 113, in save
    setattr(obj, attrs[-1], cleaned)
    AttributeError: can't set attribute
    
Line number: 2 - StockLocation matching query does not exist.
    , 1A1, , 2, Aisle 1, Main Warehouse/Aisle 1/1A1, 0, 0

    Traceback (most recent call last):
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
    self.import_obj(instance, row, dry_run)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
    self.import_field(field, obj, data)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
    field.save(obj, data, is_m2m)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 110, in save
    cleaned = self.clean(data)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 66, in clean
    value = self.widget.clean(value, row=data)
    File "/root/.local/lib/python3.9/site-packages/import_export/widgets.py", line 396, in clean
    return self.get_queryset(value, row, *args, **kwargs).get(**{self.field: val})
    File "/root/.local/lib/python3.9/site-packages/django/db/models/query.py", line 435, in get
    raise self.model.DoesNotExist(
    stock.models.StockLocation.DoesNotExist: StockLocation matching query does not exist.
    
Line number: 3 - StockLocation matching query does not exist.
    , 1A2, , 2, Aisle 1, Main Warehouse/Aisle 1/1A2, 0, 0

    Traceback (most recent call last):
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
    self.import_obj(instance, row, dry_run)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
    self.import_field(field, obj, data)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
    field.save(obj, data, is_m2m)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 110, in save
    cleaned = self.clean(data)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 66, in clean
    value = self.widget.clean(value, row=data)
    File "/root/.local/lib/python3.9/site-packages/import_export/widgets.py", line 396, in clean
    return self.get_queryset(value, row, *args, **kwargs).get(**{self.field: val})
    File "/root/.local/lib/python3.9/site-packages/django/db/models/query.py", line 435, in get
    raise self.model.DoesNotExist(
    stock.models.StockLocation.DoesNotExist: StockLocation matching query does not exist.
    
Line number: 4 - StockLocation matching query does not exist.
    , 1A3, , 2, Aisle 1, Main Warehouse/Aisle 1/1A3, 0, 0

...

    Traceback (most recent call last):
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
    self.import_obj(instance, row, dry_run)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
    self.import_field(field, obj, data)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
    field.save(obj, data, is_m2m)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 110, in save
    cleaned = self.clean(data)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 66, in clean
    value = self.widget.clean(value, row=data)
    File "/root/.local/lib/python3.9/site-packages/import_export/widgets.py", line 396, in clean
    return self.get_queryset(value, row, *args, **kwargs).get(**{self.field: val})
    File "/root/.local/lib/python3.9/site-packages/django/db/models/query.py", line 435, in get
    raise self.model.DoesNotExist(
    stock.models.StockLocation.DoesNotExist: StockLocation matching query does not exist.
    
Line number: 79 - StockLocation matching query does not exist.
    , 1Z3, , 2, Aisle 1, Main Warehouse/Aisle 1/1Z3, 0, 0

    Traceback (most recent call last):
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
    self.import_obj(instance, row, dry_run)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
    self.import_field(field, obj, data)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
    field.save(obj, data, is_m2m)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 110, in save
    cleaned = self.clean(data)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 66, in clean
    value = self.widget.clean(value, row=data)
    File "/root/.local/lib/python3.9/site-packages/import_export/widgets.py", line 396, in clean
    return self.get_queryset(value, row, *args, **kwargs).get(**{self.field: val})
    File "/root/.local/lib/python3.9/site-packages/django/db/models/query.py", line 435, in get
    raise self.model.DoesNotExist(
    stock.models.StockLocation.DoesNotExist: StockLocation matching query does not exist.
    
Line number: 80 - can't set attribute
    , Aisle 2, , 1, Main Warehouse, Main Warehouse/Aisle 2, 0, 0

    Traceback (most recent call last):
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 658, in import_row
    self.import_obj(instance, row, dry_run)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 512, in import_obj
    self.import_field(field, obj, data)
    File "/root/.local/lib/python3.9/site-packages/import_export/resources.py", line 495, in import_field
    field.save(obj, data, is_m2m)
    File "/root/.local/lib/python3.9/site-packages/import_export/fields.py", line 113, in save
    setattr(obj, attrs[-1], cleaned)
    AttributeError: can't set attribute

Benjamin0001 Apr 10, 2023
Author

Should I try removing the spaces? Do spaces maybe not play well with a path name? Do I need to use an escape character for spaces when importing as CSV? Should I try importing as XLSX instead?

wolflu05 Apr 10, 2023
Collaborator

Version 0.10.1

By Version Information, I guess @SchrodingersGat meant the full one, which you can copy via the inventree menu.

Benjamin0001 Apr 11, 2023
Author

I hope this is it.

Version Information:

InvenTree-Version: 0.10.1
Django Version: 3.2.16
Commit Hash: c1f15ef
Commit Date: 2023-02-25
Database: postgresql
Debug-Mode: False
Deployed using Docker: True
Active plugins: [{'name': 'InvenTreeBarcode', 'slug': 'inventreebarcode', 'version': '2.0.0'}, {'name': 'InvenTreeCoreNotificationsPlugin', 'slug': 'inventreecorenotificationsplugin', 'version': '1.0.0'}]

eeintech · 2023-04-11T13:42:56Z

eeintech
Apr 11, 2023
Collaborator

@SchrodingersGat @matmair I thin the admin stock location import is broken on master, those are the steps to reproduce:

Go to Admin page > Stock Locations > Export (to CSV)
Edit CSV to:

Location ID,Location Name,Description,Parent ID,Parent Name,Location Path,Stock Items,structural,external
1,Main Warehouse,this is the main warehouse,,,,,,

Import, the following error pops-up:

There is no information what is item_count related to, editing the file with:

1,Main Warehouse,This is the main warehouse,,,Main Warehouse,0,0,0

still gives the same error.

Note that my test database does not have any existing stock locations.

0 replies

SchrodingersGat · 2023-04-11T14:08:55Z

SchrodingersGat
Apr 11, 2023
Maintainer

Fix incoming in #4601 - @Benjamin0001 please confirm that it fixes the issue once merged in

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Importing stock locations error "can't set attribute" #4592

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 3 comments 4 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

Select a reply

Importing stock locations error "can't set attribute" #4592

Benjamin0001 Apr 7, 2023

Replies: 3 comments · 4 replies

SchrodingersGat Apr 8, 2023 Maintainer

Benjamin0001 Apr 10, 2023 Author

Benjamin0001 Apr 10, 2023 Author

wolflu05 Apr 10, 2023 Collaborator

Benjamin0001 Apr 11, 2023 Author

Version Information:

eeintech Apr 11, 2023 Collaborator

SchrodingersGat Apr 11, 2023 Maintainer

Benjamin0001
Apr 7, 2023

Replies: 3 comments 4 replies

SchrodingersGat
Apr 8, 2023
Maintainer

Benjamin0001 Apr 10, 2023
Author

Benjamin0001 Apr 10, 2023
Author

wolflu05 Apr 10, 2023
Collaborator

Benjamin0001 Apr 11, 2023
Author

eeintech
Apr 11, 2023
Collaborator

SchrodingersGat
Apr 11, 2023
Maintainer