Friday, 4 December 2015

Link to xPath tutorial

XPath is used to navigate through elements and attributes in an XML document.
  • Expressions
  • Standard Functions
  • xPath and XSLT
Tutorial is here on this page:

http://www.w3schools.com/xsl/xpath_intro.asp

Friday, 27 November 2015

Boyum IT - SAP Business One CRM for Outlook Overview Video

Nice integration, with quite a few very nice features. Worth watching, and it is even not so expensive...

Little programming: recursive function call

I have found this good example on stackowerflow.com as an illustration of the recursive function call. This is really beautiful:

A child couldn't sleep, so her mother told a story about a little frog,
  who couldn't sleep, so the frog's mother told a story about a little bear,
     who couldn't sleep, so bear's mother told a story about a little weasel
       ...who fell asleep.
     ...and the little bear fell asleep;
  ...and the little frog fell asleep;
...and the child fell asleep.

In SQL SERVER a recursive query is good to compose a tree of Bill of Materials (BOM).

Monday, 16 November 2015

SAP Business One 9.2 review

Finally I had time to review the highlights of the new version. My favourite is the Support User, means no more please logout while I have a look... This is so cool! :-)

Tuesday, 13 October 2015

oAuth tutorial

"The idea behind OAuth is simple: Provide a standard way for accessing to protected resources, without the need of sharing passwords." 

 Link to the tutorial: http://blog.oauth.io/oauth-tutorial

Thursday, 1 October 2015

Delete data from SAP Business One with DTW (Data Transfer Workbench)

Just a quick note: to delete data use '/' (backslash) in your template instead of the data. It will delete the content of the field. Note: you can delete data, you can't delete entire record from the database with DTW.

For example to delete the name of the customer, the template would look like this:
CardCode,CardName
CardCode,CardName
C001,/
C002,/