KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


2 posters

    Long edit excel file.

    avatar
    Bobi


    Posts : 29
    Points : 2099
    Join date : 2018-10-01

    Long edit excel file. Empty Long edit excel file.

    Post by Bobi Tue Apr 30, 2019 7:49 pm

    Hi.
    I insert the value into the finished excel file. The file contains 13 data sheets.
    Inserting 123 values ​​on any sheet takes 120 seconds. Why so long? Perhaps we need to change the kofax kapow settings?

    If you leave only 1 sheet, then the data is inserted in a second.
    Does anyone have experience with xlsx files?
    file size 1,6Mb
    jking
    jking


    Posts : 103
    Points : 3852
    Join date : 2014-03-01
    Location : USA

    Long edit excel file. Empty Re: Long edit excel file.

    Post by jking Tue Apr 30, 2019 7:57 pm

    Kapow holds the entire Spreadsheet in memory.  A spreadsheet with 1 Tab takes less memory than a spreadsheet with 13 tabs.
    From Kofax Kapow Reference Document:


    • Excel modification is memory intensive and might not work on large Excel documents. The limit may depend on many factors, for example, available memory on a design platform or a server platform, how many modifications the robot does, etc. Therefore it is not possible to give precise criteria for when an Excel document is too large for Kapow to handle. 


    Having said that, you can adjust your RAM allocation which may increase results:

    Change the RAM Allocation
    As installed, each Kofax RPA application is configured with a maximum amount of RAM that it may use.
    This amount usually is plenty for ordinary work, but if you run many robots in parallel on RoboServer, or if
    some robots use much RAM, it may be necessary to increase the allocation.
    You can change the allocation for any of the applications by editing its .conf file, found in the bin
    subfolder of the installation folder.
    For RoboServer, the file to edit is: bin/RoboServer.conf.
    For Design Studio, the file to edit is: bin/DesignStudio.conf.
    To edit the file, perform the following steps.
    1. Open the corresponding .conf file in a text editor.
    2. Find the line containing the wrapper.java.maxmemory parameter.
    3. Un-comment the line (remove the leading #) and edit its value.

    For example, to permit a roboserver to use up to 4GB of RAM, enter the following:
    wrapper.java.maxmemory=4096.
    Note If the .conf file does not contain the wrapper.java.maxmemory line, add the whole line to
    the file.
    An allocation this high is possible only on the 64-bit version of Kofax RPA. Also, the .conf file can
    be edited only by the user who installed Kofax RPA, such as the Windows administrator.
    avatar
    Bobi


    Posts : 29
    Points : 2099
    Join date : 2018-10-01

    Long edit excel file. Empty Re: Long edit excel file.

    Post by Bobi Mon May 06, 2019 1:21 pm


    I tried to change the parameter wrapper.java.maxmemory = 4096 (or hier) but this did not work.

    Sponsored content


    Long edit excel file. Empty Re: Long edit excel file.

    Post by Sponsored content


      Current date/time is Sun Apr 28, 2024 5:52 pm