The URL can be used to link to this page

Home My WebLink AboutInv# 132182 - VC3, Inc. - 12/31/2023VC3 IncPO Box 746804Atlanta, GA 30374-6804(803) 733-7333 Bill To: City of Dania Beach, FLAttn: Darryl McFarlane100 W. Dania Beach BlvdDania Beach, FL 33004United States Date Invoice 12/31/2023 132182 Account DAN03 Terms Due Date PO Number Reference Net 30 days 01/30/2024 2022-00000397 November Billing - SharePoint Migration Project Name PTM - SharePoint Document Migration Billing Type Standard Original Downpayment $0.00 Company Name Robert Baldwin Services Work Type Hours Rate Amount Billable Services Sharepoint Specialist Remote 29.00 190.00 $5,510.00 Total Services:$5,510.00 If you have any questions about this invoice, please do not hesitate to contact me directly. Thank You, Kylie. Kylie Cantanzarite | Kylie.Cantanzarite@VC3.com | 803.955.8823 Make checks payable to VC3 Inc Remit To:VC3, IncPO Box 746804Atlanta, GA 30374-6804 visit www.vc3.com/pay-invoice to pay via credit card If you are signed up for VC3's ACH program, drafts will occur after 15calendar days. Please email finance@vc3.com with any issues to stop thedraft of any invoice. ACH payments may be submitted to the following account information.Please send remittance detail to finance@vc3.com.Bank Name: PNC BankRouting Number: 021052053Account Number: 51843132 Invoice Subtotal:$5,510.00 Sales Tax:$0.00 Invoice Total:$5,510.00 Payments:$0.00 Credits:$0.00 Balance Due:$5,510.00 Invoice Time Detail Invoice Number:132182 Company:City of Dania Beach, FL Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/1/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/01/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Weekly migration meeting withDania beach. Post-meetingfollowup on questions aroundretention policies, and how CDMdoes not seem to be restrictedby them like the defaultSharePoint Browser interface.Tested deleting items andchecked to see if they would goto recycle bin/retention holdlibraries. Sent email to Darrylwith results from testing. Sent email to CDM supportregarding issues with someusers folders not showing in-app, despite their ability toaccess them within SharePoint. Set up staging migration forfinance:- Add Utilities and Invoiceslibraries to finance site andassign group permissions asexplained by Darryl in today'smeeting.- Create CSV file for FinanceNTFS source locations, andthose users in groups thatcurrently have membership.Run staging migration for therespective SharePoint/OneDrivesites. Y 3.50 190.00 $665.00 Subtotal: $665.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/3/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/03/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Check on status of Financestaging migration startedyesterday. Sent Darryl updateon folders that the on-premservice account could notaccess. Y 0.50 190.00 $95.00 Subtotal: $95.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/8/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/08/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Weekly migration meeting w/Dania Beach team. Discussionon migrating Financedepartment content.Migration planned for tomorrowevening. Y 0.50 190.00 $95.00 11/08/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Purge finance site Documentslibrary of previous migrationstagingRun migration of Finance siteMonitor progress.Update Darryl when completed. Y 2.00 190.00 $380.00 Subtotal: $475.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/10/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/10/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Export list of files to CSV from alllibraries in HR and Finance sitesusing custom powershell scriptFormat outputs to show onlyfiles that are too long, and allowfiltering based on site/library. Sent formatted document toDarryl for review. Y 2.00 190.00 $380.00 Subtotal: $380.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/15/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/15/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Weekly update meeting withDania beach. Discussionaround Finance and HR longpath issues.Post-meeting follow-up: - Email CDM Support tounderstand long path issueswith WebDav Folders. Receivedfollow up pointing to articlewhich explains issue in detail.- Run PowerShell Scripts toexport list of all files and foldersin HR and Finance sites- Compile results into two excelfiles (One each for Finance andHR) using a formula to convertthe path to a 'CDM' path. Excelstruggled with this given the Y 5.50 190.00 $1,045.00 sheer amount of rows in the filebut was able to eventually get itto work.-Sent completed files to Darrylto review. Subtotal: $1,045.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/17/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/17/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Work with Darryl to diagnoseissues with HR and Financesites: - Worked with Darryl todiagnose issues with SharePointsearch for lock files beginningwith (~$). Re-indexed HR sitelibraries which helped but didnot fully solve issue.Determined that script wouldprobably be best appropach. - Large # of lock files (Office filesthat begin with ~$) areconfusing users. Created ascript to identify these files onthe sites.Script ran successfully for HR,which I sent to Darryl but I didnot succeed with Finance due toresults set exceeding 5000items. Will have to tweak scriptand try again. Y 3.00 190.00 $570.00 Subtotal: $570.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/22/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/22/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Weekly update meeting.Discuss issues around longpaths and testing paths inmeeting when inconsistencieswere found with calculatedCloud Drive Mapper paths notlining up with tests. Post meeting tasks to attempttesting CDM paths using themigration server Dania beachprovided.After testing paths based onCDM documentation,discovered that the docs werewrong. After confirming some tests Iconfirmed the correct paths forfiles and now have a format thatcan be used to properlycalculate long paths for CDM 2.0 Y 6.50 190.00 $1,235.00 drives. Updated the Finance and HRlong path reports to reflect thecorrect path lengths, sent link toDarryl via teams. Subtotal: $1,235.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/24/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/24/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Work with Darryl via teams todo the following: Delete unused MS 365 group"Human Resources" to free upURL for /sites/hr path. Run Powershell script topermanently delete site before90 day wait period Change URL for HUmanResources site from"sites/HumanResources" to"sites/HR" Create library "Archive" in HRsite to move \\hr\archive foldercontent to (due to excessivelong paths) Update HR long path report toreflect changes above, sendupdate and link to Darryl viaTeams. Y 4.25 190.00 $807.50 Subtotal: $807.50 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/25/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/25/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Toggle Retention Policy off-and-on for HR site in Security &Compliance center when Darrylnotified he was unable to deletea folder on that site. Aftercompleting update to Retentionpolicy, tested deletion of folderDarryl wanted to removesuccessfully. Updated Darrylwith results and where to finddeleted folder in recycle bin. Y 1.00 190.00 $190.00 Subtotal: $190.00 Charge To: City of Dania Beach, FL / PTM - SharePoint Document MigrationDevelopment PhaseCity of Dania Beach,FL * DBSPMIG * Ensure Billing and Backup Configs Date: 11/26/2023 Date Staff Notes Bill Hours Rate Ext Amt 11/26/2023 Taylor, Justin Project Phase:DevelopmentPhase Project Activity:City of DaniaBeach, FL * DBSPMIG * EnsureBilling and Backup Configs Y 0.25 190.00 $47.50 Update URLs for City Clerk andCommunity Development sitesafter change requested byDarryl. Sent Darryl confirmationvia Teams. Subtotal: $47.50 Invoice Time Total:Billable Hours:29.00