BBCT - WBC Migration – CP User Manual
Contents
1. Service_Support_Helpd esk Optional Service number support help desk ModifiedFT RCalc Optional Attribute to enable user to retain 20 CN line rate MTBERedThreshold Optional Mean time between Error RedThreshold MTBEGreenThreshold Optional Mean time between Error GreenThreshold MTBRRedThreshold Optional Mean time between Retrain RedThreshold MTBRGreenThreshold Optional Mean time between Retrain GreenThreshold RateBandUS Optional Additional Parameter RateBandDS Optional Additional Parameter InterleaveDepthUS Optional Additional Parameter InterleaveDepthDS Optional Additional Parameter TargetMarginDepthUS Optional Additional Parameter TargetMarginDepthDS Optional Additional Parameter FTRValueUS Optional Additional Parameter FTRValueDS Optional Additional Parameter Page 27 of 66 BBCT wBC migrations CP user guide BTE 11 2 Migration Upload Messages Following are failure success messages when you upload migration file on BBCT Message Selected file is not of type XML CSV EXCEL Invalid Filename please try again in recommended format WBCBULKMIG_LLU_OMxxxx xxxx_ddMMyyyy_HHmm csv OR WBCBULKMIG_LLU H_OMxxxxxxxx_ddMMyyyy_H Hmm csv Duplicate filename please try again in recommended format WBCBULKMIG_LLU_OMxxxx xxxx_ddMMyyyy_HHmm2. As a new user you will need to register on BBCT by sending an access request with your Customer Id OMNumber Username Password to the BT Wholesale Service Management helpdesk 3 How to login on BBCT First check accessing following URL http www bbct bt com broadbandbulkchangetool then select Click Here to Upload View WBC Migration Orders link to redirect to WBC migration website You will find a login screen You will need to provide your OMNumber username and password All these fields are mandatory You will see the following login screen After providing valid details OMNumber username and password the application will take you to the home page Z WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help aT eS WBC Migration Controller You have accessed a system operated by BT Wholesale which allows to place multiple single line migration orders In order to gain access you must login Customer ID OMNumber Username Password Submit Reset Forgot Password 4 Local intranet Page 5 of 66 BBCT wBC migrations CP user guide cre 4 Forgot Password Navigation BBCT URL gt WBC Migration link gt Login gt Forgot Password link Description If you forget your password then you will need to enter your BT email id on forgot password page Your password will be sent on this email id For this option the email has to be enabled in your profile a
3. Company_ TechnicalContact_ Fullname Company_ TechnicalContact_ Phonenumber Company_ TechnicalContact_ 24hourContactnumbe r Company_ TechnicalContact Email BT_ Accountmanager _Full name BT Accountmanager_Ph onenumber BT Accountmanager _Em ail Page 63 of 66 BBCT wBC migrations CP user guide Data ltem Remarks BT AAccountmanager_Fax number BT Accountmanager _Em ail Service_ Support_Helpdesk ERRORCODE Error Code ERRORTEXT Error Text ExistingProductCode f available Trailer record Data Item Remarks RECORD_TYPE Constant WBC_BULKMIG_TRL Fields in this section are as described earlier except for those below ErrorCode a code associated with the error text status code ErrorText error information relevant to the order that failed status message ExistingProductCode this is the name of the existing product returned to aid error diagnosis It is optional because there may be some failed orders e g with an invalid ServicelD where it can t be provided Sample Excel Exception file m WBCBULKMIGEXP_O M_2108_1 xls The same file can be corrected in case of format errors and re uploaded Page 64 of 66 BBCT wBC migrations CP user guide 18 Contact Us Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Contact Us Description This p
4. Total Records found 1 Download to Csv File Name Date Uploaded Order Count Service Provider Status Status changed date WBCLOC 0M32345678 12012008 2250 csy 11 03 2008 09 59 11 1 AMCOMP Unhandled Exception 24 06 2008 14 16 05 Local intranet Page 30 of 66 BBCT wBC migrations CP user guide 12 2 LQC Order Status Report Navigation BBCT URL gt WBC Migration gt login gt Successful Login gt Home gt Report gt Bulk Line Qualification Check gt Order Status OR BBCT URL gt WBC Migration gt login gt Successful Login gt Home gt Report gt Bulk Line Qualification Check gt File Status gt Drill down a particular file record File Name link Description Page to view the status of all orders from the uploaded LQC and Annex M LQC files The orders can be filtered based on the LQC file from which you uploaded network ID service ID installation DN status status change date and MDF ID Each order record has a link to view the LQC details Each order displays the predicted speed for ADSL and ADSL2 technologies In the case where the LQC details are fetched from the MPA instead of ONCE then the predicted columns will show the Maximum speed information rather than the actual predicted information which will be highlighted to the user with a sub heading Maximum In the case where a particular order has already been migrated and it is after migration LQC details are available
5. No it won t be used or if Auto then BT will decide whether it can be used or not Interleaving Yes No Auto AdvancedServicesOpt Mandatory used to Opt in or Opt out of Page 25 of 66 BBCT wBC migrations CP user guide BT Advanced Services available to users whose CPs are signed up for them either Yes or No RealTime Mandatory the realtime rate in kilobits per second Downstream Mandatory The downstream transmission rate in megabits per second If Upstream value is Annex M then the permissible Downstream values are 8Mbit s and 24Mbit s all values are case sensitive Upstream Mandatory The upstream transmission rate in kilobits per second Permissible values for the attribute are Uncapped Annex M and 448kKbit s all values are case sensitive MaintenanceClass Mandatory the maintenance category ror level of service that is provided Company_Contact_Sur name Optional The surname of the contact for the order Company_Contact_Firs thame Optional The first name of the contact This should match with the data on OS for the CP DUNS ID OS will send warning message if different and use the details from its database Company_Contact_Tel ephone Optional The telephone number of the contact Note that telephone numbers should contain the STD code including leading zero be
6. aspx Migration File Report Upload File Report Utilities Contact Us Logout 06 08 2008 18 36 08 AMCOMP Processed 06 08 2008 18 36 12 07 08 2008 ES AMCOMP Processed 07 08 2008 10 46 14 07 08 2008 11 27 39 AMCOMP Processed 07 08 2008 11 27 42 07 08 2008 12 15 11 AMCOMP Processed 07 08 2008 12 15 11 WBCBULKMIG 0M12345677 070701 xls pune 2006 AMCOMP Processed 07 08 2008 16 10 52 08 08 2008 14 37 42 AMCOMP Processed 08 08 2008 14 46 04 WBCBULKMIG OM 2108 5 csv qarna zoo8 AMCOMP Processed 08 08 2008 14 46 08 Local intranet Page 33 of 66 BBCT wBC migrations CP user guide BTE 12 5 Bulk Migration Order Status Report Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk Migration gt Order Status OR BBCT URL gt WBC Migration gt Successful login gt Home gt Report gt Bulk Migration gt File Status gt Drill down a particular file record File Name link Description A Page to view the status of all orders from the uploaded Migration files The orders can be filtered based on the Order Source Migration file from which they were uploaded the network ID the service ID the installation DN status status change date required by date and MDF ID Each order record has a link to view the migration details as well as another link to view the LQC details Each order displays the actual speed Th
7. 10 or 11 digits in length and must not contain spaces hyphens or any other de limiting characters Company_Contact_Em ail Optional The email address of the contact Company_Contact_Titl e Optional Company contact title e g Mr Mrs Company_Contact_lIniti als Optional Company contact initials Company_Contact_Ad dress Optional Company contact address information Company_Contact_Pos tcode Optional Company contact post code Company_Contact_Fax number Optional Company contact fax number Company_TechnicalCo ntact_Fullname Optional Company technical contact full name Page 26 of 66 BBCT wBC migrations CP user guide BTE Company_TechnicalCo ntact_Phonenumber Optional Company technical contact phone number Company_TechnicalCo ntact_24hourContactnu mber Optional Company technical contact 24 hour contact number Company_TechnicalCo ntact_Email Optional Company technical contact email address Company_TechnicalCo ntact_FaxNumber Optional Company technical contact fax number BT_Accountmanager_F ullname Optional BT Account manager full name BT_Accountmanager_ Phonenumber Optional BT Account number manager phone BT_Accountmanager_F axnumber Optional BT Account manager fax number BT_Accountmanager_ Email Optional BT Account address manager email
8. 11 digits in length and must not contain spaces hyphens or any other de limiting characters The email address of the contact Company contact title e g Mr Mrs Company contact initials Company contact address information Company contact post code Company contact fax number number Company_TechnicalCo ntact_Fullname Company_TechnicalCo ntact_Phonenumber Company_TechnicalCo ntact_24hourContactnu mber Company_TechnicalCo ntact_Email Company_TechnicalCo ntact_FaxNumber BT_Accountmanager_F ullname BT_Accountmanager_ Phonenumber BT_Accountmanager_F axnumber BT_Accountmanager_ Email Service_Support_Helpd esk ModifiedFT RCalc MTBERedThreshold MTBEGreenThreshold MTBRRedThreshold MTBRGreenThreshold BT Optional Company technical contact full name Optional Company technical contact phone number Optional Company technical contact 24 hour contact number Optional Company technical contact email address Optional Company technical contact fax number Optional BT Account manager full name Optional BT Account manager phone number Optional BT Account manager fax number Optional BT Account manager email address Optional Service support help desk number Attribute to enable user to retain 20 CN line rate Mean time between Error RedThreshold Mean time between Error GreenThreshold Mean time between Retrain RedThreshold Mean time between Retrain GreenThreshold 9 2 Migr
9. BBCT Message File must be CSV only Invalid Filename please try again in recommended format WBCLQCPosiMig_8MTransit_ CP Ident DDMMYYYY_HHMM csv WBCLQC_ CP Ident DDMMYYYY_HHMM xml Duplicate filename please try again in recommended format WBCLQCPosiMig_8MTransit_ CPldent _ DDM MYYYY_HHMM csv BCLQCPostMig_8MTransit_ CP Ident _ DDMMYYYY_HHMM xml Invalid Request type Please try again Invalid Header Please try again Page 22 of 66 Remarks Only CSV file can be uploaded if you try to upload any other file format it will display this message Filename format must be WBCLQCPosiMig_8MTransit_OM95205700_ 20112009 0706 csv filename should start with prefix WBCLQCPosiMig BBCT will perform file duplication check if same file exists previously then it will display this message Header validation e g first row must contain WBC_BULKLINEQUAL Multiple_Services If it fails to match with this format then it will display this message Second row must contain following sequence InstallationDN Serviceld Networkld MAC If it fails to match with this format then it will display this message BBCT wBC migrations CP user guide A BT Invalid Trailer Please try again Trailer Validation e g last row must contain WBC_BULKLINEQUAL_TRL If it fails to match with this format then it will display this message Missing Mandatory field Serviceld Networkld If no value
10. CP should have a valid email id and should select the option to receive notifications Given below is the format of the attached CSV file a WBCMigration_Failed _Orders_050908_To_ 21 Archive Database Description This is a job which runs at the back end and provides the ability to archive all migration Iqc and CPAllocation processed files that have been uploaded before a configurable period All orders corresponding to these files are also archived By default the archival period is to be set to 3 months Page 66 of 66 BBCT wBC migrations CP user guide
11. View LQC option in a particular order record Description Page that displays the LQC details for an order from Migration file A wec Migration Controller Microsoft Internet Explorer Fie Edit View Favorites Tools Help Qax O x Z une T TolsG up O Tools Events M E Leaming OL Tool Shop Address http flocalhost WBCMCWebApp wp8MOrderReportMain aspx Z WBC Migration Controller Web Page Dialog E Tools Lit Support X Upload File COMMITTED E Rg tocelintranet Page 42 of 66 BBCT wBC migrations CP user guide 12 12 Bulk LLU Migration File Status Report Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk LLU Migration gt File Status Description Page to view the status of LLU Migration files uploaded The files can be filtered on the basis of the file uploaded date status or status change date Each record contains a link to navigate to the orders page In the case where all the orders are at a stage where they have not been progressed to the downstream system i e with status scheduled then such a file can be entirely excluded using the Exclude File option In the case where the orders within a file have gone into error condition during validation then a list of such orders with their details is available in CSV format for CSV XML files and Excel format for Excel files via the Download Exception File option The page also facilitat
12. order or not The user can click OK to exclude the order with the selected exclusion reason and can click Cancel to revoke the exclusion of the order B soft Internet Explorer Fie Edit Help Ou O HAG Pw gym O 82 a UA Address http flocalhast WECMCDay4_450 wpFileStatusRepartMig aspx Migration File Report Upload File Report Utilities Contact Us Microsoft Internet Explorer 06 08 2008 18 36 08 08 2008 18 36 12 YD This will exclude this order from any Further processing Cx Cema 07 08 2008 10 46 05 a 07 08 2008 11 27 39 07 08 2008 WBCBULKMIG OM 2106892 csv ne 12 15 11 1 0 AMCOMP Processed 07 08 2008 12 15 11 bing B m AMCOMP Processed 07 08 2008 11 27 42 07 08 2008 WBCBULKMIG 0M12345677 070701 xls 16 08 15 AMCOMP Processed 07 08 2008 16 10 52 08 08 2008 14 37 42 AMCOMP Processed 08 08 2008 14 46 04 WBCBULKMIG OM 2108 5 csv gavoa 2008 AMCOMP Processed 08 08 2008 14 46 08 l oone amp C Local intranet Page 55 of 66 BBCT wBC migrations CP user guide 14 2 Order level Exclude Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk Migration gt Order Status gt Exclude Order Description In case all the order has not been progressed to the downstream system i e with status scheduled then such an order can be excluded using the Exclude Order option Page th
13. requesting CP can be cancelled using this process A CP can choose to process their requests in either REPORT Mode or EXECUTE Mode Note It is advisable that the CP validates the DNs using the REPORT mode functionality and then input the validated DNs for bulk cancellation in EXECUTE mode Page 50 of 66 BBCT wBC migrations CP user guide REPORT Mode BTE BTW will validate the requests and advise whether a cancel order can be raised against the requested DN BTW will not raise cancellations on the downstream systems if the request mode is REPORT EXECUTE Mode BTW will validate the requests and raise cancellations on the downstream systems for the valid requests 12 2 2 Input Attributes The following key attributes need to be present in the input file Row Attribute Name details Possible values Remarks Row 2 CP Name CP Contact Name CP Contact Tel No CP Contact Email ID CP Reference CP Contact details No validation performed This will be used to contact the CP for the progress Cosmoss Customer ID O M123456 etc CP identifier to validate ownership If invalid O M then BBCT will report in the log file Invalid CP identifier File not processed REPORT or EXECUTE REPORT BBCT will validate the file and generate log file EXECUTE BBCT will validate the file raise cancellations and generate log fi
14. this statistic can help users to decide whether to choose a WBC product option Sample CSV file format Note While editing the CSV file the user is required to open it in notepad or text pad instead of Excel This is because when opened in Excel formatting information is lost en WBCLQC_AnnexM_O M1i2345678_110420C 8 1 Input Attributes The input data required is as follows Attribute Length Remarks Remarks Request Type Mandatory Multiple Services Installation DN 11 Mandatory either One or more instances of Service ID 15 of DN or Service ID service identifiers Either of Network ID 12 or Network ID DN or Service ID or Network ID is Mandatory If the Installation DN is less than 11 characters in length and is not preceded by a 0 this might happen when user edits the file in CSV mode instead of notepad BBCT will automatically add a 0 to the Installation DN Optional Page 12 of 66 BBCT wBC migrations CP user guide BTE 8 2 Annex M LQC Upload Messages Following are failure success messages and their meaning when you upload Annex M LQC file on BBCT Message Selected file is not of type CSV Incorrect File Name Please see the example file naming convention Duplicate filename please try again in recommended format WBCLQC_AnnexM_ CP Ident DDMMYYYY_HHMM csv Invalid Request type Please try again Invalid Header Please try again Invalid Tra
15. with the selected cancellation reason and can click Cancel to revoke the cancellation of order Fie Edit view Om O AAG Aw ET E Address http jlocelhost WECMCDay4_450 wpMigrstionOrderReportMain aspx sve WBC Migration Controller Upload File Report Utilities Contact Us Logout Order Source Both Filename Status Pending On Fulfillment MDFID css District Exchange Select Customer Order Reference Source Service ID Network ID Order Type Required by Date From Status Change Date Fro D This will cancel this order from any further processing Order Creation Date Fri Cx Contractual Delivery D Total Records found 1 Download to Csv Customer Required Date Status Actual Line z Customer Contractual Cancel Status changed Speed Qualification KCIMessage E Gbps pika Group Id Delivery Date Order WBC Order Customer Order Product Installation Number Reference Name DN OSD OSD04 WBC End L750034282 User 01 09 2008 Pending on 07 08 2008 tg 15 07 2008 125999999 SERVIC Access 06 54 00 Fulfillment 12 15 11 00 00 00 AR_000000008T EUA 000000008T Bs B Local intranet 13 2 Bulk Cancellation 13 2 1 Requesting Bulk Cancellation CPs can provide their bulk cancellation requests to the BTW CS OPS in the prescribed format Only open Status Provide Pending On fulfillment migration orders raised via BBCT and which belong to the
16. 010 WBCLOCPostMiq 8MTransit 0M12121212 20082009 2014 csv waciocpostaia rTransit om12121212 20082009 2001 sv Page 39 of 66 BBCT wBC migrations CP user guide 12 9 8M Order Status Report Navigation BBCT URL gt WBC Migration gt login gt Successful Login gt Home gt Report gt 8M Transit Post Migration LQC gt Order Status OR BBCT URL gt WBC Migration gt login gt Successful Login gt Home gt Report gt 8M Transit Post Migration LQC gt File Status gt Drill down a particular file record File Name link Description Page to view the status of all orders from the 8M files The orders can be filtered based on the LQC file from which you uploaded network ID service ID installation DN Each order record has a link to view the LQC details Each order displays the predicted speed for ADSL and ADSL2 technologies In the case where the LQC details are fetched from the MPA instead of ONCE then the predicted columns will show the Maximum speed information rather than the actual predicted information which will be highlighted to the user with a sub heading Maximum In the case where a particular order has already been migrated and it is after migration LQC details are available but then the actual speed columns will display the actual speed information For such orders the comparison column shows whether the actual speed is equal to or greater than the predicted speed Green or is it less than the
17. 13 2 3 Bulk Cancellation Log The Bulk Cancellation Logs will be available with the BTW CS OPS It is a simple txt file Given below is the sample log file Page 52 of 66 BBCT wBC migrations CP user guide on Ea OM123456_SampleFil e_BulkCancel_log_ddi 13 2 4 Bulk Cancellation Progress Reporting The CP can monitor the progress of cancellations via the existing BBCT GUI Bulk Migration Order Status Report Note CPs can download the Bulk Migration Order Status Report in csv format They can export the csv file in excel format and using the filter option the orders cancelled via the Bulk Cancellation process can be filtered using the Cancelled By BBCT_BULK_CANCEL Orders cancelled via the Bulk Cancellation process will have the Cancelled By user as BBCT_BULK_CANCEL Page 53 of 66 BBCT wBC migrations CP user guide 14 How to Exclude Orders You can exclude those orders which are within BBCT and have not been taken for any migration process to downstream components Exclusion is available at file level and order level 14 1 File level Exclude Navigation BBCT URL gt WBC Migration gt Login gt Successful Login gt Home gt Report gt Bulk Migration gt File Status gt Exclude Last column There are 2 steps Description In case all the orders in file are at a stage where they have not been progressed to the downstream system i e with status scheduled then such a file
18. BC migrations CP user guide Version Issue 4 4 Issue 4 5 Issue 4 6 Issue 4 7 Page 2 of 66 Date 26 1 1 2009 09 12 2009 22 02 2010 14 10 2010 BTE Author Reason BBCT Including Annex M LQC upload page details upload messages and changes in upload screen for LQC and Migration files ModifiedF TRCalc to be made optional Adding the upload file screen shot Including 8M Transit upload files and reports new module Including DLM changes for migration BBCT wBC migrations CP user guide Contents Document History Introduction How to register for access on BU saccccit eda tee sisted alec hdampatistd ceca octededetiaaeest 5 How t l gin On BBG sscessccvsshavtirelcssisaltvrasdetace Nauti A A 5 Forgot Password Password Send Confirmation Home Page Placing Line Qualification Check orders 7 1 Input Attributes 7 2 LQC Upload Messages 7 3 Uploading file from user s machine Placing Annex M Line Qualification Check orders 8 1 Input Attributes 8 2 Annex M LQC Upload Messages 8 3 Uploading file from user s machine 9 Placing Bulk migration orders 9 1 Order Attributes 9 2 Migration Upload Messages 9 3 Uploading file from user s machine 10 Placing 8M orders 10 1 Input attributes 10 2 8M Upload Messages 10 3 Uploading file from user s machine 11 Placing Bulk LLU migration orders 11 1 Order Attributes 11 2 Migration Upload Messages 11 3 Uploading file from user s machine 12 Reports 12 1 LQC Fil
19. BTE BBCT WBC Migration CP User Manual Document History Version Date Author Reason Draft 0 1 06 05 2008 BBCT First Draft upon designed functionality for CP s Draft 0 2 06 06 2008 BBCT Added new web pages of Day2 functionality Draft 0 3 02 09 2008 BBCT Added new web pages for Day4 functionality Issue 2 21 10 2008 BBCT Update Details of Migration Order Entry Issue 3 11 05 2009 BBCT Added details for Bulk Cancellations via BBCT Issue 3 1 20 05 2009 BBCT Added details of functionality regarding addition of leading 0 in Installation DN if not present Issue 3 2 20 05 2009 Updated sample Excel file which is being used for uploading WBC Migration orders and re attached LQC Migration Bulk cancel sample files in zipped format to enable direct file download without any data loss Issue 4 22 05 2009 Update new attribute ModifiedFTRCalc for 20CN line retention Issue 4 1 26 05 2009 Updated the document as per the review comments from Legal Representative Issue 4 2 26 08 2009 Updated screenshots for LQC order status report LQC order details and Bulk Migration Order Details as per BS WBC MIG 360 a b Added one more status for BS WBC MIG 360 a and elaborated the meaning of the status Invalid Requiredby Date Updated Migration file excel templates to Issue 15 Issue 4 3 18 09 2009 BBCT Including New CP Status message Validation Completed No Broadband exists on this line Page 1 of 66 BBCT w
20. CMCWebApp wpLOCOrderReportMain aspx Fileld 75aUserld 1091 z Go Links gt Z WBC Migration Controller Web Page Dialog Upload File 91929221124 Opening page http localhost WBCMCWebApp wplQCOrderReportMain aspx FilelId 75 amp UserId 1091 Page 32 of 66 BBCT wBC migrations CP user guide 12 4 Bulk Migration File Status Report Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk Migration gt File Status Description Page to view the status of Migration files uploaded The files can be filtered on the basis of the file uploaded date status or status change date Each record contains a link to navigate to the orders page In the case where all the orders are at a stage where they have not been progressed to the downstream system i e with status scheduled then such a file can be entirely excluded using the Exclude File option In the case where the orders within a file have gone into error condition during validation then a list of such orders with their details is available in CSV format for CSV XML files and Excel format for Excel files via the Download Exception File option The page also facilitates the user to download the entire report in CSV format Z WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Om O A BG Paw from O 8 2 ais Address http flocalhost WBCMCDay4_450 wpFileStatusReportMig
21. FaxNumber BT_Accountmanager_Fullname BT_Ac countmanager_Phonenumber BT_Accountmanager_Faxnumbe r BT_Accountmanager_Email Service_Support_Helpdesk Modif iedFTRCalc MTBERedThreshold MTBEGreenThreshold MTBRRedThreshold MTBRGreenThreshold RateBandUS RateBandDS InterleaveDepthUS InterleaveDepthDS TargetMarginDepthUS TargetMarginDepthDS FTRValueUS FTRValueDS If it fails then it will display this message Page 28 of 66 BBCT wBC migrations CP user guide AS BT Note All green attributes are optional it requires column title only in second row it can be blank in actual data row Invalid Trailer Please try Trailer Validation e g last row must contain again WBC_BULKMIG_TRL If it fails to match with this format then it will display this message Missing Mandatory field value Mandatory and optional field value check fieldname at row 3 If this check fails then it will display this message File uploaded successfully If file passes through all above validations then it will display success status to users 11 3 Uploading file from user s machine Navigation gt WBC Migration gt Login gt Successful login gt Home gt Upload menu gt Bulk LLU Migration Description Page to upload bulk LLU migration file The user will be able to see the estimated time to commence processing of the uploading Migration file as shown below The user will have to choose an appropriate file format XML CSV Excel
22. Help O AAG Poe genom O B D 6 DM2B Address http localhost WECMCWebApp 00 wpHome aspx Home Utilities Bulk Line Qualificd pload Fie Bulk Migration Annex M Bulk Line Qual Check 8M Transit Post Migration LQC Done Local intranet Description Page to upload Annex M Line Qualification Check file This option is to report on Annex M line qualification only The user will be able to see the estimated time to commence processing of the uploading Annex M LQC file as shown below The user will have to ensure the file is in the correct format CSV with the correct naming convention as shown in the example screen below and then provide the file path from local machine location On upload the user will be able to see the appropriate success error message as described above The sample file naming convention will be shown continuously on the upload screen as shown below Page 14 of 66 BBCT wBC migrations CP user guide Z WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Q O 2 A Dew eres 8 1 Ss Address E http localhost WBCMCWebApp wpaAnnexMUpload aspx Uploading File for Line Qual Annex M Upload File Report Utilities Contact Us Page 15 of 66 BBCT wBC migrations CP user guide BTE 9 Placing Bulk migration orders The user can place migration orders on BBCT which can be a singleton order or a multiple singleton order BBCT supports
23. Local intranet Sample CSV Exception file E D RET_WBCBULKMIG_ OM62003700_08042 WBC Migration Exception Responses A response file is sent to the customer if any of their submitted orders within a batch have failed It will include the original orders with associated error information The filename of the response file will be the filename of the original order file preceded by RET_ Page 61 of 66 BBCT wBC migrations CP user guide Header record BTE Data Item Remarks RECORD_TYPE Constant WBCBULKMIG_RESPONSE RUN_TS The date and time when this extract started Format YYYYMMDDTHH MM SS Detail record Data Item Remarks BuyerlD IssueDatTime KCIType SellerAssignedAccou ntID CPDUNSID BTWDUNSID Sellersltemldentificati on BuyersLineNumber CustomerRequiredDa te InstallationDN MAC CustomerID Serviceld AccessTechnology StabilityOption TrafficWeighting Interleaving AdvancedServicesOp t In RealTime Downstream Page 62 of 66 BBCT wBC migrations CP user guide Data Item Remarks Upstream MaintenanceClass Company _ Contact Title Company_Contact Surname Company_Contact_ Firstname Company_Contact_ Initials Company_Contact Address Company_Contact Postcode Company_Contact_F laxnumber
24. MigrationOrderReportMain aspx Z WBC Migration Controller Web Page Dialog Migration Orc Upload File Page 38 of 66 BBCT wBC migrations CP user guide 12 8 8M File Status Report Navigation BBCT URL gt WBC Migration gt login gt Successful Login gt Home gt Report menu gt 8M Transit Post Migration LQC gt File Status Description Page to view 8M file details The files can be filtered on basis of file uploaded date status or status change date Each record contains a link to navigate to the orders page Sorting ascending descending is allowed on all fields you need to click on column header for sorting The page also facilitates the user to download the entire report in CSV format WBC Migration Controller Microsoft Internet Explorer File Edit view Favorites Tools Help Q sxx 7 x A gt irks af TolsGfup OTools Events MIELeaming O ToolShop E Tools List W Support Address ja http localhost WBCMCWebApp wpFileStatusReport8M aspx z Go o E E 01 03 2010 Processed 01 03 2010 14 36 12 14 36 40 g r 01 03 2010 A 01 03 2010 WBCLOCPostMiq 8MTransit 0M12121212 20082009 0006 csv 15 09 49 3 0 kiran Processed 15 10 08 kng F 24 02 2010 24 02 2010 WBCLOCPostMig 8MTransit 0M12121212 20082009 1003 csv 12 14 39 0 0 kiran Processed 12 40 23 25 02 2010 25 02 2010 18 53 24 Biran Processed 15 53 40 TT TT T tocatintranet 3 F 01 03 2010 01 03 2
25. Order Report Upload File Report Utilities Contact Us Logout i WBC Migration Controller Microsoft Internet Explorer A A WBC End aooon000an 125999999 0 User 01 08 2008 Formatting 06 08 2008 Access 16 40 00 18 36 12 SERVIC_000000008Q EUA G 000000008 OSD OSD04 L750034282 125 User 01 08 2008 SERVIC_000000008U 16 40 00 Local intranet Page 36 of 66 BBCT wBC migrations CP user guide 12 6 Bulk Migration Order Details Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk Migration gt Order Status gt Drill down a particular order record Description Page that displays the Migration details for an order from Migration file I WBC Migration Controller Microsoft Internet Explorer Fie Edit View Favorites Tools Help Om O DAG aw gro AB e VM Z WBC Migration Controller Web Page Dialog Migration Order Local intranet Page 37 of 66 BBCT wBC migrations CP user guide 12 7 Bulk Migration Order LQC Details Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk Migration gt Order Status gt Drill down using the View LQC option in a particular order record Description Page that displays the LQC details for an order from Migration file itroller Microsoft Internet Explorer Help Q O h A Alpe grms 2 Jide Ss Address 6 http localhost WBCMCWebApp wp
26. WBC Migration Controller Microsoft Internet Explore File Edit View Favorites Tools Help EK a are WBC Migration Controller Email ID Demo demolcom amp Local intranet Page 6 of 66 BBCT wBC migrations CP user guide 5 Password Send Confirmation Navigation BBCT URL gt WBC Migration link gt Forgot Password link gt Enter the email ID gt Submit Description A Confirmation page that the password has been sent to the user s email ID will appear a WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help era WBC Migration Controller Thank You Your Password will be sent to you via Email Login Local intranet Page 7 of 66 BBCT wBC migrations CP user guide 6 Home Page Navigation BBCT URL gt WBC Migration link gt login gt Successful login Description The application will take you to the following home page You can use different options like uploading files viewing reports utilities logout from menu on top of web page E WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Qa x 2 QD Preah rores O 2 2 a LG Address http flocalhost WBCMCDay4_450 wpHome aspx ETN WBC Migration Controller amtest Upload File Report Utilities Contact Us Logout Welcome to WBC Migration Controller This application will allow you to place multiple single line migration orders and
27. age displays the contact details to user for any help needed WBC Migration Controller Microsoft Internet Explorer Jes File Edit View Favorites Tools Help Q O ha JO search she revortes 2 2 amp H Address http localhost WBCMCDay4_450 wpContactUs aspx Bo p ore WBC Migration Controller amtest Upload File Report Utilities Contact Us Logout For Any Troubleshooting Please Contact BT Help Desk Contact No 0880 8008 BT Help Desk E mail Id bbct infosys com Local intranet Page 65 of 66 BBCT wBC migrations CP user guide BTE 19 Download User manual Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Utilities gt Download User manual Description On clicking this link in the menu toolbar the CP will be redirected to this URL http www btwholesale com pages static Products Internet Wholesale Broadband Connect wBB C Migrations html 20 Send Error Mail Notification Description This is a service which runs once every day at a configured time At the Order level after all the validation is performed and if an order is found to be incorrect then an email notification will be sent along with the CSV attachment displaying all the errors during the order validation stage from the downstream system for the CP Order level validation should always have the Customer Reference No and Error messages For an error mail to be sent to CP the
28. aintenanceClass Compa ny_Contact_Surname Company_Contact_Firstname Company _Contact_Telephone Company_Contact_Email Company_Cont act_Title Company_Contact_Initials Company_Contact_Addres s Company_Contact_Postcode Company_Contact_Faxnumber Company_TechnicalContact_Fullname Company_TechnicalCo ntact_Phonenumber Company_TechnicalContact_24hourConta ctnumber Company_TechnicalContact_Email Company_Techni calContact_FaxNumber BT_Accountmanager_Fullname BT_Ac countmanager_Phonenumber BT_Accountmanager_Faxnumbe r BT_Accountmanager_Email Service_Support_Helpdesk Modif iedFTRCalc MTBERedThreshold MTBEGreenThreshold MTBRRedThreshold MTBRGreenThreshold If it fails then it will display this message Note All green attributes are optional it requires column title only in second row it can be blank in actual data row Invalid Trailer Please try Trailer Validation e g last row must contain again WBC_BULKMIG_TRL If it fails to match with this format then it will display this message Missing Mandatory field value Mandatory and optional field value check fieldname at row 3 If this check fails then it will display this message File uploaded successfully If file passes through all above validations then it will display success status to users Page 20 of 66 BBCT wBC migrations CP user guide 9 3 Uploading file from user s machine Navigation gt WBC Migration gt Login gt Successful login gt Home gt Upload
29. and then provide the file path from the local machine s location On upload the user will be able shown the appropriate success error message i wec Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help O O HAG Poe prom O A 2 E Address http flocalhost WECMCWebApp wpLLUUpload aspx Upload File for Bulk LLU Migration Upload File Utilities 4 Local intranet Page 29 of 66 BBCT wBC migrations CP user guide BTE 12 Reports 12 1 LQC File Status Report Navigation BBCT URL gt WBC Migration gt login gt Successful Login gt Home gt Report menu gt Bulk Line Qualification Check gt File Status Description Page to view LQC and Annex M LQC file details The files can be filtered on basis of file uploaded date status or status change date Each record contains a link to navigate to the orders page Sorting ascending descending is allowed on all fields you need to click on column header for sorting The page also facilitates the user to download the entire report in CSV format Z WBC Migration Controller Microsoft Internet Explorer DHK Fie Edit View Favorites Tools Help Qw O HAD Pwo krs O 2 2 A Address http localhost WBCMCDay4_450 wpFileStatusReportLQC aspx a gt Kea N re WBC Migration Controller Upload File Report Utilities Contact Us Logout Files Uploaded Date From l E To Status Select Status Change Date From i To Fetch Reset
30. at takes input of the Exclusion reason for a particular order and on submit it will prompt user for confirmation of the same A soft Internet Explorer File Edit Vi Q gt x a e JO search she ravortes 2 Br amp m We Address http localhost WBCMCDay4_450 wpMigrationOrderReportMain aspx Fileld 6908Userld 1053 Migration Order Report T Help Upload File Report Utilities Contact Us 0SD 0SD04 L750034282 WeCrend l rete 000000008T 125999999 SERVIC wees Te Sadi Scheduled me AR_000000008T EUA Be be OSD OSD04 L750034282 125 WBC End miyne0cd 000000008R SERVIC ARUN pel 164000 YAD 000000008R eA sites Local intranet Page 56 of 66 BBCT wBC migrations CP user guide B Navigation BBCT URL gt WBC Migration gt Login gt Successful Login gt Home gt Report gt Bulk Migration gt gt File Status gt Exclude gt Submit Description Page that confirms if user really wants to exclude the order or not The user can click OK to exclude the order with the selected exclusion reason and can click Cancel to revoke the exclusion of order soft Internet Explorer Q O aae PE E 2 an W Address http localhost WBCMCDay4_450 wpMigrationOrderReportMain aspx Fileld 6908LIserld 1053 Migration Order Report Upload File Report Utilities Contact Us 2d WBC Migration Controller We ialog Microsoft Internet Explorer 3 This will exclude this order from any further processi
31. ation Upload Messages Following are failure success messages when you upload migration file on BBCT Message Remarks Selected file is not of type Only CSV XML EXCEL file can be uploaded if you try to XML CSV EXCEL upload any other file format it will display this message Invalid Filename please try Filename format must be again in recommended format WBCBULKMIG_OM12345678_09012008_ 1523 filename Page 19 of 66 BBCT wBC migrations CP user guide BTE WBCBULKMIG_ CP should start with prefix WBCBULKMIG Ident DDMMYYYY_HHMM cs v WBCBULKMIG_ CP Ident DDMMYYYY_HHMM x ml Duplicate filename please try BBCT will perform file duplication check if same file exists again in recommended format previously then it will display this message WBCBULKMIG_ CP Ident DDMMYYYY_HHMM cs v WBCBULKMIG_ CP Ident DDMMYYYY_HHMM x ml Invalid Header Please try Header validation e g first row must contain again WBC_BULKMIGV2 If failed then it will display this message Invalid Header Column Second row must contain following sequence names Please try again BuyerlD lssueDateTime KCIType SellerAssignedAccountID CP DUNSID RESELLERCPDUNSID BTWDUNSID Sellersltemlden tification BuyersLineNumber CustomerRequiredDate nstallatio nDN MAC CosmossCustomerID SourceServiceld AccessTechn ology StabilityOption TrafficWeighting Interleaving AdvancedSe rvicesOpt In RealTime Downstream Upstream M
32. but then the actual speed columns will display the actual speed information For such orders the comparison column shows whether the actual speed is equal to or greater than the predicted speed Green or is it less than the predicted speed Red The page also facilitates the user to download the entire report in CSV format Z WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Q O h A OD Dee rs O 2 Sa Jd BS Address ja http fflocalhost WBCMCWebApp wpLQCOrderReportMain aspx Fileld 1 amp UserlId 1091 gt BE Links 5 LQC Order Report Upload File Utilities WBCLQC_OM95205700_21102009_0701 csv v xj Select E ADSL2 Service 01234563988 Speedis 56 000 12 000 Scheduled 24 10 2009 Se 17 00 00 available javascript __doPostBack UctlLQCOrderDisplayReports _ctlog_ctl2 _ctl11 P Rad Localintranet Page 31 of 66 BBCT wBC migrations CP user guide 12 3 LQC Order Details Navigation BBCT URL gt WBC Migration gt Login gt Successful Login gt Home gt Report gt Bulk Line Qualification Check gt Order Status gt Drill down a particular order record Installation DN link on third column Description Page that displays the LQC details for an order from LQC or Annex M LQC file aw BC Migration Controller Microsoft Internet Explorer _ File Edit View Favorites Tools Help Qa O 2 AG Psat gore O 2 a UL S Address ja http localhost WB
33. can be entirely excluded using the Exclude File option Whenever the user clicks on Exclude File icon a pop up will be displayed which asks the user to select an exclusion reason from the drop down as shown in the below given screenshot Submitting it would then prompt the user for further confirmation of the same A T WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help O O HAD Powe krens O 8 2 a WA Address http flocalhast WBCMCDay4_450 wpFileStatusReportMig aspx Migration File Report Upload File Report Utilities Contact Us Logout 06 08 2008 ere WBCBULKMIG OM 2106778 csv 136 18 36 08 08 2008 18 36 12 07 08 2008 Duplicate CdS CBULKMIG OM 2106782 c 3 146 WB G 0 2 csv 10 46 05 Sul mil j 708 2008 10 46 14 07 08 2008 127 11 27 39 AMCOMP Processed 07 08 2008 11 27 42 AMCOMP Processed 07 08 2008 12 15 11 07 08 2008 12 15 11 WBCBULKMIG 0M12345677_ 070701 xIs pze067 2008 AMCOMP Processed 07 08 2008 16 10 52 08 08 2008 14 37 42 AMCOMP Processed 08 08 2008 14 46 04 WBCBULKMIG OM 2108 5 csv EA AMCOMP Processed 08 08 2008 14 46 08 Page 54 of 66 BBCT wBC migrations CP user guide B Navigation BBCT URL gt WBC Migration gt Login gt Successful Login gt Home gt Report gt Bulk Migration gt gt File Status gt Exclude gt Submit Description Page that confirms if the user really wants to exclude the
34. cing one order at a time and CSV file for placing bulk orders There are 2 types of LLU files LLU H and LLU Sample CSV file format Note While editing the CSV file the user is required to open it in notepad textpad instead of Excel This is because when opened in Excel formatting information is lost WBCBULKMIG_LLU H WBCBULKMIG_LLU_ _OM95193701_1210 OM95193700_12082 Sample XML file format refer C7 XML documentation WBCBULKMIG_LLU H WBCBULKMIG_LLU_ _OM12345670_3108 OM12345676_02062 Sample Excel File format EHL Excel_Design Template xlsx WBCBULKMIG_LLU H WBCBULKMIG _LLU_ _OM12345678_0206 OM12345678_06082 11 1 Order Attributes The input data required is as follows Column Name Length Mandatory Optional Description BuyerlD 39 Mandatory A unique message identifier for the order from the CP IssueDateTime Mandatory Input from CRF KClIType Mandatory Keep Customer Informed method SellerAssignedAccountl Mandatory Billing Account number Sellers D Assigned Account ID Column E in excel file is formatted as text Page 24 of 66 BBCT wBC migrations CP user guide BTE to enable leading zeros to be entered CPDUNSID Mandatory the active DUNS number for the CP RESELLERCPDUNSID Optional the DUNS number of the third party CP BTWDUNSID Mandatory the BT Wholesale DUNS number Sellersltemldentificatio n Mandatory the na
35. csv WBCBULKMIG_LLU H_OMxxxxxxxx_ddMMyyyy_H Hmm csv Invalid Header Please try again Invalid Header Column names Please try again Remarks Only CSV XML EXCEL file can be uploaded if you try to upload any other file format it will display this message Filename format must be WBCBULKMIG_LLU H_OM95193701_13102010_1233 csv WBCBULKMIG_LLU_OM95193700_02062010_1600 csv Filename should start with prefix WBCBULKMIG_LLU H_ BBCT will perform file duplication check if same file exists previously then it will display this message Header validation e g first row must contain WBC_BULKMIGV2 If failed then it will display this message Second row must contain following sequence BuyerlD lssueDateTime KCIType SellerAssignedAccountID CP DUNSID RESELLERCPDUNSID BTWDUNSID Sellersltemlden tification BuyersLineNumber CustomerRequiredDate Installatio nDN MAC CosmossCustomerlD SourceServiceld AccessTechn ology StabilityOption TrafficWeighting Interleaving AdvancedSe rvicesOpt In RealTime Downstream Upstream MaintenanceClass Compa ny_Contact_Surname Company_Contact_Firstname Company _Contact_Telephone Company_Contact_Email Company_Cont act_Title Company_Contact_Initials Company_Contact_Addres s Company_Contact_Postcode Company_Contact_Faxnumber Company_TechnicalContact_Fullname Company_TechnicalCo ntact_Phonenumber Company_TechnicalContact_24hourConta ctnumber Company_TechnicalContact_Email Company_Techni calContact_
36. e Status Report 12 2 LQC Order Status Report 12 3 LQC Order Details 12 4 Bulk Migration File Status Report 12 5 Bulk Migration Order Status Report 12 6 Bulk Migration Order Details 12 7 Bulk Migration Order LQC Details 12 8 8M File Status Report 12 9 8M Order Status Report 12 10 8M Order Migration Details 12 11 8M Order LQC Details 12 12 Bulk LLU Migration File Status Report 12 13 Bulk LLU Migration Order Status Report 12 14 Bulk LLU Migration Order Details 12 15 Bulk LLU Migration Order LQC Details Page 3 of 66 BBCT wBC migrations CP user guide 12 16 CP Forecasting Report 13 How to Cancel Orders ccccccccccccccccccececececececececececececececececececesecesacecacecaceeaceeecaeanags 48 13 1 Cancel Order from BBCT GUI 13 2 Bulk Cancellation 13 2 1 Requesting Bulk Cancellation 12 2 2 Input Attributes 13 2 3 Bulk Cancellation Log 13 2 4 Bulk Cancellation Progress Reporting 14 How to Exclude Orders ccccessscccccecessessnsececeseceesensnseaecececeesessssaeseseccesesesenseaeeeeees 54 14 1 File level Exclude 14 2 Order level Exclude 15 Edit Profile 16 BBCT Status amp their meaning 17 Download Exception file 18 Contact Us 19 Download User manual 20 Send Error Mail Notification 21 Archive Database Page 4 of 66 BBCT wBC migrations CP user guide BTE 1 Introduction The document describes WBC migration functionality available for CP users on BBCT web site 2 How to register for access on BBCT
37. e technology to which the migrated circuit belongs is indicated in this actual speed column In the case where an order has not progressed to the downstream system OneSiebel i e it is in the status scheduled then that order can be excluded from migration using the Exclude Order option In case an order has progressed to downstream system OneSiebel and is at the stage Pending on Fulfillment then such order can be cancelled from migration using the Cancel Order option The page also facilitates the user to download the entire report in CSV format Page 34 of 66 BBCT wBC migrations CP user guide 2 WBC Migration Controller Microsoft Interr File Edit View Favorites Tools Help Om O HAG Pwo rn O 8 2 a WM Address http flocalhast WBCMCDay4_450 wpMigrationOrderReportMain aspx Fileld 6908LserId 1053 Migration Order Report File Report Utilities Contact Us OSD OSD04 WBC End oooooooogr 4750034262 125 ser 1 08 2008 Formatting 07 08 2008 SERV RUN ccess 00 45 YAD_000000008R EUA Page 35 of 66 BBCT wBC migrations CP user guide B Orders having either the status Format Error or Rejected are displayed as a link and on clicking on it the error details will be shown as a popup oft Internet Explorer Help Geox i o JO search she Favortes Ka B we m a Address http flocalhast WECMCDay4_450 wpMigrationOrderReportMain aspx Fileld 6908LIserId 1053 Migration
38. es the user to download the entire report in CSV format amp WBC Migration Controller Microsoft Internet Explorer File Edit view Favorites Tools Help Om O DAO Pave prom BB e WM 2 Address amp http localhost WBCMCWebApp wpFileStatusReportLLU aspx LLU Migration File Report Upload File Utilities a Jas Fetch WBCBULKMIG LLU H_0M95193701 01092010 1600 csv proei2010 Processed 1 09 2020 01 10 2010 01 10 2010 09 32 13 Processed 09 34 07 WBCBULKMIG LLU 01 10 2010 01 10 2010 H_0M95205700 23092010 BulkLLu test76 csv 14 04 24 Processed 14 05 01 i o SB bocalintranet Page 43 of 66 BBCT wBC migrations CP user guide 12 13 Bulk LLU Migration Order Status Report Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk LLU Migration gt Order Status OR BBCT URL gt WBC Migration gt Successful login gt Home gt Report gt Bulk LLU Migration gt File Status gt Drill down a particular file record File Name link Description A Page to view the status of all orders from the uploaded LLU Migration files The orders can be filtered based on the Order Source Migration file from which they were uploaded the network ID the service ID the installation DN status status change date required by date and MDF ID Each order record has a link to view the migration details as well as another link to view t
39. ex M is not For Annex M order when supported on this ADSL2 RAG and Annex M line Alternative RAG are not GREEN upstream options are available Page 60 of 66 BBCT wBC migrations CP user guide 17 Download Exception file Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Reports gt Bulk Migration gt File Report Description In case one or few or all orders within a file have gone into error condition during validation then the list of such orders with their details is available in CSV format for CSV XML files and Excel format for Excel files via the Download Exception File option Z WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Om O AAO Paw geome O 8S a VA Address http flocalhast WECMCDay4_450 wpFileStatusRepartMig aspx sve Migration File Report Upload File Report Utilities Contact Us Logout an fe 06 08 2008 18 36 08 AMCOMP Processed 06 08 2008 18 36 12 07 08 2008 146 10 46 05 AMCOMP Processed 07 08 2008 10 46 14 07 08 2008 1271 11 27 39 AMCOMP Processed 07 08 2008 11 27 42 07 08 2008 15 12 15 11 AMCOMP Processed 07 08 2008 12 15 11 WBCBULKMIG 0M12345677 070701 xIs eke E AMCOMP Processed 07 08 2008 16 10 52 08 08 2008 14 37 42 AMCOMP Processed 08 08 2008 14 46 04 14 42 19 WBCBULKMIG OM 2108 5 csv 08 08 2008 AMCOMP Processed 08 08 2008 14 46 08 i
40. f no value supplied for either Serviceld Networkld DN in CSV file then this message will be displayed If file passes through all above validations then it will display success status to users BBCT wBC migrations CP user guide 7 3 Uploading file from user s machine Navigation BBCT URL gt WBC Migration link gt Login gt Successful login gt Home gt Upload File menu gt Bulk Line Qualification Check Description Page to upload LQC file The user will be able to see the estimated time to commence processing of the uploading LQC file as shown below The user will have to choose an appropriate file format XML CSV and then provide the file path from local machine location On upload the user will be able to see the appropriate success error message as described above 4 WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Qm O 2 A G Dan eee Oo Sesh 8 k Address http localhost wBCMCwebApp wpUploadFie aspx mode LQC SS G0 Links Upload File for Line Qualification Check Upload File Report Utilities Contact Us Pio Page 11 of 66 BBCT wBC migrations CP user guide BTE 8 Placing Annex M Line Qualification Check orders Line Qualification of Annex M orders is optional Users can perform this step before placing migration orders to check current line status data of Annex M orders This will give you the predicted speed for WBC Products and by using
41. he LQC details Each order displays the actual speed The technology to which the migrated circuit belongs is indicated in this actual speed column In the case where an order has not progressed to the downstream system OneSiebel i e it is in the status scheduled then that order can be excluded from migration using the Exclude Order option In case an order has progressed to downstream system OneSiebel and is at the stage Pending on Fulfillment then such order can be cancelled from migration using the Cancel Order option The page also facilitates the user to download the entire report in CSV format Z WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help O O DAO Nowe genom 22 e WH 2 Address http jlocalhost WECMCWebApp wpLLUOrderReportMain aspx raised via BBCT WBCBULKMIG_LLU H_OM95205700_23092010_BulkLLu_test74 csv Select as ee es a Page 44 of 66 BBCT wBC migrations CP user guide B Orders having either the status Format Error or Rejected are displayed as a link and on clicking on it the error details will be shown as a popup 2 wee Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help O O HAG Pwo from O BS amp WH id Address http flocalhost WBCMCWebApp wpLLUOrderReportMain aspx E LLU Migration Order Report Upload File Utilities i WBC Migration Controller Microsof
42. iler Please try again Missing Mandatory field Serviceld Networkld DN value at row 3 File uploaded successfully Page 13 of 66 Remarks Only CSV file can be uploaded if you try to upload any other file format it will display this message Filename format must be WBCLQC_AnnexM_OM12345678_09012008_1523 filename should start with prefix WBCLQC_AnnexM BBCT will perform file duplication check if same file exists previously then it will display this message Header validation e g first row must contain WBC_BULKLINEQUAL Multiple_Services If it fails to match with this format then it will display this message Second row must contain following sequence InstallationDN Serviceld Networkld MAC If it fails to match with this format then it will display this message Trailer Validation e g last row must contain WBC_BULKLINEQUAL_TRL If it fails to match with this format then it will display this message If no value supplied for either Serviceld Networkld DN in CSV file then this message will be displayed If it passed through all above validations then it will display success status to users BBCT wBC migrations CP user guide 8 3 Uploading file from user s machine Navigation BBCT URL gt WBC Migration link gt Login gt Successful login gt Home gt Upload File menu gt Annex M Line Qual Check i WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools
43. le Header Information Installation DN Installation DN Header information No validation performed Row 8 to Rown Asset details to be cancelled i e DN or End of File identifier EOP Installation DN s to be cancelled or End of File identifier EOF BBCT will first check if the DN is 11 characters in length If less then it will add a leading 0 to it if not present BBCT will validate the DN for completeness check whether the migration order against the DN 1 belongs to the CP requesting cancellation 2 Page 51 of 66 BBCT wBC migrations CP user guide BTe order status Provide Pending on Fulfillment or any other valid open order status and 3 order raised via BBCT If above conditions are true then raise cancellation on downstream system if EXECUTE mode EOF This will identify the end of file BBCT will stop processing the file if either of the below is true 1 it encounters EOF or 2 1008th row Sample Input file The filename format of the input file will be CP Identifier _ FileReference _BulkCancel csv Given below is the sample input file Note While editing the CSV file the user is required to open it in notepad or textpad instead of Excel This is because when opened in Excel formatting information is lost OM12345678_InputF ile_BulkCancel zip OM12345678_InputF ileWithSampledata_Bt
44. me of the product being ordered i e WBC End User Access EUA BuyersLineNumber Mandatory BBCT will prefix BULKMIG to this attribute so that this can be used to identify the order as Bulk Migration order CustomerRequiredDate Mandatory Input to BBCT Format will be YYYY MM DDTHH MM SS InstallationDN Optional Telephone number on which the service is to be provided Note that telephone numbers should contain the STD code including leading zero be 10 or 11 digits in length and must not contain spaces hyphens or any other de limiting characters Installation Directory Number DN Column L in excel file is formatted as text to enable leading zeros to be entered If a user missed leading 0 in Installation DN BBCT would automatically add the same MAC Optional Migration key CosmossCustomerID Optional OMNumber for Service provider SourceServiceld Mandatory Service id AccessTechnology Mandatory The type required either ADSL ADSL2plus StabilityOption Mandatory Can be either Standard Stable or Super Stable TrafficWeighting Mandatory The choice of weighting will effect the user response at times of contention with Elevated getting a higher proportion of the available bandwidth either Standard Elevated Interleaving Mandatory Used to define the Interleaving status of the line Yes it will be used
45. menu gt Bulk Migration Description Page to upload bulk migration file The user will be able to see the estimated time to commence processing of the uploading Migration file as shown below The user will have to choose an appropriate file format XML CSV Excel and then provide the file path from the local machine s location On upload the user will be able shown the appropriate success error message WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Q O A Dae ro L Sa 18 A BS Addess htpocahost VECNCWebApplplpoeFleapomedems SSS Upload File far Migration Upload File Report Utilities Contact Us Logout ioe a Page 21 of 66 BBCT wBC migrations CP user guide 10 Placing 8M orders 10 1 Input attributes The input data required is as follows Attribute Request Type Installation DN Service ID Network ID Length Remarks Mandatory Mandatory either of DN or Service ID or Network ID Remarks Multiple Services One or more instances of service identifiers Either of DN or Service ID or Network ID is Mandatory If the Installation DN is less than 11 characters in length and is not preceded by a0 this might happen when user edits the file in CSV mode instead of notepad BBCT will automatically add a 0 to the Installation DN Optional 10 2 8M Upload Messages Following are failure success messages and their meaning when you upload LQC file on
46. monitor order progress Local intranet Page 8 of 66 BBCT wBC migrations CP user guide 7 Placing Line Qualification Check orders BTE Line Qualification is optional Users can perform this step before placing migration orders to check current line status data This will give you the predicted speed for WBC Products and by using this statistic can help users to decide whether to choose a WBC product option Sample CSV file format Note While editing the CSV file the user is required to open it in notepad or textpad instead of Excel This is because when opened in Excel formatting information is lost WBCLQC_OM123456 78_11042008_1620 Sample XML file format WBCLQC_OM123456 78_11042008_1430 7 1 Input Attributes The input data required is as follows Attribute Length Remarks Request Type Mandatory Installation DN 11 Mandatory either Service ID 15 of DN or Service ID Network ID 12 or Network ID MAC Code Optional Remarks Multiple Services One or more instances of service identifiers Either of DN or Service ID or Network ID is Mandatory If the Installation DN is less than 11 characters in length and is not preceded by a0 this might happen when user edits the file in CSV mode instead of notepad BBCT will automatically add a 0 to the Installation DN Page 9 of 66 BBCT wBC migrations CP user guide 7 2 LQC Upload Messages BTE Following are failure success messages a
47. n gt Home gt Report gt CP Forecasting Description This report will allow the CP to see his her allocation and utilisation orders The report can be filtered on the basis of the MDFID Migration Date Allocation Utilisation Orders and spare A hyperlink will be provided on the utilisation count and count of singleton orders as shown in the below mentioned screenshot so that the user can see details of those orders on the migration report A WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help Qk O DOA Asean krve A a M DA XOA OME 8 My Web Search Psearch Address http localhost WBCMCDay2 wpCPForecastRpt aspx v Ba Links gt Google C Vo ODM Gy OH Br OP SM Be g Bookarks Pasak C Popups okay Qsettinsy E CP Forecast Report Upload File Utilities bey bso recur cuci cucnames Monday 05 May 2008 3 Ogg recur cuci cucname Thursday 26 3un 2008 oe OOOO O recne _ cuc1 cusnamet Thursday 10 3ur2008 fo O O erana e 6 CC O l Y Local intranet 13 How to Cancel Orders You can only cancel those orders for which the PONR has not been reached the PONR is set at CPD 2days beyond which cancellation is not allowed There are two ways of canceling orders i one is by canceling each order from BBCT GUI one by one ii the other is by canceling an order in bulk by providing an input file to BBCT ASG via CS OPS Page 48 of 66 BBCT wBC migrations CP use
48. nd their meaning when you upload LQC file on BBCT Message File must be either CSV or XML only Invalid Filename please try again in recommended format WBCLQC_ CP Ident __DDMMYYYY_HHMM csv WBCLQC_ CP Ident DDMMYYYY_HHMM xml Duplicate filename please try again in recommended format WBCLQC_ CP Ident DDMMYYYY_HHMM csv WBCLQC_ CP Ident DDMMYYYY_HHMM xml Invalid Request type Please try again Invalid Header Please try again Invalid Trailer Please try again Missing Mandatory field Serviceld Networkld DN value at row 3 File uploaded successfully Page 10 of 66 Remarks Only CSV XML file can be uploaded if you try to upload any other file format it will display this message Filename format must be WBCLQC_OM12345678_09012008_ 1523 filename should start with prefix WBCLQC BBCT will perform file duplication check if same file exists previously then it will display this message Header validation e g first row must contain WBC_BULKLINEQUAL Multiple_Services If it fails to match with this format then it will display this message Second row must contain following sequence InstallationDN Serviceld Networkld MAC If it fails to match with this format then it will display this message Trailer Validation e g last row must contain WBC_BULKLINEQUAL_TRL If it fails to match with this format then it will display this message I
49. ng Co Cema SD OSD04 L750034282 veendi PA 25999999 SERVIC Wess fesse Scheduled R_000000006T EUA WBC End OSD TEER eons eae 125 eer 01 08 2008 YAD 000000008 Access 16 40 00 Local intranet Page 57 of 66 BBCT wBC migrations CP user guide BTE 15 Edit Profile Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Utilities gt Edit CP Profile Description Page that allows editing of the profile details of the User The username password details impact the login to the BBCT WBC Migration application The Send Mail Notification decides whether to send an email to the CP when there are erroneous orders in the file uploaded El NBC Migration Controller Microsoft Internet Explorer File Edt View Favorites Tools Help Q O x 2G JO Search she rovortes 2 2 S m We Address http localhost WBCMCDay4_450 wpEditCPProfile aspx A ora WBC Migration Controller amtest Upload File Report Utilities Contact Us Logout O M Number User Name amtest Password Email amtest a com Company Name C Profile Edited By ADAN Profile Edited DateTime PAZO ASM Send Mail Notification v Send Order Failure Notification Save Reset Local intranet Page 58 of 66 BBCT wBC migrations CP user guide 16 BBCT Status amp their meaning CP Status Message File successfully uploaded Processing Processed I
50. nvalid Service ID Open BAU order exists Line Asset has been ceased Invalid Ownership Validation Failed No Details found EXCHANGE NOT SCHEDULED FOR WBC MIGRATION Validation Completed Invalid Require by Date Page 59 of 66 File Order File Description hen file is uploaded this will be default status hen file is picked by loader omponent for validation purpose hen validations for all orders in this file are performed successfully File File If we get any error in response from BTW circuit inventory system then we will update order with status hen 20 CN circuit is in Status In course of regrade In course of provisioning In course of Cease hen 20 CN circuit is already eased Perform Ownership check one CP should not upload any ircuit belonging to other CP if this validation fails this message will be displayed if order validation failed during OSS components processing his message will be displayed if we receive no response for line qualification information rom OSS components this message will be displayed hen WBC exchange enabled date exceeded required by date CRD hen all validations ompleted successfully for his order hen required by date alculation failed Difference between ustomerRequiredbyDate and UploadedDatetime of an order should be greater than 12 working days Order Order Order BBCT wBC migrations CP user guide BTE Migration
51. predicted speed Red The page also facilitates the user to download the entire report in CSV format 3 WBC Migration Controller Microsoft Internet Explorer Ele Edt view Favorites Tools Help Ox x 2 4 gt irs af TolisGfup O Tools Events MJELeaming O Tooishop E Tools List pg Support Address E etestocahostIWECMCwebAppiopEMOrderReporManasm O O OOOO OOOOO y d 8M Order Report Upload File Utilities WBCLOCPostMig_8MTransit_OM12121212_20082009_2014 csv PoP E E Eiana Page 40 of 66 BBCT wBC migrations CP user guide 12 10 8M Order Migration Details Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt 8M Transit Post Migration LQC gt Order Status gt Drill down a particular order record Description Page that displays the Migration details for an order from Migration file F WBC Migration Controller Microsoft Internet Explorer File Edit View Favorites Tools Help O O HAO Paw goa O 22 eA a Address http flocalhost wBCMCWebApp wp8MOrderReportMain aspx 8M Order Report Z WBC Migration Controller Web Page Dialog WBC 0000001KS3 CP Local intranet Page 41 of 66 BBCT wBC migrations CP user guide 12 11 8M Order LQC Details Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt 8M Transit Post Migration LQC gt Order Status gt Drill down using the
52. r guide 13 1 Cancel Order from BBCT GUI There are two steps A Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk Migration gt Order Status gt Cancel Order Description the Page that takes input of the Cancellation reason for a particular Pending on Fulfillment order which has been selected for cancellation and on submit it will prompt the user for confirmation of the same A I WBC Migration Controller Microsoft Internet Explorer File Edit View Favorite s O O DAG pmo kr G D a Address http localhost WBCMCDay4_450 wpMigrationOrderReportMain aspx sT Migration Order Report Upload File Report Utilities Contact Us Logout Select Pending On Fulfillment Select select Z WBC Migration Controller Web Page Dialog PR OSD OSD04 WBC End 000000008T L750034282 User 01 09 2008 Pending on 07 08 2008 Vie 15 07 2008 125999999 SERVIC Access 06 54 00 Fulfillment 12 15 11 dice 00 00 00 AR_000000008T EUA Page 49 of 66 BBCT wBC migrations CP user guide BTE B Navigation BBCT URL gt WBC Migration gt Login gt Successful Login gt Home gt Report gt Bulk Migration gt Order Status gt Cancel Order gt Submit Description The page that confirms if the user really wants to cancel the order or not The user can click OK to progress the order for cancellation to the downstream system OneSiebel
53. request Order hen there is any open order already exists and In or this service id then reject Progress for this new order Serviceld Scheduled Order hen all validations passed and order is ready for migration BTW Processing Order hen order failed during failed initial stage after the order is scheduled Pending On Order Iwhen provide order has Fulfillment passed its validation stage and accepted by One Siebel Rejected Order hen provide order is failed during initial validation stage and rejected by One Siebel Completed Order hen provide order is ompleted successfully on One Siebel Cancel In Progress Order hen cancel order is accepted on One Siebel portal and in progress Cancellation failed Order here are chances that order an not be fulfilled as it reaches to PONR Point Of No Return in case this message will be displayed Cancelled Order hen cancel order completed successfull Cancelled File amp Order hen file order is excluded Format Error Order ill show the details of the mandatory attribute s absence or invalidity of its value Line not Suitable for A service has been detected broadband order on the line but it is not LLU and is not suitable for migration to WBC This could be due to already being on BC or a data issue Validation Completed hen no Broadband or LLU No Broadband exists services exist on the line A on this line provide order will be required rather than a migration order Ann
54. supplied for either Serviceld DN value at row 3 Networkld DN in CSV file then this message will be displayed File uploaded successfully If file passes through all above validations then it will display success status to users 10 3 Uploading file from user s machine Navigation gt WBC Migration gt Login gt Successful login gt Home gt Upload menu gt 8M Transit Post Migration LQC Description Page to upload 8M file The user will be able to see the estimated time to commence processing of the uploading 8M file as shown below The user will have to choose an appropriate file format CSVI and then provide the file path from the local machine s location On upload the user will be able shown the appropriate success error message 3 WBC Migration Controller Microsoft Internet Explorer Ele Edt view Favorites Tools Help O x 2 H uinks ots Gerla Tools Events M E Leaming OToolshop E Tools List px Suppot Address E http iiocahost waCMCWebAppivpstMTranstipeadaspe SSC Uploading File for Post Migration LQC 8M Transit Upload File Utilities Dor Ri ocatintranet Page 23 of 66 BBCT wBC migrations CP user guide BTE 11 Placing Bulk LLU migration orders The user can place LLU migration orders on BBCT which can be a singleton order or a multiple singleton order BBCT supports three file formats XML CSV amp EXCEL BBCT also supports a B2B xml file for pla
55. t Internet Explorer con e Local intranet 12 14 Bulk LLU Migration Order Details Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk LLU Migration gt Order Status gt Drill down a particular order record Description Page that displays the Migration details for an order from Migration file Page 45 of 66 BBCT wBC migrations CP user guide ft Internet Explorer JO search she Favortes Og iy Wwe id A WBC Migration Controller Web Page Dialog Migration Order Upload File Q Local intranet 12 15 Bulk LLU Migration Order LQC Details Navigation BBCT URL gt WBC Migration gt Login gt Successful login gt Home gt Report gt Bulk LLU Migration gt Order Status gt Drill down using the View LQC option in a particular order record Description Page that displays the LQC details for an order from Migration file Page 46 of 66 BBCT wBC migrations CP user guide I WBC Migration Controller Mic File Edit View Favorites Tools Help Oek O A iz A search Favorites O S e O Z WBC Migration Controller Web Page Dialog LLU Migration Order Ri Upload File ll Asar e BO m e a 122 E WBC Migration Contro Fy Thursday Page 47 of 66 BBCT wBC migrations CP user guide 12 16 CP Forecasting Report Navigation BBCT URL gt WBC Migration gt Login gt Successful logi
56. three file formats XML CSV amp EXCEL BBCT also supports a B2B xml file for placing one order at a time and CSV file for placing bulk orders Sample CSV file format Note While editing the CSV file the user is required to open it in notepad textpad instead of Excel This is because when opened in Excel formatting information is lost WBCBULKMIG_OM95 193701_10032010_1 Sample XML file format refer C7 XML documentation WBCBULKMIG_OM12 345676_02082010_1 Sample Excel File format Excel_Design Template xlsx WBCBULKMIG_OM12 345678_02082010_1 9 1 Order Attributes The input data required is as follows Column Name Description BuyerlD A unique message identifier for the order from the CP IssueDateTime Input from CRF Format will be YYYY MM DDTHH MM SS KCIType Keep Customer Informed method either EXCEL or CSV SellerAssignedAccount Billing Account number Sellers D Assigned Account ID Column E Page 16 of 66 BBCT wBC migrations CP user guide CPDUNSID RESELLERCPDUNSID BTWDUNSID Sellersltemldentificatio n BuyersLineNumber CustomerRedquiredDate InstallationDN MAC CosmossCustomerID SourceServiceld AccessTechnology StabilityOption TrafficWeighting Interleaving AdvancedServicesOpt Page 17 of 66 Mandatory Mandatory Mandatory Mandatory Case Sensitive Mandatory Mandatory Optional Not Required Optional Mandatory Mandatory Mandatory Mandator
57. to Opt in or Opt out of RealTime Downstream Upstream MaintenanceClass Company_Contact_Sur name Company_Contact_Firs thame Company_Contact_Tel ephone Company_Contact_Em ail Company_Contact_Titl e Company_Contact_lIniti als Company_Contact_Ad dress Company_Contact_Pos tcode Company_Contact_Fax Page 18 of 66 Mandatory Mandatory Mandatory Mandatory Optional BBCT wBC migrations CP user guide A BTW Advanced Services available to users whose CPs are signed up for them either Yes or No the realtime rate in kilobits per second The downstream transmission rate in megabits per second If Upstream value is Annex M then the permissible Downstream values are 8Mbit s and 24Mbit s all values are case sensitive The upstream transmission rate in kilobits per second Permissible values for the attribute are Uncapped Annex M and 448kKbit s all values are case sensitive the maintenance category or level of service that is provided Maintenance Category 4 Enhanced Care Maintenance Category 5 Standard Care The surname of the contact for the order The first name of the contact This should match with the data on OS for the CP DUNS ID OS will send warning message if different and use the details from its database The telephone number of the contact Note that telephone numbers should contain the STD code including leading zero be 10 or
58. y Mandatory Mandatory BBCT wBC migrations CP user guide A BTW in excel file is formatted as text to enable leading zeros to be entered Remains the same value for all orders for each CP 399494418 the DUNS number of the CP the BT Wholesale DUNS number 232510151 the name of the product being ordered WBC End User Access EUA Valid value for this field BULKMIG Input to BBCT Format will be YYYY MM DDTHH MM SS Telephone number on which the service is to be provided Note that telephone numbers should contain the STD code including leading zero be 10 or 11 digits in length and must not contain spaces hyphens or any other de limiting characters Installation Directory Number DN Column L in excel file is formatted as text to enable leading zeros to be entered If a user missed leading 0 in Installation DN BBCT would automatically add the same Migration key OMNumber for Service provider Service id The type required either ADSL ADSL2plus Can be either Standard Stable or Super Stable The choice of weighting will effect the user response at times of contention with Elevated getting a higher proportion of the available bandwidth either Standard Elevated Used to define the Interleaving status of the line Yes it will be used No it won t be used or if Auto then BT will decide whether it can be used or not Interleaving Yes No Auto used
Download Pdf Manuals
Related Search