Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bulk Upload Anomalies when Database is Empty #548

Closed
joannekoch opened this issue Apr 19, 2022 · 3 comments
Closed

Bulk Upload Anomalies when Database is Empty #548

joannekoch opened this issue Apr 19, 2022 · 3 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@joannekoch
Copy link
Collaborator

Start out with no Parts, Assemblies, Inventory or Builds in the database.

Upload this sensor_bulk_load-AssetRecords.csv:
Capture

Creates a Part Template with no Revision Number (a required field). When you select Choose Action->Create New Revision, nothing happens. This may be related to unresolved issue #432.
Capture1

In addition, when you upload this sensor_vocab.csv file, the upload is successful and no error is reported, but nothing is created because there are no Parts with the specified Manufacturer & Model. Don't know if no error could be confusing to the user if they would be expecting to see a bulk upload file for a specific Part.

Capture2

Capture3

@joannekoch joannekoch added the bug Something isn't working label Apr 19, 2022
@joannekoch joannekoch added this to the v1.7.0 milestone Apr 19, 2022
@MarioCarloni
Copy link
Collaborator

MarioCarloni commented May 16, 2022

Hi @joannekoch , I think you're right about a warning. When Bulk Vocab Files are submitted without matching Parts, the data is still created but not displayed anywhere until matching Manufacturer/Models exist. Once matching fieldbvalues exist, the Vocab files would need to be reimported, which would automatically associate the Bulk Upload Event's Vocab Files with Parts.

@joannekoch
Copy link
Collaborator Author

This is not working:
There's a new error importing the sensor_bulk_load-AssetRecords.csv file shown above.
This import is supposed to create a Part and Inventory when it does not exist when the RDB_Part_Template field is supplied.

Capture

This is working:
A sensor_vocab.csv import error is reported if no Parts with the specified Manufacturer & Model exist.

Capture

@joannekoch
Copy link
Collaborator Author

This issue is fixed. Upload the sensor_bulk_load-AssetRecords.csv file above and the following Part and Inventory are created.

Capture3
Capture3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants