Unable to create/duplicate Storage Locations

[CyberTeckyLLC]

Hello,

As always, I really appreciate using Part-DB as it really helps manage my electronics. A bit of a learning curve, for sure, but worth the effort to learn and build!

That being said, as I was creating my 'Storage Location' in Part-DB, I wanted to find an efficient way of rapidly creating/numbering storage drawers. I keep my electronic components in small form-factor containers called a 'Box-All' from AideTek. Most Box-All products can hold between 40 to 144 drawers that are designed to fit most SMD/SMT electronic components. Here is the Box-All variant that I use:

In my case, I have more than [3] 96-COUNT Box-All containers that I would like Part-DB to manage (inventory-wise). The location where I am having this problem is under: Part-DB --> Edits --> Storage Locations - AND this is what I'm trying to accomplish:

While working on my labeling/numbering scheme, I noticed a mistake in how I initially named the Box-All container #1 (e.g., BA.01.001) wrong, and the following snapshot depicts my efforts to correct the naming scheme from 'Slot-01, Slot-02, etc to BA.01.001 (SLOT-01), BA.01.001 (SLOT-02), etc.

SEE "Storage Locations" column:

Just to clarify, naming each drawer location using BA.01.001 (SLOT-##) is the desired outcome that works well, however, I can't find a way for Part-DB to rapidly create ALL my drawer Storage Locations quickly instead of me having to create (type) each Box-All container/drawer manually.

Overall, maybe there could be a way where the user could manually create a complete container/drawer label scheme for a Box-ALL (e.g., BA.01.001) then Part-DB could offer duplicating the work for additional Box-All container/drawers - Example:

• BA.01.001

  • BA.01.001 (SLOT-01)
  • BA.01.001 (SLOT-02)
  • Etc...

• BA.02.002

  • BA.02.002 (SLOT-01)
  • BA.02.002 (SLOT-02)
  • Etc...

Note. Not to bring up old inventory software, but one thing Partkeepr offered for labeling scenarios like this is a way to rapidly create using numbering sequences, so if I created a naming scheme of 'BA.01.001 (SLOT-01)', Partkeepr would ask how many numbering sequences would be required. In my case, I would type [95] more (since the first was already created) and would generate the remaining list of labels.

Hope this explains things!

Server Side

• Part-DB Version: 1.14.2 (Docker 27.3.1 Build cel12230)
• PHP Version: PHP 8.3.12
• Database Server: SQLite 3.34.1
• System OS: Debian 11 KVM

[Verox-]

While it's not entirely within the software, couldn't you use something like Excel or a simple script to create the list of storage locations then use the Mass Creation tab (Storage Locations -> New Element -> Mass Creation) to do the actual creation of the locations?

[CyberTeckyLLC]

While it's not entirely within the software, couldn't you use something like Excel or a simple script to create the list of storage locations then use the Mass Creation tab (Storage Locations -> New Element -> Mass Creation) to do the actual creation of the locations?

I like the idea you are suggesting, thank you. However, I'm not sure how to take the exported file from Part-DB and make it into a readable csv, yml, json, etc. I've exported the files before, however, I just can't seem to get a grasp on organizing the data. SQLite is a bit new for me, I suppose.

Anyone have other ideas how I should go about this would be much appreciated. Thanks!

[jbtronics]

Basically, this is what the mass creation input is for:

Basically you just have to input the elements you want to create as a (nested) list.

Maybe this could be improved by allowing to generate things like ranges automatically, but its not so easy to make a generalized solution for this.