Deployment Steps
Migration Procedure
1. Create a folder Deployment in D: drive
2. Open Internet Explorer Browser and give the URL
3. Click on Migration Application link and download the Migration.zip file inside D:\Deployment folder. Now Extract the Migration.zip file in the same path.
4. Now go to the Migration folder. Following files should be there inside the folder.
Double click on DataMigration.exe file (marked in red block). Then following screen will open.
5. Click on Migration → 00_Create Folder and Database
.
Create Folder and Database screen will open. Click on the Create Folder and Database button and wait until a message come that database created successfully. Now please re-check that whether the following folder is present.
D:\DCMS\MSSQL\DATA
D:\DCMS\MSSQL\LOG
D:\TomoGas
D:\TomoGas\InputFiles
D:\DCMS\TomoGasInterface\ArchiveFiles
User will not be able to open the other screens with out creating the database properly.
6. Now click on Migration → 01_Set Up Distributor Database.
Following screen will open. Enter proper Distributor Code and click on Fetch button. Distributor details will come in the text area. Validate the distributor details, and if it is correct then select the check box present below and click on Set up Distributor button. Distributor Set Up will be done properly.
- For CSV to Staging Table, click on the Migration → 02_Migration Data → 03_CSV-Staging Table.
8. Browse the CSV file which is to be migrated in the staging table using the (…) button and open it.
Choose the appropriate Data Set that is to be migrated. Click on Migrate button. A successful pop-up message will come after a successful migration. Then Click on Clear button.
9. Repeat 6 and 7 for Data Set – ConsumerMaster, ConsumerSVInfo, RefillOrderDtls, RefillOrderHistory, ConsumerTransferOut, ConsumerTerminationOut and InvoiceEMR sequentially (as in the drop down).
- Go to Migration → 02_Migration Data → 05_Get Error Records.
Following screen will open. Then click on BCP Error button. BCP error files will be generated in D:\Deployment\BCPError
11. Repeat Step 7 to 11 unless the BCP Error generated all blank files
12. Click on the Migration → 02_Migration Data → 04_Staging-Actual Table . After successfully migrating data in staging table, you have to migrate data staging to actual table.
Following screen will open. Choose Data Set as DistributorAreaMaster from the drop down and enter any ticket no.
Click on Migrate button. A successful pop-up message will come after a successful migration. Click on Clear button.
13. Now repeat Steps 14-16 by choosing Data Set as ConsumerMaster, ConsumerSVInfo,Verify Consumer Data,RefillOrderDtls, ConsumerTransferOut, ConsumerTerminationOut and InvoiceEMR sequentially (as in drop down).
14. Go to Migration → 02_Migration Data → 05_Get Error Records.
Following screen will open. Then click on Staging Error button, staging error files will be generated in “D:\Deployment\Staging Error” folder.
If any error comes, then correct the .CSV file and repeat the Steps 7-18 again. The error for Verify Consumer Data comes on the ConsumerMaster.csv. Repeat this step unless all the files generated will be blank.
15. Please ensure that the post migration data excel has been received from the sales officer before proceeding to step 16.
16. Click on the Migration → 02_Migration Data → 07_Active Consumer. After successfully migrating data to actual table, user need to check whether the Active Consumer Count, Cylinder Quantity, Regulator Quantity and Deposit Amount.
Select the proper Nature Code and/or package Code as search criteria and click on the Fetch button. Then Active Consumer count, Cylinder Count, Regulator Count and Corresponding Deposit Amount will come in the details list. If the details are correct, then click on the Correct button.
17. Click on the Migration → 02_Migration Data → 06_Authorized Floor Stock. After successfully migrating data to actual table, have to enter all the post migration data. Enter the data of authorized floor stock.
Enter all the values as per excel and click on Save button. On clicking save, following pop-up will come.
18. Click on the Migration → 02_Migration Data → 07_Define Stock.
Enter all the values as per excel and click on Save button. A pop-up will come.
19. Enter data for Account Balance.
Enter all the values as per excel and click on Save button. A pop-up will come.
20. Enter data for Weekly report.
Enter all the values as per excel and click on Save button. A pop-up will come.
21. Click On the Migrate → 02_Migrate Data → 10_Update Serial Number
Enter the serial numbers is the corresponding fields and click on Save button. A pop up will come.
- Click on Migrate → 02_Migrate Data → 13_View Weekly Report. After giving weekly report post migration data user will be able to view the weekly report.
User has to go through the weekly report Properly. It comprises of the Year, date,month,and to to from date(s) weekly details. If the data are correct then user only has to click on ' Correct' button.
If the data are matching then click on OK. Then go to next step.
23.Click on Migrate → 02_Migrate Data → 14_Declare Go Live. If all the previous steps are done correctly then only user will be able to declare live correctly.
If the user is agree with the given terms and conditions present in the text area, then user have to select the check box and click on the Declare Go Live button.
Page 1 of 21