Creating new import spreadsheet service or modifying existing service
Hello community, I seen there is a productimportfromspreadsheet service in ofbiz which is used for import product entries from excel sheets in to the database. If I want to do same for some other table so will i need to create a new service for that ?? If yes how to achieve that. Or i can modify the above service ?? One thing also i need to know how to read the date fields from the excel sheets and convert those values to date datatype as per the database columns. Please do share some resources for doing this. Regards, Sumesh
REST API - Access token and refresh token for login
Hi, Whenever I login to the application using the rest api token, the user logs out after specific time (1800 seconds). This is because the Access token expires and the user needs to login once again to continue the activities. Do we have the feature of refresh token in here to make sure the user is not interrupted after login? Or a workaround to tackle this issue? Thanks.
Re: Creating new import spreadsheet service or modifying existing service
Hello Sumesh, Please refer OFBIZ_HOME/applications/product/src/main/java/org/apache/ofbiz/product/spreadsheetimport/ImportProductServices.java file. Please read the code present inside service: productImportFromSpreadsheet Please refer my comments inline: -- Kind Regards, Ashish Vijaywargiya Vice President of Operations *HotWax Systems* *Enterprise open source experts* http://www.hotwaxsystems.com On Tue, Jun 21, 2022 at 12:36 PM Sumesh R Acharya <7.sumesh...@gmail.com> wrote: > Hello community, > > I seen there is a productimportfromspreadsheet service in ofbiz which is > used for import product entries from excel sheets in to the database. > > If I want to do same for some other table so will i need to create a new > service for that ?? If yes how to achieve that. > Yes, you need to create other services. > > Or i can modify the above service ?? > My recommendation for you is to create a custom component in OFBiz and write your services in that component. Please refer following links: https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide+for+18.12(Assuming that you are exploring the code base of this stable branch) > > One thing also i need to know how to read the date fields from the excel > sheets and convert those values to date datatype as per the database > columns. Please do share some resources for doing this. > I have used the Apache POI project when I have implemented this feature in the Apache OFBiz project. So I request you to read more details about Apache POI from here: https://poi.apache.org > > Regards, > Sumesh >
Re: REST API - Access token and refresh token for login
Hi Rishi, the client should recognize that the token is not valid or that the token based authentication failed and do a refresh of the token by re-authenticating again. Best regards, Michael Brohl ecomify GmbH - www.ecomify.de Am 21.06.22 um 11:26 schrieb Rishi Agr: Hi, Whenever I login to the application using the rest api token, the user logs out after specific time (1800 seconds). This is because the Access token expires and the user needs to login once again to continue the activities. Do we have the feature of refresh token in here to make sure the user is not interrupted after login? Or a workaround to tackle this issue? Thanks.
Inventory Item Detail
Hello Community, I need your help please understanding the logic used while adding records to the subject table as demo data is not giving enough insight regarding the same. Usually, we’ll have one initial record added with every ‘inventory_item’ and fields ‘QUANTITY_ON_HAND_DIFF’ and ‘AVAILABLE_TO_PROMISE_DIFF’ have the same value. My question is how subsequent records on the same inventory item affect the values of the mentioned fields? Regards, Emad
Re: Fonts in Ofbiz
Referring to my previous mail I have found out a piece of css code in the following file... OFBIZ_HOME/themes/flatgrey/webapp/flatgrey/style.css body, textarea, input, select { font-family: Quicksand, Verdana, Arial, Helvetica, sans-serif; } Question: from where ofbiz is picking up the above mentioned font families? Is it taking from the windows OS (system) which are already installed? Comments: If it takes from the system, then one can install any fonts in the windows system and ofbiz is supposed to pick up that specific font, if it is mentioned in the above css code. Am I thinking correctly? Pls let us know. regards Avijit On Tue, Jun 21, 2022 at 12:09 PM Avijit Bose wrote: > Dear Sir, > > I am making an app in Ofbiz. I need to change the font of the whole app. > > If I change in (OFBIZ_HOME/themes/flatgrey/webapp/flatgrey/style.css), > then where will I put the font .TTF files. Example like: "Roboto-Light.ttf" > > regards > Avijit > > On Tue, Jun 21, 2022 at 12:02 PM Ashish Vijaywargiya < > ashish.vijaywarg...@hotwaxsystems.com> wrote: > >> Hello Avijit, >> >> What are you trying to do? Can you please provide additional details? >> >> Apache OFBiz is a theme driven project and there are a few themes that are >> available out of the box(OOTB). >> >> Please refer: OFBIZ_HOME/themes folder. Here you can see the style.css >> file >> present inside a >> flatgrey theme(OFBIZ_HOME/themes/flatgrey/webapp/flatgrey/style.css). Same >> style.css file is also present in other themes as well. >> >> -- >> Kind Regards, >> Ashish Vijaywargiya >> Vice President of Operations >> *HotWax Systems* >> *Enterprise open source experts* >> http://www.hotwaxsystems.com >> >> >> >> On Tue, Jun 21, 2022 at 10:59 AM Avijit Bose >> wrote: >> >> > Hi, >> > >> > Pls let me know how a different font could be used in ofbiz and where to >> > put the files. >> > >> > regards >> > Avijit >> > >> >
AW: Inventory Item Detail
Hi Emad, when the initial record is done (for example adding product inventory with quantity 10 for productId "demoproduc"t) the inventory item gets +10 QUANTITY_ON_HAND_DIFF +10 AVAILABLE_TO_PROMISE_DIFF’ If a customer creates an order, adding quantity 2 from demoproduct an inventory item detail with AVAILABLE_TO_PROMISE_DIFF -2 is created. The inventory is reserved for that order. The result: ATP: 8 - available to promise QOH: 10 - physical stock This is just one simple case for inventory change. Does this answer your question? Best regards, Ingo -Ursprüngliche Nachricht- Von: Emad Radwan Gesendet: Dienstag, 21. Juni 2022 17:11 An: user@ofbiz.apache.org Betreff: Inventory Item Detail Hello Community, I need your help please understanding the logic used while adding records to the subject table as demo data is not giving enough insight regarding the same. Usually, we’ll have one initial record added with every ‘inventory_item’ and fields ‘QUANTITY_ON_HAND_DIFF’ and ‘AVAILABLE_TO_PROMISE_DIFF’ have the same value. My question is how subsequent records on the same inventory item affect the values of the mentioned fields? Regards, Emad