automationexpert12345

I have an application (split into both a client and server module) that uses UDP to provide notification of an incoming data manipulation request to the server. Once this manipulation has completed, I would like the server to send back a .CSV file to the client and store that in a directory of the client's choosing. (Ideally, using TCP). How would this work, especially considering the ports have been forwarded at the router level to access the server from the client, but not vice-versa. In my mind, here are the ways I can accomplish this: 1. Send the small .CSV file (but won't always be small) via _SMTPEmail() *** Would work but isn't the most practical way -- I would like to complete the circuit within the application, and not involve e-mail. 2. Transfer the file to an FTP site *** Would work, but again, not the most practical way and involves another step. 3. Upload to an apache server *** Would work, but again, not the most practical way and involves another step. So, is there anyone out there with experience in both receiving data at the server, and then sending a file back to the client? After looking through dozens of posts on the forums here, I've only come across articles where the client is sending to the server, and not vice-versa. Thanks very much for your time and assistance. - Jon

I have an application (split into both a client and server module) that uses UDP to provide notification of an incoming data manipulation request to the server. Once this manipulation has completed, I would like the server to send back a .CSV file to the client and store that in a directory of the client's choosing. (Ideally, using TCP). How would this work, especially considering the ports have been forwarded at the router level to access the server from the client, but not vice-versa. In my mind, here are the ways I can accomplish this: 1. Send the small .CSV file (but won't always be small) via _SMTPEmail() *** Would work but isn't the most practical way -- I would like to complete the circuit within the application, and not involve e-mail. 2. Transfer the file to an FTP site *** Would work, but again, not the most practical way and involves another step. 3. Upload to an apache server *** Would work, but again, not the most practical way and involves another step. So, is there anyone out there with experience in both receiving data at the server, and then sending a file back to the client? After looking through dozens of posts on the forums here, I've only come across articles where the client is sending to the server, and not vice-versa. Thanks very much for your time and assistance. - Jon

Hi all, I was wondering if anyone could offer any suggestions on how I might be able to accomplish the following: I regularly work with large datasets in .csv form, and typically need to perform significant ETL (extract/transform/load) to the data in the file(s). For example, if I have a date field in the CSV, I would want to use a combination of that field and the field name of the other 3-4 fields to create unique variables. Example variables desired: 0501catA: (value: data from the catA field that corresponds to the 05/01 date) 0601catA: ... 0701catA: ... 0801catA: ... 0501catB: ... 0601catB: ... 0701catB: ... 0801catB: ... ... I am very comfortable with AutoIt scripting - I'm just looking for logic suggestions (and perhaps code if you've done something like this) to automate this for hundreds (perhaps even thousand+ variables) Limitations: I expect to generate hundreds of columns for the data and save that output to a much larger new .csv file. Please don't question why we do this, but know that the new .csv serves as a large input to a more complicated application that requires this type of input. The output must be copied directly to a new .csv and not to Excel / Access because of max column restraints. Thanks so much for your time and assistance!

Very good suggestions - thank you for your time and assistance Dale, I greatly appreciate it.

Just bumping this along as I still have not come up with a workaround (or an answer). Thanks.

Looking at the encoding tab of IE when looking at my page (Korean output), the encoding is set at Korean (EUC), and Unicode is NOT checked. Similarly, one of my other pages (Chinese output), has the following encoding: Chinese Simplified (GB2312). I have enabled language support for both Korean and Chinese in my Windows region settings, and have no problem copy/pasting and reading these characters in other applications (notepad, etc.) Please note that when copying these characters into Scite, they appear as question marks, much like the output generated when running a compiled AutoIt app. The msgbox displays question marks, apparently unable to display the text. Hmmmm...

Thank you for the reply Dale - I too found that topic, and sadly, it did not work. I guess it's convenient that you responded to my post, as my difficulty surrounds the contents of a _IETableWriteToArray. Where would I use the conversion functions? When reading in the sourceHTML? Before writing the array? I'm not sure what to do. Thanks so much!

Hi all , I have a script set up that is working fantastically with my english-language data in tables. However, my script does not hold (or perhaps does not output) correctly the data when it is in Asian-language characters. A msgbox debug outputs question marks instead of the corresponding language when testing. Here is some sample code: $oTable = _IETableGetCollection ($oIE, 1) $ClassTable = _IETableWriteToArray ($oTable) The remainder of the code (functional) is likely unnecessary since it is working with English. Any thoughts/suggestions from those who have run into this problem? Thank you!

5 minutes later, I thought to myself, why not just assign the action... $oIE.document.Name.action = "filename.asp" $o_form = _IEFormGetObjByName($oIE, "Name") _IEFormSubmit($o_form,0) Silly me - writing it out helped diagnose and solve the problem. Thanks for reading! =)

Maybe someone can offer some guidance: I am trying to navigate to a given page from a certain website. The link to this page is presented using a span tag and CSS to modify the text. Using the _IELinkClickByText function does not work as there is no link attached to the text - it is of course a more complicated onclick to a .js function. This js function checks the span tag's ID variable for a given string, and matches it accordingly with a select case in the .js. If the text matches, the document.formname.action is = to the proper URL for the desired page. Any idea how I can duplicate this functionality using one or a combination of the powerful _IE functions? Thanks!

Nice work around - thanks! Quick question though - what does the -1 reference (where the controlID would be used)? Any idea if this is something that can be added to the "fixable" items for the next beta release? =)

Hi everyone, I've had tremendous success using AutoIt and have recently stumbled on to a bit of an inconvenience and wanted to see if anyone was having similar trouble. I've browsed the forums and notices some problems with the painting of certain controls whenever they have been placed over a tabitem, but I haven't seen any talk of listboxes. Run the code below to see the discoloration (dark grey) of the listbox over the tabitem. I added a second listbox created the same way outside of a tabitem to demonstrate the glitch. Any thoughts? FYI: I am using v3.1.1.128 (beta) with the following code snippet : #include <GuiConstants.au3> ; GENERATE GUI INTERFACE $MainGUI = GuiCreate("Tools", 600, 700) $Tab1 = GUICtrlCreateTab(5,5,590,390) GUICtrlCreateTabItem ( "Tab1" ) $ListWindow_painting_problem = GUICtrlCreateList("",18,35,555,90) $Tab1 = GUICtrlCreateTabitem ("") $ListWindow2_fine = GUICtrlCreateList("",18,435,555,90) $Tab2 = GUICtrlCreateTabItem ( "Tab2" ) GUISetState(@SW_SHOW) While 1 $msg = GUIGetMsg() Select Case $msg = $GUI_EVENT_CLOSE ExitLoop EndSelect WEnd Exit