mpkasp / indabom Goto Github PK

View Code? Open in Web Editor NEW

21.0 21.0 9.0 2.71 MB

bill of materials management system using the django-bom app

Home Page: https://indabom.com

License: MIT License

Python 29.99% HTML 62.56% CSS 5.64% Shell 1.81%

indabom's People

Contributors

Stargazers

Watchers

Forkers

dennybo surlymatt gxyp jaschimni msmatos molandtoxx alyasamba joseapicon stnigg

indabom's Issues

IndaBOM is too awesome, need to make less awesome

It's too good.
Please make it worse so I can stop thinking about it every night.
Thank you.

Sincerely,
Your #1 Phan

"bom_usermeta" does not exist

I have progressed from issue #2, however this issue may be a side affect of not running these migrations??

Is there an assumed seeded DB for this to work standalone? I.e. do you have a script which creates the tables required that you run before a new deployment (or more likely, it is a live system, therefore you can assume all required tables have already been created)??

When on the main page, clicking signup, then submit I get the following (very similar error when clicking on indabom logo top left):

Request Method: | GET
-- | --
http://10.0.75.1:8000/bom/
1.10.5
ProgrammingError
relation "bom_usermeta" does not exist LINE 1: ...ta"."organization_id", "bom_usermeta"."role" FROM "bom_userm...                                                              ^
/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py in execute, line 64
/usr/local/bin/python
2.7.14
['/src',  '/usr/local/lib/python27.zip',  '/usr/local/lib/python2.7',  '/usr/local/lib/python2.7/plat-linux2',  '/usr/local/lib/python2.7/lib-tk',  '/usr/local/lib/python2.7/lib-old',  '/usr/local/lib/python2.7/lib-dynload',  '/usr/local/lib/python2.7/site-packages']
Wed, 28 Feb 2018 06:16:23 +0000

More details traceback:

Environment:


Request Method: GET
Request URL: http://10.0.75.1:8000/bom/

Django Version: 1.10.5
Python Version: 2.7.14
Installed Applications:
['indabom',
 'bom.apps.BomConfig',
 'django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.sitemaps',
 'raven.contrib.django.raven_compat']
Installed Middleware:
[u'raven.contrib.django.middleware.SentryMiddleware',
 'django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware']



Traceback:

File "/usr/local/lib/python2.7/site-packages/django/core/handlers/exception.py" in inner
  39.             response = get_response(request)

File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
  187.                 response = self.process_exception_by_middleware(e, request)

File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
  185.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
  23.                 return view_func(request, *args, **kwargs)

File "/usr/local/lib/python2.7/site-packages/bom/views.py" in home
  28.     profile = request.user.bom_profile()

File "/usr/local/lib/python2.7/site-packages/bom/models.py" in _user_meta
  34.             'organization': organization})[0]

File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py" in manager_method
  85.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in get_or_create
  473.             return self.get(**lookup), False

File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in get
  379.         num = len(clone)

File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in __len__
  238.         self._fetch_all()

File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all
  1087.             self._result_cache = list(self.iterator())

File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in __iter__
  54.         results = compiler.execute_sql()

File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
  835.             cursor.execute(sql, params)

File "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  79.             return super(CursorDebugWrapper, self).execute(sql, params)

File "/usr/local/lib/python2.7/site-packages/raven/contrib/django/client.py" in execute
  114.             return real_execute(self, sql, params)

File "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  64.                 return self.cursor.execute(sql, params)

File "/usr/local/lib/python2.7/site-packages/django/db/utils.py" in __exit__
  94.                 six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  64.                 return self.cursor.execute(sql, params)

Exception Type: ProgrammingError at /bom/
Exception Value: relation "bom_usermeta" does not exist
LINE 1: ...ta"."organization_id", "bom_usermeta"."role" FROM "bom_userm...
                                                             ^

Manufacturing & Inventory & API

Hi Mike,
we are looking for a simple Django-based tool to manage our BOMs, however I have a few questions to ask as there is very limited documentation here:

Is there a possibility to create a super-easy inventory interface? That is - upload a delivery note (in CSV lets say) and have the inventory of parts updated in terms how many units of each pars are available in stock?
Is there a way to create a "manufacturing order" - that is - lets say we have this product which contains 300+ electronic parts including plastic parts and sub assemblies etc - is there a way to klick "Im now making 100 units of this product" and Idabom will check which parts are in stock, which need to be bought or 3d printed / manufactured ...

Doing this using API would be absolutely awesome since we can integrate this with KiCad and some other applications to have a working inventory systems for KiCad assemblies and parent products.

I have more ideas here, but really cannot contribute time to this. Thigs like variations of the same product and its different BOMs etc.

total weight

Hi,

First off all thanks for sharing this great project
Is it somehow possible to get the total weight off all assembled parts and subpart?
It would be nice if you could get the weight of the assembled parts like the total costs

thx for you help

Implement other part finder services

We are using PartChips at my place.

How hard would it be to implement other part finder services?

IndaBOM Installation

Hi there,

Firstly, I am NOT a developer, and therefore not to clever when it comes to django. I am however an infrastructre person, and do understand operating systems etc.

I ran IndaBOM on your server to validate the functionality, and it is really what I wanted all along, however, I simply cannot get it to run, as the instructions are a bot confusing.

I have a complete clean machine, with Ubuntu 18.04.

What are the step by step instructions to install IndaBOM on this machine please!!!!

What are the pre-requisites? (mysql, java, .......)

Then how to get Instabom running to be the same as on your cloud site.

I would really appreciate the help, as follwing the instruction you provided, sdoes NOT result in a running application.

Thanks
Louis

Useability - manage ellipsis is often off the right of the window and required scrolling

When managing the BOM for an individual part (e.g at https://indabom.com/bom/part/17834/rev/18871/manage-bom/ ), the ellipsis is the last column... making it a pain to scroll over to find.

One solution might be to make the 'level' field clickable at the point, and to provide the same "edit or change / remove" drop-down menu from it.

Auto-complete during 'Edit BOM'

To help with usability, an auto search or auto complete for adding new items to a BOM would make it much faster and easier to create BOM structures. Without this, one needs to already know all of their part numbers beforehand which means they basically already need a bom in front of them

Part number syntax

Hello everyone, I'm looking for a way to modify the part number syntax in order to better customize this platform to my needs. Take into account that every business has its own way to code parts, so I suppose that it'd be useful to provide a config file where you can decide your own part number syntax, going beyond the predefined structure which mainly fits to the electronics scope.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.