WBR DAILY & PROJECT WORK SHEET Static Responsibilities Merch: Update Inventory Daily, B3 Shipped & Taken (Amy Report) once a week. Run Inventory & PO Reports – check weekly to ensure Sales Accounts and PO #’s are being entered. Update AMAZON Sales once a week and send to New Media. Catalog: Update Daily. A&R: Check DB every morning for any errors – clean tables for duplicates and nulls SIR: Check with Matt/Brigette to ensure schedule ok and Deron completing requested upkeeps New / On-going Project Log MERCH DATABASE What General Status
Follow up on MS Access install for Jenni & Ryan. Sent approved email from Carrie London to Ted Kour at helpdesk for him to update tickets and send to desktop.
Add Date 4/13
Date/Comments
Done 4/13
Average Costing
General
Rewrote average cost function: Dim db As DAO.Database, r As DAO.Recordset, s As String Dim Result As Currency, SingleR As DAO.Recordset Set db = CurrentDb s = "Select Merch_Item_UPC FROM tblMerch WHERE Merch_Item_Manual_Costing = 0 AND Merch_Item_UPC <> '' AND Merch_Item_UPC IN (SELECT PO_Item_UPC FROM tblPO_Items WHERE PO_Id_FK = " & Me!PO_ID & ")" Set r = db.OpenRecordset(s, dbOpenSnapshot) r.MoveFirst Do While Not r.EOF If (IsNull(r!Merch_Item_UPC) = False) Then s = "SELECT AvgPrice FROM qryMerch_ItemAvg_ByUPC WHERE UPC = '" & CStr(r!Merch_Item_UPC) & "'" Set SingleR = CurrentDb.OpenRecordset(s) If (SingleR.EOF = False) Then Result = SingleR(0).Value If (IsNull(Result) = False) Then s = "UPDATE tblMerch SET merch_Item_Cost = " & Result & " WHERE Merch_Item_UPC = '" & CStr(r!Merch_Item_UPC) & "'" CurrentDb.Execute s End If End If End If Result = 0 r.MoveNext Loop r.Close Set r = Nothing Staff meeting to review changes to WEA PO process. Dan concerned about time it may take Katie to add/update Oracle PO, so we’ll revisit next week. WB Merch system being used by WEA for PO entry and process is go well.
4/15
4/15
4/17
4/17
Merch End A&R ADMIN DATABASE What Status Add Date Date/Comments Done
RECOUP ADMIN DATABASE What Video Tracker Status
Review the production database for test data entered by Infosys so Laura can remove these projects. Also discussed removal of employee names for those no longer with the company and explained that they can be remove with no effect on existing projects. From Laura: can we also please delete all the fake files that were created to test everything? There’s a ton of josh groban "february songs" and stuff like that for other artists, etc. Some users in VPT application got deleted hence we need to restore the table dbo.vp_inhouse in WMGGSLASQL01 database. Please see and let us know what was last backup date for this table or database. I will then ask Bernard or Isadora to approve the request for restore. Add following sub: Private Sub Form_Dirty(Cancel As Integer) On Error GoTo Err_Form_Dirty ' Load relationship ID Me!Cue_Vid_ID_FK = Forms!frmVideo_Production_Tracking!Vid_ID ' Load update to tblVid_Production.Vid_Que_Sheet_Loaded flag here ************************** Forms!frmVideo_Production_Tracking!Vid_Que_Sheet_Loaded = True Exit_Form_Dirty: Exit Sub Err_Form_Dirty: MsgBox Err.Description & " Form_Dirty " Resume Exit_Form_Dirty End Sub If it's development, we will put up a request for database refresh with Production instead of deleting junk data from dev. All the changes of PKE 8283 are migrated to production. The requirement was : 1. Add new search fields on Search screen. The search fields are Visual Type, Selection#, Label, and Film (Format). 2. Rename existing label of Inhouse1 as Video under Budget tab of Video Details screen. Add a new label with description “A&R Admin” to the Inhouse2 dropdown shown on the Video Details screen. Add a new dropdown list and label for “MKTG” on budget tab of
Add Date 4/13
Date/Comments
Done 4/13
Video Tracker
4/14
4/14
Video Clearance
4/15
4/15
Video Tracker
4/16
4/16
Video Details screen. 3. Video Details screen.
Add ISRC field to the budget tab of
Video End SIR DATABASE What SIR Status
Created Nonesuch schedule and removed Qdef generation functions: Dim stDateFrmtd As String stDateFrmtd = Format(Now(), "MM/DD/YYYY") ' Dim myQdef As DAO.QueryDef' ' Set myQdef = CurrentDb.QueryDefs("qryCombinedSummaryBuild_Nonesuch") strDate = InputBox("Please enter date in mm/dd/yyyy format", "INTERNAL Version w/DVD: Report Date", stDateFrmtd) If Not IsDate(strDate) And Len(Trim(strDate)) > 0 Then MsgBox "Please enter a valid date to continue", vbInformation, "INTERNAL Version w/DVD: Report Date" Exit Sub End If If Not IsDate(strDate) And Len(Trim(strDate)) < 1 Then 'Close Sub Exit Sub End If myQdef.SQL = formQuery(strDate)
Add Date 4/15
Date/Comments
Done 4/15
SIR End Misc. What Digital Sales Catalog Status
Review mod’s to database and test w/ Karen. Push changes to production version. Coordinated access for Courtney to be able to maint the “Invalid Brach Codes”. Infosys was not clear on menu options so additional research was required to get this completed.
Add Date 4/13 4/13
Date/Comments
Done 4/13 4/13
Delivery Agent
PMDJ process
Digital Download
Store Sales Download Sales
Replacement orders for DA: On Friday 04/10/09 at 10:05 P.M. we received one PO from Delivery Agent and it is on hold in EDI system. The file sequence# is 3469. PO# 3469-2600496-2120191 (for Yvan Carette , 6441, des PerceNeige, apt. 206441).UPC 809736444085 QTY = 1 We stopped processing these orders at our end. What needs to be done here? Canceled order and advised to send detail info to Sally at B3. Aija Lise @ 818 953-3211 on behalf of Perry Watts-Russell is not able to complete order on inside.wbr.com under PMDJ New Order Form User is trying to order cds and when she changed the date, it took her to the beginning of the page. When at step 5 of 7 to send the order it reverts back to the search and never completes when logged in as Perry Watts-Russell. The science behind the solution: Access and SQL Server use different data types. It converts the data types over when you open a linked table. When you attempt to update, Access checks again, but using different conversion filters for some reason. Because there is no timestamp in the table to show when it was last updated, it has to compare all the different fields, which it interprets differently. It might consider 1.25 to be 1.25 one time but 1.3 when checking. it see's two different values and thinks someone updated the record while you had it open. I'm not sure exactly what isn't being converted properly, but by adding a timestamp, it will check that instead and can compare it properly. So in your production database, you need to drop the linked table and re-add it (it now has a timestamp) and rename it to remove the "dbo_" in front of "tbl". I updated the record when testing it. We might need to do this to other tables as well. This isn't an issue when updating in the SQL Server interface or through normal SQL (like in a query). Will drop tables from SQL and re-link on Karen’s PC. Build list of UPC’s currently selected for BSM sales reporting. Send to Wyatt & Kevin for updates.
Essentially the purchase process for digital is the same as the process for merchandise or recorded music. The ONLY differences in the checkout process are: >> On Address page - if shopper ONLY has digital items in their cart we do not gather shopping "Ship To Address" >> On Payment / Finalize page - there is no charge for Shipping and Handling >> On Order Confirmation Page - there are download instructions and a "Download Now" button. >> In the Order Confirmation Email - there is verbiage about digital downloads and a link that shoppers can use to download their content again if they didn't when they placed their order or if they paid with
4/13
4/13
4/13
4/13
4/14
4/14
4/15
4/15
4/15
4/15
Catalog File Fan Club Process
PayPal. Review meeting w/ Shawn to 1. Improve speed of slow processing reports. 2. Remove select queries based on current year flags using embedded SQL with variable passthrough. 3. Start dev on top XX reports. Manual update of singles & albums for up to date reporting.
Numerious issues reported by Caroline and Lynette about Nashville artists. Forwarded to Ethan and Josh & Earnest are working them. Ben will provide refunds for dup charges.
4/15 4/17
4/15 4/17