Importing Transactions

[Kevin Tan]

Hi Everyone,

Is there any way to import mass transactions (S/O, invoices, Quotations, P/Os etc)? Understand that the product (import tool) does not come with it.

Many thanks. :)

[Maxwell Morais]

Hello, Kevin!

I have an custom method to import this DocTypes, in my organization, we have two system running simultaneous  and with scripts using splinter[1], with this, we loading the data from first system to ERPNext.

The mechanism to do this is very simple, you only create the script for the each DocType, and create a mechanism to log the state of transition between the systems.

[1] spliter http://splinter.cobrateam.info/

[Rushabh Mehta]

Max,

This is cool, never heard of it. How stable is it?

It will be great if you can share some sample code. It might help others to push data into ERPNext in a different way. The other way is the API https://gist.github.com/rmehta/5418237

best,

Rushabh

--
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...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.

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

--

https://erpnext.com

Twitter: @rushabh_mehta

[Maxwell Morais]

Hello, Rushabh!

This is the example for transition of Lead.

https://www.dropbox.com/s/frwtvr46zdmkmgg/Digitador.py

Works fine! Sometimes, we refactored the code, because of our and yours updates, but, the concept, is based on tools for test of software, we looking a plan to create a custom DocType to manage the data transition between external and supplier systems.

We based the mechanism on splinter, but we know one method more easily, with the salad tool, this is support the scripts in natural language.

https://github.com/salad/salad

2013/5/14 Rushabh Mehta <rme...@gmail.com>

--

Maxwell Morais
(+55 11) 3931-1412 Ramal 31
 www.realizemodulados.com.br

[Rushabh Mehta]

Max,

This is great, but I would still recommend using the API using web requests and JSON. First, its a lot cleaner and we are due a major rewrite of the client app in the coming months or so (making it responsive on different devices + the architecture needs an upgrade) so your connector might need some updates.

btw, this might be good for testing.

best,

Rushabh

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

[Maxwell Morais]

Thanks Rushabh for you feedback, I understand the stability of API, but because of my supply chain, this mechanism is the major form to automate te process and reduce the re-input.

Each supplier have a custom system to manage yours Purchase Requests, actualy our have 15 suppliers, if our re-input the data manually from my system to supplier Purchase Request system, the time elapsed in this works is very long, and have a big probality of error.

And more, my old system don't contains an API, because this the choice.

2013/5/15 Rushabh Mehta <rme...@gmail.com>