Showing Files (Excel ,PDF or CSV) in Grid from Infotable/Datatable.

[VS_9760165]

Hi ,

I am looking for File reading from Grid . i have table like below , when i click on "View" the File should open from File Repository which is on Remote server. 

1. how to store file path from repository in Infotable/datatable.

2.How can i do it in Grid Advanced?

If you would give the steps to achieve it ..would be better

Thanks

[PaiChung]

I believe there are extensions in the Marketplace that can read CSV and even excel files.

If you are using the Thingworx agent to manage your remote repository or if your files are in the Thingworx filerepository, then there are services that can get you the directory structure and file listings.

And I think mabye even ootb a file repository has a csv load type service available (else use the extension)

[VS_9760165]

Hi @PaiChung ,

Thanks for Reply , I would like to have steps to achieve the Requirement. and if i use Hyperlink in Grid by clicking on it ..file should be read. what should i do if my file resides at Remote Server or Might be in Local Directory.

should i create a thing using FileRepository..?

Should i create a thing using RemoteThing?

Thanks

[anarwal · Accepted solution]

@VS_9760165 , you can use File repository if file is in local thingworx directory . Remote thing with File transfer and tunneling is helpful when you have a remote thingworx agent runing on that machine .

Or you can use html text area if you want to show the content of the file using rest call and process the file on thingworx local service