Skip to main content
V
VS_97601651-Visitor
1-Visitor
January 4, 2021
Solved

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

  • January 4, 2021
  • 1 reply
  • 1746 views

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. 

VS_9760165_0-1609764548588.png

 

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

Best answer by anarwal

@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

1 reply

P
PaiChung22-Sapphire I
22-Sapphire I
January 4, 2021

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)

    V
    VS_97601651-VisitorAuthor
    1-Visitor
    January 5, 2021

    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

    A
    anarwal5-Regular MemberAnswer
    5-Regular Member
    January 5, 2021

    @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

    Terms & ConditionsAccessibility statement