Announcement

Collapse
No announcement yet.

ScriptCase v8.0.044 (05-07-2015 20:52)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ScriptCase v8.0.044 (05-07-2015 20:52)

    New functionalities

    - Added PHPExcel (Need to update production environment)
    (For users that use the separate production environment for the publications, you need to update it. Through our website you can download. For the rest, just leave marked the "Update production environment" during automatic update ScriptCase.)
    - Added new project theme.
    - Added support for border radius in content of project themes.


    Specific correction

    - Fixed problem in generating XLSX files in the Grid application.
    - Fixed problem in the project version history view.


    Bug

    - Fixed problem in the conversion of Access databases using ADO connection.
    - Fixed problem in the lookup preview at charts.
    - Fixed problem in the conversion of Access databases to SQL Server.
    - Fixed problem in the application navigation when it has a multiple line field.
    - Fixed the CHARSET problem when using macro sc_exec_sql with specific connection.
    - Fixed problem in the changes validation in the Report PDF events.
    - Fixed problem when importing files named with special characters in document fields (File Name) in the form editable grid with Oracle.
    Last edited by John L. Santos; 05-12-2015, 10:46 AM. Reason: Need to update production environment
    Best Regards,
    John L. Santos

    Bug Tracker Team
    NetMake - IT Solutions

  • #2
    - Added PHPExcel

    And how to use it? or is added just for exportation?
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      http://openxmldeveloper.org/blog/b/o...5/07/4606.aspx has some nice info...
      Of course you could (if running windows) instead of using phpexcel simply use an odbc connection to your spreadsheet with your excel spreadsheet or use COM (only if excel is installed). But those are the simple alternatives.

      Comment


      • #4
        Hi,

        This class PHPExcel is great, there is any way to update also third party class for swiftmailer, i found many features on their changelog.

        Great work!

        Comment


        • #5
          how to update "update production environment"

          is the _lib folder?

          Comment


          • #6
            Hi,

            After deploy is finished you must click on "Click to Download the common libraries" and there is a zip with all libraries updated.

            Comment


            • #7
              Originally posted by Giu View Post
              - Added PHPExcel

              And how to use it? or is added just for exportation?

              Hello,

              Unfortunately it is just for export. We had to upgrade our library in export EXCEL to fix some problems with images export images in XLSX files.
              As you have seen the documentation, feel at ease to the report as a suggestion and we will examine the case for implementations.

              It is also worth remembering that you can use the sc_include_lib macro.
              http://www.scriptcase.net/docs/en_us...sc_include_lib

              Example in the Blank application:
              PHP Code:
              // Using ScriptCase's Macro
              sc_include_lib ("excel");

              // Create new PHPExcel object
              echo date('H:i:s') . " - Create new PHPExcel object<br />";
              $objPHPExcel = new PHPExcel();

              // Set properties
              echo date('H:i:s') . " - Set properties<br />";
              $objPHPExcel->getProperties()->setCreator("ScriptCase");
              $objPHPExcel->getProperties()->setLastModifiedBy("ScriptCase");
              $objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
              $objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
              $objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");


              // Add some data
              echo date('H:i:s') . " - Add some data<br />";
              $objPHPExcel->setActiveSheetIndex(0);
              $objPHPExcel->getActiveSheet()->SetCellValue('A1''ScriptCase');
              $objPHPExcel->getActiveSheet()->SetCellValue('B1''Example');
              $objPHPExcel->getActiveSheet()->SetCellValue('A2''Hello');
              $objPHPExcel->getActiveSheet()->SetCellValue('B2''World!');

              // Rename sheet
              echo date('H:i:s') . " - Rename sheet<br />";
              $objPHPExcel->getActiveSheet()->setTitle('Simple');

                      
              // Save Excel 2007 file
              echo date('H:i:s') . " - Write to Excel 2007 format<br />";
              $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
              $objWriter->save(str_replace('.php''.xlsx'__FILE__));

              // Echo done
              echo date('H:i:s') . " - Done writing file.<br />";
              echo 
              "<a href='index.xlsx'>Download file</a>"
              Last edited by John L. Santos; 05-08-2015, 02:31 PM. Reason: Using sc_include_lib macro
              Best Regards,
              John L. Santos

              Bug Tracker Team
              NetMake - IT Solutions

              Comment

              Working...
              X