Difference between revisions of "OSGI HengSin/File2PackZip"
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
m (→Exporting As Excel) |
m (→Exporting As Excel) |
||
Line 86: | Line 86: | ||
*When you select the File Save As > Type as Excel you can click on X so as to get all records. | *When you select the File Save As > Type as Excel you can click on X so as to get all records. | ||
*But the Export only export the current record backwards. So you need to be at the last record to get all. See results below: | *But the Export only export the current record backwards. So you need to be at the last record to get all. See results below: | ||
− | [[Image:FileExportExcel.png|thumb|650px|Excel format export for Business Partner window main tab. Go to the last record and decline single record | + | [[Image:FileExportExcel.png|thumb|650px|Excel format export for Business Partner window main tab. Go to the last record and decline single record choice.]] |
[[Category:Projects and Tools]] | [[Category:Projects and Tools]] |
Revision as of 03:21, 28 December 2010
Contents
Data Portability On Demand
- I think we have found our holy grail of data agility in ERP.
- Imagine able to export out any table in the window you are at for another person on another system with easy clicks.
- Imagine able to go to another remote ADempiere instance and put back your table without an import loader!
- Imagine keeping your data truly backup without dependence on the Database been there!
- Imagine having your backup tables portable and readable as an XML or Excel formats at the same time!
- This is a very convenient tool in any window. Just by selecting File > Export, you can export all the records of the Window you are looking at.
- You have a choice to export as an Excel or 2Pack format.
- You can export the single record in focus or all the records in the window.
- You can select the target directory to save the file in and give it a unique name for easy managing later.
- All this is tested on the latest OSGI HengSin codebase.
PackOut.xml
- Following is a sample output of a single record i exported from my just PackIn Flight Schedule Module.
<?xml version="1.0" encoding="ISO-8859-1"?> <adempiereAD Name="IS_Schedule" Version="1.0.0" AdempiereVersion="Release 3.6.0LTS @ 2010-06-14" DataBaseVersion="2010-06-14" Description="" Author="SuperUser" AuthorEmail="" CreatedDate="Tue Dec 28 16:13:04 MYT 2010" UpdatedDate="Tue Dec 28 16:13:04 MYT 2010" PackOutVersion="100" Client="11-GardenWorld-GardenWorld"> <IS_Schedule type="table"> <AD_Org_ID>@AD_Org_ID@</AD_Org_ID> <Description>AK1010</Description> <Destination>KLI</Destination> <Details>BangkokKuL</Details> <IS_Schedule_UU>29b03832-499d-4ea5-9337-be9ba812fea0</IS_Schedule_UU> <IsActive>true</IsActive> <Name>AK101</Name> <Origin>BKK</Origin> <Value>1000000</Value> </IS_Schedule> </adempiereAD>
What about a Master-Detail window?
- Can this work for whole window with multi-tabs such as Business Partner Window or let's say a Sales Order that has OrderLines?
- The answer is YES! See the PackOut.xml extract for a Sales Order below:
... <PriceList>22.73</PriceList> <Processed>true</Processed> <QtyAllocated>0</QtyAllocated> <QtyDelivered>10</QtyDelivered> <QtyEntered>10</QtyEntered> <QtyInvoiced>10</QtyInvoiced> <QtyLostSales>0</QtyLostSales> <QtyOrdered>10</QtyOrdered> <QtyReserved>0</QtyReserved> <RRAmt/> <RRStartDate/> <Ref_OrderLine_ID reference="id"/> <S_ResourceAssignment_ID/> <User1_ID reference="id"/> <User2_ID reference="id"/> </C_OrderLine> <C_OrderTax> <AD_Org_ID>@AD_Org_ID@</AD_Org_ID> <C_OrderTax_UU>11bd9ac1-70db-4018-ac5c-9feec2b135ef</C_OrderTax_UU> <C_Order_ID reference="id">108</C_Order_ID> <C_Tax_ID reference="id">105</C_Tax_ID> <IsActive>true</IsActive> <IsTaxIncluded>false</IsTaxIncluded> <Processed>true</Processed> <TaxAmt>12.95</TaxAmt> <TaxBaseAmt>215.9</TaxBaseAmt> </C_OrderTax> </C_Order> <C_Order type="table"> <AD_Org_ID>@AD_Org_ID@</AD_Org_ID> <AD_OrgTrx_ID reference="id"/> <AD_User_ID reference="id"/> <AmountRefunded/> <AmountTendered/> <Bill_BPartner_ID reference="id">112</Bill_BPartner_ID> <Bill_Location_ID reference="id">108</Bill_Location_ID> <Bill_User_ID reference="id"/> ...
- Note the existence of 3 tabs within the xml tags.
Exporting As Excel
- When you select the File Save As > Type as Excel you can click on X so as to get all records.
- But the Export only export the current record backwards. So you need to be at the last record to get all. See results below: