Chart of Accounts export - does not export all records at a time
Locked
 
|
Hello to OFBiz community. This is my first post on this forum and as you may guess, still learning the ropes..
I am looking to get an export of all the entries in chart of accounts using the export link in the screen URL below https://demo904.ofbiz.org/accounting/control/globalGLSettings While this page shows the records on the browser in a paginated fashion, I was hoping that the export and the print (PDF) would include all the records in one shot avoiding pagination. However, that does not happen and the export seems to only throw the records visible on the screen, 20 at a time. Tried to follow the flow to GlobalGlAccountScreen.xml , <screen name="ListGlAccounts"> and see the following code <set field="viewIndex" from-field="parameters.VIEW_INDEX" type="Integer" default-value="0"/> <set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" default-value="50"/> From it looks like the pagination is set to 50, but the screen still paginates 20 at a time. How does one get to 50 for example? Back to the export all records which seem to point to <screen name="ListGlAccountsReport"> find that there is a setting to make the view size very large (1000) <set field="viewIndex" from-field="parameters.VIEW_INDEX" type="Integer" default-value="0"/> <set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" default-value="1000"/> But this too doesn't seem to take effect. While I continue to dig further to get an understanding, would very much appreciate if anyone can throw me some pointers. Many thanks in advance Aray |
Re: Chart of Accounts export - does not export all records at a time
|
|
Try adding a parameter like "VIEW_SIZE=1000" to the URL in your browser. In the set entries you mentioned where you put the 1000 was just a "default-value" which means that if there is a value in parameters.VIEW_SIZE then the 1000 you set will be ignored. I haven't traced through the code, and hopefully there isn't anything on that screen/etc that ignores or does a hard override on this parameter, so this should work (it does in pretty much all of OFBiz where pagination is supported). -David On Jun 5, 2009, at 8:36 AM, ARays wrote: > > Hello to OFBiz community. This is my first post on this forum and as > you may > guess, still learning the ropes.. > > I am looking to get an export of all the entries in chart of > accounts using > the export link in the screen URL below > https://demo904.ofbiz.org/accounting/control/globalGLSettings > > While this page shows the records on the browser in a paginated > fashion, I > was hoping that the export and the print (PDF) would include all the > records > in one shot avoiding pagination. However, that does not happen and the > export seems to only throw the records visible on the screen, 20 at > a time. > > Tried to follow the flow to GlobalGlAccountScreen.xml , <screen > name="ListGlAccounts"> and see the following code > <!-- no longer works requies a fieldMap entity-and > entity-name="GlAccount" list="entityList" use-cache="true" > > <limit-range start="0" size="20"/> > </entity-and --> > <set field="viewIndex" from- > field="parameters.VIEW_INDEX" > type="Integer" default-value="0"/> > <set field="viewSize" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="50"/> > > From it looks like the pagination is set to 50, but the screen still > paginates 20 at a time. How does one get to 50 for example? > > Back to the export all records which seem to point to <screen > name="ListGlAccountsReport"> find that there is a setting to make > the view > size very large (1000) > <set field="viewIndex" from- > field="parameters.VIEW_INDEX" > type="Integer" default-value="0"/> > <set field="viewSize" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="1000"/> > > But this too doesn't seem to take effect. > > While I continue to dig further to get an understanding, would very > much > appreciate if anyone can throw me some pointers. > > Many thanks in advance > Aray > > -- > View this message in context: http://www.nabble.com/Chart-of-Accounts-export---does-not-export-all-records-at-a-time-tp23889451p23889451.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Chart of Accounts export - does not export all records at a time
|
|
In reply to this post by aray
a work around I think is to click on the next button so then change the URL
N&VIEW_SIZE_1=20&VIEW_INDEX_1=1# to N&VIEW_SIZE_1=461&VIEW_INDEX_1=1# will give you one page I am not sure the printing will follow but you can give it a try. ARays sent the following on 6/5/2009 7:36 AM: > Hello to OFBiz community. This is my first post on this forum and as you may > guess, still learning the ropes.. > > I am looking to get an export of all the entries in chart of accounts using > the export link in the screen URL below > https://demo904.ofbiz.org/accounting/control/globalGLSettings > > While this page shows the records on the browser in a paginated fashion, I > was hoping that the export and the print (PDF) would include all the records > in one shot avoiding pagination. However, that does not happen and the > export seems to only throw the records visible on the screen, 20 at a time. > > Tried to follow the flow to GlobalGlAccountScreen.xml , <screen > name="ListGlAccounts"> and see the following code > <!-- no longer works requies a fieldMap entity-and > entity-name="GlAccount" list="entityList" use-cache="true" > > <limit-range start="0" size="20"/> > </entity-and --> > <set field="viewIndex" from-field="parameters.VIEW_INDEX" > type="Integer" default-value="0"/> > <set field="viewSize" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="50"/> > >>From it looks like the pagination is set to 50, but the screen still > paginates 20 at a time. How does one get to 50 for example? > > Back to the export all records which seem to point to <screen > name="ListGlAccountsReport"> find that there is a setting to make the view > size very large (1000) > <set field="viewIndex" from-field="parameters.VIEW_INDEX" > type="Integer" default-value="0"/> > <set field="viewSize" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="1000"/> > > But this too doesn't seem to take effect. > > While I continue to dig further to get an understanding, would very much > appreciate if anyone can throw me some pointers. > > Many thanks in advance > Aray > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator. |
|
|
Fantastic! Thanks for the tips, David, Freeman.. I could get it working for both cases regular pagination as well as export by changing
<set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" default-value="1000"/> to <set field="parameters.VIEW_SIZE_1" from-field="parameters.VIEW_SIZE" type="Integer" default-value="1000"/> So, looks like the parameter is VIEW_SIZE_1.. Interestingly I don't see this used anywhere else in ofbiz. Need to dig deeper perhaps but looks like the <set field="viewSize" is being used at several places for pagination. So, is there a better way to fix it for all cases rather than changing the line above (I haven't checked other cases but going to do shortly)? Sorry, I am still trying to get my head around how this works. -Aray ---------------------------------------------------- <quote author="BJ Freeman"> a work around I think is to click on the next button so then change the URL N&VIEW_SIZE_1=20&VIEW_INDEX_1=1# to N&VIEW_SIZE_1=461&VIEW_INDEX_1=1# will give you one page I am not sure the printing will follow but you can give it a try. ARays sent the following on 6/5/2009 7:36 AM: > Hello to OFBiz community. This is my first post on this forum and as you may > guess, still learning the ropes.. > > I am looking to get an export of all the entries in chart of accounts using > the export link in the screen URL below > https://demo904.ofbiz.org/accounting/control/globalGLSettings > > While this page shows the records on the browser in a paginated fashion, I > was hoping that the export and the print (PDF) would include all the records > in one shot avoiding pagination. However, that does not happen and the > export seems to only throw the records visible on the screen, 20 at a time. > > Tried to follow the flow to GlobalGlAccountScreen.xml , <screen > name="ListGlAccounts"> and see the following code > > <set field="viewIndex" from-field="parameters.VIEW_INDEX" > type="Integer" default-value="0"/> > <set field="viewSize" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="50"/> > >>From it looks like the pagination is set to 50, but the screen still > paginates 20 at a time. How does one get to 50 for example? > > Back to the export all records which seem to point to <screen > name="ListGlAccountsReport"> find that there is a setting to make the view > size very large (1000) > <set field="viewIndex" from-field="parameters.VIEW_INDEX" > type="Integer" default-value="0"/> > <set field="viewSize" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="1000"/> > > But this too doesn't seem to take effect. > > While I continue to dig further to get an understanding, would very much > appreciate if anyone can throw me some pointers. > > Many thanks in advance > Aray > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator. |
Re: Chart of Accounts export - does not export all records at a time
|
|
Hello ARays,
You can also try with view-size attribute of form where you can give integer type value to display no. of records like 1000, it'll display all records based on value of view-size, without pagination. Thanks and Regards Santosh Malviya www.hotwaxmedia.com ARays wrote: > Fantastic! Thanks for the tips, David, Freeman.. I could get it working for > both cases regular pagination as well as export by changing > > <set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" > default-value="1000"/> > > to > > <set field="parameters.VIEW_SIZE_1" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="1000"/> > > So, looks like the parameter is VIEW_SIZE_1.. Interestingly I don't see this > used anywhere else in ofbiz. Need to dig deeper perhaps but looks like the > <set field="viewSize" is being used at several places for pagination. So, is > there a better way to fix it for all cases rather than changing the line > above (I haven't checked other cases but going to do shortly)? Sorry, I am > still trying to get my head around how this works. > > -Aray > > > > ---------------------------------------------------- > > BJ Freeman wrote: > >> a work around I think is to click on the next button so then change the >> URL >> N&VIEW_SIZE_1=20&VIEW_INDEX_1=1# >> to >> N&VIEW_SIZE_1=461&VIEW_INDEX_1=1# >> >> will give you one page >> I am not sure the printing will follow but you can give it a try. >> >> ARays sent the following on 6/5/2009 7:36 AM: >> >>> Hello to OFBiz community. This is my first post on this forum and as you >>> may >>> guess, still learning the ropes.. >>> >>> I am looking to get an export of all the entries in chart of accounts >>> using >>> the export link in the screen URL below >>> https://demo904.ofbiz.org/accounting/control/globalGLSettings >>> >>> While this page shows the records on the browser in a paginated fashion, >>> I >>> was hoping that the export and the print (PDF) would include all the >>> records >>> in one shot avoiding pagination. However, that does not happen and the >>> export seems to only throw the records visible on the screen, 20 at a >>> time. >>> >>> Tried to follow the flow to GlobalGlAccountScreen.xml , <screen >>> name="ListGlAccounts"> and see the following code >>> <!-- no longer works requies a fieldMap entity-and >>> entity-name="GlAccount" list="entityList" use-cache="true" > >>> <limit-range start="0" size="20"/> >>> </entity-and --> >>> <set field="viewIndex" from-field="parameters.VIEW_INDEX" >>> type="Integer" default-value="0"/> >>> <set field="viewSize" from-field="parameters.VIEW_SIZE" >>> type="Integer" default-value="50"/> >>> >>> >From it looks like the pagination is set to 50, but the screen still >>> paginates 20 at a time. How does one get to 50 for example? >>> >>> Back to the export all records which seem to point to <screen >>> name="ListGlAccountsReport"> find that there is a setting to make the >>> view >>> size very large (1000) >>> <set field="viewIndex" from-field="parameters.VIEW_INDEX" >>> type="Integer" default-value="0"/> >>> <set field="viewSize" from-field="parameters.VIEW_SIZE" >>> type="Integer" default-value="1000"/> >>> >>> But this too doesn't seem to take effect. >>> >>> While I continue to dig further to get an understanding, would very much >>> appreciate if anyone can throw me some pointers. >>> >>> Many thanks in advance >>> Aray >>> >>> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> Systems Integrator. >> >> >> >> > > |
|
|
Hi Santosh,
I tried the below <set field="parameters.view-size" from-field="parameters.VIEW_SIZE" type="Integer" default-value="1000"/> This didn't result in the desired. Should I be doing something different? Sorry, I am still limited by my understanding of the framework. Also another somewhat related question .. In the form associated with the screen in reference I find an entry as below <field-map field-name="noConditionFind" value="Y"/> Thanks again - Aray
|
Re: Chart of Accounts export - does not export all records at a time
|
|
Hello ARays,
You have to set view-size attirbute in form included "ListGlAccount" in screen for printing and exporting records like this: <form name="ListGlAccount" list-name="listIt" target="" title="" type="list" default-entity-name="GlAccount" odd-row-style="alternate-row" default-table-style="basic-table hover-bar" view-size="1000"> noConditionFind field is used for perfomFind service and if this is set to "Y" means find records without any entityConditionList. HTH Thanks and Regards Santosh Malviya www.hotwaxmedia.com ARays wrote: > Hi Santosh, > > I tried the below > <set field="parameters.view-size" from-field="parameters.VIEW_SIZE" > type="Integer" default-value="1000"/> > > This didn't result in the desired. Should I be doing something different? > Sorry, I am still limited by my understanding of the framework. > > Also another somewhat related question .. In the form associated with the > screen in reference I find an entry as below > > <field-map field-name="noConditionFind" value="Y"/> > > Thanks again > - Aray > > santosh malviya-2 wrote: > >> Hello ARays, >> You can also try with view-size attribute of form where you can give >> integer type value to display no. of records like 1000, it'll display >> all records based on value of view-size, without pagination. >> >> Thanks and Regards >> Santosh Malviya >> www.hotwaxmedia.com >> >> ARays wrote: >> >>> Fantastic! Thanks for the tips, David, Freeman.. I could get it working >>> for >>> both cases regular pagination as well as export by changing >>> >>> <set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" >>> default-value="1000"/> >>> >>> to >>> >>> <set field="parameters.VIEW_SIZE_1" from-field="parameters.VIEW_SIZE" >>> type="Integer" default-value="1000"/> >>> >>> So, looks like the parameter is VIEW_SIZE_1.. Interestingly I don't see >>> this >>> used anywhere else in ofbiz. Need to dig deeper perhaps but looks like >>> the >>> <set field="viewSize" is being used at several places for pagination. So, >>> is >>> there a better way to fix it for all cases rather than changing the line >>> above (I haven't checked other cases but going to do shortly)? Sorry, I >>> am >>> still trying to get my head around how this works. >>> >>> -Aray >>> >>> >>> >>> ---------------------------------------------------- >>> >>> BJ Freeman wrote: >>> >>> >>>> a work around I think is to click on the next button so then change the >>>> URL >>>> N&VIEW_SIZE_1=20&VIEW_INDEX_1=1# >>>> to >>>> N&VIEW_SIZE_1=461&VIEW_INDEX_1=1# >>>> >>>> will give you one page >>>> I am not sure the printing will follow but you can give it a try. >>>> >>>> ARays sent the following on 6/5/2009 7:36 AM: >>>> >>>> >>>>> Hello to OFBiz community. This is my first post on this forum and as >>>>> you >>>>> may >>>>> guess, still learning the ropes.. >>>>> >>>>> I am looking to get an export of all the entries in chart of accounts >>>>> using >>>>> the export link in the screen URL below >>>>> https://demo904.ofbiz.org/accounting/control/globalGLSettings >>>>> >>>>> While this page shows the records on the browser in a paginated >>>>> fashion, >>>>> I >>>>> was hoping that the export and the print (PDF) would include all the >>>>> records >>>>> in one shot avoiding pagination. However, that does not happen and the >>>>> export seems to only throw the records visible on the screen, 20 at a >>>>> time. >>>>> >>>>> Tried to follow the flow to GlobalGlAccountScreen.xml , <screen >>>>> name="ListGlAccounts"> and see the following code >>>>> <!-- no longer works requies a fieldMap entity-and >>>>> entity-name="GlAccount" list="entityList" use-cache="true" > >>>>> <limit-range start="0" size="20"/> >>>>> </entity-and --> >>>>> <set field="viewIndex" >>>>> from-field="parameters.VIEW_INDEX" >>>>> type="Integer" default-value="0"/> >>>>> <set field="viewSize" from-field="parameters.VIEW_SIZE" >>>>> type="Integer" default-value="50"/> >>>>> >>>>> >From it looks like the pagination is set to 50, but the screen still >>>>> paginates 20 at a time. How does one get to 50 for example? >>>>> >>>>> Back to the export all records which seem to point to <screen >>>>> name="ListGlAccountsReport"> find that there is a setting to make the >>>>> view >>>>> size very large (1000) >>>>> <set field="viewIndex" >>>>> from-field="parameters.VIEW_INDEX" >>>>> type="Integer" default-value="0"/> >>>>> <set field="viewSize" from-field="parameters.VIEW_SIZE" >>>>> type="Integer" default-value="1000"/> >>>>> >>>>> But this too doesn't seem to take effect. >>>>> >>>>> While I continue to dig further to get an understanding, would very >>>>> much >>>>> appreciate if anyone can throw me some pointers. >>>>> >>>>> Many thanks in advance >>>>> Aray >>>>> >>>>> >>>>> >>>> -- >>>> BJ Freeman >>>> http://www.businessesnetwork.com/automation >>>> http://bjfreeman.elance.com >>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>>> Systems Integrator. >>>> >>>> >>>> >>>> >>>> >>> >>> >> > > |
|
|
In reply to this post by aray
Alright, never mind my previous note.. I think I figured what you meant by "view-size attribute of form". I see the attribute used quite frequently across the app on the form definition. Thanks for the hint.
-Aray
|
|
|
Yet another related question that I still digging to find out how?
In the screen https://demo904.ofbiz.org/accounting/control/globalGLSettings the export is expected to use the simple.xml.ftl file to render as suggested by the entry in commonscreen.xml under webcommon <xml><html-template location="component://common/webcommon/includes/simple.xml.ftl"/></xml> Now it does not seem like getting picked up and instead the processing continues to happen using simple.ftl as specified under <html>c location="component://common/webcommon/includes/simple.ftl"/></html> Also find that the controller.xml for accounting has an entry <view-map name="ListGlAccountsExport" type="screenxml" page="component://accounting/widget/GlobalGlAccountsScreens.xml#ListGlAccountsReport" content-type="text/xml"/> Question: what is the link between screenxml above and <xml> tag before <html-template ? I was hopping that screenxml would pick the entry with <xml> Many thanks in advance - Aray
|
|
|
In reply to this post by santosh malviya-2
Indeed that helped.. I figured that one out after I sent my note..
Many thanks Aray
|
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |