CSV to ORDERS05 idoc SAP

[Utkarsh Mittal]

Hello All,

I am a newbie to EDI-BOTS. I stumbled on to it from a 10 year old thread discussing conversion of a csv to SAP-compatible ORDERS05 idoc file. (https://groups.google.com/g/botsmail/c/5VgnGqLIJG8)

However, since the thread is quite outdated, I am asking for any help to get started with this mini project of converting my CSV file which contains order data extracted from a PDF to be converted to idoc (ORDERS05) so that it can be accepted by SAP.

Thanks in advance.

Best Regards,

Utkarsh

[Kbsof edi engine WARE]

Are you using bots for your company for edi translation? 

Or just would like to learn edi using bots?

Thanks,

Yasir

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/botsmail/e9241889-d0cd-45ed-b182-d5b3c7d9c020n%40googlegroups.com.

[Utkarsh Mittal]

Hello, thanks for your response.

At the moment, we are not using EDI BOTS. Over the past 4 years we have built our own in-house solutions for most of our EDI needs, but as we expand, EDI BOTS looks interesting and promising. So we would like to start using it. And this little project seemed like a good starter objective to get familiar, which is also a current need for us which is not solved by our current internal solutions.

Thanks
Utkarsh

You received this message because you are subscribed to a topic in the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/botsmail/1_JNPjm3LeE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to botsmail+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/botsmail/CA%2BXkmRRce8B646H-KvR4nM9wH%2B783L-%2BFi4PHS9HhcOEdaJzGg%40mail.gmail.com.

[Tom Westrick]

The last Bots release was in 2014 so that 2015 thread you found is still relevant. All example plugins can be found here - https://sourceforge.net/projects/bots/files/plugins/. I've only been on the receiving end of SAP EDI and it was XML so assuming you are also dealing with XML with the ORDERS05 format? If so, it's not anything special with the Bots mapping. Take a look at some of the CSV and XML plugin examples.

As a side note, the new Bots project that supports Python 3 is over here - https://bots-edi.org.

[Utkarsh Mittal]

Thank you very much for your insightful response Tom!

Unfortunately, I have quite a unique case I think, I am not on the receiving end of the SAP EDI but instead I have an application that auto-generates orders programmatically for one of our customers. These generated orders are in our in-house meta format, and we need to deposit them into the customer's SAP ERP system. Hence, we need to convert the intermediary CSV order data into the iDOC ORDERS05 format. Unfortunately, I have next to zero experience with EDIFACT (mostly Zugferd/XRechnung experience only in the EDI domain), and hence I am struggling a bit on how to use BOTS to translate my csv into a iDOC.

Thanks,

Utkarsh

To view this discussion visit https://groups.google.com/d/msgid/botsmail/53927b87-5b84-41ab-a335-62a0217b91e9n%40googlegroups.com.

[Henk-Jan Ebbers]

so you need to translate that csv format to idoc? are those xml idocs?

(do not think you use/need EDIFACT)

kind regards, henk-jan ebbers

To view this discussion visit https://groups.google.com/d/msgid/botsmail/CAErReNUiUGatbGB47FWv7WqPQrhjRZL4gmKev7P7MJ2aGXRjvg%40mail.gmail.com.

[Utkarsh Mittal]

Hi henk-jan ebbers

you need to translate that csv format to idoc?

Yes.

are those xml idocs?

 No, I do not think so. (that would be much easier I guess, at least with my limited knowledge, I could simply map CSV colnames to the appropriate X-paths) 

But the expected idocs look something like this - 

(pls ignore the contents, and only look at the structure, I have manually redacted some stuff)

Thanks,

Utkarsh

To view this discussion visit https://groups.google.com/d/msgid/botsmail/CAEY1zk-N6N3G6pxpp%3DVJLp%2B-MBs9oh_r7e700u4EX-%3DsRiwwwQ%40mail.gmail.com.

[Henk-Jan Ebbers]

oh yeah, the old fixed records IDOCS.

there is a plugin the uses such a ORDERS idoc; might help a little bit

note that there are many variants of SAP orders and many have been customized.

kind regards, henk-jan ebbers

To view this discussion visit https://groups.google.com/d/msgid/botsmail/CAErReNV4X6qOCnREq3PRagukcc0gaxKYs8w%3D3wM88%3D5FNGtp3A%40mail.gmail.com.

[Utkarsh Mittal]

there is a plugin the uses such a ORDERS idoc; might help a little bit

which plugin might that be? 

 note that there are many variants of SAP orders and many have been customized.

Genau, but I do have the specs file which describes the field codes (ORDERS05_{i/d/f}.html) But I am completely lost on the grammar here. I can semantically map fieldlables from our meta csv to those in ORDERS05 spec but I don't how to convert it. 

To view this discussion visit https://groups.google.com/d/msgid/botsmail/CAEY1zk_-4vB%3Du7h131YLtPeiMFtjKJjSH5gKuLRtokFcpS2ysg%40mail.gmail.com.