Sharepoint excel file wont stop loading
Hi guys. Is it just me or is everyone facing a problem with Sharepoint excel files constantly just loading and not opening? My company runs on the sharepoint excel file and we cant access it suddenly since yesterday. It just says loading and wont stop loading and then it says it cant be opened. Any solutions?
Status Change tracker
#Sharepoint Hello, I have a list with a column " Status" . We have "open" " rejected" " sent to vendor" " closed" Can we track the status changes in Sharepoint and measure how long it takes for each case from the " open " to the "closed " status? We would like to measure performances if this is possible. Best Regards GD.
SharePoint On Premises Farm Restoration Question:
my unofficial supervisor broke the farm: I asked him to copy over a production content database to the test SQL Server we were using for the new farm I was building out. He accidentally overwrote the SharePoint 2016 Configuration database. His remedy: he used a database snapshot to restore the database to a point in time. He also may have restored the CA server to near that same point in time. Now, we have had several issues: patches that were installed show as not installed. the farm server went from "No action required" to "Needs Installation" The Search Service App won't communicate on port 808, even though it's open. The Search Service App was re-provisioned and the same symptoms persist. I believe that our issues are the result of this "restoration method" my supervisor employed. Can someone provide some concrete reasoning why the restoration method wouldn't work? I've explained that it severs the ties between the farm features and the configuraiton database. But it would be great to have a more expansive explanation.
Tahoe Server
25 years ago, I was a Windows Admin in Austin, TX at a place called Vignette (bought by OpenText years later). Back in the day, if you were Windows admin, you likely had an MSDN subscription with Microsoft. If so, every so often, they’d send big plastic cases filled with CD's including lots of their software, Windows versions, SQL, Exchange, etc. They’d send pre-released software sometimes. I remember pulling a “Tahoe Server” CD out of the case, installing it one of our dev servers & standing up Vignette’s first instance of SharePoint (circa 2000). That same night, I found a feature in the interface for indexing PDF’s. I made a ‘site’ for their legal department & pointed the PDF indexer at a folder that had thousands of PDF legal case files. By the next morning it was fully indexed, and I sent an email to the legal team with link to the site. They began working much faster than they’d ever done before. It was like having Google for all their legal cases where previously they’d manually dig through one PDF at a time & even print paper and hire people to read to find, highlight, review, etc. Several months later, I received a call from the CIO in the middle of the night. “Tyler, this is John C. That tool you setup our legal dept. is offline, and they need it back up ASAP!” I drove an hour into the office (cause that’s what we did in those days) and discovered that ‘Tahoe Server’ had expired. I was on the phone with Microsoft until long after the sun rose, migrating the Tahoe database to a fully licensed & officially titled “SharePoint” server. Lessons learned: PDF Data Extraction. SUPER POWERFUL!! Don’t put pre-released software into production… unless you’re prepared to suffer the consequences. Share the story someday.SharePoint 2016 Server - mquery.js event deprecation
Hello everyone, OnMay 31 2023, Google Chrome announced that mutation events are deprecated and will be removed from the browser starting on its 127 versionwhich goes to stable release onJuly 30 2024 (https://developer.chrome.com/blog/mutation-events-deprecation/). In the meantime, I've noticed in 3 different SharePoint 2016 Server environments that the javascript library mquery.jscontains some of these deprecated events such as "DOMSubtreeModified" and "DOMNodeRemoved": Since I want to avoid touching on this library by trying to replace these events by the MutationObserver alternative, is there any known solution (eg: official patch) or workaround for this? Thank you all in advance. Best regards, DuarteSharePoint 2019 On Premise: JavaScript <REST API>: 400 (Bad Request)
Hi there, I try to use the CAML w/ SharePoint REST API to extract the data from the List. And the JavaScript like this as follows. But unfortunately, when the REST API was performed, and error message played out. Has anyone encountered such a problem before and can provide relevant solutions? Because I spent a lot of time on this problem, thank you url: "https://accionvegana.org/accio/QjMt92YuQnZvN3byNWat5Se0lmb11WbvNGajVGd6MHc0/_api/web/lists(guid'98495B1F-2BD1-4B09-80CA-4A4FE5EF82ED')/GetItems", method: 'POST' 400 (Bad Request) >> Error url: "https://accionvegana.org/accio/QjMt92YuQnZvN3byNWat5Se0lmb11WbvNGajVGd6MHc0/_api/web/lists(guid'98495B1F-2BD1-4B09-80CA-4A4FE5EF82ED')", method: 'POST' WORK FINE. No issue. $(document).ready(function() { var projectCodeDropdownId = '#Project\\_x0020\\_Code\\_576bd655\\-c475\\-412d\\-bd61\\-8164571f6726\\_\\$LookupField'; var tasksCodeDropdownId = '#Tasks\\_09d67b50\\-12ae\\-4d0c\\-b3e0\\-b83d615baa8a\\_\\$LookupField'; var fallbackSelector = 'select[id*="Project_x0020_Code"]'; console.log('Script loaded'); // Debugging statement $(projectCodeDropdownId + ', ' + fallbackSelector).change(function() { console.log('Dropdown changed'); // Debugging statement var selectedProjectCode = $(this).val(); var selectedProjectText = $(this).find('option:selected').text(); console.log('Selected Project Code:', selectedProjectCode); // Debugging statement console.log('Selected Project Text:', selectedProjectText); // Debugging statement var taskPrefix = ''; // Determine the task prefix based on the project code text if (selectedProjectText.startsWith('BM')) { taskPrefix = 'A'; } else if (selectedProjectText.startswith('S')) { taskPrefix = 'S'; } console.log('Task Prefix:', taskPrefix); // Debugging statement // 動態生成 CAML 查詢 var camlQuery = ` <View> <Query> <Where> <Contains> <FieldRef Name='Title' /> <Value Type='Text'>${taskPrefix}</Value> </Contains> </Where> </Query> </View> `; // var listId = '98495B1F-2BD1-4B09-80CA-4A4FE5EF82ED'; // var listName = '執行項目維護'; // Filter tasks based on the determined prefix $.ajax({ url: "https://accionvegana.org/accio/QjMt92YuQnZvN3byNWat5Se0lmb11WbvNGajVGd6MHc0/_api/web/lists(guid'98495B1F-2BD1-4B09-80CA-4A4FE5EF82ED')/GetItems", method: 'POST', headers: { 'Accept': 'application/json;odata=verbose', 'contentType': 'application/json;odata=verbose', 'X-RequestDigest': $('#__REQUESTDIGEST').val() }, data: JSON.stringify({ query: { __metadata: { type: 'SP.CamlQuery' }, ViewXml: camlQuery } }), success: function(data) { console.log(data); // 檢查返回的資料結構 var filteredItems = data.d.results; var tasksDropdown = $('#Tasks\\_09d67b50\\-12ae\\-4d0c\\-b3e0\\-b83d615baa8a\\_\\$LookupField'); // 確保這裡的 ID 正確 tasksDropdown.empty(); $.each(filteredItems, function(index, task) { tasksDropdown.append('<option value="' + task.Title + '">' + task.Title + '</option>'); }); }, error: function(xhr, status, error) { console.error("Error fetching items: ", error); console.error("Status: ", status); console.error("Response: ", xhr.responseText); } }); }); }); http://win-0ggeu9kbm60:19027/_api/web/lists(guid'98495B1F-2BD1-4B09-80CA-4A4FE5EF82ED')/GetItems 400 (Bad Request)
