This was a solo project.
Developed pre-Lambda School. Deployed version is offline. Porting this to a React/Redux version with a back end via Node, Express, and PostgreSQL. Back end is largely completed; front end in planning stages.
This is my company's VB database, which is used for transcript production and workflow management. The VB database does everything from scheduling to automated shorthand to automated hyperlinking and document formatting, shipping, production, management of company financials, and other business operations. Copyright 2020 Erica Ingram.
- Live solo project
- Integrates GTD principles into workflow
- Generates 25 to 30 different documents automatically such as price quotes, invoices, cover pages, indexes, and others in Microsoft Word, Publisher, and Outlook
- Manages schedule and production workflow
- Auto-imports electronic communication
- Automatically hyperlinks authority within transcripts via CourtListener API
- Manipulates PDFs to auto-generate bookmarks and create different transcript versions
- Auto-creates and formats Word versions of documents
- Tracks communication and document history of each transcript order
- Manages and plays audio and reporter notes
- Integrated with Office, Acrobat, and WinSCP libraries and several APIs such as CourtListener, PayPal, OneNote, and others
- speech recognition
Software runs in Microsoft Access and built using:
- Visual Basic: Visual Basic is an approachable language with a simple syntax for building type-safe, object-oriented apps.
- SQL: a domain-specific language used in programming and designed for managing data held in an RDBMS or stream processing in an RDSMS
- CourtListener: assists in automation of authority hyperlinking.
- Office: document creation, formatting, and management.
- PayPal: payment processing and management.
- Wunderlist: to-do list management.
- Only manual testing has been conducted.
Check out the Wiki for more info on general production workflow, file and folder organization, database-related information, templates, classes, modules and various functions within the software.