daxxn/partsholeapi

API for PartsHole client - Inventory management for electronics components

PartsHoleAPI

An API for managing all communication between the Client and the database.

Overview

The need for managing all the parts and tiny components needed for complex PCBs can get out of hand extremely quickly. It gets even worse when different parts have different packages and footprints. Other components like resistors and capacitors have hundreds of different values and sizes. Its alot.

Features and Responibilities

• Serve the Client Data
• Databse Management
• Invoice Parsing
• BOM File Parsing
• Location (Bin) Management
• Custom Part Number Creation

Future Plans

• Invoice reading directly through DigiKey
• Order parts from DigiKey
• Parse KiCAD Project/Library files to access to more data (Change part numbers, Update supplier part numbers)

Installation

Prerequisites

The database is set up to use MongoDB Atlas. Its the easiest to set up and deploy for me. That means a MongoDB database is required.

Auth0 is used for authentication. Auth0 Client and API projects are required.

Other Dependencies

• CSV Parser Library - Daxxn

partsholeapi's Issues

Integrate With Mouser API

Add the ability for the API to directly communicate with Mousers' API.

Requirements

• Add API calls
• Integrate with InvoiceModel
• Add calls to update customer part numbers (PartModel.Reference) in Mousers' system automatically (If possible.)

Add Project and BOM Collections

The Problem

As of right now, the project model isn't included in the database and will only parse one BOM. Projects need to be able to contain multiple BOMs. As there's now multiple projects I'm working on that have upward of 3 PCBs, the ability to control what BOM and revision is current on a project will be extremely useful.

Requirements

• Change project to allow for multiple BOMs to be associated with a project
• Separate BOMs and projects
• Add Project collection to API
• Add BOM collection to API
• Client controls to allow for project creation
• Client controls to tie BOMs to a project
• Client communication with API

Integrate With DigiKey API

Add the ability for the API to directly communicate with DigiKeys' API.

Requirements

• Add API calls
• Integrate with InvoiceModel
• Add calls to update customer part numbers (PartModel.Reference) in DigiKeys' system automatically (If possible.)

Add Mouser Invoice Parser

Add the ability for the API to parse mouser invoice files. The invoices from mouser can be downloaded as Excel files. The one annoying part is that their OLD (.xls) formats. Add the ability for the API to parse these files and add them to the users invoices.

Requirements

• Parse Excel (.xls) files
• Integrate with InvoiceModel
• Add parsed invoice to user