Commit Graph

62 Commits

Author SHA1 Message Date
Bobby Abellana
69d132300d Made GUI Changes 2025-02-24 15:27:25 -08:00
Bobby Abellana
38f5793883 ExcelFileHandling 2025-02-24 15:04:58 -08:00
Bobby Abellana
b45a6c490a Created README.md 2025-02-24 14:47:52 -08:00
Bobby Abellana
eb0f2299d3 Removed recurisve 2025-02-24 14:39:31 -08:00
Bobby Abellana
7822f074c4 ConvertsXLStoXLSX and save to original location 2025-02-24 14:37:47 -08:00
Bobby Abellana
e29391639f Saving Converted Files in Temp Library with same folder structure 2025-02-24 14:13:17 -08:00
Bobby Abellana
d729b88606 cursor update 2025-02-21 15:34:46 -08:00
Bobby Abellana (aider)
ffbe44da0a fix: Add error handling for Excel SaveAs operation in Convert-Files function 2025-02-21 11:30:09 -08:00
Bobby Abellana (aider)
e615e043e3 refactor: Replace Excel Interop enum with numeric constant in SaveAs 2025-02-21 11:27:23 -08:00
Bobby Abellana (aider)
64540f9a0e refactor: Simplify Excel file conversion by removing temporary file handling 2025-02-21 11:26:00 -08:00
Bobby Abellana (aider)
ff2500707f fix: Improve Excel file conversion with temp files and better cleanup 2025-02-21 11:24:11 -08:00
Bobby Abellana (aider)
b725f52366 fix: Correct temp library path construction and remove duplicate upload 2025-02-21 11:14:46 -08:00
Bobby Abellana (aider)
93ffe6a5a2 refactor: Simplify Excel conversion process in SharePointFunctions.ps1 2025-02-21 11:11:37 -08:00
Bobby Abellana (aider)
31407f0330 fix: Improve Excel file handling with temporary paths and better cleanup 2025-02-21 11:09:47 -08:00
Bobby Abellana (aider)
2077423bc0 refactor: Replace Import-Module with dot-sourcing in PowerShell scripts 2025-02-21 11:07:58 -08:00
Bobby Abellana (aider)
b8049f6f85 refactor: Replace SaveAs2 with standard SaveAs method in Excel conversion 2025-02-21 11:03:55 -08:00
Bobby Abellana (aider)
cc887b4d3e fix: Improve Excel file conversion with SaveAs2 and robust path handling 2025-02-21 11:02:24 -08:00
Bobby Abellana (aider)
b55058161a fix: handle file paths with spaces and special characters in Excel conversion 2025-02-21 11:00:28 -08:00
Bobby Abellana (aider)
dfb9dc3557 fix: handle spaces in Excel SaveAs paths and add file verification 2025-02-21 10:58:34 -08:00
Bobby Abellana (aider)
c6c0769384 fix: Use -OutputFilePath for binary downloads in Convert-Files 2025-02-21 10:56:30 -08:00
Bobby Abellana (aider)
065a822866 fix: Correct file download method in Convert-Files function 2025-02-21 10:54:58 -08:00
Bobby Abellana (aider)
83895edac4 fix: Correct URI construction and ensure proper function exports/imports 2025-02-21 10:53:22 -08:00
Bobby Abellana (aider)
529c0f3982 fix: Update SharePoint file download/upload to use proper drive ID 2025-02-21 10:52:05 -08:00
Bobby Abellana (aider)
728ce14af4 fix: Properly escape URI and improve Load-Config error message 2025-02-21 10:49:18 -08:00
Bobby Abellana (aider)
3a2cb289db refactor: Improve Excel COM object handling with try-finally and GC cleanup 2025-02-21 10:47:07 -08:00
Bobby Abellana (aider)
eb6c9adc6b feat: Implement file conversion logic using DocumentFormat.OpenXml 2025-02-21 10:21:17 -08:00
Bobby Abellana (aider)
fe308bc16f feat: Add placeholder Convert-Files function to SharePointFunctions.ps1 2025-02-21 10:16:42 -08:00
Bobby Abellana (aider)
f1e3a09cc0 feat: Add recursive listing checkbox to MainForm 2025-02-21 10:13:39 -08:00
Bobby Abellana (aider)
aed44fc07d fix: Check folder and child count before recursing in Get-XlsFilesRecursive 2025-02-21 09:50:07 -08:00
Bobby Abellana (aider)
6bda577ba3 feat: Add newlines to status text for file listing 2025-02-21 09:46:16 -08:00
Bobby Abellana (aider)
bbf46c9eb8 fix: Add null checks and error handling in Get-XlsFilesRecursive 2025-02-21 09:42:26 -08:00
Bobby Abellana (aider)
cc799c7d68 feat: Add recursive search for XLS files in subfolders 2025-02-21 09:39:39 -08:00
Bobby Abellana (aider)
004a3d239e feat: Add Load-Config and Save-Config functions to SharePointFunctions.ps1 2025-02-21 09:36:15 -08:00
Bobby Abellana (aider)
b6c9a15a15 feat: Add "Select Folder" button to folder browser dialog 2025-02-21 09:34:43 -08:00
Bobby Abellana (aider)
7fb87bdccf fix: Correct URL encoding for folder paths with spaces 2025-02-21 09:32:38 -08:00
Bobby Abellana (aider)
c30d7ccdc5 refactor: Replace Out-GridView with Form and ListBox in Get-FolderBrowser 2025-02-21 09:30:59 -08:00
Bobby Abellana (aider)
37ec5d328e feat: Add subfolder browsing to Get-FolderBrowser function 2025-02-21 09:28:26 -08:00
Bobby Abellana (aider)
5194dc0198 fix: URL encode folder path in List-XlsFiles function 2025-02-21 09:26:32 -08:00
Bobby Abellana (aider)
4a3c1bb26e fix: Correct folder path resolution in List-XlsFiles function 2025-02-21 09:24:12 -08:00
Bobby Abellana (aider)
c955fed489 fix: Improve folder path resolution and error handling in List-XlsFiles 2025-02-21 09:22:25 -08:00
Bobby Abellana (aider)
0a4df5e4dc refactor: Update List-XlsFiles to use Graph API with detailed logging 2025-02-19 15:56:31 -08:00
Bobby Abellana (aider)
8f9df8e97d fix: correct folder retrieval by using DriveId and DriveItemId 2025-02-19 15:49:28 -08:00
Bobby Abellana (aider)
d3e21955da fix: Update Graph API permissions and site access method in folder browser 2025-02-19 15:46:33 -08:00
Bobby Abellana (aider)
d3ffe1098a fix: Correct SharePoint site lookup in Get-FolderBrowser function 2025-02-19 15:45:07 -08:00
Bobby Abellana (aider)
3d170f3652 fix: Improve site search in Get-FolderBrowser with better URL handling 2025-02-19 15:42:53 -08:00
Bobby Abellana (aider)
aaabb11624 fix: Handle Shared Documents URL format and update config 2025-02-19 15:41:23 -08:00
Bobby Abellana (aider)
2752601537 refactor: Update Get-FolderBrowser to use Graph API instead of PnP 2025-02-19 15:38:22 -08:00
Bobby Abellana (aider)
df82840f99 refactor: Migrate from PnP to Microsoft Graph authentication 2025-02-19 15:34:44 -08:00
Bobby Abellana (aider)
87da4e1185 refactor: Remove hardcoded -SiteUrl parameter from SharePoint functions 2025-02-19 15:19:36 -08:00
Bobby Abellana (aider)
a5ba06c2bf refactor: Simplify Connect-SharePoint by removing unsupported parameters 2025-02-19 15:17:44 -08:00