jQuery Grid Plugin - jqGrid - Topic: problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option Simple:Press Version 5.7.5.3 venugopalsmartboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p28812 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p28812 A simple yet efficient work around is , use  label option in the colModel to set the grid headers and avoid using colNames.  That will set things properly.

]]> Thu, 16 May 2013 12:31:31 +0300 Nils on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p21577 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p21577 Hi Teddyboy,

Thanks for post this workaround.

Just one question regarding this proposed solution.
The main sortable  (column reordering) feature works properly as expected.
But after I reordered some columns and try afterwords to sort one or more columns (asc or desc by clicking onto the column header), my table columns toggle around. In other words I clicked i.e. at column #5 and column #5 becomes column #3 and the original column #3 becomes #5. with another click onto a different column header (totally independed on which one) the columns are toggle back.

...,
loadBeforeSend : function()  {
     jQuery('.ui-jqgrid-hdiv').hide();                              
 },

gridComplete: function() {
     var rv=document.getElementById('column_order').value.split(","); //[0,1,2,3,4,5,6,7,8,9,10,11,12]
     jQuery("#list1").jqGrid("remapColumns",rv, true, false);    
     var hv=document.getElementById('hidden_columns').value.split(",");  //['id','product']
     jQuery('#list1').jqGrid('hideCol',hv);
     jQuery('.ui-jqgrid-hdiv').show();
 },...

BTW as hint: I got more than one sort arrow at the grid (but just one per column).  That's strange, but just with the above descripted senario.

Thanks

Nils

]]> Fri, 07 Jan 2011 22:34:15 +0200 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p19046 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p19046 BTW a simple fix for this is just to make all your columns visible in the data column array. Then in loadBeforeSend first time callback hide the columns bar $('.ui-jqgrid-hdiv').hide() . On gridComplete first time callback call $('#yourGrid').jqGrid('remapColumns',colOrderArry,true,false) and then buildup an array of those columns you want to hide and call $('#yourGrid').jqGrid('hideCol',colArray) and then $('.ui-jqgrid-hdiv').show() to show the column header. This gets over the problem 'remapColumns' has with hidden columns.

]]> Tue, 10 Aug 2010 15:57:22 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p18983 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p18983 Hi Tony

Sorry to pester you about this but is there any chance might fixed in the next release 3.7.3 (?) I've been asked to support this feature and my users are getting  a bit impatient.

Thanks Again

]]> Thu, 05 Aug 2010 15:45:40 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p18731 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p18731 Hi Tony

Has this been fixed in the latest version ?

Thanks

]]> Thu, 22 Jul 2010 11:47:32 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p17520 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p17520 Tried that it didn't work when I moved a column before a non-visible column thanks anyway.

]]> Fri, 28 May 2010 09:35:11 +0300 easytea on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p17460 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p17460 Hey, I had a similar problem. Try setting keepHeader to false, that's what worked for me.

Good luck

]]> Wed, 26 May 2010 11:15:04 +0300 tony on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p17067 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p17067 Hello,

Sorry no. I do not have a chance to investigate this, but definetley will do it.

Best Regards

Tony

]]> Tue, 11 May 2010 14:57:20 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16969 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16969 Hi Tony

Can you tell me whether this bug is fixed in 3.6.5 ?

Thanks

]]> Thu, 06 May 2010 16:38:28 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16514 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16514 Thanks Tony

]]> Mon, 19 Apr 2010 13:02:36 +0300 tony on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16465 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16465 Hello,

Currently we check this bug

Best Regards

Tony

]]> Fri, 16 Apr 2010 17:10:05 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16386 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16386 Any update on this Tony there's still a problem using remapColumns in the latest release.

Thanks

]]> Tue, 13 Apr 2010 17:10:30 +0300 teddyboy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16324 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p16324 Hi Tony

Has the issue been resolved yet, because I would like to do something similar and I have columns which are always hidden and others which the user can show/hide.

Thanks

]]> Fri, 09 Apr 2010 10:10:45 +0300 macbuoy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14912 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14912 Thanks!

]]> Wed, 17 Feb 2010 22:00:53 +0200 tony on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14873 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14873 Hello,

Will look at this.

Regards

Tony

]]> Wed, 17 Feb 2010 12:12:30 +0200 macbuoy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14775 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14775 Hey Tony! Thanks for your reply. There are, indeed, some hidden fields. This is another one of the features I am saving to the server as my user's settings. Some columns permanently hidden by default and others might end up hidden by the user. Thanks, David

tony said:

Hello,

Do you have hidden fields?

Best Regards

Tony

]]> Fri, 12 Feb 2010 22:58:31 +0200 tony on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14766 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14766 Hello,

Do you have hidden fields?

Best Regards

Tony

]]> Fri, 12 Feb 2010 18:46:25 +0200 macbuoy on problem with importing remapColumns grid option http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14706 Help http://www.trirand.com/blog/?page_id=393/help/problem-with-importing-remapcolumns-grid-option#p14706 I am exporting, saving to server and then importing grid options. I use this to save my user's preferences for data sorting, column width and column re-ordering.

That last feature, column re-ordering is a bit of a problem. The grid options are exported and saved with the correct "remapColumns" parameter–it's the permutation array. When the grid loads and the saved options are imported, the columns are properly ordered by the permutation array but the column headings are left in the original, default order.

gridOptions.remapColumns is exported as an array when using the grid export feature:

gridOptions={
  . . .
 ,"remapColumns":[1,2,4,3,5,6]
  . . .
};

again, this approach reorders the columns but leaves the headers in the wrong order.

I have also tried updating the remapColumns option before binding the grid so that it matches the remapColumns method signature:

gridOptions={
  . . .
  ,"remapColumns":{"permutation":[1,2,4,3,5,6],"updateCells":true,"keepHeader":true}
  . . .
};

This last approach doesn't work at all on the columns OR the header row.

Many thanks for such a cool control!! Can anyone tell me what I'm missing here or help me identify a bug?

Thanks!

]]> Wed, 10 Feb 2010 17:27:38 +0200