I am a newbie with addin programming and need help with the following scenario. I have an C# excel automation addin that calls a few UDFs. I want to do a user name and password check during when the automation addin loads for which a screen where the user can enter his details must pop up on load of the add in. How can it be done using ...
Question Summary: Is there a better method than the one posted below to implement the database-creation stage of an automated deployment? Background/Requirements: I am in the process of attempting to develop a coherent database version control process using an approach similar to this one. This question is specifically about the bas...
Earlier I asked a question about command-line parameters to automate processing of a file in InfoPath. I'll probably get the Tumbleweed badge for that one. Instead of attempting a batch solution through the command line, can someone suggest a good resource for developing a solution that will open an application and then perform actions...
I want to access forms on HTMl pages throught Java Programming Language without involving real browser in between. At present I am doing it through HTML UNIT but it takes a bit more time to load a page. When it comes to accessing millions of page, then this extra bit time matters most. Is there any other methods for doing this? ...
I'm trying to implement a right click context menu using UI automation. Since UI automation does not have a native right click pattern I am adding an ExpandCollapse provider to the listview's AutomationPeer class and mapping the expand and collapse to opening and closing the context menu. My question, is there a better method of invoki...
Basically I would like to keep the existing format of an Excel cell. If I use ActiveCell.Value2 = "new value"; The ActiveCell displays "new value" but loses the user defined formatting ( say red font, blue background), all formatting values goes back to Excel default format values. Note: If you replace a cell value using Excel, Excel k...
Hello Everybody, The code in the sequence is working fine, but looking to improve the MySQL code to a more efficient format. The first case is about a function that received a parameter and returns the customerID from MySQL db: def clean_table(self,customerName): getCustomerIDMySQL="""SELECT customerID FROM customer WHERE ...
I have an automation object with event support that leaks memory. The FConnectionPoints which comes with the generated source is never freed. When I manually add FConnectionPoints.Free in the destructor, the leak goes away. Is this a bug in the Delphi code template, am I doing someting wrong, or is it intended to free FConnectionPoints ...
Hi Everybody, I have a function with a new improved version of the code for automatic table indexing: def update_tableIndex(self,tableName): getIndexMySQLQuery = """SELECT numberID FROM %s;""" % (tableName,) updateIndexMySQLQuery = """UPDATE %s SET numberID=%s WHERE numberID=%s;""" % (tableName,) updateIndex=1 ...
I want to login in different machine in the network and copy a file from that machine to my machine.I want to do this using python.Any idea how can i do this .I have python 2.5 a nd ubuntu 8.10 ...
Other ideas are also welcome. I am trying to take an excel file, using python to generate an xml for a javascript html webpage that will essentially display a gallery (or some sort of directory structure). The excel file would be pretty massive, but let us assume time isn't so crucial. So far I can convert the tab delimited version of ...
Can anyone show me c# code that successfully logs into a Linux server by inputting username and password? ...
Say I have a table like ID, NAME, SCORE. Now normally, to get the rankings of the teams, I'd select all and order by. Sometimes though, I don't want to know all the rankings, just the ranking of one team. If I added a column RANK, is there any way for MySQL to automatically fill in those values for me based off of SCORE? (I believe MS Ex...
I have a table called "teams" with column "inactive" and another table "events" with column "time". How can I have the "inactive" column updated (to true), if the latest date in "events" for any team occurred X amount of time ago? I know this can be doe with a php script, but i'm looking for a sql solution ...
Hey everyone, I was wondering if there was a scripting language that one could use to to interact with a flash object on a webpage? I am trying to automate some tasks but the webpage uses flash. Thanks for the help! Edit: I am trying to fill out a form basically click a few "check boxes" and then a submit button but I would like to ...
I've been trying very hard to automatically ssh into a Linux server. What's crazy, is that I can create a .bat script, that will do it, but I have to be there physically, to type in the password. I've tried automating this using System.Diagnostics.Process object in c# to no end. There is no way, I've found, to make this object allow you...
I am checking Squeak homework assignments submitted by my students. I have written an SUnit test case with a bunch of tests and now I want to run these on all submissions. I would like to somehow automate - whether from inside Squeak or with shell scripts - the process of loading a student submission, running the test case on it, and sa...
Is there a headless browser for .NET? I am looking for this in a testing context. Coming from Java I am thinking of something similar to HtmlUnit (http://htmlunit.sourceforge.net/) which itself is the base for different higher level tools like Canoo WebTest or Celerity. I would like to create automated UI tests for web applications in...
I am trying to generate a powerpoint presentation in C#. Everything works well on my machine but when I deploy it on Server I receive HRESULT exception on the creation of chart. Tables and other shapes work on both sides but I dont whats wrong with the chart when I generate it on Server. Can someone help here? ...
I have this old Fortran executable that can only be accessed through its GUI, and is too complicated to rewrite. I need to integrate it into a tool we are building, so I wrote a GUI wrapper in C# using the White library (certainly not ideal, but I couldn't think of a better approach). This works ok, but when my program runs, the GUI po...