adding columns to the intermidiate tables for import

To err is to be human, to help each other is joy. Tell your Compiere needs in your own words. Let's figure out together.

Moderator: azaharizaman

adding columns to the intermidiate tables for import

Postby bobbydada » Wed Mar 30, 2005 9:02 pm

Hi red1,
I am a very new user of compiere, and using version 252a , I am facing 2 problems at the moment
1. The compiere is installed on a red hat 3.0 advance server and on that m/c I am able to connect to both the application server and the databse server, but the all the client m/c are not able to access the application server, though the database connection is OK, this problem was not there when I installed 251g initially.for some time

2. while importing the data like that of business partner, the data first go to an intermidiate table i.e. I_BPARTNER, we can add the columns like sales rep, credit limit to the table if required, then we can log into the compiere as system -> go to Table & Column --> press ADD COLUMN FROM DB to create the column, then on the column tab we can sync the column with an existing system element.

now my problem is that after doing all the above mentioned things, the data for the added columns does gets loaded into the intermidiate table which is visible in the load BP window, but when I import the data from the import window it does not appear in the business partner window. it happens only for the columns which are added new in the I_BPARTNER table, for the existing columns the data gets imported.

Could U please show me the way, for the above said problems, I am sorry for such a big mail , but really I am in a fix .
thanks a lot and regards
Posts: 7
Joined: Wed Mar 30, 2005 8:29 pm
Location: Mauritius

Postby trifon » Wed Mar 30, 2005 11:27 pm

Hi bobbydada,

Unfortunately this what you have done is not enough to import required data into Compiere.

You need to modify source codes (org.compiere.process.ImportBPartner in your case).

Please tell me which fields do you need to import and I will make source code changes if you do not know Java.

Last edited by trifon on Thu Mar 31, 2005 10:06 pm, edited 1 time in total.
Trifon Trifonov
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

thanks trifon

Postby bobbydada » Thu Mar 31, 2005 9:52 pm

Thanks a tons trifon. I would definetly mail U abt the columns to be added.
Posts: 7
Joined: Wed Mar 30, 2005 8:29 pm
Location: Mauritius

Postby red1 » Fri Apr 01, 2005 12:25 am

Hi Bobby,
Pls organise your requests online so that others can understand the whole picture and appreciate what Trifon is doing for u.
Otherwise u have to pay for Trifon's private service. ;)
Its also up to Trifon to accept it offline. I do not impose any strict rule on such matter, as contributors are free to solicit.
Trifon is a highly capable Compierean if u wana know. :)

Site Admin
Posts: 2762
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby bobbydada » Fri Apr 01, 2005 9:30 pm

Hi red1,
yup, I will do it online only. I have not posted the things uptill now coz I got occupied with some more accounting problems.
And thank U for this forum and what U R doing for open source movement, HATS OFF !!!
Posts: 7
Joined: Wed Mar 30, 2005 8:29 pm
Location: Mauritius

Return to Ask RED1 personally

Who is online

Users browsing this forum: No registered users and 1 guest