Re: Importing Passwords and Serial Numbers from Password Retriever?

2007-11-30 Thread Steve Kalkwarf
Has anyone done this before? What is the best way to do it? 
Password Retriever can export records as delimited data files, 
but when I try to import it into Yojimbo, I run into field 
mapping issues. Before I start migrating seven years of 
passwords, serial numbers, etc, from Password Retriever to 
Yojimbo, I wanted to check and see if anyone had any 
suggestions for making this a less painful task.


I'd use an AppleScript to iterate over your entries.

If you can post a couple of example lines, somebody will 
probably be able to help.



--
--
This message is sent to you because you are subscribed to
 the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working
correctly? Please send mail to: [EMAIL PROTECTED]


Re: Importing Passwords and Serial Numbers from Password Retriever?

2007-11-30 Thread Kenneth Kirksey


On Nov 30, 2007, at 9:45 AM, Robert Snyder wrote:

Has anyone done this before? What is the best way to do it? Password  
Retriever can export records as delimited data files, but when I try  
to import it into Yojimbo, I run into field mapping issues. Before I  
start migrating seven years of passwords, serial numbers, etc, from  
Password Retriever to Yojimbo, I wanted to check and see if anyone  
had any suggestions for making this a less painful task.


Jim DeVona posted the following script earlier this year. Worked for me.

-- Example script to import passwords or serial numbers from tab  
delimited files into Yojimbo

-- Jim DeVona 8 March 2007

set _type to button returned of (display alert Select what kind of  
data to import to Yojimbo: buttons {Cancel, Serial Numbers,  
Passwords} cancel button 1)

if _type is Cancel or _type is  then
return
end if

-- read the file
set _file to choose file with prompt Select a tab delimited file  
containing   _type

open for access _file
set _data to read _file using delimiter {(ASCII character 13), (ASCII  
character 10)}

close access _file

-- import each line as a tab delimited record
-- per http://www.blankreb.com/studiosnips.php?ID=17
set _delim to AppleScript's text item delimiters
set AppleScript's text item delimiters to tab -- or {,}
repeat with _index from 1 to count of _data
try
set _line to the text items of item _index of _data
if _type is Passwords then
-- items are name, location, account, and password
			MakePassword(item 1 of _line, item 2 of _line, item 3 of _line,  
item 4 of _line)

else if _type is Serial Numbers then
-- items are product, owner, serial number, and comments
			MakeSerial(item 1 of _line, item 2 of _line, item 3 of _line, item  
4 of _line)

end if
end try
end repeat
set AppleScript's text item delimiters to _delim

on MakePassword(_name, _location, _account, _password)
tell application Yojimbo
		set _new to make new password item with properties {name:_name,  
location:_location, account:_account, password:_password}

end tell
end MakePassword

on MakeSerial(_product, _owner, _number, _comments)
tell application Yojimbo
		set _new to make new serial number item with properties  
{name:_product, owner name:_owner, serial number:_number,  
comments:_comments}

end tell
end MakeSerial

--
--
This message is sent to you because you are subscribed to
 the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]