WDCi is currently looking for new members to be added to the team.
Who are them looking for? They are looking for Integration Developer.
For more details about the job application, please visit here.
WDCi Is Looking For New Recruits!
Reply
Category Archives: Integration Corner
Want to view your MYOB Accounting inventory on your iPhone?
Contact us to take a look at our new app thats currently in beta. You’ll be able to view your inventory levels from your MYOB accounting system while on the road, using your mobile device, nifty right?
Business Catalyst Integration: eCommerce Data Model
As we all have known, Business Catalyst is not only used for content management, it does provide other functionalities like eCommerce, reporting and etc.
The diagram below shows the first level eCommerce data model and the relationships between each object:
Business Catalyst can be integrated via SOAP web service, however, Company info is not available in the API most likely because Business Catalyst is more contact centric.
Guess what? WDCi is going to release a Business Catalyst related integration product soon! Want to know more? Stay tuned with Tim as more information will be announced.
Bugzilla Web Service: Custom Field
Bugzilla front-end allows custom field to be created. So what if you want to get the custom field value over to another system? We make this possible by using the Bugzilla XML RPC web service as custom field value is retrievable.
For example, if we are integrating Bugzilla with Salesforce, we can create a custom field called “Sync to Salesforce”, it can be set to True or False. If the value is set to True, it will trigger the integration process to create/update a Salesforce Case.
Below is the screenshot of the part of Bugzilla xml response:
If you are interested in getting the Bugzilla custom values to be synced over to another system and need help on that, feel free to contact us.
SmartTurn Integration: Purchasing and Inventory Control
Not long ago, we have talked how can integration helps in the SmartTurn Order Fulfillment process. This time around, let’s us talk about another process that SmartTurn can handle, Purchasing and Inventory Control.
We can integrate SmartTurn with an ERP system, let us take an example of integrating SmartTurn and Netsuite:
1. User can create a purchase order in Netsuite for purchasing items.
2. The purchase order will then be created in SmartTurn automatically.
3. Once the user received the goods, a receipt will be created in SmartTurn and the inventory status will also be updated.
4. This will then update the status of the purchase order and a receipt will be created in Netsuite automatically.
Below is a diagram illustrates the above scenario:
Besides integrating with ERP system, SmartTurn can also be integrated with accounting system, E-Commerce system and etc. You can save time and effort by automating the inventory status update between the systems, automate purchase order creation when inventory is running low.
Upskilled saves time by integrating Salesforce and MYOB
Got MYOB, got Salesforce? Check out this case study for details on how Upskilled uses a pre-built integration solution to get MYOB and Salesforce talking.
Bugzilla Integration: Web Service
Bugzilla is an Open Source Defect Tracking System to manage software development. We can integrate to Bugzilla through the web service or directly to the database.
For example, you can integrate Bugzilla with a support system. When a case is confirmed as a bug, then the bug will be automatically created in Bugzilla. You can find the demo here.
Interested in integrating Salesforce and Bugzilla?
Got Salesforce, got Bugzilla? Life would be easier if they were connected right? Checkout a quick video on integrating Salesforce and Bugzilla using the Dell Boomi platform.
SmartTurn Integration: Order Fulfillment
SmartTurn is a very good warehouse management system. It has features which cover from item purchasing to item shipping, within these processes, item inventory/warehouse status will be automically updated.
So how can integration help? Let’s talk about one of the features that we can perform in SmartTurn, Order Fulfillment. Here is one scenario:
1. I am managing a clothing wholesale business, a customer has ordered 200 items from my company. Within these 200 items, 100 will be shipped to location A, 50 will be shipped to location B, and the rest to location C.
2. If the customer is placing an order through my CRM or eCommerce system. The integration process can synchronise the Sales Order into SmartTurn specifying all the item details and customer’s shipping destinations.
3. SmartTurn will then check the inventory status, if the stock is insufficient, the shipment will be put ‘On Hold’. If everything goes well, the inventory count will be deducted in SmartTurn. We can then synchronise the latest inventory count to our Accounting System.
Below is a simple diagram illustrating the above scenario:
We can integrate SmartTurn with any other CRM, ERP system or etc. which improve efficiency in order processing and fulfillment. As with the above scenario, updating the customer information and purchasing details, processing the transaction before confirming shipment status and other details.
JIRA Integration: Work Logs
The time logged in a specific issue can be retrieved from JIRA by using the JIRA API (getWorklogs). The result returned will include the details of the time logged into an issue. For example:
<multiRef id=”id1″ soapenc:root=”0″ soapenv:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/” xsi:type=”ns3:RemoteWorklogImpl” xmlns:soapenc=”http://schemas.xmlsoap.org/soap/encoding/” xmlns:ns3=”http://service.soap.rpc.jira.atlassian.com”>
<author xsi:type=”xsd:string”>hmkhong</author>
<comment xsi:type=”xsd:string”/>
<created xsi:type=”xsd:dateTime”>2011-10-12T06:22:18.663Z</created>
<groupLevel xsi:type=”xsd:string” xsi:nil=”true”/>
<id xsi:type=”xsd:string”>10002</id>
<roleLevelId xsi:type=”xsd:string” xsi:nil=”true”/>
<startDate xsi:type=”xsd:dateTime”>2011-10-12T06:22:00.000Z</startDate>
<timeSpent xsi:type=”xsd:string”>2 hours</timeSpent>
<timeSpentInSeconds xsi:type=”xsd:long”>7200</timeSpentInSeconds>
<updateAuthor xsi:type=”xsd:string”>hmkhong</updateAuthor>
<updated xsi:type=”xsd:dateTime”>2011-10-12T06:22:18.663Z</updated>
</multiRef>
If you find the “pretty” format too difficult to calculate, you can use the timeSpentInSeconds. This field will returned time logged in seconds.