Added translations for conrad settings

* Fix: Use correct field name for LCSC supplier part numbers in BOM import

The field mapping system uses 'LCSC SPN' as the target field name for LCSC
supplier part numbers (following the pattern SupplierName + ' SPN'), but the
code in parseKiCADSchematic() was incorrectly checking for 'LCSC'.

This caused LCSC supplier part numbers to be silently ignored and not included
in the BOM entry comments during schematic import.

Changed isset($mapped_entry['LCSC']) to isset($mapped_entry['LCSC SPN']) to
match the actual field name produced by the field mapping system.

* regression test: check for LCSC SPN in comment

* Support dynamic supplier SPNs in BOM import comments

Replace hardcoded LCSC SPN handling with dynamic supplier lookup to support all configured suppliers in BOM import. This allows any supplier defined in
Part-DB to have their SPN fields recognized and included in the BOM entry
comments during BOM import.

* Optimize BOM import by only calculating supplier SPN keys once

.docker/frankenphp/docker-entrypoint.sh

@@ -26,6 +26,28 @@ if [ "$1" = 'frankenphp' ] || [ "$1" = 'php' ] || [ "$1" = 'bin/console' ]; then
 		composer install --prefer-dist --no-progress --no-interaction
 	fi
 
+	# Install additional composer packages if COMPOSER_EXTRA_PACKAGES is set
+	if [ -n "$COMPOSER_EXTRA_PACKAGES" ]; then
+		echo "Installing additional composer packages: $COMPOSER_EXTRA_PACKAGES"
+		# Note: COMPOSER_EXTRA_PACKAGES is intentionally not quoted to allow word splitting
+		# This enables passing multiple package names separated by spaces
+		# shellcheck disable=SC2086
+		composer require $COMPOSER_EXTRA_PACKAGES --no-install --no-interaction --no-progress
+		if [ $? -eq 0 ]; then
+			echo "Running composer install to install packages without dev dependencies..."
+			composer install --no-dev --no-interaction --no-progress --optimize-autoloader
+			if [ $? -eq 0 ]; then
+				echo "Successfully installed additional composer packages"
+			else
+				echo "Failed to install composer dependencies"
+				exit 1
+			fi
+		else
+			echo "Failed to add additional composer packages to composer.json"
+			exit 1
+		fi
+	fi
+
 	if grep -q ^DATABASE_URL= .env; then
 		echo "Waiting for database to be ready..."
 		ATTEMPTS_LEFT_TO_REACH_DATABASE=60

.docker/partdb-entrypoint.sh

@@ -39,6 +39,28 @@ if [ -d /var/www/html/var/db ]; then
     fi
 fi
 
+# Install additional composer packages if COMPOSER_EXTRA_PACKAGES is set
+if [ -n "$COMPOSER_EXTRA_PACKAGES" ]; then
+    echo "Installing additional composer packages: $COMPOSER_EXTRA_PACKAGES"
+    # Note: COMPOSER_EXTRA_PACKAGES is intentionally not quoted to allow word splitting
+    # This enables passing multiple package names separated by spaces
+    # shellcheck disable=SC2086
+    sudo -E -u www-data composer require $COMPOSER_EXTRA_PACKAGES --no-install --no-interaction --no-progress
+    if [ $? -eq 0 ]; then
+        echo "Running composer install to install packages without dev dependencies..."
+        sudo -E -u www-data composer install --no-dev --no-interaction --no-progress --optimize-autoloader
+        if [ $? -eq 0 ]; then
+            echo "Successfully installed additional composer packages"
+        else
+            echo "Failed to install composer dependencies"
+            exit 1
+        fi
+    else
+        echo "Failed to add additional composer packages to composer.json"
+        exit 1
+    fi
+fi
+
 # Start PHP-FPM (the PHP_VERSION is replaced by the configured version in the Dockerfile)
 php-fpmPHP_VERSION -F &
 

.github/workflows/assets_artifact_build.yml

@@ -37,7 +37,7 @@ jobs:
         run: |
           echo "::set-output name=dir::$(composer config cache-files-dir)"
 
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         with:
           path: ${{ steps.composer-cache.outputs.dir }}
           key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}
@@ -51,7 +51,7 @@ jobs:
         id: yarn-cache-dir-path
         run: echo "::set-output name=dir::$(yarn cache dir)"
 
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         id: yarn-cache # use this to check for `cache-hit` (`steps.yarn-cache.outputs.cache-hit != 'true'`)
         with:
           path: ${{ steps.yarn-cache-dir-path.outputs.dir }}
@@ -80,13 +80,13 @@ jobs:
         run: zip -r /tmp/partdb_assets.zip public/build/ vendor/
 
       - name: Upload assets artifact
-        uses: actions/upload-artifact@v5
+        uses: actions/upload-artifact@v6
         with:
           name: Only dependencies and built assets
           path: /tmp/partdb_assets.zip
 
       - name: Upload full artifact
-        uses: actions/upload-artifact@v5
+        uses: actions/upload-artifact@v6
         with:
           name: Full Part-DB including dependencies and built assets
           path: /tmp/partdb_with_assets.zip

.github/workflows/static_analysis.yml

@@ -34,7 +34,7 @@ jobs:
       run: |
         echo "::set-output name=dir::$(composer config cache-files-dir)"
 
-    - uses: actions/cache@v4
+    - uses: actions/cache@v5
       with:
         path: ${{ steps.composer-cache.outputs.dir }}
         key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}

.github/workflows/tests.yml

@@ -81,7 +81,7 @@ jobs:
         id: composer-cache
         run: |
           echo "::set-output name=dir::$(composer config cache-files-dir)"
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         with:
           path: ${{ steps.composer-cache.outputs.dir }}
           key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}
@@ -92,7 +92,7 @@ jobs:
         id: yarn-cache-dir-path
         run: echo "::set-output name=dir::$(yarn cache dir)"
 
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         id: yarn-cache # use this to check for `cache-hit` (`steps.yarn-cache.outputs.cache-hit != 'true'`)
         with:
           path: ${{ steps.yarn-cache-dir-path.outputs.dir }}

Dockerfile

@@ -46,13 +46,11 @@ RUN apt-get update && apt-get -y install \
     && rm -rvf /var/www/html/*
 
 # Install node and yarn
-RUN curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add - && \
-    echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list && \
-    curl -sL https://deb.nodesource.com/setup_22.x | bash - && \
+RUN curl -sL https://deb.nodesource.com/setup_22.x | bash - && \
     apt-get update && apt-get install -y \
       nodejs \
-      yarn \
-    && apt-get -y autoremove && apt-get clean autoclean && rm -rf /var/lib/apt/lists/*
+    && apt-get -y autoremove && apt-get clean autoclean && rm -rf /var/lib/apt/lists/* && \
+    npm install -g yarn
 
 # Install composer
 COPY --from=composer:latest /usr/bin/composer /usr/bin/composer

Dockerfile-frankenphp

@@ -14,31 +14,21 @@ RUN apt-get update && apt-get -y install \
     && apt-get -y autoremove && apt-get clean autoclean && rm -rf /var/lib/apt/lists/*;
 
 RUN set -eux; \
-    # Prepare keyrings directory
-    mkdir -p /etc/apt/keyrings; \
-    \
-    # Import Yarn GPG key
-    curl -fsSL https://dl.yarnpkg.com/debian/pubkey.gpg \
-      | tee /etc/apt/keyrings/yarn.gpg >/dev/null; \
-    chmod 644 /etc/apt/keyrings/yarn.gpg; \
-    \
-    # Add Yarn repo with signed-by
-    echo "deb [signed-by=/etc/apt/keyrings/yarn.gpg] https://dl.yarnpkg.com/debian stable main" \
-      | tee /etc/apt/sources.list.d/yarn.list; \
-    \
-    # Run NodeSource setup script (unchanged)
+    # Run NodeSource setup script
     curl -sL https://deb.nodesource.com/setup_22.x | bash -; \
     \
-    # Install Node.js + Yarn
+    # Install Node.js
     apt-get update; \
     apt-get install -y --no-install-recommends \
-      nodejs \
-      yarn; \
+      nodejs; \
     \
     # Cleanup
     apt-get -y autoremove; \
     apt-get clean autoclean; \
-    rm -rf /var/lib/apt/lists/*
+    rm -rf /var/lib/apt/lists/*; \
+    \
+    # Install Yarn via npm
+    npm install -g yarn
 
 
 # Install PHP

VERSION

@@ -1 +1 @@
-2.2.1
+2.5.1

assets/controllers/elements/collection_type_controller.js

@@ -21,6 +21,7 @@ import {Controller} from "@hotwired/stimulus";
 
 import * as bootbox from "bootbox";
 import "../../css/components/bootbox_extensions.css";
+import accept from "attr-accept";
 
 export default class extends Controller {
     static values = {
@@ -112,6 +113,33 @@ export default class extends Controller {
                 dataTransfer.items.add(file);
 
                 rowInput.files = dataTransfer.files;
+
+                //Check the file extension and find the corresponding attachment type based on the data-filetype_filter attribute
+                const attachmentTypeSelect = newElement.querySelector("select");
+                if (attachmentTypeSelect) {
+                    let foundMatch = false;
+                    for (let j = 0; j < attachmentTypeSelect.options.length; j++) {
+                        const option = attachmentTypeSelect.options[j];
+                        //skip disabled options
+                        if (option.disabled) {
+                            continue;
+                        }
+
+                        const filter = option.getAttribute('data-filetype_filter');
+                        if (filter) {
+                            if (accept({name: file.name, type: file.type}, filter)) {
+                                attachmentTypeSelect.value = option.value;
+                                foundMatch = true;
+                                break;
+                            }
+                        } else { //If no filter is set, chose this option until we find a better match
+                            if (!foundMatch) {
+                                attachmentTypeSelect.value = option.value;
+                                foundMatch = true;
+                            }
+                        }
+                    }
+                }
             }
 
         });
@@ -189,4 +217,4 @@ export default class extends Controller {
             del();
         }
     }
-}
+}

assets/controllers/elements/part_search_controller.js

@@ -26,9 +26,6 @@ import {marked} from "marked";
 
 import {
     trans,
-    SEARCH_PLACEHOLDER,
-    SEARCH_SUBMIT,
-    STATISTICS_PARTS
 } from '../../translator';
 
 
@@ -82,9 +79,9 @@ export default class extends Controller {
             panelPlacement: this.element.dataset.panelPlacement,
             plugins: [recentSearchesPlugin],
             openOnFocus: true,
-            placeholder: trans(SEARCH_PLACEHOLDER),
+            placeholder: trans("search.placeholder"),
             translations: {
-                submitButtonTitle: trans(SEARCH_SUBMIT)
+                submitButtonTitle: trans("search.submit")
             },
 
             // Use a navigator compatible with turbo:
@@ -153,7 +150,7 @@ export default class extends Controller {
                         },
                         templates: {
                             header({ html }) {
-                                return html`<span class="aa-SourceHeaderTitle">${trans(STATISTICS_PARTS)}</span>
+                                return html`<span class="aa-SourceHeaderTitle">${trans("part.labelp")}</span>
                                     <div class="aa-SourceHeaderLine" />`;
                             },
                             item({item, components, html}) {
@@ -197,4 +194,4 @@ export default class extends Controller {
         }
 
     }
-}
+}

assets/controllers/elements/part_select_controller.js

@@ -18,7 +18,7 @@ export default class extends Controller {
 
         let settings = {
             allowEmptyOption: true,
-            plugins: ['dropdown_input'],
+            plugins: ['dropdown_input', this.element.required ? null : 'clear_button'],
             searchField: ["name", "description", "category", "footprint"],
             valueField: "id",
             labelField: "name",

assets/controllers/elements/password_strength_estimate_controller.js

@@ -25,8 +25,7 @@ import * as zxcvbnEnPackage from '@zxcvbn-ts/language-en';
 import * as zxcvbnDePackage from '@zxcvbn-ts/language-de';
 import * as zxcvbnFrPackage from '@zxcvbn-ts/language-fr';
 import * as zxcvbnJaPackage from '@zxcvbn-ts/language-ja';
-import {trans, USER_PASSWORD_STRENGTH_VERY_WEAK, USER_PASSWORD_STRENGTH_WEAK, USER_PASSWORD_STRENGTH_MEDIUM,
-    USER_PASSWORD_STRENGTH_STRONG, USER_PASSWORD_STRENGTH_VERY_STRONG} from '../../translator.js';
+import {trans} from '../../translator.js';
 
 /* stimulusFetch: 'lazy' */
 export default class extends Controller {
@@ -89,23 +88,23 @@ export default class extends Controller {
 
         switch (level) {
             case 0:
-                text = trans(USER_PASSWORD_STRENGTH_VERY_WEAK);
+                text = trans("user.password_strength.very_weak");
                 classes = "bg-danger badge-danger";
                 break;
             case 1:
-                text = trans(USER_PASSWORD_STRENGTH_WEAK);
+                text = trans("user.password_strength.weak");
                 classes = "bg-warning badge-warning";
                 break;
             case 2:
-                text = trans(USER_PASSWORD_STRENGTH_MEDIUM)
+                text = trans("user.password_strength.medium");
                 classes = "bg-info badge-info";
                 break;
             case 3:
-                text = trans(USER_PASSWORD_STRENGTH_STRONG);
+                text = trans("user.password_strength.strong");
                 classes = "bg-primary badge-primary";
                 break;
             case 4:
-                text = trans(USER_PASSWORD_STRENGTH_VERY_STRONG);
+                text = trans("user.password_strength.very_strong");
                 classes = "bg-success badge-success";
                 break;
             default:
@@ -120,4 +119,4 @@ export default class extends Controller {
         this.badgeTarget.classList.add("badge");
         this.badgeTarget.classList.add(...classes.split(" "));
     }
-}
+}

assets/controllers/elements/structural_entity_select_controller.js

@@ -22,7 +22,7 @@ import '../../css/components/tom-select_extensions.css';
 import TomSelect from "tom-select";
 import {Controller} from "@hotwired/stimulus";
 
-import {trans, ENTITY_SELECT_GROUP_NEW_NOT_ADDED_TO_DB} from '../../translator.js'
+import {trans} from '../../translator.js'
 
 import TomSelect_autoselect_typed from '../../tomselect/autoselect_typed/autoselect_typed'
 TomSelect.define('autoselect_typed', TomSelect_autoselect_typed)
@@ -204,7 +204,7 @@ export default class extends Controller {
 
         if (data.not_in_db_yet) {
             //Not yet added items are shown italic and with a badge
-            name += "<i><b>" + escape(data.text) + "</b></i>" + "<span class='ms-3 badge bg-info badge-info'>" + trans(ENTITY_SELECT_GROUP_NEW_NOT_ADDED_TO_DB) + "</span>";
+            name += "<i><b>" + escape(data.text) + "</b></i>" + "<span class='ms-3 badge bg-info badge-info'>" + trans("entity.select.group.new_not_added_to_DB") + "</span>";
         } else {
             name += "<b>" + escape(data.text) + "</b>";
         }

assets/controllers/helpers/form_cleanup_controller.js

@@ -62,6 +62,6 @@ export default class extends Controller {
             element.disabled = true;
         }
 
-        form.submit();
+        form.requestSubmit();
     }
-}
+}

assets/controllers/pages/barcode_scan_controller.js

@@ -70,6 +70,6 @@ export default class extends Controller {
         //Put our decoded Text into the input box
         document.getElementById('scan_dialog_input').value = decodedText;
         //Submit form
-        document.getElementById('scan_dialog_form').submit();
+        document.getElementById('scan_dialog_form').requestSubmit();
     }
-}
+}

assets/js/app.js

@@ -44,7 +44,7 @@ import "./register_events";
 import "./tristate_checkboxes";
 
 //Define jquery globally
-window.$ = window.jQuery = require("jquery");
+global.$ = global.jQuery = require("jquery");
 
 //Use the local WASM file for the ZXing library
 import {

assets/js/webauthn_tfa.js

@@ -198,6 +198,7 @@ class WebauthnTFA {
     {
         const resultField = document.getElementById('_auth_code');
         resultField.value = JSON.stringify(data)
+        //requestSubmit() do not work here, probably because the submit is considered invalid. But as we do not use CSFR tokens, it should be fine.
         form.submit();
     }
 
@@ -232,4 +233,4 @@ class WebauthnTFA {
     }
 }
 
-window.webauthnTFA = new WebauthnTFA();
+window.webauthnTFA = new WebauthnTFA();

assets/translator.js

@@ -1,5 +1,6 @@
-import { localeFallbacks } from '../var/translations/configuration';
-import { trans, getLocale, setLocale, setLocaleFallbacks } from '@symfony/ux-translator';
+import { createTranslator } from '@symfony/ux-translator';
+import { messages, localeFallbacks } from '../var/translations/index.js';
+
 /*
  * This file is part of the Symfony UX Translator package.
  *
@@ -9,8 +10,12 @@ import { trans, getLocale, setLocale, setLocaleFallbacks } from '@symfony/ux-tra
  * If you use TypeScript, you can rename this file to "translator.ts" to take advantage of types checking.
  */
 
-setLocaleFallbacks(localeFallbacks);
+const translator = createTranslator({
+    messages,
+    localeFallbacks,
+});
 
-export { trans };
-
-export * from '../var/translations';
+// Wrapper function with default domain set to 'frontend'
+export const trans = (id, parameters = {}, domain = 'frontend', locale = null) => {
+    return translator.trans(id, parameters, domain, locale);
+};

composer.json

@@ -79,7 +79,8 @@
         "symfony/string": "7.4.*",
         "symfony/translation": "7.4.*",
         "symfony/twig-bundle": "7.4.*",
-        "symfony/ux-translator": "^2.10",
+        "symfony/type-info": "7.4.*",
+        "symfony/ux-translator": "^2.32.0",
         "symfony/ux-turbo": "^2.0",
         "symfony/validator": "7.4.*",
         "symfony/web-link": "7.4.*",

config/packages/knpu_oauth2_client.yaml

@@ -35,4 +35,4 @@ knpu_oauth2_client:
             provider_options:
                 urlAuthorize: 'https://identity.nexar.com/connect/authorize'
                 urlAccessToken: 'https://identity.nexar.com/connect/token'
-                urlResourceOwnerDetails: ''
+                urlResourceOwnerDetails: ''

config/packages/translation.yaml

@@ -1,7 +1,7 @@
 framework:
     default_locale: 'en'
     # Just enable the locales we need for performance reasons.
-    enabled_locale: ['en', 'de', 'it', 'fr', 'ru', 'ja', 'cs', 'da', 'zh', 'pl']
+    enabled_locale: '%partdb.locale_menu%'
     translator:
         default_path: '%kernel.project_dir%/translations'
         fallbacks:

config/packages/ux_translator.yaml

@@ -1,3 +1,12 @@
 ux_translator:
     # The directory where the JavaScript translations are dumped
     dump_directory: '%kernel.project_dir%/var/translations'
+    # Only include the frontend translation domain in the JavaScript bundle
+    domains:
+        - 'frontend'
+
+when@prod:
+    ux_translator:
+        # Control whether TypeScript types are dumped alongside translations.
+        # Disable this if you do not use TypeScript (e.g. in production when using AssetMapper), to speed up cache warmup.
+        # dump_typescript: false

config/services.yaml

@@ -33,8 +33,8 @@ services:
     App\:
         resource: '../src/'
         exclude:
-            - '../src/DataFixtures/'
-            - '../src/Doctrine/Purger/'
+            - '../src/Entity/'
+            - '../src/Helpers/'
 
     # controllers are imported separately to make sure services can be injected
     # as action arguments even if you don't extend any base controller class
@@ -274,21 +274,12 @@ services:
         tags:
             - { name: monolog.processor }
 
+    App\Doctrine\Purger\ResetAutoIncrementPurgerFactory:
+        tags:
+            - { name: 'doctrine.fixtures.purger_factory', alias: 'reset_autoincrement_purger' }
+
 when@test: &test
     services:
-
-        App\DataFixtures\:
-            resource: '../src/DataFixtures/'
-            autoconfigure: true
-            autowire: true
-
-        App\Doctrine\Purger\:
-            resource: '../src/Doctrine/Purger/'
-
-        App\Doctrine\Purger\ResetAutoIncrementPurgerFactory:
-            tags:
-                - { name: 'doctrine.fixtures.purger_factory', alias: 'reset_autoincrement_purger' }
-
         # Decorate the doctrine fixtures load command to use our custom purger by default
         doctrine.fixtures_load_command.custom:
             decorates: doctrine.fixtures_load_command
@@ -297,6 +288,3 @@ when@test: &test
                 - '@doctrine.fixtures.loader'
                 - '@doctrine'
                 - { default: '@App\Doctrine\Purger\DoNotUsePurgerFactory' }
-
-when@dev:
-    *test

crowdin.yml

@@ -5,3 +5,5 @@ files:
     translation: /translations/validators.%two_letters_code%.xlf
   - source: /translations/security.en.xlf
     translation: /translations/security.%two_letters_code%.xlf
+  - source: /translations/frontend.en.xlf
+    translation: /translations/frontend.%two_letters_code%.xlf

docs/concepts.md

@@ -50,10 +50,7 @@ A part entity has many fields, which can be used to describe it better. Most of
 * **Mass**: The mass of a single piece of this part (so of a single transistor). Given in grams.
 * **Internal Part Number** (IPN): Each part is automatically assigned a numerical ID that identifies a part in the
   database. This ID depends on when a part was created and cannot be changed. If you want to assign your own unique
-  identifiers, or sync parts identifiers with the identifiers of another database, you can use this field. Part-DB 
-  can automatically suggest IPNs based on category prefixes and sequential numbering. See the 
-  [IPN Generation documentation]({% link usage/ipn_generation.md %}) for detailed information on how to set up and use 
-  this feature.
+  identifiers, or sync parts identifiers with the identifiers of another database, you can use this field.
 
 ### Stock / Part lot
 

docs/index.md

@@ -27,8 +27,6 @@ It is installed on a web server and so can be accessed with any browser without
 * Inventory management of your electronic parts. Each part can be assigned to a category, footprint, manufacturer,
   and multiple store locations and price information. Parts can be grouped using tags. You can associate various files
   like datasheets or pictures with the parts.
-* Automatic Internal Part Number (IPN) generation with customizable prefixes and numbering schemes (see [IPN documentation]({% link usage/ipn_generation.md %}))
-* Synonym system to customize terminology throughout the application (see [Synonyms documentation]({% link usage/synonyms.md %}))
 * Multi-language support (currently German, English, Russian, Japanese, French, Czech, Danish, and Chinese)
 * Barcodes/Labels generator for parts and storage locations, scan barcodes via webcam using the built-in barcode scanner
 * User system with groups and detailed (fine-grained) permissions.

docs/installation/choosing_database.md

@@ -21,8 +21,8 @@ differences between them, which might be important for you. Therefore the pros a
 are listed here.
 
 {: .important }
-You have to choose between the database types before you start using Part-DB and **you can not change it (easily) after
-you have started creating data**. So you should choose the database type for your use case (and possible future uses).
+While you can change the database platform later (see below), it is still experimental and not recommended. 
+So you should choose the database type for your use case (and possible future uses).
 
 ## Comparison
 
@@ -180,3 +180,23 @@ and it is automatically used if available.
 For SQLite and MySQL < 10.7 it has to be emulated if wanted, which is pretty slow. Therefore it has to be explicitly enabled by setting the
 `DATABASE_EMULATE_NATURAL_SORT` environment variable to `1`. If it is 0 the classical binary sorting is used, on these databases. The emulations
 might have some quirks and issues, so it is recommended to use a database which supports natural sorting natively, if you want to use it.
+
+## Converting between database platforms
+
+{: .important }
+The database conversion is still experimental. Therefore it is recommended to backup your database before performing a conversion, and check if everything works as expected afterwards.
+
+If you want to change the database platform of your Part-DB installation (e.g. from SQLite to MySQL/MariaDB or PostgreSQL, or vice versa), there is the `partdb:migrations:convert-db-platform` console command, which can help you with that:
+
+1. Make a backup of your current database to be safe if something goes wrong (see the backup documentation).
+2. Ensure that your database is at the latest schema by running the migrations: `php bin/console doctrine:migrations:migrate`
+3. Change the `DATABASE_URL` environment variable to the new database platform and connection information. Copy the old `DATABASE_URL` as you will need it later.
+4. Run `php bin/console doctrine:migrations:migrate` again to create the database schema in the new database. You will not need the admin password, that is shown when running the migrations.
+5. Run the conversion command, where you have to provide the old `DATABASE_URL` as parameter: `php bin/console partdb:migrations:convert-db-platform <OLD_DATABASE_URL>`
+   Replace `<OLD_DATABASE_URL` with the actual old `DATABASE_URL` value (e.g. `sqlite:///%kernel.project_dir%/var/app.db`):
+   ```bash
+   php bin/console partdb:migrations:convert-db-platform sqlite:///%kernel.project_dir%/var/app.db
+   ```
+6. The command will purge all data in the new database and copy all data from the old database to the new one. This might take some time and memory depending on the size of your database.
+7. Clear the cache: `php bin/console partdb:cache:clear`
+8. You can login with your existing user accounts in the new database now. Check if everything works as expected.

docs/installation/email.md

@@ -15,13 +15,75 @@ To make emails work you have to properly configure a mail provider in Part-DB.
 ## Configuration
 
 Part-DB uses [Symfony Mailer](https://symfony.com/doc/current/mailer.html) to send emails, which supports multiple
-automatic mail providers (like MailChimp or SendGrid). If you want to use one of these providers, check the Symfony
+mail providers (like Mailgun, SendGrid, or Brevo). If you want to use one of these providers, check the Symfony
 Mailer documentation for more information.
 
 We will only cover the configuration of an SMTP provider here, which is sufficient for most use-cases.
 You will need an email account, which you can use to send emails from via password-based SMTP authentication, this account
 should be dedicated to Part-DB.
 
+### Using specialized mail providers (Mailgun, SendGrid, etc.)
+
+If you want to use a specialized mail provider like Mailgun, SendGrid, Brevo (formerly Sendinblue), Amazon SES, or 
+Postmark instead of SMTP, you need to install the corresponding Symfony mailer package first.
+
+#### Docker installation
+
+If you are using Part-DB in Docker, you can install additional mailer packages by setting the `COMPOSER_EXTRA_PACKAGES` 
+environment variable in your `docker-compose.yaml`:
+
+```yaml
+environment:
+  - COMPOSER_EXTRA_PACKAGES=symfony/mailgun-mailer
+  - MAILER_DSN=mailgun+api://API_KEY:DOMAIN@default
+  - EMAIL_SENDER_EMAIL=noreply@yourdomain.com
+  - EMAIL_SENDER_NAME=Part-DB
+  - ALLOW_EMAIL_PW_RESET=1
+```
+
+You can install multiple packages by separating them with spaces:
+
+```yaml
+environment:
+  - COMPOSER_EXTRA_PACKAGES=symfony/mailgun-mailer symfony/sendgrid-mailer
+```
+
+The packages will be installed automatically when the container starts.
+
+Common mailer packages:
+- `symfony/mailgun-mailer` - For [Mailgun](https://www.mailgun.com/)
+- `symfony/sendgrid-mailer` - For [SendGrid](https://sendgrid.com/)
+- `symfony/brevo-mailer` - For [Brevo](https://www.brevo.com/) (formerly Sendinblue)
+- `symfony/amazon-mailer` - For [Amazon SES](https://aws.amazon.com/ses/)
+- `symfony/postmark-mailer` - For [Postmark](https://postmarkapp.com/)
+
+#### Direct installation (non-Docker)
+
+If you have installed Part-DB directly on your server (not in Docker), you need to manually install the required 
+mailer package using composer.
+
+Navigate to your Part-DB installation directory and run:
+
+```bash
+# Install the package as the web server user
+sudo -u www-data composer require symfony/mailgun-mailer
+
+# Clear the cache
+sudo -u www-data php bin/console cache:clear
+```
+
+Replace `symfony/mailgun-mailer` with the package you need. You can install multiple packages at once:
+
+```bash
+sudo -u www-data composer require symfony/mailgun-mailer symfony/sendgrid-mailer
+```
+
+After installing the package, configure the `MAILER_DSN` in your `.env.local` file according to the provider's 
+documentation (see [Symfony Mailer documentation](https://symfony.com/doc/current/mailer.html) for DSN format for 
+each provider).
+
+## SMTP Configuration
+
 To configure the SMTP provider, you have to set the following environment variables:
 
 `MAILER_DSN`: You have to provide the SMTP server address and the credentials for the email account here. The format is

docs/installation/installation_docker.md

@@ -80,7 +80,11 @@ services:
       #- BANNER=This is a test banner<br>with a line break
     
       # If you use a reverse proxy in front of Part-DB, you must configure the trusted proxies IP addresses here (see reverse proxy documentation for more information):
-      # - TRUSTED_PROXIES=127.0.0.0/8,::1,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16  
+      # - TRUSTED_PROXIES=127.0.0.0/8,::1,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16
+      
+      # If you need to install additional composer packages (e.g., for specific mailer transports), you can specify them here:
+      # The packages will be installed automatically when the container starts
+      # - COMPOSER_EXTRA_PACKAGES=symfony/mailgun-mailer symfony/sendgrid-mailer
 ```
 
 4. Customize the settings by changing the environment variables (or adding new ones). See [Configuration]({% link
@@ -149,6 +153,9 @@ services:
       # Override value if you want to show a given text on homepage.
       # When this is commented out the webUI can be used to configure the banner
       #- BANNER=This is a test banner<br>with a line break
+      
+      # If you need to install additional composer packages (e.g., for specific mailer transports), you can specify them here:
+      # - COMPOSER_EXTRA_PACKAGES=symfony/mailgun-mailer symfony/sendgrid-mailer
 
   database:
     container_name: partdb_database
@@ -169,6 +176,38 @@ services:
 
 ```
 
+### Installing additional composer packages
+
+If you need to use specific mailer transports or other functionality that requires additional composer packages, you can 
+install them automatically at container startup using the `COMPOSER_EXTRA_PACKAGES` environment variable.
+
+For example, if you want to use Mailgun as your email provider, you need to install the `symfony/mailgun-mailer` package.
+Add the following to your docker-compose.yaml environment section:
+
+```yaml
+environment:
+  - COMPOSER_EXTRA_PACKAGES=symfony/mailgun-mailer
+  - MAILER_DSN=mailgun+api://API_KEY:DOMAIN@default
+```
+
+You can specify multiple packages by separating them with spaces:
+
+```yaml
+environment:
+  - COMPOSER_EXTRA_PACKAGES=symfony/mailgun-mailer symfony/sendgrid-mailer
+```
+
+{: .info }
+> The packages will be installed when the container starts. This may increase the container startup time on the first run.
+> The installed packages will persist in the container until it is recreated.
+
+Common mailer packages you might need:
+- `symfony/mailgun-mailer` - For Mailgun email service
+- `symfony/sendgrid-mailer` - For SendGrid email service  
+- `symfony/brevo-mailer` - For Brevo (formerly Sendinblue) email service
+- `symfony/amazon-mailer` - For Amazon SES email service
+- `symfony/postmark-mailer` - For Postmark email service
+
 ### Update Part-DB
 
 You can update Part-DB by pulling the latest image and restarting the container.

docs/troubleshooting.md

@@ -50,6 +50,21 @@ docker-compose logs -f
 
 Please include the error logs in your issue on GitHub, if you open an issue.
 
+## KiCad Integration Issues
+
+### "API responded with error code: 0: Unknown"
+
+If you get this error when trying to connect KiCad to Part-DB, it is most likely caused by KiCad not trusting your SSL/TLS certificate.
+
+**Cause:** KiCad does not trust self-signed SSL/TLS certificates.
+
+**Solutions:**
+- Use HTTP instead of HTTPS for the `root_url` in your KiCad library configuration (only recommended for local networks)
+- Use a certificate from a trusted Certificate Authority (CA) like [Let's Encrypt](https://letsencrypt.org/)
+- Add your self-signed certificate to the system's trusted certificate store on the computer running KiCad (the exact steps depend on your operating system)
+
+For more information about KiCad integration, see the [EDA / KiCad integration](../usage/eda_integration.md) documentation.
+
 ## Report Issue
 
 If an error occurs, or you found a bug, please [open an issue on GitHub](https://github.com/Part-DB/Part-DB-server).

docs/usage/console_commands.md

@@ -68,6 +68,7 @@ docker exec --user=www-data partdb php bin/console cache:clear
   deleted!*
 * `settings:migrate-env-to-settings`: Migrate configuration from environment variables to the settings interface.
 The value of the environment variable is copied to the settings database, so the environment variable can be removed afterwards without losing the configuration.
+* `partdb:migrations:convert-db-platform`: Convert the database platform (e.g. from SQLite to MySQL/MariaDB or PostgreSQL, or vice versa).
 
 ## Database commands
 

docs/usage/eda_integration.md

@@ -22,6 +22,16 @@ This also allows to configure available and usable parts and their properties in
 Part-DB should be accessible from the PCs with KiCad. The URL should be stable (so no dynamically changing IP).
 You require a user account in Part-DB, which has permission to access the Part-DB API and create API tokens. Every user can have their own account, or you set up a shared read-only account.
 
+{: .warning }
+> **HTTPS with Self-Signed Certificates**
+> 
+> KiCad does not trust self-signed SSL/TLS certificates. If your Part-DB instance uses HTTPS with a self-signed certificate, KiCad will fail to connect and show an error like: `API responded with error code: 0: Unknown`.
+> 
+> To resolve this issue, you have the following options:
+> - Use HTTP instead of HTTPS for the `root_url` (only recommended for local networks)
+> - Use a certificate from a trusted Certificate Authority (CA) like [Let's Encrypt](https://letsencrypt.org/)
+> - Add your self-signed certificate to the system's trusted certificate store on the computer running KiCad (the exact steps depend on your operating system)
+
 To connect KiCad with Part-DB do the following steps:
 
 1. Create an API token on the user settings page for the KiCad application and copy/save it when it is shown. Currently, KiCad can only read the Part-DB database, so a token with a read-only scope is enough.

docs/usage/information_provider_system.md

@@ -260,6 +260,34 @@ This is not an official API and could break at any time. So use it at your own r
 The following env configuration options are available:
 * `PROVIDER_POLLIN_ENABLED`: Set this to `1` to enable the Pollin provider
 
+### Buerklin
+
+The Buerklin provider uses the [Buerklin API](https://www.buerklin.com/en/services/eprocurement/) to search for parts and get information.
+To use it you have to request access to the API.
+You will get an e-mail with the client ID and client secret, which you have to put in the Part-DB configuration (see below).
+
+Please note that the Buerklin API is limited to 100 requests/minute per IP address and 
+access to the Authentication server is limited to 10 requests/minute per IP address
+
+The following env configuration options are available:
+
+* `PROVIDER_BUERKLIN_CLIENT_ID`: The client ID you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_SECRET`: The client secret you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_USERNAME`: The username you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_PASSWORD`: The password you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_CURRENCY`: The currency you want to get prices in if available (optional, 3 letter ISO-code, default: `EUR`).
+* `PROVIDER_BUERKLIN_LANGUAGE`: The language you want to get the descriptions in. Possible values: `de` = German, `en` = English. (optional, default: `en`)
+
+### Conrad
+
+The conrad provider the [Conrad API](https://developer.conrad.com/) to search for parts and retried their information.
+To use it you have to request access to the API, however it seems currently your mail address needs to be allowlisted before you can register for an account.
+The conrad webpages uses the API key in the requests, so you might be able to extract a working API key by listening to browser requests.
+That method is not officially supported nor encouraged by Part-DB, and might break at any moment.
+
+The following env configuration options are available:
+* `PROVIDER_CONRAD_API_KEY`: The API key you got from Conrad (mandatory)
+
 ### Custom provider
 
 To create a custom provider, you have to create a new class implementing the `InfoProviderInterface` interface. As long

docs/usage/ipn_generation.md

@@ -1,306 +0,0 @@
----
-title: Internal Part Number (IPN) Generation
-layout: default
-parent: Usage
-nav_order: 12
----
-
-# Internal Part Number (IPN) Generation
-
-Part-DB supports automatic generation and management of Internal Part Numbers (IPNs) for your parts. IPNs are unique identifiers that help you organize and track your inventory in a structured way.
-
-1. TOC
-{:toc}
-
-## What is an IPN?
-
-An Internal Part Number (IPN) is a unique identifier assigned to each part in your inventory. Unlike manufacturer part numbers (MPNs), IPNs are defined and controlled by you, following your own naming conventions and organizational structure.
-
-IPNs are useful for:
-- Creating a consistent numbering scheme across your entire inventory
-- Organizing parts hierarchically based on categories
-- Quickly identifying and locating parts
-- Generating barcodes for parts
-- Integrating with external systems (like EDA tools)
-
-## Basic Concepts
-
-### IPN Structure
-
-An IPN typically consists of several components:
-- **Prefix**: Identifies the category or type of part (e.g., "RES" for resistors, "CAP" for capacitors)
-- **Separator**: Divides different parts of the IPN (default is `-`)
-- **Number**: A sequential number that makes the IPN unique
-
-Example: `RES-0001`, `CAP-IC-0042`, `MCU-ARM-1234`
-
-### Category-Based IPN Prefixes
-
-Categories in Part-DB can have their own IPN prefix. When creating a new part in a category, Part-DB can automatically suggest IPNs based on the category's prefix.
-
-To set an IPN prefix for a category:
-1. Navigate to the category edit page
-2. Find the "Part IPN Prefix" field
-3. Enter your desired prefix (e.g., "RES", "CAP", "IC")
-
-### Hierarchical Prefixes
-
-Part-DB supports hierarchical IPN generation based on parent categories. For example:
-- Parent category "IC" with prefix "IC"
-- Child category "Microcontrollers" with prefix "MCU"
-- Generated IPN could be: `IC-MCU-0001`
-
-This allows you to create deeply nested categorization schemes while maintaining clear IPNs.
-
-## Configuring IPN Generation
-
-You can configure IPN generation in the system settings under `Tools -> System -> Settings -> Miscellaneous -> IPN Suggest Settings`.
-
-### Available Settings
-
-#### Regex Pattern
-Define a regular expression pattern that valid IPNs must match. This helps enforce consistency across your inventory.
-
-Example: `^[A-Za-z0-9]{3,4}(?:-[A-Za-z0-9]{3,4})*-\d{4}$`
-
-This pattern requires:
-- 3-4 alphanumeric characters for prefixes
-- Optional additional prefix groups separated by `-`
-- Ending with a 4-digit number
-
-#### Regex Help Text
-Provide custom help text that explains your IPN format to users. This text is shown when users are creating or editing parts.
-
-#### Auto-Append Suffix
-When enabled, Part-DB automatically appends a suffix (`_1`, `_2`, etc.) to IPNs that would otherwise be duplicates. This prevents IPN collisions when multiple parts might generate the same IPN.
-
-**Example:**
-- First part: `RES-0001`
-- Duplicate attempt: automatically becomes `RES-0001_1`
-- Next duplicate: automatically becomes `RES-0001_2`
-
-#### Suggest Part Digits
-Defines how many digits should be used for the sequential part number (default: 4).
-- 4 digits: `0001` to `9999`
-- 6 digits: `000001` to `999999`
-
-#### Use Duplicate Description
-When enabled, Part-DB will suggest the same IPN for parts with identical descriptions. This is useful when you want to track variants of the same component with the same IPN scheme.
-
-#### Fallback Prefix
-The prefix to use when a category has no IPN prefix defined (default: `N.A.`). This ensures all parts can get an IPN suggestion even without category-specific prefixes.
-
-#### Number Separator
-The character that separates the prefix from the number (default: `-`).
-
-Example: With separator `-`, you get `RES-0001`. With separator `.`, you get `RES.0001`.
-
-#### Category Separator
-The character that separates hierarchical category prefixes (default: `-`).
-
-Example: With separator `-`, you get `IC-MCU-0001`. With separator `.`, you get `IC.MCU.0001`.
-
-#### Global Prefix
-An optional prefix that is prepended to all IPNs in your system. Useful if you want to distinguish your inventory from other systems.
-
-Example: With global prefix `ACME`, IPNs become `ACME-RES-0001`, `ACME-CAP-0042`, etc.
-
-## Using IPN Suggestions
-
-### When Creating a New Part
-
-When you create a new part, Part-DB provides IPN suggestions based on:
-
-1. **Global Prefix** (if configured): Suggestions using your global prefix
-2. **Description Matching** (if enabled): If another part has the same description, its IPN is suggested
-3. **Direct Category Prefix**: The IPN prefix of the part's assigned category
-4. **Hierarchical Prefixes**: IPNs combining parent category prefixes with the current category
-
-Each suggestion includes:
-- The suggested IPN
-- A description of how it was generated
-- An auto-incremented version (ending with the next available number)
-
-### IPN Suggestion Types
-
-#### Common Prefixes
-These show just the prefix part without a number. Use these as a starting point to manually add your own number.
-
-Example: `RES-` (you then type `RES-1234`)
-
-#### Prefixes with Part Increment
-These show complete IPNs with automatically incremented numbers. The system finds the highest existing number with that prefix and suggests the next one.
-
-Example: If `RES-0001` through `RES-0005` exist, the system suggests `RES-0006`.
-
-### Manual IPN Entry
-
-You can always manually enter any IPN you want. If you've configured a regex pattern, Part-DB will validate your IPN against it and show an error if it doesn't match.
-
-## IPN Uniqueness
-
-IPNs must be unique across your entire Part-DB instance. Part-DB enforces this constraint:
-
-- When manually entering an IPN, you'll see an error if it already exists
-- When auto-append suffix is enabled, duplicate IPNs are automatically made unique
-- Existing parts retain their IPNs even if you change their category
-
-## IPNs in Labels and Barcodes
-
-IPNs can be used in label templates through placeholders:
-
-- `[[IPN]]` - The IPN as text
-- `[[IPN_BARCODE_C39]]` - IPN as Code 39 barcode
-- `[[IPN_BARCODE_C128]]` - IPN as Code 128 barcode
-- `[[IPN_BARCODE_QR]]` - IPN as QR code
-
-See the [Labels documentation]({% link usage/labels.md %}) for more information.
-
-## IPNs in Barcode Scanning
-
-Part-DB can scan barcodes containing IPNs to quickly find parts. When a barcode is scanned, Part-DB:
-1. Attempts to parse it as an IPN
-2. Searches for the part with that IPN
-3. Displays the part information
-
-This enables quick inventory operations using barcode scanners.
-
-## IPNs in EDA Integration
-
-When using Part-DB with EDA tools like KiCad, the IPN is automatically added to the component fields as "Part-DB IPN". This creates a direct link between your schematic components and your Part-DB inventory.
-
-See the [EDA Integration documentation]({% link usage/eda_integration.md %}) for more information.
-
-## Best Practices
-
-### Choosing Prefixes
-
-- **Keep them short**: 2-4 characters work well (e.g., "RES", "CAP", "IC")
-- **Make them memorable**: Use abbreviations that are obvious (avoid "XYZ" or "ABC")
-- **Be consistent**: Use the same style across all categories (all caps or all lowercase)
-- **Avoid ambiguity**: Don't use similar prefixes like "IC" and "1C"
-
-### Numbering Schemes
-
-- **Pad with zeros**: Use leading zeros for cleaner sorting (0001, 0042 instead of 1, 42)
-- **Leave room for growth**: If you have 50 parts now, use 4 digits (up to 9999) instead of 2
-- **Don't encode information**: Let the prefix and category do the work, not the number
-- **Sequential is fine**: You don't need gaps - 0001, 0002, 0003 is perfectly valid
-
-### Hierarchical Categories
-
-- **Limit depth**: 2-3 levels is usually sufficient (IC-MCU vs IC-MCU-ARM-STM32)
-- **Balance specificity**: More levels = longer IPNs but more precise categorization
-- **Consider searching**: Very specific categories are harder to search across
-
-### Changing Your Scheme
-
-- **Plan ahead**: Changing IPN schemes later is difficult
-- **Document your convention**: Add your IPN format to your regex help text
-- **Existing parts**: Don't feel obligated to renumber existing parts if you change schemes
-- **Migration**: Use import/export to batch-update IPNs if needed
-
-## Common Issues and Solutions
-
-### "IPN already exists"
-
-**Problem**: You're trying to use an IPN that's already assigned to another part.
-
-**Solutions**:
-- Choose a different number
-- Enable "Auto-Append Suffix" to automatically handle duplicates
-- Search for the existing part to see if it's a duplicate you should merge
-
-### "IPN doesn't match regex pattern"
-
-**Problem**: Your IPN doesn't follow the configured format.
-
-**Solutions**:
-- Check the regex help text to understand the expected format
-- Contact your administrator if the regex is too restrictive
-- Use the suggested IPNs which are guaranteed to match
-
-### Suggestions not showing
-
-**Problem**: IPN suggestions are empty or not appearing.
-
-**Solutions**:
-- Ensure the part has a category assigned
-- Check that the category has an IPN prefix defined
-- Verify that a fallback prefix is configured in settings
-- Save the part first before getting suggestions (for new parts)
-
-### Wrong prefix being suggested
-
-**Problem**: Part-DB suggests an IPN with the wrong prefix.
-
-**Solutions**:
-- Check the part's category - suggestions are based on the assigned category
-- Verify parent categories and their prefixes if using hierarchical structure
-- Set the correct IPN prefix in the category settings
-- Use manual entry with your desired prefix
-
-## Example Scenarios
-
-### Simple Electronic Components Inventory
-
-**Setup**:
-- Categories: Resistors, Capacitors, ICs, etc.
-- Prefixes: RES, CAP, IC
-- 4-digit numbering
-
-**Results**:
-- `RES-0001` - 10kΩ resistor
-- `CAP-0001` - 100nF capacitor
-- `IC-0001` - ATmega328
-
-### Professional Lab with Detailed Categories
-
-**Setup**:
-- Hierarchical categories: Components > Passive > Resistors > Surface Mount
-- Prefixes: COMP, PAS, RES, SMD
-- Global prefix: LAB
-- 6-digit numbering
-
-**Results**:
-- `LAB-COMP-PAS-RES-SMD-000001` - 0805 10kΩ resistor
-- `LAB-COMP-PAS-CAP-SMD-000001` - 0805 100nF capacitor
-
-### Makerspace with Mixed Inventory
-
-**Setup**:
-- Categories for electronics, mechanical parts, tools
-- Simple prefixes: ELEC, MECH, TOOL
-- Fallback prefix for miscellaneous: MISC
-- 4-digit numbering
-
-**Results**:
-- `ELEC-0001` - Arduino Uno
-- `MECH-0001` - M3 screw set
-- `TOOL-0001` - Soldering iron
-- `MISC-0001` - Cable ties
-
-## Environment Variables
-
-IPN settings can be configured via environment variables (useful for Docker deployments):
-
-- `IPN_SUGGEST_REGEX` - Override the regex pattern
-- `IPN_SUGGEST_REGEX_HELP` - Override the regex help text
-- `IPN_AUTO_APPEND_SUFFIX` - Enable/disable auto-append suffix (boolean)
-- `IPN_SUGGEST_PART_DIGITS` - Number of digits for part numbers (integer)
-- `IPN_USE_DUPLICATE_DESCRIPTION` - Enable/disable duplicate description matching (boolean)
-
-Example in docker-compose.yaml:
-```yaml
-environment:
-  IPN_SUGGEST_REGEX: "^[A-Z]{3}-\d{4}$"
-  IPN_AUTO_APPEND_SUFFIX: "true"
-  IPN_SUGGEST_PART_DIGITS: "4"
-```
-
-## Related Documentation
-
-- [Getting Started]({% link usage/getting_started.md %}) - Initial setup guide
-- [Concepts]({% link concepts.md %}) - Understanding Part-DB concepts
-- [Labels]({% link usage/labels.md %}) - Using IPNs in labels
-- [EDA Integration]({% link usage/eda_integration.md %}) - IPNs in electronic design tools

docs/usage/synonyms.md

@@ -1,346 +0,0 @@
----
-title: Synonym System
-layout: default
-parent: Usage
-nav_order: 13
----
-
-# Synonym System
-
-Part-DB includes a powerful synonym system that allows you to customize the terminology used throughout the application. This is especially useful when using Part-DB in contexts other than electronics, or when you want to adapt the interface to your organization's specific vocabulary.
-
-1. TOC
-{:toc}
-
-## What is the Synonym System?
-
-The synonym system allows you to replace Part-DB's standard terminology with your own preferred terms. For example:
-- Change "Part" to "Product", "Component", or "Item"
-- Change "Category" to "Group", "Type", or "Class"
-- Change "Manufacturer" to "Supplier", "Vendor", or "Brand"
-
-These custom terms (synonyms) are applied throughout the user interface, making Part-DB feel more natural for your specific use case.
-
-## Important Notes
-
-{: .warning-title }
-> Experimental Feature
->
-> The synonym system is currently **experimental**. While it works in most places throughout Part-DB, there may be some locations where the default terms still appear. The synonym system is being continuously improved.
-
-## Configuring Synonyms
-
-To configure synonyms, you need administrator permissions:
-
-1. Navigate to `Tools -> System -> Settings`
-2. Find and click on "Synonyms" in the settings menu
-3. You'll see the synonym configuration interface
-
-### Adding a Synonym
-
-To add a new synonym:
-
-1. Click the "Add Entry" button in the synonym settings
-2. Select the **Type** (element type) you want to create a synonym for
-3. Select the **Language** for which the synonym applies
-4. Enter the **Singular** form of your synonym
-5. Enter the **Plural** form of your synonym
-6. Click "Save" to apply the changes
-
-### Available Element Types
-
-You can create synonyms for the following element types:
-
-| Element Type        | Default Term (EN)     | Example Use Cases                             |
-|--------------------|-----------------------|-----------------------------------------------|
-| **attachment**     | Attachment            | Document, File, Asset                          |
-| **attachment_type**| Attachment Type       | Document Type, File Category                   |
-| **category**       | Category              | Group, Class, Type, Collection                 |
-| **currency**       | Currency              | Monetary Unit, Money Type                      |
-| **footprint**      | Footprint             | Package, Form Factor, Physical Type            |
-| **group**          | Group                 | Team, Department, Role                         |
-| **label_profile**  | Label Profile         | Label Template, Print Template                 |
-| **manufacturer**   | Manufacturer          | Brand, Vendor, Supplier, Maker                 |
-| **measurement_unit**| Measurement Unit     | Unit of Measure, Unit, Measurement             |
-| **parameter**      | Parameter             | Specification, Property, Attribute             |
-| **part**           | Part                  | Component, Item, Product, Article, SKU         |
-| **part_lot**       | Part Lot              | Stock Item, Inventory Item, Batch              |
-| **project**        | Project               | Assembly, Build, Work Order                    |
-| **storage_location**| Storage Location     | Warehouse, Bin, Location, Place                |
-| **supplier**       | Supplier              | Vendor, Distributor, Reseller                  |
-| **user**           | User                  | Member, Account, Person                        |
-
-## How Synonyms Work
-
-### Translation Mechanism
-
-The synonym system works by integrating with Part-DB's translation system. When you define a synonym:
-
-1. Part-DB creates translation placeholders for the element type
-2. These placeholders are available in both capitalized and lowercase forms
-3. The placeholders are used throughout the application where these terms appear
-
-### Placeholder Format
-
-Synonyms use special placeholders in translations:
-
-- `[elementtype]` - Singular, lowercase (e.g., "part" → "item")
-- `[Elementtype]` - Singular, capitalized (e.g., "Part" → "Item")
-- `[[elementtype]]` - Plural, lowercase (e.g., "parts" → "items")
-- `[[Elementtype]]` - Plural, capitalized (e.g., "Parts" → "Items")
-
-### Language-Specific Synonyms
-
-Synonyms are language-specific, meaning you can define different terms for different languages:
-
-- English users see: "Component" and "Components"
-- German users see: "Bauteil" and "Bauteile"
-- French users see: "Composant" and "Composants"
-
-This allows Part-DB to maintain proper multilingual support even with custom terminology.
-
-## Use Cases and Examples
-
-### Non-Electronics Inventory
-
-**Scenario**: Using Part-DB for a library
-
-**Synonyms**:
-- Part → Book
-- Category → Genre
-- Manufacturer → Publisher
-- Supplier → Distributor
-- Storage Location → Shelf
-
-**Result**: The interface now speaks library language: "Add a new Book", "Select a Genre", etc.
-
-### Manufacturing Environment
-
-**Scenario**: Managing production inventory
-
-**Synonyms**:
-- Part → Material
-- Category → Material Type
-- Part Lot → Batch
-- Storage Location → Warehouse Zone
-- Project → Assembly
-
-**Result**: The interface uses manufacturing terminology: "Materials", "Batches", "Warehouse Zones", "Assemblies"
-
-### Small Business Retail
-
-**Scenario**: Managing store inventory
-
-**Synonyms**:
-- Part → Product
-- Category → Department
-- Manufacturer → Brand
-- Supplier → Vendor
-- Part Lot → Stock Item
-- Storage Location → Store Location
-
-**Result**: The interface matches retail terminology: "Products", "Departments", "Brands"
-
-### Laboratory Setting
-
-**Scenario**: Managing lab supplies and chemicals
-
-**Synonyms**:
-- Part → Reagent
-- Category → Substance Type
-- Manufacturer → Chemical Supplier
-- Storage Location → Cabinet
-- Part Lot → Bottle
-
-**Result**: Lab-appropriate language: "Reagents", "Substance Types", "Cabinets"
-
-### Educational Makerspace
-
-**Scenario**: Managing shared tools and components
-
-**Synonyms**:
-- Part → Resource
-- Category → Resource Type
-- Storage Location → Area
-- Project → Activity
-- Part Lot → Available Unit
-
-**Result**: Educational context: "Resources", "Resource Types", "Areas", "Activities"
-
-## Managing Synonyms
-
-### Editing Synonyms
-
-To edit an existing synonym:
-1. Find the synonym entry in the list
-2. Modify the singular or plural form as needed
-3. Click "Save" to apply changes
-
-### Removing Synonyms
-
-To remove a synonym:
-1. Find the synonym entry in the list
-2. Click the "Remove Entry" button (usually a trash icon)
-3. Click "Save" to apply changes
-
-After removal, Part-DB will revert to using the default term for that element type and language.
-
-### Bulk Configuration
-
-If you need to set up many synonyms at once (e.g., for a complete custom terminology set):
-
-1. Define all your synonyms in the settings page
-2. Each element type can have synonyms in multiple languages
-3. Save once when all entries are configured
-
-### Duplicate Prevention
-
-The system prevents duplicate entries:
-- You cannot have multiple synonyms for the same element type and language combination
-- If you try to add a duplicate, you'll see a validation error
-- Edit the existing entry instead of creating a new one
-
-## Best Practices
-
-### Consistency
-
-- **Use consistent terminology**: If you change "Part" to "Product", consider changing "Part Lot" to "Product Item" or similar
-- **Think holistically**: Consider how terms relate to each other in your domain
-- **Test thoroughly**: Check various pages to ensure your terms make sense in context
-
-### Singular and Plural Forms
-
-- **Provide both forms**: Always define both singular and plural forms
-- **Use proper grammar**: Ensure plurals are grammatically correct
-- **Consider irregular plurals**: Some terms have non-standard plurals (e.g., "Box" → "Boxes", not "Boxs")
-
-### Language Considerations
-
-- **Match user expectations**: Use terms your users are familiar with in their language
-- **Be culturally appropriate**: Some terms may have different connotations in different languages
-- **Maintain professionalism**: Choose terms appropriate for your organizational context
-
-### Planning Your Terminology
-
-Before implementing synonyms:
-
-1. **List all terms**: Identify which Part-DB terms don't fit your context
-2. **Define replacements**: Decide on appropriate alternatives
-3. **Check relationships**: Ensure related terms work together logically
-4. **Get feedback**: Consult with users about proposed terminology
-5. **Document decisions**: Keep a record of your synonym choices for future reference
-
-## Limitations
-
-### Not All Locations Covered
-
-As an experimental feature, synonyms may not appear in:
-- Some error messages
-- Technical logs
-- Email templates (depending on configuration)
-- API responses
-- Some administrative interfaces
-
-The development team is working to expand synonym coverage.
-
-### No Automatic Propagation
-
-Synonyms only affect the user interface:
-- Database values remain unchanged
-- Export files use original terms
-- API endpoints keep original names
-- URLs and routes remain the same
-
-### Performance Considerations
-
-The synonym system:
-- Caches translations for performance
-- Minimal performance impact in normal usage
-- Cache is automatically updated when synonyms change
-
-## Technical Details
-
-### Cache Management
-
-Synonyms are cached for performance:
-- Cache is automatically cleared when synonyms are saved
-- No manual cache clearing needed
-- Changes appear immediately after saving
-
-### Translation Priority
-
-When displaying text, Part-DB checks in this order:
-1. Synonym (if defined for current language and element type)
-2. Standard translation (from translation files)
-3. Fallback to English default
-
-### Environment Variables
-
-Currently, synonyms can only be configured through the web interface. Future versions may support environment variable configuration.
-
-## Troubleshooting
-
-### Synonyms Not Appearing
-
-**Problem**: You've configured synonyms but still see original terms.
-
-**Solutions**:
-- Clear your browser cache and reload the page
-- Check that you've configured the synonym for the correct language
-- Verify that you saved the settings after adding the synonym
-- Remember this is an experimental feature - some locations may not be covered yet
-
-### Inconsistent Terminology
-
-**Problem**: Some pages show your synonym, others show the original term.
-
-**Solutions**:
-- This is expected behavior for the experimental feature
-- Check if you've defined both singular and plural forms
-- Report inconsistencies to help improve the system
-
-### Wrong Language Displaying
-
-**Problem**: Seeing synonyms from the wrong language.
-
-**Solutions**:
-- Check your user language preference in user settings
-- Verify you've configured synonyms for the correct language code
-- Ensure the language code matches exactly (e.g., "en" not "en_US")
-
-### Synonyms Lost After Update
-
-**Problem**: Synonyms disappeared after updating Part-DB.
-
-**Solutions**:
-- Check the settings page - they should still be there
-- Database migrations preserve synonym settings
-- If truly lost, restore from backup or reconfigure
-
-## Future Enhancements
-
-The synonym system is under active development. Planned improvements include:
-- Coverage of more interface elements
-- Synonym suggestions based on common use cases
-- Import/export of synonym configurations
-- Synonym templates for different industries
-- More granular control over term usage
-
-## Related Documentation
-
-- [Getting Started]({% link usage/getting_started.md %}) - Initial Part-DB setup
-- [Configuration]({% link configuration.md %}) - System configuration options
-- [Concepts]({% link concepts.md %}) - Understanding Part-DB terminology
-
-## Feedback
-
-Since the synonym system is experimental, feedback is valuable:
-- Report locations where synonyms don't appear
-- Suggest new element types that should support synonyms
-- Share your use cases to help improve the system
-- Report bugs or unexpected behavior
-
-You can provide feedback through:
-- GitHub issues on the Part-DB repository
-- Community forums and discussions
-- Direct contact with the development team

package.json

@@ -17,7 +17,7 @@
         "popper.js": "^1.14.7",
         "regenerator-runtime": "^0.13.9",
         "webpack": "^5.74.0",
-        "webpack-bundle-analyzer": "^4.3.0",
+        "webpack-bundle-analyzer": "^5.1.1",
         "webpack-cli": "^5.1.0",
         "webpack-notifier": "^1.15.0"
     },
@@ -46,6 +46,7 @@
         "@zxcvbn-ts/language-en": "^3.0.1",
         "@zxcvbn-ts/language-fr": "^3.0.1",
         "@zxcvbn-ts/language-ja": "^3.0.1",
+        "attr-accept": "^2.2.5",
         "barcode-detector": "^3.0.5",
         "bootbox": "^6.0.0",
         "bootswatch": "^5.1.3",
@@ -65,7 +66,7 @@
         "json-formatter-js": "^2.3.4",
         "jszip": "^3.2.0",
         "katex": "^0.16.0",
-        "marked": "^16.1.1",
+        "marked": "^17.0.1",
         "marked-gfm-heading-id": "^4.1.1",
         "marked-mangle": "^1.0.1",
         "pdfmake": "^0.2.2",
@@ -73,5 +74,8 @@
         "tom-select": "^2.1.0",
         "ts-loader": "^9.2.6",
         "typescript": "^5.7.2"
+    },
+    "resolutions": {
+        "jquery": "^3.5.1"
     }
 }

src/Command/Migrations/DBPlatformConvertCommand.php

@@ -0,0 +1,253 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2026 Jan Böhmer (https://github.com/jbtronics)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Command\Migrations;
+
+use App\Entity\UserSystem\User;
+use App\Services\ImportExportSystem\PartKeeprImporter\PKImportHelper;
+use Doctrine\Bundle\DoctrineBundle\ConnectionFactory;
+use Doctrine\DBAL\Platforms\AbstractMySQLPlatform;
+use Doctrine\DBAL\Platforms\PostgreSQLPlatform;
+use Doctrine\Migrations\Configuration\EntityManager\ExistingEntityManager;
+use Doctrine\Migrations\Configuration\Migration\ExistingConfiguration;
+use Doctrine\ORM\EntityManager;
+use Doctrine\ORM\EntityManagerInterface;
+use Doctrine\Migrations\DependencyFactory;
+use Doctrine\ORM\Id\AssignedGenerator;
+use Doctrine\ORM\Mapping\ClassMetadata;
+use Symfony\Component\Console\Attribute\AsCommand;
+use Symfony\Component\Console\Command\Command;
+use Symfony\Component\Console\Input\InputArgument;
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Output\OutputInterface;
+use Symfony\Component\Console\Style\SymfonyStyle;
+use Symfony\Component\DependencyInjection\Attribute\Autowire;
+
+#[AsCommand('partdb:migrations:convert-db-platform', 'Convert the database to a different platform')]
+class DBPlatformConvertCommand extends Command
+{
+
+    public function __construct(
+        private readonly EntityManagerInterface $targetEM,
+        private readonly PKImportHelper $importHelper,
+        private readonly DependencyFactory $dependencyFactory,
+        #[Autowire('%kernel.project_dir%')]
+        private readonly string $kernelProjectDir,
+    )
+    {
+        parent::__construct();
+    }
+
+    public function configure(): void
+    {
+        $this
+            ->setHelp('This command allows you to migrate the database from one database platform to another (e.g. from MySQL to PostgreSQL).')
+            ->addArgument('url', InputArgument::REQUIRED, 'The database connection URL of the source database to migrate from');
+    }
+
+    public function execute(InputInterface $input, OutputInterface $output): int
+    {
+        $io = new SymfonyStyle($input, $output);
+
+        $sourceEM = $this->getSourceEm($input->getArgument('url'));
+
+        //Check that both databases are not using the same driver
+        if ($sourceEM->getConnection()->getDatabasePlatform()::class === $this->targetEM->getConnection()->getDatabasePlatform()::class) {
+            $io->warning('Source and target database are using the same database platform / driver. This command is only intended to migrate between different database platforms (e.g. from MySQL to PostgreSQL).');
+            if (!$io->confirm('Do you want to continue anyway?', false)) {
+                $io->info('Aborting migration process.');
+                return Command::SUCCESS;
+            }
+        }
+
+
+        $this->ensureVersionUpToDate($sourceEM);
+
+        $io->note('This command is still in development. If you encounter any problems, please report them to the issue tracker on GitHub.');
+        $io->warning(sprintf('This command will delete all existing data in the target database "%s". Make sure that you have no important data in the database before you continue!',
+            $this->targetEM->getConnection()->getDatabase() ?? 'unknown'
+        ));
+
+        //$users = $sourceEM->getRepository(User::class)->findAll();
+        //dump($users);
+
+        $io->ask('Please type "DELETE ALL DATA" to continue.', '', function ($answer) {
+            if (strtoupper($answer) !== 'DELETE ALL DATA') {
+                throw new \RuntimeException('You did not type "DELETE ALL DATA"!');
+            }
+            return $answer;
+        });
+
+
+        // Example migration logic (to be replaced with actual migration code)
+        $io->info('Starting database migration...');
+
+        //Disable all event listeners on target EM to avoid unwanted side effects
+        $eventManager = $this->targetEM->getEventManager();
+        foreach ($eventManager->getAllListeners() as $event => $listeners) {
+            foreach ($listeners as $listener) {
+                $eventManager->removeEventListener($event, $listener);
+            }
+        }
+
+        $io->info('Clear target database...');
+        $this->importHelper->purgeDatabaseForImport($this->targetEM, ['internal', 'migration_versions']);
+
+        $metadata = $this->targetEM->getMetadataFactory()->getAllMetadata();
+
+        $io->info('Modifying entity metadata for migration...');
+        //First we modify each entity metadata to have an persist cascade on all relations
+        foreach ($metadata as $metadatum) {
+            $entityClass = $metadatum->getName();
+            $io->writeln('Modifying cascade and ID settings for entity: ' . $entityClass, OutputInterface::VERBOSITY_VERBOSE);
+
+            foreach ($metadatum->getAssociationNames() as $fieldName) {
+                $mapping = $metadatum->getAssociationMapping($fieldName);
+                $mapping->cascade = array_unique(array_merge($mapping->cascade, ['persist']));
+                $mapping->fetch = ClassMetadata::FETCH_EAGER; //Avoid lazy loading issues during migration
+
+                $metadatum->setIdGeneratorType(ClassMetadata::GENERATOR_TYPE_NONE);
+                $metadatum->setIdGenerator(new AssignedGenerator());
+            }
+        }
+
+
+        $io->progressStart(count($metadata));
+
+        //First we migrate users to avoid foreign key constraint issues
+        $io->info('Migrating users first to avoid foreign key constraint issues...');
+        $this->fixUsers($sourceEM);
+
+        //Afterward we migrate all entities
+        foreach ($metadata as $metadatum) {
+            //skip all superclasses
+            if ($metadatum->isMappedSuperclass) {
+                continue;
+            }
+
+            $entityClass = $metadatum->getName();
+
+            $io->note('Migrating entity: ' . $entityClass);
+
+            $repo = $sourceEM->getRepository($entityClass);
+            $items = $repo->findAll();
+            foreach ($items as $index => $item) {
+                $this->targetEM->persist($item);
+            }
+            $this->targetEM->flush();
+        }
+
+        $io->progressFinish();
+
+
+        //Fix sequences / auto increment values on target database
+        $io->info('Fixing sequences / auto increment values on target database...');
+        $this->fixAutoIncrements($this->targetEM);
+
+        $io->success('Database migration completed successfully.');
+
+        if ($io->isVerbose()) {
+            $io->info('Process took peak memory: ' . round(memory_get_peak_usage(true) / 1024 / 1024, 2) . ' MB');
+        }
+
+        return Command::SUCCESS;
+    }
+
+    /**
+     * Construct a source EntityManager based on the given connection URL
+     * @param  string  $url
+     * @return EntityManagerInterface
+     */
+    private function getSourceEm(string $url): EntityManagerInterface
+    {
+        //Replace any %kernel.project_dir% placeholders
+        $url = str_replace('%kernel.project_dir%', $this->kernelProjectDir, $url);
+
+        $connectionFactory = new ConnectionFactory();
+        $connection = $connectionFactory->createConnection(['url' => $url]);
+        return new EntityManager($connection, $this->targetEM->getConfiguration());
+    }
+
+    private function ensureVersionUpToDate(EntityManagerInterface $sourceEM): void
+    {
+        //Ensure that target database is up to date
+        $migrationStatusCalculator = $this->dependencyFactory->getMigrationStatusCalculator();
+        $newMigrations = $migrationStatusCalculator->getNewMigrations();
+        if (count($newMigrations->getItems()) > 0) {
+            throw new \RuntimeException("Target database is not up to date. Please run all migrations (with doctrine:migrations:migrate) before starting the migration process.");
+        }
+
+        $sourceDependencyLoader = DependencyFactory::fromEntityManager(new ExistingConfiguration($this->dependencyFactory->getConfiguration()), new ExistingEntityManager($sourceEM));
+        $sourceMigrationStatusCalculator = $sourceDependencyLoader->getMigrationStatusCalculator();
+        $sourceNewMigrations = $sourceMigrationStatusCalculator->getNewMigrations();
+        if (count($sourceNewMigrations->getItems()) > 0) {
+            throw new \RuntimeException("Source database is not up to date. Please run all migrations (with doctrine:migrations:migrate) on the source database before starting the migration process.");
+        }
+    }
+
+    private function fixUsers(EntityManagerInterface $sourceEM): void
+    {
+        //To avoid a problem with (Column 'settings' cannot be null) in MySQL we need to migrate the user entities first
+        //and fix the settings and backupCodes fields
+
+        $reflClass = new \ReflectionClass(User::class);
+        foreach ($sourceEM->getRepository(User::class)->findAll() as $user) {
+            foreach (['settings', 'backupCodes'] as $field) {
+                $property = $reflClass->getProperty($field);
+                if (!$property->isInitialized($user) || $property->getValue($user) === null) {
+                    $property->setValue($user, []);
+                }
+            }
+            $this->targetEM->persist($user);
+        }
+    }
+
+    private function fixAutoIncrements(EntityManagerInterface $em): void
+    {
+        $connection = $em->getConnection();
+        $platform = $connection->getDatabasePlatform();
+
+        if ($platform instanceof PostgreSQLPlatform) {
+            $connection->executeStatement(
+            //From: https://wiki.postgresql.org/wiki/Fixing_Sequences
+                <<<SQL
+                SELECT 'SELECT SETVAL(' ||
+                    quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
+                    ', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
+                    quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
+                FROM pg_class AS S,
+                     pg_depend AS D,
+                     pg_class AS T,
+                     pg_attribute AS C,
+                     pg_tables AS PGT
+                WHERE S.relkind = 'S'
+                    AND S.oid = D.objid
+                    AND D.refobjid = T.oid
+                    AND D.refobjid = C.attrelid
+                    AND D.refobjsubid = C.attnum
+                    AND T.relname = PGT.tablename
+                ORDER BY S.relname;
+                SQL);
+        }
+    }
+}

src/Controller/AdminPages/BaseAdminController.php

@@ -366,6 +366,14 @@ abstract class BaseAdminController extends AbstractController
                 }
             }
 
+            //Count how many actual new entities were created (id is null until persisted)
+            $created_count = 0;
+            foreach ($results as $result) {
+                if (null === $result->getID()) {
+                    $created_count++;
+                }
+            }
+
             //Persist valid entities to DB
             foreach ($results as $result) {
                 $em->persist($result);
@@ -373,8 +381,14 @@ abstract class BaseAdminController extends AbstractController
             $em->flush();
 
             if (count($results) > 0) {
-                $this->addFlash('success', t('entity.mass_creation_flash', ['%COUNT%' => count($results)]));
+                $this->addFlash('success', t('entity.mass_creation_flash', ['%COUNT%' => $created_count]));
             }
+
+            if (count($errors)) {
+                //Recreate mass creation form, so we get the updated parent list and empty lines
+                $mass_creation_form = $this->createForm(MassCreationForm::class, ['entity_class' => $this->entity_class]);
+            }
+
         }
 
         return $this->render($this->twig_template, [

src/Controller/InfoProviderController.php

@@ -40,10 +40,13 @@ use Symfony\Bridge\Doctrine\Attribute\MapEntity;
 use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
 use Symfony\Component\Form\Extension\Core\Type\SubmitType;
 use Symfony\Component\HttpClient\Exception\ClientException;
+use Symfony\Component\HttpClient\Exception\TransportException;
 use Symfony\Component\HttpFoundation\Request;
 use Symfony\Component\HttpFoundation\Response;
 use Symfony\Component\Routing\Attribute\Route;
 
+use Symfony\Contracts\HttpClient\Exception\ExceptionInterface;
+
 use function Symfony\Component\Translation\t;
 
 #[Route('/tools/info_providers')]
@@ -178,6 +181,13 @@ class InfoProviderController extends  AbstractController
                 $exceptionLogger->error('Error during info provider search: ' . $e->getMessage(), ['exception' => $e]);
             } catch (OAuthReconnectRequiredException $e) {
                 $this->addFlash('error', t('info_providers.search.error.oauth_reconnect', ['%provider%' => $e->getProviderName()]));
+            } catch (TransportException $e) {
+                $this->addFlash('error', t('info_providers.search.error.transport_exception'));
+                $exceptionLogger->error('Transport error during info provider search: ' . $e->getMessage(), ['exception' => $e]);
+            } catch (\RuntimeException $e) {
+                $this->addFlash('error', t('info_providers.search.error.general_exception', ['%type%' => (new \ReflectionClass($e))->getShortName()]));
+                //Log the exception
+                $exceptionLogger->error('Error during info provider search: ' . $e->getMessage(), ['exception' => $e]);
             }
 
 

src/Controller/PartListsController.php

@@ -319,6 +319,7 @@ class PartListsController extends AbstractController
 
         //As an unchecked checkbox is not set in the query, the default value for all bools have to be false (which is the default argument value)!
         $filter->setName($request->query->getBoolean('name'));
+        $filter->setDbId($request->query->getBoolean('dbid'));
         $filter->setCategory($request->query->getBoolean('category'));
         $filter->setDescription($request->query->getBoolean('description'));
         $filter->setMpn($request->query->getBoolean('mpn'));

src/DataTables/Filters/PartSearchFilter.php

@@ -23,6 +23,7 @@ declare(strict_types=1);
 namespace App\DataTables\Filters;
 use App\DataTables\Filters\Constraints\AbstractConstraint;
 use Doctrine\ORM\QueryBuilder;
+use Doctrine\DBAL\ParameterType;
 
 class PartSearchFilter implements FilterInterface
 {
@@ -33,6 +34,9 @@ class PartSearchFilter implements FilterInterface
     /** @var bool Use name field for searching */
     protected bool $name = true;
 
+    /** @var bool Use id field for searching */
+    protected bool $dbId = false;
+
     /** @var bool Use category name for searching */
     protected bool $category = true;
 
@@ -120,33 +124,51 @@ class PartSearchFilter implements FilterInterface
     public function apply(QueryBuilder $queryBuilder): void
     {
         $fields_to_search = $this->getFieldsToSearch();
+        $is_numeric = preg_match('/^\d+$/', $this->keyword) === 1;
+
+        // Add exact ID match only when the keyword is numeric
+        $search_dbId = $is_numeric && (bool)$this->dbId;
 
         //If we have nothing to search for, do nothing
-        if ($fields_to_search === [] || $this->keyword === '') {
+        if (($fields_to_search === [] && !$search_dbId) || $this->keyword === '') {
             return;
         }
 
-        //Convert the fields to search to a list of expressions
-        $expressions = array_map(function (string $field): string {
+        $expressions = [];
+        
+        if($fields_to_search !== []) {
+            //Convert the fields to search to a list of expressions
+            $expressions = array_map(function (string $field): string {
+                if ($this->regex) {
+                    return sprintf("REGEXP(%s, :search_query) = TRUE", $field);
+                }
+
+                return sprintf("ILIKE(%s, :search_query) = TRUE", $field);
+            }, $fields_to_search);
+            
+            //For regex, we pass the query as is, for like we add % to the start and end as wildcards
             if ($this->regex) {
-                return sprintf("REGEXP(%s, :search_query) = TRUE", $field);
+                $queryBuilder->setParameter('search_query', $this->keyword);
+            } else {
+                //Escape % and _ characters in the keyword
+                $this->keyword = str_replace(['%', '_'], ['\%', '\_'], $this->keyword);
+                $queryBuilder->setParameter('search_query', '%' . $this->keyword . '%');
             }
+        }
 
-            return sprintf("ILIKE(%s, :search_query) = TRUE", $field);
-        }, $fields_to_search);
+        //Use equal expression to just search for exact numeric matches
+        if ($search_dbId) {
+            $expressions[] = $queryBuilder->expr()->eq('part.id', ':id_exact');
+            $queryBuilder->setParameter('id_exact', (int) $this->keyword,
+                \Doctrine\DBAL\ParameterType::INTEGER);
+        }
 
-        //Add Or concatenation of the expressions to our query
-        $queryBuilder->andWhere(
-            $queryBuilder->expr()->orX(...$expressions)
-        );
-
-        //For regex, we pass the query as is, for like we add % to the start and end as wildcards
-        if ($this->regex) {
-            $queryBuilder->setParameter('search_query', $this->keyword);
-        } else {
-            //Escape % and _ characters in the keyword
-            $this->keyword = str_replace(['%', '_'], ['\%', '\_'], $this->keyword);
-            $queryBuilder->setParameter('search_query', '%' . $this->keyword . '%');
+        //Guard condition
+        if (!empty($expressions)) {
+            //Add Or concatenation of the expressions to our query
+            $queryBuilder->andWhere(
+                $queryBuilder->expr()->orX(...$expressions)
+            );
         }
     }
 
@@ -183,6 +205,17 @@ class PartSearchFilter implements FilterInterface
         return $this;
     }
 
+    public function isDbId(): bool
+    {
+        return $this->dbId;
+    }
+
+    public function setDbId(bool $dbId): PartSearchFilter
+    {
+        $this->dbId = $dbId;
+        return $this;
+    }
+
     public function isCategory(): bool
     {
         return $this->category;

src/DataTables/LogDataTable.php

@@ -208,6 +208,7 @@ class LogDataTable implements DataTableTypeInterface
 
         $dataTable->add('extra', LogEntryExtraColumn::class, [
             'label' => 'log.extra',
+            'orderable' => false, //Sorting the JSON column makes no sense: MySQL/Sqlite does it via the string representation, PostgreSQL errors out
         ]);
 
         $dataTable->add('timeTravel', IconLinkColumn::class, [

src/DataTables/ProjectBomEntriesDataTable.php

@@ -29,6 +29,7 @@ use App\DataTables\Helpers\PartDataTableHelper;
 use App\Entity\Attachments\Attachment;
 use App\Entity\Parts\Part;
 use App\Entity\ProjectSystem\ProjectBOMEntry;
+use App\Services\ElementTypeNameGenerator;
 use App\Services\EntityURLGenerator;
 use App\Services\Formatters\AmountFormatter;
 use Doctrine\ORM\QueryBuilder;
@@ -41,7 +42,8 @@ use Symfony\Contracts\Translation\TranslatorInterface;
 
 class ProjectBomEntriesDataTable implements DataTableTypeInterface
 {
-    public function __construct(protected TranslatorInterface $translator, protected PartDataTableHelper $partDataTableHelper, protected EntityURLGenerator $entityURLGenerator, protected AmountFormatter $amountFormatter)
+    public function __construct(protected TranslatorInterface $translator, protected PartDataTableHelper $partDataTableHelper,
+        protected EntityURLGenerator $entityURLGenerator, protected AmountFormatter $amountFormatter)
     {
     }
 
@@ -79,7 +81,14 @@ class ProjectBomEntriesDataTable implements DataTableTypeInterface
                     return htmlspecialchars($this->amountFormatter->format($context->getQuantity(), $context->getPart()->getPartUnit()));
                 },
             ])
-
+			->add('partId', TextColumn::class, [
+				'label' => $this->translator->trans('project.bom.part_id'),
+				'visible' => true,
+				'orderField' => 'part.id',
+				'render' => function ($value, ProjectBOMEntry $context) {
+					return $context->getPart() instanceof Part ? (string) $context->getPart()->getId() : '';
+				},
+			])
             ->add('name', TextColumn::class, [
                 'label' => $this->translator->trans('part.table.name'),
                 'orderField' => 'NATSORT(part.name)',

src/Doctrine/Helpers/FieldHelper.php

@@ -104,7 +104,7 @@ final class FieldHelper
     {
         $db_platform = $qb->getEntityManager()->getConnection()->getDatabasePlatform();
 
-        $key = 'field2_' . md5($field_expr);
+        $key = 'field2_' . hash('xxh3', $field_expr);
 
         //If we are on MySQL, we can just use the FIELD function
         if ($db_platform instanceof AbstractMySQLPlatform) {
@@ -121,4 +121,4 @@ final class FieldHelper
 
         return $qb;
     }
-}
+}

src/Entity/Attachments/Attachment.php

@@ -169,7 +169,7 @@ abstract class Attachment extends AbstractNamedDBElement
     #[ORM\Column(type: Types::STRING, length: 2048,  nullable: true)]
     #[Groups(['attachment:read'])]
     #[ApiProperty(example: 'http://example.com/image.jpg')]
-    #[Assert\Length(2048)]
+    #[Assert\Length(max: 2048)]
     protected ?string $external_path = null;
 
     /**

src/Entity/EDA/EDACategoryInfo.php

@@ -58,7 +58,7 @@ class EDACategoryInfo
     /** @var bool|null If this is set to true, then this part will be excluded in the simulation */
     #[Column(type: Types::BOOLEAN, nullable: true)]
     #[Groups(['full', 'category:read', 'category:write', 'import'])]
-    private ?bool $exclude_from_sim = true;
+    private ?bool $exclude_from_sim = null;
 
     /** @var string|null The KiCAD schematic symbol, which should be used (the path to the library) */
     #[Column(type: Types::STRING, nullable: true)]

src/EventListener/RegisterSynonymsAsTranslationParametersListener.php

@@ -50,9 +50,9 @@ readonly class RegisterSynonymsAsTranslationParametersListener
         $this->translator = $translator;
     }
 
-    public function getSynonymPlaceholders(): array
+    public function getSynonymPlaceholders(string $locale): array
     {
-        return $this->cache->get('partdb_synonym_placeholders', function (ItemInterface $item) {
+        return $this->cache->get('partdb_synonym_placeholders' . '_' . $locale, function (ItemInterface $item) use ($locale) {
             $item->tag('synonyms');
 
 
@@ -62,12 +62,12 @@ readonly class RegisterSynonymsAsTranslationParametersListener
             foreach (ElementTypes::cases() as $elementType) {
                 //Versions with capitalized first letter
                 $capitalized = ucfirst($elementType->value); //We have only ASCII element type values, so this is sufficient
-                $placeholders['[' . $capitalized . ']'] = $this->typeNameGenerator->typeLabel($elementType);
-                $placeholders['[[' . $capitalized . ']]'] = $this->typeNameGenerator->typeLabelPlural($elementType);
+                $placeholders['[' . $capitalized . ']'] = $this->typeNameGenerator->typeLabel($elementType, $locale);
+                $placeholders['[[' . $capitalized . ']]'] = $this->typeNameGenerator->typeLabelPlural($elementType, $locale);
 
                 //And we have lowercase versions for both
-                $placeholders['[' . $elementType->value . ']'] = mb_strtolower($this->typeNameGenerator->typeLabel($elementType));
-                $placeholders['[[' . $elementType->value . ']]'] = mb_strtolower($this->typeNameGenerator->typeLabelPlural($elementType));
+                $placeholders['[' . $elementType->value . ']'] = mb_strtolower($this->typeNameGenerator->typeLabel($elementType, $locale));
+                $placeholders['[[' . $elementType->value . ']]'] = mb_strtolower($this->typeNameGenerator->typeLabelPlural($elementType, $locale));
             }
 
             return $placeholders;
@@ -82,7 +82,7 @@ readonly class RegisterSynonymsAsTranslationParametersListener
         }
 
         //Register all placeholders for synonyms
-        $placeholders = $this->getSynonymPlaceholders();
+        $placeholders = $this->getSynonymPlaceholders($event->getRequest()->getLocale());
         foreach ($placeholders as $key => $value) {
             $this->translator->addGlobalParameter($key, $value);
         }

src/Repository/DBElementRepository.php

@@ -109,6 +109,13 @@ class DBElementRepository extends EntityRepository
             return [];
         }
 
+        //Ensure that all IDs are integers and none is null
+        foreach ($ids as $id) {
+            if (!is_int($id)) {
+                throw new \InvalidArgumentException('Non-integer ID given to findByIDInMatchingOrder: ' . var_export($id, true));
+            }
+        }
+
         $cache_key = implode(',', $ids);
 
         //Check if the result is already cached

src/Repository/StructuralDBElementRepository.php

@@ -243,6 +243,14 @@ class StructuralDBElementRepository extends AttachmentContainingDBElementReposit
             return $result[0];
         }
 
+        //If the name contains category delimiters like ->, try to find the element by its full path
+        if (str_contains($name, '->')) {
+            $tmp = $this->getEntityByPath($name, '->');
+            if (count($tmp) > 0) {
+                return $tmp[count($tmp) - 1];
+            }
+        }
+
         //If we find nothing, return null
         return null;
     }

src/Services/Attachments/FileTypeFilterTools.php

@@ -139,7 +139,7 @@ class FileTypeFilterTools
     {
         $filter = trim($filter);
 
-        return $this->cache->get('filter_exts_'.md5($filter), function (ItemInterface $item) use ($filter) {
+        return $this->cache->get('filter_exts_'.hash('xxh3', $filter), function (ItemInterface $item) use ($filter) {
             $elements = explode(',', $filter);
             $extensions = [];
 

src/Services/Cache/UserCacheKeyGenerator.php

@@ -57,7 +57,7 @@ class UserCacheKeyGenerator
         //If the user is null, then treat it as anonymous user.
         //When the anonymous user is passed as user then use this path too.
         if (!($user instanceof User) || User::ID_ANONYMOUS === $user->getID()) {
-            return 'user$_'.User::ID_ANONYMOUS;
+            return 'user$_'.User::ID_ANONYMOUS . '_'.$locale;
         }
 
         //Use the unique user id and the locale to generate the key

src/Services/EDA/KiCadHelper.php

@@ -189,7 +189,7 @@ class KiCadHelper
             "symbolIdStr" => $part->getEdaInfo()->getKicadSymbol() ?? $part->getCategory()?->getEdaInfo()->getKicadSymbol() ?? "",
             "exclude_from_bom" => $this->boolToKicadBool($part->getEdaInfo()->getExcludeFromBom() ?? $part->getCategory()?->getEdaInfo()->getExcludeFromBom() ?? false),
             "exclude_from_board" => $this->boolToKicadBool($part->getEdaInfo()->getExcludeFromBoard() ?? $part->getCategory()?->getEdaInfo()->getExcludeFromBoard() ?? false),
-            "exclude_from_sim" => $this->boolToKicadBool($part->getEdaInfo()->getExcludeFromSim() ?? $part->getCategory()?->getEdaInfo()->getExcludeFromSim() ?? true),
+            "exclude_from_sim" => $this->boolToKicadBool($part->getEdaInfo()->getExcludeFromSim() ?? $part->getCategory()?->getEdaInfo()->getExcludeFromSim() ?? false),
             "fields" => []
         ];
 

src/Services/ImportExportSystem/BOMImporter.php

@@ -274,6 +274,13 @@ class BOMImporter
         $entries_by_key = []; // Track entries by name+part combination
         $mapped_entries = []; // Collect all mapped entries for validation
 
+        // Fetch suppliers once for efficiency
+        $suppliers = $this->entityManager->getRepository(\App\Entity\Parts\Supplier::class)->findAll();
+        $supplierSPNKeys = [];
+        foreach ($suppliers as $supplier) {
+            $supplierSPNKeys[] = $supplier->getName() . ' SPN';
+        }
+
         foreach ($csv->getRecords() as $offset => $entry) {
             // Apply field mapping to translate column names
             $mapped_entry = $this->applyFieldMapping($entry, $field_mapping, $field_priorities);
@@ -400,9 +407,14 @@ class BOMImporter
             if (isset($mapped_entry['Manufacturer'])) {
                 $comment_parts[] = 'Manf: ' . $mapped_entry['Manufacturer'];
             }
-            if (isset($mapped_entry['LCSC'])) {
-                $comment_parts[] = 'LCSC: ' . $mapped_entry['LCSC'];
+
+            // Add supplier part numbers dynamically
+            foreach ($supplierSPNKeys as $spnKey) {
+                if (isset($mapped_entry[$spnKey]) && !empty($mapped_entry[$spnKey])) {
+                    $comment_parts[] = $spnKey . ': ' . $mapped_entry[$spnKey];
+                }
             }
+
             if (isset($mapped_entry['Supplier and ref'])) {
                 $comment_parts[] = $mapped_entry['Supplier and ref'];
             }

src/Services/ImportExportSystem/EntityImporter.php

@@ -167,7 +167,7 @@ class EntityImporter
         }
 
         //Only return objects once
-        return array_values(array_unique($valid_entities));
+        return array_values(array_unique($valid_entities, SORT_REGULAR));
     }
 
     /**

src/Services/ImportExportSystem/PartKeeprImporter/PKDatastructureImporter.php

@@ -152,7 +152,7 @@ class PKDatastructureImporter
     public function importPartCustomStates(array $data): int
     {
         if (!isset($data['partcustomstate'])) {
-            throw new \RuntimeException('$data must contain a "partcustomstate" key!');
+            return 0; //Not all PartKeepr installations have custom states
         }
 
         $partCustomStateData = $data['partcustomstate'];

src/Services/ImportExportSystem/PartKeeprImporter/PKImportHelper.php

@@ -39,10 +39,10 @@ class PKImportHelper
      * Existing users and groups are not purged.
      * This is needed to avoid ID collisions.
      */
-    public function purgeDatabaseForImport(): void
+    public function purgeDatabaseForImport(?EntityManagerInterface $entityManager = null, array $excluded_tables = ['users', 'groups', 'u2f_keys', 'internal', 'migration_versions']): void
     {
         //We use the ResetAutoIncrementORMPurger to reset the auto increment values of the tables. Also it normalizes table names before checking for exclusion.
-        $purger = new ResetAutoIncrementORMPurger($this->em, ['users', 'groups', 'u2f_keys', 'internal', 'migration_versions']);
+        $purger = new ResetAutoIncrementORMPurger($entityManager ?? $this->em, $excluded_tables);
         $purger->purge();
     }
 

src/Services/ImportExportSystem/PartKeeprImporter/PKImportHelperTrait.php

@@ -150,6 +150,11 @@ trait PKImportHelperTrait
 
             $target->addAttachment($attachment);
             $this->em->persist($attachment);
+
+            //If the attachment is an image, and the target has no master picture yet, set it
+            if ($attachment->isPicture() && $target->getMasterPictureAttachment() === null) {
+                $target->setMasterPictureAttachment($attachment);
+            }
         }
 
         $this->em->flush();

src/Services/ImportExportSystem/PartKeeprImporter/PKPartImporter.php

@@ -91,7 +91,10 @@ class PKPartImporter
                     $this->setAssociationField($entity, 'partUnit', MeasurementUnit::class, $part['partUnit_id']);
                 }
 
-                $this->setAssociationField($entity, 'partCustomState', MeasurementUnit::class, $part['partCustomState_id']);
+                if (isset($part['partCustomState_id'])) {
+                    $this->setAssociationField($entity, 'partCustomState', MeasurementUnit::class,
+                        $part['partCustomState_id']);
+                }
 
                 //Create a part lot to store the stock level and location
                 $lot = new PartLot();

src/Services/InfoProviderSystem/Providers/BuerklinProvider.php

@@ -0,0 +1,639 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2023 Jan Böhmer (https://github.com/jbtronics)
+ *  Copyright (C) 2025 Marc Kreidler (https://github.com/mkne)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Services\InfoProviderSystem\Providers;
+
+use App\Services\InfoProviderSystem\DTOs\FileDTO;
+use App\Services\InfoProviderSystem\DTOs\ParameterDTO;
+use App\Services\InfoProviderSystem\DTOs\PartDetailDTO;
+use App\Services\InfoProviderSystem\DTOs\PriceDTO;
+use App\Services\InfoProviderSystem\DTOs\PurchaseInfoDTO;
+use App\Services\InfoProviderSystem\DTOs\SearchResultDTO;
+use App\Settings\InfoProviderSystem\BuerklinSettings;
+use Psr\Cache\CacheItemPoolInterface;
+use Symfony\Contracts\HttpClient\HttpClientInterface;
+
+class BuerklinProvider implements BatchInfoProviderInterface
+{
+
+    private const ENDPOINT_URL = 'https://www.buerklin.com/buerklinws/v2/buerklin';
+
+    public const DISTRIBUTOR_NAME = 'Buerklin';
+
+    private const CACHE_TTL = 600;
+    /**
+     * Local in-request cache to avoid hitting the PSR cache repeatedly for the same product.
+     * @var array<string, array>
+     */
+    private array $productCache = [];
+
+    public function __construct(
+        private readonly HttpClientInterface $client,
+        private readonly CacheItemPoolInterface $partInfoCache,
+        private readonly BuerklinSettings $settings,
+    ) {
+
+    }
+
+    /**
+     * Gets the latest OAuth token for the Buerklin API, or creates a new one if none is available
+     * TODO: Rework this to use the OAuth token manager system in the database...
+     * @return string
+     */
+    private function getToken(): string
+    {
+        // Cache token to avoid hammering the auth server on every request
+        $cacheKey = 'buerklin.oauth.token';
+        $item = $this->partInfoCache->getItem($cacheKey);
+
+        if ($item->isHit()) {
+            $token = $item->get();
+            if (is_string($token) && $token !== '') {
+                return $token;
+            }
+        }
+
+        // Buerklin OAuth2 password grant (ROPC)
+        $resp = $this->client->request('POST', 'https://www.buerklin.com/authorizationserver/oauth/token/', [
+            'headers' => [
+                'Accept' => 'application/json',
+                'Content-Type' => 'application/x-www-form-urlencoded',
+            ],
+            'body' => [
+                'grant_type' => 'password',
+                'client_id' => $this->settings->clientId,
+                'client_secret' => $this->settings->secret,
+                'username' => $this->settings->username,
+                'password' => $this->settings->password,
+            ],
+        ]);
+
+        $data = $resp->toArray(false);
+
+        if (!isset($data['access_token'])) {
+            throw new \RuntimeException(
+                'Invalid token response from Buerklin: HTTP ' . $resp->getStatusCode() . ' body=' . $resp->getContent(false)
+            );
+        }
+
+        $token = (string) $data['access_token'];
+
+        // Cache for (expires_in - 30s) if available
+        $ttl = 300;
+        if (isset($data['expires_in']) && is_numeric($data['expires_in'])) {
+            $ttl = max(60, (int) $data['expires_in'] - 30);
+        }
+
+        $item->set($token);
+        $item->expiresAfter($ttl);
+        $this->partInfoCache->save($item);
+
+        return $token;
+    }
+
+    private function getDefaultQueryParams(): array
+    {
+        return [
+            'curr' => $this->settings->currency ?: 'EUR',
+            'language' => $this->settings->language ?: 'en',
+        ];
+    }
+
+    private function getProduct(string $code): array
+    {
+        $code = strtoupper(trim($code));
+        if ($code === '') {
+            throw new \InvalidArgumentException('Product code must not be empty.');
+        }
+
+        $cacheKey = sprintf(
+            'buerklin.product.%s',
+            md5($code . '|' . $this->settings->language . '|' . $this->settings->currency)
+        );
+
+        if (isset($this->productCache[$cacheKey])) {
+            return $this->productCache[$cacheKey];
+        }
+
+        $item = $this->partInfoCache->getItem($cacheKey);
+        if ($item->isHit() && is_array($cached = $item->get())) {
+            return $this->productCache[$cacheKey] = $cached;
+        }
+
+        $product = $this->makeAPICall('/products/' . rawurlencode($code) . '/');
+
+        $item->set($product);
+        $item->expiresAfter(self::CACHE_TTL);
+        $this->partInfoCache->save($item);
+
+        return $this->productCache[$cacheKey] = $product;
+    }
+
+    private function makeAPICall(string $endpoint, array $queryParams = []): array
+    {
+        try {
+            $response = $this->client->request('GET', self::ENDPOINT_URL . $endpoint, [
+                'auth_bearer' => $this->getToken(),
+                'headers' => ['Accept' => 'application/json'],
+                'query' => array_merge($this->getDefaultQueryParams(), $queryParams),
+            ]);
+
+            return $response->toArray();
+        } catch (\Exception $e) {
+            throw new \RuntimeException("Buerklin API request failed: " .
+                "Endpoint: " . $endpoint .
+                "Token: [redacted] " .
+                "QueryParams: " . json_encode($queryParams, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) . " " .
+                "Exception message: " . $e->getMessage());
+        }
+    }
+
+
+    public function getProviderInfo(): array
+    {
+        return [
+            'name' => 'Buerklin',
+            'description' => 'This provider uses the Buerklin API to search for parts.',
+            'url' => 'https://www.buerklin.com/',
+            'disabled_help' => 'Configure the API Client ID, Secret, Username and Password provided by Buerklin in the provider settings to enable.',
+            'settings_class' => BuerklinSettings::class
+        ];
+    }
+
+    public function getProviderKey(): string
+    {
+        return 'buerklin';
+    }
+
+    // This provider is considered active if settings are present
+    public function isActive(): bool
+    {
+        // The client credentials and user credentials must be set
+        return $this->settings->clientId !== null && $this->settings->clientId !== ''
+            && $this->settings->secret !== null && $this->settings->secret !== ''
+            && $this->settings->username !== null && $this->settings->username !== ''
+            && $this->settings->password !== null && $this->settings->password !== '';
+    }
+
+    /**
+     * Sanitizes a field by removing any HTML tags and other unwanted characters
+     * @param  string|null  $field
+     * @return string|null
+     */
+    private function sanitizeField(?string $field): ?string
+    {
+        if ($field === null) {
+            return null;
+        }
+
+        return strip_tags($field);
+    }
+
+    /**
+     * Takes a deserialized JSON object of the product and returns a PartDetailDTO
+     * @param  array  $product
+     * @return PartDetailDTO
+     */
+    private function getPartDetail(array $product): PartDetailDTO
+    {
+        // If this is a search-result object, it may not contain prices/features/images -> reload full details.
+        if ((!isset($product['price']) && !isset($product['volumePrices'])) && isset($product['code'])) {
+            try {
+                $product = $this->getProduct((string) $product['code']);
+            } catch (\Throwable $e) {
+                // If reload fails, keep the partial product data and continue.
+            }
+        }
+
+        // Extract images from API response
+        $productImages = $this->getProductImages($product['images'] ?? null);
+
+        // Set preview image
+        $preview = $productImages[0]->url ?? null;
+
+        // Extract features (parameters) from classifications[0].features of Buerklin JSON response
+        $features = $product['classifications'][0]['features'] ?? [];
+
+        // Feature parameters (from classifications->features)
+        $featureParams = $this->attributesToParameters($features, ''); // leave group empty for normal parameters
+
+        // Compliance parameters (from top-level fields like RoHS/SVHC/…)
+        $complianceParams = $this->complianceToParameters($product, 'Compliance');
+
+        // Merge all parameters
+        $allParams = array_merge($featureParams, $complianceParams);
+
+        // Assign footprint: "Design" (en) / "Bauform" (de) / "Enclosure" (en) / "Gehäuse" (de)
+        $footprint = null;
+        if (is_array($features)) {
+            foreach ($features as $feature) {
+                $name = $feature['name'] ?? null;
+                if ($name === 'Design' || $name === 'Bauform' || $name === 'Enclosure' || $name === 'Gehäuse') {
+                    $footprint = $feature['featureValues'][0]['value'] ?? null;
+                    break;
+                }
+            }
+        }
+
+        // Prices: prefer volumePrices, fallback to single price
+        $code = (string) ($product['orderNumber'] ?? $product['code'] ?? '');
+        $prices = $product['volumePrices'] ?? null;
+
+        if (!is_array($prices) || count($prices) === 0) {
+            $pVal = $product['price']['value'] ?? null;
+            $pCur = $product['price']['currencyIso'] ?? ($this->settings->currency ?: 'EUR');
+
+            if (is_numeric($pVal)) {
+                $prices = [
+                    [
+                        'minQuantity' => 1,
+                        'value' => (float) $pVal,
+                        'currencyIso' => (string) $pCur,
+                    ]
+                ];
+            } else {
+                $prices = [];
+            }
+        }
+
+        return new PartDetailDTO(
+            provider_key: $this->getProviderKey(),
+            provider_id: (string) ($product['code'] ?? $code),
+
+            name: (string) ($product['manufacturerProductId'] ?? $code),
+            description: $this->sanitizeField($product['description'] ?? null),
+
+            category: $this->sanitizeField($product['classifications'][0]['name'] ?? ($product['categories'][0]['name'] ?? null)),
+            manufacturer: $this->sanitizeField($product['manufacturer'] ?? null),
+            mpn: $this->sanitizeField($product['manufacturerProductId'] ?? null),
+
+            preview_image_url: $preview,
+            manufacturing_status: null,
+
+            provider_url: $this->getProductShortURL((string) ($product['code'] ?? $code)),
+            footprint: $footprint,
+
+            datasheets: null, // not found in JSON response, the Buerklin website however has links to datasheets
+            images: $productImages,
+
+            parameters: $allParams,
+
+            vendor_infos: $this->pricesToVendorInfo(
+                sku: $code,
+                url: $this->getProductShortURL($code),
+                prices: $prices
+            ),
+
+            mass: $product['weight'] ?? null,
+        );
+    }
+
+    /**
+     * Converts the price array to a VendorInfoDTO array to be used in the PartDetailDTO
+     * @param  string $sku
+     * @param  string $url
+     * @param  array  $prices
+     * @return array
+     */
+    private function pricesToVendorInfo(string $sku, string $url, array $prices): array
+    {
+        $priceDTOs = array_map(function ($price) {
+            $val = $price['value'] ?? null;
+            $valStr = is_numeric($val)
+                ? number_format((float) $val, 6, '.', '') // 6 decimal places, trailing zeros are fine
+                : (string) $val;
+
+            // Optional: softly trim unnecessary trailing zeros (e.g. 75.550000 -> 75.55)
+            $valStr = rtrim(rtrim($valStr, '0'), '.');
+
+            return new PriceDTO(
+                minimum_discount_amount: (float) ($price['minQuantity'] ?? 1),
+                price: $valStr,
+                currency_iso_code: (string) ($price['currencyIso'] ?? $this->settings->currency ?? 'EUR'),
+                includes_tax: false
+            );
+        }, $prices);
+
+        return [
+            new PurchaseInfoDTO(
+                distributor_name: self::DISTRIBUTOR_NAME,
+                order_number: $sku,
+                prices: $priceDTOs,
+                product_url: $url,
+            )
+        ];
+    }
+
+
+    /**
+     * Returns a valid Buerklin product short URL from product code
+     * @param  string  $product_code
+     * @return string
+     */
+    private function getProductShortURL(string $product_code): string
+    {
+        return 'https://www.buerklin.com/' . $this->settings->language . '/p/' . $product_code . '/';
+    }
+
+    /**
+     * Returns a deduplicated list of product images as FileDTOs.
+     *
+     * - takes only real image arrays (with 'url' field)
+     * - makes relative URLs absolute
+     * - deduplicates using URL
+     * - prefers 'zoom' format, then 'product' format, then all others
+     *
+     * @param  array|null $images
+     * @return \App\Services\InfoProviderSystem\DTOs\FileDTO[]
+     */
+    private function getProductImages(?array $images): array
+    {
+        if (!is_array($images)) {
+            return [];
+        }
+
+        // 1) Only real image entries with URL
+        $imgs = array_values(array_filter($images, fn($i) => is_array($i) && !empty($i['url'])));
+
+        // 2) Prefer zoom images
+        $zoom = array_values(array_filter($imgs, fn($i) => ($i['format'] ?? null) === 'zoom'));
+        $chosen = count($zoom) > 0
+            ? $zoom
+            : array_values(array_filter($imgs, fn($i) => ($i['format'] ?? null) === 'product'));
+
+        // 3) If still none, take all
+        if (count($chosen) === 0) {
+            $chosen = $imgs;
+        }
+
+        // 4) Deduplicate by URL (after making absolute)
+        $byUrl = [];
+        foreach ($chosen as $img) {
+            $url = (string) $img['url'];
+
+            if (!str_starts_with($url, 'http://') && !str_starts_with($url, 'https://')) {
+                $url = 'https://www.buerklin.com' . $url;
+            }
+            if (!filter_var($url, FILTER_VALIDATE_URL)) {
+                continue;
+            }
+
+            $byUrl[$url] = $url;
+        }
+
+        return array_map(
+            fn($url) => new FileDTO($url),
+            array_values($byUrl)
+        );
+    }
+
+    private function attributesToParameters(array $features, ?string $group = null): array
+    {
+        $out = [];
+
+        foreach ($features as $f) {
+            if (!is_array($f)) {
+                continue;
+            }
+
+            $name = $f['name'] ?? null;
+            if (!is_string($name) || trim($name) === '') {
+                continue;
+            }
+
+            $vals = [];
+            foreach (($f['featureValues'] ?? []) as $fv) {
+                if (is_array($fv) && isset($fv['value']) && is_string($fv['value']) && trim($fv['value']) !== '') {
+                    $vals[] = trim($fv['value']);
+                }
+            }
+            if (empty($vals)) {
+                continue;
+            }
+
+            // Multiple values: join with comma
+            $value = implode(', ', array_values(array_unique($vals)));
+
+            // Unit/symbol from Buerklin feature
+            $unit = $f['featureUnit']['symbol'] ?? null;
+            if (!is_string($unit) || trim($unit) === '') {
+                $unit = null;
+            }
+
+            // ParameterDTO parses value field (handles value + unit)
+            $out[] = ParameterDTO::parseValueField(
+                name: $name,
+                value: $value,
+                unit: $unit,
+                symbol: null,
+                group: $group
+            );
+        }
+
+        // Deduplicate by name
+        $byName = [];
+        foreach ($out as $p) {
+            $byName[$p->name] ??= $p;
+        }
+
+        return array_values($byName);
+    }
+
+    /**
+     * @return PartDetailDTO[]
+     */
+    public function searchByKeyword(string $keyword): array
+    {
+        $keyword = strtoupper(trim($keyword));
+        if ($keyword === '') {
+            return [];
+        }
+
+        $response = $this->makeAPICall('/products/search/', [
+            'pageSize' => 50,
+            'currentPage' => 0,
+            'query' => $keyword,
+            'sort' => 'relevance',
+        ]);
+
+        $products = $response['products'] ?? [];
+
+        // Normal case: products found in search results
+        if (is_array($products) && !empty($products)) {
+            return array_map(fn($p) => $this->getPartDetail($p), $products);
+        }
+
+        // Fallback: try direct lookup by code
+        try {
+            $product = $this->getProduct($keyword);
+            return [$this->getPartDetail($product)];
+        } catch (\Throwable $e) {
+            return [];
+        }
+    }
+
+    public function getDetails(string $id): PartDetailDTO
+    {
+        // Detail endpoint is /products/{code}/
+        $response = $this->getProduct($id);
+
+        return $this->getPartDetail($response);
+    }
+
+    public function getCapabilities(): array
+    {
+        return [
+            ProviderCapabilities::BASIC,
+            ProviderCapabilities::PICTURE,
+                //ProviderCapabilities::DATASHEET, // currently not implemented
+            ProviderCapabilities::PRICE,
+            ProviderCapabilities::FOOTPRINT,
+        ];
+    }
+
+    private function complianceToParameters(array $product, ?string $group = 'Compliance'): array
+    {
+        $params = [];
+
+        $add = function (string $name, $value) use (&$params, $group) {
+            if ($value === null) {
+                return;
+            }
+
+            if (is_bool($value)) {
+                $value = $value ? 'Yes' : 'No';
+            } elseif (is_array($value) || is_object($value)) {
+                // Avoid dumping large or complex structures
+                return;
+            } else {
+                $value = trim((string) $value);
+                if ($value === '') {
+                    return;
+                }
+            }
+
+            $params[] = ParameterDTO::parseValueField(
+                name: $name,
+                value: (string) $value,
+                unit: null,
+                symbol: null,
+                group: $group
+            );
+        };
+
+        $add('RoHS conform', $product['labelRoHS'] ?? null);          // "yes"/"no"
+
+        $rawRoHsDate = $product['dateRoHS'] ?? null;
+        // Try to parse and reformat date to Y-m-d (do not use language-dependent formats)
+        if (is_string($rawRoHsDate) && $rawRoHsDate !== '') {
+            try {
+                $dt = new \DateTimeImmutable($rawRoHsDate);
+                $formatted = $dt->format('Y-m-d');
+            } catch (\Exception $e) {
+                $formatted = $rawRoHsDate;
+            }
+            // Always use the same parameter name (do not use language-dependent names)
+            $add('RoHS date', $formatted);
+        }
+        $add('SVHC free', $product['SVHC'] ?? null);               // bool
+        $add('Hazardous good', $product['hazardousGood'] ?? null);       // bool
+        $add('Hazardous materials', $product['hazardousMaterials'] ?? null); // bool
+
+        $add('Country of origin', $product['countryOfOrigin'] ?? null);
+        // Customs tariff code must always be stored as string, otherwise "85411000" may be stored as "8.5411e+7"
+        if (isset($product['articleCustomsCode'])) {
+            // Raw value as string
+            $codeRaw = (string) $product['articleCustomsCode'];
+
+            // Optionally keep only digits (in case of spaces or other characters)
+            $code = preg_replace('/\D/', '', $codeRaw) ?? $codeRaw;
+            $code = trim($code);
+
+            if ($code !== '') {
+                $params[] = new ParameterDTO(
+                    name: 'Customs code',
+                    value_text: $code,
+                    value_typ: null,
+                    value_min: null,
+                    value_max: null,
+                    unit: null,
+                    symbol: null,
+                    group: $group
+                );
+            }
+        }
+
+        return $params;
+    }
+
+    /**
+     * @param string[] $keywords
+     * @return array<string, SearchResultDTO[]>
+     */
+    public function searchByKeywordsBatch(array $keywords): array
+    {
+        /** @var array<string, SearchResultDTO[]> $results */
+        $results = [];
+
+        foreach ($keywords as $keyword) {
+            $keyword = strtoupper(trim((string) $keyword));
+            if ($keyword === '') {
+                continue;
+            }
+
+            // Reuse existing single search -> returns PartDetailDTO[]
+            /** @var PartDetailDTO[] $partDetails */
+            $partDetails = $this->searchByKeyword($keyword);
+
+            // Convert to SearchResultDTO[]
+            $results[$keyword] = array_map(
+                fn(PartDetailDTO $detail) => $this->convertPartDetailToSearchResult($detail),
+                $partDetails
+            );
+        }
+
+        return $results;
+    }
+
+    /**
+     * Converts a PartDetailDTO into a SearchResultDTO for bulk search.
+     */
+    private function convertPartDetailToSearchResult(PartDetailDTO $detail): SearchResultDTO
+    {
+        return new SearchResultDTO(
+            provider_key: $detail->provider_key,
+            provider_id: $detail->provider_id,
+            name: $detail->name,
+            description: $detail->description ?? '',
+            category: $detail->category ?? null,
+            manufacturer: $detail->manufacturer ?? null,
+            mpn: $detail->mpn ?? null,
+            preview_image_url: $detail->preview_image_url ?? null,
+            manufacturing_status: $detail->manufacturing_status ?? null,
+            provider_url: $detail->provider_url ?? null,
+            footprint: $detail->footprint ?? null,
+        );
+    }
+
+}

src/Services/InfoProviderSystem/Providers/ConradProvider.php

@@ -0,0 +1,320 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2026 Jan Böhmer (https://github.com/jbtronics)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Services\InfoProviderSystem\Providers;
+
+use App\Services\InfoProviderSystem\DTOs\FileDTO;
+use App\Services\InfoProviderSystem\DTOs\ParameterDTO;
+use App\Services\InfoProviderSystem\DTOs\PartDetailDTO;
+use App\Services\InfoProviderSystem\DTOs\PriceDTO;
+use App\Services\InfoProviderSystem\DTOs\PurchaseInfoDTO;
+use App\Services\InfoProviderSystem\DTOs\SearchResultDTO;
+use App\Settings\InfoProviderSystem\ConradSettings;
+use Symfony\Contracts\HttpClient\HttpClientInterface;
+
+readonly class ConradProvider implements InfoProviderInterface
+{
+
+    private const SEARCH_ENDPOINT = '/search/1/v3/facetSearch';
+    public const DISTRIBUTOR_NAME = 'Conrad';
+
+    private HttpClientInterface $httpClient;
+
+    public function __construct( HttpClientInterface $httpClient, private ConradSettings $settings)
+    {
+        //We want everything in JSON
+        $this->httpClient = $httpClient->withOptions([
+            'headers' => [
+                'Accept' => 'application/json',
+            ],
+        ]);
+    }
+
+    public function getProviderInfo(): array
+    {
+        return [
+            'name' => 'Conrad',
+            'description' => 'Retrieves part information from conrad.de',
+            'url' => 'https://www.conrad.de/',
+            'disabled_help' => 'Set API key in settings',
+            'settings_class' => ConradSettings::class,
+        ];
+    }
+
+    public function getProviderKey(): string
+    {
+        return 'conrad';
+    }
+
+    public function isActive(): bool
+    {
+        return !empty($this->settings->apiKey);
+    }
+
+    private function getProductUrl(string $productId): string
+    {
+        return 'https://' . $this->settings->shopID->getDomain() . '/' . $this->settings->shopID->getLanguage() . '/p/' . $productId;
+    }
+
+    private function getFootprintFromTechnicalDetails(array $technicalDetails): ?string
+    {
+        foreach ($technicalDetails as $detail) {
+            if ($detail['name'] === 'ATT_LOV_HOUSING_SEMICONDUCTORS') {
+                return $detail['values'][0] ?? null;
+            }
+        }
+
+        return null;
+    }
+
+    public function searchByKeyword(string $keyword): array
+    {
+        $url = $this->settings->shopID->getAPIRoot() . self::SEARCH_ENDPOINT . '/'
+            . $this->settings->shopID->getDomainEnd() . '/' . $this->settings->shopID->getLanguage()
+            . '/' . $this->settings->shopID->getCustomerType();
+
+        $response = $this->httpClient->request('POST', $url, [
+            'query' => [
+                'apikey' => $this->settings->apiKey,
+            ],
+            'json' => [
+                'query' => $keyword,
+                'size' => 50,
+                'sort' => [["field"=>"_score","order"=>"desc"]],
+            ],
+        ]);
+
+        $out = [];
+        $results = $response->toArray();
+
+        foreach($results['hits'] as $result) {
+
+            $out[] = new SearchResultDTO(
+                provider_key: $this->getProviderKey(),
+                provider_id: $result['productId'],
+                name: $result['manufacturerId'] ?? $result['productId'],
+                description: $result['title'] ?? '',
+                manufacturer: $result['brand']['name'] ?? null,
+                mpn: $result['manufacturerId'] ??  null,
+                preview_image_url: $result['image'] ?? null,
+                provider_url: $this->getProductUrl($result['productId']),
+                footprint: $this->getFootprintFromTechnicalDetails($result['technicalDetails'] ?? []),
+            );
+        }
+
+        return $out;
+    }
+
+    private function getFootprintFromTechnicalAttributes(array $technicalDetails): ?string
+    {
+        foreach ($technicalDetails as $detail) {
+            if ($detail['attributeID'] === 'ATT.LOV.HOUSING_SEMICONDUCTORS') {
+                return $detail['values'][0]['value'] ?? null;
+            }
+        }
+
+        return null;
+    }
+
+    /**
+     * @param  array  $technicalAttributes
+     * @return array<ParameterDTO>
+     */
+    private function technicalAttributesToParameters(array $technicalAttributes): array
+    {
+        return array_map(static function (array $p) {
+            if (count($p['values']) === 1) { //Single value attribute
+                if (array_key_exists('unit', $p['values'][0])) {
+                    return ParameterDTO::parseValueField( //With unit
+                        name: $p['attributeName'],
+                        value: $p['values'][0]['value'],
+                        unit: $p['values'][0]['unit']['name'],
+                    );
+                }
+
+                return ParameterDTO::parseValueIncludingUnit(
+                    name: $p['attributeName'],
+                    value: $p['values'][0]['value'],
+                );
+            }
+
+            if (count($p['values']) === 2) { //Multi value attribute (e.g. min/max)
+                $value  = $p['values'][0]['value'] ?? null;
+                $value2 = $p['values'][1]['value'] ?? null;
+                $unit   = $p['values'][0]['unit']['name'] ?? '';
+                $unit2  = $p['values'][1]['unit']['name'] ?? '';
+                if ($unit === $unit2 && is_numeric($value) && is_numeric($value2)) {
+                    if (array_key_exists('unit', $p['values'][0])) { //With unit
+                        return new ParameterDTO(
+                            name: $p['attributeName'],
+                            value_min: (float)$value,
+                            value_max:  (float)$value2,
+                            unit: $unit,
+                        );
+                    }
+
+                    return new ParameterDTO(
+                        name: $p['attributeName'],
+                        value_min: (float)$value,
+                        value_max: (float)$value2,
+                    );
+                }
+            }
+
+            // fallback implementation
+            $values = implode(", ", array_map(fn($q) =>
+            array_key_exists('unit', $q) ?  $q['value']." ". ($q['unit']['name'] ?? $q['unit']) : $q['value']
+                , $p['values']));
+            return ParameterDTO::parseValueIncludingUnit(
+                name: $p['attributeName'],
+                value: $values,
+            );
+        }, $technicalAttributes);
+    }
+
+    /**
+     * @param  array  $productMedia
+     * @return array<FileDTO>
+     */
+    public function productMediaToDatasheets(array $productMedia): array
+    {
+        $files = [];
+        foreach ($productMedia['manuals'] as $manual) {
+            //Filter out unwanted languages
+            if (!empty($this->settings->attachmentLanguageFilter) && !in_array($manual['language'], $this->settings->attachmentLanguageFilter, true)) {
+                continue;
+            }
+
+            $files[] = new FileDTO($manual['fullUrl'], $manual['title'] . ' (' . $manual['language'] . ')');
+        }
+
+        return $files;
+    }
+
+
+    /**
+     * Queries prices for a given product ID. It makes a POST request to the Conrad API
+     * @param  string  $productId
+     * @return PurchaseInfoDTO
+     */
+    private function queryPrices(string $productId): PurchaseInfoDTO
+    {
+        $priceQueryURL = $this->settings->shopID->getAPIRoot() . '/price-availability/4/'
+            . $this->settings->shopID->getShopID() . '/facade';
+
+        $response = $this->httpClient->request('POST', $priceQueryURL, [
+            'query' => [
+                'apikey' => $this->settings->apiKey,
+                'overrideCalculationSchema' => $this->settings->includeVAT ? 'GROSS' : 'NET'
+            ],
+            'json' => [
+                'ns:inputArticleItemList' => [
+                    "#namespaces" => [
+                        "ns" => "http://www.conrad.de/ccp/basit/service/article/priceandavailabilityservice/api"
+                    ],
+                    'articles' => [
+                        [
+                            "articleID" => $productId,
+                            "calculatePrice" => true,
+                            "checkAvailability" => true,
+                        ],
+                    ]
+                ]
+            ]
+        ]);
+
+        $result = $response->toArray();
+
+        $priceInfo = $result['priceAndAvailabilityFacadeResponse']['priceAndAvailability']['price'] ?? [];
+        $price = $priceInfo['price'] ?? "0.0";
+        $currency = $priceInfo['currency'] ?? "EUR";
+        $includesVat = $priceInfo['isGrossAmount'] === "true" ?? true;
+        $minOrderAmount = $result['priceAndAvailabilityFacadeResponse']['priceAndAvailability']['availabilityStatus']['minimumOrderQuantity'] ?? 1;
+
+        $prices = [];
+        foreach ($priceInfo['priceScale'] ?? [] as $priceScale) {
+            $prices[] = new PriceDTO(
+                minimum_discount_amount: max($priceScale['scaleFrom'], $minOrderAmount),
+                price: (string)$priceScale['pricePerUnit'],
+                currency_iso_code: $currency,
+                includes_tax: $includesVat
+            );
+        }
+        if (empty($prices)) { //Fallback if no price scales are defined
+            $prices[] = new PriceDTO(
+                minimum_discount_amount: $minOrderAmount,
+                price: (string)$price,
+                currency_iso_code: $currency,
+                includes_tax: $includesVat
+            );
+        }
+
+        return new PurchaseInfoDTO(
+            distributor_name: self::DISTRIBUTOR_NAME,
+            order_number: $productId,
+            prices: $prices,
+            product_url: $this->getProductUrl($productId)
+        );
+    }
+
+    public function getDetails(string $id): PartDetailDTO
+    {
+        $productInfoURL = $this->settings->shopID->getAPIRoot() . '/product/1/service/' . $this->settings->shopID->getShopID()
+            . '/product/' . $id;
+
+        $response = $this->httpClient->request('GET', $productInfoURL, [
+            'query' => [
+                'apikey' => $this->settings->apiKey,
+            ]
+        ]);
+
+        $data = $response->toArray();
+
+        return new PartDetailDTO(
+            provider_key: $this->getProviderKey(),
+            provider_id: $data['shortProductNumber'],
+            name: $data['productFullInformation']['manufacturer']['name'] ?? $data['productFullInformation']['manufacturer']['id']  ?? $data['shortProductNumber'],
+            description: $data['productShortInformation']['title'] ?? '',
+            category: $data['productShortInformation']['articleGroupName'] ?? null,
+            manufacturer: $data['brand']['displayName'] !== null ? preg_replace("/[\u{2122}\u{00ae}]/", "", $data['brand']['displayName']) : null, //Replace ™ and ® symbols
+            mpn: $data['productFullInformation']['manufacturer']['id'] ?? null,
+            preview_image_url: $data['productShortInformation']['mainImage']['imageUrl'] ?? null,
+            provider_url: $this->getProductUrl($data['shortProductNumber']),
+            footprint: $this->getFootprintFromTechnicalAttributes($data['productFullInformation']['technicalAttributes'] ?? []),
+            notes: $data['productFullInformation']['description'] ?? null,
+            datasheets: $this->productMediaToDatasheets($data['productMedia'] ?? []),
+            parameters: $this->technicalAttributesToParameters($data['productFullInformation']['technicalAttributes'] ?? []),
+            vendor_infos: [$this->queryPrices($data['shortProductNumber'])]
+        );
+    }
+
+    public function getCapabilities(): array
+    {
+        return [
+            ProviderCapabilities::BASIC,
+            ProviderCapabilities::PICTURE,
+            ProviderCapabilities::DATASHEET,
+            ProviderCapabilities::PRICE,
+        ];
+    }
+}

src/Services/InfoProviderSystem/Providers/DigikeyProvider.php

@@ -311,6 +311,14 @@ class DigikeyProvider implements InfoProviderInterface
             'auth_bearer' => $this->authTokenManager->getAlwaysValidTokenString(self::OAUTH_APP_NAME)
         ]);
 
+        if ($response->getStatusCode() === 404) {
+            //No media found
+            return [
+                'datasheets' => [],
+                'images' => [],
+            ];
+        }
+
         $media_array = $response->toArray();
 
         foreach ($media_array['MediaLinks'] as $media_link) {

src/Services/InfoProviderSystem/Providers/OEMSecretsProvider.php

@@ -397,13 +397,13 @@ class OEMSecretsProvider implements InfoProviderInterface
      * Generates a cache key for storing part details based on the provided provider ID.
      *
      * This method creates a unique cache key by prefixing the provider ID with 'part_details_'
-     * and hashing the provider ID using MD5 to ensure a consistent and compact key format.
+     * and hashing the provider ID using XXH3 to ensure a consistent and compact key format.
      *
      * @param string $provider_id The unique identifier of the provider or part.
      * @return string The generated cache key.
      */
     private function getCacheKey(string $provider_id): string {
-        return 'oemsecrets_part_' . md5($provider_id);
+        return 'oemsecrets_part_' . hash('xxh3', $provider_id);
     }
 
 
@@ -680,7 +680,7 @@ class OEMSecretsProvider implements InfoProviderInterface
         if (is_array($prices)) {
             // Step 1: Check if prices exist in the preferred currency
             if (isset($prices[$this->settings->currency]) && is_array($prices[$this->settings->currency])) {
-                $priceDetails = $prices[$this->$this->settings->currency];
+                $priceDetails = $prices[$this->settings->currency];
                 foreach ($priceDetails as $priceDetail) {
                     if (
                         is_array($priceDetail) &&

src/Services/InfoProviderSystem/Providers/PollinProvider.php

@@ -248,4 +248,4 @@ class PollinProvider implements InfoProviderInterface
             ProviderCapabilities::DATASHEET
         ];
     }
-}
+}

src/Services/InfoProviderSystem/Providers/ProviderCapabilities.php

@@ -31,9 +31,6 @@ enum ProviderCapabilities
     /** Basic information about a part, like the name, description, part number, manufacturer etc */
     case BASIC;
 
-    /** Information about the footprint of a part */
-    case FOOTPRINT;
-
     /** Provider can provide a picture for a part */
     case PICTURE;
 
@@ -43,6 +40,24 @@ enum ProviderCapabilities
     /** Provider can provide prices for a part */
     case PRICE;
 
+    /** Information about the footprint of a part */
+    case FOOTPRINT;
+
+    /**
+     * Get the order index for displaying capabilities in a stable order.
+     * @return int
+     */
+    public function getOrderIndex(): int
+    {
+        return match($this) {
+            self::BASIC => 1,
+            self::PICTURE => 2,
+            self::DATASHEET => 3,
+            self::PRICE => 4,
+            self::FOOTPRINT => 5,
+        };
+    }
+
     public function getTranslationKey(): string
     {
         return 'info_providers.capabilities.' . match($this) {

src/Settings/InfoProviderSystem/BuerklinSettings.php

@@ -0,0 +1,84 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2025 Jan Böhmer (https://github.com/jbtronics)
+ *  Copyright (C) 2025 Marc Kreidler (https://github.com/mkne)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Settings\InfoProviderSystem;
+
+use App\Form\Type\APIKeyType;
+use App\Settings\SettingsIcon;
+use Jbtronics\SettingsBundle\Metadata\EnvVarMode;
+use Jbtronics\SettingsBundle\Settings\Settings;
+use Jbtronics\SettingsBundle\Settings\SettingsTrait;
+use Symfony\Component\Form\Extension\Core\Type\CountryType;
+use Symfony\Component\Form\Extension\Core\Type\CurrencyType;
+use Symfony\Component\Form\Extension\Core\Type\LanguageType;
+use Symfony\Component\Translation\TranslatableMessage as TM;
+use Jbtronics\SettingsBundle\Settings\SettingsParameter;
+use Symfony\Component\Validator\Constraints as Assert;
+
+#[Settings(label: new TM("settings.ips.buerklin"), description: new TM("settings.ips.buerklin.help"))]
+#[SettingsIcon("fa-plug")]
+class BuerklinSettings
+{
+    use SettingsTrait;
+
+    #[SettingsParameter(
+        label: new TM("settings.ips.digikey.client_id"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_CLIENT_ID", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $clientId = null;
+
+    #[SettingsParameter(
+        label: new TM("settings.ips.digikey.secret"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_SECRET", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $secret = null;
+
+        #[SettingsParameter(
+        label: new TM("settings.ips.buerklin.username"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_USER", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $username = null;
+
+        #[SettingsParameter(
+        label: new TM("user.edit.password"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_PASSWORD", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $password = null;
+
+    #[SettingsParameter(label: new TM("settings.ips.tme.currency"), formType: CurrencyType::class,
+        formOptions: ["preferred_choices" => ["EUR"]],
+        envVar: "PROVIDER_BUERKLIN_CURRENCY", envVarMode: EnvVarMode::OVERWRITE)]
+    #[Assert\Currency()]
+    public string $currency = "EUR";
+
+    #[SettingsParameter(label: new TM("settings.ips.tme.language"), formType: LanguageType::class,
+                        formOptions: ["preferred_choices" => ["en", "de"]],
+        envVar: "PROVIDER_BUERKLIN_LANGUAGE", envVarMode: EnvVarMode::OVERWRITE)]
+    #[Assert\Language]
+    public string $language = "en";
+}

src/Settings/InfoProviderSystem/ConradSettings.php

@@ -0,0 +1,77 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2026 Jan Böhmer (https://github.com/jbtronics)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Settings\InfoProviderSystem;
+
+use App\Form\Type\APIKeyType;
+use App\Settings\SettingsIcon;
+use Jbtronics\SettingsBundle\Metadata\EnvVarMode;
+use Jbtronics\SettingsBundle\ParameterTypes\ArrayType;
+use Jbtronics\SettingsBundle\ParameterTypes\StringType;
+use Jbtronics\SettingsBundle\Settings\Settings;
+use Jbtronics\SettingsBundle\Settings\SettingsParameter;
+use Jbtronics\SettingsBundle\Settings\SettingsTrait;
+use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
+use Symfony\Component\Form\Extension\Core\Type\CountryType;
+use Symfony\Component\Form\Extension\Core\Type\EnumType;
+use Symfony\Component\Form\Extension\Core\Type\LanguageType;
+use Symfony\Component\Translation\TranslatableMessage as TM;
+use Symfony\Component\Validator\Constraints as Assert;
+
+#[Settings(label: new TM("settings.ips.conrad"))]
+#[SettingsIcon("fa-plug")]
+class ConradSettings
+{
+    use SettingsTrait;
+
+    #[SettingsParameter(label: new TM("settings.ips.element14.apiKey"),
+        formType: APIKeyType::class,
+        formOptions: ["help_html" => true], envVar: "PROVIDER_CONRAD_API_KEY", envVarMode: EnvVarMode::OVERWRITE)]
+    public ?string $apiKey = null;
+
+    #[SettingsParameter(label: new TM("settings.ips.conrad.shopID"),
+        description: new TM("settings.ips.conrad.shopID.description"),
+        formType: EnumType::class,
+        formOptions: ['class' => ConradShopIDs::class],
+    )]
+    public ConradShopIDs $shopID = ConradShopIDs::COM_B2B;
+
+    #[SettingsParameter(label: new TM("settings.ips.reichelt.include_vat"))]
+    public bool $includeVAT = true;
+
+    /**
+     * @var array|string[] Only attachments in these languages will be downloaded (ISO 639-1 codes)
+     */
+    #[Assert\Unique()]
+    #[Assert\All([new Assert\Language()])]
+    #[SettingsParameter(type: ArrayType::class,
+        label: new TM("settings.ips.conrad.attachment_language_filter"), description: new TM("settings.ips.conrad.attachment_language_filter.description"),
+        options: ['type' => StringType::class],
+        formType: LanguageType::class,
+        formOptions: [
+            'multiple' => true,
+            'preferred_choices' => ['en', 'de', 'fr', 'it', 'cs', 'da', 'nl', 'hu', 'hr', 'sk', 'pl']
+        ],
+    )]
+    public array $attachmentLanguageFilter = ['en'];
+}

src/Settings/InfoProviderSystem/ConradShopIDs.php

@@ -0,0 +1,167 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2026 Jan Böhmer (https://github.com/jbtronics)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Settings\InfoProviderSystem;
+
+use Symfony\Contracts\Translation\TranslatableInterface;
+use Symfony\Contracts\Translation\TranslatorInterface;
+
+enum ConradShopIDs: string implements TranslatableInterface
+{
+    case COM_B2B = 'HP_COM_B2B';
+    case DE_B2B = 'CQ_DE_B2B';
+    case DE_B2C = 'CQ_DE_B2C';
+    case AT_B2C = 'CQ_AT_B2C';
+    case CH_B2C_DE = 'CQ_CH_B2C_DE';
+    case CH_B2C_FR = 'CQ_CH_B2C_FR';
+    case SE_B2B = 'HP_SE_B2B';
+    case HU_B2C = 'CQ_HU_B2C';
+    case CZ_B2B = 'HP_CZ_B2B';
+    case SI_B2B = 'HP_SI_B2B';
+    case SK_B2B = 'HP_SK_B2B';
+    case BE_B2B = 'HP_BE_B2B';
+    case PL_B2B = 'HP_PL_B2B';
+    case NL_B2B = 'CQ_NL_B2B';
+    case NL_B2C = 'CQ_NL_B2C';
+    case DK_B2B = 'HP_DK_B2B';
+    case IT_B2B = 'HP_IT_B2B';
+
+    case FR_B2B = 'HP_FR_B2B';
+    case AT_B2B = 'CQ_AT_B2B';
+    case HR_B2B = 'HP_HR_B2B';
+
+
+    public function trans(TranslatorInterface $translator, ?string $locale = null): string
+    {
+        return match ($this) {
+            self::DE_B2B => "conrad.de (B2B)",
+            self::AT_B2C => "conrad.at (B2C)",
+            self::CH_B2C_DE => "conrad.ch DE (B2C)",
+            self::CH_B2C_FR => "conrad.ch FR (B2C)",
+            self::SE_B2B => "conrad.se (B2B)",
+            self::HU_B2C => "conrad.hu (B2C)",
+            self::CZ_B2B => "conrad.cz (B2B)",
+            self::SI_B2B => "conrad.si (B2B)",
+            self::SK_B2B => "conrad.sk (B2B)",
+            self::BE_B2B => "conrad.be (B2B)",
+            self::DE_B2C => "conrad.de (B2C)",
+            self::PL_B2B => "conrad.pl (B2B)",
+            self::NL_B2B => "conrad.nl (B2B)",
+            self::DK_B2B => "conradelektronik.dk (B2B)",
+            self::IT_B2B => "conrad.it (B2B)",
+            self::NL_B2C => "conrad.nl (B2C)",
+            self::FR_B2B => "conrad.fr (B2B)",
+            self::COM_B2B => "conrad.com (B2B)",
+            self::AT_B2B => "conrad.at (B2B)",
+            self::HR_B2B => "conrad.hr (B2B)",
+        };
+    }
+
+    public function getDomain(): string
+    {
+        if ($this === self::DK_B2B) {
+            return 'conradelektronik.dk';
+        }
+
+        return 'conrad.' . $this->getDomainEnd();
+    }
+
+    /**
+     * Retrieves the API root URL for this shop ID. e.g. https://api.conrad.de
+     * @return string
+     */
+    public function getAPIRoot(): string
+    {
+        return 'https://api.' . $this->getDomain();
+    }
+
+    /**
+     * Returns the shop ID value used in the API requests. e.g. 'CQ_DE_B2B'
+     * @return string
+     */
+    public function getShopID(): string
+    {
+        if ($this === self::CH_B2C_FR || $this === self::CH_B2C_DE) {
+            return 'CQ_CH_B2C';
+        }
+
+        return $this->value;
+    }
+
+    public function getDomainEnd(): string
+    {
+        return match ($this) {
+            self::DE_B2B, self::DE_B2C => 'de',
+            self::AT_B2B, self::AT_B2C => 'at',
+            self::CH_B2C_DE => 'ch', self::CH_B2C_FR => 'ch',
+            self::SE_B2B => 'se',
+            self::HU_B2C => 'hu',
+            self::CZ_B2B => 'cz',
+            self::SI_B2B => 'si',
+            self::SK_B2B => 'sk',
+            self::BE_B2B => 'be',
+            self::PL_B2B => 'pl',
+            self::NL_B2B, self::NL_B2C => 'nl',
+            self::DK_B2B => 'dk',
+            self::IT_B2B => 'it',
+            self::FR_B2B => 'fr',
+            self::COM_B2B => 'com',
+            self::HR_B2B => 'hr',
+        };
+    }
+
+    public function getLanguage(): string
+    {
+        return match ($this) {
+            self::DE_B2B, self::DE_B2C, self::AT_B2B, self::AT_B2C => 'de',
+            self::CH_B2C_DE => 'de', self::CH_B2C_FR => 'fr',
+            self::SE_B2B => 'sv',
+            self::HU_B2C => 'hu',
+            self::CZ_B2B => 'cs',
+            self::SI_B2B => 'sl',
+            self::SK_B2B => 'sk',
+            self::BE_B2B => 'nl',
+            self::PL_B2B => 'pl',
+            self::NL_B2B, self::NL_B2C => 'nl',
+            self::DK_B2B => 'da',
+            self::IT_B2B => 'it',
+            self::FR_B2B => 'fr',
+            self::COM_B2B => 'en',
+            self::HR_B2B => 'hr',
+        };
+    }
+
+    /**
+     * Retrieves the customer type for this shop ID. e.g. 'b2b' or 'b2c'
+     * @return string 'b2b' or 'b2c'
+     */
+    public function getCustomerType(): string
+    {
+        return match ($this) {
+            self::DE_B2B, self::AT_B2B, self::SE_B2B, self::CZ_B2B, self::SI_B2B,
+            self::SK_B2B, self::BE_B2B, self::PL_B2B, self::NL_B2B, self::DK_B2B,
+            self::IT_B2B, self::FR_B2B, self::COM_B2B, self::HR_B2B => 'b2b',
+            self::DE_B2C, self::AT_B2C, self::CH_B2C_DE, self::CH_B2C_FR, self::HU_B2C, self::NL_B2C => 'b2c',
+        };
+    }
+}

src/Settings/InfoProviderSystem/InfoProviderSettings.php

@@ -63,4 +63,10 @@ class InfoProviderSettings
 
     #[EmbeddedSettings]
     public ?PollinSettings $pollin = null;
+
+    #[EmbeddedSettings]
+    public ?BuerklinSettings $buerklin = null;
+
+    #[EmbeddedSettings]
+    public ?ConradSettings $conrad = null;
 }

symfony.lock

@@ -718,18 +718,17 @@
         "files": []
     },
     "symfony/ux-translator": {
-        "version": "2.9",
+        "version": "2.32",
         "recipe": {
             "repo": "github.com/symfony/recipes",
             "branch": "main",
-            "version": "2.9",
-            "ref": "bc396565cc4cab95692dd6df810553dc22e352e1"
+            "version": "2.32",
+            "ref": "20e2abac415da4c3a9a6bafa059a6419beb74593"
         },
         "files": [
-            "./assets/translator.js",
-            "./config/packages/ux_translator.yaml",
-            "./var/translations/configuration.js",
-            "./var/translations/index.js"
+            "assets/translator.js",
+            "config/packages/ux_translator.yaml",
+            "var/translations/index.js"
         ]
     },
     "symfony/ux-turbo": {

templates/components/search.macro.html.twig

@@ -11,6 +11,10 @@
                     <input type="checkbox" class="form-check-input" id="search_name" name="name" value="1" checked {{ stimulus_controller('elements/localStorage_checkbox') }}>
                     <label for="search_name" class="form-check-label justify-content-start">{% trans %}name.label{% endtrans %}</label>
                 </div>
+                <div class="form-check">
+                    <input type="checkbox" class="form-check-input" id="search_dbid" name="dbid" value="1" {{ stimulus_controller('elements/localStorage_checkbox') }}>
+                    <label for="search_dbid" class="form-check-label justify-content-start">{% trans %}id.label{% endtrans %}</label>
+                </div>
                 <div class="form-check">
                     <input type="checkbox" class="form-check-input" id="search_category" name="category" value="1" checked {{ stimulus_controller('elements/localStorage_checkbox') }}>
                     <label for="search_category" class="form-check-label justify-content-start">{% trans %}category.label{% endtrans %}</label>
@@ -102,4 +106,4 @@
             {{ _self.settings_drodown(is_navbar) }}
         {% endif %}
     </form>
-{% endmacro %}
+{% endmacro %}

templates/info_providers/providers.macro.html.twig

@@ -27,7 +27,7 @@
                                    title="{% trans %}info_providers.settings.title{% endtrans %}"
                                 ><i class="fa-solid fa-cog"></i></a>
                             {% endif %}
-                            {% for capability in provider.capabilities %}
+                            {% for capability in provider.capabilities|sort((a, b) => a.orderIndex <=> b.orderIndex) %}
                                 {# @var capability \App\Services\InfoProviderSystem\Providers\ProviderCapabilities #}
                                 <span class="badge text-bg-secondary">
                                     <i class="{{ capability.fAIconClass }} fa-fw"></i>

templates/label_system/dialog.html.twig

@@ -135,8 +135,8 @@
 
 {% block additional_content %}
     {% if pdf_data %}
-        <div class="card mt-2 p-1 border-secondary" style="resize: vertical; overflow: scroll; height: 250px">
-            <object id="pdf_preview"  data="{{ pdf_data | data_uri(mime='application/pdf') }}"style="height: inherit">
+        <div class="card mt-2 p-1 border-secondary" style="resize: vertical; overflow: scroll; height: 280px">
+            <object id="pdf_preview"  data="{{ pdf_data | data_uri(mime='application/pdf') }}" style="height: inherit">
             </object>
         </div>
     {% endif %}

tests/EventListener/RegisterSynonymsAsTranslationParametersTest.php

@@ -37,7 +37,7 @@ class RegisterSynonymsAsTranslationParametersTest extends KernelTestCase
 
     public function testGetSynonymPlaceholders(): void
     {
-        $placeholders = $this->listener->getSynonymPlaceholders();
+        $placeholders = $this->listener->getSynonymPlaceholders('en');
 
         $this->assertIsArray($placeholders);
         // Curly braces for lowercase versions

tests/Services/ImportExportSystem/BOMImporterTest.php

@@ -353,6 +353,16 @@ class BOMImporterTest extends WebTestCase
 
     public function testStringToBOMEntriesKiCADSchematic(): void
     {
+        // Create test suppliers for this test
+        $lcscSupplier = new Supplier();
+        $lcscSupplier->setName('LCSC');
+        $mouserSupplier = new Supplier();
+        $mouserSupplier->setName('Mouser');
+
+        $this->entityManager->persist($lcscSupplier);
+        $this->entityManager->persist($mouserSupplier);
+        $this->entityManager->flush();
+
         $input = <<<CSV
         "Reference","Value","Footprint","Quantity","MPN","Manufacturer","LCSC SPN","Mouser SPN"
         "R1,R2","10k","R_0805_2012Metric",2,"CRCW080510K0FKEA","Vishay","C123456","123-M10K"
@@ -386,10 +396,20 @@ class BOMImporterTest extends WebTestCase
         $this->assertStringContainsString('Value: 10k', $bom_entries[0]->getComment());
         $this->assertStringContainsString('MPN: CRCW080510K0FKEA', $bom_entries[0]->getComment());
         $this->assertStringContainsString('Manf: Vishay', $bom_entries[0]->getComment());
+        $this->assertStringContainsString('LCSC SPN: C123456', $bom_entries[0]->getComment());
+        $this->assertStringContainsString('Mouser SPN: 123-M10K', $bom_entries[0]->getComment());
+
 
         // Check second entry
         $this->assertEquals('C1', $bom_entries[1]->getMountnames());
         $this->assertEquals(1.0, $bom_entries[1]->getQuantity());
+        $this->assertStringContainsString('LCSC SPN: C789012', $bom_entries[1]->getComment());
+        $this->assertStringContainsString('Mouser SPN: 80-CL21A104KOCLRNC', $bom_entries[1]->getComment());
+
+        // Clean up
+        $this->entityManager->remove($lcscSupplier);
+        $this->entityManager->remove($mouserSupplier);
+        $this->entityManager->flush();
     }
 
     public function testStringToBOMEntriesKiCADSchematicWithPriority(): void

tests/Services/InfoProviderSystem/Providers/BuerklinProviderTest.php

@@ -0,0 +1,271 @@
+<?php
+
+declare(strict_types=1);
+
+namespace App\Tests\Services\InfoProviderSystem\Providers;
+
+use App\Services\InfoProviderSystem\DTOs\PartDetailDTO;
+use App\Services\InfoProviderSystem\DTOs\SearchResultDTO;
+use App\Services\InfoProviderSystem\Providers\BuerklinProvider;
+use App\Settings\InfoProviderSystem\BuerklinSettings;
+use PHPUnit\Framework\TestCase;
+use Psr\Cache\CacheItemInterface;
+use Psr\Cache\CacheItemPoolInterface;
+use Symfony\Contracts\HttpClient\HttpClientInterface;
+use Symfony\Contracts\HttpClient\ResponseInterface;
+
+/**
+ * Full behavioral test suite for BuerklinProvider.
+ * Includes parameter parsing, compliance parsing, images, prices and batch mode.
+ */
+class BuerklinProviderTest extends TestCase
+{
+    private HttpClientInterface $httpClient;
+    private CacheItemPoolInterface $cache;
+    private BuerklinSettings $settings;
+    private BuerklinProvider $provider;
+
+    protected function setUp(): void
+    {
+        $this->httpClient = $this->createMock(HttpClientInterface::class);
+
+        // Cache mock
+        $cacheItem = $this->createMock(CacheItemInterface::class);
+        $cacheItem->method('isHit')->willReturn(false);
+        $cacheItem->method('set')->willReturn($cacheItem);
+
+        $this->cache = $this->createMock(CacheItemPoolInterface::class);
+        $this->cache->method('getItem')->willReturn($cacheItem);
+
+        // IMPORTANT: Settings must not be instantiated directly (SettingsBundle forbids constructor)
+        $ref = new \ReflectionClass(BuerklinSettings::class);
+        /** @var BuerklinSettings $settings */
+        $settings = $ref->newInstanceWithoutConstructor();
+
+        $settings->clientId = 'CID';
+        $settings->secret = 'SECRET';
+        $settings->username = 'USER';
+        $settings->password = 'PASS';
+        $settings->language = 'en';
+        $settings->currency = 'EUR';
+
+        $this->settings = $settings;
+
+        $this->provider = new BuerklinProvider(
+            client: $this->httpClient,
+            partInfoCache: $this->cache,
+            settings: $this->settings,
+        );
+    }
+
+    private function mockApi(string $expectedUrl, array $jsonResponse): void
+    {
+        $response = $this->createMock(ResponseInterface::class);
+        $response->method('toArray')->willReturn($jsonResponse);
+
+        $this->httpClient
+            ->method('request')
+            ->with(
+                'GET',
+                $this->callback(fn($url) => str_contains((string) $url, $expectedUrl)),
+                $this->anything()
+            )
+            ->willReturn($response);
+    }
+
+    public function testAttributesToParametersParsesUnitsAndValues(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'attributesToParameters');
+        $method->setAccessible(true);
+
+        $features = [
+            [
+                'name' => 'Zener voltage',
+                'featureUnit' => ['symbol' => 'V'],
+                'featureValues' => [
+                    ['value' => '12']
+                ]
+            ],
+            [
+                'name' => 'Length',
+                'featureUnit' => ['symbol' => 'mm'],
+                'featureValues' => [
+                    ['value' => '2.9']
+                ]
+            ],
+            [
+                'name' => 'Assembly',
+                'featureUnit' => [],
+                'featureValues' => [
+                    ['value' => 'SMD']
+                ]
+            ]
+        ];
+
+        $params = $method->invoke($this->provider, $features, '');
+
+        $this->assertCount(3, $params);
+
+        $this->assertSame('Zener voltage', $params[0]->name);
+        $this->assertNull($params[0]->value_text);
+        $this->assertSame(12.0, $params[0]->value_typ);
+        $this->assertNull($params[0]->value_min);
+        $this->assertNull($params[0]->value_max);
+        $this->assertSame('V', $params[0]->unit);
+
+        $this->assertSame('Length', $params[1]->name);
+        $this->assertNull($params[1]->value_text);
+        $this->assertSame(2.9, $params[1]->value_typ);
+        $this->assertSame('mm', $params[1]->unit);
+
+        $this->assertSame('Assembly', $params[2]->name);
+        $this->assertSame('SMD', $params[2]->value_text);
+        $this->assertNull($params[2]->unit);
+    }
+
+    public function testComplianceParameters(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'complianceToParameters');
+        $method->setAccessible(true);
+
+        $product = [
+            'labelRoHS' => 'Yes',
+            'dateRoHS' => '2015-03-31T00:00+0000',
+            'SVHC' => true,
+            'hazardousGood' => false,
+            'hazardousMaterials' => false,
+            'countryOfOrigin' => 'China',
+            'articleCustomsCode' => '85411000'
+        ];
+
+        $params = $method->invoke($this->provider, $product, 'Compliance');
+
+        $map = [];
+        foreach ($params as $p) {
+            $map[$p->name] = $p->value_text;
+        }
+
+        $this->assertSame('Yes', $map['RoHS conform']);
+        $this->assertSame('2015-03-31', $map['RoHS date']);
+        $this->assertSame('Yes', $map['SVHC free']);
+        $this->assertSame('No', $map['Hazardous good']);
+        $this->assertSame('No', $map['Hazardous materials']);
+        $this->assertSame('China', $map['Country of origin']);
+        $this->assertSame('85411000', $map['Customs code']);
+    }
+
+    public function testImageSelectionPrefersZoomAndDeduplicates(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'getProductImages');
+        $method->setAccessible(true);
+
+        $images = [
+            ['format' => 'product', 'url' => '/img/a.webp'],
+            ['format' => 'zoom', 'url' => '/img/z.webp'],
+            ['format' => 'zoom', 'url' => '/img/z.webp'], // duplicate
+            ['format' => 'thumbnail', 'url' => '/img/t.webp']
+        ];
+
+        $results = $method->invoke($this->provider, $images);
+
+        $this->assertCount(1, $results);
+        $this->assertSame('https://www.buerklin.com/img/z.webp', $results[0]->url);
+    }
+
+    public function testFootprintExtraction(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'getPartDetail');
+        $method->setAccessible(true);
+
+        $product = [
+            'code' => 'TEST1',
+            'manufacturerProductId' => 'ABC',
+            'description' => 'X',
+            'images' => [],
+            'classifications' => [
+                [
+                    'name' => 'Cat',
+                    'features' => [
+                        [
+                            'name' => 'Enclosure',
+                            'featureValues' => [['value' => 'SOT-23']]
+                        ]
+                    ]
+                ]
+            ],
+            'price' => ['value' => 1, 'currencyIso' => 'EUR']
+        ];
+
+        $dto = $method->invoke($this->provider, $product);
+        $this->assertSame('SOT-23', $dto->footprint);
+    }
+
+    public function testPriceFormatting(): void
+    {
+        $detailPrice = [
+            [
+                'minQuantity' => 1,
+                'value' => 0.0885,
+                'currencyIso' => 'EUR'
+            ]
+        ];
+
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'pricesToVendorInfo');
+        $method->setAccessible(true);
+
+        $vendorInfo = $method->invoke($this->provider, 'SKU1', 'https://x', $detailPrice);
+
+        $price = $vendorInfo[0]->prices[0];
+        $this->assertSame('0.0885', $price->price);
+    }
+
+    public function testBatchSearchReturnsSearchResultDTO(): void
+    {
+        $mockDetail = new PartDetailDTO(
+            provider_key: 'buerklin',
+            provider_id: 'TESTID',
+            name: 'Zener',
+            description: 'Desc'
+        );
+
+        $provider = $this->getMockBuilder(BuerklinProvider::class)
+            ->setConstructorArgs([
+                $this->httpClient,
+                $this->cache,
+                $this->settings
+            ])
+            ->onlyMethods(['searchByKeyword'])
+            ->getMock();
+
+        $provider->method('searchByKeyword')->willReturn([$mockDetail]);
+
+        $result = $provider->searchByKeywordsBatch(['ABC']);
+
+        $this->assertArrayHasKey('ABC', $result);
+        $this->assertIsArray($result['ABC']);
+        $this->assertCount(1, $result['ABC']);
+        $this->assertInstanceOf(SearchResultDTO::class, $result['ABC'][0]);
+        $this->assertSame('Zener', $result['ABC'][0]->name);
+    }
+
+    public function testConvertPartDetailToSearchResult(): void
+    {
+        $detail = new PartDetailDTO(
+            provider_key: 'buerklin',
+            provider_id: 'X1',
+            name: 'PartX',
+            description: 'D',
+            preview_image_url: 'https://img'
+        );
+
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'convertPartDetailToSearchResult');
+        $method->setAccessible(true);
+
+        $dto = $method->invoke($this->provider, $detail);
+
+        $this->assertInstanceOf(SearchResultDTO::class, $dto);
+        $this->assertSame('X1', $dto->provider_id);
+        $this->assertSame('PartX', $dto->name);
+        $this->assertSame('https://img', $dto->preview_image_url);
+    }
+}

translations/frontend.cs.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="cs">
+  <file id="frontend.cs">
+    <unit id="eLrezdb" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Hledat</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>Díly</target>
+          </segment>
+        </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+          <segment state="translated">
+            <source>entity.select.group.new_not_added_to_DB</source>
+            <target>Nový (zatím nebyl přidán do DB)</target>
+          </segment>
+        </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+          <segment state="translated">
+            <source>user.password_strength.very_weak</source>
+            <target>Velmi slabé</target>
+          </segment>
+        </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+          <segment state="translated">
+            <source>user.password_strength.weak</source>
+            <target>Slabé</target>
+          </segment>
+        </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+          <segment state="translated">
+            <source>user.password_strength.medium</source>
+            <target>Střední</target>
+          </segment>
+        </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+          <segment state="translated">
+            <source>user.password_strength.strong</source>
+            <target>Silné</target>
+          </segment>
+        </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+          <segment state="translated">
+            <source>user.password_strength.very_strong</source>
+            <target>Velmi silné</target>
+          </segment>
+        </unit>
+    <unit id="U5IhkwB" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>Jdi!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.da.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="da">
+  <file id="frontend.en">
+    <unit id="eLrezdb" name="search.placeholder">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+        <note priority="1">templates\base.html.twig:80</note>
+        <note priority="1">templates\base.html.twig:179</note>
+        <note priority="1">templates\base.html.twig:206</note>
+        <note priority="1">templates\base.html.twig:237</note>
+      </notes>
+      <segment state="translated">
+        <source>search.placeholder</source>
+        <target>Søg</target>
+      </segment>
+    </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+      <segment state="translated">
+        <source>part.labelp</source>
+        <target>Dele/parter</target>
+      </segment>
+    </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+      <segment state="translated">
+        <source>entity.select.group.new_not_added_to_DB</source>
+        <target>Ny (endnu ikke tilføjet til databasen)</target>
+      </segment>
+    </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+      <segment state="translated">
+        <source>user.password_strength.very_weak</source>
+        <target>Meget svag</target>
+      </segment>
+    </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+      <segment state="translated">
+        <source>user.password_strength.weak</source>
+        <target>Svag</target>
+      </segment>
+    </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+      <segment state="translated">
+        <source>user.password_strength.medium</source>
+        <target>Middel</target>
+      </segment>
+    </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+      <segment state="translated">
+        <source>user.password_strength.strong</source>
+        <target>Stærk</target>
+      </segment>
+    </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+      <segment state="translated">
+        <source>user.password_strength.very_strong</source>
+        <target>Meget stærk</target>
+      </segment>
+    </unit>
+    <unit id="U5IhkwB" name="search.submit">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+      </notes>
+      <segment state="translated">
+        <source>search.submit</source>
+        <target>Kom nu!</target>
+      </segment>
+    </unit>
+  </file>
+</xliff>

translations/frontend.de.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="de">
+  <file id="frontend.en">
+    <unit id="eLrezdb" name="search.placeholder">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+        <note priority="1">templates\base.html.twig:80</note>
+        <note priority="1">templates\base.html.twig:179</note>
+        <note priority="1">templates\base.html.twig:206</note>
+        <note priority="1">templates\base.html.twig:237</note>
+      </notes>
+      <segment state="translated">
+        <source>search.placeholder</source>
+        <target>Suche</target>
+      </segment>
+    </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+      <segment state="translated">
+        <source>part.labelp</source>
+        <target>Bauteile</target>
+      </segment>
+    </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+      <segment state="translated">
+        <source>entity.select.group.new_not_added_to_DB</source>
+        <target>Neu (noch nicht zur DB hinzugefügt)</target>
+      </segment>
+    </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+      <segment state="translated">
+        <source>user.password_strength.very_weak</source>
+        <target>Sehr schwach</target>
+      </segment>
+    </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+      <segment state="translated">
+        <source>user.password_strength.weak</source>
+        <target>Schwach</target>
+      </segment>
+    </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+      <segment state="translated">
+        <source>user.password_strength.medium</source>
+        <target>Mittel</target>
+      </segment>
+    </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+      <segment state="translated">
+        <source>user.password_strength.strong</source>
+        <target>Stark</target>
+      </segment>
+    </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+      <segment state="translated">
+        <source>user.password_strength.very_strong</source>
+        <target>Sehr stark</target>
+      </segment>
+    </unit>
+    <unit id="U5IhkwB" name="search.submit">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+      </notes>
+      <segment state="translated">
+        <source>search.submit</source>
+        <target>Los!</target>
+      </segment>
+    </unit>
+  </file>
+</xliff>

translations/frontend.el.xlf

@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="el">
+  <file id="frontend.el">
+    <unit id="lQ8QeGr" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Αναζήτηση</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.en.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="en">
+  <file id="frontend.en">
+    <unit id="eLrezdb" name="search.placeholder">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+        <note priority="1">templates\base.html.twig:80</note>
+        <note priority="1">templates\base.html.twig:179</note>
+        <note priority="1">templates\base.html.twig:206</note>
+        <note priority="1">templates\base.html.twig:237</note>
+      </notes>
+      <segment state="translated">
+        <source>search.placeholder</source>
+        <target>Search</target>
+      </segment>
+    </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+      <segment state="translated">
+        <source>part.labelp</source>
+        <target>Parts</target>
+      </segment>
+    </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+      <segment state="translated">
+        <source>entity.select.group.new_not_added_to_DB</source>
+        <target>New (not added to DB yet)</target>
+      </segment>
+    </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+      <segment state="translated">
+        <source>user.password_strength.very_weak</source>
+        <target>Very weak</target>
+      </segment>
+    </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+      <segment state="translated">
+        <source>user.password_strength.weak</source>
+        <target>Weak</target>
+      </segment>
+    </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+      <segment state="translated">
+        <source>user.password_strength.medium</source>
+        <target>Medium</target>
+      </segment>
+    </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+      <segment state="translated">
+        <source>user.password_strength.strong</source>
+        <target>Strong</target>
+      </segment>
+    </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+      <segment state="translated">
+        <source>user.password_strength.very_strong</source>
+        <target>Very strong</target>
+      </segment>
+    </unit>
+    <unit id="U5IhkwB" name="search.submit">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+      </notes>
+      <segment state="translated">
+        <source>search.submit</source>
+        <target>Go!</target>
+      </segment>
+    </unit>
+  </file>
+</xliff>

translations/frontend.es.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="es">
+  <file id="frontend.es">
+    <unit id="eLrezdb" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Buscar</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>Componentes</target>
+          </segment>
+        </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+          <segment state="translated">
+            <source>entity.select.group.new_not_added_to_DB</source>
+            <target>Nuevo (no añadido a la base de datos)</target>
+          </segment>
+        </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+          <segment state="translated">
+            <source>user.password_strength.very_weak</source>
+            <target>Muy débil</target>
+          </segment>
+        </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+          <segment state="translated">
+            <source>user.password_strength.weak</source>
+            <target>Débil</target>
+          </segment>
+        </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+          <segment state="translated">
+            <source>user.password_strength.medium</source>
+            <target>Medio</target>
+          </segment>
+        </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+          <segment state="translated">
+            <source>user.password_strength.strong</source>
+            <target>Fuerte</target>
+          </segment>
+        </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+          <segment state="translated">
+            <source>user.password_strength.very_strong</source>
+            <target>Muy fuerte</target>
+          </segment>
+        </unit>
+    <unit id="U5IhkwB" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>¡Vamos!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.fr.xlf

@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="fr">
+  <file id="frontend.fr">
+    <unit id="lQ8QeGr" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Recherche</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>Composants</target>
+          </segment>
+        </unit>
+    <unit id="N66qZeD" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>Rechercher!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.hu.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="hu">
+  <file id="frontend.en">
+    <unit id="eLrezdb" name="search.placeholder">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+        <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+        <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+        <note priority="1">templates\base.html.twig:80</note>
+        <note priority="1">templates\base.html.twig:179</note>
+        <note priority="1">templates\base.html.twig:206</note>
+        <note priority="1">templates\base.html.twig:237</note>
+      </notes>
+      <segment state="translated">
+        <source>search.placeholder</source>
+        <target>Keresés</target>
+      </segment>
+    </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+      <segment state="translated">
+        <source>part.labelp</source>
+        <target>Alkatrészek</target>
+      </segment>
+    </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+      <segment state="translated">
+        <source>entity.select.group.new_not_added_to_DB</source>
+        <target>Új (még nem hozzáadva az adatbázishoz)</target>
+      </segment>
+    </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+      <segment state="translated">
+        <source>user.password_strength.very_weak</source>
+        <target>Nagyon gyenge</target>
+      </segment>
+    </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+      <segment state="translated">
+        <source>user.password_strength.weak</source>
+        <target>Gyenge</target>
+      </segment>
+    </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+      <segment state="translated">
+        <source>user.password_strength.medium</source>
+        <target>Közepes</target>
+      </segment>
+    </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+      <segment state="translated">
+        <source>user.password_strength.strong</source>
+        <target>Erős</target>
+      </segment>
+    </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+      <segment state="translated">
+        <source>user.password_strength.very_strong</source>
+        <target>Nagyon erős</target>
+      </segment>
+    </unit>
+    <unit id="U5IhkwB" name="search.submit">
+      <notes>
+        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+      </notes>
+      <segment state="translated">
+        <source>search.submit</source>
+        <target>Indítás!</target>
+      </segment>
+    </unit>
+  </file>
+</xliff>

translations/frontend.it.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="it">
+  <file id="frontend.it">
+    <unit id="eLrezdb" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Ricerca</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>Componenti</target>
+          </segment>
+        </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+          <segment state="translated">
+            <source>entity.select.group.new_not_added_to_DB</source>
+            <target>Nuovo (non ancora aggiunto al DB)</target>
+          </segment>
+        </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+          <segment state="translated">
+            <source>user.password_strength.very_weak</source>
+            <target>Molto debole</target>
+          </segment>
+        </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+          <segment state="translated">
+            <source>user.password_strength.weak</source>
+            <target>Debole</target>
+          </segment>
+        </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+          <segment state="translated">
+            <source>user.password_strength.medium</source>
+            <target>Media</target>
+          </segment>
+        </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+          <segment state="translated">
+            <source>user.password_strength.strong</source>
+            <target>Forte</target>
+          </segment>
+        </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+          <segment state="translated">
+            <source>user.password_strength.very_strong</source>
+            <target>Molto forte</target>
+          </segment>
+        </unit>
+    <unit id="U5IhkwB" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>Cerca!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.ja.xlf

@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="ja">
+  <file id="frontend.ja">
+    <unit id="lQ8QeGr" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>検索</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>部品</target>
+          </segment>
+        </unit>
+    <unit id="N66qZeD" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>検索</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.nl.xlf

@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="nl">
+  <file id="frontend.nl">
+    <unit id="lQ8QeGr" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Zoeken</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.pl.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="pl">
+  <file id="frontend.pl">
+    <unit id="eLrezdb" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Szukaj</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>Komponenty</target>
+          </segment>
+        </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+          <segment state="translated">
+            <source>entity.select.group.new_not_added_to_DB</source>
+            <target>Nowość (jeszcze niedodana do DB)</target>
+          </segment>
+        </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+          <segment state="translated">
+            <source>user.password_strength.very_weak</source>
+            <target>Bardzo słabe</target>
+          </segment>
+        </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+          <segment state="translated">
+            <source>user.password_strength.weak</source>
+            <target>Słabe</target>
+          </segment>
+        </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+          <segment state="translated">
+            <source>user.password_strength.medium</source>
+            <target>Średnie</target>
+          </segment>
+        </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+          <segment state="translated">
+            <source>user.password_strength.strong</source>
+            <target>Mocne</target>
+          </segment>
+        </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+          <segment state="translated">
+            <source>user.password_strength.very_strong</source>
+            <target>Bardzo mocne</target>
+          </segment>
+        </unit>
+    <unit id="U5IhkwB" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>Idź!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.ru.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="ru">
+  <file id="frontend.ru">
+    <unit id="eLrezdb" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>Поиск</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>Компоненты</target>
+          </segment>
+        </unit>
+    <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
+          <segment state="translated">
+            <source>entity.select.group.new_not_added_to_DB</source>
+            <target>Новый (еще не добавленный в БД)</target>
+          </segment>
+        </unit>
+    <unit id="9rnHbSK" name="user.password_strength.very_weak">
+          <segment state="translated">
+            <source>user.password_strength.very_weak</source>
+            <target>Очень слабый</target>
+          </segment>
+        </unit>
+    <unit id="gKHmHwM" name="user.password_strength.weak">
+          <segment state="translated">
+            <source>user.password_strength.weak</source>
+            <target>Слабый</target>
+          </segment>
+        </unit>
+    <unit id="c44gN8b" name="user.password_strength.medium">
+          <segment state="translated">
+            <source>user.password_strength.medium</source>
+            <target>Средний</target>
+          </segment>
+        </unit>
+    <unit id="NwiBLHc" name="user.password_strength.strong">
+          <segment state="translated">
+            <source>user.password_strength.strong</source>
+            <target>Сильный</target>
+          </segment>
+        </unit>
+    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
+          <segment state="translated">
+            <source>user.password_strength.very_strong</source>
+            <target>Очень сильный</target>
+          </segment>
+        </unit>
+    <unit id="U5IhkwB" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>Поехали!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/frontend.zh.xlf

@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="zh">
+  <file id="frontend.zh">
+    <unit id="lQ8QeGr" name="search.placeholder">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:67</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">Part-DB1\templates\AdminPages\EntityAdminBase.html.twig:19</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:61</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:27</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:43</note>
+            <note priority="1">Part-DB1\templates\_sidebar.html.twig:63</note>
+            <note priority="1">templates\AdminPages\EntityAdminBase.html.twig:9</note>
+            <note priority="1">templates\base.html.twig:80</note>
+            <note priority="1">templates\base.html.twig:179</note>
+            <note priority="1">templates\base.html.twig:206</note>
+            <note priority="1">templates\base.html.twig:237</note>
+          </notes>
+          <segment state="translated">
+            <source>search.placeholder</source>
+            <target>搜索</target>
+          </segment>
+        </unit>
+    <unit id="R4hoCqe" name="part.labelp">
+          <segment>
+            <source>part.labelp</source>
+            <target>部件</target>
+          </segment>
+        </unit>
+    <unit id="_cXCaLo" name="entity.select.group.new_not_added_to_DB">
+          <segment state="translated">
+            <source>entity.select.group.new_not_added_to_DB</source>
+            <target>新建（尚未添加到数据库）</target>
+          </segment>
+        </unit>
+    <unit id="RdFvZsb" name="user.password_strength.very_weak">
+          <segment state="translated">
+            <source>user.password_strength.very_weak</source>
+            <target>非常弱</target>
+          </segment>
+        </unit>
+    <unit id="IBjmblZ" name="user.password_strength.weak">
+          <segment state="translated">
+            <source>user.password_strength.weak</source>
+            <target>弱</target>
+          </segment>
+        </unit>
+    <unit id="qSm_ID0" name="user.password_strength.medium">
+          <segment state="translated">
+            <source>user.password_strength.medium</source>
+            <target>中</target>
+          </segment>
+        </unit>
+    <unit id="aWAaADS" name="user.password_strength.strong">
+          <segment state="translated">
+            <source>user.password_strength.strong</source>
+            <target>强</target>
+          </segment>
+        </unit>
+    <unit id="Wa9CStW" name="user.password_strength.very_strong">
+          <segment state="translated">
+            <source>user.password_strength.very_strong</source>
+            <target>非常强</target>
+          </segment>
+        </unit>
+    <unit id="N66qZeD" name="search.submit">
+          <notes>
+            <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
+            <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
+          </notes>
+          <segment state="translated">
+            <source>search.submit</source>
+            <target>GO!</target>
+          </segment>
+        </unit>
+  </file>
+</xliff>

translations/messages.cs.xlf

@@ -4025,16 +4025,6 @@ Pokud jste to provedli nesprávně nebo pokud počítač již není důvěryhodn
         <target>Reg.Ex. shoda</target>
       </segment>
     </unit>
-    <unit id="U5IhkwB" name="search.submit">
-      <notes>
-        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
-        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
-      </notes>
-      <segment state="translated">
-        <source>search.submit</source>
-        <target>Jdi!</target>
-      </segment>
-    </unit>
     <unit id="UXyo9ZT" name="project.labelp">
       <notes>
         <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:37</note>
@@ -11224,36 +11214,6 @@ Element 3</target>
         <target>Není uveden žádný textový obsah! Popisky zůstanou prázdné.</target>
       </segment>
     </unit>
-    <unit id="9rnHbSK" name="user.password_strength.very_weak">
-      <segment state="translated">
-        <source>user.password_strength.very_weak</source>
-        <target>Velmi slabé</target>
-      </segment>
-    </unit>
-    <unit id="gKHmHwM" name="user.password_strength.weak">
-      <segment state="translated">
-        <source>user.password_strength.weak</source>
-        <target>Slabé</target>
-      </segment>
-    </unit>
-    <unit id="c44gN8b" name="user.password_strength.medium">
-      <segment state="translated">
-        <source>user.password_strength.medium</source>
-        <target>Střední</target>
-      </segment>
-    </unit>
-    <unit id="NwiBLHc" name="user.password_strength.strong">
-      <segment state="translated">
-        <source>user.password_strength.strong</source>
-        <target>Silné</target>
-      </segment>
-    </unit>
-    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
-      <segment state="translated">
-        <source>user.password_strength.very_strong</source>
-        <target>Velmi silné</target>
-      </segment>
-    </unit>
     <unit id="m.RBg6w" name="perm.users.impersonate">
       <segment state="translated">
         <source>perm.users.impersonate</source>
@@ -13495,5 +13455,14 @@ Vezměte prosím na vědomí, že se nemůžete vydávat za uživatele se zakáz
         <target>Uživatelé</target>
       </segment>
     </unit>
+        <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+            <notes>
+                <note priority="1">Do not remove! Used for datatables rendering.</note>
+            </notes>
+            <segment state="translated">
+                <source>datatable.datatable.lengthMenu</source>
+                <target>_MENU_</target>
+              </segment>
+        </unit>
   </file>
-</xliff>
+</xliff>

translations/messages.da.xlf

@@ -4032,16 +4032,6 @@ Bemærk også, at uden to-faktor-godkendelse er din konto ikke længere så godt
         <target>Reg. Ex. matching</target>
       </segment>
     </unit>
-    <unit id="N66qZeD" name="search.submit">
-      <notes>
-        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
-        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
-      </notes>
-      <segment state="translated">
-        <source>search.submit</source>
-        <target>Kom nu!</target>
-      </segment>
-    </unit>
     <unit id="w0jVACo" name="project.labelp">
       <notes>
         <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:37</note>
@@ -11256,36 +11246,6 @@ Oversættelsen
         <target>Intet tekstindhold angivet! De oprettede etiketter vil være tomme.</target>
       </segment>
     </unit>
-    <unit id="RdFvZsb" name="user.password_strength.very_weak">
-      <segment state="translated">
-        <source>user.password_strength.very_weak</source>
-        <target>Meget svag</target>
-      </segment>
-    </unit>
-    <unit id="IBjmblZ" name="user.password_strength.weak">
-      <segment state="translated">
-        <source>user.password_strength.weak</source>
-        <target>Svag</target>
-      </segment>
-    </unit>
-    <unit id="qSm_ID0" name="user.password_strength.medium">
-      <segment state="translated">
-        <source>user.password_strength.medium</source>
-        <target>Middel</target>
-      </segment>
-    </unit>
-    <unit id="aWAaADS" name="user.password_strength.strong">
-      <segment state="translated">
-        <source>user.password_strength.strong</source>
-        <target>Stærk</target>
-      </segment>
-    </unit>
-    <unit id="Wa9CStW" name="user.password_strength.very_strong">
-      <segment state="translated">
-        <source>user.password_strength.very_strong</source>
-        <target>Meget stærk</target>
-      </segment>
-    </unit>
     <unit id="6OHd5fv" name="perm.users.impersonate">
       <segment state="translated">
         <source>perm.users.impersonate</source>
@@ -12164,5 +12124,14 @@ Bemærk venligst, at du ikke kan kopiere fra deaktiveret bruger. Hvis du prøver
         <target>Brugere</target>
       </segment>
     </unit>
+    <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+        <notes>
+            <note priority="1">Do not remove! Used for datatables rendering.</note>
+        </notes>
+        <segment state="translated">
+            <source>datatable.datatable.lengthMenu</source>
+            <target>_MENU_</target>
+          </segment>
+    </unit>
   </file>
-</xliff>
+</xliff>

translations/messages.el.xlf

@@ -1638,5 +1638,14 @@
         <target>Κατασκευαστές</target>
       </segment>
     </unit>
+    <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+        <notes>
+            <note priority="1">Do not remove! Used for datatables rendering.</note>
+        </notes>
+        <segment state="translated">
+            <source>datatable.datatable.lengthMenu</source>
+            <target>_MENU_</target>
+          </segment>
+    </unit>
   </file>
-</xliff>
+</xliff>

translations/messages.es.xlf

@@ -4024,16 +4024,6 @@ Subelementos serán desplazados hacia arriba.</target>
         <target>Reg.Ex. Matching</target>
       </segment>
     </unit>
-    <unit id="U5IhkwB" name="search.submit">
-      <notes>
-        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
-        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
-      </notes>
-      <segment state="translated">
-        <source>search.submit</source>
-        <target>¡Vamos!</target>
-      </segment>
-    </unit>
     <unit id="UXyo9ZT" name="project.labelp">
       <notes>
         <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:37</note>
@@ -11242,36 +11232,6 @@ Elemento 3</target>
         <target>¡No se ha dado contenido de texto! Las etiquetas permanecerán vacías.</target>
       </segment>
     </unit>
-    <unit id="9rnHbSK" name="user.password_strength.very_weak">
-      <segment state="translated">
-        <source>user.password_strength.very_weak</source>
-        <target>Muy débil</target>
-      </segment>
-    </unit>
-    <unit id="gKHmHwM" name="user.password_strength.weak">
-      <segment state="translated">
-        <source>user.password_strength.weak</source>
-        <target>Débil</target>
-      </segment>
-    </unit>
-    <unit id="c44gN8b" name="user.password_strength.medium">
-      <segment state="translated">
-        <source>user.password_strength.medium</source>
-        <target>Medio</target>
-      </segment>
-    </unit>
-    <unit id="NwiBLHc" name="user.password_strength.strong">
-      <segment state="translated">
-        <source>user.password_strength.strong</source>
-        <target>Fuerte</target>
-      </segment>
-    </unit>
-    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
-      <segment state="translated">
-        <source>user.password_strength.very_strong</source>
-        <target>Muy fuerte</target>
-      </segment>
-    </unit>
     <unit id="m.RBg6w" name="perm.users.impersonate">
       <segment state="translated">
         <source>perm.users.impersonate</source>
@@ -12336,5 +12296,14 @@ Por favor ten en cuenta que no puedes personificar a un usuario deshabilitado. S
         <target>Usuarios</target>
       </segment>
     </unit>
+    <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+        <notes>
+            <note priority="1">Do not remove! Used for datatables rendering.</note>
+        </notes>
+        <segment state="translated">
+            <source>datatable.datatable.lengthMenu</source>
+            <target>_MENU_</target>
+          </segment>
+    </unit>
   </file>
-</xliff>
+</xliff>

translations/messages.fr.xlf

@@ -4014,16 +4014,6 @@ Si vous avez fait cela de manière incorrecte ou si un ordinateur n'est plus fia
         <target>Reg.Ex. Correspondance</target>
       </segment>
     </unit>
-    <unit id="N66qZeD" name="search.submit">
-      <notes>
-        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
-        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
-      </notes>
-      <segment state="translated">
-        <source>search.submit</source>
-        <target>Rechercher!</target>
-      </segment>
-    </unit>
     <unit id="Kw3N1AA" name="actions">
       <notes>
         <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:2</note>
@@ -9076,5 +9066,14 @@ exemple de ville</target>
         <target>Utilisateurs</target>
       </segment>
     </unit>
+    <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+        <notes>
+            <note priority="1">Do not remove! Used for datatables rendering.</note>
+        </notes>
+        <segment state="translated">
+            <source>datatable.datatable.lengthMenu</source>
+            <target>_MENU_</target>
+          </segment>
+    </unit>
   </file>
-</xliff>
+</xliff>

translations/messages.hu.xlf

@@ -3952,16 +3952,6 @@
         <target>Reguláris kifejezés egyezés</target>
       </segment>
     </unit>
-    <unit id="U5IhkwB" name="search.submit">
-      <notes>
-        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
-        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
-      </notes>
-      <segment state="translated">
-        <source>search.submit</source>
-        <target>Indítás!</target>
-      </segment>
-    </unit>
     <unit id="UXyo9ZT" name="project.labelp">
       <notes>
         <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:37</note>
@@ -11157,36 +11147,6 @@
         <target>Nincs szöveges tartalom megadva! A címkék üresek maradnak.</target>
       </segment>
     </unit>
-    <unit id="9rnHbSK" name="user.password_strength.very_weak">
-      <segment state="translated">
-        <source>user.password_strength.very_weak</source>
-        <target>Nagyon gyenge</target>
-      </segment>
-    </unit>
-    <unit id="gKHmHwM" name="user.password_strength.weak">
-      <segment state="translated">
-        <source>user.password_strength.weak</source>
-        <target>Gyenge</target>
-      </segment>
-    </unit>
-    <unit id="c44gN8b" name="user.password_strength.medium">
-      <segment state="translated">
-        <source>user.password_strength.medium</source>
-        <target>Közepes</target>
-      </segment>
-    </unit>
-    <unit id="NwiBLHc" name="user.password_strength.strong">
-      <segment state="translated">
-        <source>user.password_strength.strong</source>
-        <target>Erős</target>
-      </segment>
-    </unit>
-    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
-      <segment state="translated">
-        <source>user.password_strength.very_strong</source>
-        <target>Nagyon erős</target>
-      </segment>
-    </unit>
     <unit id="m.RBg6w" name="perm.users.impersonate">
       <segment state="translated">
         <source>perm.users.impersonate</source>
@@ -14049,5 +14009,14 @@
         <target>Tömeges importálási feladat alkatrészek</target>
       </segment>
     </unit>
+    <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+        <notes>
+            <note priority="1">Do not remove! Used for datatables rendering.</note>
+        </notes>
+        <segment state="translated">
+            <source>datatable.datatable.lengthMenu</source>
+            <target>_MENU_</target>
+          </segment>
+    </unit>
   </file>
-</xliff>
+</xliff>

translations/messages.it.xlf

@@ -4026,16 +4026,6 @@ Se è stato fatto in modo errato o se un computer non è più attendibile, puoi
         <target>Corrispondenza Reg.Ex.</target>
       </segment>
     </unit>
-    <unit id="U5IhkwB" name="search.submit">
-      <notes>
-        <note category="file-source" priority="1">Part-DB1\templates\_navbar_search.html.twig:68</note>
-        <note priority="1">Part-DB1\templates\_navbar_search.html.twig:62</note>
-      </notes>
-      <segment state="translated">
-        <source>search.submit</source>
-        <target>Cerca!</target>
-      </segment>
-    </unit>
     <unit id="UXyo9ZT" name="project.labelp">
       <notes>
         <note category="file-source" priority="1">Part-DB1\templates\_sidebar.html.twig:37</note>
@@ -11244,36 +11234,6 @@ Element 3</target>
         <target>Nessun contenuto di testo specificato! Le etichette generate saranno vuote.</target>
       </segment>
     </unit>
-    <unit id="9rnHbSK" name="user.password_strength.very_weak">
-      <segment state="translated">
-        <source>user.password_strength.very_weak</source>
-        <target>Molto debole</target>
-      </segment>
-    </unit>
-    <unit id="gKHmHwM" name="user.password_strength.weak">
-      <segment state="translated">
-        <source>user.password_strength.weak</source>
-        <target>Debole</target>
-      </segment>
-    </unit>
-    <unit id="c44gN8b" name="user.password_strength.medium">
-      <segment state="translated">
-        <source>user.password_strength.medium</source>
-        <target>Media</target>
-      </segment>
-    </unit>
-    <unit id="NwiBLHc" name="user.password_strength.strong">
-      <segment state="translated">
-        <source>user.password_strength.strong</source>
-        <target>Forte</target>
-      </segment>
-    </unit>
-    <unit id="Bw.iCUm" name="user.password_strength.very_strong">
-      <segment state="translated">
-        <source>user.password_strength.very_strong</source>
-        <target>Molto forte</target>
-      </segment>
-    </unit>
     <unit id="m.RBg6w" name="perm.users.impersonate">
       <segment state="translated">
         <source>perm.users.impersonate</source>
@@ -12338,5 +12298,14 @@ Notare che non è possibile impersonare un utente disattivato. Quando si prova a
         <target>Utenti</target>
       </segment>
     </unit>
+    <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
+        <notes>
+            <note priority="1">Do not remove! Used for datatables rendering.</note>
+        </notes>
+        <segment state="translated">
+            <source>datatable.datatable.lengthMenu</source>
+            <target>_MENU_</target>
+          </segment>
+    </unit>
   </file>
-</xliff>
+</xliff>