Laddawn.com : Rolling DEV site to LIVE

Created by User c0361, last modified by Judy Ascensao on Jan 23, 2015

 

The following are the steps needed to move the development of the new web to live production.  Initially we are going to do a test roll to create the Training Environment for CE.

 

  1. Save WEBROLES.USR somewhere where it can be copied back after the account is brought over & the file has been created.   *** THIS IS ONLY WHEN COPYING TO TEST ENVIRONMENT!!!
  2. FOR LIVE IMPLEMENTATION - STOP REPLICATION
  3. FOR LIVE IMPLEMENTATION - COPY ENTIRE AVANTE92 TO WEBAVANTE92
  4. Prevent Live customers from being notified of testing activities:  *** THIS FIRST SECTION IS ONLY WHEN COPYING TO TEST ENVIRONMENT!!!
    1. Set all Fax Numbers to 999-999-9999 in Customers, Contacts, and link files:
      1. SLSCONTACT.USR FAX.NBR = "999-999-9999"
      2. CUSTMST FAX.PHONE = "999-999-9999"
      3. CUSTMST FAX_NO = "999-999-9999"
    2. Set all email addresses to jmalloy@laddawn.com in Customers, Contacts and Link files:  yes, this says jmalloy@laddawn.com  
      1. SLSCONTACT.USR EMAIL.ADDRESS = jmalloy@laddawn.com
      2. CUSTMST EMAIL = jmalloy@laddawn.com
      3. CUSTMST.USR FORM.EMAIL.ADDR = jmalloy@laddawn.com
      4. CUSTMST.USR INV.EMAIL.ADDR = jmalloy@laddawn.com
    3. Change all 'email to' SYSCON SB User Id's to JMALOY:
      1. CSWORKFLOW.LAD:
        1. set the following fields to JMALOY: 4, 5 , 7-16, 18-20, 25-27, 29, 36-40, 43-50
        2. Change server name in fields 24 and 42:   from 00SRV01 to 00ITDEVSERVER01 
      2. EMAIL.LAD:
        1. set the following fields to JMALOY: 8, 17, 19, 20-23, 26, 29
        2. set the following associated fields: field 11 to JMALOY 5 times; field 12 to 01]02]04]05]06 (these are both multi-valued fields)
        3. set the following associated fields: field 27 to 01]02]04]05]06; field 28 to JMALOY 5 times (these are both multi-valued fields)
        4. set the following field to WCICCOTELLI: 30 (for testing) 
    4. Make sure the CSWF queue is pointing to the correct location:
      1. The CSWORKFLOW.LAD changes above should take care of this
      2. Make sure that the FLODATA$ share is setup on the server (*** also check all other shares) 
    5. Set the Credit Card address to the testing paytrace site:
      1. SYSCON TERMS.LAD: set fields 7 and 8 to demo123 - leave LIVE in field 9
    6. Point all Avante printers to the some printer for testing:
      1. SYSCON  PROD.PRINTER.LAD:
        1. Replace contents of fields 1-6 with:  If PIC printer, replace with PIC_HP4200 else replace with HP4200
        2. Null out contents of fields 7-9
        3. Replace contents of fields 10-13 with: If PIC printer, replace with PIC_HP4200 else replace with HP4200
      2. SYSCON LBL.PRINTERS.LAD:
        1. Replace field 1 with JMALOY
        2. Replace field 2 with HP4200
      3. SYSCON SHIP.PRINTER.LAD:
        1. Replace printers in fields 1 and 3 with HP4200 (5 multi-values associated with each warehouse# in field 1) 
    7. Disable clippership updating in SYSCON:
      1. SYSCON CLIPSHP.LAD:
        1. Set all multi-values in field 4 to CLIPPERSHIPDEV
        2. Set field 7 = jmalloy@laddawn.com
    8. How are items going to get into the testing queue?
    9. Make sure the testing computers can pull up faxes and emails from the queue.
    10. Search SYSCON and SYSTBL for paths (\\, c:, d:, e: ) *** I DIDN'T FIND ANYMORE THAT REQD CHANGES
    11. Search SYSCON for paths specifying MACHINE NAME:
      1. Change path in VCARD.LAD field 2 from 00SRV01 to 00ITDEVSERVER01
      2. Change path in RR.PATH.LAD fields 1 and 2 from 00SRV01 to 00ITDEVSERVER01
  5. Make a new _PH_ folder in LIVE.DATA, DEV.DATA, DEV925, TRN925, AND LIVE925.  They are not replicated, and therefore not on the server we are copying data from.
  6. Make sure LOGIN voc on LIVE925 looks like DEV925 - also copy LDLIB SB.SETUP from DEV
  7. Update webconfig: Website folder: configuration/appsettings.config
  8. Add VOC pointers for TXX and KTXX in LIVE.DATA from 01 to 300 (is SYSS0001.1 creating this automatically)??
  9. Create new files and set up voc pointers in LIVE925 & TRN925 - ONCE CREATED, MAKE SURE TO RESIZE IN LIVE.DATA
    1. CONFIG.CONV (only needed when program is ready to convert ashads)
    2. CONTACT.ITEM.XRF.USR  then resize to 503,1
    3. CUSTPARTXRF.USR then resize to 503,1
    4. ITMTAGS.USR then resize to 503,1
    5. MOD.ITMMST.USR then resize to 503,1
    6. MSTRORDDET.USR  then resize to 1009,1
    7. MSTRORDHDR.USR then resize to 503,1
    8. SCRATCHPAD.USR  then resize to 503,1
    9. SHAREDCARTS.USR  then resize to 503,1
    10. SHAREDITEMS.USR  then resize to 503,1
    11. WEBLOCK.USR  then resize to 503,1
    12. WEBOPTIONS.USR  then resize to 503,1
    13. WEBROLES.USR then resize to 203,1
    14. WEBROUTINES.USR then resize 503,1
    15. CHECKOUT.CART.USR  then resize to 503,1
    16. CUSTMST.DUPES then resize to 1009,1
    17. CUSTMST.DUPES.USR then resize to 1009,1 
    18. Make sure there's a VOC pointer in TRN925 and LIVE925 to ACCPTMST (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    19. WEBSEARCHGROUPS.USR  *** this already exists in LIVE.DATA
    20. MASTERORDER.USR    *** I REMOVED THIS AGAIN ... THIS WAS RENAMED TO HDR/DET  ***Wayne has removed all dictionaries for this file from task 101111 so this shouldn't be a problem going forward
    21. Make sure there's a VOC pointer in TRN925 and LIVE925 to ARDEPOSIT (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    22. Make sure there's a VOC pointer in TRN925 and LIVE925 to BOOKINGS (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    23. Make sure there's a VOC pointer in TRN925 and LIVE925 to COMPET.USR (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    24. Make sure there's a VOC pointer in TRN925 and LIVE925 to COMPET.USR.INDEX (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    25. Make sure there's a VOC pointer in TRN925 and LIVE925 to CONXRF (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    26. Make sure there's a VOC pointer in TRN925 and LIVE925 to CURRDET (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    27. Make sure there's a VOC pointer in TRN925 and LIVE925 to CURRHDR (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    28. Make sure there's a VOC pointer in TRN925 and LIVE925 to EMPLOYEES (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    29. Make sure there's a VOC pointer in TRN925 and LIVE925 to FAMMST
    30. Make sure there's a VOC pointer in TRN925 and LIVE925 to IVTTBL (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    31. Make sure there's a VOC pointer in TRN925 and LIVE925 to JOBHDR
    32. Make sure there's a VOC pointer in TRN925 and LIVE925 to JOBDET (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    33. Make sure there's a VOC pointer in TRN925 and LIVE925 to JOBMST (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    34. Make sure there's a VOC pointer in TRN925 and LIVE925 to LD.INCLUDES 
    35. Make sure there's a VOC pointer in TRN925 and LIVE925 to ORDREQHST (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    36. Make sure there's a VOC pointer in TRN925 and LIVE925 to ORDREQXRF (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    37. Make sure there's a VOC pointer in TRN925 and LIVE925 to RMTDET (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    38. Make sure there's a VOC pointer in TRN925 and LIVE925 to RMTHDR (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    39. Make sure there's a VOC pointer in TRN925 and LIVE925 to SLSTAXMST (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    40. Make sure there's a VOC pointer in TRN925 and LIVE925 to SOAUDIT (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    41. Make sure there's a VOC pointer in TRN925 and LIVE925 to SOPWRK.LF1 (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    42. Make sure there's a VOC pointer in TRN925 and LIVE925 to TAXCLASSMST (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    43. Make sure there's a VOC pointer in TRN925 and LIVE925 to USRSECACT (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    44. Make sure there's a VOC pointer in TRN925 and LIVE925 to WIP (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    45. Make sure there's a VOC pointer in TRN925 and LIVE925 to WIPMTLRQ (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    46. Make sure there's a VOC pointer in TRN925 and LIVE925 to XFREXP (this is a std Avante file that isn't used, but std programs such as convert quote need to be able to open it)
    47. Make sure there's a VOC pointer in TRN925 and LIVE925 to CHGTBL
    48. Make sure there's a VOC pointer in TRN925 and LIVE925 to DMTRN
    49. Make sure there's a VOC pointer in TRN925 and LIVE925 to DMTRN.LF1
    50. Make sure there's a VOC pointer in TRN925 and LIVE925 to IICOMBO
    51. Make sure there's a VOC pointer in TRN925 and LIVE925 to INVPLAN07
    52. Make sure there's a VOC pointer in TRN925 and LIVE925 to WBDEFN
    53. Make sure there's a VOC pointer in TRN925 and LIVE925 to IIUTIL
    54. IN PRC39 - Add pointer LIVE.II.MD to AVBP (copy LIVE.II.MD LDLIB but change remove A from LIVE925)
    55. IN LIVE.DATA - create pointer to AVBP (which lives in LIVE925)
  10. Roll PRC Tasks
    1. Task 101028 and all sub tasks
    2. Steve Norris task 100976 and subs - Web Cofnigurator Routines (SYS9026, WEB9001, 9002, 9004)
    3. 101015 don't need - empty Steve N task
    4. 101059 - WEB9005 Web Options Maint (Wayne)
    5. 101060 - BOM3000 new web screen (Wayne)
    6. 101065  - don't need - Empty task for Redback Interface (Wayne)
    7. 101090 - SODET dictionaries for dimensions (Wayne)
    8. 101094 - Item Tagging in saved items (Wayne)
    9. 101103 - MOD Price Calculation (Wayne)
    10. 101109 - Revert SYSS0123.1 to Avante Version. Incorporate needed Web logic
    11. 101111 - Convert Quotes to Sales Orders
    12. 101117 - Customer Part Cross reference
    13. 101118 - Use CUSTPARTXRF.USR as required
    14. 101127 - Add Atlanta to MFG Plant Assignment
    15. 101128 - WEB PROJECT - Create / Modify Drop Ship Customer (CURRENTLY EMPTY)
    16. 101063 and sub tasks - Update Item Mastser from Spreadsheet
    17. 100869 - Support Multiple Shopping Carts for Mobile Website
  11. Some Cleanup Items: *** I HAVE PUT ALL OF THESE MISSING PGMS ONTO TASK 101028.6 (judy)
    1. catalog all LDLIB (SELECT LDLIB <> "_]", CATALOG LDLIB DIRECT FORCE)
    2. Catalog LDLIB PARSE.PARAMS.LAD
    3. WEB.METALPCT.DEFAULT.VALUE not on any task. copied manually.
    4. WEB.WIDTH.DEFAULT.VALUE not on any task copied manually.
    5. FCT.PLATENBR.DEFAULT.VALUE not any task copied manually.
    6. FCT.ZIPCODE.DEFAULT.VALUE not any task copied manually.
    7. FCT.GAUGE.GROUP.ENABLED not on any task copied manually.
    8. WEB.BTWNHOLES.VALIDATE not on any task copied manually.
    9. WEB.GAUGE.GROUP.ENABLED not on any task copied manually.
    10. WEB.MATERIAL.GROUP.ENABLED not on any task copied manually
    11. WEB.PACKING.GROUP.ENABLED not on any task copied manually
    12. WEB.PRINT.PLTVALID not on any task copied manually
    13. GET.LTL.FLAG is also missing
  12. SYSCON's (New/Changed) - look at each one individually and make appropriate changes for LIVE:
    1. NAMED.PARAMS.LAD (Changed - COPY W/OVERWRITE OPTION)
      1. RUN IIUTIL MAKE.NAMED.PARAMS IN DEV AND LATER IN LIVE AND RECOMPILE ALL PROGRAMS (BP AND LDLIB) THAT USE LAD.COMMON.
    2. CONFIG.SETTINGS.LAD (New - COPY)
    3. WEB.APP.LAD -(Changed - COPY W/OVERWRITE OPTION)
    4. MOD.CONV.LAD (New - this isn't needed until we are ready to run the configuration conversion - when this is moved to LIVE, must change field 1 to be the CPN of the new MOD item that is created)
    5. ITEM.DESC.LAD (New - COPY)
    6. NEXT.SHAREDITEM.LAD (New - COPY)  *** reset field 1 to null so that count starts at "1"
    7. WEB.SETTINGS.LAD (New - COPY)
    8. NEXT.TAG.ID.LAD (New - COPY)
    9. QUOTE.TERMS.LAD - added field 14 for Godzilla (history cutoff days) (changed - manually add field 14)
    10.  SHIP.CUTOFF.LAD - added field 3 for cutoff time
    11. EMAIL.LAD - set field 30 to ITDEPT
  13. SYSTBL's (New/Changed) look at each one individually and make appropriate changes for LIVE:*** FOR ALL NEW SYSTBL's, CALL UP IN SYS3005 AFTER COPY SO THAT IICOMBO GETS BUILT 
    1. CFG.RULES.LAD (New - COPY ALL 57 records including header)  *** CALL UP IN SYS3005
    2. MOD.CRITERIAXRF.LAD (New - COPY ALL 234 including header) *** CALL UP IN SYS3005
    3. SUPPMSG.LAD (New - COPY ALL 3 including header) *** CALL UP IN SYS3005
    4. RTC.LAD - flag the following records with a "1" in field 3 (rate) for c/e request popup filtering (USE SYS3005):
      1. 041, 043, 070, 080, 090, 140
    5. RTC.LAD - flag the following records with a "2" in field 3 (rate) (USE SYS3005):
      1. 030, 110, 120, 130
    6. RTC.LAD - create new request type "005" - (Using SYS3005, add 005 with WEB9006 in field 1 and WEBSITE as the description)
    7. RTC.LAD - new request type 127 - upload print plates - copy to LIVE  *** added 7/16/14 (Judy) 
    8. FOB - ADD "CPU" for customer pickups (Using SYS3005, add CPU with description of CPU)
    9. CFG.GRP.LAD THIS IS NOT USED
    10. WEB.GRP.LAD THIS IS NOT USED
    11. WEB.OPTIONTYPES.LAD (New - COPY ALL 15 including header)
    12. Existing VIA code "PO" - put "PO" in field 1 for carrier selection
    13. New SYSTBL WEBOPTIONS.XRF.LAD
    14. WEB.EXT.DESC.LAD (New - COPY ALL 35 records including header)  *** CALL UP IN SYS3005
  14. WEBCRITERIA.USR file - copy all records that start with "S.".  First, copy existing records somewhere else then clear. (45 records as of 5/13/14)
  15. CATALOG.CD.USR - copy all records that start with a 1-5. First, copy existing records somewhere else then clear. (select with @id < 9999 - 61 records as of 5/13/14 but may be more added)
  16. WEBSEARCHGROUPS.USR- copy all records (file exists in LIVE but is empty)  
  17. WEBOPTIONS.USR - copy all records (including "new" header records.)
  18. COMMENTS.USR - update 900 series to have the new fields and then copy all 900 series comments to live with overlay
  19. EPCCTL (config tables) - New/Changed:
    1. MARKETPLACERATES  *** WE HAVE TO CHANGE PRIME_OCTENE AND PRIME_CLARITY rates in this table to match WEBCRITERIA.USR PRIME_OCTENE & PRIME_CLARITY
    2. MP_FRTCONSTANT
    3. MP_MINMULT
    4. MP_MARKUPS
    5. MP_DFLTCASE
    6. MP_IMP_MINWGT
    7. MP_IMP_BOXWGT
    8. MP_IMP_MARKUPS
    9. Change field 2 of EPCCTL EZVAR.PREF from "X" to "XX" (this is the prev field indicator for the config going forward)
    10. *** ON HOLD MFG_PLANTS (changed from from DR to DL for Canada) - **** already in LIVE with "DR"  CAN'T BE MOVED UNTIL ATLANTA CONFIGURATOR GOES LIVE!!!
    11. KONCENTRATE - added Purple an dBlue/Green*** already in LIVE
    12. All Atlanta tables (BG, SWG, SWSG)*** already in LIVE
  20. Create "MOD" item in BOM3000:
    1. Desc & Internal Desc = MADE ON DEMAND ITEM
    2. Sort Key = MOD
    3. UOM = M
    4. Class Code = PRO
    5. Config Code = 1 (Configure to Order)
    6. Eng Status =- 1 (Active)
    7. F6 - GLG=MI, Item Type=7, Make/Purch=M, Buyer & Planner codes = 01, Order Policy=A, Mfg Leadtime=3
    8. F7-> F6: Generic Name Code = N/A, Closure Type=3
    9. Modify SYSCON MOD.CONV.LAD and enter cpn associated with MOD item in field 1
  21. Roll MOD configuration (all 10 CF... files starting with "MOD]")  Select filename = "MOD]"
    1. EPCBOM  (1 item)
    2. EPCPLC   (248 items)
    3. EPCPLD   (1 item)
    4. EPCPLM   (20 items)
    5. EPCPLP   (11 items)
    6. EPCPLR   (0 items)
    7. EPCPLT   (76 items)
    8. EPCRULES  (23 items)
    9. EPCSCHDR (1 item)
    10. EPCSCDET (88 items)
  22. New/Changed standard comments (COMMENTS.USR) - this file needs to be cleaned up - remove obsolete comments and make sure the following exist with the correct info:
    1. 000 - Blank Comment
    2. 005 - 40x48 4-way pallet
    3. 006 - Export Pallet
    4. 007 - #Pkgs per Pallet
    5. 008 - Max Pallet Height
    6. 101 - change text to say "SHIP ORDER COMPLETE"
    7. 102  - change text to say "BACKORDER"
    8. 105 - Inside Delivery
    9. 106 - Tailgate Delivery
    10. 107 - Lift Gate Delivery
    11. 108 - Call for Delivery
    12. 109 - Receiving Hours
    13. 111 - Load Tags
    14. 116 - Ship with Order
    15. 133 - BOL Comment
    16. 144 - Attach Documents to Shipping Paperwork
    17. 160 - New comment for Residential Delivery.  Enter a delivery charge rate.  *** do not set the 'preference flag' to Y
    18. 161 - New comment for LIMITED ACCESS DELIVERY.  Enter a delivery charge rate (per lb for small pkg and flat rate for LTL). *** do not set the 'preference flag' to Y
    19. 162 - New comment for 'don't use wooden slats'
    20. 163 - New comment for 'don't use slats'
    21. Put delivery charge rates into all comments that have upcharges
  23. Roll new/changed LDLIB RPC's ***Any of these that aren't already on a task have been added to prc task 101028.6 and will be rolled with other tasks
    1. RPC$CATALOGCODE_GETBYFILTER
    2. RPC$CATALOGCODE_GETBYID
    3. RPC$CATALOGCODE_GETFILTERVALUES
    4. RPC$CHARGECODE_GETBYFILTER
    5. RPC$COMMENTS_GETBYFILTER
    6. RPC$COMMENTS_GETBYID
    7. RPC$COMMISSION_GETBYFILTER
    8. RPC$COMMISSION_GETBYID
    9. RPC$CONFIGCRITERIA_GETBYFILTER
    10. RPC$CONFIGGROUP_GETBYFILTER
    11. RPC$CONFIGGROUP_GETBYPARTNBR
    12. RPC$CONFIGQUESTION_CANCEL
    13. RPC$CONTACT_DELETE
    14. RPC$CONTACT_GETBYEMAIL
    15. RPC$CONTACT_GETBYFILTER
    16. RPC$CONTACT_GETBYID
    17. RPC$CONTACT_SAVE
    18. RPC$CONTACT_VALIDATE
    19. RPC$CONTACTITEM_DELETE
    20. RPC$CONTACTITEM_GETBYFILTER
    21. RPC$CONTACTITEM_GETBYID
    22. RPC$CONTACTITEM_SAVE
    23. RPC$CUSTOMER_CREATE
    24. RPC$CUSTOMER_GETBYFILTER
    25. RPC$CUSTOMER_GETBYID
    26. RPC$CUSTOMER_PREFSAVE
    27. RPC$CUSTOMERPRODUCTITEM_GETBYFILTER
    28. RPC$CUSTOMERPRODUCTITEM_GETBYID
    29. RPC$CUSTOMERPRODUCTITEM_SAVE
    30. RPC$ITEM_GETAVAILABILITY
    31. RPC$ITEMTAG_DELETE
    32. RPC$ITEMTAG_GETBYFILTER
    33. RPC$ITEMTAG_GETBYFILTER2
    34. RPC$ITEMTAG_SAVE
    35. RPC$ITEMTAG_SELECT
    36. RPC$MODITEM_CLOSEMATCH
    37. RPC$MODITEM_CREATE
    38. RPC$MODITEM_OPTIONAL
    39. RPC$MODITEM_VALIDATETOCART
    40. RPC$MODPRODUCTITEM_GETAVAILABILITY
    41. RPC$MODPRODUCTITEM_GETBYFILTER
    42. RPC$MODPRODUCTITEM_GETBYID
    43. RPC$MODPRODUCTITEM_GETPRICE
    44. RPC$ORDER_GETBYFILTER
    45. RPC$ORDER_GETBYID
    46. RPC$ORDERITEM_GETBYFILTER
    47. RPC$ORDERITEM_GETBYID
    48. RPC$PRICE_GETBYFILTER
    49. RPC$PRICEBREAK_GETBYFILTER
    50. RPC$PRODUCTSTOCKITEM_GETSUBSTITUTES
    51. RPC$QUOTE_EMAIL
    52. RPC$QUOTE_GETBYFILTER
    53. RPC$QUOTE_GETBYID
    54. RPC$QUOTEITEM_GETBYFILTER
    55. RPC$QUOTEITEM_GETBYID
    56. RPC$QUOTEITEM_GETBYSAVEDITEM
    57. RPC$REQUEST_GETBYFILTER
    58. RPC$REQUEST_SAVEALL
    59. RPC$SEARCHFIELD_GETBYFILTER
    60. RPC$SEARCHFIELD_GETBYID
    61. RPC$SEARCHFIELD_GETDEFAULTVALUES
    62. RPC$SEARCHFIELD_GETENABLED
    63. RPC$SEARCHGROUP_GETBYFILTER
    64. RPC$SHAREDITEM_GETBYFILTER
    65. RPC$SHAREDITEM_SAVE
    66. RPC$SHIPMENT_GETBYFILTER
    67. RPC$SHIPMENT_GETBYID
    68. RPC$SHIPMENTBUNDLING_GETBYFILTER
    69. RPC$SHIPMENTITEM_GETBYFILTER
    70. RPC$SHIPMENTITEM_GETBYID
    71. RPC$SHOPPINGCART_CREATEORDER
    72. RPC$SHOPPINGCART_DELETE
    73. RPC$SHOPPINGCART_GETBYFILTER
    74. RPC$SHOPPINGCART_GETBYID
    75. RPC$SHOPPINGCART_GETORDERVALUE
    76. RPC$SHOPPINGCART_QUICKSTOCKCHECK
    77. RPC$SHOPPINGCART_SAVE
    78. RPC$SHOPPINGCART_VALIDATECHECKOUTSTEP
    79. RPC$SHOPPINGCARTITEM_DELETE
    80. RPC$SHOPPINGCARTITEM_GETBYFILTER
    81. RPC$SHOPPINGCARTITEM_GETBYID
    82. RPC$SHOPPINGCARTITEM_SAVE
    83. RPC$SYSTEMTABLEITEM_GETBYFILTER
    84. RPC$USERPREFERENCE_GETBYFILTER
    85. RPC$USERPREFERENCE_GETBYID
    86. RPC$USERPREFERENCE_SAVE
    87. RPC$UTILITY_CITYFROMZIP
    88. RPC$UTILITY_PROFILELOCK
    89. RPC$UTILITY_VALIDATEZIP
    90. RPC$WEBPRODUCTITEM_GETBYFILTER
    91. RPC$WEBPRODUCTITEM_GETBYID
    92. RPC$WEBPRODUCTITEM_GETBYPARTNBR
    93. RPC$YMACPRODUCTITEM_GETBYFILTER
    94. RPC$YMACRULE_GETBYFILTER
    95. RPC$UTILITY_BROWSERCLOSE
    96. RPC$CONTACT_SUPPRESSMSG
    97. RPC$SHIPMENT_GETSUMMARY
    98. RPC$TESTPLAN_GETBYFILTER
    99. RPC$TESTPLAN_GETBYID
  24. BP.INCLUDES (possibly clean this file up to remove obsolete records):  ***Any of these that aren't already on a task have been added to prc task 101028.6 and will be rolled with other tasks
    1.  Copy/overlay all records with LAD. prefix
  25. LD.INCLUDES (possibly clean this file up to remove obsolete records): ***Any of these that aren't already on a task have been added to prc task 101028.6 and will be rolled with other tasks
    1.  Copy/overlay all records
  26. AVBP programs that were changed need to be added to task 101028.6 - these are:  these were added to task 101028.6 on 06/26/14
    1. EPCS0001.1
    2. EPCS0017.1
    3. EPCS0020.1
    4. SYSS0003.1 
  27. Put SYS0001 in PROC AT SET COMMON on LIVE925: 
    1. LOGTO LIVE925
    2. SB.LOGIN
    3. WEB, WEB (username/password)
    4. /TM
    5. Other Tools/ Housekeeping/ System Control Record
    6. Put SYS0001 in PROC AT SET COMMON 
  28. In LIVE925, catalog all LBP that have pointers in DEV925. *** make sure to use DIRECT FORCE option
  29. In LIVE925:
    1. Using DELETED.AVBP file in DEV925, recatalog all of these programs using LBP DIRECT FORCE (compare to DEV925 AVBP to see what is still in use)
    2. Remove these programs from AVBP in LIVE925
  30. Run the ZIPCODE.USR update.  Check to see if we have a CZAR update and load that too.
  31. Run Conversion Programs:
    1. ITMMST - load web data:
      • *** Make sure the most current version of ItemWebFields.txt is in the TRANSFERS folder before the DEV site is copied to the new server
      • Load ItemWebFields.txt into TRANSFERS

      • RUN IIUTIL UPDT.ITMMST.USR.WEB.INFO

      • Enter the TRANSFER file name? ItemWebFields.txt

      • Does first line contain headers?

      • Error example displayed on screen…      Incorrect Laddawn Part Number; 000506

    1. On training machine only - Clear CUSTPART.USR and let them setup new customer part numbers
    2. Run Sales Order Purge
    3. Run the Create Master Order Conversion Program
       i. BASIC IIUTIL WEB.CONV.MASTER.ORDERS
      ii. RUN IIUTIL WEB.CONV.MASTER.ORDERS
    4. Run Customer Item Number Conversion Program
    5. Run Conversion to Resize Logo Images
    6. Load New Brandit Forms to Shipping Servers at all Locations
    7. Load New Logos Folder to Shipping Servers at all Locations
    8. Run the program that converts marketplace item descriptions on existing quotes/sales orders
      i. BASIC IIUTIL CONVERT.MP.DESC
      ii. RUN IIUTIL CONVERT.MP.DESC
    9. PRIOR TO GO-LIVE:
      1. RUN IIUTIL WEB.PALLET.PREF (already in LIVE IIUTIL) listing pallet choices that will be lost from configurations (40x48/max hgt/export/#pkgs per/pallet wgt)
      2. ce to edit ascii and leave only the lines where we should establish this as a customer preference.  Edit the TRANSFERS version.
      3. after hours (no lock logic): RUN IIUTIL WEB.UPDT.PALLET.PREF - this will update all customers from the ASCII file in TRANSFERS
    10. Run Shopping Cart Conversion Program
      i. BASIC IIUTIL CONVERT.SHOPPINGCART
      ii. RUN IIUTIL CONVERT.SHOPPINGCART
    11. Setup all CE operators with the appropriate security via WEB9007 - make sure SYSTBL WEBROLE.LAD has been rolled.  Tina, Meme, Mark,  and Sarah need to have CE and Manager codes assigned:
      1. BASIC IIUTIL UPDATE.CE.SECURITY
      2. RUN IIUTIL UPDATE.CE.SECURITY then manually add role code 30 to Tina (TMO), Meme (AES), Mark (MPB), and Sarah (SEM) records.
    12. Run CREATE.FILE.PTRS (to create VOC pointers??) 
  32. Copy folders from existing LIVE site that do not get replicated correctly.
    1. Because replication mimics what file updates are done in Avante, files or records that are "moved" must be copied over to the system again to make sure we have the up to date information.  Examples are CSWF, EDI etc.
    2. LIVE - when we make the final cut over, we should copy the entire LIVE folder from Avante92 to make sure all files are in tact.  *** NOTE: If any of the CSWF directories are empty at the time of the copy, they do not get created so have to be created manually (IE, CSWFHOT)
  33. Take new non-inventory GLG Code 900
  34. Take the following new CHGCODE (revenue charge code) records: 901, 902, 903, 904, 905, 906, and 998 
  35. Take the images for shared items
  36. Take the latest brandit logos and product images from marketing and make sure work in sharing, labeling, and product details
  37. Make sure plates file is in place and the items are copied over
  38. Reset Product Tags in Saved Items - remove test tags: COPY from staging ITMTAGS.USR 1,2,10,11,12,13,14,15,16 and renumber them 1-9.  Reset the next tag# to start at 10.
  39. Change 'from email address' in APP config file to go to CE if ce is sharing an email (see SYSCON EMAIL.LAD<13>)
  40. When a new account has been created for training purposes, must check permissions for non-developer users so that they can log in:
    1. LIVE.DATA, FLOPROGS
    2. LIVE.IIBASE8 (where usersecact is)

 

 

 

 

 

 

 

 

 

 

 

 

 

Rolling DEV site to training site:                 (Janice added 06/30/2014 3:40pm)

  1. coordinate with Ed the website deployment
  2. check with Wayne to see if the ITMMST.USR conversion routine needs to run
  3. send reminder email (to Tina, Meme, Susan, Steve, Joe, Wayne, Janice, Ed & copy Cathy, Judy, John, Jim) that the training site's software will be updated beginning at 4pm.  Avante programmers should not edit any program until after the ravel file is generated & testers should not be on the train website nor train Avante site until the software has been updated (will receive follow up email when available) 
  4. On Avante, create a sub-version ravel file
    a. /LOGTO PRC39
    b. Files / Version/Sub-Version
       1. version: WEB2.0
       2. system: II
       3. F9 (rollout)
           a. source realm: DEV
           b. target realm: HOLD 
           c. ravel name: WEB2.0
           d. F2 (to begin rollout)
               1. Clear (RELEASE FILE EXISTS)
               2. Y es, Continue (to rollout version now)
       4. F2 (save)
  5. Send email to programmers that the ravel file has been generated & they may edit programs again
  6. On Training Site, unravel software changes, copy data, & update website
    a. /LOGTO DEV.DATA
        1. /TCL
        2. !copyravel
        3. PRC.UNRAVEL.SITE
            a. ravel file: WEB2.0
            b. F2 (to begin unravel)
                1. S (output report to screen)
                2. esc (escape out of report)
                3. Continue (unraveling)
                4. Ovrt All (project on file already)
                5. Continue
    b. /LOGTO PRC39
        1. Files / Version/Sub-Version
            a. version: WEB2.0
            b. system: II
            c. F9 (rollout)
                1. source realm: DEV
                2. target realm: TRN
                3. F2 (begin rollout)
                4. Yes, Continue (with rollout)
            d. F9 (rollout)
                1. source realm: DEV
                2. target realm: LIVE
                3. F2 (to begin rollout)
                4. Yes, Continue (rollout)
            e. F2 (save)
    c. /LOGTO LIVE925
        1. 0 (real TCL)
        2. BASIC IIUTIL COPY.DATA
        3. RUN IIUTIL COPY.DATA
  7. note:  if ITMMST.USR conversion needs to run, do steps 4-6
        4. BASIC IIUTIL UPDT.ITMMST.USR.WEB.INFO
        5. load ItemWebFields.txt into TRANSFERS
        6. RUN IIUTIL UPDT.ITMMST.USR.WEB.INFO
                a. Enter TRANSFER file name?  ItemWebFields.txt
                b. Does first line contain headers?  Y
    d. /LOGTO LIVE.DATA
        1. programs from ravel file compile automatically
        2. /TCL
        3.!restartrgw (restart Redback)
        4.!copyweb (deploy latest web software)  note:  must be run after Ed finishes website deployment (this no longer works, run steps in email from John dated January 2, 2015 1:32pm)
  8. Compile LDLIB and AVBP before cataloging in DEV925/LIVE925 - PRC doesn't compile these
  9. Compile BP ??? (we had issues after creating a training site where we had to recompile some programs - this may not happen if we don't create a new account) - also programs with LD.INCLUDES should be recompiled
  10. go to  \\00extranet01\d$\WebSites\LaddawnWeb\Configuration
    a. edit AppSettings (using notepad)
         1. under Database settings, change laddawndevrpc to laddawntrnrpc in line <add key="ConnectionString" value="Provider=RedBack.RedPages;Data Source=laddawntrnrpc" />
         2. under Database settings, change laddawnlockdevrpc to laddawnlocktrnrpc in line <add key="LockAwareConnectionString" value="Provider=RedBack.RedPages;Data Source=laddawntrnrpc" />
    1. Find the line that contains <add key="SiteTitle" and set the line to look like this:<add key="SiteTitle" value="Laddawn 2.0 -  CE Training"/>.
    2. Find the line that contains <add key="Environment"  and set the line to look like this: <add key="Environment" value="1" />       <!-- 0=Dev, 1=Trn, 2=Prod -->
    3. Find the line that contains <add key="LockingQueueName" then change it to look like this: <add key="LockingQueueName" value="LaddawnWebsiteUsers" />
    4.  save 
  11. go to \\00extranet01\d$\WebSites\LaddawnWeb
    a. edit Web (using notepad)
        1. under Systems sections,  change true to false in line <default Proxy use DefaultCredentials="false"></defaultProxy>
        2. under Systems sections, change Off to On line <customerErrors mode="Off" defaultRedirect="~/Error/General">
  12. go to website 10.15.5.51 (will take a few minutes to "recompile" the programs) - you may receive an error, if you do close browser
  13. on training site's LIVE.DATA, !restartrgw (restart Redback)
     
  14. go to website 10.15.5.51  - it should be successful this time, move around website to make sure processes are functioning
  15. send email to testers (cc'ing Cathy, John, Judy, Jim) stating the software has been updated & the train site is available

NOTE:  you can roll again, if need be, however, you must reset status for each project/task back to 3 before attempting to roll again;  this should only be needed if you logto LIVE.DATA (which recompiles the programs on the projects/tasks just delivered) before doing the steps on LIVE925