[DeployDuckParticipant]

discussion closed.

[DeployDuckParticipant]

Hello, why am I paying for support?
One month ago – still no answer – a shame.

[DeployDuckParticipant]

Not interested in an answer any more.

close this.

[DeployDuckParticipant]

I did the job of providing you with all the details necessary for you to answer the question. Since I haven’t received an answer from you after 2 weeks, I have now turned to one of your competitors. They answered immediately.

Too bad. jqWidgets controls are good – but worthless without functioning customer service.

[DeployDuckParticipant]

Hello Peter,
sorry to hear this. Its absolutly impossible for me, to provide you with a sample.
Due to a confidentiality declaration, it is unfortunately not possible for me to send you an extract from the program. I have to see if I can find the time in the next few months or next year to build something similar for you as an example. I will not be able to do so in the next few months due to lack of time.

I have already used the exact same export function in several hundred tables without any problems. The table in question differs only in the number of columns and in no other way.
I therefore assume that your new export view will not be able to cope with the sheer amount of columns. The affected table currently has exactly 2358 columns with 33 rows. Columns of the type text, date, number (int and float), bool are included. Your exportview function exports this table to csv, tsv, json without errors. The older function exportdata also exports to xls !, csv, tsv, json without errors. Only the export to xlsx fails and only exports 1526 columns.

I use:
$("#MyGridID").jqxGrid('exportview', 'xlsx', hev.Spk(ExportFileName));
to export the data.

As a datasource I use:

var source = { 
            datatype: 'array',
            datafields: [
                { name: 'Pseudonym',           type: 'string' }, 
                { name: 'Group',               type: 'int' },
                { name: 'RegisterAt',          type: 'date' },
                ...
           ],
            id: 'ID',
            localdata: daten
        
        };
        var dataAdapter = new $.jqx.dataAdapter(source);

There were:
1977 * type ‘int’
267 * type: ‘string’
21 * type: ‘float’
93 * type: ‘date’

This is my Grid definition:

$("#GridID").jqxGrid({
            width: '100%', 
            autoheight: true,
            altrows: true,
            columnsresize: true,
            filterable: true,             
            showfilterrow: true,
            groupable: true,               
            showgroupmenuitems: true,               
            pageable: true,                 
            pagesize: [15,20,25], 
            pagesizeoptions: PageSizeSet.Pagesizeoptions,
            localization: GermanTranslationObject,     
            theme: MyTheme,
            source: dataAdapter,     
            columns:  SetColumns_ausw()  
        }); 

And my column definitions look like:

const SetColumns_omp_ausw_export = function(){
    let columns = [
        //Nutzer
        { text: 'Pseudonym',	    datafield: 'Pseudonym',	    columntype: 'textbox',	     		   width: 200 },
        { text: 'Group',            datafield: 'Group',	            columntype: 'textbox',	     		   width: 100 },
        { text: 'RegisterAt',       datafield: 'RegisterAt',	    columntype: 'textbox', filtertype: 'range', cellsformat: 'dd.MM.yyyy HH:mm',width: 180 },

        { text: 'EXAMPLE',	    datafield: 'EXAMPLE',	    columntype: 'numberinput',      cellsformat: 'f1',		    width: 100 },
        ...
     ];
    return columns;
};

To find the error, I compared the xlsx export column by column with the xls export in Excel. Both exports appear to be the same up to column AFZ / 858.

Column 858 is of type MySQL TINY(1) / bool and contains the values 0, 1 and null.
datadefinition is:
{ name: ‘GES_13_3b_T2’, type: ‘int’},

columndefinition is:
{ text: ‘GES_13_3b_T2’, datafield: ‘GES_13_3b_T2’, columntype: ‘textbox’, width: 100 },

Column 859 is of type MySQL BIGINT(20) /int and contains the values 0, 7, and null.
columndefinition is:
{ text: ‘GES_13_3c_T2’, datafield: ‘GES_13_3c_T2’, columntype: ‘textbox’, width: 100 },
datadefinition is:
{ name: ‘GES_13_3c_T2’, type: ‘int’},

Nothing special. I used the same settings everywhere without any problems. I can’t see any reason in the data.

After column 858 ( GES_13_3b_T2) there is a gab of 832 columns but no empty columns in excel.
The gab ends at a TINY(1) /int column and starts again with a TINY(1)/int column.
The remaining columns are then completely available in the export.

Have you any suggestion, why exportview faild?

thanks in advance.

[DeployDuckParticipant]

Update:
I tried to use the older exportdata function to export the same table to the old ‘xls’ Format: and all the columns are present and all the datetime fields are shown correct. What remains are the warning messages from Excel and the fact that we have to offer our customers an outdated data format.

[DeployDuckParticipant]

Ok. found a solution: You have to use an $('#MySchedulerID').on('editDialogOpen', function (event){...
to set the resource selected item. Seems that the editDialogOpen: function is an non working software-artefact.

[DeployDuckParticipant]

Meanwhile I’m able to set the selected resource for the FIRST TIME on create in editDialogCreate: function (dialog, fields, editAppointment) with:

`let MyCalenderResourceName = MyScheduler.source.db.localdata.find(x => x.ResourceID ===My.Sid.I).CalenderOf;
$(fields.resource[0]).jqxDropDownList(‘selectItem’, MyCalenderResourceName );`

But if I do the same in editDialogOpen: function (dialog, fields, editAppointment) it dosn’t work.

Any suggestions?

Thanks.

[DeployDuckParticipant]

Solved by myself.

[DeployDuckParticipant]

As a supplement:
We set up the grid as in your demo (virtualmode, rendergridrows, pageable used) with real data (filled with every data type: 2498 columns and 34,967 data records). There are also occasional data records with the value “zero”, if that could be decided.

What we found:
– filter does not work
– grouping works – but only ungrouped data are exported (tried with excel xlsx)
– sorting does not work

Best Regards.

[DeployDuckParticipant]

Hello Hristo,
thank you for the example. It helps a lot with export.

————
But… the localisation problem still exists – sorry.
I have seen the localisation for the Buttons – no problem.

Missing is the localisation-string for the HEADER “Columns” of the dialog.
I’m commercial customer and have access to the source-code, so I took a look into jqxgrig.js
It seems you have hardcoded the dialogs header in jqxgrid.js in the function “openColumnChooser” in row 2075:

openColumnChooser: function (columns, header) {
            var that = this;

            if (!header) {
                header = "Columns";
            }
...

Therefore a translationstring for the header is missing in the loalisationobj.

Best regards.

[DeployDuckParticipant]

Hello Hristo,
perhaps it’s only an error in your documentation:
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm
Under column you find the description of columntype:

columntype – sets the column’s type.
Possible values:
‘number‘ – readonly column with numbers.

If have modified your example to use columntype: number instead of numberinput, that you choose for the first column. Try it and you will get 1,2,3,4,5,6 instead of the real data.

var data = [
  { firstnumber: 1008768761, secondnumber: 10.01 },
  { firstnumber: 678687, secondnumber: 10.01 },
  { firstnumber: 10067671, secondnumber: 10.01 },
  { firstnumber: 1067868701, secondnumber: 10.01 },
  { firstnumber: 1678687001, secondnumber: 10.01 },
  { firstnumber: 10686876801, secondnumber: 10.01 },
  { firstnumber: 287687686002, secondnumber: 20.02 }
];

var source = {
  localdata: data,
  datatype: "array"
};
var dataAdapter = new $.jqx.dataAdapter(source, {
  loadComplete: function (data) {},
  loadError: function (xhr, status, error) {}
});
$("#jqxgrid").jqxGrid({
  theme: "energyblue",
  altrows: true,
  width: 500,
  autoheight: true,
  source: dataAdapter,
  columns: [{
    text: "First Number",
    datafield: "firstnumber",
    columntype: "number",
    width: 100
  }, {
    text: "Second Number",
    datafield: "secondnumber",
    columntype: "numberinput",
    // width: 100
  }]
});

Best Regards

[DeployDuckParticipant]

Hello Hristo,
thank you for your (part) answer.

Sorry, I can’t see the localisation-string for the columnchooser dialog header.

Also my question 2 is still open.

Thanks

[DeployDuckParticipant]

Hello Hristo,
i’ve just build a grid with about 2500 columns. I have a lot of columns from datatype integer, float and decimal. The data is available throug an array of objects. I have checked, that the data in the array is of the correct datatype.
If I try to use columntype: number I don’t get the data displayed in the column. Instead I got all rows of this column numbered 1,2,3,4,5,…

But everything works fine for me with columntype: textbox. Thats the reason for my question.
thanks.

[DeployDuckParticipant]

Hello.
The export to xlsx is after 5 1/2 years still not supported.

The link to :
https://docs.microsoft.com/en-us/archive/blogs/vsofficedeveloper/excel-2007-extension-warning

in the documetation :
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm?search=grid

is broken.

Please informe me, if you plan to upgrade your export-function for excel.

[Author]

Posts