New Packaging System for Compiere (AD Exporter/Importer!)

For those who got the Open Source fever, sharing only makes you hot!

Moderator: neilg

New Packaging System for Compiere (AD Exporter/Importer!)

Postby robert » Mon Mar 27, 2006 3:26 pm

I've just released a new packaging system called 2Pack. 2Pack is designed to allow users to transfer/migrate custom objects and data created in Compiere to other Compiere instances. Such as the Fixed Asset Extension which can be download at http://sourceforge.net/projects/cfa.

Features of 2Pack include:
Seamless integration into Compiere
Simple to use
Easy to install
Supports versions 252d-253b
Packages created are self-contained
Automatic generation of install instructions
Provides ability to roll-back installed packages
Provides ability to import packages directly in Compiere
Supports exporting custom dictionary settings and java code

2Pack can be found at http://sourceforge.net/projects/twopack .

Please give it a try and let me know what you think.

THANKS!
Rob K.
robert
 
Posts: 6
Joined: Wed Mar 08, 2006 8:35 pm

Postby Mr_reggatta » Mon Mar 27, 2006 11:39 pm

Hi Robert!
It's possible to use your 2pack project for creating new tables and windows?
If yes...how can i do?
Thanks in advance...
mr_reggatta (italy)
Mr_reggatta
 
Posts: 24
Joined: Wed Mar 15, 2006 12:34 am
Location: Roma, Italy

Postby robert » Tue Mar 28, 2006 7:36 am

It's possible to use your 2pack project for creating new tables and windows?
If yes...how can i do?


Actually you create the tables and windows directly in Compiere as you normally would. 2Pack allows you to export those new windows and tables, along with fields and columns, references and everything else in a self contained package. You can then distribute the package to other Compiere instances.

The documentation for 2pack has been posted to the project.


Hope that helps.
Robk
robert
 
Posts: 6
Joined: Wed Mar 08, 2006 8:35 pm

Postby Mr_reggatta » Tue Mar 28, 2006 4:39 pm

Great Robert !

Now I've understood !!!

robert wrote: Actually you create the tables and windows directly in Compiere as you
normally would.
Robk


Last questions:
-What's the best way to do this?
-What about this way to create tables and windows?
http://hemsidor.torget.se/users/m/Murphy/compiere/
-I have the italian 2.5.3b compiere version... Can 2pack normally work?
thank you in advance
regards
mr_reggatta
Mr_reggatta
 
Posts: 24
Joined: Wed Mar 15, 2006 12:34 am
Location: Roma, Italy

Postby robert » Wed Mar 29, 2006 12:36 pm

Mr_reggatta wrote:Great Robert !

Now I've understood !!!

robert wrote: Actually you create the tables and windows directly in Compiere as you
normally would.
Robk


Last questions:
-What's the best way to do this?
-What about this way to create tables and windows?
http://hemsidor.torget.se/users/m/Murphy/compiere/
-I have the italian 2.5.3b compiere version... Can 2pack normally work?
thank you in advance
regards
mr_reggatta


Ok.
-What's the best way to do this? There are many different ways.
- What about this way to create tables and windows? I used this method to learn how to modify Compiere when I started. What I've found works for me is to:
1.) Go in OEM and create a table with the fields as needed.
2.) Sign in to Compiere and import the table from the database.
3.) Adjust the necessary settings such as Parent Link, Updateable, Identifier or Reference.
4.) Resync Column for each column modified.
5.) Go to Window, Tab and Field
6.) Create a window
7.) Go to Tab tab fill out as needed and click Create Fields. This will create the fields from the Table as defined in previous steps
8.) Go to Field tab and adjust as needed. (described in example)
9.) Add new window to menu.

After you get the hang of it, its pretty simple. But I'm sure everybody has their own way.

-I have the italian 2.5.3b compiere version... Can 2pack normally work?
I tested it with 2.53b but I've only tried it on the CSV download. Please let me know how it goes if you try it.

Good Luck!
Rob
robert
 
Posts: 6
Joined: Wed Mar 08, 2006 8:35 pm

Postby Mr_reggatta » Wed Mar 29, 2006 8:59 pm

Robert,
thanks a lot...
I will try all of this and then I will let you know...
see you soon
regards
mr_reggatta
Mr_reggatta
 
Posts: 24
Joined: Wed Mar 15, 2006 12:34 am
Location: Roma, Italy

Postby Mr_reggatta » Tue Apr 04, 2006 12:14 am

Hi rob!

How can i do the second step ?

2. Sign in to Compiere and import the table from the database.

thank you
regards
Mr_reggatta
 
Posts: 24
Joined: Wed Mar 15, 2006 12:34 am
Location: Roma, Italy

Brilliant...

Postby neilg » Tue Apr 04, 2006 3:34 am

I just read through the docs haven't had a chance to apply it yet and see how it works.

However this is what the compiere world has been desperately looking for... imagine sending someone your xml extension via email and they see almost immediately what you have done, never mind the vertical markets this will open up.

If it does what it says it does why doesn't Jorg incorporate it into Compiere?
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Postby red1 » Tue Apr 04, 2006 10:24 am

I guess the same reason why God created women but didnt give us free sex.

We have to sweat for it! HAHA! :))
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby Mr_reggatta » Tue Apr 04, 2006 4:30 pm

Uahuaaaaa !!!
:lol: :lol: :lol:
Mr_reggatta
 
Posts: 24
Joined: Wed Mar 15, 2006 12:34 am
Location: Roma, Italy

How to generate a db table in Compiere

Postby robert » Tue Apr 04, 2006 9:07 pm

Mr_reggatta wrote:Hi rob!

How can i do the second step ?

2. Sign in to Compiere and import the table from the database.

thank you
regards



Ok lets give it a try....

Sign in as Administrator
Go to Application Dictionary Menu
Go to Table and Column Application
Create a new record for the table
Fill in the DB Table Name
Fill in Name
Add description of table
Add any comments
Click the "Create Columns from DB"

Thats step 2...

Rob
robert
 
Posts: 6
Joined: Wed Mar 08, 2006 8:35 pm

Postby Mr_reggatta » Tue Apr 04, 2006 9:36 pm

yessss sorry... it was very simple...

:oops: :oops: :oops:

now i have my new X_Friends window... it works very good...
I'm happy...
this is my first little customization...
very happy!!!
:lol: :lol: :lol:

Now... next steps...
how can export my little customization (X_Friends, Friends window) in other
compiere istances?
Robert, can I use the 2pack tool even thought having modified in this way ?
Mr_reggatta
 
Posts: 24
Joined: Wed Mar 15, 2006 12:34 am
Location: Roma, Italy

Postby robert » Wed Apr 05, 2006 3:25 pm

Mr_reggatta wrote:Now... next steps...
how can export my little customization (X_Friends, Friends window) in other
compiere istances?
Robert, can I use the 2pack tool even thought having modified in this way ?


Sure, not a problem.
Rob
robert
 
Posts: 6
Joined: Wed Mar 08, 2006 8:35 pm

Postby red1 » Fri Jun 16, 2006 5:06 pm

Hi Rob,
I ask Trifon to look thru POPI and weter its replacement for XML2AD, and this is his reply,
Hi Red1,

i will describe to you first.
Could you post it.

POPI is not replacement of XML2AD.

POPI (2Pack) and XML2AD have different ideas for transferring customizations.

POPI export everything from AD and import it into new instance.

"XML2AD childe" which i support is based on Druid and XML2AD. In fact in new version i chnaged the name to AD Customization Keepr, as i start using DOM XML parser and i started developing of Plugin based architecture for customization transfer. In fact this is entirelly new application, but it still uses old XML2AD in order to transfer model.xml and view.xml. I started developing plugins for transfer of data changes stored till not in data.xml. But in future i will move all xml to new architecture as i with Plugins i can handle version dependency which allows me to support multiple versions of Compiere. Also with Plugin architecture developers do not need to modify sources of XML2AD, but just need to create new plugin which imports given table.

You can find example Plugin in this CVS tree:
http://comxe.cvs.sourceforge.net/comxe/ ... -TEMPLATE/

Regards,
Trifon
However i see that Trifon's still didnt say y POPI if it exports everyting in AD, isnt that what XML2AD tries to do? Bob has said that he started with XML2AD but find limitations.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby trifon » Fri Jun 16, 2006 5:37 pm

>However i see that Trifon's still didnt say y POPI if it exports everyting in AD, isnt that what XML2AD tries to do?

No. This is not the main target of XML2AD. Main aim for me is to have conviniet way to know what is changed in Compiere DB and AD for every customization/project.

With Druid and XML2Ad i can do it as i can see visually in Druid wich tables/column are changed and from the xml files which windows, tabs, fields are changed.

XML2AD still do not have export all functionality. In fact i started developing export functionality in last months and export functionality is still limited.
I can export definition of windows, tabs, fields and other tables.

Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

Postby robertk » Sat Jun 17, 2006 6:40 pm

As far as comparing capabilities of XML2AD to 2Packs(formally POPI), I'm not the best person for that. I have not really looked at XML2AD since 2004 and I'm sure Trifon has improved and expanded its capability.

But I can recap what 2Packs goal and capabilities are:

The goal of 2Pack is to make customizations and data migration easily portable and available to all Compiere Users.

In striving to achieve this goal the current release of 2Pack - Version 005:
    Exports all AD Settings for a particular object(s) in Compiere whether its an application, report, table, menu, role, data or others.
    Exports are done internally with in Compiere. No other software needed.
    Creates a self-contain, standalone compressed package that is portable to other Compiere instances.
    Allows the developer to transfer .java and other external files, such as documents. These files are contained in the package.
    The package supports multiple Compiere versions.
    Imports not only create needed dictionary settings for the exported customization but also creates the necessary database columns, tables, functions or other items as required.
    Provides installation logs.
    Records and backup original dictionary settings and files during installation. This allows the package to be rollback if necessary.

In the next release of 2Pack - Version 006:
    2Pack and other packages can be installed to a Pre-compiled Compiere installation. Compiling or modifying Compiere source code is no longer necessary.
    Packages can be distributed with or without source code(pre-compiled jar).
    Installation has been made much simpler.
    Packages are much smaller. (Example FA Extension is now 600k - originally 5,000k)
    Ability to scan for new packages via a web service. Packages found can be installed directly from the web. (aka Eclipse style) This web service will be made widely available to all users and web administrators to include on their sites. In addition I will be adding the ability to have both a public and private service for firms that want to support their clients via web access.
    Current work is being done on providing the ability to transfer a clients master or transactional data in a package. In addition a client can be transformed to new client by simply specifying a new client name.
    Finally exportation of Application Dictionary settings over groups of tables by client or by date changed.

Additions to be included in 2Pack - Version 007:
    2Packs code will be refactored.
    Easier access for developers to extend 2Pack.

Thanks
Rob
robertk
 
Posts: 6
Joined: Thu Dec 30, 2004 8:11 am

Postby trifon » Sat Jun 17, 2006 7:14 pm

Hi Rob,

Thank's fot this detailed description.

I'm very glad to know and to see that 2Pack is moving and showing good progress.

I have one question.

Could i export only changed objects?

I mean if i add new column in AD_Role for example could i export sql statement, redorc in AD_Column, AD_field?

Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

Postby robertk » Mon Jun 19, 2006 10:11 am

Hi Trifon,

For the current release:
Yes you could simply use a SQL select statement to export those changes while in 2Pack however I use that for data transfers. My preference is to export the window and table objects, that would as default, only install your new user defined settings. Finally you could use what I call "an application export" that would export the window, table and menu settings. With the last two methods it would include all supporting objects like references, elements and setup any database objects required like the new column. Again the default for 2Pack is to install only user defined settings however you could set the flag installing/updating all other defined settings.

Next release 006:
A new feature would allow a user to export settings based on dates or clients for groups of tables. This I think would be effective in Client migrations or other AD migrations.

Future release 007:
I didn't mention it above but I will be working on capturing changes for user selected tables. These changes would be stored in a table while the user is making them. The user/administrator could then package these changes and promote them to a new environment or simply save for later use.


Hope this help! Take care.
Rob
robertk
 
Posts: 6
Joined: Thu Dec 30, 2004 8:11 am

support for 2.5.3c?

Postby ptb » Thu Jul 13, 2006 9:06 pm

I'm very interested in using one of these products but I need them to work with 2.5.3c. Based on my needs - I want to export custom table/column, window/tab/field, print form, import loader table definitions from one compiere development system to my clients pilot compiere installation - I'm thinking 2Pack is what I should be looking at. Rob, do you have planned dates for the releases you mention here, and does one of them include supporting 2.5.3c?

Trifon - if you think XML2AD would address this need as well, please let me know. From your description I didn't think so but perhaps I misunderstood... If so, then does your version of XML2AD support 2.5.3c?

Thanks to you all,
Peter
ptb
 
Posts: 4
Joined: Wed Apr 05, 2006 7:23 pm
Location: Massachusetts, USA

Postby trifon » Thu Jul 13, 2006 9:10 pm

Hi Peter,

Yes, my version is intended for development and currently export functionality is not so good as 2Pack.

Main advantage of my version i call it AD Customization Keeper is that developer uses Druid in order to store information for Tables, column, AD_Tables and other AD emlements in one central place [Druid]. From Druid i just export in proper format usable for import into Compiere AD and for SQL update of structure of DB.

New version is plugin based and supports 2.5.3c.

Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

Postby ptb » Thu Jul 13, 2006 10:46 pm

Hi Trifon,

Thanks for the quick reply...

Interesting approach. So what can I define in Druid (and export for import into Compiere) besides tables and columns? Windows/Tabs/Fields? What about Elements, Print Forms and Import loader formats?

This might work for me. Can you point me to a current version? Any documentation?

Thanks again,
Peter
ptb
 
Posts: 4
Joined: Wed Apr 05, 2006 7:23 pm
Location: Massachusetts, USA

Postby trifon » Thu Jul 13, 2006 11:37 pm

Hi,

In Druid currently AD_Table, AD_Column and information for AD_Reference.

I tried to put infomration for AD_Window, AD_Tab and AF_Fieldm but i didn't had time to finish it. :( So currenly xml file for view is created manualy.

Look at comXe project: https://sourceforge.net/project/showfil ... _id=162328

But please look at CVS Server.
Tehre you will find compilo folder:
http://comxe.cvs.sourceforge.net/comxe/compilo/

All this projects store AD modifications.
Except TEMPLATE.

The biggest is _Project-ID-ComXe_Standard.

You need to take druid project from:
http://comxe.cvs.sourceforge.net/comxe/tools/

Currenlt documenation is very small as noone support me to do all this work and i make it during the project when i need some functioality...

>What about Elements, Print Forms and Import loader formats?
Elements are supported.
In HEAD of ComXe you can find import of Loader Formats.

Well for Print formats, i ask for money as i need to live from something.
I mean i have functionality which can import print formats, but i provide it as paid. Sorry for this, but i need to make money too.


Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

2Pack supporting 253c

Postby robertk » Fri Jul 14, 2006 1:47 pm

Hi Peter,
I'm running tests against 253c right now with no issues. (Ok last time I checked) I usually try to wait until Compiere releases a stable version before releasing a new version of 2Pack or the FA Extension. I soon hope to release a 2Pack version that will be neutral making it easier for everyone.

If you want to test what I've done to date I can whip up a package for you to test it out. 2Pack should cover your needs pretty well. Contact me via www.oslabs.org and let me know.

Thanks!
Rob
robertk
 
Posts: 6
Joined: Thu Dec 30, 2004 8:11 am


Return to Contributor's Corner

Who is online

Users browsing this forum: No registered users and 2 guests

cron