Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

What format of EDI file require for Import/Export ?

By
Zahin
on 7/16/13, 5:49 PM 6,623 views

Hello,

I want to import some of data/records from other business solution to OpenERP Via EDI.

Now I not found such pretty simple documentation for OpenERP EDI, where all steps are well written for Importing data to OpenERP via EDI

OR

Exporting data from OpenERP to EDI.

If someone expert or know EDI then Please share inputs.

1

AJ Schrafel Paper Corp

--AJ Schrafel Paper Corp--
2050
| 4 5 8
Bronx, United States
--AJ Schrafel Paper Corp--

Exploring OpenERP for business

AJ Schrafel Paper Corp
On 7/16/13, 6:16 PM

EDI in openERP means you can attach files to items in the database. Like attach an image of your suppliers acknowledgement to your PO in openERP.

It is not Electronic data interchange (EDI) https://en.wikipedia.org/wiki/Electronic_data_interchange

There might be a custom module out there for real EDI, but i don't know where to look.

If you want to import/export data to/from openERP you would be best served putting the data into a CSV

1

Ray Carnes

--Ray Carnes--
15677
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 7/16/13, 9:45 PM

The module is called EDI. - "Provides a common EDI platform that other Applications can use. OpenERP specifies a generic EDI format for exchanging business documents between different systems, and provides generic mechanisms to import and export them."

http://bazaar.launchpad.net/~openerp/openobject-addons/7.0/files/head:/edi/

It was working differently at 6.1 - some EDI features were replaced by the improved 7.0 portal.

For background, check out https://doc.openerp.com/6.1/it/book/3/3_6/invoice_payment/

I haven't checked out how it works at version 7.0, but from the release notes:

The EDI mechanism is mobilized when a user shares an OpenERP object (e.g. a sales quotation) with a customer. The mail message is the vehicle used to transmit the EDI file; a file that is signed with an auto generated key pair. The mail contains the link towards the object, allowing the customer to directly view that object in the originating OpenERP system.

Furthermore, the mail contains the JSON attachment, which permits the importation of the data into the target system. OpenERP 7.0 automatically adds the instructions explaining how to import the document.

Typically, the customer can click on the link to visualise the data in a form view. An accompanying EDI panel provides options to either import the EDI message using the URL or get the JSON data to perform a manual import.

Alternatively, the customer can proceed by forwarding the message to the generic email address of his OpenERP instance. When the latter receives the EDI message and accepts the authentication information of the originating instance, the file will be imported. When authentication fails, the EDI message is held in a queue, ready for the authorized administrator to either reject the message, accept it once or to approve it. In the last scenario, the key and the originating OpenERP instance identity will be stored in the receiving database, thus enabling automatic acceptance of future EDI message from that source.

According to OpenERP, "It is planned in 7.1 to provide a new EDI export system via email notification and attaching JSON EDI blobs to outgoing emails."

Not sufficient, OpenERP 6.0 EDI just a big jock, where as for OpenERP 7.0 EDI just small fun. Nothing work well, Does not seem good feature to auto/manual import EDI from other ERP. Does not manage different kind of EDI Versions. Famous version of EDI till does not support.

EDI with OpenERP Just Good Jock. Rather they doing fake advertisement of their feature, build right document for community and other people.

Official OpenERP does not maintain quality.

Zahin
on 7/17/13, 5:53 AM

how to do it with version 7? I want to import invoice as supplier invoice.

Nehal
on 4/24/14, 10:14 AM

@Nehal, OpenERP only support json edi documents so if you have different version of EDI then it seems not work.

Zahin
on 4/24/14, 11:11 AM

have you find any work around to do the same? as I am using version 7 of EDI.

Nehal
on 4/24/14, 11:18 AM
0
Jesper Carstensen
On 9/19/14, 6:22 AM

Hi. If you need real EDI (EDIFACT, X12, TRADACOM and others) to and from Odoo you can contact easyEDI. They have an App for Odoo that works with a SaaS. No knowledge about EDI required. Works with any business partner. Have a look here: http://easyedi.dk/solutions/easyedi-for-odoo/ 

Best regards
Jesper

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/16/13, 5:49 PM
Seen: 6623 times
Last updated: 3/16/15, 8:10 AM