»Xog Posted December 14, 2009 Author Report Posted December 14, 2009 you see the thing is, this isn't something I can run on my computer.. it's got to be done with administrative priveledges (to edit an item type), which means the firmwide manager is going to have to do it.. and he works in the Boston office, I'm in New York.. this is no small-time company by any means and I definitely wouldn't want to propose an idea I know nothing about only to be laughed at by him.. So help me form some questions about this that I could ask him.. 1) Are you experienced in PROGRAM_LANGUAGES_HERE? (languages related to the script he'd be writing)2) Are you familiar with AutoHotKey?3) Can you run a script that would edit the item types from Folders to Wallets for all files with something say like.. Item Type=Folders, Classification=UNCLASSIFIED, Barcode=0000*? what else could I ask.. or what should I change to make it sound more influential and not retarded Quote
»Blocks Posted December 14, 2009 Report Posted December 14, 2009 This is hard to do without knowledge of your system, which is why I think you'll have to do it yourself. You seem willing enough to learn, so just go for it. That said, how are you changing the item type right now if you don't have those administrative privileges? If the script is not done in AutoHotkey, it should probably be done in Python, as chances are half of it is already written. Quote
»Xog Posted December 14, 2009 Author Report Posted December 14, 2009 This is hard to do without knowledge of your system, which is why I think you'll have to do it yourself. You seem willing enough to learn, so just go for it. That said, how are you changing the item type right now if you don't have those administrative privileges? If the script is not done in AutoHotkey, it should probably be done in Python, as chances are half of it is already written.Since I don't have the proper rights to change the Item Type of a particular entry, we have to open up the file that was dumped into Accutrac from FileSurf, click Add Paste (it's like pressing Copy+Paste for a file on ur computer), which creates a new file with all of the properties.. but now that I'm creating a new file, I now have the priviledge of making the Item Type to something I choose. Once I change that, I give it the proper classification (Prosupplements, Correspondence, Closing Documents/Books/CDs, literally hundreds on the list) and click OK.. now that a copy of that file was made with the proper Item Type and Classification (which now has its own barcode number), I delete the old file. It's a very time consuming and ridiculous procedure because it's hard to integrate non-native files into our database because they have different structures from the other software (FileSurf). Quote
»Blocks Posted December 14, 2009 Report Posted December 14, 2009 Since I don't have the proper rights to change the Item Type of a particular entry, we have to open up the file that was dumped into Accutrac from FileSurf, click Add Paste (it's like pressing Copy+Paste for a file on ur computer), which creates a new file with all of the properties.. but now that I'm creating a new file, I now have the priviledge of making the Item Type to something I choose. Once I change that, I give it the proper classification (Prosupplements, Correspondence, Closing Documents/Books/CDs, literally hundreds on the list) and click OK.. now that a copy of that file was made with the proper Item Type and Classification (which now has its own barcode number), I delete the old file. It's a very time consuming and ridiculous procedure because it's hard to integrate non-native files into our database because they have different structures from the other software (FileSurf).Okay. Now take everything you said and turn it into an AutoHotkey script (serious). Figure out what sequence of keystrokes it takes to do each thing, and then script it up. You can even do mouse movements and clicks with AHK, though this should be avoided for maximum reliability. Quote
»Xog Posted December 14, 2009 Author Report Posted December 14, 2009 (edited) http://img42.imageshack.us/img42/8787/accutrac.jpg Edit: Might I add.. after each file is created, I then have to print out labels (one for the front and one for the side tab) and slap them on to new "wallets" (aka redwelds) Edited December 14, 2009 by Xog Quote
»Xog Posted December 14, 2009 Author Report Posted December 14, 2009 Since I don't have the proper rights to change the Item Type of a particular entry, we have to open up the file that was dumped into Accutrac from FileSurf, click Add Paste (it's like pressing Copy+Paste for a file on ur computer), which creates a new file with all of the properties.. but now that I'm creating a new file, I now have the priviledge of making the Item Type to something I choose. Once I change that, I give it the proper classification (Prosupplements, Correspondence, Closing Documents/Books/CDs, literally hundreds on the list) and click OK.. now that a copy of that file was made with the proper Item Type and Classification (which now has its own barcode number), I delete the old file. It's a very time consuming and ridiculous procedure because it's hard to integrate non-native files into our database because they have different structures from the other software (FileSurf).Okay. Now take everything you said and turn it into an AutoHotkey script (serious). Figure out what sequence of keystrokes it takes to do each thing, and then script it up. You can even do mouse movements and clicks with AHK, though this should be avoided for maximum reliability. I'd love to -- but it's not quite that easy. Each item has to be given a reference number, which I don't think AHK can't really do unless it can count how many "Wallets" are made with a certain classification?.. Here's what I meanSay you have 5 wallets.2 are Prosupplements1 is Correspondence1 is a Closing Book1 is Closing Documents The reference system would go like this:Prosupplement of XX blahblahx-Reference: 00001--Inside of XX blahblahx are 3 folders, with names. Each folder is assigned a reference number going from 00001 to 00003. I have to type the description of each folder manually because the previous department here didn't do this procedure with FileSurf Prosupplement of XX blahblahy-Reference: 00002--Inside of XX blahblahx are 10 folders, with names. Each folder is assigned a reference number going from 00001 to 00010. I have to type the description of each folder manually because the previous department here didn't do this procedure with FileSurf Correspondence and subfolders A-Z dated 1/14/08-6/22/08-Reference: 00001--Inside of Correspondence and subfolders A-Z dated 1/14/08-6/22/08 are 7 folders, with names. Each folder is assigned a reference number going from 00001 to 00007. I have to type the description of each folder manually because the previous department here didn't do this procedure with FileSurf Closing Book for Case Blah-Reference: 00001--Inside of Closing Book for Case Blah are 5 folders, with names. Each folder is assigned a reference number going from 00001 to 00005. I have to type the description of each folder manually because the previous department here didn't do this procedure with FileSurf Closing Documents for Case Blah-Reference: 00001--Inside of Closing Documents for Case Blah are 7 folders, with names. Each folder is assigned a reference number going from 00001 to 00007. I have to type the description of each folder manually because the previous department here didn't do this procedure with FileSurf Would there be a way to have AHK count how many Item Type = Wallets with a certain Classification, find the highest "Ref" number, then +1 to that value?? Quote
»Blocks Posted December 14, 2009 Report Posted December 14, 2009 (edited) Would there be a way to have AHK count how many Item Type = Wallets with a certain Classification, find the highest "Ref" number, then +1 to that value??Yes. Once you get the necessary data into AHK, that part is easy. Getting the data might be as simple as a series of tabs and copy-paste operations, I don't know. There's probably a more elegant way. Exporting to files and reimporting a changed version would be desirable. You can do it, just sit down with the AHK manual for a bit. Edited December 14, 2009 by Blocks Quote
Testtube Posted December 15, 2009 Report Posted December 15, 2009 (edited) If you had a txt file with all of the non converted barcodes like barcode.txt with the following info in itf109030f109014f109012f109042f111974f111881f103142f123059f113410f113411f109025f109015f113408f109024f111966f113409f109183f111208 You could put this in a script cat barcode | sed "s/f/0000/" | sort -n >> results And your output would be in the results file 000010903000001090140000109012000010904200001119740000111881000010314200001230590000113410000011341100001090250000109015000011340800001090240000111966000011340900001091830000111208 or make a file named barcode.sh and put this in it. #!/bin/bash echo Please, enter your barcode to be coverted read barcode clear echo Converted bar code $barcode | sed "s/f/0000/" Does this help? Edited December 15, 2009 by Testtube Quote
»Xog Posted December 15, 2009 Author Report Posted December 15, 2009 (edited) If you had a txt file with all of the non converted barcodes like barcode.txt with the following info in itf109030f109014f109012f109042f111974f111881f103142f123059f113410f113411f109025f109015f113408f109024f111966f113409f109183f111208 You could put this in a script cat barcode | sed "s/f/0000/" | sort -n >> results And your output would be in the results file 000010903000001090140000109012000010904200001119740000111881000010314200001230590000113410000011341100001090250000109015000011340800001090240000111966000011340900001091830000111208 lol, well I got a fix that's very useful and it performs in realtime as I'm scanning into the search field.. anywho.. I'm kinda jumbled up on such a simple command for AHK.. I can't seem to get shift+tab to work. I've tried so many different things, NOTHING works! Send Shift+TabSend +TabSend {Shift}{Tab}Send {Shift+Tab}Send {Shift}+{Tab}Send {+Tab} wtf ! edit: nevermind.. for some reason.. NOOWW Send {Shift}+{Tab} works. Shouldn't +Tab be a shift+tab on keyboard?edit2: moar issuez.. So I get the program to press shift+Tab in a loop the right amount of times to get to the button I want it to press.. Just in case my computer lags, I have it sleep for half a second and then press entersleep 500Send,En I see the highlighted button I want, it tabbed to the right one.. then Enter is pressed .. and apparently it's functioning as if the button BEFORE that one was pressed.. but the other one was highlighted. Edited December 15, 2009 by Xog Quote
»Xog Posted December 15, 2009 Author Report Posted December 15, 2009 (edited) It's a very simple script and it would be put to good use if it worked. >:\ ;CTRL+W initiates the script to start ^w:: { ;(!e = ALT+E on keyboard) Brings up the edit option for the highlighted item Send !e ;Pauses for 1 second sleep 1000 ;Loops the following line 12 times Loop 12 { ;Presses Shift+Tab once, but is looped 12 times by previous command Send {Shift}+{Tab} } ;Pauses for half a second sleep 500 ;Presses Enter on the keyboard Send {Enter} } fixed it.. had to change from Send,En to Send {Enter}:\ Would anyone know how I would make it so that it can initiate the macro based on me scanning a barcode? Like for instance.. I don't think this'll work because I've never seen it but.. 0,1,2,3,4,5,6,7,8,9+{Enter}::Sleep 15000 I don't know how I would be able to make it shorter without saying {0}+{Enter}::{1}+{Enter}::etc but that doesns't even work.. just tried it how would I be able to do this? The scanner presses each key seperately, so it's not a combination of keys, it's 0, then enter or 1, then enter, etc. edit: project complete.FILE 1: SCAN.ahk #InstallKeybdHook ;Run the macro on either an "f" or "t" from the barcode scanner. f:: t:: ; Capture the input, terminated by a newline or Enter. Input Barcode, ,`n{Enter} ; Prepend the leading zeroes. while StrLen(Barcode) < 10 { Barcode := % "0" . Barcode } ; Type out the new barcode followed by an Enter. SendInput %Barcode%{Enter} Sleep 5000 Run C:\Documents and Settings\sinclal\Desktop\AHK\ReCreate\ADD PASTE.ahk ; Assign the toggle-suspend function to a hotkey. { F9::Suspend } FILE 2: ADD PASTE.ahk (The file that SCAN.ahk calls to) { Send !e sleep 1000 Loop 12 { Send {Shift}+{Tab} } sleep 500 Send {Enter} sleep 500 Send {Shift}+{Tab} Send Wallets Send {Tab} } It works like a charm! all I do is scan a barcode then BAM! everything's created! ROFL And, thanks for the silent treatment guys. :\ I wish I could get it to somehow remember or store reference numbers for certain classifications that it can recall to.. that's a completely different league though o_O Edited December 15, 2009 by Xog Quote
Testtube Posted December 15, 2009 Report Posted December 15, 2009 WHen you finish early do you lose your job? Quote
»Xog Posted December 15, 2009 Author Report Posted December 15, 2009 Pssh. *nibbles on finger nails while in the fetal position* Quote
»Lynx Posted December 15, 2009 Report Posted December 15, 2009 Isn't a script that pretty much obsoletes your job role for the next 1.5 years something that you keep to yourself? Quote
»Xog Posted December 15, 2009 Author Report Posted December 15, 2009 (edited) Isn't a script that pretty much obsoletes your job role for the next 1.5 years something that you keep to yourself? It's not 100% automated.. the script was originally supposed to just fix a barcode problem, which we wound up fixing.. then I delved a little deeper into the script and made it do a few more things that only takes up my time. It's just making my job more productive, not obsolete. I'm going to get this project finished much faster with the script - Hell, today? I made almost 1,000 files. Yesterday I made 194 without it. Once I'm done re-doing the file room.. it's not "Go home you have nothing more to do" ... paralegals, secretaries, etc. submit new files in here every day. That's what my real job is.. but this annoying side project (which is taking up 95% of my daily time) is really just a big bother.. I could just be sitting back enjoying my time if we didn't have to do this stupid re-production of ALL these files. Most of the staff here at the new office was transferred to our main office in midtown, it's SOOO slow here. I really can't wait to just kick back and relax once it's done. oh, and thanks for the help to those that helped me Edited December 15, 2009 by Xog Quote
»Xog Posted December 16, 2009 Author Report Posted December 16, 2009 (edited) *cough* word1 = CLOSING BOOK class1 = CBCD word2 = CLOSING FOLDER word3 = CLOSING SET class2 = CLOSING DOCUMENTS word4 = PROSP class3 = PROS { Send !e sleep 1000 Loop 12 { Send {Shift}+{Tab} } sleep 500 Send {Enter} sleep 500 Send {Shift}+{Tab} Send Wallets sleep 500 Send {Tab 3} sleep 500 Send {HOME} Send +{End} Send +{Down} Send +{Down} Send +{Down} Send ^c sleep 500 ClipWait if Clipboard contains %word1% Send {TAB 17}%class1% else if Clipboard contains %word2%,%word3% Send {TAB 17}%class2% else if Clipboard contains %word4% Send {TAB 17}%class3% Send {TAB} Send {Enter} } Edited December 16, 2009 by Xog Quote
»Blocks Posted December 16, 2009 Report Posted December 16, 2009 Good job. I told you you could do it. Quote
whalz Posted December 16, 2009 Report Posted December 16, 2009 u r now official member of script kiddies club! Quote
»Xog Posted December 17, 2009 Author Report Posted December 17, 2009 (edited) nevermind .. now it's working again. anomaly o_O! Edited December 17, 2009 by Xog Quote
»Xog Posted December 17, 2009 Author Report Posted December 17, 2009 wtfz going on >.< sometimes it works and sometimes it doesn't.. turning the script off then opening it again doesn't fix it either. this thing is being weird the problem im having is that it seems like sometimes the scanner isn't "typing" in the letters (beginning with f or t) but is instead dumping them in, therefor not initiating the script... it'll work if I type "fdfgs" and press enter, but then I scan and it just types in "f123456" without initiating it Quote
»Blocks Posted December 17, 2009 Report Posted December 17, 2009 the problem im having is that it seems like sometimes the scanner isn't "typing" in the letters (beginning with f or t) but is instead dumping them in, therefor not initiating the script... it'll work if I type "fdfgs" and press enter, but then I scan and it just types in "f123456" without initiating itIt's occurred to me now that this script might not actually work. I tested it by manually keying in barcode strings like f-1-1-1-1-1-1-enter. If the barcode scanner sequentially streams in characters, then it will probably work. If it just dumps the whole barcode sequence like a paste operation, then it won't work. One could create a smarter script to properly handle that input though.This is the potential problem I mentioned previously. Does my barebones script still work when run on its own? Quote
»Xog Posted December 17, 2009 Author Report Posted December 17, 2009 the problem im having is that it seems like sometimes the scanner isn't "typing" in the letters (beginning with f or t) but is instead dumping them in, therefor not initiating the script... it'll work if I type "fdfgs" and press enter, but then I scan and it just types in "f123456" without initiating itIt's occurred to me now that this script might not actually work. I tested it by manually keying in barcode strings like f-1-1-1-1-1-1-enter. If the barcode scanner sequentially streams in characters, then it will probably work. If it just dumps the whole barcode sequence like a paste operation, then it won't work. One could create a smarter script to properly handle that input though.This is the potential problem I mentioned previously. Does my barebones script still work when run on its own? that's the weird part of it all.. SOMETIMES it works, SOMETIMES it doesn't.. there's got to be something contributing to it.. I've noticed that whenever I have this problem, it's always corrected when I start typing a lot (like in this thread, trying to explain it!) I run into the problem, try a few fixes, nothing.. type up the problem in here.. post.. try scanning again, and it works! :\ Quote
»Blocks Posted December 17, 2009 Report Posted December 17, 2009 Does my barebones script still work when run on its own?that's the weird part of it all.. SOMETIMES it works, SOMETIMES it doesn't..So, to get this straight, the script only intermittently works when run on its own? That would be a strange problem if it has only appeared now, and I think would indicate that either something has changed with the barcode scanner software settings, or something in the background is hogging your CPUz. Quote
»Xog Posted August 24, 2010 Author Report Posted August 24, 2010 I know this is a bit of a bump but I just wanted to thank everyone that helped. The firm finally merged both locations and your contributions really helped save a ton of work and time. It's a shame IT doesn't help us or suggest things that could assist in our operations. I was able to create a total of 11,386 files because of this simple little script. I guesstimate I would have only been able to do half of that without it, considering it cut my production time in half. So, thanks guys Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.