Problem importing Products from CSV file

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

Problem importing Products from CSV file

Postby gaurav » Fri Nov 25, 2005 7:33 pm

Hi
I have created new Import File Loader Format to import Products with lines as follows

Name Column name
A-Key Value_SearchKey
B-Name Name_Name
C-UOM C_UOM_ID_UOM
D-Description Description_Description
E-Product Type ProductType_ProductType

now when i import products using this loader it gives me error "ERR=Invalid BPartner," where the fileds of C_BPARTNER_ID , BPARTNER_VALUE can accept null value and are not madatory in table I_Product.....
Please tell me then why am i getting this error.....I do not want to import Business Partner from CSV file.
Please help.
Thank You

Regards,
Gaurav
ViennaSolutions.com
gaurav
 
Posts: 38
Joined: Wed Aug 03, 2005 2:48 pm

Postby red1 » Wed Dec 14, 2005 8:13 am

When u use the Import Products, the system will definitely check and map to the Business Partners first. U have to import Business Partners first. Otherwise u modify the ImportProduct.java not to check for valid BP IDs. But this is bad for the system as it assume that each Product's Vendor is a valid BP.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia


Return to Ask RED1 personally

Who is online

Users browsing this forum: No registered users and 3 guests

cron