| Project name : | Data migration from Ms FoxPro to MySQL and database design for ESCO* sales website's department | ||||||||||
| Start : | 2004 | ||||||||||
| End : | 2004 | ||||||||||
| Status : | finalized | ||||||||||
| Category : | web applications | ||||||||||
| Description : | Data migration from Ms FoxPro to MySQL and database design for ESCO* sales website's department | ||||||||||
| Full descriptiopn : | Employer:
Pooyaandish Address: Isfahan, Chaharbagh Bala St, Kowsar trade complex,second phase,2nd floor,No 400 One of the most important part of ESCO Sales website's department was data migration from MS.FoxPro to MySQL. The sales M.I.S software developed in MS.FoxPro and installed on a Novell server in sales office located in Esfahan city , part of data was created in plant after deliver to customer (because it must be scale ) and sent to Novell server via modem , hence in website we must be showed sales information to ESCO's customers in two steps. 1- When they buy product 2-when they deliver the product. We decided to develop a web application for data entry operators on sales department's website with multi user access facility . And also we must be developed this web application based on ESCO privacy that I mentioned . Because the huge amount of sales information data in our site and big amount of data that create daily , we must be designed website's data bank accuracy. Data normalization and creating indexes rules must be done right. Also we worked with huge data amount , these data is very important and I must be developed a secured web application , that enables to prevent data . After developing this software we must be test the software . A mistake in software could made huge incorrect sales information for many customers and it was a tragedy . This project has 4 main parts: 1- Sending and converting data from FoxPro to MySQL module . 2- Data bank design . 3- Web application security . 4- User authentication and secured page module . Role My role for this project was dual; I was web security specialist and developer . Based on my roles in this project I have done majority of this project. I worked in part 1,3 and 4 of this project. Technical aspects Part one: Sending and data migration from FoxPro to MySQL module For developing data migration module of this project I chose converting dbf files to CSV (Common-separated values) files and import it to MySQL website's data banks method based on my researches about data migration methods and decided to develop it in PHP. During my work on developing data migration application I gained valuable experience in : 1- Working with CSV files methods in PHP 2- Security subjects in sending files across internet via web interfaces 3- Text files processing methods in PHP 4- Speed up file processing via using accurate algorithms One of another knowledge that I gained up in it is : Object oriented programming methods in PHP. Part three : Web application security module As a web security specialist I was responsible for preventing data against web attacks , hence I must be strong up this web application . Encryption and decryption data with a private key and methods of data encryption are subjects that I gained up experiences on it during this project. One of another subject that I have experienced is security in web forms and interfaces such as validating web forms . We used also advanced encryption method in this project such as SSL. Installing OPEN SSL on a Linux server is one of another experience that I have learned in this project. Part four : User authentication and secured page module We added multi user facility to this application. For this facility we need to add user authentication facility to this project. During adding this facility I have learned valuable knowledge about sessions , user authentication methods and security subjects in sessions and web based authentication software in PHP. The strong phase that we did in this project is testing software. There was processing and editing some sales information values during migrating data from MS.FoxPro to MySQL . There was variety editing method and processing for every record and we must be check data that publish in website after data migration . We tested data migration process in software testing period . Conclusion This project is one of the most strong project that we develop in ESCO. This project is the first step to installing sales information website for the ESCO. Before implementing this website around 6,000 customers of ESCO used to get their information via fax and print page from sales department located in Esfahan city. It was very difficult and insecure. ESCO staffs had crowded day and they major times loosed for giving sales information to customers. Although ESCO employed many staff but couldn't serve good services to customers and there was many complains from customers about wrong information and postpone in sending information . After implementing this project and ESCO sales information website (http://sales.esfahansteel.com) every customer can login to his/her control panel and make report for his/her sales information and delivery report and many other reports in secured area, while he/she is in home or office in 24 hours a day . After implementing this project ESCO could reduce staffs . Also another reports was created in this website that before ESCO couldn't create that such as : Product line reports and value of production . Another user levels such as ESCO sales specialists, transportation companies, assistants and head manager was created in this website and now every user level can particular report. Working in this project as web security and web developer was certainly an eye opener with regard to ESCO privacy . I am proud to say that my team successfully delivered the work packages on time and within budget and contributed to the most profitable project of ESCO and Pooyaandish history. ESCO : Esfahan Steel Company – a huge steel making company located in Iran, Esfahan. This company is one of the best steel making company in the middle east. Website : www.esfahansteel.com |
||||||||||
| Company : | Esfahan Steel Company | ||||||||||
| Task Master : |
| ||||||||||
Project detail