bcombs18 / osticket-inventory-manager Goto Github PK
View Code? Open in Web Editor NEWAn Inventory Managment plugin for osTicket.
License: MIT License
An Inventory Managment plugin for osTicket.
License: MIT License
The database should have a function that allows osTicket to flush out Inventory tables in the database
Describe the bug
I have successfully installed version 1.1.5 by following the installation steps.
Once the plugin is activated, inside the agent panel, in Applications, the Inventory Manager drop-down appears and when I click on it, it takes me to the URL "/scp/dispatcher.php/inventory/asset/handle" and it gives me a 404 response, telling me it can't find the file.
I have tried to install other versions of the plugin, but the same thing happens to me.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
View plugin Dashboard
Additional context
OsTicket 1.16.1
PHP: 8.0
Add a new feature to allow users to generate reports on assets. Should be implemented similar to queues in the ticketing system
The header row is being imported as an asset. Additionally, the importer is not checking headers against form fields.
The dispatcher needs to be re-worked so all requests are not processed through the import controller
When exporting assets from Inventory Tracker I'm getting a 400 (Bad Request). Please provide insight on how to fix this.
The scp.js and dispatcher.php files should automatically be added to their respective locations using shell commands to simplify the installation process for the user. Must support Windows and Linux environments.
This will break the plugin if the user has changed the root of the URL for their instance of osTicket
Describe the bug
I have SSL installed on my Server and a custom domain pointing to my OS ticket instance.
eg. https://support.mydomain.com
I completed the setup but I cannot create assets.
When testing API via curl using the server IP address I get "301 Moved Permanently" as an error.
When testing API via the custom hostname I get "Valid API key required"
In the API section of the app I can create the API and enable "Can Create Assets" I get a message "Successfully updated this API key" on save but the tick box for Can create assets is empty.
I want to try this plug in but it seems that I get this error
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'A1.host_name' in 'order clause' in /home/support/upload/include/mysqli.php:189 Stack trace: #0 /home/support/upload/include/mysqli.php(189): mysqli->query() #1 /home/support/upload/include/class.orm.php(3470): db_query() #2 /home/support/upload/include/class.orm.php(3517): MySqlExecutor->execute() #3 /home/support/upload/include/class.orm.php(2097): MySqlExecutor->getArray() #4 /home/support/upload/include/class.orm.php(2047): HashArrayIterator->{closure}() #5 /home/support/upload/include/class.orm.php(2026): CallbackSimpleIterator->next() #6 /home/support/upload/include/class.orm.php(2035): CallbackSimpleIterator->rewind() #7 /home/support/upload/include/class.orm.php(1706): CallbackSimpleIterator->valid() #8 /home/support/upload/include/class.orm.php(1741): CachedResultSet->fillTo() #9 /home/support/upload/include/class.orm.php(1602): CachedResultSet->offsetGet() #10 /home/support/upload/include/class.orm.php(1458): QuerySet->offsetGet() #11 /home/support/upload/include/plugins/osTicket-Inventory-Manager-1.0.1/views/queue-assets.tmpl.php(212): QuerySet->exists() #12 /home/support/upload/include/plugins/osTicket-Inventory-Manager-1.0.1/include/model/assets.php(242): require('...') #13 /home/support/upload/include/plugins/osTicket-Inventory-Manager-1.0.1/include/controller/Asset.php(190): require_once('...') #14 /home/support/upload/include/class.dispatcher.php(145): controller\Asset->handle() #15 /home/support/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch() #16 /home/support/upload/include/class.dispatcher.php(120): Dispatcher->resolve() #17 /home/support/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch() #18 /home/support/upload/scp/dispatcher.php(45): Dispatcher->resolve() #19 {main} thrown in /home/support/upload/include/mysqli.php on line 189
and some part of the personal queue are displayed in the page
osticket 1.16.3
php 8.1
ubuntu 20.4
The Inventory Form uses ID 'G' to make it visible in the Custom Forms menu. This causes an issue when a second custom form already exists or is created since 'G' is reserved for all custom forms, not just the Inventory Form.
ID should be changed to 'I' and a settings menu should be created to provide access to the form for customization.
The Search bar should be searching on all data fields. Not just assignee names.
Investigating the possibility of linking assets to tickets, potentially through the assigned user.
Assets should have a viewable history of changes made to them.
This can be in the form of Notes
Asset locations should be tied to a user-customizable list storing each location and should be accessible in the form of a drop down
Assets which have been removed from circulation should be able to be marked as such and removed from the active listing to a "retired assets" table.
The user would like to be able to create views with custom columns similar to ticket queues
The main inventory form needs a rework. Should only have a few required/pre-installed fields. The rest should be up to the user to set up.
Assigning a user results in a failed AJAX call and infinite loading screen.
Data should be fully indexed. This should help resolve issues with the search engine and exporter
Importer currently does not check for pre-existing copies of an asset before inserting into the database. Serial Numbers should be checked before executing insert.
URLs should be utilizing global variables so they are easy to update in the future
This included a revision to the current search feature and the addition of an advanced search feature.
The install script should add a blank cdata table to prevent issues with it being unavailable when loading the plugin.
Add an API call to enable remote asset creation for use in deployment processes.
[ ] - Add API
[ ] - Add installer for API
[ ] - Add uninstaller for API
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.