Discussion Forum Archives - Page 3 of 4

Where can I get training on Microsoft Dynamics CRM (MS CRM) ?

By TechOneStop

Question posted by Sameer Ab:
“I have 2 years of experience as a test engineer. How could I become a Microsoft CRM tech consultant. Also i am looking for internship or entry level job in ms crm in bangalore/Hyderabad. Please please help me.”

Answer (by TechOneStop):
It is great to see that you are interested to learn Microsoft CRM (also called as Microsoft Dynamics CRM or MS CRM).
1. First I would suggest you to watch few videos on Microsoft Dynamics, visit Microsoft Virtual Academy. You could watch YouTube videos as well. It will give you overall idea about MS CRM.
2. Microsoft gives 30 days free trial period to do hands on Dynamics CRM, just register yourself and do some basic configurations like create organization, position, users.
3. If you are interested to explore more, join any classroom training. There are many institutes who provide training on MS CRM.
To download user guide and training documents on Dynamics, click here.

Wish you all the best!! Please let us know if this was helpful for you. Also I would like to ask our readers to share their answers on this question.

How to display barcode on Oracle BI Publisher report

By TechOneStop

We all know use of barcode, right! It helps business to track a product or order quickly and accurately. Like in any supermarket, barcode helps to identify items easily and accurately. But how to generate barcode from Siebel or any other system? Can we generate and display barcode on Oracle Business Intelligence Publisher Report?
Answer is YES, we can use BI Publisher as barcode generator and print/display barcode on report.
Recently, I was working on a requirement for one manufacturing company where they were looking for better approach to track Service Request and RMA (Return Material Authorization) of products distributed among different systems. So easiest and reliable solution is Barcode but how will it help them to meet their goal? Well, let me give you a business scenario. Right now, business uses Siebel CRM application to create service request of any product or order. Suppose for RMA type service request, Siebel system will generate the RMA number and then send it to dispatch section for mail communication. So for dispatch section, it is manual task to enter RMA number into System. Next for RMA working department, it is another manual task to enter RMA number into their system. In complex system, business could have more hierarchy and more hierarchy means higher chance of doing wrong entry. So they need automation of this manual task to make the process faster and error free (almost error free) and best solution is barcode automation. Siebel will generate the RMA number and send it to reporting system (here business is using BI Publisher for reporting purpose). Then BI Publishers will change the RMA number to barcode which will be referred by all other business units. To read barcode, business units need only barcode scanner which will change the barcode to actual number and make an entry on their system. Faster and error free, isn’t it!!

Now, question is how BI Publisher will generate barcode and print it on report?

Barcode is nothing but special kind of font which barcode scanner only can read. There are few free barcode fonts and few paid fonts. As per requirement, you could pick free font or paid. For our requirement, we have used free barcode font 39HIHR.ttf of barcode39 font family. In Microsoft Word, 39HIHR.ttf looks like below (barcode above and number down).

How to display barcode on Oracle BI Publisher report www.techonestop.com

You can download the font from Google. If the font file is zipped, then unzip it and paste it under C:WindowsFonts folder. Once you paste Code39.ttf, it will be installed automatically and you should see many other barcode fonts like 39HI.TTF, 39HIHR.TTF, 39HITLHR.TTF. To verify the new barcode font, open one word doc in MS word, write any text and select one barcode font. You will see the text in barcode font. Now our first step is completed. We have successfully installed barcode font on our system so that we could build our report template using barcode font. Here we have used 39HIHR.ttf as business needs barcode bar above and RMA number down what exactly this barcode font provides

.
Next check BI Publisher Desktop is installed on your system or not. We need it to build template with barcode font. If BI Publisher Desktop is installed, then you could see Oracle BI Publisher Add Ins tab in MS word. I hope you know how to add bookmark to display field in report. Here we have added two bookmarks, one for SR number and another for RMA Number and we have picked BC 39 HI HR font (which is nothing but display name of 39HIHR.ttf font) for both two fields.

display barcode on Oracle BI Publisher report www.techonestop.com

Once report template is ready, see the preview to check barcode font. To see preview, first add the font in xdo.cfg file, located under ..BI Publisher DesktopTemplate Builder for Wordconfig. If you are doing for first time, then you may have xdo_example.cfg instead of xdo.cfg. We have to rename this file as xdo.cfg and add below script under ‘<!– Font setting –>’ section.

</font>

It should look like below

Now we can see the preview of the template. To see preview, click on Preview option from Oracle BIP Toolbar and select the report type (example PDF, DOC, HTML). If the template preview does not meet our requirement, modify it and verify it again. Once the template is ready, generate XLIFF file from the original template. At runtime, original template is applied for the layout and the XLIFF file is applied for translation.

Follow below steps to generate an XLIFF file from an RTF template

– Open the template in Microsoft Word and click on Add-Ins tab

– From the Template Builder menu, select Tools > Translate Template > Extract Text, BI Publisher

will extract the translatable strings from the template

– Save the file with .xlf extension

Now our template and XLIFF file are ready. Next step is font mapping in BI Publisher so that we could use BIP as Barcode Generator. Follow below steps to configure new font in BIP.

Step 1:

Check the java path which is getting referred by Business Intelligence Publisher server and copy the font file (39HIHR.ttf) from C:WindowsFonts to .. Javajre(version no)libfonts

– Make sure, font file extension (.ttf) is in small letter otherwise font may not appear in font mapping dropdown

– If the extension is in Caps, then change it to small letter first and then copy it

– Restart the werserver (OC4J/Tomcat) service if required

Step 2:
Login to BI Publisher Application and Navigate to Admin > Runtime Configuration > Font Mappings

Oracle BI Publisher font mapping www.techonestop.com

Step 3:

As per report template type (RTF or PDF), click on ‘Add Font Mapping’ button to add font. As we have used RTF template for our requirement, font mapping for RTF template type will be sufficient, no need to do anything on pdf font mapping option.

Base font = BC 39 HI HR (Base Font value should be same as font display name in MS Word)

Style = Normal

Weight = Normal

Target Font Type = Truetype

Target Font = Actual font file (39HIHR.ttf)

TTC Number = (keep it blank)

Barcode font mapping on Oracle BI Publisher report www.techonestop.com

Step 4:

Click on ‘Apply’ button from right hand side top corner and restart the webserver (OC4j or tomcat) service.

That’s all. Now goto Siebel application, upload files (template file and XLIFF file) on Administration-BI Publisher and generate reports. You could see nice barcode on the template.

Few things to remember:

– Font file extension (.ttf) must be in small letters otherwise font may not appear in font mapping dropdown

– Sometimes barcode scanner needs barcode terminator to read the code properly, mainly if you are using code39 barcode font. Here we have used * (asterisk) as terminator.

If you have any doubt or question, feel free to ask us. To get more updates on recent activities, follow ‘TechOneStop’ on Facebook/Twitter/LinkedIn or join our website as followers. In our next article, we will discuss about how to display MICR code and QR code on BIP Report.

Watch our video as well:

Junk characters in SoapUI response – how to fix it

By TechOneStop

Getting junk characters in SoapUI response? weird characters in SoapUI response

Well, this is quite common issue in SoapUI during web service testing.

These junk characters are nothing but SoapUI compressed response.

Follow below steps so that you can see actual XML response without encoding:

1) Navigate to File > Preferences > ‘HTTP Settings’ on SoapUI interface

2) Verify ‘Response compression‘ property on HTTP Settings page

– Uncheck the option ‘Accept compress responses from hosts‘

3) Verify ‘Disable Response Decompression‘ property (just below ‘Response compression’ )

– Make sure ‘Disable decompression of compressed responses‘ checkbox is unchecked

soapui response encoding

That’s it!

Now submit the request XML once again and you will get the response in XML structure.

If you have any of these two options checked, SoapUI encodes the response file and you see junk characters instead of XML.

You can still see the encoded SoapUI response if there is any encoding rule in WSDL file.

Please leave your comment below if the above solution does not fix your problem and still see junk characters in SoapUI response.

Would you like simpler and lighter web service testing tool than SoapUI?

Then read this article – 5 SoapUI alternative applications.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Google+.

What is ActiveX

By TechOneStop

ActiveX is nothing but a small piece of code(better known as Add-ons), created by Microsoft. If you have Internet Explorer installed on your computer, then ActiveX is also installed. Purpose of this ActiveX is to improve the browsing experience but it only works with Microsoft applications like MS Word, Excel, PowerPoint, Internet Explorer. The Idea behind ActiveX is that same piece of code can be used in more than one place.

For Example, a spell checker functionality is required in MS Word as well as in e-mail application like Microsoft Outlook. So instead of writing same code twice, write a spell checking functionality in one place (i.e Windows Operating System) and call spell checker object wherever it is required.

ActiveX technology started as Object Linking and Embedding (OLE). In earlier version of windows, OLE used for cross application functions like Cut , Copy, Paste. Now a day, OLE has been transformed into Compound Object Module (COM). Spell checker is an example of COMs. It is an independent program in windows which can be used by any windows applications. ActiveX control is another COM which is used in larger applications.

For example, if you want to play flash files(.swf) in Internet Explorer, you need Adobe Flash player installed on your system first, as IE cannot play flash files directly. But if the whole website is built in flash and you don’t want to install Adobe Flash Player, then IE gives you an option to download and install Flash ActiveX at your OS level. After that IE can play the files in the browser itself.

As it is a piece of code, there is a risk of misuse also. Using ActiveX, applications/websites can access your personal information, also it could throw unwanted pop-ups. So before installing any ActiveX, make sure it is trust worthy.

How to install ActiveX ?

When any application needs ActiveX control, IE displays a dialog box asking your permission to install, provided Pop-Up blocker option in IE level is not set to ‘Yes’. Right click on the dialog box and click on ‘Install ActiveX Control’ option to install it.

How to uninstall ActiveX ?

Open Internet Explorer and then goto Tools > Manage Add-ons option. You can see the list of all add-ons, installed in your system. Select the ActiveX control you want to delete and then either click on Delete option or Disable.

Difference between Siebel Open UI 8.1.1.10 and 8.1.1.11

By TechOneStop

Oracle has done many changes in Siebel Open UI 8.1.1.11 over 8.1.1.10. One major difference is that from Open UI 8.1.1.11 onward, there is no need to add any user property to associate Presentation Model or Physical Renderer JS files with Applets or Views or Screens. We can do this from Open UI client itself and completely srf independent. If you have worked on Siebel Open UI .10 version, then you know that we have used two user properties (Physical_Renderer and Presentation_Model) in Siebel tools to embed .js files with Siebel objects and compiled into srf. But from Open UI 8.1.1.11, we will not use these two user properties anymore. Also there is no need to modify manifest file (custom_manifest.xml) anymore. Here we will see, how we can we do from client itself.

Let me give you an example. Suppose, for ‘Contact Form Applet’, we have one PR file (condemaildisplaypr.js) and one PM file (condemaildisplaypm.js) which will display contact’s Email id conditionally. So next step will be, embed these two files with ‘Contact Form Applet’.

In 8.1.1.10, we need to add two applet user properties (Physical_Renderer and Presentation_Model) under the applet, give key name as value and compile it.

Siebel Open UI 8.1.1.10 - techonestop.com

But in 8.1.1.11, instead of adding these two user properties in Siebel tools, we will do it from client.
Step 1: Go to Administration-Application > Manifest Files and add two js files like below

Siebel Open UI Manifest file - techonestop.com

Manifest Files Registration

Step 2: Go to Administration-Application > Manifest Administration and associate these two files with the applet like below

Siebel Open UI Manifest Administration - techonestop.com

Siebel Open UI 8.1.1.11 - techonestop.com

Step 3: Log off and log in, we can see our changes now.

So from Open UI 8.1.1.11, there is neither any user property to embed JS files nor srf compilation, it’s completely srf independent.

To get more updates on recent activities, follow ‘TechOneStop‘ on Facebook/Twitter/LinkedIn or join our website as followers.

You may like our Youtube videos on Siebel Open UI Training:

How to create a free website

By TechOneStop

Want to build your own website but don’t know how to start!! Don’t worry, here we will tell how to create a (FREE!!) website step by step. Before opening any website, it is very much important to set a clear goal. So let’s start our discussion with few initial questions.

How to create a free website - techonestop.com

1) What kind of website you want to open (educational, commercial, music, social…)?
2) How much space do you need for your website?
– Well, it is tough to answer at primary stage. But if you are planning to open a website which
will mainly have videos or images, it needs more space than just text based website.
3) What would be the content type (text/picture/music/video)? Decide the percentage of every content type.
4) What will be the domain name? (Better to decide more than one domain name because it could be that the website name what you have decided, is already taken by someone else.You have to pay to buy custom domain mane)

5) Do you want custom email id? (Suppose, owner of the website www.lovemypet.com would like to have custom email id like [email protected].) Also how many custom email id is required for you?

6) Do you need any mysql/php server deployment/maintenance for you website?
7) Most important, budget for your website?

You may think that just now we told free website, then why do we need budget here. Well, if you want a professional name for your website, then you have buy domain name like techonestop.com .
But if you just want to start your own website, which mainly contains text articles and does not require any custom email id or server maintenance, then better to start with blogger or WordPress. It is completely free of cost. After that just buy the domain name and integrate it with blogger or WordPress website which will give your website a professional name. It will cost you few bucks only but if you want our own web hosting mechanism, more space to store contents like music, video or custom email ids, then you have to pay more.  Here we will discuss how to get a website with professional name spending nothing or very few bucks.

High Level Idea: Use Blogger or WordPress which will give you a platform to write articles, free templates for website, free widgets and many more and then integrate it with actual domain name. Here we will use blogger. Lets see in details how to build a free website.

Step 1) Create a Google account
As we are using blogger here, we have to have Google account to get blogger administration window. If you already have Google account. you can use it otherwise open a new Google account. We will use this Google account to login into blogger.com. Once you are logged into blogger, click on the ‘New Blog’ button to create a new blog. One blogger account can have up to 100 blogs. In the popup window, give the title of your blog and in the address field, put your blog name. Its url will be sub-domain of blogger. Suppose, if title is like ‘Love My Pet’, then address could be lovemypet.blogspot.com. Initially pick any template for your website, given by blogger, later we can change it. Now click on ‘Create Blog’ and check your blog has been listed in your blogger account or not. Once your blog is created successfully, either click on ‘View Blog’ button or give the blog address url in address bar of any browser. Your blog will be up and running just like any another website. Only difference, it will have blogspot.com sub-domain. Now our next step is to give a proper name like www.lovemypet.com so that it looks like professional website. You can write posts, change templates/color/font size of your blog, add navigation menu bar. We will discuss these in next post.

Step 2) Buy domain name for your website
Now we will change the name of our website. To do this, we have to buy domain name so that our blog looks like www.lovemypet.com. What is domain? Domain is nothing but the address url of a website. Without proper domain name, we cannot open any website. Now one domain name can have sub domain also like blogger.com is a domain name but when we create our blog under blogger.com, we get address like mywebsite.blogger.com which is the sub-domain of parent one. To buy our own custom domain, we have to spend few bucks. Also price varies from domain to domain, like if you buy generic domain name like .com, .info, .org then you need to pay more. But if you buy country level domain like .in, .us, .uk then you pay less. There are many companies who provide domain names in cheaper rate like godaddy, register, bigrock, yahoo. Visit any of these sites and search for your domain name availability. Suppose Lovemypet.com is already taken by someone else, then you can either change the name like lovepet.com or if other domain extension (like lovemypet.org/lovemypet.co.in) is available, pick up any. So once you decide your website name, register and buy the domain. Before buying domain name, don’t forget to compare price in various websites as price may differ from one company to another. You can see various buying option like only hosting, hosting with server maintenance and email id. For the time being you can pick up only hosting option. After registration, you will get code which needs to integrate with your blog. It may take some time to get the code.

Step 3) Integrate blog with domain id
Once your domain registration is approved, login into hosting website with your user id/password. Here we will tell you few common steps what you need to perform to integrate your website. There may be additional steps as it differs from company to company. Few common steps are like below:
    a) Goto DNS Management of your domain name. Here you have to create 4 different ‘A’ records of domain by using 4 different IP addresses.
    b) After creating 4 different ‘A’ records, it’s time to set ‘Cname’ for domain. To do this, go to ‘Cname’ records and click on Add ‘C’ name record.
www in name box, put value ghg.google.com and TTL 28000 and save the ‘Cname’ record.

Step 4) Blog verification
Once you are done with ‘Cname’ configuration in your hosting website, we have to change few settings in our blogger account as well. So, login into blogger and select the blog for which you want to set up ‘Cname’. Go to ‘Settings’ > Basic > Publishing Blog Address > Add custom Domain name and in Advance settings, type your domain name.
Add a new ‘Cname’ here using verification code. Put the first code in ‘Name, Label or Host’ field, second code in the ‘Destination, target or Points to’ field and add TTL as 28000.

How to build a free website - techonestop.com

That’s all to give your blog a pro name. It may take few hours to do DNS settings and blog verification. Also the above steps, given in Step 3 and 4 may vary from one hosting company to another but mostly they are same. You can refer ‘how to setup’ docs, available in any hosting service provider website.
Also you can spend some time for decoration of your website. To do this, login into blogger account and select your blog. Go to setting tab and pick most suitable template for your website. Change the font color, size and background color in blogger provided interactive designer pane. If you want, add some custom HTML/CSS code or add gadgets. You can get many free templates over the net and integrate it with your blogger if you are not satisfied with templates, provided by blogger. That’s all to have your own website.
How can you make it completely free if you want a pro name for your website?
Let me tell you this how you can get website free of cost. You already know that one can have any number of blog completely free of cost. Now if you don’t want to pay a single penny to buy domain name, then go for domain co.nr. It’s completely free and don’t need to pay a single penny. To get this, visit www.freedomain.co.nr and register, this will give you a free domain name. Follow remaining steps to integrate you blog with .co.nr domain.

Do you have any question on how to create a free website? Then please write us. Sharing is caring, so please share it with your friends.To get more updates on recent activities, follow ‘TechOneStop‘ on Facebook/Twitter/LinkedIn.