Skip to first unread message
Leonard Walletzký
Dec 13, 2017, 4:08:17 AM12/13/17
to iDempiere
HI,
is there any way how I can import the table structure into NInja Plugin - if I have Pack.zip with tables and want to put them into Ninja Plugin to create some advanced functionality. Or do I need to retype all their structure manually? Thank you!
Leonard Walletzký
redhuan d. oon
Dec 13, 2017, 9:10:13 PM12/13/17
to iDempiere
Leonard Walletzký
Dec 14, 2017, 10:01:28 AM12/14/17
to iDempiere
Great, thanks - also is there any description of Column Set syntax? Or any tool to design Column Set? Thanks!
Dne čtvrtek 14. prosince 2017 3:10:13 UTC+1 redhuan d. oon napsal(a):
Dne čtvrtek 14. prosince 2017 3:10:13 UTC+1 redhuan d. oon napsal(a):
redhuan d. oon
Dec 17, 2017, 8:41:27 PM12/17/17
to iDempiere
You can export out your custom made tables in the App Dictionary, into Excel format, then cull them accordingly as shown in examples of Ninja Hospital data sample or at this point onwards in the forum http://red1.org/adempiere/viewtopic.php?f=45&t=1831#p8826
After culling them i.e. L# for List, Y# for Yes/No, D# for Date, Q# for Quantity, A# for amount and T# for text, String is automatic without pre-text. Also beginning with 'Is' is auto Y#, 'Date; is auto D#.
The whole idea behind Ninja is to attract Excel users handling their large data user sets, allowing fast import of their migration data and auto table modelling. The only drawback is i kept is so light and maintainable (for me at least) that i do away with too much spell checking. So please double check your spelling particularly if it looks up core tables. One typo mistake Ninja shall create entirely new tables and you have to manually delete them (Ninja Delete Model may help but not guaranteed).
Ninja is also powerful in custom module architecture, as it forces non touching of core, and visibility in agile resuability. It shall replace 2Pack soon. I intend to make it into a visual wizard if work permits.
After culling them i.e. L# for List, Y# for Yes/No, D# for Date, Q# for Quantity, A# for amount and T# for text, String is automatic without pre-text. Also beginning with 'Is' is auto Y#, 'Date; is auto D#.
The whole idea behind Ninja is to attract Excel users handling their large data user sets, allowing fast import of their migration data and auto table modelling. The only drawback is i kept is so light and maintainable (for me at least) that i do away with too much spell checking. So please double check your spelling particularly if it looks up core tables. One typo mistake Ninja shall create entirely new tables and you have to manually delete them (Ninja Delete Model may help but not guaranteed).
Ninja is also powerful in custom module architecture, as it forces non touching of core, and visibility in agile resuability. It shall replace 2Pack soon. I intend to make it into a visual wizard if work permits.
Reply all
Reply to author
Forward
0 new messages