Forum Topics Tagged [automation]

hi everyone. been a while since i have been on here, alot has changed. I am in the middle of amending/adding features to an installer using python. I have the dropbox API (for business) set up and working, upload and downloading without issue. The potential issue i see is during the progress of either up/down the CLI sits, does nothing. So my question is (as i am still finding my way with all that is Python), how can i add a progress bar? For download and can use the API call to get the metadata file_size if that helps? PS, …

HI, I am using zend guard for encryption of my php code. I would like to ask that is there a way to automate the process through command prompt or gui that we can zip the files of the source code and encrypted code in seperate folders automatically. Thanks in advance

Hi, Im trying to include the feature of automatically generating a word document through C# using a pre-defined template. Im able to insert 'mailmerge' fields in the word template documents at specific locations, and accessing these through the code in C#. I can update the values of these fields, no problem. I am now trying to insert a table at a specific location. I would like to dynamically set the number of rows and columns, back color, fore color of the cell, font size etc. and even formulas with cell referencing (like you have in excel). Is it possible to …

Dajia hao, daniwebians! Just a quick question, is it possible to focus on a textbox on an externally loaded website? My goal is to load an external website, focus on a textfield, auto fill it with the current date, then submit it to then run my newly created scraper tool on the resulting page. Any ideas? I've done a bit of research and will continue to do so...

I'm trying to run a cron job on my web server. I used the cron module at the cPanel to add the file and used this command.. `sh ./public_html/crark/run.sh` The problem was that it takes the root folder context for all the followed processes i.e. I call run.sh from cron job which has the following code ./public_html/test/test.exe -h -s > ./public_html/test/output.txt The code apparently doesn't work as **./test** calls a few files within that folder. I originally used ./test -h -s > output.txt as the code inside run.sh because I wanted it to work in that directory context. It would …

Shel scrip to create automatic ROLLBACK statements for DDL's and put it into a separate file DDL's FILE Content ------------------ name:xyz ------------------------ --table 1 DROP table <tablename>; create table <tablename>;

Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that populates data but this happens at the begining. My problem is this the excel sheet produces over 400 excel seperate books (yes you read that correctly the client wants the data in excel) when the books are saved the excel workbooks sizes are 17 meg however if you go into …

i am using html agility pack to retrieve the articles from website with "p" tag, but it return all the user comments along with it. how to overcome one this. i have only one string holding all the stuff at last.

hi, i am using regular expression in extract paragraph from html code but it gives me only one (the first one) line written in first <p> i want the whole article in my string. here is my code. Match m = Regex.Match(htmlstring, @"<p>\s*(.+?)\s*</p>"); htmlstring=m.Groups[1].Value; where "htmlstring" all the html code in text form in it.

GUIdancer 3.2, the latest version of flagship automated GUI testing tool from Bredex, now "officially" supports Windows 7 and Vista, and includes additional enhancements to its library of pre-built test actions. It began shipping on Nov. 3. Before you decide that US$5785 is too much to pay for an automated keyword testing tool (more if you're subject to Germany's voracious appropriation tax), take a look at [these demos of the software](http://www.bredex.de/en/guidancer/downloads.html) in action. You can also [try the software](https://cgi.bredex.de/GUIdancerShop/downloadpage.do) for two weeks for free. There are versions for Linux and Windows; a Mac OX S version is in beta. According …

I have searched and nothing that I have found hits directly on what I am looking for (or maybe my searches have not hit on the combo of words). In C# I have created an Excel sheet, using Interop.Excel, in which I insert some data and create a chart. This all works fine when I do a xlWorkBook.SaveAs. What I want to do is prompt the user to put the automated workbook somewhere with thier own file name. I have tried (<http://p2p.wrox.com/vb-how/63900-disabling-second-excel-save-prompt.html>) where he basically does a new SaveFileDialog then if its == OK he builds his Excel sheet then …

Hi, I want to know if is possible to make those events/automation with a Python code( without any program like Pywinauto ), so I could compile the python code: 1. [B]sending keys to an active window;[/B] 2. [B]sending mouse clicks to specific coordinates in a window;[/B] 3. [B]set the window to be everytime active or on top;[/B] 4. [B]waiting/sleeping ( for lowering CPU consumption ) until a specific window exists;[/B] If this could be accomplished with Python ,can anymoe show me how to do this,or a tutorial, please? Thankyou !:)

Hi, I want to know what Windows language can make ALMOST all sorts of automations like : [I]- sending keys, to a focused window ; - sending mouse clicks to specific coordinates in a window ; - finding if a window exists, by name ; - set it to be everytime active ; - or waits until exists or until is closing ;[/I] I know AutoIt is one of the best for this, but I don't use it anymore( personal issues ). I want to do those events from the code, not with the help of a program, like Pywinauto. …

I'm trying to automate browser at google website, [URL="http://www.google.com/finance/option_chain?q=nflx"]http://www.google.com/finance/option_chain?q=nflx[/URL]. There are several expiration dates in the drop down list. If you choose one, the option table below is updated accordingly. The website script is listed below. [CODE]<div id="expirations" class="id-expirations float sfe-break-left"> <select> <option value="0">Jan 21, 2012</option> <option value="1">Jan 27, 2012</option> <option value="2">Feb 18, 2012</option> <option value="3">Mar 17, 2012</option> <option value="4">Jun 16, 2012</option> <option value="5">Jan 19, 2013</option> <option value="6">Jan 18, 2014</option> </select> </div>[/CODE] Here is my VB 2008.net code. It can find the drop down list, but even I used SetAttribute, the website is not updating. For example the code choose …

I am using the following to send a string to the application on the foreground. But it's no good, as it for some reason only accepts numbers, and letters in uppercase. But I also need to send letters in lowercase, and slashes and backslashes etc. Can anyone help me achieve this? I also tried simply copying the string to the clipboard with the intention of finding out how to emulate Ctrl+V keypresses but it wouldn't copy the text to the clipboard in backgroundworker, which I use in my app. Said something about STAThread being required. So now it's back to …

Hi All, I'm Trying to solve this puzzle for my script: Let's say we have 3 lists, A,B and C with the following elements 'A' = [5,3,1] 'B' = [6,5,2] 'C' = [2,0,-2] I want to go through all 27 combination sequentially, looking for a combination that is 'valid' AND has the highest sum. Let's say that A=3 B=2 and C = 2 is valid. Testing all 27 and computing the score (sum) will work, but is computationally too expensive for larger problems. I mean to say that the program should test the highest combination first: A=5 , B=6, C= …

I have a project where I need to retrieve data from MS SQL Server and format it into an Excel Spreadsheet. I am using the OfficePartner component to try and make this easier, but I'm having a hard time figuring out how to get the VB help and Excel Object Model and Excel Macro code all to help me to figure out how to write my Delphi code. This is my current code: [CODE] Rng := OpExcel.Workbooks[0].Worksheets[0].Ranges.Add; Wkst := OpExcel.Workbooks[0].Worksheets[0]; Rng.Name := 'UpdateRange'; Rng.Address := 'A1'; Rng.OfficeModel := DataModule1.mdlUpdates; DataModule1.mdlUpdates.Dataset := DataModule1.spGetLabelUpdates; OpExcel.RangeByName['UpdateRange'].Populate; Wkst.Activate; Rng.Address := 'A1:M59'; Rng.Select; Rng.AutoFitColumns; Wkst.Name …

I have a excel spreadsheet that contains the following information: part name, part number, calibration, rev. level and other information. I also have a form that I have to fill out every month using the information from the above mentioned spreadsheet. Is there a way to input the spreadsheet information to the form? I have to hand write this form every month and I'm looking for a way to keep from doing it. I need to be able to print for each month of the year. (I'm currently using excel 2003.) Any help with this would be much appreciated.

Hi all, I have basic knowledge on perl concepts ... Now i am assigned with a task to automate software build installation process on windows please guide me in the following 1.what are the documents to refer for example scripts on automation 2.Should i have to install any thing else than active perl. i know ,to automate, Perl code should be interactive, i have no clue to make it interactive...!!:( please guid me on this.

Hi friends... I'm doing Inventory Project... I'm Having purchase and sales tables... In purchase table fields are Code, Category, Brand,S.p, Date etc., Men, Women, Kids, Accessories are the VALUES STORED IN Category Fields... In PURCHASE FORM, When i select MEN in Combobox, it has to AUTOMATICALLY allocate(SHOW) CODE(it is also COMBOBOX) numbers from 1-200, women form 201-400, kids from 401-600, Accessories from 601-1600. No other numbers to be allocated to SPECIFIED VALUE... i.e for MEN NUMBERS LIKE 225, 555 888 SHOULD not to be allocated... I.e In Purchase table, i have to Generate Numbers Automatically... Please help me... Thanks in …

helo! can anyone help me in automatically saving files with fixed filename in python? the OUTPUT would be like this: FILE- A01.txt FILE- A02.txt FILE- B01.txt File- B02.txt i was hoping that i could save a file automatically after making some changes in the older version. Thank you, Gene

Hey there everyone, I'm working in windows, writing a python program which runs various programs through command line and pipes the outputs of one into the next program. All the programs accept all instructions in one line then run. I've been using the os.system command to run these. One program though does not work in this manner - it prompts the user for the input file name/location then once it receives this, prompts with the name and desired location of output, etc., until it receives all the information necessary to run. Just providing all the necessary information separated by newlines …

I have been having nothing but trouble trying to get C# to read excel. I haven't even gotten to the writing part, but I imagine it's going to be a challenge, too. FYI, I'm pretty new at this, and don't have a ton of experience, so I'm sure I'm missing something that's obvious to someone who's been around a bit. Basically, what I'm trying to do is write a simple program that will read information from 2 different workbooks, reading each of 4 columns from one book into a different list<string>, and reading the 2 columns from the other book …

Hi, I'm having a little problem with IE7. I'm entering data for my work on a netbook but I get an error message saying that "Class doesn't support automation". I've tried reinstalling IE7 but that doesn't fix the problem. It works on other computers, but not the netbook I'm using. Any advice greatly appreciated. Tell me if you need more info.

Hi, I urgently need the following information and techniques on how to: 1. disable input in a field text box and automatically increment the same namely a numeric primary key field (viz. StudentID) by 1 at the issuing of a blank/new record. The Database method is DATA BINDING and ACCESS. 2. add an input text box (a query) asking for a Student name or Student Code and the program to automatically look and highlight the name in a data grid (Database Method: Data Binding). 3. bind code and data binding techniques in a program The program I am doing is …

Please help! I have the following code in the head section of my web page: <script> ..... var serverLoc = "http://www.mydomain.com/mypath/"; var serverFile = serverLoc+"myexcel.xls"; var ehandle = new ActiveXObject("Excel.Application"); //error occurs var eWBhandle = ehandle.Workbooks.Open(serverFile); var eShandle = eWBhandle.ActiveSheet; var cell1 = eShandle.Cells(1,1).Value; // get more data ..... </script> It works fine when I'm launching the page on my local machine referencing an xls on my hard drive (serverLoc). But when I upload the page to a server along with the xls file (changing the path of the file, of course), I get the above error. Note, I am …

Hello, I'm trying to deploy an application. On my development machine, I have Office 2007, and using it to automate excel from c#. On the target machine, there's Office 2003, and I getting an error message when trying to installm that I should isntall Microsoft.Vbe.Interop version 12.0.0.0. I removed all references (including the one in question), but still getting the message. How can I resolve this issue? Thanks in advance!

Even Microsoft is sometimes faced with the decision of whether to "buy or build." This time it chose to buy. With the acquisition of Opalis Software announced yesterday, Redmond in one stroke takes a major leap in data center process automation. And it couldn't have come at a better time. Major announcements by [Dell](http://www.networkcomputing.com/data-center/new-dell-hardware-and-software-aid-data-center-automation.php?type=article) and [EMC](http://www.networkcomputing.com/storage-networking-management/emc-fast-brings-storage-tiering-to-fibre-channel-sata-and-flash.php) last week put Microsoft behind by at least six months when it comes to IT automation; according to reports, it will be mid-2010 before we see a Microsoft-branded solution. Opalis's flagship is Integration Server, which automates data center processes--such as those for provisioning a …

Has your IT budget just taken a big hit for 2009? Many have. These desperate times call for desperate measures but don't worry these measures aren't nearly so desperate and they just might help you fix that ailing IT budget. All you need is a little creative thinking and some good people behind you--and these 5 things (in order of importance). [B]1. Linux[/B] - No surprise here since this is a Linux-oriented blog. Linux makes sense for those tightening those budgetary belts since it's free, robust, and stable. You can't go wrong choosing Linux for your IT infrastructure. It handles …

If you’re looking for low-cost GUI-test automation for Java, Qt, Mac OS X and Web applications, here’s a product you might find useful. Have you heard of Squish? It’s an automated function-testing tool from [URL=http://www.froglogic.com/pg?id=Home]Froglogic[/URL]. Released today was Squish 3.4, adding support for the May release of Trolltech’s [URL=http://trolltech.com/company/press-center/Qt4PressRoom]Qt 4.4 GUI framework[/URL], the June release of Eclipse 3.4 Ganymede, and for testing applications using varying GUI technologies from within a single test case. Also new in 3.4 is integration with [URL=http://ant.apache.org/]Apache’s Ant[/URL] build system and the [URL=http://cruisecontrol.sourceforge.net/]CruiseControl[/URL] framework for continuous build and integration process. Qt 4.4 now supports Qt, Java …