cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

show data from a text file - is it possible?

Jump to solution

Hello

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

 

0 Kudos
Reply
8 Replies
Workflow Hero

Re: show data from a text file - is it possible?

Jump 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

0 Kudos
Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

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??

Cheers,

Rick

0 Kudos
Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

in my experience a simple c# app will do the trick to import data to sharepoint and it will be way faster

0 Kudos
Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

Hi

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.

0 Kudos
Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

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.

Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

Hi Bim BimiPatti Naccarati

 

 

were you able to resolve your problem?

if so, could you select an answer that helped you and mark it 'correct answer'?

 

 

0 Kudos
Reply
Workflow Hero

Re: show data from a text file - is it possible?

Jump to solution

Hello Marian

my last solution was to use the extracted .txt file and embed it on Sharepoint.

This work ok at minute .... thanks

Reply