How deklonis/etl-panpline_public works
Contacts ETL is a PyQt desktop application that turns a conference Word table into reviewed contact records and loads new people and companies into SQLite. The main flow is file selection, extraction and transformation with duplicate checks, operator review, then load; drafts can be resumed later. The graph preserves documented parsing, morphology, matching, and storage responsibilities. Some subsystem links rely on README or SOURCE INDEX references because their implementations were not excerpted; those limits are reflected by omitted or dashed links.
Main entry points: main_function.py Word extraction · main.py Review window · to_main_db.py CRM loader · select_file_window.py File selector
Components 21
File intake
- File selector
select_file_window.py
Data transformation
- Word extraction
main_function.py - Text cleanup
components/del_space.py - Job-term dictionary
components/all_first_word.py - Contact parsing
components/phonedetector.py - Email parsing
components/emaildetector.py - Name forms
morfy/morfology_name.py - Job forms
morfy/morfology_comp.py - Company normalization
components/to_norm_vid.py - Salutation
components/name_lastname.py
Review and drafts
- Review window
main.py - Review interface
ui/main_ui.py - Person editor
popele_conteiner.py
Matching and storage
- Duplicate matching
components/find_in_base.py - Draft access
component_to_db/workwithdb.py - Draft table
component_to_db/draft_table.py - Resume settings
settings/settings.py - CRM loader
components/to_main_db.py - Contact database
components/db.db
Other components
- Operator
- Word file
Connections 25
- Operator → File selector: chooses file
README.md - Word file → File selector: provides input
README.md - File selector → Review window: opens review
select_file_window.py - Review window → Word extraction: converts file
main.py - Word extraction → Text cleanup: cleans cells
main_function.py - Word extraction → Job-term dictionary: finds job terms
main_function.py - Word extraction → Contact parsing: extracts phone
main_function.py - Word extraction → Email parsing: extracts email
main_function.py - Word extraction → Name forms: inflects names
main_function.py - Word extraction → Job forms: inflects jobs
main_function.py - Word extraction → Company normalization: normalizes company
main_function.py - Word extraction → Salutation: formats salutation
main_function.py - Word extraction → Duplicate matching: checks duplicates
main_function.py - Duplicate matching → Contact database: reads contacts
components/find_in_base.py - Review window → Review interface: renders review
main.py - Review window → Person editor: creates editors
main.py - Operator → Review window: checks records
README.md - Review window → Draft access: saves or restores
main.py - Draft access → Draft table: reads and writes
component_to_db/workwithdb.py - Review window → Resume settings: stores resume info
main.py - Operator → CRM loader: sends records
README.md - Review window → CRM loader: loads approved data
main.py - CRM loader → Contact database: inserts contacts
components/to_main_db.py - CRM loader → Duplicate matching: checks company
components/to_main_db.py - Draft table → Contact database: shares SQLite file