Extract necessary data from various type of spread sheets, store the data and combine 


                                                                  

  X-tract
  X-tract offers easy DB set-up from Spread Sheet (Excel@Microsoft) together with easy mapping function. X-tract covers most popular Planning and Data Import Job in most industries.   
 
      Functionality
User login with system define authorization
Create database storage by GUI screen
Define mapping information based on table contents
Upload entire workbook or selected worksheet by defined pattern file
Data backup to specified table if same workbook and same worksheet is re-uploaded
Upload History / Error tracking
Output the entire uploaded data to Excel format
Eliminate unnecessary data from data storage
Convert the value from input spread sheet to data storage
 
 
      System Features
 
 Security
 User authentication by Login Screen
 
 Data Storage
 Database creation using GUI Screen
 
 Data Extraction
 Flexible mapping information definition. Upload the spreadsheet data into Database by defined Flexible Mapping information
 
 Output
 Output uploaded data to Microsoft Excel spreadsheet
 
 House Keeping
 Eliminate unnecessary data from database
 
 Maintenance Utility
 Register Data Storage to System. Delete Data Storage from System
 
 Data Translation
 Data Conversion for Uploading
 
 

Development Tool

Visual Basic

Databases

SQL Server 2000/Oracle 8i/Oracle 9i

Hardware Requirement

Server : Pentium III - 512MB & above, 2GB hard disk

Client : Pentium III & above

Software Requirement

Server OS : Windows 2000/XP/NT

Client OS : Windows 2000/XP

Platforms

Windows 2000/XP/NT

 

  
  Operation Flow

  
 
   
Copyright © 2003 FBIC Computers Services Sdn. Bhd. All Rights Reserved