VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Development Projects, Modifications, Hacks & Tweaks. VM1.1 => Topic started by: pjimmoos on August 16, 2006, 06:28:33 am

Title: Open Catalog Interface (OCI) and XML Punchout support
Post by: pjimmoos 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.   
Title: Re: Open Catalog Interface (OCI) and XML Punchout
Post by: Soeren 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
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: pjimmoos 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.
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: dnewman20 on April 07, 2009, 20:17:15 pm
Has any progress occurred on this subject.  Can someone send me in the right direction?

Thanks
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: smithy32 on September 15, 2010, 12:36:37 pm
I also wondered if anyone had developed anything for OCI integration?
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi 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]
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: gangesindia 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.
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi 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


Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: eim on March 08, 2012, 13:23:05 pm
Can you send me some code too? I just sent you a private message. Thanks.
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: usuariovm 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!
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi 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
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: rodfarrell 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.
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi 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


Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: rodfarrell 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
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: rodfarrell on January 23, 2013, 00:08:54 am
No answer?
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: rodfarrell on January 28, 2013, 23:57:24 pm
I take it from the lack of reply that there is nothing wrong with my template and the extension doesn't actually work in VM2
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi on February 21, 2013, 16:36:36 pm
Sorry Rod!

There was no message from VM in my mail.

Is it to late!
If no, post the template and i will test it.

In other installations kh_vmoci works fine.

k.r
hirzi
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi on February 21, 2013, 20:56:04 pm
Hi Rod!

I tested the installation on your server and it works fine in testmode.

Please read my private messages.

k.r.
hirzi
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: rodfarrell on February 26, 2013, 05:04:57 am
Yes it works now.  I had to modify the auto login plugin which was saving the hook url but not actually logging in.
Title: Re: Open Catalog Interface (OCI) and XML Punchout support
Post by: hirzi on February 26, 2013, 15:41:38 pm
Hi Rod!

Sound good, but a litle bit strange.
Because the login data should be saved by jooma core.
Please send me the changed autologin for testing and implementing in the open source project?

k.r.
hirzi