tag:blogger.com,1999:blog-14479009.post116403368362043385..comments2023-11-24T12:30:17.358+01:00Comments on Ronald Lemmen - CRM, C# and Cme: Maximum amount of records in Excel exportRonald Lemmenhttp://www.blogger.com/profile/11930631598114156863noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-14479009.post-21158067476055530802016-03-18T12:27:06.588+01:002016-03-18T12:27:06.588+01:00Thank you so much... your blog is giving very usef...<br />Thank you so much... your blog is giving very useful knowledge for all.i didn’t have the knowledge in this now i get an idea about this.. thks a lot:-)<br />If you Want more details kindly Visit Cash on <a href="http://www.creditcardtocashinchennai.in/spot-cash-on-credit-card/" rel="nofollow"> Credit </a> cardRajeshhttp://www.creditcardtocashinchennai.in/spot-cash-on-credit-card/noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-81552238094767159552014-02-13T13:57:10.664+01:002014-02-13T13:57:10.664+01:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/02586689911661759268noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-15708522862971264982010-03-04T22:59:18.257+01:002010-03-04T22:59:18.257+01:00Changing the value to 100000 worked! I was going c...Changing the value to 100000 worked! I was going crazy! There was a mailing list to process 'yesterday'. No, I am in a good shape!<br />Thanks, Peter!mkatsevnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-61313937686510021952009-02-18T23:35:00.000+01:002009-02-18T23:35:00.000+01:00You have to recycle the app pool of the front-end ...You have to recycle the app pool of the front-end CRM web server after making this change. Also, it appears to only allow you to limit in multiples of 500 - if you set something like say 650 rows, you'll get 1000.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-75410046039537624242008-09-23T18:52:00.000+02:002008-09-23T18:52:00.000+02:00Good Afternoon!I found the column described for CR...Good Afternoon!<BR/>I found the column described for CRM 4.0 in the table Organization Base. When I change the value in SQL and exit the column, a red circle with an exclamation point appears in the column. Do I continue and save or is there something else that should be changed?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-42239161674119713452008-06-05T15:02:00.000+02:002008-06-05T15:02:00.000+02:00There isn´t table called OrganizationStatisticBase...There isn´t table called OrganizationStatisticBase in our CRM 4.0!<BR/><BR/>There isn´t column named MaxRecordsForExportToExcel in OrganizationBase table!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-33128194134267603772008-05-30T01:18:00.000+02:002008-05-30T01:18:00.000+02:00*I found the MaxRecordsForExportToExcel column in ...*I found the MaxRecordsForExportToExcel column in the OrganizationBase tableAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-39314059598427230072008-03-18T09:25:00.000+01:002008-03-18T09:25:00.000+01:00This isn't working in CRM 4.0 anymore.To change th...This isn't working in CRM 4.0 anymore.<BR/><BR/>To change the value in 4.0 follow these steps:<BR/><BR/>1: Open the organization database (organization_MSCRM)<BR/>2: Open the table OrganizationStatisticBase<BR/>3: Change the column MaxRecordsForExportToExcel to the desired number of records.<BR/><BR/>4: I did an iisreset also, can't tell you at this time if it is required or not.Peter van Amerongenhttps://www.blogger.com/profile/12391253227550162088noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-37653951227469964022007-02-16T16:35:00.000+01:002007-02-16T16:35:00.000+01:00Hi Clifford,Thanks for your valueable comment. The...Hi Clifford,<BR/><BR/>Thanks for your valueable comment. The code should indeed be changed on the server. I have not tested this for the outlook clients.<BR/><BR/>Kind regards,<BR/><BR/>RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-90945980285341847982007-02-16T16:26:00.000+01:002007-02-16T16:26:00.000+01:00Thank you very much for this information. Tried it...Thank you very much for this information. Tried it and it worked great. You might want to also add that you can make this change on the Server so that if you are using the web browser interface for the excel exports it would work for those users as well.<BR/><BR/>Clifford W Gray - Network Engineer / Sr. SQA Analyst<BR/>Nielsen Media Research<BR/>Office E-Mail: graycw@tvratings.comAnonymousnoreply@blogger.com