Parse AIM Buddy List Export file and Import to LCS 2005 Client

Architecture, Tools, and Process for ISVs

‹ Microsoft ISV
- Archive
  - Windows Live
  - Game
  - SharePoint
  - Visual Studio
  - Smart Device
  - Office
  - VC++
  - Architecture
  - VB
  - VS 2008
  - VS Express
  - Dotnet
  - ISV
  - Windows Forms
  - SQL Server
  - IE
  - VFP
  - Windows Vista
  - Visual C#

- Previous
  - 1
    - Adding Outlook signature using OLE automation. It should be noted that the previous message code only seems to work if the Outlook BodyFormat is set to HTML. For some reason adding the text or RTF signature file to the Body isn't working for me. If you set HTMLBody using the text (BodyFormat is plain text) or RTF (BodyFormat is rtf) signature file, the BodyFormat is overridden to HTML. If you set the 'Body' property using the text or RTF signature file, the BodyFormat remains unchanged, but all of the RTF codes from the RTF signature file are displayed, and the text signature file doesn't display correctly when the BodyFormat is plain text. Maybe something else in Outlook needs to be set to handle the signature file content correctly Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 2
    - Once copied, can we export as a GIF file? I doubt very much you can do that, or if you can it's a long difficult way to do a simple thing. If your looking to email parts of a spreadsheet your best bet is to format the cells into html/text and display them in the email message. How you go about putting the cells as html/text into an email message is another matter, if you co with copy and paste then the user needs to manually do the paste in Outlook, on the other hand if your sending the email through VBA interop with Outlook objects then all you need to do is create the email and set it's message body and address info. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 3
    - help required related LCS(Live Communication Server). i wanted to make a client that will get the status/username of the user from the LCS and initiate a collaboration chat session between the LCS users and between my client application.........is it possible our nt . Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 4
    - this problem is also troubling me now!! :( I passed this issue to a Microsoft support engineer, and here is what he said: Based on what I gather from the case notes and the article that was pointed out, I think the customer is running into a known problem when connecting to SharePoint 2003. There is a bug in the wss object model code when connecting to a site using the fully qualified domain name. The problem arises under this circumstance because wss does not go out to the DNS server to do name resolution. The scenario of using a fully qualified domain name in the code will only work if the host header is local to the IIS metabase, this is easy to do in a test environment where everything is in the same environment but will not work in a production environment with a DNS server. The only workaround to this is to use either the IP address or the netbios name of the server rather than passing the fully qualified domain name to the object model when referencing a site. So instead of writing code like this: SPSite site =new SPSite( http://test.domainname.com ); You need to write it like this: SPSite site =new SPSite( “http://<IP address>” ); or SPSite site =new SPSite( “http://<Server Name>” ); A good way to approach this is to have the IP address encrypted as a key in the configuration file, read the key and decrypt it in the code and use the value to establish the connections to the sites. The advantage of this is that you won’t need to hard code any values in the code. I think this will take care of the problem for the customer but please let me know the results. The customer also had the question of “Is it possible to connect to a SharePoint site and retrieve a document from a machine where the SharePoint is not installed by using the SharePoint object model ”, I have address this below. Yes, there are ways to connect to a SharePoint site from a machine which does not have Sharepoint installed, however, you cannot use the object model directly. You will need to create an application (web or console) that will make use of the SharePoint web services hosted on the SharePoint server machine. There is also the option of using FP RPC to connect to and manipulate document libraries. --Thanks Lisa (ISV Buddy Team) Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 5
    - Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset I've been seeing some of the same issues with specific laptop configurations using only IE7. Also the zoom level has no affect worse or better for the problem. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 6
    - WMI.Net 2.0 Is there any documentation on this new implementation I have done little bit experimenting with it using the reflector tool and able to create a basic instrumented applicatoin with read/write properties and few methods. The new API is much better than old one with a good fine-grained control over various aspects of WMI. I can see this model mimicing the .net configuration model so it would be an easy learning with this model. My quick test shows tha this implementation is less fragile than old System.Management one especially in-terms successive registration/un-registration in WMI repository. It worked quite well. I'm really looking forward to use this in some depth; I would be thankful If you could point me to some documentation on this Thanks, Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 7
    - Word document Hi Friends I have two word documents.I have to compare the both documents.The difference between the two document is that the second documents contains an image,insert some data or delete some existing data.I am able to find the changes and store the result in another document in which the changes reflects.Now our main moto is how can the end user identify that there is a change of only image in both the documents without opening the word file. Thank & Regards Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 8
    - iexplore.exe - Application Error I'm getting this with IE 6. Just started as well. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 9
    - How do I deal with files of more than 65k rows? I am not sure how can that be bad. You can read the data and export it to a predefined paths. You are not changing the original file. But With 2 to 3 million rows of data, I don't think opening them in multiple sheet is a such good idea. Your code will be too slow since it is dealing with too much data on spread sheet. Have you consider reading the file using SQL If your actual working data is just a small portion of your source, you can run query to filter out the unwanted data before you populate your worksheet. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 10
    - Using VBA macro to locate next free column on worksheet Woot, that's so much simplier than mine. Is this faster than using Find backward from the end of the sheet What's the performance of Find function Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 11
    - Setting a Bookmark to insert a Page Break in MS Word Hi! I know how to use setBookmarkString, but I need to insert a Page Break with a Bookmark. What Function do I use thanks in advance Pieka Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 12
    - Macro - Replacing Contents of Cells When dealing with the a spreadsheet, is there a macro code that would replace the contents of a cell with a "0" for all of the cells in each column in the Questions worksheet that do not match the criteria from a specific cell in the Solutions worksheet I received wonderful help for a similar question on the same worksheet with the following original question: I am trying to write a macro that will use one sheet, Solutions (Sheet 1), with a specific cell range, B2, and find and replace the reference from cell B2 in a specific column, G, in Sheet 2, Questions, and replace with the value 1. Right now I am using B2 from Solutions Sheet 1 that contains the cell named Financial (Revenue) reporting, and using that as a specific search criteria in column G, but is there a way to use the reference B2 and find and replace cells in column G that are also labeled Financial (Revenue) reporting without using the actual name "Financial (Revenue) reporting" but if the cell in column G, Sheet 2 Questions, matches B2, Sheet 1 Solutions, then replace that specific value in column G, Sheet 2 Questions, with a value of "1" The following is the outcome from that original question that I am building my spreadsheet from: Code Snippet Sub Macro1() ' ' Macro1 Macro ' Macro recorded 5/8/2007 by Rachel ' ' Sheets("Questions").Range("G:G").Replace What:=Sheets("Solutions").Range("B2"), Replacement:="1", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:= _ False, ReplaceFormat:=False End Sub Thank you! Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 13
    - Getting data from other workbooks Hi Have a look at Andy Popes answer to How do i reference a cell in an unopened workbook in this forum this might help. The approach uses a working cell in the current book. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 14
    - Run Time Error 9 when Calling a Userform As you say that is a simple piece of code :) which is not the cause but the entry point to the problem. Can you check the userform itself of any code in either the Initialize or Activate event. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 15
    - Excel CheckBox - Enabled "False" but I don't want it grayed out The Locked property will only work if the control is on a userform. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 16
    - iexplore.exe - Application Error I'm getting this with IE 6. Just started as well. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
- Next
  - 1
    - How to make a macro to copy some parts of a table to an email that it will create? Hi Joseph, thanks for the website. It helped me alot. I have identified the code that may be able to solve my problem. However, If I may ask, is the codes for Microsoft Word and Excel the same I think this part of code can help me copy the table out to the body of an email, currently it copies the cells B15 to B20 in the Excel worksheet. How can I make it to copy the first table in a Word document Is it possible to code it such that it only copies certain rows of the table For example I just need rows 1, 2 and 4 and not row 3 to be copied to the body of the email. Sub Mail_Range_Outlook_Body() ' Don't forget to copy the function RangetoHTML in the module. ' Working in Office 2000-2007 Dim rng As Range Dim OutApp As Object Dim OutMail As Object With Application .EnableEvents = False .ScreenUpdating = False End With Set rng = Nothing On Error Resume Next Set rng = Sheets("MailRangeSelection").Range("B15:B20").SpecialCells(xlCellTypeVisible) On Error GoTo 0 If rng Is Nothing Then MsgBox "The selection is not a range or the sheet is protected" & _ vbNewLine & "please correct and try again.", vbOKOnly Exit Sub End If Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = " ron@debruin.nl " .CC = "" .BCC = "" .Subject = "This is the Subject line" .HTMLBody = RangetoHTML(rng) .Display 'or use .Send End With On Error GoTo 0 With Application .EnableEvents = True .ScreenUpdating = True End With Set OutMail = Nothing Set OutApp = Nothing End Sub Once again, thanks for the help! Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 2
    - Automatically send attachment in email with a submit command button in word Hi Did you remeber to send the mail item in your code Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 3
    - Excel VBA Hi everbody! I am using Excel and I wrote a code using VBA. I have subroutine which open and read text file. I call this subroutine in the master program. The object of the program is to open read a text file(numeric) and make average of the data , make a table and fill the table with the data. However, I want to modify the program so that it can open 5 text file at the same time and process the data. Below I have a code that open and read one file. Could you please give me an advice how to open and read multiply files at the same time Thanks in advance Filename = Application.GetOpenFilename() Close FileNumber = 1 Open Filename For Input As #FileNumber ' Get data, here I call the subrutine that read the data Close If DataCount = 0 Then MsgBox "No data" Exit Sub End If Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 4
    - .mdmp files not being created OK, while setting ForceQueue to 1 does happily generate the minidump, now the user sees no UI of this happening. Before, a dialog said <Program> has stopped working ... [Debug] [Close Program] Is there a way to both generate the minidump AND have the dialog Thanks, David Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 5
    - How do I accomplish this in VBA using Office 97 and later? I am trying to come up with a system that would improve efficiency in creating Request for Quote and Purchase Orders. As an example, here is what I am trying to do with the Request for Quote. 1.) A new document from a template called "Request for Quote" is created. 2.) The system asks for an Excel file to import that has bid item information in specific columns and from a set row down to the end. 3.) The system uses an Outlook address book to pull up a list of vendors. You can then select a checkbox control next to each vendor to include the vendor. Vendors are displayed one by one from top to bottom. 4.) The same thing done in step 3 is performed for the bid items using the Excel file imported earlier. 5.) The information is appropriately placed in the template. I can apply the Request for Quote concepts to Purchase Orders. Any idea on the most efficient way to accomplish this type of system Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 6
    - ASP .NET 1.1 fails at install, but not .NET Framework 1.1 Hi there, My Scorecard Manager 2005 installation finds that I do not have ASP .NET 1.1 installed, but it finds .NET Framework 1.1 installed. I could not find a download for ASP .NET 1.1 outside of the .NET Framework 1.1. Can anyone explain in a few words what is the difference between the framework and the asp .net To note that when I try to install the .NET Framework 1.1, which I cannot see installed in my programs, the installation is failing due to product already installed. I am a little confused. The OS is Server 2003 SP1. Thank much. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 7
    - How to allow cookies for Windows Live ID Hi, This Windows Live Help Central page covers Windows Live ID and Hotmail issues: http://help.msn.com/(cHJvamVjdD1wYXNzcG9ydDQmbWFya2V0PWVuLVVT)/help.aspx querytype=topic&query=Passportv4_TROU_CannotSignIn.htm&fs=1 I hope this helps you resolve the issue. -brenda (ISV Buddy Team) Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 8
    - Projects, objects & modules Place this code in Thisdocument. Save/close the file then re open it. The Open event will be trigger and the message displayed. Private Sub Document_Open() ' will display a message box when document is opened. MsgBox "Hello World" End Sub ThisDocument refers to the document that contains the code currently being executed. The application also has an ActiveDocument reference which as the name suggests refers to the active document. The updating of this reference is handled automatically by the application. Copy the following code into a standard module within your document. Within the VBE (Visual Basic Editor) environment press CTRL+G to display the immediate window. From here you can run the macro by simply typing DocInfo and pressing enter. The message boxes should display the same name for This and Active document. Now open another document file and re run the macro. This time the activedocument name should be that of the newly opened file whereas the Thisdocument will be the same. Sub DocInfo() MsgBox "Thisdocument is " & ThisDocument.Name MsgBox "Active Document is " & ActiveDocument.Name End Sub Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 9
    - A macro to count the number of macros in a woorkbook Never mind, I just had to check the box in the Macro Security settings to trust access from VB programs. Thanks again Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 10
    - ComboBox listing on Startup You have missed the Sub out of your code example Code Snippet Private SUB UserForm_Initialize() ComboBox1.AddItem ("Open App1") ComboBox1.AddItem ("Open App2") ComboBox1.AddItem ("Open App3") ComboBox1.AddItem ("Open App4") End Sub Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 11
    - PASSING MS OUTLOOK DATA TO EXCEL Is it possible to pass Outlook information such as dates and durations of meeting to an Excel spreadsheet I would need to do this via a macro. I need this to create a time card that tracks how much time is being spent in meetings. Thanks! Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 12
    - MDI on old Office but not on new Office 2007? I had regularly emailed myself in the past from my older version office {2003} {work laptop with no printer attached} to my newer office XP on my personal system to print but now that I have upgraded to Office 2007 the MDI is not recognized. How can I install the MDI drivers so I can print again Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 13
    - referenced memory error hello people. can someone help me. My computer displays an error saying instruction at "0x269e7875" refernced memory at "0x269e7875". The memory could not be "read". Click ok to terminate the program. And I cannot switch from one user to another. I can log-off from windows and switch user. It needs to be restarted every time I want to switch from one user to another. Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 14
    - Visual Basic Code Corrupted? Hi, I have been having several problems on a complicated excel spreadheet that I have been developing, that have led me to believe that the file i am working on has been corrupted. The problems started when I switched PC's that I used for developing (i.e. was given a slower PC to work on). Since then, I have been having all sorts of problems with my macros. Now, even when I open the file on other, faster machines, the results are still unstable, with features that were previously working normally still not working. Is it possible that the PC that I switched to has somehow corrupted the compiled VBA code stored in the excel file For example, a simple procedure that hides some columns on a sheet when a value is changed is not working. However, when I duplicate the exact same code, and trigger it when a different value on the sheet changes, the new procedure works. (The old procedure has a problem with activating the sheet on which to hide the columns). As the code is exactly the ame, could it be that the already complied VBA code in the excel file is corrupt Many thanks for any help! Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 15
    - Removing "Trial Version" from Web Components on SharePoint web sites Hello, I would like to remove the "Trial Version" as stated above. I used CSS but then other part disappear as well so this is not an option. Then I tried JavaScript but wasn't working either. Question: is it somehow possible to do it with JavaScript (I have only limited scripting capabilities). Or can I directly access the template that creates the different sharepoint web sites for my purposes I would appreciate advice on this matter and thank you for your attention. Regards Christian Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client
  - 16
    - Multithreading with VBA6 and Access Hello, I'm not so familiar with VBA/Access. I have to maintain an existing application. Now I need that a user can use the application and in the background a function must at certain times (these times are in a table param) lookup and export a XML file from a query. IS IT POSSIBLE TO CREATE MULTITHREADING WITH VBA AND ACCESS AND IF YES HOW I read at some forums it should be possible but I have never read how Thanks in advance. Nico Tag: Parse AIM Buddy List Export file and Import to LCS 2005 Client

Bryan Tidd

I'm working on a migration project from the wide use of AOL AIM to Office Communicator 2005 and Live Communication Server 2005. I can create a text file export like the following:

Config {

version 1

}

User {

screenName thereScreenName

}

Buddy {

list {

"GroupA" {

"buddy1"

"buddy2"

}

"GroupB" {

"buddy3"

"buddy4"

}

}

}

There could be any number of groups. I will provide variable inputs for the input file and output file locations.

I need to be able to make a new file like:

buddy1 sip:buddy1@aol.com

buddy2 sip:buddy2@aol.com

buddy3 sip:buddy3@aol.com

buddy4 sip:buddy4@aol.com

I am completely a newbie in C#, but I was requested to use it.

Any assistance would be great. I will request that the resulting tool be open source and publicly available, so please keep that in mind.

Top

Re: Parse AIM Buddy List Export file and Import to LCS 2005 Client

sgood

Did you every successfully get the script working to get the AOL buddy list into LCS

Top