Leadblossom Filesx

blareweyrSoftware and s/w Development

Dec 13, 2013 (3 years and 3 months ago)

71 views

Leadblossom Files

/ Databases

Summary



File names in list are conceptual



Each file will be related to a customer or job number

Input Files



input.txt


customer input file containing key, full name, full address, city
-
state
-
zip, phone, email



request.txt


cleaned up expanded version of input.txt, sent to Convergence for data append



append.txt


raw V12 append data file in either postal or epostal dictionary format, pipe
-
delimited,
contains customer key along with 1 or more matching data records

Configuratio
n

(input)



profile.ini


data extraction and conversion definition file (maps append fields to LB variables)



tables.ini



secondary support file used for mapping append values to LB values (optional)

Configuration (input/output)



vars.ini



list of LB profil
e variables with score matching codes, defines how data is compared



weights.ini



variable weight levels for roll
-
up scoring

Data Storage (output)



profiles.dat


binary storage for people profile data in consolidated, compressed, encrypted form

DB Storage
(file
-
based)



job.db


SQLite database created for each job, contains:

o

People
-

lead profile records

o

People


selected distributor profile records

o

Matches
-

lead to matched distributor relationship table

o

Stats


job statistics from system process



reps.db


SQLite database maintained for each customer, contains:

o

People


distributor profile records

SQL Storage (system
-
based)



Customers



People



Jobs



Matches



Transactions



Billing / Accounting