Batch Update with Excel files

Task to do:

Preparing for working out Batch update over excel for the SMD website. The website does not have uploading functions before, the current one only support for downloading or generating reports for download.

-Do not use ADO COM object as possible in this updates. (complicates things and difficult to maintain)
-In uploading the excel files to the server, the excel file names have to be modified in order to avoid overwriting of files for different users, the file names can be append with systemtime (and username) to have an understanding of the file and also prevent the overwriting exposure.
-When updating the database, do it record by record: (i.e. Read a record from the excel, and then carry out the corresponding update in the database instead of read the whole excel file and save all the record in the runtime program, and then carryout all the updates together in the database) One of the cons is to save some memory space of the runtime program during execution.


Functions Completed:
-ASP Pages for uploading and saving the files into the server

SMD Enhancement Outline

1. Minor Change--------October
2. HSIC-------phase1---Dec 2007 ~ UAT Nov-mid Dec
-------phase2---2008

Procedure

1. UR Study
2. Interview - confirm + sign FS (Functional Spec)
3. Development
4. SIT (System Integrated Test)
5. UAT
6. Deployment Procedure
7. Deployment Production

Deployment Issues

SMD Deployment Procedure v7.0


DB issues
Backup

Data Files, Transaction Log Files
Shrinkdown DB

dns?

Details of SMD Project

The SMD is some sort of a centralized database, where there are different source of data updating the database (import) or it has to generate reports / complete outsourcing task (export).

Import

Export

SMD website

Database Structure

Technology Involved
MSSQL COM VB6.0 ASP
Stored Procedure

Program design
Admin, Batch, Common,

The HKEx Project -- SMD

I start working at 3/9/07, where Frankie took me to the HKEx office at noon. My working location is going to be in 17/F of World Wide House (WWH), where some departments of HKEx office locates, the main location of HKEx is at IFC and Exchange Square.

My main working location will be at WWH, but for our (SMD) users they sit at IFC, and the UAT area will be in IFC too, so during UAT we will have to go to IFC from time to time. The SMD server is located in Quarry Bay (QB), when the final production phase of SMD is carried out we may have to go to that station. The servers in HKEx located in several areas: QB or Central (IFC/Exchange Square).

The project I'm going to be involved is the update of Stock Market Database (SMD). It is first deployed in 2003 and it was update periodically thoughout the 4 years. This time, similarily, we are going to enhance the system by following the user requirement.

Although we are contractors, we also work with HKEx IT team, where they call it EBOA (E-business and OA). One of the team (where I work with) is located in WWH, so I just stayed there for work.

Job

Working in RainbowSoft


It is a software development house which accepts/handles IT project from outside companies. Their big clients include HP, CLP, the Transport Department, etc.



This time when my position is introduced I'll be handling and staying at the office of Hong Kong Exchanges and Clearing Limited (HKEx) to undergo a project. In this project HKEx requests an AP stayed full time in their office during the contract period to handle their project. Since my supervisor, Frankie, cannot stay at HKEx full time as he had other projects at hand, they have to hire one person to fullfil HKEx's request.



So my title is Analyst Programmer, as they told HKEx an AP is going to take part in this project, so they just gave me this title though I am new to the field.