JIRA Integration: Work Logs

Posted on by
Reply

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.

Interesting fact about WDCi support team

Posted on by
Reply

WDCi provides not only data integration and migration services, WDCi also have a reliable support team to provide a premium level of support to customer which is called the Support Plus. WDCi support monitors the Support Plus customer’s integration processes on a daily routine. The team will also:

- troubleshoot errors that occur
- maintain the processes to ensure that they run smoothly
- report daily update of the processes to the customers
- improve on the existing support system to challenge the status quo

One of the interesting facts is, just last month alone, more than 8 million documents have been processed and the support team has successfully troubleshoot, fixed and reported all the documents to ensure smooth data sync between applications.

Feel free to contact us if you are want to know more about this support service.

Salesforce Campaign: Advanced Setup

Posted on by
Reply

Salesforce campaign object has a feature called “Advanced Setup” which allows the user to edit the campaign member status picklist values for each campaign.

Under this advanced setup, you can add, remove or replace the name of the campaign member status for the current campaign. You can also globally rename and replace the campaign member values, to do that, you will need to go to the campaign member “Status” field setting (Setup > Customize > Campaign > Campaign Members > Field > Status).

Each campaign has its own set of picklist values of the campaign member status. This means that each time you created a campaign, you will need to enter the campaign status values to update the picklist.

Salesforce Quotes: Custom Fields Sync

Posted on by
Reply

In one of our recent projects, we are dealing with Quotes and Opportunities in Salesforce. We find that the Quote feature useful when it comes to creating quotation and opportunity data sync.

Within an opportunity, you can create multiple quotes which consist of quote details and quote line items. You can also save the quote as a PDF and send it to the customer. Let’s say if the customer has agreed to the quote, you can then sync the quote line items to update the opportunity line items. After the initial sync, updates to the quote line items and opportunity products will automatically be synced in bidirectional.

However, custom field sync between Quote and Opportunity is not supported out-of-box. You can see the feature request here:

http://success.salesforce.com/ideaview?id=08730000000HpBHAA0

Let’s hope that Salesforce will enhance this feature soon. Meanwhile, we just have to use a workaround to achieve this.

EDI Integration: Trading Partner Feature in Boomi

Posted on by
Reply

There is a feature in Boomi called ‘Trading Partner’ which can provide a solution for EDI integration.

The Trading Partner functionality can be configured with the details for both your company and your trading partners in terms of document standards and communication types.

For more details or information about Trading Partner configuration in Boomi, you can check out the documentation.

QuickBooks Integration Part 2: Getting the Related Transactions

Posted on by
Reply

When integrating QuickBooks data to another application, syncing the accurate and relevant transaction information over to the destination application is very useful.

The easiest and simple way is to sync the specific transaction and its details. However, have ever you wonder if you want to get the other transaction details that are related to this transaction? And how can you get these details synced over whenever you create a transaction?

Lets have an example to explain the above situation.

  • An accountant has just created a Sales Order in QuickBooks.
  • Then, she converted this Sales Order into an Invoice.
  • After that, she wants to sync this Invoice to another application
  • So, this Invoice is being synced to the destination but the user wants to get more information about this Invoice, for example:

- Is the Invoice converted from Sales Order?

- Does this Invoice have any related invoice from the same Sales Order?

All these can be done with some tweaks in an integration process. Basically, what you have to do is to set the parameters when doing a request call for Invoice.

Here are the parameters that can be enabled to display/filter out the elements of the Invoice:

Lets say we have an Invoice that is converted from a Sales Order, so when we query out this Invoice,  we would like to know which Sales Order that this Invoice is converted from. We can set the parameter above (selected with red colour box), ‘IncludeLinkedTxns’ = true.

As we can see here, this is part of the Invoice response XML which we can get the Sales Order useful information from the Invoice.