LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Data viewer Excel

  • 1.  Data viewer Excel

    Employee
    Posted 03-14-2013 03:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ThomasT

    Hi Guys.

    Having upgrading to 4.6 i also want to use the new functionality of viewing data in excel directly from the pin.

    I think i have configured it correctly, but it still doesnt work.

    Please help?

    See the attached.

    Error2.jpgSetting.jpg
    Attachments:
    Error 2.bmp
    Setting.bmp


  • 2.  RE: Data viewer Excel

    Employee
    Posted 03-15-2013 13:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aorlovsky

    The steps to fix this problem are outlined here: http://community.lavastorm.com/showt...l-Data-Viewers.

    Please note this has been fixed in 4.6.0.1.


  • 3.  RE: Data viewer Excel

    Employee
    Posted 03-20-2013 07:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ThomasT

    It is (almost) working now.
    However, in Scandinavia the system (and excel) setting uses semicolon as field separator as default.
    Therefore, when i use Excel as viewer, excel starts and all fields ends up in the first cell with a comma between them..


  • 4.  RE: Data viewer Excel

    Employee
    Posted 03-20-2013 09:16

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aorlovsky

    Here's how to avoid this problem: http://community.lavastorm.com/showt...=3689#post3689


  • 5.  RE: Data viewer Excel

    Employee
    Posted 03-21-2013 03:05

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ThomasT

    Great, thanks!

    It works now..


  • 6.  RE: Data viewer Excel

    Employee
    Posted 03-21-2013 08:13

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aorlovsky

    Var s� god!


  • 7.  RE: Data viewer Excel

    Employee
    Posted 06-05-2013 13:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Delta_V

    I'm also having this issue in 4.6, I added the entries to the bre.ini file but I still get the "DataViewer failed to convert output format." I uninstalled LAE 4.6, deleted the folders and registry entries and reinstalled but its still producing the error. I'm using Excel 2007, is that version supported for the external viewer functionality?


  • 8.  RE: Data viewer Excel

    Employee
    Posted 06-05-2013 13:52

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aorlovsky

    Make sure BRE is not running when you make your changes to the bre.ini. Save the changes to bre.ini, then edit the bre.ini file to verify that it contains the csvConverter stuff you just entered. Double check the path name for the excel.exe. Now restart BRE and try it again.


  • 9.  RE: Data viewer Excel

    Employee
    Posted 06-07-2013 10:04

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Delta_V

    Okay, I'm noticing something odd with this. Let me step thru this and see if any of this makes sense.

    Just FYI, Running Windows 7, LAE is installed to C:\Program Files(x86)\Lavastorm\LAE 4.6

    1. Verify that BRE is shut down
    2. Open the bre.ini file located in C:\Users\jsp052651\AppData\Roaming\Lavastorm
    3. Add the following to the end of the file:

    BrdConverters ManagedArray [
GenericRecord {
Name "qvx"
Converter "qvxConverter.exe"
}
GenericRecord {
Name "csv"
Converter "csvConverter.exe"
}
]

    4. Close and save bre.ini then reopen to verify changes were saved.
    5. Open BRE and verify that my path to excel is correct, I have attached a screenshot of my setup in preferences. BRE_Preferences.jpg
    6. I attempt to view the records using the external viewer but I still get a "Data Viewer failed to convert output format" error message
    7. However, when I close BRE and go check the BRE.INI file again, the lines I added above are no longer there. Not sure what is going on but it looks like my bre.ini is getting overwritten when I open BRE.


  • 10.  RE: Data viewer Excel

    Employee
    Posted 06-07-2013 10:14

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aorlovsky

    I think you're doing everything right, except for where you put the BrdConverters ManagedArray. Make sure what you have in the code snippet above is before the last } at the end of the ini file. Don't add an extra }, put that stuff before the one that is there.

    In order to avoid syntax details like that, I usually put that stuff before the ServerFarms ManagedArray.


  • 11.  RE: Data viewer Excel

    Employee
    Posted 06-07-2013 11:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Delta_V

    Still not working but it looks like the additional syntax is in the ini file itself, its just in the middle of the file instead of the end. I've attached my ini file for reference.

    When I select the external data viewer in LAE a command line window is popping up quickly and then disappearing and then giving me the "Data Viewer failed to convert output" error. Could this be some sort or windows administrative/permissions issue with the Program Files folder not letting it execute the csvConverter.exe properly? I'm thinking of trying to install LAE at the root of C and see if that makes a difference.

    bre.ini.txt


  • 12.  RE: Data viewer Excel

    Employee
    Posted 06-10-2013 09:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: aorlovsky

    The bre.ini looks fine. Are you able to view data via the BrdViewer or the external data viewer on a plain, unedited Static Data node? I'm wondering if it's the data or something about your setup.


  • 13.  RE: Data viewer Excel

    Employee
    Posted 06-18-2013 08:38

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Delta_V

    No, I tried viewing the output of a static data node with the external viewer and I still get the "Data viewer failed to convert to output format"