Workspace/Overview
Imported snapshot · 01 Oct 2026
ZA
REPORTING OVERVIEW

Your data, in focus.

A clear view of the Zaintel reporting workspace and the reports ready for their next step.

ROWS IN SNAPSHOT
295,828
Verified across 33 populated tables
295K
IMPORTED TABLES
44
Across 4 database schemas
LEGACY REPORTS
45
Catalogued from Crystal Reports
HPANI+
REPORT READINESS
Needs mapping
Missing SQL objects block direct runs
DATABASE

Schema snapshot

44 tables organized across four imported schemas.

A
accountdbAccounting & vouchers
3 tables
C
companyCompany & reseller data
22 tables
H
homephoneCustomers & products
8 tables
R
rangteldb_dboLegacy dbo objects
11 tables
✓ Import verified on MySQL 8.4 · 33 tables contain rows
NEXT TO UNLOCK

Data gaps to resolve

ACTION NEEDED

These gaps currently prevent reports from running as designed.

!
CompInfo is missingReferenced by all 45 reports
45 reports
◌
Operational objects absentSales, purchasing, reseller & ticket sources
Multiple
?
SQL Server logic to mapViews, joins, formulas & parameters
Review
CURATED FOR YOU

Explore report library

ZAINTEL REPORTING WORKSPACEImported database snapshot · Readiness review
CUSTOMER REPORT

Customer accounts, at a glance.

Search customer contact details and see account IDs, descriptions, and service indicators where the database supports a verified link.

904 CUSTOMERS
Private customer workspace

Sign in to search contact details. This page loads customer records only over the secured connection and after authentication.

SIGN-IN REQUIRED
◎
ANI CUSTOMER RECORDS904Unique (company, customer) keys
⌖
ACCOUNT ADDRESS RECORDS264Customer records with street addresses
◇
LINKED ACCOUNTS7All 7 link to a customer by company + customer ID
CUSTOMER + ACCOUNT RECORDS

Search the directory

Verified account join · ComCode + CustId
904 results
CUSTOMERTELEPHONE & EMAILADDRESSACCOUNT & SERVICE INDICATORSSTATUS
Sign in to securely load customersSearch partial customer names, phone numbers, or addresses, then filter and sort linked account records.
Read-only customer source · credentials and financial fields excludedSign-in required to view records
i
What the imported data can confirm

All 7 rows in rangteldb_dbo.callforaccount join to customers by (ComCode, CustId), and all 7 have the Home Phone account flag. Account numbers, descriptions, and line numbers are shown for those rows. The invoice ServiceId values do not match homephone.phoneservice, and account ProductCode values do not match homephone.product; the report shows verified service flags and raw product codes, not guessed service names. Customers without a linked account are marked accordingly.

ZAINTEL · CUSTOMER DIRECTORYRead-only customer source · Personal records require sign-in
REPORT LIBRARY

Find the right report.

45 legacy Crystal Reports, organized by business area and checked against the imported data.

45 reports Every report needs source mapping before execution
ZAINTEL · 45 CRYSTAL REPORT DEFINITIONSCatalog metadata only · Reports are not executable yet
DATA HEALTH

Know what’s connected.

A transparent view of the imported database and the gaps between it and the legacy reports.

IMPORT VERIFIED
44TABLES
DATABASE IMPORT

Snapshot is healthy.
Report coverage needs work.

The SQL dump imported successfully into an isolated MySQL 8.4 instance. Its 44 tables and 295,828 rows are verified. Legacy report dependencies still need to be mapped before a report can run.

4 schemas33 populated tables0 imported views
MYSQL8.4ISOLATED
SCHEMA INVENTORY

Imported source tables

44 total
SCHEMATABLESREPORT CONNECTION
accountdb3Partial
company22Partial
homephone8Partial
rangteldb_dbo11Partial
Matching table names alone do not confirm compatible columns or relationships.
COVERAGE BLOCKERS

Before reports can run

01
CompInfo has no imported match

Every one of the 45 report definitions references it.

45/45
02
Required business objects are absent

Sales, purchasing, reseller invoices, tickets, and SQL views are among the gaps.

Multiple
03
Legacy report logic is unverified

Columns, joins, filters, formulas, and subreports need a Crystal Reports export.

Review
04
Some matches are ambiguous

HPInvoice exists in two schemas; SQL Server names differ from MySQL schemas.

Resolve
i
Safe by design

Table previews require sign-in, use a read-only database account, exclude sensitive columns, and return at most 100 rows per request.

ZAINTEL · VERIFIED DATABASE INVENTORYSource: imported 2017 dump · report object coverage review
READ-ONLY DATA

Query your data.

Write a SELECT statement, preview the first 100 rows, or export the full result.

SELECT ONLY
TABLE BROWSER

Select a table

Read-only

Edit or replace the SQL with any single read-only SELECT. Database permissions block writes and protected columns.

Columns

Select a table to view its available columns.

Sign in, then choose a schema and table.
Your account has read-only access.
ZAINTEL · READ-ONLY SQL100-row preview · Full-result CSV export
DATA MODEL

Understand the connections.

See which table relationships are enforced and which still need confirmation.

SOURCE REVIEW
IMPORTED TABLES
44
Across four schemas
DECLARED FOREIGN KEYS
0
No enforced links in the imported schema
OBSERVED CUSTOMER LINKS
3
Join-key match counts from this snapshot
OBSERVED KEY MATCHES

Customer data connections

No automatic joins

These key matches were checked against the imported rows. No foreign-key constraints exist, so they remain data-verified candidates rather than enforced database relationships.

KEY MATCH · USED IN CUSTOMER REPORT
rangteldb_dboanicustomerComCode + CustId
7 / 7 account rows match
rangteldb_dbocallforaccountComCode + CustId

All 7 account rows map to a customer. Each has the Home Phone account indicator. This supplies account number, account description, line number, product code, and account status for the customer report. The account table contains only 7 rows in this snapshot.

KEY MATCH · HISTORY CANDIDATE
rangteldb_dboanicustomerComCode + CustId
7,000 / 7,000 invoice rows match
rangteldb_dboaniinvoiceComCode + CustId

The invoice rows match 763 distinct customer keys. `aniinvoice.AccountNo` does not match the account numbers in `callforaccount` in this snapshot, so the invoice account should not be treated as the current account master.

KEY MATCH · HISTORY CANDIDATE
rangteldb_dboanicustomerComCode + CustId
10 / 10 sales rows match
rangteldb_dboanisalesComCode + CustId

All 10 sales rows match 6 distinct customers on the composite customer key. The imported schema does not enforce this relationship.

NOT VERIFIED
companyaniserviceTelephone value
Possible phone match
rangteldb_dboanicustomerPhone / Cell

One service row has a phone match, but its meaning is unclear. It is not shown as a customer subscription.