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 <[email protected]>.
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]>
