Fix<\/p>\n\n\n\n
Fix Allergan in your CSV, re-save, then run this. Save as powershell<\/p>\n\n\n\n Run it:<\/p>\n\n\n\n powershell<\/p>\n\n\n\n ALREADY THERE covers last week’s uploads \u2014 those get skipped, not re-copied. Run the dry run first and send me the counts; with 717 rows the file scan will take a few minutes since it searches the source tree per file.<\/p>\n\n\n\n I am sharing this code with my colleague so Give instructions on what to change<\/p>\n\n\n\n Here’s a note you can send along with the script.<\/p>\n\n\n\n Before running: three lines to change at the top<\/strong><\/p>\n\n\n\n powershell<\/p>\n\n\n\n Replace Building the CSV<\/strong><\/p>\n\n\n\n Copy columns C, E, G, I from the Master Agreement Tracker into a new workbook as columns A\u2013D. Headers must be in row 1<\/strong> (delete any blank row above) and named exactly: Running it<\/strong><\/p>\n\n\n\n Save the script as a powershell<\/p>\n\n\n\n Close the CSV in Excel first, or the read may fail.<\/p>\n\n\n\n Run once with Reading the output<\/strong><\/p>\n\n\n\n Two files land on your Desktop: Statuses:<\/p>\n\n\n\n The script never creates or renames folders \u2014 it only matches existing ones \u2014 so a mismatch always shows as a flag rather than a new folder appearing.<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n Then verify before running anything:<\/p>\n\n\n\n powershell<\/p>\n\n\n\n You want four properties named Vendor \/ Master \/ Docs \/ RolledUp, and the RolledUp value showing multiple filenames rather than just one. If you see Before the dry run, check the parse count against column G across every row. Paste the function first (type the quotes rather than pasting them):<\/p>\n\n\n\n powershell<\/p>\n\n\n\n Boston Scientific should come back 45. Any row that prints is one where a filename didn’t parse cleanly \u2014 those are worth looking at individually rather than assuming the count is close enough.<\/p>\n\n\n\n Worth a quick look at what the missing line is before you do, though, since both being off-by-one suggests a pattern rather than two random glitches:<\/p>\n\n\n\n powershell<\/p>\n\n\n\n Compare that against what The Intuitive Surgical row is probably the same class of issue.<\/strong> Check it:<\/p>\n\n\n\n powershell<\/p>\n\n\n\n That prints only the lines the parser rejected, so you’ll see the malformed one directly instead of scanning 24 filenames.<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n able with a move \u2014 no re-download needed. The structure is vendor \u2192 subfolder \u2192 file even for single-doc rows, which my earlier script didn’t account for. The files are all sitting one level too high.<\/p>\n\n\n\n This finds each file at vendor level and moves it into the matching subfolder:<\/p>\n\n\n\n Matching goes exact-name-minus-extension first, then a prefix match only when it resolves to exactly one subfolder. Ambiguous or missing cases get flagged as NO SUBFOLDER MATCH and the file stays put rather than being moved somewhere guessed \u2014 the Settrax-style subfolders with long timestamp suffixes are where prefix matching earns its keep.<\/p>\n\n\n\n Run with Those are the real-run errors, and the cause is almost certainly path length<\/strong>. Your destRoot is already long, and some subfolders have very long names (the Settrax one with the double timestamp is ~85 characters on its own). Add vendor + filename and you blow past the 260-character Windows limit \u2014 which surfaces exactly as “Could not find a part of the path.”<\/p>\n\n\n\n Check the ones that failed:<\/p>\n\n\n\n Anything with Fix<\/strong> \u2014 .NET’s file API handles long paths via the It skips anything already sitting correctly in its subfolder, so it’s safe to run after a partial success.<\/p>\n\n\n\n If files remain stuck after that, the practical fallback is asking Akshay whether those subfolder names can be shortened \u2014 the timestamped ones are the problem, and that’s a structure decision rather than something to change unilaterally.<\/p>\n\n\n\n The retry is reporting the source<\/strong> file missing, not the destination \u2014 so path length probably isn’t the story. Let’s see the actual paths rather than guess:<\/p>\n\n\n\n That tells us which of three things it is: the file already left vendor level (SrcOK false \u2014 possibly your manual moves), the target subfolder doesn’t exist (DstDir false \u2014 bad prefix match), or lengths near 260 (genuinely path length).<\/p>\n\n\n\n Send me that output and I’ll give you the right fix rather than another guess. Worth also checking one of those vendor folders in the SharePoint browser view \u2014 seeing where the file actually sits right now is often faster than inferring it.<\/p>\n\n\n\n <\/p>\n\n\n\n Yes \u2014 they’ll come through as MISSING, with vendor and filename. To list just those:<\/p>\n\n\n\n That’s your download-and-redo list. Once you pull those 3 from Kira into Worth cross-checking that list against the original Good idea \u2014 final verification. This checks every CSV row and reports where the file actually sits under its vendor folder:<\/p>\n\n\n\n What you want to see: everything as IN SUBFOLDER except the 3 that were never downloaded (MISSING).<\/p>\n\n\n\n If any come back AT VENDOR LEVEL, those still need moving. DUPLICATE means the same filename exists in two places under that vendor \u2014 worth looking at rather than assuming, since it could be a genuine second copy from a manual move.<\/p>\n\n\n\n The full per-row detail lands in One note: if If the PowerShell session is still open, If you’ve since closed it, read from the saved file instead:<\/p>\n\n\n\n If the list is long enough to be awkward in the terminal, drop it to its own CSV so you can work through it in Excel:<\/p>\n\n\n\n Worth splitting them once you see the list: MISSING means download from Kira, AT VENDOR LEVEL means the file is already there and just needs moving down a level. Different fixes, and the vendor-level ones are quick.<\/p>\n","protected":false},"excerpt":{"rendered":" Fix Fix Allergan in your CSV, re-save, then run this. Save as Desktop\\upload_final.ps1 in Notepad (Save as type: All Files) rather than pasting: powershell Run it: powershell ALREADY THERE covers last week’s uploads \u2014 those get skipped, not re-copied. Run the dry run first and send me the counts; with 717 rows the file scan will take… Continue reading Haypoh<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-626","post","type-post","status-publish","format-standard","hentry","category-blog","entry"],"_links":{"self":[{"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/posts\/626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/comments?post=626"}],"version-history":[{"count":43,"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/posts\/626\/revisions"}],"predecessor-version":[{"id":671,"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/posts\/626\/revisions\/671"}],"wp:attachment":[{"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/media?parent=626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/categories?post=626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hayooh.in\/index.php\/wp-json\/wp\/v2\/tags?post=626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Desktop\\upload_final.ps1<\/code> in Notepad (Save as type: All Files) rather than pasting:<\/p>\n\n\n\n$csv = \"C:\\Users\\HU346SK\\OneDrive - EY\\Desktop\\mapping_multi.csv\"\n$source = \"C:\\Users\\HU346SK\\OneDrive - EY\\Desktop\\Sonnet upload\"\n$destRoot = \"C:\\Users\\HU346SK\\OneDrive - EY\\Vitality Acute Program - 17. Outside Counsel Folder Structure\"\n$dryRun = $true\n\nfunction Get-Files($cell) {\n ($cell -split \"`n\") | ForEach-Object {\n $t = $_.Trim() -replace '^[\\u2022\\-\\*]\\s*',''\n if ($t -match '^(.+?\\.(pdf|docx?|msg|xlsx?))') { $Matches[1] }\n } | Where-Object { $_ }\n}\n\n$log = foreach ($row in Import-Csv $csv) {\n $vendorPath = Join-Path $destRoot $row.Vendor.Trim()\n $master = $row.Master.Trim()\n if (-not (Test-Path $vendorPath)) {\n [pscustomobject]@{Vendor=$row.Vendor; File=$master; Target=\"\"; Status=\"VENDOR FOLDER NOT FOUND\"}\n continue\n }\n $base = [IO.Path]::GetFileNameWithoutExtension($master)\n $subs = Get-ChildItem $vendorPath -Directory -ErrorAction SilentlyContinue\n $m = @($subs | Where-Object { $_.Name -eq $base -or $_.Name -eq $master })\n if ($m.Count -eq 0) {\n $m = @($subs | Where-Object { $_.Name -like \"$base*\" })\n if ($m.Count -ne 1) { $m = @() }\n }\n if ($m.Count -eq 0) {\n [pscustomobject]@{Vendor=$row.Vendor; File=$master; Target=\"\"; Status=\"NO SUBFOLDER MATCH\"}\n continue\n }\n $target = $m[0].FullName\n $files = @($master) + (Get-Files $row.RolledUp) | Select-Object -Unique\n foreach ($f in $files) {\n if (Test-Path (Join-Path $target $f)) {\n [pscustomobject]@{Vendor=$row.Vendor; File=$f; Target=$m[0].Name; Status=\"ALREADY THERE\"}\n continue\n }\n $src = Get-ChildItem $source -Recurse -File -Filter $f -ErrorAction SilentlyContinue | Select-Object -First 1\n if (-not $src) {\n [pscustomobject]@{Vendor=$row.Vendor; File=$f; Target=$m[0].Name; Status=\"FILE NOT DOWNLOADED\"}\n } else {\n $st = \"OK\"\n if (-not $dryRun) {\n try { Copy-Item $src.FullName -Destination $target -ErrorAction Stop }\n catch { $st = \"COPY FAILED: $($_.Exception.Message)\" }\n }\n [pscustomobject]@{Vendor=$row.Vendor; File=$f; Target=$m[0].Name; Status=$st}\n }\n }\n}\n\n$log | Export-Csv \"$env:USERPROFILE\\Desktop\\upload_log_final.csv\" -NoTypeInformation\n\n$rowStatus = $log | Group-Object Vendor, Target | ForEach-Object {\n $done = @($_.Group | Where-Object Status -in \"OK\",\"ALREADY THERE\").Count\n $miss = @($_.Group | Where-Object Status -notin \"OK\",\"ALREADY THERE\")\n [pscustomobject]@{\n Vendor = $_.Group[0].Vendor\n Subfolder = $_.Group[0].Target\n Expected = $_.Count\n Present = $done\n Missing = $miss.Count\n RowStatus = if ($miss.Count -eq 0) { \"COMPLETE\" } elseif ($done -eq 0) { \"NONE\" } else { \"PARTIAL\" }\n MissingFiles = ($miss.File -join \"; \")\n }\n}\n$rowStatus | Export-Csv \"$env:USERPROFILE\\Desktop\\row_status_final.csv\" -NoTypeInformation\n\n$log | Group-Object Status | Select Name, Count\n$rowStatus | Group-Object RowStatus | Select Name, Count<\/code><\/pre>\n\n\n\npowershell -ExecutionPolicy Bypass -File \"$env:USERPROFILE\\Desktop\\upload_final.ps1\"<\/code><\/pre>\n\n\n\n
\n\n\n\n$csv = \"C:\\Users\\HU346SK\\OneDrive - EY\\Desktop\\mapping_multi.csv\"\n$source = \"C:\\Users\\HU346SK\\OneDrive - EY\\Desktop\\Sonnet upload\"\n$destRoot = \"C:\\Users\\HU346SK\\OneDrive - EY\\Vitality Acute Program - 17. Outside Counsel Folder Structure\"<\/code><\/pre>\n\n\n\nHU346SK<\/code> with your own user folder in all three. Easiest way to get the exact paths: open each folder in File Explorer, click the address bar, and copy what’s there.<\/p>\n\n\n\n\n
$csv<\/code>\u00a0\u2014 your mapping CSV (see below)<\/li>\n\n\n\n$source<\/code>\u00a0\u2014 folder holding the Kira exports; the script searches subfolders too, so exports can stay in their own extracted folders<\/li>\n\n\n\n$destRoot<\/code>\u00a0\u2014 the SharePoint library. Add a shortcut to OneDrive from the “17. Outside Counsel Folder Structure” library (Add shortcut to OneDrive), wait for it to sync, then use that local path. Note the folder name gets prefixed with the site name.<\/li>\n<\/ul>\n\n\n\nVendor<\/code>, Master<\/code>, Docs<\/code>, RolledUp<\/code>. Paste as values, not formulas. Save as CSV UTF-8 (Comma delimited)<\/strong>.<\/p>\n\n\n\n.ps1<\/code> file via Notepad (Save as type: All Files) rather than pasting into the terminal \u2014 pasting can convert quotes to curly quotes, which breaks it. Then in PowerShell:<\/p>\n\n\n\npowershell -ExecutionPolicy Bypass -File \"$env:USERPROFILE\\Desktop\\upload_final.ps1\"<\/code><\/pre>\n\n\n\n$dryRun = $true<\/code> (nothing is copied, it just reports), check the counts, then change to $dryRun = $false<\/code> and run again.<\/p>\n\n\n\nupload_log_final.csv<\/code> (one line per file) and row_status_final.csv<\/code> (one line per contract family, with expected vs present counts and any missing filenames).<\/p>\n\n\n\n\n
subst X: \"<destRoot>\"<\/code>\u00a0then set\u00a0$destRoot = \"X:\\\"<\/code><\/li>\n<\/ul>\n\n\n\n$csv = \"C:\\Users\\HU346SK\\OneDrive - EY\\Desktop\\mapping_multi.csv\"\n$rows = Import-Csv $csv\n\"Rows: $($rows.Count)\"\n$rows | Select -First 1 | Format-List<\/code><\/pre>\n\n\n\nH1<\/code> as a property name again, there’s still a blank row above the headers.<\/p>\n\n\n\nfunction Get-Files($cell) {\n ($cell -split \"`n\") | ForEach-Object {\n $t = $_.Trim() -replace '^[\\u2022\\-\\*]\\s*',''\n if ($t -match '^(.+?\\.(pdf|docx?|msg|xlsx?))') { $Matches[1] }\n } | Where-Object { $_ }\n}\n\n$rows | ForEach-Object {\n $p = @(Get-Files $_.RolledUp).Count + 1\n if ($p -ne [int]$_.Docs) {\n [pscustomobject]@{Vendor=$_.Vendor; Master=$_.Master; ExcelDocs=$_.Docs; Parsed=$p}\n }\n} | Format-Table -AutoSize<\/code><\/pre>\n\n\n\n$r = $rows | Where-Object Vendor -eq \"Allergan\"\n$r.RolledUp -split \"`n\" | ForEach-Object { $_.Trim() }<\/code><\/pre>\n\n\n\nGet-Files<\/code> returned. If it’s a filename with an unusual extension or a line wrapped oddly in the cell, you’ll know whether to just add it manually to the CSV or whether the same thing could bite elsewhere.<\/p>\n\n\n\n$r2 = $rows | Where-Object Vendor -like \"Intuitive*\"\n$r2.RolledUp -split \"`n\" | ForEach-Object { $t = $_.Trim(); if ($t -notmatch '\\.(pdf|docx?|msg|xlsx?)') { $t } }<\/code><\/pre>\n\n\n\n$csv = \"C:\\Users\\HU346SK\\OneDrive - EY\\Desktop\\mapping150.csv\"\n$destRoot = \"C:\\Users\\HU346SK\\OneDrive - EY\\Vitality Acute Program - 17. Outside Counsel Folder Structure\"\n$dryRun = $true\n\n$fix = foreach ($row in Import-Csv $csv) {\n $vendorPath = Join-Path $destRoot $row.Vendor.Trim()\n $file = $row.Master.Trim()\n $filePath = Join-Path $vendorPath $file\n if (-not (Test-Path $filePath)) {\n [pscustomobject]@{Vendor=$row.Vendor; File=$file; Target=\"\"; Status=\"NOT AT VENDOR LEVEL\"}\n continue\n }\n $base = [IO.Path]::GetFileNameWithoutExtension($file)\n $subs = Get-ChildItem $vendorPath -Directory\n $match = @($subs | Where-Object { $_.Name -eq $base -or $_.Name -eq $file })\n if ($match.Count -eq 0) {\n $match = @($subs | Where-Object { $_.Name -like \"$base*\" })\n if ($match.Count -ne 1) { $match = @() }\n }\n if ($match.Count -eq 0) {\n [pscustomobject]@{Vendor=$row.Vendor; File=$file; Target=\"\"; Status=\"NO SUBFOLDER MATCH\"}\n } else {\n $t = $match[0]\n if (-not $dryRun) { Move-Item $filePath -Destination $t.FullName }\n [pscustomobject]@{Vendor=$row.Vendor; File=$file; Target=$t.Name; Status=\"MOVED\"}\n }\n}\n$fix | Export-Csv \"$env:USERPROFILE\\Desktop\\move_log_150.csv\" -NoTypeInformation\n$fix | Group-Object Status | Select Name, Count\n<\/code><\/pre>\n\n\n\n$dryRun = $true<\/code> first and send me the counts. The Target column in the log lets you eyeball whether the prefix matches picked sensible folders before you commit.<\/p>\n\n\n\n$fix | Where-Object Status -eq \"MOVED\" | ForEach-Object {\n $p = Join-Path (Join-Path (Join-Path $destRoot $_.Vendor.Trim()) $_.Target) $_.File\n if (-not (Test-Path $p)) { [pscustomobject]@{File=$_.File; Len=$p.Length} }\n} | Sort Len -Descending\n<\/code><\/pre>\n\n\n\nLen<\/code> near or over 260 confirms it. Note the log says MOVED for these even though the move failed \u2014 the status was written regardless of the error, so trust this check over the log.<\/p>\n\n\n\n\\\\?\\<\/code> prefix where the cmdlet can’t:<\/p>\n\n\n\n$retry = foreach ($r in $fix | Where-Object Status -eq \"MOVED\") {\n $vp = Join-Path $destRoot $r.Vendor.Trim()\n $src = Join-Path $vp $r.File\n $dst = Join-Path (Join-Path $vp $r.Target) $r.File\n if (Test-Path $dst) { continue }\n if (-not (Test-Path $src)) {\n [pscustomobject]@{File=$r.File; Status=\"SOURCE GONE\"}\n continue\n }\n try {\n [System.IO.File]::Move(\"\\\\?\\$src\", \"\\\\?\\$dst\")\n [pscustomobject]@{File=$r.File; Status=\"FIXED\"}\n } catch {\n [pscustomobject]@{File=$r.File; Status=\"STILL FAILING: $($_.Exception.Message)\"}\n }\n}\n$retry | Group-Object Status | Select Name, Count\n<\/code><\/pre>\n\n\n\n$bad = $fix | Where-Object Status -eq \"MOVED\" | ForEach-Object {\n $vp = Join-Path $destRoot $_.Vendor.Trim()\n $dst = Join-Path (Join-Path $vp $_.Target) $_.File\n if (-not (Test-Path $dst)) { $_ }\n}\n$bad | Select -First 3 | ForEach-Object {\n $vp = Join-Path $destRoot $_.Vendor.Trim()\n $src = Join-Path $vp $_.File\n $dst = Join-Path (Join-Path $vp $_.Target) $_.File\n [pscustomobject]@{\n File = $_.File\n SrcOK = Test-Path $src\n DstDir = Test-Path (Join-Path $vp $_.Target)\n SrcLen = $src.Length\n DstLen = $dst.Length\n Target = $_.Target\n }\n} | Format-List\n<\/code><\/pre>\n\n\n\n$verify | Where-Object Status -eq \"MISSING\" | Format-Table Vendor, File -AutoSize\n<\/code><\/pre>\n\n\n\nSonnet upload<\/code>, you can copy them straight into the right subfolder rather than re-running the whole pipeline \u2014 by then you’ll know the exact target folder name from the verify output for neighbouring rows.<\/p>\n\n\n\nupload_log_150.csv<\/code> FILE NOT DOWNLOADED rows. If they match, the story is clean end to end: 3 never downloaded, everything else placed. If MISSING shows more than 3, something slipped between the copy and the move, and that’s worth tracing before you call it done.<\/p>\n\n\n\n$verify = foreach ($row in Import-Csv $csv) {\n $vendor = $row.Vendor.Trim()\n $file = $row.Master.Trim()\n $vp = Join-Path $destRoot $vendor\n if (-not (Test-Path $vp)) {\n [pscustomobject]@{Vendor=$vendor; File=$file; Location=\"\"; Status=\"NO VENDOR FOLDER\"}\n continue\n }\n $hits = @(Get-ChildItem $vp -Recurse -File -Filter $file -ErrorAction SilentlyContinue)\n if ($hits.Count -eq 0) {\n [pscustomobject]@{Vendor=$vendor; File=$file; Location=\"\"; Status=\"MISSING\"}\n } else {\n $h = $hits[0]\n $inSub = $h.DirectoryName -ne $vp\n [pscustomobject]@{\n Vendor = $vendor\n File = $file\n Location = Split-Path $h.DirectoryName -Leaf\n Status = if ($hits.Count -gt 1) { \"DUPLICATE\" }\n elseif ($inSub) { \"IN SUBFOLDER\" }\n else { \"AT VENDOR LEVEL\" }\n }\n }\n}\n$verify | Export-Csv \"$env:USERPROFILE\\Desktop\\verify_150.csv\" -NoTypeInformation\n$verify | Group-Object Status | Select Name, Count\n<\/code><\/pre>\n\n\n\nverify_150.csv<\/code>, which is the artifact to keep alongside the upload log for Akshay.<\/p>\n\n\n\nsubst X:<\/code> is still active, it doesn’t affect this \u2014 $destRoot<\/code> points at the real path either way. Run subst X: \/D<\/code> to clean up when you’re finished.<\/p>\n\n\n\n$verify<\/code> is in memory:<\/p>\n\n\n\n$verify | Where-Object Status -in \"MISSING\",\"AT VENDOR LEVEL\" | Format-Table Vendor, File, Status -AutoSize\n<\/code><\/pre>\n\n\n\nImport-Csv \"$env:USERPROFILE\\Desktop\\verify_150.csv\" |\n Where-Object Status -in \"MISSING\",\"AT VENDOR LEVEL\" |\n Format-Table Vendor, File, Status -AutoSize\n<\/code><\/pre>\n\n\n\nImport-Csv \"$env:USERPROFILE\\Desktop\\verify_150.csv\" |\n Where-Object Status -in \"MISSING\",\"AT VENDOR LEVEL\" |\n Export-Csv \"$env:USERPROFILE\\Desktop\\to_fix.csv\" -NoTypeInformation\n<\/code><\/pre>\n\n\n\n