I am aware that you can create a workflow to pull out the information from an imported spreadsheet or a custom list.
However, would that also be possible from a text file ?!
my colleague used SAP to export a txt file (to our shared drive) for all First Aid users being on the site.
the file looks like this...
Now I been asked to show these users on our Intranet page (SharePoint 2013).
Is there a method to do it via a workflow somehow .. or would it be just a case of an iframe?!
Though only the names and possibly the status is required
Solved! Go to Solution.
wouldn't it be a solution to use sharepoint's document library as a export files store?
users can map document library to a local drive/folder and work with it like with local filesystem
Hi Bim Bimi,
If I were you, I would use PowerShell (Server) or PnP-PowerShell (Client) (https://github.com/SharePoint/PnP-PowerShell) to process the SAP exported text file and add the information you want to a SharePoint list (which is shown on a page on the intranet). What?? No Nintex??
as far as I know, the SAP uses an FTP to export that txt file to our shared drive and we tried to make it store the file directly into the sharepoint file directory but does not work as FTP is blocked (cannot be unblocked for sec reasons).
Then what I done so far is, used the Content Editor webpart and pasted an embedded html code that points to the files stored in our shared drive e.g F:\SAPexport\FirstAider.txt
This at least shows the data as the actual txt file.
Though ideally wanted to show only names and the status but yeh it would take a lot of scripting, which I don't know.
thanks for the suggestions but my scripting and PowerShell is not something I been doing for living
stuff like embedded html code within a content editor webpart pointing to the file in shared folder - seems to be ok
I assume the share is published from some windows host.
then I would say it doesn't matter.
you can map F: drive to a UNC path to SP's doc library as a network share.
or you can even create symlink/junction SAPExport folder to point to UNC path to SP's doc library.
SAP/FTP will not care where file is physically being stored.