Saw about 6 dropped pings, very nice for a controller failover!
Filed under: Uncategorized | 1 Comment »
So you bought an EqualLogic now what….. Virtualize Exchange Edition
Posted on December 21, 2009 by mellerbeck
So what should you consider if you want to virtualize your exchange server onto an EqualLogic SAN. Well, first start by reading this guide
Deploying Microsoft Exchange Server 2003 in an iSCSI SAN
Dell_Exchange_2007_equallogic.pdf
First, I would think you would want to do iSCSI attached volume for the Exchange DataStore. Why? by going this route you would be able to take advantage of the wonderful ASM/ME tools. If you are not in the know, ASM/ME stands for Auto-Snapshot Manager/Microsoft Edition (They also have the ASM/VE which is the Auto-Snapshot Manager/VMware Edition)
Another benefit of having it on a iSCSI attached volume is that it will be formatted NTFS which you can resize. (VMFS on the other hand you can’t resize easily as noted in this KB article)
****
Is it possible to increase the size of my VMFS volume?
It is possible to increase the size of a VMFS v3 datastore.
However, if a VMFS datastore needs more space the only current supported solution by VMWare is to create a new VMFS datastore and add new VMs directly to it or migrate VMs from the old to that new datastore. If the version of ESX in use is ESX 3.5, Storage Vmotion can be used to do this on live VMs. Documention on Storage VMotion can be found on the VMWare support site.
Note: While it is possible to resize a VMFS volume using VMWare disk extents it is not supported and not recommended. There are a few caveats to understand surrounding this.
1. VMware has not certified this use of extents for resizing. The intended purpose of disk extents is to add additional drives to a VMFS datastore, not resize an existing one. So in the future you could have issues getting support from VMware. There have also been reports of data corruption on the datastore after a resize using extents unless all I/O to that VMFS volume has been stopped.
2. The maximum size of disk in a VMFS volume is 2TB but a datastore may be 64TB in size which means that thirty-two 2TB VMFS volumes could be added into a datastore. There is some controversy within the VMWare community surrounding the issue of adding more LUNs to a single datastore at this time 10-09-2008. The more LUNs which exist in a single datastore will increase the iSCSI reservation overhead of all I/O. Since all volumes must have an iSCSI reservation asserted before I/O can begin. This should only be used when there is no other choice. For example: when you have a 2TB volume and you need to add another 2TB volume to the same VMFS partition of the datastore.
3. You can only resize a VMFS volume four times. This is because of how VMFS works, not an EQL array limitation.
Before attempting to resize a VMware VMFS volume, please contact VMware support for the most current information regarding VMFS volume extents.
Note: ALL I/O to that volume must be stopped BEFORE adding an extent. This is per the VMware support staff. VMFS corruption could result if I/O is ongoing when the extent is added.
Another option is to create a new volume on the array and format that VMFS. This will provide better performance and reduce iSCSI reservation conflicts when only one or two large volumes are used.
VMware supports states that there should be no more than 15 VMs / LUN for optimal performance.
****
If you do want to resize your NTFS partition dell has this awesome, and under-published tool called ExtPart.exe This is an awesome tool because it allows you to resize your system partition!!!
This is a great write up on how to do this inside vsphere! http://www.jjclements.co.uk/index.php/2009/09/14/vmware-esx-vsphere-resize-disk/comment-page-1/
Create your two virtual nics VMXNET 3 of course. Hardcode the Ip addresses, uncheck Client for Microsoft Networks, and File and Printer Sharing for Microsoft Networks. Uncheck the Register this connection’s addresses in DNS. Press Configure, advanced Tab, and flip the Jumbo Packet to Jumbo 9000 (assuming you are using Jumbo frames end to end of course)
Then install the HIT tools, it will recognize the exchange install and install those tools as well. (Need to be on exchange 2003 sp2 or 2007)
Go start, programs, EqualLogic, Remote Setup Wizard, then choose configure MPIO settings for this computer to exclude any subnets that you won’t be using for MPIO.
Ok, now create your volume on the equalLogic. Give access to your initiator. Connect to the volume.
Aligning the partition.
So to get the best performance out of your exchange environment you want to align your partition. Actually what is recent news to me was all of the various alignments that need to happen. So the first one is pretty easy, when you create a VMFS partition using vCenter it will automatically align it. So now your VMFS partition is aligned but your OS partition. This is mentioned here http://www.vmware.com/pdf/Perf_Best_Practices_vSphere4.0.pdf
on page32
Make sure the system partitions within the guest are aligned. For further information you might want to
refer to the literature from the operating system vendor regarding appropriate tools to use as well as
recommendations from the array vendor.
Well, how would you align your system partition then? This helpful doc from netapp shows the way http://media.netapp.com/documents/tr-3747.pdf
(Although in our case we want to align on 64 for equallogic)
In short:
Virtual disks to be used as boot disk can be formatted with the correct offset at the time of creation by connecting the new virtual disk to a running VM before installing an operating system and manually setting the partition offset. For Windows guest operating systems, one may consider using an existing Windows Preinstall Environment boot CD or alternative tools like Bart’s PE CD. To set up the starting offset, follow these steps. It also lays out how to do this inside of ESX!
1. Boot the VM with the WinPE CD. 2. Select Start > Run and enter Diskpart. 3. Enter Select Disk0. 4. Enter Create Partition Primary Align=64. 5. Reboot the VM with WinPE CD. 6. Install the operating system as normal.
Moving on… now that the OS partition is aligned and installed. Now we need to align our Data partition. In the above netapp doc it lays it out like this
1. Attach the data disk to the VM. Ensure there is no data on the disk 2. Select Start > Run and enter Diskpart. 3. Determine the Disk # for the new data disk and enter Select Disk # (E.g. select disk 1) 4. Enter Create Partition Primary Align=64. 5. Enter Exit to exit out of the Diskpart utility 6. Format the data disk as you do normally
EqualLogics Doc on the process is called Microsoft Windows Aligning Disk Sectors for Optimal Perfomance I stored a copy here
Now you can format the drive. Only use a Basic Disk.
As stated in the Deploying Microsoft Windows Server 2003 in an iSCSI SAN..pdf
Do not convert the disk to a dynamic disk.
There are several reasons why you must use basic disks:
• The utilities used to align disk sectors, can only be used with basic disks.
• The Microsoft iSCSI Software Initiator currently does not support dynamic disks. It has been observed
that there are timing issues that may prevent a dynamic disk volume on an iSCSI disk from being
reactivated at system startup.
• Microsoft Windows Server 2003 clustering currently does not support dynamic disks.
As stated here
Dynamic disks allow the joining of individual disk drives directly attached to a server (DAS) into a single logical volume.
In SAN configurations, the SAN itself can expand a volume, so the need to do this in a server is eliminated. Dynamic disks have several limitations including:
• cannot be used with Microsoft Clusters
• prevent hardware-snapshots from being brought online on the same host as the live volume
• not supported by the Microsoft iSCSI initiator
Dynamic disks can be used in iSCSI SAN configurations, but given the restrictions above, the server must be configured with iSCSI HBAs. One example of such an HBA which can be used which is supported by Dell Equallogic is the Qlogic 4062 dual port HBA.
Most administrators decide dynamic disks are un-needed in a SAN configuration and just use basic disks.
NOTE: If you happen to be using Microsoft DPM for protecting your storage data you will need to use Dynamic disks however so a method should be chosen to allow this which would be to use either Qlogic HBAs or to use Windows 2008 server which does support dynamic disks under the supplied embedded Microsoft initiator.
Dynamic disks are supported for server 2008 (http://download.microsoft.com/download/a/e/9/ae91dea1-66d9-417c-ade4-92d824b871af/uguide.doc)
Making sure Exchange comes up on an iSCSI drive
From here
You will need to mark the volume(s) as “Persistent Targets” so that the initiator will bring them online automatically when the system is rebooted. To do this, select the checkbox marked “Automatically restore this connection when the system boots” when logging the target in (from the Available Targets tab, click “Log On” to see this option). You only need to do this once per volume. If you create or change the iSCSI volume configuration (add, remove or reformat iSCSI volumes) you should check to ensure that the Exchange Server or SQL Server volume(s) are still marked as persistent (the Persistent Targets tab will show this information).
Once the volumes are connected and marked as persistent, you must logically bind the volume(s) to the iSCSI initiator. This causes the volumes to be marked so that, whenever the computer restarts, the system will pause until all the bound volumes reappear. Any time you change the iSCSI volume configuration (adding or deleting volumes) or if you reformat any iSCSI volume, you will need to re-bind the volumes.
To bind the volumes, select the Initiator Settings tab and click the “Bind Volumes” button. Note that you will not get any pop-ups, messages or other indication that anything has happened when you click this button.
To prevent Exchange Server or SQL Server from attempting to start before the iSCSI volumes are online, you must add a dependency to the Registry information for the corresponding service(s) to delay their startup until after the iSCSI service has started. Below is a step-by-step procedure for doing this. Please also refer to Microsoft Knowledge Base article 193888, “How to Delay Loading of Specific Services”, for general information on this topic.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. EqualLogic and Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
For Windows 2003 Server and Windows XP, please use the following steps:
Run the Regedit program.
Open the key “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services”.
Go down the list of service names and verify that there is one called “MSiSCSI”.
Go back up the list and find the key for “MSExchangeSA” (for Exchange Server System Attendant) or “MSSQLServer” (for SQL Server). Click once on it to select it. In the right-hand pane of the Regedit window you will see all values associated with the selected key. If there is already a value called “DependOnService” please do the following:
Right-click on the “DependOnService” value and select “Modify”. A dialog titled “Edit Multi-String” will appear.
Confirm that the Value Name shown is “DependOnService”.
Press the down-arrow key to put the cursor on the beginning of a new line at the end of the current entries, so that our new entry will be appended to the existing ones.
Enter “MSiSCSI” and then press the <Enter> key.
Click “Ok” to save the change.
In the Registry Editor window, look in the “Data” column associated with the “DependOnService” value and confirm that the data now includes the “MSiSCSI” entry at the end of whatever was there before.
Close Regedit.
If there is no “DependOnService” value please do the following:
In the Regedit menu, click on “Edit->New->Multi-String Value”. This will create a new entry in the right-hand pane called “New Value #1”, which will be highlighted. Enter the name “DependOnService”.
NOTE: Be sure to select “Multi-String Value” and not “String Value”. A “String Value” will appear to be correct in the “Services” tool dependency list but will not work correctly.
Right-click on the new “DependOnService” value and select “Modify”. A dialog titled “Edit Multi-String” will appear.
In the “Value data” box, enter “MSiSCSI” and then press the <Enter> key.
Click “Ok” to save the change.
In the Registry Editor window, look in the “Data” column associated with the “DependOnService” value and confirm that the data is now “MSiSCSI”.
Close Regedit.
Please remember to reboot your server after changing registry settings.
This looks like an easier way to do this from here http://support.microsoft.com/kb/870964/en-us
sc \\computer_name config MSExchangeSA depend= MSiSCSI
Addendum
What do you do if your partitions are not aligned? From
A couple of days ago we were troubleshooting a problem with one of our Windows 2003 systems performance with our Equallogic PS400E iSCSI storage system. The problem turned out to be caused by poor alignment of our disk partitions. Since we discovered that disk alignment could have a more dramatic affect than we had ever thought we decided to undertake a project to properly align all of our Windows and Linux systems. The Linux systems with LVM were pretty easy to move, but the Windows systems proved much more troublesome, espeically the boot drive. I was finally able to come up with a free solution that took time, but worked pretty well. I thought I’d document it here in case it helps anyone else.
First you should probably decide if you want to align all your volumes, or just the data volumes. Realigning the data volumes can be easily accomplished with tools like Ghost or Clonezilla, or even simply xcopy, robocopy, or backup/restore procedures. Simply add a new disk, create an aligned partition, and copy the data with your tool of choice. Doing the same on the boot partition is a little more inovled since it’s pretty easy to break the boot loader by moving data all around.
There are several reasons you might want to align your existing boot partition though, in many cases your swap file is on that partition and if your system does any swapping an aligned partition can be much faster. In our case we had several systems that had been migrated from older systems where everything was all on the C: drive. These systems used postgres database, did lots of logging, had some MSSQL Express thrown in, etc. While it might have been possible to reinstall and move all of these applications to a D: drive, it seemed like a lot of work and the documentation on the various apps was pretty weak. We decided it would be better if we could figure out a way to align the partition data without a reinstall.
This turned out to be much more difficult that I first thought. We didn’t own a version of Ghost that would clone Windows 2003 reliably, and so I went searching for a free solution. Clonezilla seemed promising, and we created the first clone of our system with it, but we were never able to get the newly cloned, properly aligned partition to boot.
Then I decided to give Gparted a try. Gparted is a great tool that can boot from a live CD and resize and move your existing partitions. The thought here was to use Gparted to simply resize the existing partition by 64 sectors and the move it slightly to the right to an aligned location. Unfortunately Gparted wasn’t quite as easy as I had hoped, mainly because the GUI only allows you to set sizes by MiB, not by sector. Still, I was undeterred, and I found a way to manipulate Gparted to do what I wanted. It takes two passes, which can take a long time if you have largish system paritions, but most of our were less that 16GB, with typically only about 8GB used. Here what I did:
!!! MAKE A BACKUP/SNAPSHOT IN CASE THINGS GO WRONG !!!
1. Make sure the disk is defragmented
2. Boot the system with the Gparted live CD.
3. Select the parition you are wanting to resize and choose (Move/Resize)
4. Shrink the volume by some amount, the smaller you shrink it the faster it will copy during the move step. I usually shrink it a GB or so larger than the amount of data on the drive.
5. Move the partition to right by a few MB’s to free up space at the start of the disk.
6. Once the move completes, exit Gparted, not the entire live CD, just the Gparted application
7. Start the terminal window on the live CD
8. In the command window type ‘parted /dev/sda’ (substitute your actual device here) to start the command line parted editor
9. Create a new partition at the start of the disk to fill in the space up to the section where you want to align your parition. For example, if you want your system partition to start at sector 128, create a very small partition that takes up space from sectors 63-127. The command would be something like this:
mkpart primary 63s 127s
This tells parted to create a new primary partition from sector 63 to sector 127. That means the very next sector available is 128, a stripe aligned partition. You may want a different start sector based on your array (some use 64K, some 128K, some bigger) but I’ve found the 128K alignment to work well with both 64K (Equallogic) and 128K (EMC Clariiion) stripe sizes.
10. Exit parted and restart the Gparted GUI by clicking the Gparted icon.
11. Use the Move/Resize option to resize the NTFS partition to fill the entire remaining space.
12. Exit gparted, run parted again, remove the small partition you created earlier and reboot.
Now you have a nice, stripe aligned NTFS partition that should still boot right up normally. The first reboot will run a checkdisk to make sure all the moving and resizing didn’t damage anything on the disk. Enjoy the improved performance and lowered IOPS on your SAN storage!
Obviously the steps above are just an outline, you really shouldn’t try this unless you understand what the above means, but if your comfortable with manipulating partitions the above should be enough to give you an idea what to do. I’ve found that the above procedure takes about 15-30 minutes for a typical 8-10GB system partition, so keep that in mind when planning downtime. Also, make sure your future OS deployments are aligned so you don’t have to repeat this again.
The above procedures work for virtual machine too (assuming the VMFS volume is aligned as well, which is done automatically with VI3 volumes and above). There are some other tools which will to this at the VMDK layer (Netapp has mbralign available to their customers and Vizioncore’s vOptimizer Pro will do it without having to copy the entire VMDK) but I don’t have any experience with these tools and I needed something that would work for physical machines too. The above procedure did the trick for me.
***
If you follow the instructions for creating a new mail store and then using the move mailbox tool to transfer over the mailbox be prepared to wait! You will have to wait for the mail store to replicate across AD before you will be able to mount it, and you will have to wait while the rules are replicated which will throw a ton of 1144 errors! Just FYI
Filed under: Applied IT, equallogic | Tagged: exchange | 1 Comment »
How to integrate with the Taleo webservice (API) using vb.net
Posted on December 18, 2009 by mellerbeck
If you just want to try it out, download TaleoExport from here
http://code.google.com/p/taleo-export/
The command line is
TaleoExport1.0 CompanyCode username password CustomFieldOnTaleoThatYouWantToUpdate SearchParameters OutPutDirectory
(Search Parameters are a key,value pair separated by a comma and if you have multiple pairs they are separated by a colon. Search parameters are additive for example if you want someone with the last name smith, who has status of NEW you would use lastName,Smith:status,NEW)
VERY IMPORTANT —PLEASE NOTE that the key is CASE SENSITIVE, but the value is not. Also note that if you give a bogus value(Or typo) you can cause BIG problems. For example if you sent LASTNAME,Smith:status,NEW it will export everyone with the status of NEW because LASTNAME is not a valid key!!! so make sure of your keys!
So here is an example that will get you those people with the last name smith, and the status of hired.
TaleoExport.exe ACOMPANY auser apassword Exported lastName,smith:status:hired c:\myExports
Ok, as I mentioned in this post http://wp.me/p8B7w-dr I have been exploring how to use the Taleo API. Taleo is a great system, and extremely flexible. What I do think they are lacking is transparency in how to use their web service. Actually, I am surprised that they don’t offer sample code (anywhere on the open web, there is some on their customer forum but you can’t see it until you are a customer… little bit of a catch 22 don’t you think) or even better a generic dump to flat file program.
Well, speaking of the generic dump to flat file program. That is exactly what I will show you how to make. Gotta scratch my own itch ya’know
So how would you use this? On the Taleo side of things you need a premium service level to allow you to use the API. Then you need to create a custom field by going to Administration, Customize Taleo Business Edition Recruit, Candidate Fields, scroll down to Candidate Custome Fields, and then Click New Field. If you want to match the default for the program create a Check Box with the Label of Exported and the External Name of Exported. (Don’t set the default to checked) (This checkbox will be set to true after we have exported the candidate data)
Ok, so download yourself a copy of vb.net express 2008. http://www.microsoft.com/express/vb/Default.aspx
Create yourself a new console app. So now we need to add two web services. They are listed here http://www.taleo.com/products/business-edition-integration-web-api.php
But here they are for your reference
Dispatcher API: DispatcherAPI.wsdl
Web API: WebAPI.wsdl
Ok, so how do you add a web service in vb.net? Right click your project (top right hand side) and choose add service reference. THEN, choose advanced because that is where they hide adding webservices. Click Add Web Reference on the bottom of that screen (easy to find huh) and then paste in the first web service (for the dispatcher URL). Then press Go.
If everything worked right you should have found the DispatcherAPI which has one method of getURL() this method gives you your URL that you will send all further requests to (and login) so click Add Reference.
Ok, so now we need to add the second webservice which is the actual workhorse. Follow the same procedure using the WebAPI.wsdl
Now, use some imports statements to make those webservices easier to deal with
Imports System.Xml Imports System.IO Imports TaleoConsole.net.taleo.tbe Imports TaleoConsole.net.taleo.tbe1
Ok, lets create some variables and instantiate our ‘IWebAPIService’
Dim myWebService As New IWebAPIService Dim myAPIKey As String Dim candidateArray As New ArrayList Dim exportKeyValue As String = "Exported" 'this is a custom field created on Taleo Dim companyCode As String = "yourcompany" Dim userName As String = "youruser" Dim userPassword As String = "yourpassword"
Ok, so as written in the documentation the first thing we need to do is get a url from the dispatcher. So lets instantiate the DispatcherAPIService and call getURL using your company code (assigned by Taleo)
Sub Main() 'get our URL using our companyCode Dim myDispatcherAPIService As New DispatcherAPIService Dim myurl As String = myDispatcherAPIService.getURL(companyCode) myWebService.Url = myurl
Ok, now we use the returned URL to login and get our APIKey (This APIKey is used for all our next queries)
'Now that we have our URL logon and get our APIKey myAPIKey = myWebService.login(companyCode, userName, userPassword)
So, now that we are logged on lets do something useful. Let’s search on all of my candidates and bring back the ones that have a status of hired and have not been exported yet.
In order to search we have to create an array of mapItem’s that contain key and value pairs.
'create an array of mapItem's that are key and value pairs Dim myArray(1) As mapItem myArray(0) = New mapItem myArray(0).key = "status" myArray(0).value = "hired" myArray(1) = New mapItem myArray(1).key = exportKeyValue myArray(1).value = "false"
To get our results back we need to create a SearchResultArr, then use our previously instantiated webservice send our APIkey, and our array of mapItems (key and value pairs)
'create a SearchResultArr to recive the results 'then submit to our webservice Dim resultsArray As SearchResultArr resultsArray = myWebService.searchCandidate(myAPIKey, myArray)
The resultsArray will contain a bunch of SearchResultBeans so instantiate a search result to use in our For Each statement. What we need from this search is the Candidate Id’s so we can use them to get the full details of the the candidate. Once we have the id use the getCandidateById method to return the full details and then add them to an arrayList for writing out to XML.
'take that list and get each candidates data using id 'add to arrayList Dim aBean As SearchResultBean For Each aBean In resultsArray.array Dim myCandidateData As New CandidateBean myCandidateData = myWebService.getCandidateById(myAPIKey, aBean.id) candidateArray.Add(myCandidateData) Next
Then we will call the WriteOutData function. At a high level this creates an xml doc, and for each candidate it lists through the methods and uses the CallByName function to output any of the values.
Public Sub WriteOutData()
Dim doc As New Xml.XmlDocument
'create nodes
Dim root As Xml.XmlElement = doc.CreateElement("TaleoExport")
Dim aCandidateBean As New CandidateBean
Dim aFlexValue As New FlexFieldBean
Dim pdc As System.ComponentModel.PropertyDescriptorCollection
Dim pdc2 As System.ComponentModel.PropertyDescriptorCollection
For Each aCandidateBean In candidateArray
Dim eCandidate As Xml.XmlElement = doc.CreateElement("Candidate")
Dim valueTxt As XmlText
Dim eValue As Xml.XmlElement
'iterate through every method in CandidateBean Object
'and save the value out to XML
pdc = System.ComponentModel.TypeDescriptor.GetProperties(aCandidateBean.GetType)
For Each pd As System.ComponentModel.PropertyDescriptor In pdc
eValue = doc.CreateElement(pd.Name)
'detect the flexValues
If pd.Name = "flexValues" Then
Dim eFlexValues As Xml.XmlElement = doc.CreateElement("FlexValues")
For Each aFlexValue In aCandidateBean.flexValues
pdc2 = System.ComponentModel.TypeDescriptor.GetProperties(aFlexValue.GetType)
For Each pd2 As System.ComponentModel.PropertyDescriptor In pdc2
eValue = doc.CreateElement(pd2.Name)
valueTxt = doc.CreateTextNode(CallByName(aFlexValue, pd2.Name, CallType.Get))
If Not valueTxt.Value = "" Then
eValue.AppendChild(valueTxt)
eFlexValues.AppendChild(eValue)
End If
Next
Next
eCandidate.AppendChild(eFlexValues)
Else
valueTxt = doc.CreateTextNode(CallByName(aCandidateBean, pd.Name, CallType.Get))
' don't write tags if they don't contain data
If Not valueTxt.Value = "" Then
eValue.AppendChild(valueTxt)
eCandidate.AppendChild(eValue)
End If
End If
Next
root.AppendChild(eCandidate)
Next
'put them all together
doc.AppendChild(root)
'save it
Try
doc.Save("c:\OutPut.xml")
Catch ex As Exception
End Try
End Sub
Ok, well that source line wraps awful but we only have one more thing to do, we need to update the status on Taleo that our Candidate has been exported.
Once again we will iterate through our candidates in our array, then we will look for the fieldName that matches our exportKeyValue (custom field\checkbox created on Taleo to mark the candidate as exported) and then we will set the boolean value to true. Then after we are done we will update the candidate using the updateCandidate method (you need to push back all of the data or else it will clear fields that don’t get re-filled in again, if that makes sense)
Dim aCandidateBean As New CandidateBean Dim aFlexValue As New FlexFieldBean For Each aCandidateBean In candidateArray For Each aFlexValue In aCandidateBean.flexValues If aFlexValue.fieldName = exportKeyValue Then aFlexValue.valueBool = True End If Next myWebService.updateCandidate(myAPIKey, aCandidateBean) Next
To make this into a more generic Taleo Flat filer we can pull out the companyCode, userName, and userPassword, and the search array as parameters.
Notes: The Tale WebAPI guide has typos with what the datafield name should be. I think this was caused by auto capitalization. Things like Phone should really be phone, Status should be status etc…
Filed under: Applied IT, Taleo API | Tagged: taleo, Taleo API | 6 Comments »
Coolest function of the day, call an objects method using a variable, Dynamically invoke properties by string name using VB.NET
Posted on December 17, 2009 by mellerbeck
So I had always wanted to be able to do something like this
dim myDog as new dogobject
dim methodVariable as string = “bark”
myDob.(methodVariable)
i.e. call a method by using a variable
Well, after some serious googling, I finally ran across this function CallByName
http://msdn.microsoft.com/en-us/library/chsc1tx6%28VS.80%29.aspx
this allows me to do this
CallByName(myDog,methodVariable,CallType.Method)
or if you wanted to iterate through ever method in the object you could do
Dim pdc As System.ComponentModel.PropertyDescriptorCollection
pdc = System.ComponentModel.TypeDescriptor.GetProperties(myDog.GetType)
For Each pd As System.ComponentModel.PropertyDescriptor In pdc
CallByName(myDog,pdc.name,CallType.Method)
Next
Filed under: Applied IT | Leave a comment »
Exploring Taleo Webservice
Posted on December 16, 2009 by mellerbeck
First things first get the WebAPI doc from here http://www.taleo.com/products/business-edition-integration-web-api.php
They mention that first you get a web address from the dispatcher and then you use that for your queries. They mention testing with soapUI to test out your requests. You can get soapUI from here http://www.soapui.org/
So in soapui I created a new project and pointed it at this WSDL http://tbe.taleo.net/wsdl/DispatcherAPI.wsdl
Just for grins I pressed the green arrow, which of course responded back that it didn’t know my company name… hmm so how to pass it my credentials. Look in the guide for info about the getUrl
Ok, in soap I edit the request this line has a ? which needs to be replaced with our orgCode
<orgCode xsi:type=”xsd:string”>?</orgCode>
After editing I press go, and in response I get an https://tbe.taleo.net/etc…/etc…
Ok, so now I am assuming I will need to log on to this dispatched site.
I create a new project in soapUI and then use this link as the wsdl http://tbe.taleo.net/wsdl/WebAPI.wsdl
Scrolling around I see a login request. Doubling clicking on it I see
<in0>?</in0>
<in1>?</in1>
<in2>?</in2>
Checking the WebAPI.doc I can see that this is what is expected
| Data Field Name | Data Field Type | Required | Acceptable Values |
| in0 | String | Yes | Company Code |
| in1 | String | Yes | User ID |
| in2 | String | Yes | Password |
So I will fill in those tags with my creds and see what happens. Hmm I wonder how I tell it to use the dispatched URL….
Hmm so that is a roadblock, java.lang.IllegalStateException: No value for key [org.hibernate.impl.SessionFactoryImpl@3710b205] bound to thread [TP-Processor19]</faultstring>
<detail>
So, then I decided I should fire up Altova Mapforce (I love that software) unfortuantely I couldn’t get it to work either…
Hmm… well I will continue investigating
Filed under: Uncategorized | 2 Comments »
I was extremely amused by this post about EDI and SaaS
Posted on December 16, 2009 by mellerbeck
As the guy who gets to read really long EDI specs I can emphasize with this post. Even more amusing was the fact that I had implemented the 48 page Target 850 purchase… and am in the middle of reading and implementing the Taleo API docs. It was like this blog post was written for me!
Filed under: Applied IT, EDI | Tagged: taleo | Leave a comment »
components required to enumerate web references are not installed vbexpress 2008, solved
Posted on December 15, 2009 by mellerbeck
Could’nt find out how to do this for visual basic express. You need to use vbexpress /resetskippkgs
“C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\vbexpress.exe” /resetskippkgs
Filed under: Applied IT | Leave a comment »
