We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Infogix Reports on Server to Database

Comments

11 comments

  • Avatar
    Matthew Kennedy

    Hi Adam,

    Where these reports store is configurable within the IA.properties. Per our "Infogix Properties Guide" PDF :

    Please note, any report still on the server will not migrate to the database. This will be a change moving forward only. The reports already created will remain on the file system ( or database ), until retention kicks in.

    Matthew Kennedy

    0
    Comment actions Permalink
  • Avatar
    Adam Walker

    Matt,

    Currently, this is what is in our IA properties files in dev.

    # File Store Configuration
    # FileSystem or Database
    FILESTORE_BACKEND=FileSystem
    ENABLE_FILESTORE_ENCRYPTION=false
    ENABLE_FILESTORE_COMPRESSION=false

    I understand I would have to make the two ENABLE lines to true, What would I put where "FileSystem" is located?

    Thanks,

    Adam

     

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Based on the aim the team is shooting for, this value would be defined as "Database"

    Matthew Kennedy

    0
    Comment actions Permalink
  • Avatar
    Adam Walker

    Also, where would I see on the database side if I wanted to validate that it wrote it to the database?

    0
    Comment actions Permalink
  • Avatar
    Adam Walker

    Matt,

    Once I have the IA properties file changed and applied to the server, where will the report write to on the server?

    Adam

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Adam,

    If the value is set to "FileSystem" it will write to the same directory it currently is pointing to on the OS. If "Database" is set as the value, this will write to the database table for the control. Navigating to Assure's "admin console" > "dynamic tables" will allow better insight on which table corresponds with which report due to the right-side column labeled "purpose".

    Matthew Kennedy

    0
    Comment actions Permalink
  • Avatar
    Adam Walker

    Is there any way to write a SQL command to validate that the report wrote to the database?  If so what would that SQL command look like?

    0
    Comment actions Permalink
  • Avatar
    Adam Walker

    Matt,

    Where are on the database is it writing the reports to?

    Adam

     

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Adam,

    The table name itself would entirely be dependent on the report type / control name. When possible, please open a support case so we may discuss further. I am happy to walk through this with you over a 'zoom' call.

    Matthew Kennedy

    0
    Comment actions Permalink
  • Avatar
    Adam Walker

    Matt,

    Two more question:

    So the file storage configuration properties is for just "control reports", correct? 

    So are the "user report" being written to the database already and not to the server?

    Adam

     

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Adam,

    User reports are always stored within the database, using a dynamic table per user report. The "FILESTORE_BACKEND" value mentioned above has no impact on this.

    Matthew Kennedy

    0
    Comment actions Permalink

Please sign in to leave a comment.