Accessing SharePoint Text file via VBA
I originally posted this query in the SharePoint community a while ago but didn't get a response so I'm posting here. I have a VBA macro in MS Project that needs to read a text file located on SharePoint. I have tried two different methods of opening the file (code below [https replaced with xxxxs as it wouldn't let me post]), both of which work fine on a local copy but fail when using SharePoint. The SharePoint I'm using is not an in-house system but is using Microsoft's SharePoint service offering. I have tried names using %20 instead of spaces and just using spaces with the same result. In my searches I have found multiple old references (10 years plus) about mapping drives or using UNC names. But mapping drives or using UNC are not possible with the SharePoint we use (I have tried). I have also found this - https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ms470176(v=office.14) that originally gave me some hope, but that is for VB and not VBA. I did consider OneDrive but the location of the file differs depending on whether the user has set up OneDrive sync or OneDrive shortcut from SharePoint. Plus, I need an option that will work regardless of a OneDrive connection being set up or not. Thanks in advance for any assistance. ======================================================= 'Const strLookup As String = "xxxxs://xxx.xxx.com/sites/xxxx/Shared%20Documents/xxxxx/xxxxx/My%20Text%20File.txt" ' Const strLookup As String = "\\xxx.xxx.com/sites\xxxx\Shared Documents\xxxx\xxxx\My Text File.txt" ' Const strLookup As String = "C:\Temp\My Text File.txt " intOutFileNum = FreeFile Open strLookup For Input As #intOutFileNum Line Input #intOutFileNum, strDataLine ' read in first line MsgBox (strDataLine) Close #intOutFileNum Const ForReading = 1, ForWriting = 2, ForAppending = 8 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objTextStream = objFileSystem.OpenTextFile(strLookup, ForReading, False, TristateFalse) strDataLine = objTextStream.ReadLine MsgBox (strDataLine) objTextStream.Close
Project Online REST API
Hi all. I'm currently working on an integration with Project Online using a low code/no code product (that is capable of doing HTTP requests) and Project Online REST API using OAUth client credentials (Machine to Machine authentication). I'm a complete rookie to Project Online, can someone please point me in the direction of detailed documentation that: - Identifies what kind of license is required to access Project Online REST API - Identifies what (if any) needs to be configured on Project Online - Identifies what (if any) needs to be configured on SharePoint - Identifies the steps to get the OAuth token to interact with Project Online REST API Thanks in advance VicenteProject Online REST API for Timesheets
About a year ago I attempted to create an app that could be used to update Timesheets in Project Online. I could not find an API endpoint that would let me update Timesheets entries for a particular project and for a particular user during a defined date range. Another project has surfaced with similar goals. Is this now available today? If so can anyone point me to the endpoint with examples specifically for updating user Timesheets please? Thank you in advance for your help, Audrie
Accessing Project REST API throws error: Exception of type 'Microsoft.IdentityModel.Tokens.AudienceU
I am trying to access the Project Online REST API http://ServerName/ProjectServerName/_api/ProjectData/Projects More precisely my query is the following "https://" + sharepoint_url + "/sites/pwa/_api/ProjectServer/Projects('" + project_id + "')/Assignments('" + project_task_id + "')/Resource" Now what I am challenges with, is the right authentication. I am trying to impersonate two natural users, the application is registered in AAD and I also get a token. But I get either one of the two errors {"error_description":"Unsupported security token."} or {"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."} I am happy to provide further details, but I am a bit lost in the API jungle from Microsoft. Unfortunately it appears that Graph API does not (yet?) support Project Online. I was already following those guides here: https://docs.microsoft.com/de-de/azure/active-directory/develop/v2-oauth2-client-creds-grant-flow http://pratapreddypilaka.blogspot.com/2018/05/sharepoint-online-authentication-for.html No positive result. I do get tokens, but the errors remain.Project Online Task notes update using Rest Api
Hello, I am able to create a new task and then I can give the value for notes field which works fine but when I try to update the same "Notes " field then the update doesnt happen using the rest api I am using below rest api with Patch method _api/ProjectServer/Projects(<project_id>)/Draft/Tasks(<Task_id>) Body: {'Notes': value}Problem: Project Accelerator Power app "Tasks" tab connected to P4TW UI
Hello, I have been dealing with an issue for over a month now where the embedded Web Control on the Power App that compliments project 4 the web will not expand even to the point where I can see one task in a project schedule. It is making the app very frustrating to use. Does anyone out there have experience with this type of issue or are you facing the same problem? As you can see in the photo you can barely see one task in a project. I have tried the new and the classic designer to change the size on this box and I cannot. Specifically, it seems like an issue with the resizing of the PexWebControl in the project form under the tasks tab. The control does not even load in the designer. There is no way to resize it! PexWebControl is "control to host the modern project UI inside project form". I have opened a ticket with Microsoft and it has not been helpful. I have been bounced around and no one seems to know anything about this issue. This is also probably due to the fact P4TW is very new and not many people are allocated to it maybe. Either way I need help! Please community help me! 🙂
Connecting Microsoft Project with Python
Hello, I'm stuck in the development of a system that automates Microsoft Project, I hope you can give me a clue where to go from here. In the company where I work we need to automate the creation and modification of tasks in Microsoft Project. We use Project Web App (PWA) in SharePoint. The thing is that due to technical requirements our system is based on Python so it would be great to be able to connect with Python to MS Project. I did it, I connect to MS Project Professional using PyWin32 and I managed to create projects, upload them to PWA, and create/modify the 100.000 tasks. Where is the problem? It is extremely slow and takes many hours to create/modify all the tasks, which makes it unfeasible and I need a faster solution. I think it is because I have connected using win32com and this slows down the work. I also think that VBA for Microsoft Project is not very fast. Does anyone know of a faster way to get me to connect to Project? Maybe directly accessing PWA from Python? But I haven't managed to do that. I would have to create my own Python API? Any other alternative you can think of would be appreciated. Thank you very much and hopefully we can do it. DarÃo. Pipeline TD
