Importing Payments

For those who ventured too far - just hope they know their way back :)

Moderator: neilg

Importing Payments

Postby chris » Wed Oct 05, 2005 6:59 pm

I want to import payments into compiere. I am using Compiere 2.5.1 c. Could anybody please suggest me how we can do this and which tables to use while importing as I am new to this Compiere?
chris
 
Posts: 15
Joined: Wed Oct 05, 2005 6:54 pm

Postby lofx » Wed Oct 05, 2005 7:33 pm

Hi!!!

i suggest you to take a look at the code and database structure already present in compiere. Basically, you will need an intermediate table I_payments (for instance) and the X_I_payments.java file, that you can "copy" from the already existing ones.
From there, you can create the window to see what you imported, and create a process run from a complete button to import into the final table the imported data

oh, and you have to create an import format to tell the data loader into which table you are first importing the data and the order of the csv file in respect with the table fields.

i am afraid i may have not been very clear, i suggest you to start trying and we will little by little start solving small doubts

Regards,
lofx
Regular
 
Posts: 86
Joined: Fri Sep 24, 2004 11:55 pm

Postby chris » Wed Oct 05, 2005 9:50 pm

Hi!!!
Thanks for your mail. There is a I_Payment already in the compiere database. I created an Example Payment in the compiere through Import Format. The data is entering into the Intermediate table i.e. I_Payment table. I believe that we need to write a callout so that we could import the data from the Intermediate table to the compiere database table.

The following are the fields which are there in I_Payment:

Name Type Nullable Default Comments
------------------ --------------- -------- ------- --------
1. I_PAYMENT_ID NUMBER(10)
2. AD_CLIENT_ID NUMBER(10) Y
3. AD_ORG_ID NUMBER(10) Y
4. ISACTIVE CHAR(1) Y 'Y'
5. CREATED DATE Y SYSDATE
6. CREATEDBY NUMBER(10) Y
7. UPDATED DATE Y SYSDATE
8. UPDATEDBY NUMBER(10) Y
9. I_ISIMPORTED CHAR(1) 'N'
10. I_ERRORMSG NVARCHAR2(4000) Y
11. PROCESSED CHAR(1) Y 'N'
12. C_PAYMENT_ID NUMBER(10) Y
13. DOCUMENTNO NVARCHAR2(60) Y
14. DATETRX DATE Y
15. ISRECEIPT CHAR(1) Y 'Y'
16. C_DOCTYPE_ID NUMBER(10) Y
17. DOCTYPENAME NVARCHAR2(120) Y
18. TRXTYPE CHAR(1) Y
19. C_BANKACCOUNT_ID NUMBER(10) Y
20. BANKACCOUNTNO NVARCHAR2(40) Y
21. C_BPARTNER_ID NUMBER(10) Y
22. BPARTNERVALUE NVARCHAR2(80) Y
23. C_INVOICE_ID NUMBER(10) Y
24. INVOICEDOCUMENTNO NVARCHAR2(60) Y
25. TENDERTYPE CHAR(1) Y
26. CREDITCARDTYPE CHAR(1) Y
27. CREDITCARDNUMBER NVARCHAR2(40) Y
28. CREDITCARDVV VARCHAR2(4) Y
29. CREDITCARDEXPMM NUMBER(10) Y
30. CREDITCARDEXPYY NUMBER(10) Y
31. MICR NVARCHAR2(40) Y
32. ROUTINGNO NVARCHAR2(40) Y
33. ACCOUNTNO NVARCHAR2(40) Y
34. CHECKNO NVARCHAR2(40) Y
35. A_NAME NVARCHAR2(120) Y
36. A_STREET NVARCHAR2(120) Y
37. A_CITY NVARCHAR2(120) Y
38. A_STATE NVARCHAR2(80) Y
39. A_ZIP NVARCHAR2(40) Y
40. A_COUNTRY NVARCHAR2(80) Y
41. A_IDENT_DL NVARCHAR2(40) Y
42. A_IDENT_SSN NVARCHAR2(40) Y
43. A_EMAIL NVARCHAR2(120) Y
44. VOICEAUTHCODE NVARCHAR2(40) Y
45. SWIPE VARCHAR2(80) Y
46. ORIG_TRXID NVARCHAR2(40) Y
47. PONUM NVARCHAR2(120) Y
48. C_CURRENCY_ID NUMBER(10) Y
49. PAYAMT NUMBER Y 0
50. DISCOUNTAMT NUMBER Y 0
51. WRITEOFFAMT NUMBER Y 0
52. ISOVERUNDERPAYMENT CHAR(1) Y 'N'
53. OVERUNDERAMT NUMBER Y 0
54. C_CHARGE_ID NUMBER(10) Y
55. CHARGENAME NVARCHAR2(120) Y
56. CHARGEAMT NUMBER Y 0
57. TAXAMT NUMBER Y 0
58. ISAPPROVED CHAR(1) Y 'N'
59. ISSELFSERVICE CHAR(1) Y 'N'
60. ISDELAYEDCAPTURE CHAR(1) Y 'N'
61. R_PNREF NVARCHAR2(40) Y
62. R_RESULT NVARCHAR2(40) Y
63. R_RESPMSG NVARCHAR2(120) Y
64. R_AUTHCODE NVARCHAR2(40) Y
65. R_INFO NVARCHAR2(4000) Y
66. PROCESSING CHAR(1) Y

If i enter some data thru import payment window, I could see that data is being imported to the intermediate table. what should be my approach after this ?

I think I need to write a callout and place it in org.compiere.Process. I am not clear at this point. I need your guidance.

Thanks in advance.
chris
 
Posts: 15
Joined: Wed Oct 05, 2005 6:54 pm

Postby chris » Wed Oct 05, 2005 10:00 pm

I need to import payments into compiere relating sales of certain items. For this, I even need to import details like Product, Quantity, Price of each item. Do I need to alter the I_Payment table for this purpose? If so, will it may arise some more problems or not? Or Could I send data to more than one tables after importing into an Intermediate table?
chris
 
Posts: 15
Joined: Wed Oct 05, 2005 6:54 pm

Postby trifon » Thu Oct 06, 2005 2:54 am

chris wrote:I need to import payments into compiere relating sales of certain items. For this, I even need to import details like Product, Quantity, Price of each item.

Yuo need to import Products, Quantity and price prior importing payments.

chris wrote:Do I need to alter the I_Payment table for this purpose?

No, You have to use other I_Xxx tables.


chris wrote:If so, will it may arise some more problems or not?

It depends how you modify import process.
Unfortunately with Callouts you will fail to import anything. You need to modify import sources.

chris wrote:Or Could I send data to more than one tables after importing into an Intermediate table?

Yes, in import process you can send data to more than one table. In many cases you need to normalize yuor data.

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


Return to Strictly Technical

Who is online

Users browsing this forum: No registered users and 2 guests