Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only

  • 1.  Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/07/12 06:25 PM

    Originally posted by: outlookeye


    I installed ILOG CPLEX optimization studio 12.4 under ubuntu system, and try to run a model. This model can be executed under OPL 6.3 without errors. But on 12.4 version, it has come errors.
    The error: Processing failed.
    Sheet data not supported on this platform.

    At first, I thought this error is due to the .dat file I wrote. So I try to run examples that OPL provided, the same errors appear.
    I don't know why. Is this the problem with configuration? Or the Linux version ILOG CPLEX OPL doesn't support read in data sheet from .xls file?

    (I remote to a ubuntu server to use this optimization studio software)
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/07/12 09:57 PM

    Originally posted by: SystemAdmin


    Reading data from Microsoft Excel spreadsheet is supported on Microsoft Windows only, not on Linux.
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/07/12 10:51 PM

    Originally posted by: outlookeye


    Thank you for your reply.
    I found that when read in .mdb file, it also has such errors. So the linux does not support .mdb database file either?

    In this case, how to read in the data needed in these files? Is that I need to write these data in a correct form in .dat file directly?

    Thank you.
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 4.  Re: Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/09/12 04:55 PM

    Originally posted by: outlookeye


    The .xls file can be opened/write under Ubuntu system, but this does not indicate that .xls data sheet is supported in ILOG CPLEX optimization studio 12.4-Linux. Is that right?

    Thanks
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 5.  Re: Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/09/12 05:30 PM

    Originally posted by: SystemAdmin


    that's correct. Even if you may be able to work with your Excel file on Linux, OPL will not read/write data from/to Excel spreadsheet on Linux.
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 6.  Re: Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/09/12 05:33 PM

    Originally posted by: outlookeye


    Thanks so much.

    Is there a way for Linux OPL to read in external data? I search the IDE OPL tutorial of version 12.4, but found nothing.

    Thanks.
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 7.  Re: Errors when running a .mod on ILOG CPLEX optimization studio 12.4-Linux

    Posted 10/10/12 05:32 AM

    Originally posted by: SystemAdmin


    Dear OPL-team,

    wouldn't that be a valuable new feature for OPL?
    There is the Java Excel API (http://jexcelapi.sourceforge.net/) that might be used !?
    We are as well often confronted with the problem of handling Excel-files under Linux. Customers simply love to work with Excel...

    Best regards
    Norbert
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


Related Content