ISO DIN EN Standard - custom database

[TeeVar]

Hi everyone

My custom database for "SE storekeeper". This version does not include any of the items created by Robert.

1. All variables and dimensions have been taken directly from ISO, DIN or EN standard.
2. In some cases I created additional variables for some dimensions and calculations.
3. For each item there is a drawing with variables.
4. Not all models have been tested. Some bugs are possible.
5. All models have been created in Solid Edge 2019 and they have "Released" status.

Standards in database

1. ISO SCREWS

• ISO 4014 - Hexagon head bolts - normal pitch
• ISO 4017 - Hexagon head screws - normal pitch
• ISO 8676 - Hexagon head screws - thin pitch
• ISO 4026 - Hexagon socket set screws with flat point
• ISO 4027 - Hexagon socket set screws with cone point
• ISO 4028 - Hexagon socket set screws with cone point
• ISO 4762 - Hexagon socket head cap screws
• ISO 10642 - Hexagon socket countersunk head screws
• ISO 7380-1 - Hexagon socket button head screws
• ISO 7380-2 - Hexagon socket button head screws with collar
• ISO 2009 - Slotted countersunk flat head screws
• ISO 2010 - Slotted raised countersunk head screws
• ISO 7379 - Hexagon socket head shoulder screws
• ISO 1207 - Slotted cheese head screws
• ISO 8765 - Hexagon head bolts with metric fine pitch thread
• ISO 12474 - Hexagon socket head cap screws with metric fine pitch thread
• DIN 7984 - Hexagon socket head cap screws with low head with reduced loadability
• DIN 6912 - Hexagon socket head cap screws with reduced loadability
• DIN 316 - Wing screws
• DIN 580 - Lifting eye bolts

2. ISO NUTS

• ISO 4032 - Hexagon regular nuts
• ISO 4033 - Hexagon high nuts
• ISO 4035 - Hexagon thin nuts
• ISO 8673 - Hexagon regular nuts - fine pitch
• ISO 8674 - Hexagon high nuts - fine pitch
• ISO 8675 - Hexagon thin nuts - fine pitch
• ISO 7040 - Hexagon regular nuts with non-metallic insert
• ISO 10511 - Hexagon thin nuts with non-metallic insert
• DIN 315 - Wing nuts
• DIN 582 - Lifting eye nuts

3. ISO WASHERS

• ISO 7089 - Plain washers - Normal series
• ISO 7092 - Plain washers - Small series
• ISO 7093 - Plain washers - Large series
• ISO 7094 - Plain washers - Extra large series
• DIN 127 - Spring washer

4. ISO PINS

• ISO 1234 - Split pins
• ISO 2338 - Dowel pins
• ISO 8734 - Dowel pins
• ISO 8735 - Pins with internal thread
• ISO 8752 - Spring pins

5. EN STRUCTURAL

• EN 10056-1 - Structural steel equal leg angles
• EN 10210-2 - Hot finished structural hollow sections
• EN 10219-2 - Cold formed welded structural hollow sections
• EN 10220 - Seamless and welded steel tubes
• EN 10305-1 - Precise seamless cold drawn tubes
• EN 10305-2 - Precise welded cold drawn tubes
• EN 10305-3 - Precise welded cold sized tubes
• EN 10305-4 - Precise seamless cold drawn tubes for hydraulic and pneumatic power systems
• EN 10305-5 - Precise welded cold sized square and rectangular tubes
• EN 10305-6 - Precise welded cold drawn tubes for hydraulic and pneumatic power systems
• EN 10365 - Hot rolled steel channels, I and H sections

6. OTHER - Steel

• DIN 6885-1 - Parallel keys
• DIN 471 - Retaining rings for shafts
• DIN 472 - Retaining rings for bores
• ISO 2982-2 Rolling bearings - Locknuts
• ISO 2982-2 Rolling bearings - Lockwasher
• AN315 - Blind rivet nut knurled - flat head
• AN318 - Blind rivet nut knurled - countersunk head
• AN320 - Blind rivet nut knurled - countersunk reduced head

Change log

2026-08-14
update release
#16 (comment)

2026-05-16
update release
#16 (comment)

2026-01-06
update release

#16 (comment)

2025-10-24
update release

#16 (comment)

2025-09-28
update release
#16 (comment)

2025-09-14
update release
#16 (comment)

2025-08-17
Initial release

https://drive.google.com/file/d/1gJ6GALZaPmWaF98wjR2xatNDPEMi_wrK/view?usp=drive_link

[rmcanany]

@TeeVar

That's awesome work. Thank you! I added your name to the project Contributors section of the Readme.

I'll figure out how to add it into the release pipeline. That will make it readily available for the upcoming version, and thereafter.

In the meantime, you might get more exposure if you repeat your announcement on the SE Forum. Most of the traffic for this project and Housekeeper come from there.

[TeeVar]

This initial release is mostly for you to think of a way how to add it to the main release. As part of the main release or as a separate download. I Don't think end user should edit excel files. Generally adding new items to the database or combining more databases is pain in the ass.

There are still some items that I want to add. Maybe next release I will post on siemens forum. For now I will post only here.

[rmcanany]

That makes sense. I've got some vague ideas on how the integration might be done, but need to think it through.

Totally agree about using Excel. It sounds good -- until you need to add/change something. Also the syntax around property mapping, formula creation, etc. is cumbersome.

[rmcanany]

@TeeVar

In terms of integration, I'm wondering about simply renaming the original Data and Templates to DataSE2024 and TemplatesSE2024 and adding yours as DataSE2019 and TemplatesSE2019.

I could copy both to Preferences and let the user decide. They could even use one or the other as needed. I would have to consider eventual name conflicts in the Library, but I don't think there are any between our two versions at present.

Thoughts?

[TeeVar]

@rmcanany

There won't be any file conflicts or duplicates.
My file name formula always include ISO/DIN number, example - ISO_4762_%{Name}x%{L}.par. Not to mention that I already have changed my DB to subfolders. Posted DB is very outdated so before you release 2025.4 let my know i will post my updated DB. The only concern I have right now is fasteners stack as I'm not able to test it with 2024.4 preview 1 (still in development). Not enough information except what is in the help.

[rmcanany]

Yes, please post your updated data and templates.

We have some work to do on fastener stacks. To get a sense how it is implemented, here's the Documentation.

Here's how the pre-configured files are named. (They are stored in Templates\FastenerStackTemplates)

Legend: F = Fastener, FW = Flat Washer, LW = Lock Washer, N = Nut.

To create F.par, I copied and renamed hhcs_0.250-20_1.000.par. I created the other components in the same fashion. It doesn't really matter exactly what parts you use, they will be replaced with the correct ones. One thing that is pretty important is that any fastener type can be replaced with any other without breaking assembly relationships.

Part of the process to find the corresponding components involves moving up and down the Xml tree, searching for component names. For example, to find the flat washer for a given fastener, the program moves up up three nodes, then searches that collection for a node named "Washer_Flat". It then opens that and searches for a matching NominalDiameter. I'll have to create a mapping between our data structures. That shouldn't be too hard.

The program uses these variables.

• NominalDiameter (all components)
• Length (fastener)
• ThreadDescription (fastener, nut)
• Thickness (flat washer, lock washer, nut)

While I can deal with different data structures, I'd rather not try to accommodate different variable names. They're literally everywhere in the code. I don't think it would be impossible to reconcile our two naming conventions. I'm mostly thinking what happens with a growing number of contributions from others.

If that's a big pain for you, let's talk about it. I really appreciate your contributions and continued interest in the project. I want to keep that going.

[TeeVar]

First I need working version to see what I can do with it.

2025-09-14 update release
This release base on 2025.4 Beta Preview 1

• fixed values, parameters and variable for some items
• excel database reorganization
• added to database

ISO 2982-2 Rolling bearings - Locknuts
ISO 2982-2 Rolling bearings - Lockwasher
ISO 2009 - Slotted countersunk flat head screws
ISO 2010 - Slotted raised countersunk head screws
ISO 7379 - Hexagon socket head shoulder screws
ISO 1207 - Slotted cheese head screws
ISO 8765 - Hexagon head bolts with metric fine pitch thread
ISO 12474 - Hexagon socket head cap screws with metric fine pitch thread
ISO 7094 - Plain washers - Extra large series

DIN 7984 - Hexagon socket head cap screws with low head with reduced loadability
DIN 6912 - Hexagon socket head cap screws with reduced loadability
DIN 315 - Wing nuts
DIN 316 - Wing screws

AN315 - Blind rivet nut knurled - flat head
AN318 - Blind rivet nut knurled - countersunk head
AN320 - Blind rivet nut knurled - countersunk reduced head

known issues

• ISO 2009: 40mm long screws are generated incorrectly
• ISO 2010: 40mm long screws are generated incorrectly
• ISO 2982-2 Locknuts: some threads are generated incorrectly, no thread texture

https://drive.google.com/file/d/1uzYTruREdZ2awtm_qbNW85p9zXqQo3Kx/view?usp=drive_link

[rmcanany]

Wow. That's awesome!

I'll adapt my fastener stack code to be compatible with your data structure. I'll let you know when it's ready to test.

[rmcanany]

I was able to create a fastener stack from your dataset today. I seriously doubt it's bug free. Let me know what you run across.

There are several things I should mention. First off, I renamed DefaultData to DefaultDataSE2024 and added DefaultDataSE2019. I did the same for templates.

As I mentioned, some variables have to be renamed. There are four of them; they're listed in my previous post. As you know, the variables occur in many places -- the templates, storekeeper.xls (like in the filename and description formulas), companion spreadsheets, and possibly more I forgot.

NominalDiameter is required in the spreadsheets and templates, even if it's not used (like with flat washers and lock washers). I need it so I can match the component size to the fastener.

Speaking of lock washers, in my testing I used ISO 2982-2. Those do not appear to be for fasteners. I don't know if ISO-Land uses lock washers. If not, there are several stack configurations that don't apply.

As I mentioned, there are templates for the various top and bottom stack assemblies. I would give you mine, but they're in SE2024 which won't help. Here's a couple examples of what they look like.

In the fastener stack dialog, any component should show a file name. If instead it says Flat washer (or whatever) it means the file was not found. In my testing, that usually meant I forgot to update some variable name in one of the spreadsheets.

Missing variables or other mismatches can lead to seemingly unrelated errors. I had one where it was complaining about the Filelogger. In that case, I had forgotten to update the filename formula to use Length instead of L. There were quite a few weird errors like that.

Anyway, sorry to babble on like that. Here's the link.
https://drive.google.com/file/d/1LWd7miCBFop9DM2xkISt_uFrRcF8y3lt/view?usp=sharing

[TeeVar]

ISO 2982-1/2 is a very bad choice for testing. These items are used to lock bearing, wheels ect. on the shaft. Typical lock washer is DIN 6798 A for example, Nord-lock, Schnorr, just didn't add them do DB.

If you are talking about spring washer, ISO standard doesn't have them and DIN standard is withdrawn but you can still buy them.

Don't know how much more work do you have with v2025.4 but you can release it with annotation that fastener stack won't work with DB2019 for now.

And don't worry about your babble, each info from you is precious.

[rmcanany]

Oh, got it.

I'm working on error catching/reporting right now. Depending on how much time I can dedicate, it might be a week or two before a new release could be ready. I'll check in with you then.

[rmcanany]

@TeeVar

Still working on integration of your data set with fastener stacks. I took the liberty of adding my variables to a couple of your files. It worked one time, so far. I'm still finding bugs, so haven't posted anything to Google Drive yet.

.

[TeeVar]

I have spent some time with my DB I can say that adjusting it to work with fastener stack should not be a problem. I will have to add 3rd row in excel to keep my old variables as drawing references and change model variable formulas.

ThreadDescription (fastener, nut) - was already there, no change needed
Length (fastener) --> L
Thickness (flat washer, lock washer, nut) --> h, m and probably a few more

NominalDiameter (all components) - I'm not sure about this one. Is it variable that change model or is it as a reference? For example washer model needs only 3 variables, inside/outside diameter and thickness. But ND is as a 4th variable.

[rmcanany]

Good deal. Yes, you need NominalDiameter is the spreadsheets and templates, even if it isn't used in the model. That's how I find the components that match the fastener.

[rmcanany]

I just uploaded a new preview to Google Drive. It has much improved error checking and reporting for fastener stacks.

One thing it doesn't have is the correct location for your lock washers. The first time you run the program, it will create a file Preferences\LockWasherSE2019.json. You can edit that in Notepad and enter the correct information. Next time I get your dataset, I'll update my code.

By the way, I noticed a few entries in your Storekeeper.xls still have Prompt as the filename formula. With the recent change to interactive folder selection, that's obsolete.

Anyway, here's the link.
https://drive.google.com/file/d/1ReTWlqVediZWMCp1_chYay0c-ejPIvyy/view?usp=sharing

[rmcanany]

Yeah, seeing the same on V2025.

[TeeVar]

2026-08-14 update release

• updated to Storekeeper 2026.1 preview beta 5
• fixed values, parameters and variable for some items
• override required for all templates
• added missing material in material table (override required)
• added polish version of the data base,
• from now on only StorekeeperSchema.xml will be maintained as main data base

Polish data base

• to use this data base select DefaultDataSE2019_PL as the source

• only descriptions have been translated, files are generated using english name

• Size and Length have not been translated as they are hard coded

https://drive.google.com/file/d/1gJ6GALZaPmWaF98wjR2xatNDPEMi_wrK/view?usp=drive_link

[rmcanany]

Good deal. I should have a chance to get everything integrated starting tomorrow.

Quick question -- what does "override required" mean exactly? Is that something users have to worry about, or are you just noting that I need to replace the old with the new?

Also, you previously mentioned adding split pins. Didn't you also add some structural items, too? I want to make sure I get everything captured in the release notes.

[TeeVar]

Since your release is official, all the information are mostly for you. You can assume that you have to replace DefaultDataSE2019, DefaultDataSE2019_PL and DefaultTemplatesSE2019 every time to have everything up to date. But the end user will have to replace everything as well.

With this release I didn't add any new items. Last time I added only split pins.

I'm tracking changes in release_notes, if i find anything wrong I will let you know.

[rmcanany]

Sorry for the delay. I got interrupted. I'm back now.

Got your new data. Looks good. I especially like the Polish version. I'm going to add a screenshot of that to the release notes.

Once I get everything integrated, I think I'll make one final preview. That will give us both a chance to do a quick check before release. How's that sound?

[rmcanany]

I found one issue with fastener stacks using the Polish dataset. I have some hard-coded XML node names from your English version. I may be able to fix it. Could you translate the following for me? (I just need the text following Solid_Edge_Storekeeper\, not the rest.)

Case "FlatWasherSE2019"
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_WASHERS\ISO_7089_-_Plain_washers_-_Normal_series")
Case "LockWasherSE2019"
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_WASHERS\DIN_127_-_Spring_washers")
Case "NutSE2019"
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_NUTS\Hexagonal\ISO_4032_-_Hexagon_regular_nuts")
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_NUTS\Hexagonal\ISO_8673_-_Hexagon_regular_nuts_-_fine_pitch")

[rmcanany]

Never mind. I keyed off of the part numbers and found what I needed. Please double-check if you don't mind.

Case "FlatWasherSE2019"
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_WASHERS\ISO_7089_-_Plain_washers_-_Normal_series")
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_-_PODKŁADKI\ISO_7089_-_Podkładki_okrągłe_-_szereg_normalny")
Case "LockWasherSE2019"
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_WASHERS\DIN_127_-_Spring_washers")
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_-_PODKŁADKI\DIN_127_-_Podkładki_sprężyste")
Case "NutSE2019"
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_NUTS\Hexagonal\ISO_4032_-_Hexagon_regular_nuts")
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_-_NAKRĘTKI\Sześciokątne\ISO_4032_-_Nakrętki_sześciokątne")
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_NUTS\Hexagonal\ISO_8673_-_Hexagon_regular_nuts_-_fine_pitch")
    SearchPathList.Add("Solid_Edge_Storekeeper\ISO_DIN_-_NAKRĘTKI\Sześciokątne\ISO_8673_-_Nakrętki_sześciokątne_-_gwint_drobnozwojny")

[rmcanany]

Uploaded a new preview just now. I did a quick test and it worked for me. Let me know if you run into anything.

The main changes were to integrate your new dataset, and add return-to-accept in Property Search. Also updated the release notes with that info.

Here's the link:
https://drive.google.com/file/d/1qxvSZsDHi1bqXLV8hnudWL16IJGXJ3F6/view?usp=sharing

[rmcanany]

@TeeVar

No rush at all, but I was waiting for your "OK" before finalizing the release. I can see now that I didn't make that clear in my last message.

[TeeVar]

Sorry for a delay. I was on holiday for the last 3 weeks. I did some test and should be ok. I didn't test fastener stack last time, my fault. I got some strange error in PB5 but it should be fixed now, at least I don't get it in PB6. I will do more test tomorrow at work.

[rmcanany]

Sounds good. Hope you had fun on vacation!

[TeeVar]

You can prepare stable release. No issues so far. I would add info in the release note about replacing all templates as this is required.

[rmcanany]

Good point about the templates. I'll add that to the release notes and get it going.

I missed your earlier comment about fastener stacks. I need to check the readme; I thought for some reason those didn't work in SE2019 or SE2020. Sounds like they do, is that right? And, yeah I fixed how stack components are searched in PB6. The previous method was probably responsible for that PB5 error you got.

[TeeVar]

Fastener stack had some issues at the beginning. The problem is with auto patterning due to API. We discussed it here #12

[rmcanany]

Oh, got it. I was mixed up.

I'm working on the release now, and hope to get it out today.