<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3091859584889509789</id><updated>2024-09-01T15:44:40.770-07:00</updated><category term="ASDatabase deserialization error"/><category term="DB2 timestampdiff"/><category term="Deployment wizard error SSAS"/><category term="HSBC payment gateway"/><category term="Mysql load data"/><category term="PERL WIN32 services"/><category term="PHP and HSBC payment gateway"/><category term="SSAS Error"/><category term="SSIS Buffer manager"/><category term="SSIS Error"/><category term="The buffer manager cannot extend the file"/><category term="UNPROCESSED SSAS"/><category term="Win32::service"/><category term="db2 date difference"/><category term="import data from CSV to mysql"/><category term="integration of HSBC payment gateway"/><category term="mysql replace function"/><category term="mysql replace with update"/><category term="sql replace"/><category term="unprocessed cube"/><title type='text'>Tech Know Stat</title><subtitle type='html'>Learn as you work </subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-1580961135011642253</id><published>2016-03-14T03:26:00.002-07:00</published><updated>2016-03-14T03:26:55.761-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="unprocessed cube"/><category scheme="http://www.blogger.com/atom/ns#" term="UNPROCESSED SSAS"/><title type='text'>Unprocessed state of a SSAS cube : Reasons</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Issue:&lt;br /&gt;&lt;br /&gt;While investigating job failure and missing data we found all the measure groups are in unprocessed state.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Reason:&lt;br /&gt;&lt;br /&gt;There are many possibilities that could lead to this kind of situation. To summarize, every action that affects data will move cube or dimension status to unprocessed. Such changes are also called structural changes, that means any change that apply on cube or dimension structure like adding new element, edition on aggregation method, etc. &lt;br /&gt;&lt;br /&gt;In our case, one dimension &quot;daterange&quot; was fully processed during a bug fix and that actually initiated this issue. &lt;br /&gt;&lt;br /&gt;If ProcessFull is performed on a dimension, all affected cubes and their partitions will subsequently exist in an unprocessed state and they will have to be fully processed on their next scheduled run. &lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/1580961135011642253/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2016/03/unprocessed-state-of-ssas-cube-reasons.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/1580961135011642253'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/1580961135011642253'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2016/03/unprocessed-state-of-ssas-cube-reasons.html' title='Unprocessed state of a SSAS cube : Reasons'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-6515316435823301395</id><published>2015-09-05T06:50:00.001-07:00</published><updated>2015-09-05T11:29:18.083-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ASDatabase deserialization error"/><category scheme="http://www.blogger.com/atom/ns#" term="Deployment wizard error SSAS"/><category scheme="http://www.blogger.com/atom/ns#" term="SSAS Error"/><title type='text'>SSAS Error: Deserialization failed - The AttributeHierarchyProcessingState element ...</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;div elvetica=&quot;&quot; font-family:=&quot;&quot; neue=&quot;&quot; quot=&quot;&quot; rial=&quot;&quot; sans-serif=&quot;&quot; style=&quot;text-align: justify;&quot;&gt;It is a common practice for a BI developer to use &lt;b&gt;ASDatabase&lt;/b&gt; file for &lt;b&gt;SSAS&lt;/b&gt; Cube deployment. How the deployment is done, that is a separate topic. But today I am going to share a trifling problem which may look big sometime and&lt;br /&gt;
&lt;br /&gt;
Error loading *** &lt;b&gt;Deserialization failed: The &#39;AttributeHierarchyProcessingState&#39; element &lt;/b&gt;http://schemas.microsoft.com/analysisservices/2011/engine/300&#39; namespace is unexpected.&lt;br /&gt;
&lt;br /&gt;
There is no problem with the deployment service, neither there is any problem with the generated ASDatabase script. The problem purely is incompatibility. The script was generated using 2012 Data Tool and 2008 R2 BIDS was used for the deployment.&lt;br /&gt;
&lt;br /&gt;
Solution:  As a solution we did the deployment with 2012 Data Tool and the deployment completed without any issue.&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/6515316435823301395/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2015/09/deserialization-failed-asdatabase-error.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/6515316435823301395'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/6515316435823301395'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2015/09/deserialization-failed-asdatabase-error.html' title='SSAS Error: Deserialization failed - The AttributeHierarchyProcessingState element ...'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-2911916309470884066</id><published>2014-05-06T06:46:00.001-07:00</published><updated>2015-08-26T11:40:11.916-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SSIS Buffer manager"/><category scheme="http://www.blogger.com/atom/ns#" term="SSIS Error"/><category scheme="http://www.blogger.com/atom/ns#" term="The buffer manager cannot extend the file"/><title type='text'>The buffer manager cannot extend the file ... (SSIS Error: Microsoft Business Intelligence)</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;Have you ever faced the above issue while running your SSIS package?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt; &lt;b&gt;&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;The buffer manager cannot extend the file &amp;lt;FILE_PATH&amp;gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/b&gt; &lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;That message actually says ... &lt;b&gt;YOU DON&#39;T HAVE SUFFICIENT BUFFER STORAGE TO RUN THE PACKAGE&lt;/b&gt;. When SSIS runs out of virtual memory it uses the paging mechanism and shifts some data from RAM to a TEMPORARY FILE inside the hard drive. If there is insufficient space &amp;nbsp;in your hard drive to create the TEMP file, you will get the above error.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt; &lt;b&gt;&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;Solution(s):&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt; &lt;br /&gt;
&lt;ol style=&quot;text-align: left;&quot;&gt;&lt;li&gt;&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;Do a cleanup of the hard drive&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;background-color: white; color: #333333; font-size: 14px; line-height: 20.162017822265625px;&quot;&gt;&lt;span style=&quot;font-family: Helvetica Neue, Arial, Helvetica, sans-serif;&quot;&gt;Change the location for the buffer files by setting the &lt;b&gt;BLOBTempStoragePath&lt;/b&gt; and &lt;b&gt;BufferTempStoragePath&lt;/b&gt; properties of your data flow task&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/2911916309470884066/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2014/05/error-buffer-manager-cannot-extend-file.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/2911916309470884066'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/2911916309470884066'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2014/05/error-buffer-manager-cannot-extend-file.html' title='The buffer manager cannot extend the file ... (SSIS Error: Microsoft Business Intelligence)'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-4508841268831726447</id><published>2013-05-20T04:51:00.000-07:00</published><updated>2013-05-29T12:51:26.406-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PERL WIN32 services"/><category scheme="http://www.blogger.com/atom/ns#" term="Win32::service"/><title type='text'>Win32 service handling using PERL</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;I had a requirement to check the status of some Windows services from a list and if the status is &quot;STOPPED&quot;, I need need to &quot;START&quot; that service using a script written in PERL.&lt;br /&gt;
&lt;br /&gt;
Here goes the code how I have achieved that in PERL:&lt;br /&gt;
&lt;br /&gt;
&lt;script src=&quot;https://gist.github.com/anonymous/5673264.js&quot;&gt;&lt;/script&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/4508841268831726447/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2013/05/win32-service-handling-using-perl.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/4508841268831726447'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/4508841268831726447'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2013/05/win32-service-handling-using-perl.html' title='Win32 service handling using PERL'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-1693975094495043526</id><published>2012-06-13T01:45:00.001-07:00</published><updated>2013-03-09T03:12:06.792-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="mysql replace function"/><category scheme="http://www.blogger.com/atom/ns#" term="mysql replace with update"/><category scheme="http://www.blogger.com/atom/ns#" term="sql replace"/><title type='text'>Mysql Replace: Using replace function with UPDATE</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;MySQL replace function is very useful while you need to update a field value based on a search criterion during execution.Here is an example&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;Syntax:&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: #38761d;&quot;&gt;UPDATE&lt;/span&gt; &lt;i&gt;&amp;lt;table_name&amp;gt; &lt;/i&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: #38761d;&quot;&gt;SET &lt;/span&gt;&lt;/b&gt;&lt;i&gt;&lt;b&gt;&amp;lt;field_name&amp;gt;&lt;/b&gt;&lt;/i&gt; = &lt;b&gt;&lt;span style=&quot;color: #cc0000;&quot;&gt;replace&lt;/span&gt;&lt;/b&gt;(&lt;i&gt;&lt;b&gt;&amp;lt;field_name&amp;gt;&lt;/b&gt;&lt;/i&gt;,&lt;i&gt;&lt;b&gt;&amp;lt;search_keyword&amp;gt;&lt;/b&gt;&lt;/i&gt;,&lt;i&gt;&lt;b&gt;&amp;lt;replace_keyword&amp;gt;&lt;/b&gt;&lt;/i&gt;) &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: #38761d;&quot;&gt;WHERE&lt;/span&gt;&lt;/b&gt; &lt;i&gt;&lt;b&gt;&amp;lt;condition&amp;gt;&lt;/b&gt;&lt;/i&gt;; &lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/1693975094495043526/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2012/06/mysql-replace-using-replace-function.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/1693975094495043526'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/1693975094495043526'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2012/06/mysql-replace-using-replace-function.html' title='Mysql Replace: Using replace function with UPDATE'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-2983355967935719227</id><published>2012-06-05T23:28:00.004-07:00</published><updated>2012-06-05T23:31:53.352-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="import data from CSV to mysql"/><category scheme="http://www.blogger.com/atom/ns#" term="Mysql load data"/><title type='text'>MYSQL LOAD DATA: To load data from CSV files into MYSQL TABLE</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Mysql provides a function LOAD DATA to load data from a CSV file into a mysql table. This is an amazingly efficient and a real time saver.&lt;br /&gt;
&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
LOAD DATA LOCAL INFILE&lt;b&gt; &#39;C:\\raw.csv&#39;&lt;/b&gt; INTO TABLE &lt;b&gt;dummyTable&lt;/b&gt;&lt;br /&gt;
FIELDS TERMINATED BY &lt;b&gt;&#39;,&#39;&lt;/b&gt; ENCLOSED BY&lt;b&gt; &#39;&quot;&#39;&lt;/b&gt; LINES TERMINATED BY &lt;b&gt;&#39;\r\n&#39;&lt;/b&gt;;&lt;br /&gt;
&lt;br /&gt;
Code is self-explanatory. &lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/2983355967935719227/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2012/06/mysql-load-data-to-load-data-from-csv.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/2983355967935719227'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/2983355967935719227'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2012/06/mysql-load-data-to-load-data-from-csv.html' title='MYSQL LOAD DATA: To load data from CSV files into MYSQL TABLE'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-9027383683790757172</id><published>2011-10-18T02:59:00.000-07:00</published><updated>2011-10-18T03:16:58.683-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="db2 date difference"/><category scheme="http://www.blogger.com/atom/ns#" term="DB2 timestampdiff"/><title type='text'>DB2 - get the time difference between two dates</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;
There was a specific requirement to check how long the user have not changed his password. For that I had to calculate the date difference between the current date and the last password change date.&lt;/div&gt;
&lt;div style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;&lt;b&gt;The query to get date difference in DB2:&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;
&lt;i&gt;SELECT name,CURRENT TIMESTAMP,timestamp(pw_changed,&#39;00:00:00&#39;),&lt;br /&gt;&lt;a href=&quot;http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.iseries.langref2.doc/rbafzmst271.htm&quot;&gt;TIMESTAMPDIFF&lt;/a&gt;(16,CHAR(CURRENT TIMESTAMP - timestamp(pw_changed,&#39;00:00:00&#39;)))&lt;br /&gt;from user;&lt;/i&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;where &#39;user&#39; is the user table and &#39;pw_changed&#39; is the last password change date.&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/9027383683790757172/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2011/10/db2-get-time-difference-between-two.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/9027383683790757172'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/9027383683790757172'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2011/10/db2-get-time-difference-between-two.html' title='DB2 - get the time difference between two dates'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3091859584889509789.post-2065662068169266868</id><published>2011-09-13T10:31:00.000-07:00</published><updated>2011-11-13T09:16:53.672-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="HSBC payment gateway"/><category scheme="http://www.blogger.com/atom/ns#" term="integration of HSBC payment gateway"/><category scheme="http://www.blogger.com/atom/ns#" term="PHP and HSBC payment gateway"/><title type='text'>HSBC Payment gateway integration using PHP</title><content type='html'>Here we go with the first one. HSBC payment gateway integration, i was in trouble while doing this for the first time. As there are not much support for PHP people. I till believe the best way to do this is , through a &lt;span style=&quot;font-weight: bold;&quot;&gt;web service&lt;/span&gt; call. build an XML according to their format and post it to the specific url, use CURL to get the output, thats also in XML. So you need to parse that XML to get the response.
&lt;pre&gt;

$xml_data = &quot;&amp;lt;?xml version=&#39;1.0&#39; encoding=&#39;UTF-8&#39; ?&amp;gt;
&amp;lt;EngineDocList&amp;gt;
&amp;lt;DocVersion DataType=&#39;String&#39;&amp;gt;1.0&amp;lt;/DocVersion&amp;gt;
&amp;lt;EngineDoc&amp;gt;
&amp;lt;ContentType DataType=&#39;String&#39;&amp;gt;OrderFormDoc&amp;lt;/ContentType&amp;gt;
&amp;lt;User&amp;gt;
&amp;lt;ClientId DataType=&#39;S32&#39;&amp;gt;ClientId&amp;lt;/ClientId&amp;gt;
&amp;lt;Name DataType=&#39;String&#39;&amp;gt;Name&amp;lt;/Name&amp;gt;
&amp;lt;Password DataType=&#39;String&#39;&amp;gt;Password&amp;lt;/Password&amp;gt;
&amp;lt;/User&amp;gt;
&amp;lt;Instructions&amp;gt;
&amp;lt;Pipeline DataType=&#39;String&#39;&amp;gt;PaymentNoFraud&amp;lt;/Pipeline&amp;gt;
&amp;lt;/Instructions&amp;gt;
&amp;lt;OrderFormDoc&amp;gt;
&amp;lt;Mode DataType=&#39;String&#39;&amp;gt;Y&amp;lt;/Mode&amp;gt;
&amp;lt;Consumer&amp;gt;
&amp;lt;PaymentMech&amp;gt;
&amp;lt;Type DataType=&#39;String&#39;&amp;gt;CreditCard&amp;lt;/Type&amp;gt;
&amp;lt;CreditCard&amp;gt;
&amp;lt;Number DataType=&#39;String&#39;&amp;gt;&quot;.$_POST[&#39;cust_cc_number&#39;].&quot;&amp;lt;/Number&amp;gt;
&amp;lt;Expires DataType=&#39;ExpirationDate&#39;
Locale=&#39;826&#39;&amp;gt;&quot;.$cust_cc_end_month_xml.&quot;/&quot;.$cust_cc_end_year_xml.&quot;&amp;lt;/Expires&amp;gt;
&amp;lt;/CreditCard&amp;gt;
&amp;lt;/PaymentMech&amp;gt;
&amp;lt;/Consumer&amp;gt;
&amp;lt;Transaction&amp;gt;
&amp;lt;Type DataType=&#39;String&#39;&amp;gt;PreAuth&amp;lt;/Type&amp;gt;
&amp;lt;CurrentTotals&amp;gt;
&amp;lt;Totals&amp;gt;
&amp;lt;Total DataType=&#39;Money&#39; Currency=&#39;826&#39;&amp;gt;&quot;.$all_price_tot.&quot;&amp;lt;/Total&amp;gt;
&amp;lt;/Totals&amp;gt;
&amp;lt;/CurrentTotals&amp;gt;
&amp;lt;/Transaction&amp;gt;
&amp;lt;/OrderFormDoc&amp;gt;
&amp;lt;/EngineDoc&amp;gt;
&amp;lt;/EngineDocList&amp;gt;&quot;;

$ch = curl_init();
$url = &quot;https://www.secure-epayments.apixml.hsbc.com&quot;;
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS,$xml_data);
$data = curl_exec($ch);
if ($error = curl_error($ch)) {
//echo &quot;Error: $error
\n&quot;;
}
curl_close ($ch);

&lt;/pre&gt;

$data contains the &lt;span style=&quot;font-weight: bold;&quot;&gt;output xml &lt;/span&gt;of the web service call. Parse it to get the response.

If you need more information about this, I am always ready to help. Njoy!</content><link rel='replies' type='application/atom+xml' href='http://techknowstat.blogspot.com/feeds/2065662068169266868/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://techknowstat.blogspot.com/2011/09/hsbc-payment-gateway-integration-using.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/2065662068169266868'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3091859584889509789/posts/default/2065662068169266868'/><link rel='alternate' type='text/html' href='http://techknowstat.blogspot.com/2011/09/hsbc-payment-gateway-integration-using.html' title='HSBC Payment gateway integration using PHP'/><author><name>SurajitRay</name><uri>http://www.blogger.com/profile/04056912615985654050</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>