| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| mypassv7.1 | 2015-11-17 | ||
| README | 2015-11-17 | 3.9 kB | |
| Totals: 2 Items | 3.9 kB | 0 |
# # Skyline Research ;) -- Password Management Scripts (OSX) -- v7.1 2015-11-15 # # 1) Get the files and install sqlite3 and the Apple sample ClipboardViewer.app # for later use. # # 2) Un-zip the package containing the files: # # mypassv7.1 is the top directory # # ./_com should be copied to ~/.com # ./Scripts should be copied to your OSX ~/Library/Scripts folder # with the files edited to ensure the path name will be correct. # ./bin contains mypassv7.1 which is a copy of mypassSEL.v7.1.sh below. # # 2A) Check the scripts as above to ensure you will use the correct the path name. # # 3) Set the working directory name in the two Bash scripts now in your ~/.com folder: # # mypassADD.v7.1.sh # mypassSEL.v7.1.sh # # The full folder name is ~/.com/skyprod/mypass/v7/dev # # 4) Create a plain text file to contain the passwords to be loaded into the sqlite3 # database. # Lines should be ordered alphabetically. Each line should contain information # that you will search for: e.g. # # name-of-web-site email-address password-to-use date # # You can include any data in the database. The important thing is to know how you # will search for it in the database. # # If you want to include more than one line for a "name-of_web-site" do it like this: # # name-of-web-site_01 email-address password-to-use date # name-of-web-site_02 email-address password-to-use date # # The file should be in the same folder as in the next step. # # 5) Check the script file xprod.0.LOADNEW.sh in ~/.com/skyprod/mypass/v7/dev # # - Ensure the input file name is correct. # - The database (DB) will contain records with a single field "Code" and each # record is automatically assigned a unique ID # - Do not change the database name because it is used in the other # script files. Their names are self-explanatory, though you do not need # to run any of them and you should inspect them carefully if you do: # # xprod.0.LOADNEW.sh - will create and load the database # from a flat text file # # xprod.2.RM+LOAD+SEL.sh - will delete the table and load it # and run selects for testing. # # xprod.2.UPDATE_CMDLINE.sh - will let you update the database # from the command line # # xprod.3.INSERT_FROM_FILE+SEL.sh - will update the DB from a flat file # # xprod.4.DELETE.1IDEQUAL.sh - will delete 1 record with the specified # ID # # xprod.4.DELETE.1IDLIKE.sh - will delete 1 record with a Code "like" # what you specify # # xprod.6.SELECT.1ALL.sh - will select all records in the entire DB # # xprod.6.SELECT.1Code.sh - will select 1 record by Code # # xprod.6.SELECT.1ID.sh - will select 1 record by ID # # xprod.6.SELECT.ALL_TO_DUMP.sh - will select all records in the DB # # xprod.7.SELECT.ALL_CODE_TO_DUMP.sh - will select all Codes in the DB # # 6) Run the Applescript mypassADD.v7.1.scpt to ADD a record. You must use double quotes. # Results will be displayed using ClipboardViewer.app. # # 7) Run the Applescript mypassADD.v7.1.scpt to SEARCH the database. # Results will be displayed using ClipboardViewer.app. # # If necessary please contact the author by email at sourceforge@michaelcook.ca