Interoperability Scenarios: Technical Questions Forum

Reusing Word instance

Fri, 20 Nov 2009 10:53:17 Z

Hi,

I have an application that needs to use MS Word to open a document and save it in a different format. If there is already an instance of Word open, I want to reuse this process, otherwise I want to create a new one. So every time my application needs this Word instance it calls the following code:

private Microsoft.Office.Interop.Word.Application GetActiveApplication()
        {
            Microsoft.Office.Interop.Word.Application app = null;

            try
            {
                app = System.Runtime.InteropServices.Marshal.GetActiveObject("Word.Application")
                    as Microsoft.Office.Interop.Word.Application;
            }
            catch (Exception ex)
            {
                // Log exception
            }

            if(app == null)
                   app = new Microsoft.Office.Interop.Word.Application();

            return (app);
        }

So if Word wasn't opened yet or if someone shut it down in the meantime, this will create a new instance; otherwise it reuses the existing.
This works well so far, but I was wondering if there is some cleanup code I should include here - whether for the case when I create a new instance or reuse the existing one? Just remember, I do not want to close the instance either way when I'm done with using it.

Thanks.

Cannot invoke MSCOMMLib.MSComm through JavaScript in IE.

Wed, 18 Nov 2009 17:03:32 Z

Cannot invoke MSCOMMLib.MSComm through JavaScript in IE.

I need to interact with the hardware through the serial ports.
I have a legacy code that had been working for quite a while on the web site, but it stopped working at all a couple of month ago on all of the client’s machines.

Here is the simplified version of the JavaScript code and markup on the page

MsComm control itself in the markup:

</object>

Here is the JavaScript that sets port number for MsComm and basically starts it.

function Listen(button) {

var port = 3 //getPortNumber();

if (isNaN(port))

return;

var com = $get("MsComm");

try {

com.CommPort = port;

} catch (ex) {

alert(‘Invalid port number’);

return;

}

if (!com) {

alert('MsComm control is not Installed on your computer.');

return;

}

try {

com.PortOpen = true;

} catch (ex) {

alert(‘Invalid port number’);

return;

}

button.disabled = true;

alert('Ready’);

}

Here is the javascript code that is supposed to be invoked on OnComm event of the MsComm. It had been working before but now OnComm just never fires.

alert(‘Data received!’);

</script>

I wrote simple application in C# that uses MsComm and it works perfectly and invokes OnComm event Here is the code:

MSCommClass commClass = new MSCommClass();

try

{

commClass.CommPort = 3;

commClass.RThreshold = 1;

commClass.Handshaking = HandshakeConstants.comXOnXoff;

commClass.PortOpen = true;

commClass.OnComm += new DMSCommEvents_OnCommEventHandler(commClass_OnComm);

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

Console.ReadLine();

commClass.PortOpen = false;

static void commClass_OnComm()

{

}

To mee it looks like I cannot invoke MsComm through javascript anymore. Even if I write

Var obj = ActiveXObject(“MSCOMMLib.MSComm”)

I get following error - “Automation server can't create object”.

I am pretty sure that MsComm is in registry though.

MyP3uK

handle a .net Com Class event in vb6 - the event does not send

Fri, 13 Nov 2009 09:37:15 Z

i have the ComClassSearchCustomers class and interface IComClassSearchCustomersat .net which used to create a tlb file. The class raise an event inside new. After that i have a vb6 form Form1 which catch the event , but it never see the event. Any ideas?

Option Strict On
Option Explicit On
Imports System.Runtime.InteropServices

<Guid("BB86EB1C-6444-424f-B83B-A667561E06C3"), _
ComSourceInterfaces(GetType(IComClassSearchCustomers))> _
Public Class ComClassSearchCustomers

    Public Delegate Sub printReportEventHandler(ByVal codes As String)
    Public Event printReport As printReportEventHandler

       Public Sub New()
         MyBase.New()
         RaiseEvent printReport
    End Sub
End Class


Imports System.Runtime.InteropServices

<Guid("D8F7EC74-0EFC-4e43-9B59-4CF741DF616D"), _
InterfaceType(ComInterfaceType.InterfaceIsIDispatch)> _
Public Interface IComClassSearchCustomers
    <DispId(1)> _
            Sub printReport(ByVal codes As String)
End Interface

Public WithEvents Instance As Search.ComClassSearchCustomers

 Private Sub Form_Load()
 Set Instance = New Search.ComClassSearchCustomers
End Sub

Private Sub Instance_printReport(ByVal codes As String)
MsgBox ("raise")
End Sub

Outlook Anywhere Access Problem

Fri, 06 Nov 2009 07:11:55 Z

Background: Company has installed Exchange and Sharepoint on same server.

Needs: I need remote access/sync from Outlook to Exchange Server for e-mail without VPN access.

Status: I was told Outlook Anywhere will not work. Quote from IT Department "Because of the way the server was set up initially there is no way to do the remote outlook. We put SharePoint on the same server as Exchange. Sharepoint uses the default domain address to run. 2007 Outlook allowed for remote access using the default domain address but we are already using it."

Interestingly, I have successfully added access to the Exchange Server on my iPhone using HTTPS.

Questions: This was a very simple set-up on iPhone. Why can't I get the same functionality on my laptop? How can I make Outook Anywhere work (server config, client config)?

MSDN Subscription - (Developers Tools Area) WebSiteSpark Subscription - DVD Version

Tue, 03 Nov 2009 21:58:39 Z

Product Version:: Expression Studio 3 (Expression Blend 3 (3.0.1927.0))

I have a MSDN WebSiteSparks Subscription. In this area there is two Expression Studio 3 downloads. One is the CD version and the other download is the DVD version. The CD version doesn't require a Product Key to be entered. The DVD version requires a producy key.

The CD version is the full version of Expression 3 with all 4 programs. The DVD version has 3 programs. It's missing Expression Blend 3.Is this by designed?. Expression Blend 3 is the hub between VS 2008 Pro, Expression Design 3 and Expression Encore 3.

Work Around Solution:

Went into the CD version setup directory and ran Blend_en.msi and BlendSDK_en.msi and then entered the DVD product key.Add Expression Blend 3 to the DVD version. Otherwise that suite will be almost useless for design tools purposes.

Michael Summers

NetFwTypeLib and ComElevation dllhost fails to exit

Thu, 22 Oct 2009 08:06:27 Z

I am using the comelevation sample from the vistabridge library in the windows sdk to elevate a .net class I exported to a com typelib.

To demonstrate what I have done consider something like this:

    class Firewall:IDisposable
    {
        INetFwPolicy2 policy = (INetFwPolicy2)Activator.CreateInstance(...);
       
        bool FirewallEnabled
        {
            get { return policy.get_FirewallEnabled(profileType2); }
            set { policy.set_FirewallEnabled(profileType2, value); }
        }

        void EnableRule(string group, string ruleName, bool enable)
        {
            IEnumerator enumerator = null;

            try
            {
                enumerator = this.policy.Rules.GetEnumerator();

                while (enumerator.MoveNext())
                {

                    INetFwRule iNetRule = (INetFwRule)enumerator.Current;

                    if (string.Equals(iNetRule.Grouping, group, StringComparison.OrdinalIgnoreCase))
                    {
                        if (string.Equals(iNetRule.Name, ruleName, StringComparison.OrdinalIgnoreCase))
                        {
                            iNetRule.Enabled = enable;
                            Marshal.ReleaseComObject(iNetRule);
                            break;
                        }
                    }
                    Marshal.ReleaseComObject(iNetRule);
                }
            }
            finally
            {
                if (enumerator is IDisposable)
                {
                    (enumerator as IDisposable).Dispose();
                }
            }
        }


       public void Dispose()
      {
 
         Marshal.ReleaseComObject(policy.Rules);
 
         Marshal.ReleaseComObject(policy);
      }

    }

When I create my elevated com object and change the value of the property, all is well. When I do the same and call the function, it works but the dllhost process fails to exit. I am calling Marshal.ReleaseComObject on my elevated class. I narrowed the problem down to: Any time I iterate through the INetFwPolicy2.Rules the dllhost process fails to exit. In the above codeblock the function calls Marshal.Release... on each rule, I have tried without this call as well to no avail.

Any thoughts?

1000001 1100001 1110010 1101111 1101110 100000 1000001 1110011 1101000 1100101 1110010

Miscrosoft Interops Compatibility Issues

Thu, 15 Oct 2009 12:32:21 Z

Hi , Im a web developer working on asp.NET . In times i supposed to work on export from aspx page to word/excel using microsoft interops , things are good , but am facing some compatibility issues among different versions of office tools ? how to maintain a standard among different versions of Office ? can i have any code ?? generic for all versions of Microsoft Office tools ??

-Prince

Convert word to Jpeg or TIFF files

Fri, 28 Aug 2009 10:53:19 Z

Using C# can we convert Doc file into Jpeg/Tiff(Not PDF).
First option is Jpeg.
Please suggest some solution for this..

Merging Word Documents in ASP.Net

Wed, 26 Aug 2009 10:05:03 Z

Hello Guys

I have a requirement in my project to merge multiple word documents in a one doc file. All the formatting must be retained.currently I am using words' com methods to merge the documents.But it has some formatting problems.I am looking for some third party library/dll to use in my code for merging purpose.Please help me out if you are aware of such a library/dll that works very well with all the formatting, tables and hyperlinks in the documents

Thanks a lot

Regards
Vivek

Problem while splitting table cells in word 2003's XML file.

Thu, 23 Jul 2009 06:07:50 Z

Hello,

I have created a table with 2 rows,like below in word 2003's XML file.

1		2		3		4
5	6		7		8		9

i wanted to split 5th cell into 4 cells programatically(DOM+java) , so have taken 5th cell's width and devided by 4, then distributed that width in 4 splitted cells, but it is disturbing other cells in the table, so how i split the cells without disturbing to the other cells in the table.Please help me regarding this.

Thanks
Shree

MPP Extraction for MS 2003 project in dot net

Fri, 10 Jul 2009 12:37:47 Z

I am using MS Project 2003 interop and want to dump all data from .mpp file to database.
I have created database using Microsoft MS Project 2003 script provided in setup.

Now i am getting all the values from interop object model
e.g. MSProject.Project properties like ActualStart,ActualWork etc.

I am unable to map these properties to database columns.
e.g MSP_PROJECTS table has only 69 columns and
MSProject.Project properties are around 274.

moreover i am not clear if properties are giving me all the required values as per table.

Query
1.If above approach of extraction is right ?
2.If yes i need mapping for same.

Note: I dont want to use OLE DB, ODBC , mdb approaches for MPP extraction of data.

Thanks & Regards Ajay Singh

Publisher PIA change of behavior for TextRange.Text between Office 2003 and 2007

Fri, 10 Jul 2009 12:21:54 Z

I have a .Net-based COM add-in that works in Publisher in which I go thru the "Stories" one-by-one and change the encoding of words (also, one-by-one) in-situ.

I iterate the Paragraphs in a Story and for each Paragraph, I use a TextRange object to isolate a single word (and it's following space) to do
the replacement. So, for example, if I had a Paragraph that contained:

// aTextRange.Text == "This is a paragraph\r";

Then I would make a working copy of that TextRange and set the Start = 0 (the beginning of the range) and the End = 5 (the offset of the 'i' in 'is') and this would result in:

// myTextRange.Text == "This "

Then I select that range (i.e. myTextRange.Select()) and then set the ".Text" property to my new encoding of that word (e.g. for Piglatin,
"myTextRange.Text = "Isthay ").

Now the problem: in Office 2003, even though my replacement text is longer, it only replaces the selected portion of the original range (resulting in the original range becoming "Isthay is a paragraph\r"), which is what I want.

But in Office 2007, it seems to ignore what portion of the TextRange is selected and replaces the length of the new string (resulting in the
original range becoming "Isthay paragraph"--I.e. clobbering the next word(s), because the replacement string is longer than the original word).

Is there some way to work around this? That is, I know that I can use the _Application.Version to detect whether I'm talking to Publisher 2003 or 2007 and treat them differently, but I'm not sure how to work with the TextRange object in 2007 to make it behave like the 2003 PIA does.

Any ideas?

Thanks,
Bob

P.S. This is only a problem with the Publisher PIAs. I do the same thing in Excel, Access, and Word (of course, with the RangeText object, instead), and it works the same in both the 2003 and 2007 versions.

L2TP/IPSec with Cisco IOS CA?

Mon, 06 Jul 2009 23:24:26 Z

I am trying to create a L2TP/IPSec tunnel using a machine certificate from the Cisco IOS Certificate Authority(CA). The end points are a Windows XP machine and a Cisco IOS Router. This tunnel works perfectly fine if I use a certificate from a Microsoft CA.

I was able to match all the parameters of the certificate and I also placed it in the 'local computer store' with the root certificate.

Unfortunately, the connection still does not work and it fails to find a valid machine certificate. On looking at the debug logs:

6-19: 13:39:59:686:2c8 Source IP Address <removed> Source IP Address Mask 255.255.255.255 Destination IP Address <removed> Destination IP Address Mask 255.255.255.255 Protocol 0 Source Port 0 Destination Port 0 IKE Local Addr <removed> IKE Peer Addr <removed>
6-19: 13:39:59:686:2c8 Certificate based Identity. Peer Subject Peer SHA Thumbprint 0000000000000000000000000000000000000000 Peer Issuing Certificate Authority Root Certificate Authority My Subject CN=cisco My SHA Thumbprint 7aaa11d0395db589328b88d7dcad51c3f286966b Peer IP Address: <removed>
6-19: 13:39:59:686:2c8 Me
6-19: 13:39:59:686:2c8 No private key associated with machine certificate
6-19: 13:39:59:686:2c8 0x80092004 0x0

On looking up the error number (0x80092004) :

0x80092004 (-2146885628) -- 2148081668 (-2146885628)
Error message text: Cannot find object or property.

This happens even though windows claims that it has the private key associated with that particular certificate.

Any ideas on how to solve this?

Thanks!

Microsoft Word 12.0 Object Library throws oDoc.SaveAs() "The message filter indicated that the application is busy."

Wed, 01 Jul 2009 13:44:10 Z

In our web application VS 2008, When I try to convert an Office 2003 file to Office 2007 file format, am getting the following exception In the oDoc.SaveAs() statement. What might be the reason! we are using Microsoft Word 12.0 Object Library and Microsoft Excel 12.0 Object Library.
The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))

Have the following code :-
public static string ConvertDocToDocx(object sourceDocFilePath, object destinationDocxFilePath)
        {
            object omissing = System.Reflection.Missing.Value;
            Word._Application oWord = GetWordApplicationInstance();
            Word._Document oDoc;
            oDoc = oWord.Documents.Open(ref sourceDocFilePath, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing);
            object frmt = Word.WdSaveFormat.wdFormatXMLDocument;//Foramt meant for Office 2003.
            oDoc.SaveAs(ref destinationDocxFilePath, ref frmt, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing, ref omissing);
            oDoc.Close(ref omissing, ref omissing, ref omissing);
            return (string)destinationDocxFilePath;
        }

private static Word.Application GetWordApplicationInstance()
        {
            Word.Application oWord = null;
            try
            {
                oWord = (Microsoft.Office.Interop.Word.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Word.Application");
            }
            catch (Exception)
            {
                oWord = null;
            }
            if (oWord == null)
            {
                oWord = new Word.Application();
                oWord.Visible = false;
            }
            return oWord;
        }

Thanks,
Manjunath.

manjunath

Accessing windows 2003 folder through unix server

Tue, 30 Jun 2009 07:38:22 Z

Hi,

While accessing the windows folder through unix server, I'm getting username or password failed error. I used to access the same yesteday but today it started giving error.

I have checked following
1. Remote Shell Service is running
2. .rhosts file contents remote host and id correctly

One strange this I found in event viewer security audit log. The user id through wich unix used to connect earlier to windows, is deleted from windows local users. So I have created local users & password same as available in unix server. I have restarted the remote shell service, but still the problem exists.

Thanks,

- JL

Creating PowerPoint files via C# and COM Interop

Wed, 24 Jun 2009 16:05:45 Z

Hi there,

this is very urgent and I really don't know, what I can do more. I want to build a PowerPoint file using ASP.NET and #C. That works fine with this COM Library, but I'm not able to fill a textbox with a specific color. The only way I found in the web is this one:

private void ppt_addPhaseName(PowerPoint.Slide slide, String name)
{
    PowerPoint.Shape shape = slide.Shapes.AddTextbox(Microsoft.Office.Core.MsoTextOrientation.msoTextOrientationVerticalFarEast, 0f, 0f, 32.0f, 65.0f);
    shape.Fill.ForeColor.RGB = System.Drawing.Color.Black.ToArgb();
    shape.TextFrame.TextRange.Text = name;
    shape.TextFrame.TextRange.Font.Color.RGB = System.Drawing.Color.White.ToArgb();
    shape.TextFrame.TextRange.Font.Size = 13;
}

Everything works fine, the font color too. But the filling of the textbox doesn't work. I always get that Exception:

System.ArgumentException: Der Wert liegt außerhalb des erwarteten Bereichs.

Which means in English something like: "The value is out of the expected range"...

Can you help me?

Thanks!

xml mapping in excel

Mon, 15 Jun 2009 13:57:40 Z

Hello

I'm trying to map XML data in Excel and I have followed the instructions listed on the following web-blog http://blogs.msdn.com/brian_jones/archive/2005/08/25/456298.aspx however it is not working for me, when i try to save or export it tells me that my map is not exportable...

this is the file that I am attempting to use as my 'map' and it must be exported in the format in order for me to use import it successfully into a database program that I am using...

<import type="financials" mode="Insert" startdate="2008-01-01" enddate="2010-01-01" importbudget="1" importexpenditures="1" importfundingsources="1" isfiscalmonth="0" searchmode="1">
<project name="TEST2" number="2">
<budgets>
<budgetcategory name="Other" type="" gl="" abbrev="">
<byear year="2009" amount="10.00">
</byear>
</budgetcategory>
</budgets>
<expenditures>
</expenditures>
<fundingsources>
<fundingsource name="FRP">
<fyear year="2009" amount="1000.00"/>
<fyear year="2010" amount="10000.00"/>
</fundingsource>
</fundingsources>
</project>
</import>

Can anyone tell me why this isn't working?

Thanks!!

Delete this thread, wrong forum

Thu, 04 Jun 2009 08:16:59 Z

// edit - removed

Wrong forum.

In fiery flight we would leave this hall...

How to create generic tool/product/mapping that will resolve the below issue?

Wed, 20 May 2009 15:27:59 Z

Hi guys,

Currently, I am working with one client they have following scenario to manipulation with data files and DB

1) Unknown data file format to DB
         1.1) Used to get different type of for data file from different client through FTP location
         1.2) Parse this file and dump the data into consolidated DB structure (known)
               -- what ever data are fit into normalized data base
         1.3) want error log and email alerts for each completed/fail transactions.

My thoughts:
       1) Provide UI interface to store the new client info and their input data file format structure
          Into different database table
      2) Load the file data based on format in above step(1) in temporary table
            2.1) SSIS packages?
            2.2) BCP and Stored procedure?
            2.3) Powershell script
            2.4) C# program
3) read this tables and dump the data into database
           2.1) SSIS packages?
           2.2) BCP and Stored procedure?
           2.3) Powershell script
           2.4) C# program

Important ## Here I am assuming my destination DB table structure is static, BUT in future it will
Change, can i have some kind of mapping that will fit with dynamic unknown file format will map with dynamic database tables

2) DB to unknown data file format
2.1) From the DB data create different structured file, based on Client requirement
2.2) put into their FTP location

My thoughts:
           1) Provide UI interface to store the new client info and their output data file format structure
               into different database table
           2) From the database data create different structured files
                  2.1) SSIS packages ?
                  2.3) Powershell script
                  2.4) C# program

Important ## Here I am assuming my source DB structure is static, BUT in future it will
                        change, can i have some kind of mapping that will fit with dynamic source database table map with dynamic structured output files

Appreciate your suggestions and help.

thanks,
Prashant

pbrathod

How to automate -- routine manual steps to load the data file in UNIX environment?

Wed, 20 May 2009 14:27:59 Z

Hi guys,

Currently I am working on one project that has following issue, I want to automate this problem

1) We used to send a flat file data into some FTP location.
2) Once we moved our flat data file to client's FTP location
3) We have to manually log-in to their system and we have to provide uploaded file name (predefine file name with current date)
    Under the import file section of their system.
        3.1) they provide us one executable for remote terminal login
        3.2) one we run this .exe it will ask user name and password, once we supply this information
        3.3) it will display the screen like mainframe screen
                  1) Production
                  2) Test
                  3) Demo
                  4) Logout

               enter your option.___

       3.4) next it will show menu like…
               1) View data
              2) Maintenance
              3) Reporting
              4) Sign off
              Enter your option____

Similarly we have to follow couple of predefine steps and finally we will provide our file name that we want to import into their database

4) Once we provide file name it will automatically import the file data into their system.

I wanted to automate step 3 and all sub steps (3.1,3.2...)
They have Unix terminal where I used to logged in. Can I write some script to automate this step?

Highly appreciate your suggestions.

thanks,
prashant

pbrathod

Accessing com ports greater than 9 in TCL on Windows XP

Mon, 18 May 2009 19:44:23 Z

I'm using a TCL script (on Windows XP) to access com ports which selects a port from a serial server. When I access try to access COM10, it doesn't work.

set serialDevice [open COMx r+]

will open the com ports through 9 but will not work for 2 digit com ports. According to the all documentation I have read,

set serialDevice [open "//./COM10" r+]

should work as an alternate method and for 2 digit com ports. This does not work for any com ports. Any help?

Register COM-classes

Fri, 15 May 2009 07:31:53 Z

Hi, I'm building com-libraries with VB-forms to extend a application. I notice a difference between classes written in VB.Net and C#.

In VB.Net there is the COM-class template. I use this, I build it, register the COM-guid in the application and it's working.

For C# I need to do a few more steps. Besides the fact there is no COM-class template and you need to write your own, after building the project and registering the GUID, the COM-class cannot be found. After putting the COM-class in the GAC and running the tool RegAsm.exe-tool the C# COM-class can be found.

Why the difference?

Thanks in advance for any responses.

Regards,

Chris

Problem in paragraph justification in Word 2007.

Sat, 11 Apr 2009 19:40:47 Z

In Word 2007, In Arabic Language whenever I apply low, medium or high justification the Kashidah i.e. the stretching line within the words appear at wrong places as shown by the red arrows in the picture below. This problem appears in all those arabic fonts containing large number of glyphs i.e Microsoft Arabic TypeSetting Font, Adobe Arabic Font etc. what would be the solution ? To observe the images of problem please take a look at this page http://www.typophile.com/node/56836

Bios Update, Ram Upgrade, General Operating & heat questions.

Thu, 09 Apr 2009 21:15:41 Z

I have a HP Pavillion DV9009nr. Specs below:

Mobile DualCore AMD Turion 64 X2 TL-52, 1600 MHz (8 x 200)
nVidia GeForce Go 6150, AMD Hammer
2 slots of ram with 1G in each.
I'm running Vista 32 Bit
BIOS Type - Phoenix (12/18/06)
Video Adapter NVIDIA GeForce GO 6150 (64 MB)
Bios version F.25
Mobo Props - Quanta 30B9 65.26
Processor
Now running at 67 Degrees, was over 90 degrees last night (celsius)
Run second monitor, and run some heavier programs (ACT, QuickBooks, Outlook, etc.) all at the same time.

My Questions:

Been researching how to upgrade the ramt o 4G, and everyone at HP is telling me you can't do it. But does not seem legitimate. I found some people that have said through forums that when I upgrade the Bios, I should be able to at least get 3G of Ram.

Here is a link to a forum I found on exactly this. This guy's computer is almost identical to mine. Only difference is out Bios. His is F.3D. Mine is F.25, and the current version is F.42. However, if you go to the HP website, it tells many users not to run the F.3D Bios. (but my PN does not match the one they talk about)

http://forum.notebookreview.com/showthread.php?t=347808

I have orderd the exact RAM he has and got it pretty cheap. (4G (2x2) for $30)

Questions.

1) Should I update the BIOS?

If I should, how to do easily back up my BIOS in case something goes wrong, and if something does go wrong, what are my next steps.
I would also have to do much research into how to update the BIOS. I've never done it before and am a touch nervous to do it.

2) If I do update my BIOS, what version? Should I update to the F.3D or the F.42?

3) My bandwith is running very low. Any typical programs I should shut down to increase it?

4) My computer is running hot...very hot. Will the BIOS upgrade help this?

5) Very random question... I have my secondary monitor running into the docking port of the computer/ Because of that the secondary monitor output is free. Shouldn't I be able to put another monitor into that slot, and be able to use a third???

Any help anyone can provide would be great.

Extracting historical data from LiveStats.XSP 7

Tue, 07 Apr 2009 07:21:00 Z

Hi there.

I've inherited a LiveStats.XSP installation from a predecessor, which houses web stats for over 400 web-sites. I would like to extract his data from livestats and convert it into a format which can be processed by our in-house stats package... So far I've had very little luck in deciphering the database schema, or the data files stored in the livestats installation directory - I've wasted well over a day trying to make sense of it all.

The data points I'm primarily interested in are daily bandwidth usage, and the daily number of hits per site. Can anyone shed any light onto the process I might undergo in order to perform this conversion? I'm not to keen on the prospect of having to manually login to livestats for every site, and download a couple XML/CSV files for each - that, IMO, is just to tedious a task for anyone to have to perform... unless they were being punished for something :P

Any ideas, or ready made scripts out there that can save the day for me?

Thanks in advance!

how to restrict the returned fields in Winrm

Tue, 31 Mar 2009 17:46:45 Z

When I do query to Windows table, say:SELECT Availability FROM Win32_Processor, I am expecting only return the Availability field; However, Winrm returns me the whole node of Win32_Processor. So it seems I had sent : select * from Win32_Processor.

frankm

My first PShell Script is broken!

Thu, 26 Mar 2009 01:33:39 Z

I am wanting to control the color output to the line numbers in PShell Console, for ease of reading long lines of data: this is my first attempt @ Script writing any help would greatly be used to continue with this long awaitted Shell for Windows. thanks an old, new Shellplayer.

$0 = linenumber {if ($0 = 0,2,4,6,..,foreach $0 % 100) {"$0 is Even"}}
$1 = linenumber {if ($1 = 1,3,5,7,..,foreach $1 % 99) {"$1 is Odd" }}
While (linenumber Even is "magna" Color)
While (linenumber Odd is "yellow" Color)
WriteHost = ConsoleOutPut = $0 + $1

running winVista Basic.