Part-DB 2.9.1

Improvements

• Removed MPN fallback from LCSC barcode scanner, the SPN field is used instead for part matching (#1302)
• Automatically detect the delimiter on generic CSV BOM imports

Bug fixes

• Fixed intendation of EDA visibility checkboxes
• Fixed SAML login button (#1308, thanks to @mowoe)
• Fixed problem of GenericWeb info provider when used behind traefik (#1296)
• Fixed 500 error, when mapping in generic CSV BOM import fails (#1298)
• Fixed 500 error with displaying part prices, when a user has a currency preference different of base currency, and there is no conversion rate known for it (#1317)

Miscellaneous

• Updated dependencies
• Updated translations
• Updated kicad symbols

New Contributors

• @mowoe made their first contribution in #1308

Full Changelog: v2.9.0...v2.9.1

Part-DB 2.9.0

New feautures

• Sidebar trees keep track of page navigations. If you open a certain category, the treenode will be hightlighted
• Show a "Show password" toggle on all password inputs, including login form
• Made form fields wider on large monitors, to remove useless whitespace
• Reset opcache after update manager update (thanks @Sebbeben, PR #1288)
• Allow to create manual backups and download them from the WebUI (thanks @Sebbeben, PR #1255)
• Added user_barcode_filter to API (thanks @MayNiklas, PR #1280)
• Show manufacturing status in project BOM table (thanks @mkne, #1289)
• Create a part lot with quantity, user barcode and order number based on digikey, lcsc or mouser barcode, to reduce amount of manual input

Bug fixes

• Do not scroll sidebar to top, when clicking a tree node
• Fixed description field on KiCAD 9.0.5 and 9.0.6 (#1289)
• Generate correct url for part lots barcode content label placeholders (#1268)
• Correctly import files, where only children elements are specified and no parent field (#1272)
• Clear the input after selecting an option in tomselect (#1264)

Miscellaneous

• Updated dependencies

Full Changelog: v2.8.1...v2.9.0

Part-DB 2.8.1

Bug fixes

• Security hardening for some endpoints
• Fixed minor unauthorized information leackage in IPN generation endpoint (#1283)
• Fixed problem with creating digikey parts from barcode when it contained a CREF (#1283)
• Use cache:pool:clear --all for more thorough cache clearing in update process
• Moved settings cache to cache.system adapter, to ensure its cleared on cache:clear (prevents #1279)
• Fixed problem that flash messages were not shown in admin pages

Miscellaneous

• Updated dependencies
• Updated kicad library files

Full Changelog: v2.8.0...v2.8.1

Part-DB 2.8.0

New features

• Allow to add parts from barcode scans of LCSC, digikey and other vendor labels (thanks @swdee)
• Allow to scan LCSC labels
• Added Amazon info provider via Canopy API
• Added an optional HTML sandbox for attachments, allowing to view interactive BOM HTML files inside Part-DB (#1150)
• Add option to disable special character keybindings (#1251, thanks @MayNiklas)
• Improve working with an external barcode scanner, allow scanning barcodes from everywhere
• Make KiCad API better cachable (#1241, thanks @Sebbeben)
• Make parameters and order informations visible in KiCad (#1241, thanks @Sebbeben)
• Show EDA value and reference in part tables (#1266, thanks @hrueger)

Miscellaneous

• Updated dependencies
• Updated translations
• Updated KiCad library autocomplete lists
• Security hardening of attachments

New Contributors

• @hrueger made their first contribution in #1266

Full Changelog: v2.7.1...v2.8.0

Part-DB 2.7.1

Bug fixes

• Fixed problem that stocktake date of part lot was required when editing part (#1250)
• Fixed problem that part tables had wrong sorting on initial loading
• Fixed german translations related to update manager
• Fixed visual styling of lot table

Part-DB 2.7.0

New features

• Allow to set GTIN / EAN numbers for parts
• Some info providers allow to provide GTIN infos
• Allow to mark if supplier prices contain VAT or not. This is especially useful in combination with info providers
• Allow to restrict on which element types attachment types can be applied. For example the "Avatars" attachmen type can only be shown on user attachments
• Added ability to stocktake part lots from info page. This easily allows for setting a specific amount, instead of just adding/removing from an database value. The stocktake date is stored, to give a hint on how reliable the amount left is.
• Delegate part retrieval to buerklin info provider when an buerklin URL is given (@mkne, PR #1235)
• Added API endpoint for label generation (@MayNiklas, PR #1234)
• Added functions to twig labels to retrieve associated parts. This allows to print all parts contained in a storage location (#1239)

Improvements

• Performance optimizations for parts tables
• Autofocus fields for easier workflow (@d-buchmann, PR #1240)
• Allow more functions and filters in twig labels

Bug fixes

• Fixed issue when parts contained % in name (@d-buchmann, PR #1238)
• Do not show a 500 error, if twig labels contains invalid code
• Fixed german translations

Docker

• Removed nodejs from docker images as it is only needed for frontend building. This makes images ~ 25% smaller
• Optimized docker image build flow

Miscellaneous

• Updated dependencies
• Updated GNU Unifont to 17.0.3

Full Changelog: v2.6.0...v2.7.0

Part-DB 2.6.0

New features

• Experimental update manager, to update Part-DB from the web interface (thanks to @Sebbeben, PR #1217)
• Added Conrad info provider
• Added a generic info provider, to retrieve basic part infos from many shop URLs
• Allow BOM import via SPNs (thanks @MayNiklas, PR #1209)
• Highlight scanned part lot when scanning a barcode (#968)

Miscellaneous

• Updated dependencies

New Contributors

• @Sebbeben made their first contribution in #1217

Full Changelog: v2.5.1...v2.6.0

Part-DB 2.5.1

Improvements

• When using the "upload files" button automatically determine a fitting attachment type based on extension
• Support SPN columns for all suppliers as columns in BOM imports, not only LCSC (PR#1208, thanks @MayNiklas)

Bug fixes

• Disable the ID search by default, like intended in PR #1184
• Use correct language for sidebar trees, even if no user is logged in
• Prevent ordering of extra column in log tables, as this errors on Postgres and has no real use
• Show an error popup instead of a 500 page when info provider retrieval fails
• Added clear button for part select input in BOMs (#1156)

Miscellaneous

• Updated dependencies
• Updated translations

New Contributors

• @MayNiklas made their first contribution in #1208

Full Changelog: v2.5.0...v2.5.1

Part-DB 2.5.0

New features

• Added console command to change database platform (e.g. from sqlite to mysql, or mysql to postgresql)
• Added a ability to search for part IDs from searchfields (thanks @kernchen-brc, #1184)

Improvements

• Do not mark new categories excluded from simulation in KiCAD, to avoid annoying symbols in KiCad (thanks @lukas-runge , #1192)
• Optimized frontend file sizes a bit

Bug fixes

• Fixed OEMSecretsProvider (thanks @d-buchmann, #1187)
• Fixed CSRF issue with barcode scanner (thanks @swdee, #1197)

Miscellaneous

• Updated dependencies

New Contributors

• @kernchen-brc made their first contribution in #1184
• @swdee made their first contribution in #1191
• @lukas-runge made their first contribution in #1192

Full Changelog: v2.4.0...v2.5.0

Part-DB 2.4.0

New features

• Added info provider for Buerklin (thanks to @mkne, #1151)
• Show part IDs in project BOMs

Improvements

• Use more performant hash algorithms for cache keys
• Increase label generator PDF preview height to show PDF toolbar (@mkne , #1171)
• Show info provider capabilities in fixed order

Bug fixes

• Fixed exception if DigiKey has no media for a part (#1154)

Miscellaneous

• Updated dependencies

New Contributors

• @fsbrc made their first contribution in #1168

Full Changelog: v2.3.0...v2.4.0

Part-DB 2.3.0

New features

• Added the ability to define custom part states (PR #1053, thanks to @webdevinition)
• Added the ability to automatically suggest and generate IPNs (PR #1054, thanks to @webdevinition)
• Added experimental ability to rename datastructure types with the new synonym system, which allows you to define domain specific names for concepts of "parts", "categories", etc. (thanks @webdevinition)

Improvements

• Improved ability to determine category from info provider (#1113)
• Do not require a trailing slash for DEFAULT_URI (#1118)
• Define preview images for partkeepr imports (#1115)

Bug fixes

• Allow long URLs for attachments (#1022)
• Fixed issues related to mass import form (#1102, #1103, #1104)

Docker

• Added COMPOSER_EXTRA_PACKAGES env to docker containers, to install additional composer packages, like email bridges (#1138)

Miscellaneous

• Improved translations
• Updated dependencies
• Improved documentation

New Contributors

• @webdevinition made their first contribution in #1053
• @Copilot made their first contribution in #1124

Full Changelog: v2.2.1...v2.3.0

Part-DB 2.2.1

New features

• Load translations for Ckeditor
• Added an option to select which languages should be shown in the language dropdown menu
• Added hungarian translations (thanks to @Krissz, PR#1081)
• Added option to configure if part tables for categories, etc. should include child categories by default (#1077)
• Improved alignment of part parameter tables (#1066)
• Show an better error message if Digikey provider needs OAuth reconnection

Bug fixes

• Fixed problem when trying to geneate multiple labels (#1070)
• Made settings category titles translatable (#1037)
• Fixed placeholder plugin for label editor (#1056)
• Fixed compatibility with PHP 8.5
• Do not remove BOM entry if a part is deleted (#1068)
• Fixed problem that group permissions preset were wrongfully applies (#1039)
• Fixed problem of wrong number of buildable projects on empty project (#1038)
• Fixed problem if search keyword contained % (#1075)
• Fixed problem with tomselect in modals (#1073)

Miscellaneous

• Updated dependencies
• Improved documentation
• Optimzed part table performance under certain conditions

Full Changelog: v2.2.0...v2.2.1

Part-DB 2.2.0

New features

• Added xlsx/xls import/export for parts (thanks to @barisgit, PR #1036)
• Allow to update many parts at once from information providers (thanks @barisgit, PR #1036)
• Optimized part tables performance

Bug fixes

• Fixed problem with mouser and chinese yuan as currency (#1045)

Miscellaneous

• Improved translations
• Updated dependencies
• Use php's native lazy objects on PHP8.4+, this should help to reduce performance overheads

Full Changelog: v2.1.2...v2.2.0

Part-DB 2.1.2

Bug fixes

• Fixed problem that default info provider option could not be empty (#1032)

Miscellaneous

• Improved translations

Part-DB 2.1.1

Bug fixes

• Fixed problem that tree views were not properly highlighted anymore

Part-DB 2.1.0

New features

• Added new exchange rate provider, that allow for more foreign currencies without need for fixer.io
• Show what permissions a user is lacking in case of an access denied message
• Do not mark relative links in markdown as external and open in new tab (thanks @d-buchmann)
• Added option to import BOM files from KiCAD schematic editor and generic CSV files (thanks @barisgit)
• Added an button to update label profiles directly from the label generator.
• Allow to customize what items get shown at homepage (#470, #894)
• Allow to hide version number at homepage
• Allow to disable the extraction of parameters from part notes and description (#747)
• Allow to select default info providers for a provider search (#556)
• Made image size in part tables configurable
• Made part table action bar sticky and floating to make it better visible and improve UX

Bug fixes

• Allow import of label profiles (thanks @d-buchmann)
• Fixed problem with currency admin (#1009)
• Fixed LCSC provider (#1018)
• Fixed CKeditor text color in dark mode (#1016)
• Use better tilde symbols for LCSC provider data (@d-buchmann, #989)
• Fixed pollin info provider (#1015)
• Prevent that label profiles with duplicate names get created (#994)
• Readdeed option to show all entries of a table

Miscellaneous

• Updated dependencies
• Improved documentation
• Updated GNU Unifont

Full Changelog: v2.0.2...v2.1.0

Part-DB 2.0.2

This upgrade introduces a new web based configuration system. Existing configuration using environment variables will continue to work. If you want to configure these parameters via the WebUI in the future, an additional migration step is required. See the upgrade guide for more information.

Bug fixes

• Properly pass environment variables to Part-DB in jbtronics/partdb1 docker image to prevent startup issues (issue #1006)

Improvements

• Updated translations
• Do not pollute docker error logs with deprecation notices

Full Changelog: v2.0.0...v2.0.1

Part-DB 2.0.1

This upgrade introduces a new web based configuration system. Existing configuration using environment variables will continue to work. If you want to configure these parameters via the WebUI in the future, an additional migration step is required. See the upgrade guide for more information.

Bug fixes (compared to 2.0.0)

• Fixed broken english translations
• Fixed problem that wrong column was sorted after columns were reordered in a table

Full Changelog: v2.0.0...v2.0.1

Part-DB 2.0.0

This upgrade introduces a new web based configuration system. Existing configuration using environment variables will continue to work. If you want to configure these parameters via the WebUI in the future, an additional migration step is required. See the upgrade guide for more information.

Breaking changes

• Part-DB now requires at least PHP 8.2 or higher. If you are still using PHP 8.1 you need to upgrade PHP first
• Nodejs 20 or higher is now required
• The config/banner.md file does not exist anymore. If you wanna customize the banner, either do it via the WebUI or the BANNER env.
• The parameters partdb.sidebar.items, partdb.sidebar.root_node_enable and partdb.sidebar.root_expanded in config/parameters.yaml,
  were removed. You can configure them now directly in the admin interface.

New features

• Introduced capability to configure system settings and info providers via the WebUI. No need to work with environment variables anymore
• Improved emoji dialog for rich text editor

Miscellaneous

• Updated dependencies

Full Changelog: v1.17.4...v2.0.0

Part-DB 1.17.3

Bug fixes

• Pass the proxy related settings to the docker application (issue #1001)

Full Changelog: v1.17.3...v1.17.4

Part-DB 1.17.3

Bug fixes

• Fixed a potential denial of service issue related to user avatars (thanks to @NaklehZeidan21)
• Fixed problem with mass creation dialog (#993)

Miscellaneous

• Updated dependencies

Part-DB 1.17.2

New features

• Added option to disable image overlay on part detail pages (#960, thanks @d-buchmann)
• Allow to use the percentage sign directly as unit in parameters, without needing to latex escape it
• Pass supplier part number info to KiCad as custom field (#955, thanks @barisgit)
• Add fields for KiCost KiCad plugin, so that you can easily create a BOM from the information (#910)

Bug fixes

• Fixed typos in info provider description (#942, thanks @d-buchmann)
• Link project root node to edit project page instead of listing all parts (#957, thanks @d-buchmann)
• Fixed problems if parameter value was 0 (#959, thanks @d-buchmann)

What's Changed

• Fix typo and copy-paste error by @d-buchmann in #942
• fix sidebar root node links by @d-buchmann in #957
• Add env option to disable part image overlay by @d-buchmann in #960
• Update AbstractParameter.php by @d-buchmann in #959
• Add supplier information to KiCad part exports by @barisgit in #955

Miscellaneous

• Updated dependencies

New Contributors

• @barisgit made their first contribution in #955

Full Changelog: v1.17.1...v1.17.2

Part-DB 1.17.1

Security fixes

Until this version, users could upload SVG files containing JS code, that would be executed if a user opened the SVG in a new tab, allowing for a XSS vulnerability. This was only possible if the SVG files were explicitly opened in a new tab, if the file was embedded inside a Part-DB tab, then there was no risk.

Since this version, SVG files gets sanitized during upload, to prevent any JS code execution. If you have existing SVG files, you can sanitize them, by running the console command php bin/console partdb:attachments:sanitize-svg.

If you are using Part-DB with nginx, you should add the following block to your server configuration, to further harden it by setting a content security policy for SVG files.

# Set Content-Security-Policy for svg files, to block embedded javascript in there
    location ~* \.svg$ {
        add_header Content-Security-Policy "default-src 'self'; script-src 'none'; style-src 'self' 'unsafe-inline'; img-src 'self' data:; frame-ancestors 'none';";
    }

For apache, this is done automatically in the .htaccess file of Part-DB.

New features

• Added barcode placeholders for C93 and datamatrix barcodes (#931, thanks to @monoxide13)

Miscellaneous

• Updated translations
• Updated dependencies

New Contributors

• @monoxide13 made their first contribution in #931

Full Changelog: v1.17.0...v1.17.1

Part-DB 1.17.0

Changes

• Use Digikey V4 API for digikey provider (by @Danixu in #875)

New features

• Added a way to change the location of parts as batch action, as long as they contain only one lot.
• Improved attachment download compatibility (thanks @Treeed)
• Show digikey packing type (tape&Reel, Box, etc.) in info provider search list
• Render units of parameters with Latex (#856)
• Added a command to download all external-only attachments to the local file system (php bin/console partdb:attachments:download)
• Added an experimental automigration feature to docker image. Set DB_AUTOMIGRATE to true in your docker-compose file to automatically apply database migrations on container startup.

Bug fixes

• Fixed bugs for pollin info provider
• Workaround a bug in KiCAD which could cause a crash (#878)
• Use own CA bundle for element14 provider, to workaround missing CA in debian (#891, #866)
• Fixed problems with mouser info provider, where part numbers could not be resolved to a unique part (#888, #616)
• Fixed 500 if internal attachment path was not resolvable to an URL (#898)
• Fixed problem that global_theme config param was ignored (#880)
• Fixed problem, that categories did not appear in KiCAD, even though they contained visible parts (#885)
• Make database migrationn more compliant with SQL standard (#900)

Miscellaneous

• Updated translations
• Updated dependencies

New Contributors

• @Danixu made their first contribution in #875

Full Changelog: v1.16.1...v1.17.0

Part-DB 1.16.1

Bug fixes

• Fixed LCSC provider (PR #873, @mkne)

Miscellaneous

• Updated translations
• Optimized database migration (this might fix issue #873)

Full Changelog: v1.16.0...v1.16.1

Part-DB 1.16.0

New features

• Added info providers for the german vendors reichelt.com and pollin.de. They use webscraping of the shop pages, as no official API is provider. Use at your own risk!
• Improved inputting/editing of attachment parts (made it easily editable and highlightable) (PR #849 @Treeed)
• Updated KiCAD EDA library list for EDA info autocomplete to latest KiCad version
• Improved attachment system. Attachments now keep the external URL info if a file was downloaded, so that you can track that later (PR #848, @Treeed)
• Added additional sorting and filter possibilities in attachments table
• Use newer farnell/element14 API version. This allows to retrieve the correct URL to products in farnell shop and gives us additional part description that will be put into the notes field in Part-DB

Bug fixes

• Fixed attachment statistics for sqlite (PR #847 @Treeed)
• Fixed problem with duplicate fields in jsonapi API schema description (issue #862)
• Fixed problem with wrong/missing API docs in some cases (issue #851)

Miscellaneous

• Updated dependencies
• Fixed some deprecation warnings
• Improved documentation

New Contributors

• @felbinger made their first contribution in #852

Full Changelog: v1.15.2...v1.16.0

Part-DB 1.15.2

If you are using Part-DB it would be helpful if you fill out this short survey on your usage of Part-DB (Google Forms): https://forms.gle/Q15twx3YYq3qCNfe8

If you like Part-DB, please consider donating to help further development. See the sponsor button on the homepage.

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Changes and Improvements

• Deprecated GET_GROSS_PRICES env for TME provider with TME private access token, as it is ignored then and whether VAT is included or not in prices depends on account type
• Removed to show "All" entries in a log table, as the log can easily contain thousands of entries, that would most likely in an out of memory exception on server (see issue #835)
• If an info provider returns multiple attachments or parameters with the same name, they will be suffixed with a number (e.g. Param, Param (2), Param (3), etc.), so that they can be saved, without manually needing to edit their names (as Part-DB wants a unique name for them). See issue #840

Bug fixes

• Prevent error with TME info provider, if using TME private access key (issue #838)
• Fixed exception when exporting an empty list (issue #836)

Miscellaneous

• Updated dependencies
• Improved translations (thanks @mkne)
• Improved documentation (thanks @mkne)

Full Changelog: v1.15.1...v1.15.2

Part-DB 1.15.1

If you are using Part-DB it would be helpful if you fill out this short survey on your usage of Part-DB (Google Forms): https://forms.gle/Q15twx3YYq3qCNfe8

If you like Part-DB, please consider donating to help further development. See the sponsor button on the homepage.

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Bugfixes

• Fixed problem that frontend assets could not be loaded properly if serving Part-DB under a prefixed path (issue #824)

Miscellaneous

• Updated dependencies

Full Changelog: v1.15.0...v1.15.1

Part-DB 1.15.0

If you are using Part-DB it would be helpful if you fill out this short survey on your usage of Part-DB (Google Forms): https://forms.gle/Q15twx3YYq3qCNfe8

If you like Part-DB, please consider donating to help further development. See the sponsor button on the homepage.

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

New features / Improvements

• Updated CKEditor to v41, which should load faster
• Show when a part already exists, when trying to add new parts from info provider (thanks to @Treeed)
• Allow to scan the EIGP114 barcodes on digikey and mouser parts to directly reference parts (thanks to @Treeed)
• Added the possibility to decode and view the content of barcodes (especially EIPG114)
• Allow to map categories from info providers to local categories, using the "alternative names" of local categories
• Highly improved barcode scanner, which should be much faster and more reliable and even a bit smaller than the old one
• Allow to directly save the current label options to a label profile (see issue #806)
• Do not preselect a category when creating a new part, so that users must explicitly select a category and not save one accidentally

Bugfixes

• Fixed LCSC provider (see issue #790), thanks to @vvekic
• Fixed sizing of text in the label editor field
• Fixed "Scan from image" feature of barcode scanner
• Fixed problem that API PATCH operations to parts touched unrelated fields (issue #800)

Miscellaneous

• Updated dependencies
• Updated translations
• Updated documentation

New Contributors

• @b-nagaj made their first contribution in #788
• @vvekic made their first contribution in #795
• @Treeed made their first contribution in #810

Full Changelog: v1.14.5...v1.15.0

Part-DB 1.14.5

If you like Part-DB, please consider donating to help further development. See the sponsor button on the homepage.

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Changes

• Updated docker container PHP to PHP 8.3
• Use a different format for log files (plain text instead of JSON encoding). This should be easier to read and output shorter lines (see #781)
• Fixed problem that PostgresSQL searches were case sensitive. Now they are case-insentive to have the same and more useful behavior as on SQLIte and MySQL (see #784)

Improvements

• Allow usernames to contain @ sign (as long as it is not the first char) to allow email addresses as username (see #772)

Bugfixes

• Fixed errors, when accessing Part-DB via link-local IPv6 addresses (#782)
• Allow longer error lines in docker container. (#781)
• Fixed problem that SAML users could not access API via tokens (#765)

Miscellaneous

• Updated dependencies
• Updated translations

Full Changelog: v1.14.4...v1.14.5