Skip to main content
5-Regular Member
July 5, 2016
Solved

I am getting access denied error while Reading CSV file

  • July 5, 2016
  • 1 reply
  • 10303 views

Hi,

I am getting access denied error while reading CSV file.

Steps Perform to reach this,

  1. Created a Thing
  2. Created a DataShape
  3. Imported CSV extension
  4. Click on Magnifier
  5. Go to services
  6. Click on "ReadCSVFile --> Test"
  7. Copied CSV file to "ThingworxStorage\repository\GetCSVDetails"
  8. Fill below items
    1. fileRepository
    2. dataShape
  9. Click on "Execute Service"

After that I am getting Error as

"Unable To Open [/] in [GetCSVDetails] : \ThingworxStorage\repository\GetCSVDetails (Access is denied)"

Attached is the screen shot.

Regards,

Mahesh Lohokare

Best answer by nkhose

Firstly you check the csv file resides in the repository thing you created using the service  GetFileListing to male sure

Then to test ReadCsvFile you need to set correct path .. i think you are giving the whole path as like

repository/Repositorything/store  instead you give path  /store/Book6.csv and give it a go !


Hope this helps !

1 reply

nkhose1-VisitorAnswer
1-Visitor
July 5, 2016

Firstly you check the csv file resides in the repository thing you created using the service  GetFileListing to male sure

Then to test ReadCsvFile you need to set correct path .. i think you are giving the whole path as like

repository/Repositorything/store  instead you give path  /store/Book6.csv and give it a go !


Hope this helps !

mlohokare5-Regular MemberAuthor
5-Regular Member
July 5, 2016

Hi Nilesh,

Thanks.

Now I am able to read my csv file.

Regards,

Mahesh

1-Visitor
September 20, 2016

Hi Mahesh,

Could you load the content to grid???

Regards,

Hariprasadh