This webapp solves a specific problem with ERP applications - the inability to paste multiple lines of text into note fields. It allows users to easily paste and manage multiline text, overcoming the limitations commonly found in ERP systems. This tool focuses on simplicity and efficiency, making it ideal for enhancing data entry and note-taking within enterprise applications.
Add, edit, and delete order notes in bulk using a PHP script and MySQL database (or any other database of your choice).
![TIP] By default, the application uses
mysqlito connect to aMySQLdatabase. You can use any database you want by changing the connection method in theconfig.phpfile (toodbc,pdo, etc. for example).
This project is designed to be run on a local server. You can use XAMPP to run a local server on your machine.
- Clone the repository to your local machine.
- Create a database in MySQL using the
order_notes.sqlfile in thesqlfolder. - Update the
config.phpfile in theincludesfolder with your database credentials. - Open the
access.phpfile in your browser. - Enter a valid order number and click the
Submitbutton. - Add, edit, or delete notes as needed.
- Click the
Submitbutton to save your changes. - Click the
Backbutton to return to the order number input screen. - Click the
Linesbutton to view the order lines for the order number you entered. - Add, edit, or delete notes as needed for each order line.
This project is released under the terms of the MIT License, which permits use, modification, and distribution of the code, subject to the conditions outlined in the license.
- The MIT License provides certain freedoms while preserving rights of attribution to the original creators.
- For more details, see the LICENSE file in this repository. in this repository.
Author: Scott Grivner
Email: scott.grivner@gmail.com
Website: scottgrivner.dev
Reference: Main Branch
