Re: Importing Excel file into YJ

[Jim DeVona]

On 5/20/07, Phil Emery <[EMAIL PROTECTED]> wrote:


Thanks for the info

not too sure what to do with the script.

I suppose copy and paste into the script editor?

then?


Right, copy and paste it into the script editor. Alternatively you can
download a copy from
http://anoved.net/files/YojimboPasswordSerialImport.scpt.zip (the
version in the mailing list archives may contain extraneous line
breaks).

If you only plan to use it once or twice, you can just click the "Run"
button in the script editor window. The script will ask whether you
are importing a list of serial numbers or passwords and will then
prompt you to select a tab-delimited text file containing the list.

In the case of serial numbers, the script expects each line to contain
the product name, the owner's name, the serial number, and comments,
in that order and separated by tabs. For passwords, the expected
fields are title, location URL, account username, and password. These
fields are based on the fields from the original user's spreadsheet,
so if you wish to use the script without modification you'll need to
arrange your spreadsheet to match.

[General background on using scripts, for everyone's reference:]

If you do end up using this or any other AppleScript frequently, you
may want to use the script menu. Save the script file in the "Scripts"
folder in your home folder's "Library" folder. Then open the
"AppleScript Utility" in /Applications/AppleScript and check the "Show
Script Menu in menu bar" option. A new menu with a scroll icon will
appear in your menu bar. Select a script from this menu to run it.

If you only want a script to appear in the script menu when a certain
application is active, create an "Applications" subfolder in yours
"Scripts" folder and a folder with the name of the desired application
inside that. Any scripts placed in the specific application subfolder
will only be visible when that application is frontmost.

Many third-party utilities provide other ways to invoke scripts. I
like FastScripts because it is simple and it uses the same directory
structure as the default script menu. I believe other utility programs
like Quicksilver, LaunchBar, and Butler provide similar capabilities.


let's hope BB puts this capability into Yojimbo. It would make people
more willing to switch to Yojimbo if they can easily move their
existing collection into YJ easily.


True. I suppose the challenge is selecting a suitable "common
denominator" format to move things from other applications to Yojimbo,
as Bare Bones cannot be expected to cater directly to every
individual's particular approach to information management.

I think this works out well in many cases, such as notes, since most
note-taking software offers export to text files. HTML files import as
web archives and .webloc files import as bookmarks. But is there a
popular standard file format for password or serial number
information? If there is, I would agree that it ought to be supported,
but otherwise I think that AppleScript provides an appropriate means
to tack on support for the particular needs that vary from user to
user.

Anyway, be well and let me know if the script is any use.

Jim


>On 5/19/07, Phil Emery <[EMAIL PROTECTED]> wrote:
>
>>Hi there
>>
>>I have an excel database with serial numbers and such that I need to
>>import into Yojimbo.
>>
>>I went through the help and the support section ( I guess there's no
>>manual for Yojimbo?) but there was no info on what kind of formats YJ
>>can import.
>>
>>I tried XML but it didn't work
>>
>>thanks!
>
>My impression is that you can import files that correspond to Yojimbo
>item types (ie, text files and PDFs). However, it is possible to
>import other types of files, such as lists of serial numbers, with a
>little help from AppleScript. I am familiar with at least one case
>where this has been done to import sets of items exported from Excel
>in tab-delimited text format:
>
>http://www.listsearch.com/Yojimbo/Thread/index.lasso?582
>
>I suspect you can find others solutions in the archives, too.
>
>Let me know if that looks useful or if you need help running or
>adapting the script.
>
>Jim


--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>

Re: Importing Excel file into YJ

[Phil Emery]

Thanks for the info

not too sure what to do with the script.

I suppose copy and paste into the script editor?

then?

let's hope BB puts this capability into Yojimbo. It would make people 
more willing to switch to Yojimbo if they can easily move their 
existing collection into YJ easily.


p


On 5/19/07, Phil Emery <[EMAIL PROTECTED]> wrote:


Hi there

I have an excel database with serial numbers and such that I need to
import into Yojimbo.

I went through the help and the support section ( I guess there's no
manual for Yojimbo?) but there was no info on what kind of formats YJ
can import.

I tried XML but it didn't work

thanks!


My impression is that you can import files that correspond to Yojimbo
item types (ie, text files and PDFs). However, it is possible to
import other types of files, such as lists of serial numbers, with a
little help from AppleScript. I am familiar with at least one case
where this has been done to import sets of items exported from Excel
in tab-delimited text format:

http://www.listsearch.com/Yojimbo/Thread/index.lasso?582

I suspect you can find others solutions in the archives, too.

Let me know if that looks useful or if you need help running or
adapting the script.

Jim

--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>



--

 Phil Emery
 creative director 
 [EMAIL PROTECTED]  
 
 Focused Creative Communications

 18 Hook Ave. (416) 534-4273
 Suite 106   fax: (416) 534-7740
 Toronto, ON  M6P 1T4  http://www.focusedcreative.com

--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>

Re: Yojimbo workflow for access password protected websites.

[Matt Henderson]

Because I want to do step number 3 (in my desired workflow); I want  
to have to enter my global password.


On May 16, 2007, at 9:55 PM, bill shamam wrote:



Why not use the MacOS Keychain for this?   That's what it's  
designed for.


On May 15, 2007, at 6:30 AM, Matt Henderson wrote:

Probably one of the most frequent uses of Yojimbo for me, is  
accessing passwords to websites/forums I visit. For most sites  
these days, I use the same user name, and then generate a unique  
random password that I store in Yojimbo.


When I access sites, here's the present workflow:

1. F6, switch into yojimbo
2. Type "PayPal" (for instance)
3. Click to select the right record.
4. Click "Copy"
5. Type in my application password.
6. Control click URL to open.

Here the workflow I'd prefer to have:

1. command-space to invoke quicksilver
2. Type "PayPal" (it would soon learn I'm looking for my Yojimbo  
record), and hit return.

3. Type in my application password
4. I then find myself in safari at the paypal website with my  
password on the clipboard.


Anyone know how this could be setup? (or whether it's even  
possible?) Thanks!


Kind regards,

--
Matt Henderson, MakaluMedia Group
http://makalumedia.com | +34 952 900 776 | +1 404 975 0988

--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's  
workingcorrectly? Please send mail to: <[EMAIL PROTECTED]>



--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's  
workingcorrectly? Please send mail to: <[EMAIL PROTECTED]>





--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>