Desktop application that helps teacher 👨‍🏫 in practical work (TP) to evaluate the student 👨‍🎓, and help students to learn SQL (structure query language) - Learning by doing.

中科软项目脚手架

Automatically runs three Red Prairie Ecometry recommended buy reports, parses the resulting text files, enters the parsed items into a working database, and emails managers the results.

This utility takes as its input the import file that will create new matters in the iManage DMS system, then it will filter out the matters already in the system and replace the import file with the filtered one and send an email notification of the new matters created. This allows for the matter import process to finish quicker and run more fre…

Utility that will take a box id as input and produce an excel spreadsheet containing a listing of the contents of a box in storage by querying the Elite Enterprise back-end sql server.

This utility alerts the records department when duplicate matters were entered by mistake. It queries the iManage back-end database and send the report as an excel spreadsheet attachment.

This utility takes a file containing a list of iManage client and matter numbers and exports the files for each matter from the document management system to a specified root folder.

Utility that will take the path to a file listing barcodes as an argument and produce an excel spread sheet with the information of folders associated to each barcode by querying the Elite Enterprise back-end sql server.

A Red Prairie Ecometry add-on utility that find orders with bad addresses by comparing the order file against the database and alerts the sales department when bad address orders are found.