Forum Replies Created

Viewing 15 posts - 1 through 15 (of 49 total)
  • Author
    Posts

  • robf
    Participant

    Hello Hristo,
    Our users typically export data in excel format for further analysis. The work-around poses other problems for our users as it’s not intuitive for them and requires more work on their side to merge files in order to analyze.

    Rob


    robf
    Participant

    Hi Hristo,

    I see that this post is three years old and this is exactly what I am looking for.

    So, the question is – when a large dataset is to be exported, e.g. 10k records, the export hook is fired off and the UI seemingly hangs until the request is completed on server side. I’ve had users think the app/browser was frozen since it took 7-10 seconds (or more) to complete request – and this is with the export.php program running on same box.

    $(grid).jqxGrid('exportdata', type, fileName, exportHeader, rows, exportHidden, serverUrl);

    There does not seem to be a way to make an AJAX-like call with a callback to prevent the UI from hanging and also display a progress dialog.

    Has anything been done for this callback feature or can you offer a work-around?

    Thanks.
    Rob


    robf
    Participant

    Hello,
    Please disregard and mark as closed. It is working as expected by looping through i.jqx.filters
    Thanks.
    Rob


    robf
    Participant

    Hello,
    Please help me understand how to apply a previously saved filter. I do not understand the example.

    I save a copy of the current filter using ‘getfilterinformation’ and successfully stash the following array:

    {…}]
    0:
    datafield: "currentState"
    displayfield: "currentState"
    filter: i.jqx.filter {operator: "and", evaluate: ƒ, getfilterscount: ƒ, setoperatorsbyfiltertype: ƒ, getoperatorsbyfiltertype: ƒ, …}
    filtercolumn: "currentState"
    filtercolumntext: "Current State"

    1) is there a way to simply apply the whole saved state as the filter? seems you cannot and must iterate.

    So, I get the first value:

    {filter: i.jqx.filter, datafield: "currentState", displayfield: "currentState", filtercolumn: "currentState", filtercolumntext: "Current State"}
    datafield: "currentState"
    displayfield: "currentState"
    filter: i.jqx.filter {operator: "and", evaluate: ƒ, getfilterscount: ƒ, setoperatorsbyfiltertype: ƒ, getoperatorsbyfiltertype: ƒ, …}
    filtercolumn: "currentState"
    filtercolumntext: "Current State"

    It seems that filter is already a filterGroup – i.e. i.jqx.filter and datafield “currentState”

    I try to apply the filter using

    $('#jqxgrid').jqxGrid('addfilter', 'currentState', filtergroup);
    $("#jqxgrid").jqxGrid('applyfilters');

    The filter never gets applied.

    I have looked at the examples and still cannot determine what I am missing.

    Can you please assist.

    Thank you.
    Rob

    in reply to: Smart Elements Smart Elements #111666

    robf
    Participant

    Excellent! Thanks, Peter!


    robf
    Participant

    This still continues to haunt me when a window resize or splitter resize occurs. The suggested solution by nigel does not work 100% of the time. Window resizing and splitter resize will still render 1) half-drawn grids OR 2) squished columns OR 3) missing toolbar buttons.

    The only way I can get a full redraw is to perform full ‘render’ and then all is reset like groupings. The screen shot I provided before is still prevalent even with production build 9.0. https://ibb.co/vQQTKJ1

    Is there a ticket out there for this?

    Please assist.
    Thanks.
    Rob

    in reply to: Where are the demo files Where are the demo files #111566

    robf
    Participant

    Oops! My bad. I was looking for demos in the source folder not the production folder. Thanks!

    in reply to: Get rendered row Get rendered row #111551

    robf
    Participant

    One more really important question regarding something that seems VERY useful. When the grid has ADAPTIVE mode on, and you click the ellipsis at the end of the row, the form that pops up is EXACTLY the data representation I am looking for! I.E. it displays the row as you see it in the grid. Is there a way to hook into that same logic that you use for creating that form? That would be INCREDIBLY USEFUL!

    Thanks.
    Rob

    in reply to: Get rendered row Get rendered row #111550

    robf
    Participant

    Hello Martin,

    Is there a way to get this to render using the cellsformat – e.g. “cellsformat: f2” and produce the same rendered result – e.g. 1,254.99

    Or do I also need to have a cellrender function?

    Thank you
    Rob


    robf
    Participant

    Thanks, Hristo but that doesn’t really solve the problem because the list widget is SELECTING an item as opposed to simply performing an action like a bootstrap dropdown button (https://getbootstrap.com/docs/4.0/components/dropdowns/). I do not think jqwidgets has the equivalent functionality.

    Appreciate your time on this,
    Rob


    robf
    Participant

    Hello,
    I too am trying to use this new feature. I tried to follow example and use type XLSX. I get
    a.jqx.dataAdapter.DataExporter is not a constructor

    I have

    <script type="text/javascript" src="../jqwidgets/jqxdata.js"></script>
    <script type="text/javascript" src="../jqwidgets/jqxdata.export.js"></script> 
    <script type="text/javascript" src="../jqwidgets/jqxgrid.export.js"></script>
    <script type="text/javascript" src="../jqwidgets/jqxexport.js"></script> 

    Also running dataexport.php on my own server. Notice that mimemtype xlsx is not there.

    Ideas how to get this to work?

    Thanks.
    Rob

    in reply to: host your export php host your export php #108309

    robf
    Participant

    Hi
    Seems like I am able to host the datexport, but FYI you have a typo in code for CSV files. I changed from CVS to CSV for it to work

    $mimeTypes = array(‘xls’ => ‘application/vnd.ms-excel’,
    ‘xml’ => ‘application/xml’,
    ‘html’ => ‘text/html’,
    ‘cvs’ => ‘text/plain’,
    ‘tsv’ => ‘text/plain’, ‘json’ => ‘text/plain’, ‘array’ => ‘text/plain’);

    • This reply was modified 5 months ago by  robf.
    in reply to: host your export php host your export php #108092

    robf
    Participant

    Hello,
    I just purchased developer license. I do not understand how I host the exporter. Where is dataexport.php in production download of JQW 9.0. Where are exportsetttings?

    Thanks.
    Rob

    in reply to: Filter Row Filter Row #108042

    robf
    Participant

    Hello,
    Still wondering if this issue has been resolved? Still appears to be present. Can you please offer a work-around?
    It’s very difficult to offer filterrow option and grouping when users find error almost immediately.
    Thanks.
    Rob

    in reply to: Filter Row Filter Row #107153

    robf
    Participant

    Hello Todor,
    I noticed that a new version of of jqwidgets was released – 8.3.2 but still experience this issue in my app. Has this been addressed in any way?

    I have updated my fiddle to show the behavior which appears to occur when there are more than eight(8) columns present.
    https://jsfiddle.net/rfossella/0a6ufg5b/72/

    Please let me know.

    Thanks.
    Rob

Viewing 15 posts - 1 through 15 (of 49 total)