Re: POS Integration: Step 1

1
Hi Jude / Olawale,

You can also post this on the developer forum, so that others can also benefit and we can share knowledge.

1. Direct database push is not recommended, a lot of validations and triggers are written inside the python app. 

2. The trasaction names and table names have a direct mapping - For example Sales Invoice has table `tabSales Invoice` and so on and so forth. You should just do some transactions from the client and then check the database for the impact.

best,
Rushabh

best,
Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 17-Jan-2013, at 8:39 PM, ju...@microtrainingrooms.com wrote:

Dear Rushabh Mehta,

we are working on integrating a POS system with ERPNext.

The POS application is a client - server application; so the plan is to create a Windows Services that will at intervals pick transactions from the database and post to ERPNext.

the easiest approach from our perspective is a direct database hit. these are the questions therefore

1. can we have direct connection to the database as against using the python api?
2. what are the tables (and columns) affected by various types of transactions (data dictionary)?



Thanks

Jude Mgbaka
Xavier Ltd (consulting developer)


–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

2

can you say me the integrating steps with erpnext

On Friday, January 18, 2013 8:01:33 PM UTC+5:30, rushabh wrote:
Hi Jude / Olawale,

You can also post this on the developer forum, so that others can also benefit and we can share knowledge.

1. Direct database push is not recommended, a lot of validations and triggers are written inside the python app. 

2. The trasaction names and table names have a direct mapping - For example Sales Invoice has table `tabSales Invoice` and so on and so forth. You should just do some transactions from the client and then check the database for the impact.

best,
Rushabh

best,
Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 17-Jan-2013, at 8:39 PM, jude....@microtrainingrooms.com wrote:

Dear Rushabh Mehta,

we are working on integrating a POS system with ERPNext.

The POS application is a client - server application; so the plan is to create a Windows Services that will at intervals pick transactions from the database and post to ERPNext.

the easiest approach from our perspective is a direct database hit. these are the questions therefore

1. can we have direct connection to the database as against using the python api?
2. what are the tables (and columns) affected by various types of transactions (data dictionary)?



Thanks

Jude Mgbaka
Xavier Ltd (consulting developer)


–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5e3374c0-fea5-4daf-9f74-c4308c5c8774%40googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
3
You can use web services to integrate with ERPNext

In version 3, use: 

https://github.com/frappe/wn-client/blob/master/wn_client/wn_client.py

On Thursday, March 6, 2014 5:56:44 PM UTC+5:30, Bhuvaneshwari S wrote:

can you say me the integrating steps with erpnext

–

Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/e54d084c-59ac-4a62-a3aa-1a680ee2dd7a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.