is there a way for me to import an xml file in a similiar fashion to the
way i can import products from an external database to increase the inventory count... you may have seen my previous question about how to mass import pictures... I have figured that out with a script that combines the functionality of imagemajicks convert function, used through a system call from gawk, multiplied over the various picture sizes, and a simple text file that enumerated what each picture's associated productid was in a line delimited fashion... I like running a simple text file through a script to automate these ofbiz functions as a much simpler way to do batch processing of jobs that already are a bit of a task, but having to go into each item and recieve inventory... well.... i refurb printers and everyone that i strip apart yields about 20-40 parts... multiply that over approximately 20 printers a pallet... you get the idea i would ideally have a line delimited or csv delimited file that can be processed by gawk into an xml file that i can do the load-extdata call from ant with could i just create a ShipmentReceipt.xml and load that... it just seems like that is a marking of the transaction and not the transaction |
ive actually answered my own question... sort of... the key files that are
of importance from my research are AcctgTrans.xml AcctgTransEntry.xml ShipmentReceipt.xml InventoryItem.xml and last but not least InventoryItemDetail.xml the first three are for the creation of the shipment transaction receipt? im a little confused on this, but i know i cant add to the shipmentreceipt without creating the receiptid in acctgtrans, and im not sure about the acctgtransentry entries, if anyone can help please do... the latter two are specifically what i am more concerned with and that is the on hand amount of each part, but is the acctg and ship receipt necessary to just modify the on hand for the web store? any help on this is greatly appreciated Chris On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark <[hidden email]> wrote: > is there a way for me to import an xml file in a similiar fashion to the > way i can import products from an external database to increase the > inventory count... you may have seen my previous question about how to > mass import pictures... I have figured that out with a script that > combines the functionality of imagemajicks convert function, used through a > system call from gawk, multiplied over the various picture sizes, and a > simple text file that enumerated what each picture's associated productid > was in a line delimited fashion... > > I like running a simple text file through a script to automate these ofbiz > functions as a much simpler way to do batch processing of jobs that already > are a bit of a task, but having to go into each item and recieve > inventory... well.... i refurb printers and everyone that i strip apart > yields about 20-40 parts... multiply that over approximately 20 printers a > pallet... you get the idea i would ideally have a line delimited or csv > delimited file that can be processed by gawk into an xml file that i can do > the load-extdata call from ant with > > could i just create a ShipmentReceipt.xml and load that... it just seems > like that is a marking of the transaction and not the transaction > |
Hi Chris,
please see inline: On Apr 9, 2015, at 1:16 PM, Chris Clark <[hidden email]> wrote: > ive actually answered my own question... sort of... the key files that are > of importance from my research are > > AcctgTrans.xml > AcctgTransEntry.xml the above two entries are about General Ledger accounting transaction: AcctgTrans is the header and AcctgTransEntry are the Dr and Cr entries; if you are not planning to use accounting you could even skip them. > ShipmentReceipt.xml This represent the "document" for the receipt; the GL transactions are associated to this document. > InventoryItem.xml > and last but not least > InventoryItemDetail.xml You should create one new InventoryItem for each ShipmentReceipt; then you should also create the InventoryItemDetail with the initial units received; this will trigger a service that will update the InventoryItem.quantityOnHandTotal field. I hope it helps, Jacopo > > the first three are for the creation of the shipment transaction receipt? > im a little confused on this, but i know i cant add to the shipmentreceipt > without creating the receiptid in acctgtrans, and im not sure about the > acctgtransentry entries, if anyone can help please do... > > the latter two are specifically what i am more concerned with and that is > the on hand amount of each part, but is the acctg and ship receipt > necessary to just modify the on hand for the web store? > > any help on this is greatly appreciated > > Chris > > On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark <[hidden email]> wrote: > >> is there a way for me to import an xml file in a similiar fashion to the >> way i can import products from an external database to increase the >> inventory count... you may have seen my previous question about how to >> mass import pictures... I have figured that out with a script that >> combines the functionality of imagemajicks convert function, used through a >> system call from gawk, multiplied over the various picture sizes, and a >> simple text file that enumerated what each picture's associated productid >> was in a line delimited fashion... >> >> I like running a simple text file through a script to automate these ofbiz >> functions as a much simpler way to do batch processing of jobs that already >> are a bit of a task, but having to go into each item and recieve >> inventory... well.... i refurb printers and everyone that i strip apart >> yields about 20-40 parts... multiply that over approximately 20 printers a >> pallet... you get the idea i would ideally have a line delimited or csv >> delimited file that can be processed by gawk into an xml file that i can do >> the load-extdata call from ant with >> >> could i just create a ShipmentReceipt.xml and load that... it just seems >> like that is a marking of the transaction and not the transaction >> |
so for instance if i strip down for parts a model abc
and end up with parts (product ids) abc100.... abc120 (20 parts total) and assume i only want to deal with inventory for now, and not for accounting (although i presume i am going to need to address the accounting), then correct me if i am wrong I do NOT have to create a shipmentreceipt ONE new inventory item for EACH part # also ONE new inventoryitemdetail for each part#? fwiw from what i have experienced with trial and error i have to create a new AcctgTrans in order to even create a new ShipmentReceipt (receiptId) entry this is all new to me, but i have to say the ability to integrate this into what i would call "shell transactions" is awesome as it allows us to forego the gui and the repetitive movements that plague all us computer users On Thu, Apr 9, 2015 at 3:18 PM, Jacopo Cappellato < [hidden email]> wrote: > Hi Chris, > > please see inline: > > On Apr 9, 2015, at 1:16 PM, Chris Clark <[hidden email]> wrote: > > > ive actually answered my own question... sort of... the key files that > are > > of importance from my research are > > > > AcctgTrans.xml > > AcctgTransEntry.xml > > the above two entries are about General Ledger accounting transaction: > AcctgTrans is the header and AcctgTransEntry are the Dr and Cr entries; if > you are not planning to use accounting you could even skip them. > > > ShipmentReceipt.xml > > This represent the "document" for the receipt; the GL transactions are > associated to this document. > > > InventoryItem.xml > > and last but not least > > InventoryItemDetail.xml > > You should create one new InventoryItem for each ShipmentReceipt; then you > should also create the InventoryItemDetail with the initial units received; > this will trigger a service that will update the > InventoryItem.quantityOnHandTotal field. > > I hope it helps, > > Jacopo > > > > > the first three are for the creation of the shipment transaction receipt? > > im a little confused on this, but i know i cant add to the > shipmentreceipt > > without creating the receiptid in acctgtrans, and im not sure about the > > acctgtransentry entries, if anyone can help please do... > > > > the latter two are specifically what i am more concerned with and that is > > the on hand amount of each part, but is the acctg and ship receipt > > necessary to just modify the on hand for the web store? > > > > any help on this is greatly appreciated > > > > Chris > > > > On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark <[hidden email]> wrote: > > > >> is there a way for me to import an xml file in a similiar fashion to the > >> way i can import products from an external database to increase the > >> inventory count... you may have seen my previous question about how to > >> mass import pictures... I have figured that out with a script that > >> combines the functionality of imagemajicks convert function, used > through a > >> system call from gawk, multiplied over the various picture sizes, and a > >> simple text file that enumerated what each picture's associated > productid > >> was in a line delimited fashion... > >> > >> I like running a simple text file through a script to automate these > ofbiz > >> functions as a much simpler way to do batch processing of jobs that > already > >> are a bit of a task, but having to go into each item and recieve > >> inventory... well.... i refurb printers and everyone that i strip apart > >> yields about 20-40 parts... multiply that over approximately 20 > printers a > >> pallet... you get the idea i would ideally have a line delimited or csv > >> delimited file that can be processed by gawk into an xml file that i > can do > >> the load-extdata call from ant with > >> > >> could i just create a ShipmentReceipt.xml and load that... it just seems > >> like that is a marking of the transaction and not the transaction > >> > > |
On Apr 9, 2015, at 2:38 PM, Chris Clark <[hidden email]> wrote: > so for instance if i strip down for parts a model abc > and end up with parts (product ids) > abc100.... abc120 (20 parts total) > and assume i only want to deal with inventory for now, and not for > accounting (although i presume i am going to need to address the > accounting), then correct me if i am wrong > I do NOT have to create a shipmentreceipt > ONE new inventory item for EACH part # > also ONE new inventoryitemdetail for each part#? Correct: if you only want to deal with inventory, you can create one new inventory item and one new inventory item detail for each part# every time you receive it. For example, if you receive 10 units of abc100 on 2015-04-13 then you will create InventoryItem: inventoryItemId=10000, productId=abc100, datetimeReceived=2015-04-13 InventoryItemDetail: inventoryItemId=10000, inventoryItemDetailSeqId=0001, quantityOnHandDiff=10, availableToPromiseDiff=10 Then, when you receive 20 units of the same product on 2015-04-15 then you will create similarly: InventoryItem: inventoryItemId=10001, productId=abc100, datetimeReceived=2015-04-15 InventoryItemDetail: inventoryItemId=10001, inventoryItemDetailSeqId=0001, quantityOnHandDiff=20, availableToPromiseDiff=20 > > fwiw from what i have experienced with trial and error i have to create a > new AcctgTrans in order to even create a new ShipmentReceipt (receiptId) > entry This shouldn't be the case but let me know if you get this error again. Regards, Jacopo > > this is all new to me, but i have to say the ability to integrate this into > what i would call "shell transactions" is awesome as it allows us to forego > the gui and the repetitive movements that plague all us computer users > > On Thu, Apr 9, 2015 at 3:18 PM, Jacopo Cappellato < > [hidden email]> wrote: > >> Hi Chris, >> >> please see inline: >> >> On Apr 9, 2015, at 1:16 PM, Chris Clark <[hidden email]> wrote: >> >>> ive actually answered my own question... sort of... the key files that >> are >>> of importance from my research are >>> >>> AcctgTrans.xml >>> AcctgTransEntry.xml >> >> the above two entries are about General Ledger accounting transaction: >> AcctgTrans is the header and AcctgTransEntry are the Dr and Cr entries; if >> you are not planning to use accounting you could even skip them. >> >>> ShipmentReceipt.xml >> >> This represent the "document" for the receipt; the GL transactions are >> associated to this document. >> >>> InventoryItem.xml >>> and last but not least >>> InventoryItemDetail.xml >> >> You should create one new InventoryItem for each ShipmentReceipt; then you >> should also create the InventoryItemDetail with the initial units received; >> this will trigger a service that will update the >> InventoryItem.quantityOnHandTotal field. >> >> I hope it helps, >> >> Jacopo >> >>> >>> the first three are for the creation of the shipment transaction receipt? >>> im a little confused on this, but i know i cant add to the >> shipmentreceipt >>> without creating the receiptid in acctgtrans, and im not sure about the >>> acctgtransentry entries, if anyone can help please do... >>> >>> the latter two are specifically what i am more concerned with and that is >>> the on hand amount of each part, but is the acctg and ship receipt >>> necessary to just modify the on hand for the web store? >>> >>> any help on this is greatly appreciated >>> >>> Chris >>> >>> On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark <[hidden email]> wrote: >>> >>>> is there a way for me to import an xml file in a similiar fashion to the >>>> way i can import products from an external database to increase the >>>> inventory count... you may have seen my previous question about how to >>>> mass import pictures... I have figured that out with a script that >>>> combines the functionality of imagemajicks convert function, used >> through a >>>> system call from gawk, multiplied over the various picture sizes, and a >>>> simple text file that enumerated what each picture's associated >> productid >>>> was in a line delimited fashion... >>>> >>>> I like running a simple text file through a script to automate these >> ofbiz >>>> functions as a much simpler way to do batch processing of jobs that >> already >>>> are a bit of a task, but having to go into each item and recieve >>>> inventory... well.... i refurb printers and everyone that i strip apart >>>> yields about 20-40 parts... multiply that over approximately 20 >> printers a >>>> pallet... you get the idea i would ideally have a line delimited or csv >>>> delimited file that can be processed by gawk into an xml file that i >> can do >>>> the load-extdata call from ant with >>>> >>>> could i just create a ShipmentReceipt.xml and load that... it just seems >>>> like that is a marking of the transaction and not the transaction >>>> >> >> |
i do get an invalid error or a long error that references the recieptId
being invalid On Thu, Apr 9, 2015 at 4:16 PM, Jacopo Cappellato < [hidden email]> wrote: > > On Apr 9, 2015, at 2:38 PM, Chris Clark <[hidden email]> wrote: > > > so for instance if i strip down for parts a model abc > > and end up with parts (product ids) > > abc100.... abc120 (20 parts total) > > and assume i only want to deal with inventory for now, and not for > > accounting (although i presume i am going to need to address the > > accounting), then correct me if i am wrong > > I do NOT have to create a shipmentreceipt > > ONE new inventory item for EACH part # > > also ONE new inventoryitemdetail for each part#? > > Correct: if you only want to deal with inventory, you can create one new > inventory item and one new inventory item detail for each part# every time > you receive it. > For example, if you receive 10 units of abc100 on 2015-04-13 then you will > create > > InventoryItem: inventoryItemId=10000, productId=abc100, > datetimeReceived=2015-04-13 > InventoryItemDetail: inventoryItemId=10000, inventoryItemDetailSeqId=0001, > quantityOnHandDiff=10, availableToPromiseDiff=10 > > Then, when you receive 20 units of the same product on 2015-04-15 then you > will create similarly: > > InventoryItem: inventoryItemId=10001, productId=abc100, > datetimeReceived=2015-04-15 > InventoryItemDetail: inventoryItemId=10001, inventoryItemDetailSeqId=0001, > quantityOnHandDiff=20, availableToPromiseDiff=20 > > > > > fwiw from what i have experienced with trial and error i have to create a > > new AcctgTrans in order to even create a new ShipmentReceipt (receiptId) > > entry > > This shouldn't be the case but let me know if you get this error again. > > Regards, > > Jacopo > > > > > this is all new to me, but i have to say the ability to integrate this > into > > what i would call "shell transactions" is awesome as it allows us to > forego > > the gui and the repetitive movements that plague all us computer users > > > > On Thu, Apr 9, 2015 at 3:18 PM, Jacopo Cappellato < > > [hidden email]> wrote: > > > >> Hi Chris, > >> > >> please see inline: > >> > >> On Apr 9, 2015, at 1:16 PM, Chris Clark <[hidden email]> wrote: > >> > >>> ive actually answered my own question... sort of... the key files that > >> are > >>> of importance from my research are > >>> > >>> AcctgTrans.xml > >>> AcctgTransEntry.xml > >> > >> the above two entries are about General Ledger accounting transaction: > >> AcctgTrans is the header and AcctgTransEntry are the Dr and Cr entries; > if > >> you are not planning to use accounting you could even skip them. > >> > >>> ShipmentReceipt.xml > >> > >> This represent the "document" for the receipt; the GL transactions are > >> associated to this document. > >> > >>> InventoryItem.xml > >>> and last but not least > >>> InventoryItemDetail.xml > >> > >> You should create one new InventoryItem for each ShipmentReceipt; then > you > >> should also create the InventoryItemDetail with the initial units > received; > >> this will trigger a service that will update the > >> InventoryItem.quantityOnHandTotal field. > >> > >> I hope it helps, > >> > >> Jacopo > >> > >>> > >>> the first three are for the creation of the shipment transaction > receipt? > >>> im a little confused on this, but i know i cant add to the > >> shipmentreceipt > >>> without creating the receiptid in acctgtrans, and im not sure about the > >>> acctgtransentry entries, if anyone can help please do... > >>> > >>> the latter two are specifically what i am more concerned with and that > is > >>> the on hand amount of each part, but is the acctg and ship receipt > >>> necessary to just modify the on hand for the web store? > >>> > >>> any help on this is greatly appreciated > >>> > >>> Chris > >>> > >>> On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark <[hidden email]> wrote: > >>> > >>>> is there a way for me to import an xml file in a similiar fashion to > the > >>>> way i can import products from an external database to increase the > >>>> inventory count... you may have seen my previous question about how > to > >>>> mass import pictures... I have figured that out with a script that > >>>> combines the functionality of imagemajicks convert function, used > >> through a > >>>> system call from gawk, multiplied over the various picture sizes, and > a > >>>> simple text file that enumerated what each picture's associated > >> productid > >>>> was in a line delimited fashion... > >>>> > >>>> I like running a simple text file through a script to automate these > >> ofbiz > >>>> functions as a much simpler way to do batch processing of jobs that > >> already > >>>> are a bit of a task, but having to go into each item and recieve > >>>> inventory... well.... i refurb printers and everyone that i strip > apart > >>>> yields about 20-40 parts... multiply that over approximately 20 > >> printers a > >>>> pallet... you get the idea i would ideally have a line delimited or > csv > >>>> delimited file that can be processed by gawk into an xml file that i > >> can do > >>>> the load-extdata call from ant with > >>>> > >>>> could i just create a ShipmentReceipt.xml and load that... it just > seems > >>>> like that is a marking of the transaction and not the transaction > >>>> > >> > >> > > |
ok so after many many hours and many many trials and errors... i finally
have an inventory import process that is including my image import process and the only thing needed for input is ONE very small csv file, and other files that are generated automatically from said csv file so i am happy... this will save my fingers and wrists countless pains through automation I wanted to include shipment receipt along with the item id and and item id details so i could see the various lots that i was adding of the incoming parts into the database fwiw the order for just those three ids is InventoryItem ShipmentReceipt InventoryItemDetail it must go in that way because of the key structure? idk but where can i look, i.e. what folder would kind of give me an idea of that tree structure, because i have an idea i will want to start including other things and it was pita to figure out that i couldnt have the same inventoryid twice but i could have the same receiptid as many times as i wanted, im sure there was some glorious reasoning for that, and maybe if i actually read the code i could semi understand it, but where could i go for a hint as to what some of the constraints are... or is this just a trial and error sort of thing thanks again Chris On Thu, Apr 9, 2015 at 4:53 PM, Chris Clark <[hidden email]> wrote: > i do get an invalid error or a long error that references the recieptId > being invalid > > On Thu, Apr 9, 2015 at 4:16 PM, Jacopo Cappellato < > [hidden email]> wrote: > >> >> On Apr 9, 2015, at 2:38 PM, Chris Clark <[hidden email]> wrote: >> >> > so for instance if i strip down for parts a model abc >> > and end up with parts (product ids) >> > abc100.... abc120 (20 parts total) >> > and assume i only want to deal with inventory for now, and not for >> > accounting (although i presume i am going to need to address the >> > accounting), then correct me if i am wrong >> > I do NOT have to create a shipmentreceipt >> > ONE new inventory item for EACH part # >> > also ONE new inventoryitemdetail for each part#? >> >> Correct: if you only want to deal with inventory, you can create one new >> inventory item and one new inventory item detail for each part# every time >> you receive it. >> For example, if you receive 10 units of abc100 on 2015-04-13 then you >> will create >> >> InventoryItem: inventoryItemId=10000, productId=abc100, >> datetimeReceived=2015-04-13 >> InventoryItemDetail: inventoryItemId=10000, >> inventoryItemDetailSeqId=0001, quantityOnHandDiff=10, >> availableToPromiseDiff=10 >> >> Then, when you receive 20 units of the same product on 2015-04-15 then >> you will create similarly: >> >> InventoryItem: inventoryItemId=10001, productId=abc100, >> datetimeReceived=2015-04-15 >> InventoryItemDetail: inventoryItemId=10001, >> inventoryItemDetailSeqId=0001, quantityOnHandDiff=20, >> availableToPromiseDiff=20 >> >> > >> > fwiw from what i have experienced with trial and error i have to create >> a >> > new AcctgTrans in order to even create a new ShipmentReceipt (receiptId) >> > entry >> >> This shouldn't be the case but let me know if you get this error again. >> >> Regards, >> >> Jacopo >> >> > >> > this is all new to me, but i have to say the ability to integrate this >> into >> > what i would call "shell transactions" is awesome as it allows us to >> forego >> > the gui and the repetitive movements that plague all us computer users >> > >> > On Thu, Apr 9, 2015 at 3:18 PM, Jacopo Cappellato < >> > [hidden email]> wrote: >> > >> >> Hi Chris, >> >> >> >> please see inline: >> >> >> >> On Apr 9, 2015, at 1:16 PM, Chris Clark <[hidden email]> wrote: >> >> >> >>> ive actually answered my own question... sort of... the key files that >> >> are >> >>> of importance from my research are >> >>> >> >>> AcctgTrans.xml >> >>> AcctgTransEntry.xml >> >> >> >> the above two entries are about General Ledger accounting transaction: >> >> AcctgTrans is the header and AcctgTransEntry are the Dr and Cr >> entries; if >> >> you are not planning to use accounting you could even skip them. >> >> >> >>> ShipmentReceipt.xml >> >> >> >> This represent the "document" for the receipt; the GL transactions are >> >> associated to this document. >> >> >> >>> InventoryItem.xml >> >>> and last but not least >> >>> InventoryItemDetail.xml >> >> >> >> You should create one new InventoryItem for each ShipmentReceipt; then >> you >> >> should also create the InventoryItemDetail with the initial units >> received; >> >> this will trigger a service that will update the >> >> InventoryItem.quantityOnHandTotal field. >> >> >> >> I hope it helps, >> >> >> >> Jacopo >> >> >> >>> >> >>> the first three are for the creation of the shipment transaction >> receipt? >> >>> im a little confused on this, but i know i cant add to the >> >> shipmentreceipt >> >>> without creating the receiptid in acctgtrans, and im not sure about >> the >> >>> acctgtransentry entries, if anyone can help please do... >> >>> >> >>> the latter two are specifically what i am more concerned with and >> that is >> >>> the on hand amount of each part, but is the acctg and ship receipt >> >>> necessary to just modify the on hand for the web store? >> >>> >> >>> any help on this is greatly appreciated >> >>> >> >>> Chris >> >>> >> >>> On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark <[hidden email]> >> wrote: >> >>> >> >>>> is there a way for me to import an xml file in a similiar fashion to >> the >> >>>> way i can import products from an external database to increase the >> >>>> inventory count... you may have seen my previous question about how >> to >> >>>> mass import pictures... I have figured that out with a script that >> >>>> combines the functionality of imagemajicks convert function, used >> >> through a >> >>>> system call from gawk, multiplied over the various picture sizes, >> and a >> >>>> simple text file that enumerated what each picture's associated >> >> productid >> >>>> was in a line delimited fashion... >> >>>> >> >>>> I like running a simple text file through a script to automate these >> >> ofbiz >> >>>> functions as a much simpler way to do batch processing of jobs that >> >> already >> >>>> are a bit of a task, but having to go into each item and recieve >> >>>> inventory... well.... i refurb printers and everyone that i strip >> apart >> >>>> yields about 20-40 parts... multiply that over approximately 20 >> >> printers a >> >>>> pallet... you get the idea i would ideally have a line delimited or >> csv >> >>>> delimited file that can be processed by gawk into an xml file that i >> >> can do >> >>>> the load-extdata call from ant with >> >>>> >> >>>> could i just create a ShipmentReceipt.xml and load that... it just >> seems >> >>>> like that is a marking of the transaction and not the transaction >> >>>> >> >> >> >> >> >> > |
Free forum by Nabble | Edit this page |