Search:

Type: Posts; User: thudo

Search: Search took 0.01 seconds.

  1. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    Utterly brilliant, Schmidt! That worked without question! \o/ Very much appreciate all your patience.
  2. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    Update to all.. still challenged with this one and need a solution real soon.

    Here is the condensed VBS script:


    On Error Resume Next

    Const ForReading = 1
    Const ForWriting = 2
    Const...
  3. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    Thank you Techgnome... basically its preventing duplicate Shortcut txt files where it has the same duplicate LABELNAMEs so we want to check each time not to duplicate the same LABELNAME inside the...
  4. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    > the end goal is to simply prevent the same Label ID from being written to more than 1 file
    Correct.. its writing a 2nd "redundant" shortcut txt with the same internal LABELNAME when it finds the...
  5. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    Thank you (and others) for your feedback: very much appreciate the support.

    So the CSV (which has three columns "Machine Name", "UserID", "LabelID") can have rows like the one I mentioned...
  6. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    The problem is some rows with the same Workstation ID or especially User ID have the same LABELNAME#.. if the column LABELNAME# has all unique #s for each row then the existing logic would be fine...
  7. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    The CSV is required.. I cannot get around that piece as it is a hard requirement.

    Based on my main VBS code I posted in the first post, can you edit it where I should have this check for the...
  8. Re: Detecting and avoiding duplicate data stored in a loaded CSV

    Thank you Techgnome for the prompt inquiry..

    So the CSV file in question we are reading "WorkstationUserLabel.csv" basically has a mis-mash of Workstation IDs + User IDs + Label IDs so it can be...
  9. Detecting and avoiding duplicate data stored in a loaded CSV

    Morning VB community..

    I am involved with a project where they have provided me a CSV file with a 3-column comma delimited data array..

    It goes as follows:

    Machine Name, UserID, LabelID...
  10. Re: InputBox to check then write to line of a file

    @Nibbs.. no worries.. got this scripted and can be used for reference/guide for others who might find it useful:


    const ForReading = 1
    Const ForWriting = 2
    Set objFSO =...
  11. Re: InputBox to check then write to line of a file

    Thanks Nibbs thats a start. However, my VB skills are still very rusty.. can you form all that into a basic scripting template? This is VERY much appreciated!
  12. InputBox to check then write to line of a file

    Somewhat new to VBS so this is slightly beyond me..

    Essentially I need to build a VB Script that does the following:

    1) Checks for presence of a file in a specific folder. If not, it should...
  13. Replies
    0
    Views
    2,591

    Autoit script help.. anyone?

    Have some Autoit Code I seriously need addressing

    With the help of others I've created this:


    #include <Misc.au3>

    Opt('GUIOnEventMode', 1)

    #Region Pref GUI
  14. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Update.. for the community here is my final script that works..


    Option Explicit
    Dim objFSO, arrProfileAge, colFolders, objFolder, intRecord, intDomainAccts, objUser, objGroup
    Set objFSO =...
  15. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    With the help of a gracious online colleague I have this now:


    Option Explicit
    Dim objFSO, arrProfileAge, colFolders, objFolder, intRecord, intDomainAccts
    Set objFSO =...
  16. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Well the problem is I cannot get the final script for calling the LastModified attrib in Document and Settings (where the user names are stored).I can't get the logic behind the script.
  17. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Noone from this great community can figure this one out? I can't seem to put this VB script together to dump the last 3 users logged into the box into specific groups.
  18. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Anyone?
  19. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Anyone have a simple script to pick up the last 3 logged in users to the PC then transfer them to a local security group I chose?
  20. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Found out how to get it to work adding domain users to the specific groups. Script looks like:


    Dim net, local, objUser, objDomain, UserID, ObjNet
    Set net =...
  21. Re: Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Any one?
  22. Need VB advice - adding last 3 logged in users to group(s) and custom users.

    Essentially, I've created the following to add to our environment three users to a desktop: BKRADM, CTC_ITSPRT, MUSR_MQADMIN then make two groups:
    mqm and mqbrkrs, then put those three users into...
  23. Re: VBscript to Find a File on a Network then output the Results to txt

    I have.. no difference. Commenting that out only removes the line seperation between results. It doesn't affect the last line of the dump which adds the useless result as mentioned.
  24. Re: VBscript to Find a File on a Network then output the Results to txt

    MarkT - I noticed that when the script completes it adds an extra line at the end of the result file:


    **Network Path could not be resolved**
    taken from:

    'Note in the log if the machine...
  25. Re: VBscript to Find a File on a Network then output the Results to txt

    The issue here is that we're dealing with a possible network delay - a computer could theoretically be up on the network but due to lag from the PC running this script to the target machine far off...
  26. Re: VBscript to Find a File on a Network then output the Results to txt

    Outstanding MarkT..

    My only concern so far is what about setting a Timeout so when the script calls each machine's bios name in the list from #1 that if a result isn't found OR the network path...
  27. Re: VBscript to Find a File on a Network then output the Results to txt

    Thanks MarkT..

    Two things to add also:

    1) The search string must also be able to accept wildcards so it looks on the remote PC for "\c$\windows\test*.*"
    2) Also, when it finds something called...
  28. VBscript to Find a File on a Network then output the Results to txt

    Essentially, this is what I am aiming to do with a vbscript:

    1) It reads a text file that has all computer bios names in it
    2) When it reads it it then will look for a filename I choose located...
Results 1 to 28 of 28



Click Here to Expand Forum to Full Width