Author Topic: Open Catalog Interface (OCI) and XML Punchout support  (Read 25580 times)

pjimmoos

  • Beginner
  • *
  • Posts: 5
Open Catalog Interface (OCI) and XML Punchout support
« on: August 16, 2006, 06:28:33 am »
I am wondering if some one is devoloping a module to allow Business-to-Business Procurement system to integrate with VirtueMart using one of the open standards.

The next step is to flow on from here the intregration with supplier acounting software. ie: the VietueMart is to forward the order from the B2B Procurement system to the in house acounting system for completion.   

Soeren

  • Administrator
  • Sr. Member
  • *
  • Posts: 3106
  • VirtueMart Starter
    • virtuemart.net
Re: Open Catalog Interface (OCI) and XML Punchout
« Reply #1 on: August 17, 2006, 17:31:14 pm »
Hi,
user Manni is implementing an order export API for export modules. So you can import orders into your Business Software.

We're still looking for people that want to develop and Accounting Software integration for VirtueMart...

ciao, Soeren
The future of eCommerce: VirtueMart & Joomla!
http://virtuemart.net

pjimmoos

  • Beginner
  • *
  • Posts: 5
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #2 on: August 18, 2006, 03:55:07 am »
Hi

Could you please put me in the right direction of this project as I would like to help.

dnewman20

  • Beginner
  • *
  • Posts: 2
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #3 on: April 07, 2009, 20:17:15 pm »
Has any progress occurred on this subject.  Can someone send me in the right direction?

Thanks

smithy32

  • Beginner
  • *
  • Posts: 1
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #4 on: September 15, 2010, 12:36:37 pm »
I also wondered if anyone had developed anything for OCI integration?

hirzi

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 10
    • www.hirzberger.at
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #5 on: September 02, 2011, 00:44:38 am »
The Time is over.

I developed 2 Joomla plugins they solved this problem.

The first is for autologin and save the hook_url.

The second sends the order via oci (html-format) to f.e. SAP B2B.

The oci-parameters can customized with templates for each customer.
F.e. NEW_ITEM-CUST_FIELD
Code: [Select]
<form id="kh_vmOciSendForm" action=" <?php echo $hook_url ?>" method="post" target="_top">

<input type="hidden" name="~OkCode" value="ADDI" />
<input type="hidden" name="~target" value="_top" />
<input type="hidden" name="~Caller" value="CTLG" />
<?php 
$counter 1;
foreach( $rows as $row 
{
?>

<input type="hidden" name="NEW_ITEM-DESCRIPTION[<?php echo $counter ?>]"
value="<?php echo substr($row->order_item_name,0,40?>" />
<input type="hidden" name="NEW_ITEM-QUANTITY[<?php echo $counter ?>]"
value="<?php echo number_format($row->product_quantity3'.'''?>" />
<input type="hidden" name=NEW_ITEM-UNIT[<?php echo $counter ?>]"
value="<?php echo substr($row->product_unit,0,3?>" />
<input type="hidden" name="NEW_ITEM-PRICE[<?php echo $counter ?>]"
value="<?php echo number_format($row->product_item_price3'.'''?>" />
<input type="hidden" name="NEW_ITEM-PRICEUNIT[<?php echo $counter ?>]"
value="1" />
<input type="hidden" name="NEW_ITEM-CURRENCY[<?php echo $counter ?>]"
value="<?php echo $row->order_item_currency ?>" />
<input type="hidden" name="NEW_ITEM-LEADTIME[<?php echo $counter ?>]"
value="1" />
<input type="hidden" name="NEW_ITEM-EXT_PRODUCT_ID[<?php echo $counter ?>]"
value="<?php echo substr($row->order_item_sku,0,40?>" />
<input type="hidden" name="NEW_ITEM-CUST_FIELD1[<?php echo $counter ?>]"
value="<?php echo $row->order_id ?>" />
<input type="hidden" name="NEW_ITEM-CUST_FIELD5[<?php echo $counter ?>]"
value="<?php echo substr($row->product_s_desc,0,50?>" />
<?php $counter++; ?>
<?php //end for ?>
<input type="button" class="button" value="<?php echo $button_text ?>"
id=kh_submitoci name=kh_submitoci onClick="kh_vmocisendform()">
</form>
No Hack to thankyou.php.
The Plugin inserts/injects the the logic for sending the order via oci in the top of the thankyou-page.
The other part of the thankyou-page will not be changed.

In the attachment are some screenshots.
They are in german, but you can see, how the plugin works.

I have testet the interface with real SAP B2B and it seems to work.
Now i have to wrte a page for help and download.
It will be coming soon.

If you are interestet for testing, send me a mail.

--hirzi


[attachment cleanup by admin]

gangesindia

  • Beginner
  • *
  • Posts: 1
    • Buy Marble Statues Online, Hindu God Idols For Sale
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #6 on: September 08, 2011, 14:10:17 pm »
Hi,

I also need this Business-to-Business Procurement system to integrate with VirtueMart using one of the open standards.

Does any one is working on it.

Please update me.

hirzi

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 10
    • www.hirzberger.at
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #7 on: September 10, 2011, 23:58:24 pm »
Hi gangesindia!

The B2B system is ready an it works.
We testet it with SAP B2B from an austrian company.

But, at the moment there is no english manual availiable.
I'm working on a translation from german to english.

Are you familiar with PHP?
If yes, i can send you the plugins with a with basic instuctions and you can write your own template like a VM-template.
In the template you can define the fields they are sendet to SAP, because different companies use different fields in B2B.
In kh_vmoci you can define a personal template for each customer.
The default.tpl.php is developed for the austrian company who testet the OCI.
You can see the template in the post above.

Send me a mail-address an i send you the plugins for your personal use.

--hirzi



eim

  • Beginner
  • *
  • Posts: 1
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #8 on: March 08, 2012, 13:23:05 pm »
Can you send me some code too? I just sent you a private message. Thanks.

usuariovm

  • Beginner
  • *
  • Posts: 1
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #9 on: April 04, 2012, 03:10:07 am »
Hi Hirzi!
Thanks for you effort to make this 2 joomla plugins for the SAP OCI punchout connection.

I will appreciate if you can share me too this code to check how did you do it.

Thanks in advance,
Grettings!

hirzi

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 10
    • www.hirzberger.at
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #10 on: May 17, 2012, 21:04:31 pm »
Hi all!

You can download kh_vmoci at sourceforge.net.

https://sourceforge.net/projects/khvmoci/

It is available in two versions.
1.5 for Joomla 1.5 and Virtuemart 1.1
2.5 for Joomla 2.5 and virtuemart 2.0
hirzi

rodfarrell

  • Beginner
  • *
  • Posts: 30
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #11 on: January 18, 2013, 00:25:31 am »
Has anyone tested this in Joomla 2.5 / VM 2.0?  I get an error message "Object doesn't support this property or method" and no data is transferred to SAP.

hirzi

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 10
    • www.hirzberger.at
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #12 on: January 18, 2013, 15:52:24 pm »
Hi rodfarrell!

Of course.
kh_vmoci was developed in Joomla 2.5 and VM 2.0 and tested.

The error looks like a javascript-bug in IE 6 or like a wrong PHP code in the template.

Please send me more informations.
Exact version of Joomla, VM and Browser.
You can also send me your template.

k.r.
hirzi



rodfarrell

  • Beginner
  • *
  • Posts: 30
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #13 on: January 21, 2013, 02:20:26 am »
Thanks for your help.  I will pm the template.  We are running Joomla 2.5.8 and VM 2.0.16  The error is happening on all browsers so probably my php

rodfarrell

  • Beginner
  • *
  • Posts: 30
Re: Open Catalog Interface (OCI) and XML Punchout support
« Reply #14 on: January 23, 2013, 00:08:54 am »
No answer?