Working with XML files

Comments

3 comments

  • Avatar
    Mary DeAngelo

    I’m trying to bring an xml document into the elasticube and I am receiving some errors. Is this something you can help me with?
    I was using the above documentation  and was using an xml directory.
    https://support.sisense.com/hc/en-us/community/posts/115002913547-Working-with-XML-files
    C:\>cd prebuildPlugins
    Directory of C:\prebuildPlugins
    C:\prebuildPlugins>python.exe Xml2MongoDB.py

    Connecting to MongoDB, prepping the database

    Traceback (most recent call last):
    File "Xml2MongoDB.py", line 113, in <module>
    main()
    File "Xml2MongoDB.py", line 69, in main
    collection.drop()
    File "C:\Python27\lib\site-packages\pymongo\collection.py", line 1062, in drop
    self.__database.drop_collection(self.__name, session=session)
    File "C:\Python27\lib\site-packages\pymongo\database.py", line 657, in drop_collection
    session=session)
    File "C:\Python27\lib\site-packages\pymongo\database.py", line 439, in _command
    client=self.__client)
    File "C:\Python27\lib\site-packages\pymongo\pool.py", line 517, in command
    collation=collation)
    File "C:\Python27\lib\site-packages\pymongo\network.py", line 125, in command
    parse_write_concern_error=parse_write_concern_error)
    File "C:\Python27\lib\site-packages\pymongo\helpers.py", line 145, in _check_command_response
    raise OperationFailure(msg % errmsg, code, response)
    pymongo.errors.OperationFailure: not authorized on ExternalData to execute command { drop: "PersonData", writeConcern: {} }

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Mary,

    this script was developed on Sisense prior to 6.7. In 6.7 Sisense mongoDB, which is used here to store data, requires a login in order to access it. You would need to modify this scripts in order to accoutn for that login.

    0
    Comment actions Permalink
  • Avatar
    Aaron Vickery

    The Python file link says I need permission to download it from the Google Drive.

    0
    Comment actions Permalink

Please sign in to leave a comment.