William Shipley's dashboard

I have to send myself an email with an xls of the delicious export every time I go book shopping (700+ at the moment and still increasing!) which is OK but I have come to expect a better solution from Delicious/iPhone combination.

Got the same problem publishing to a folder. Started out with a 1.5 library, now running the latest verison.

I'm getting the same error, also when publishing to mobile me. report was submitted.

If it would help, I would be happy to send you an export of the database so you can see what the actual data looks like.

It does appear to be a data issue, rather than just an issue with the publishing template, as when I look at items in the list view, it actually gives me two items to "click to search" for each entry. Further, it shows up doubled in the iPod sync function.

When I look at editing the actual data in the program however I don't see anything that looks doubled, or anywhere to correct it.

Is there any way to do an export *just* of the UPC data and then have it auto-refresh from that? I poked around for a little in the export function... Any way to interact more directly *in the program* with the actual data?

When I got first DL there was one thing I wished for and that was the ability for multiple users/macs in a family to share the same database. I really want the ability for my wife to be able to add and update the library without having to change computers or log into my account.

Now that the iPhone is out make that two items on my wish list with the second being a fully accessible library on the phone.

It seems to me that solving the multiple user problem would help in solving the iPhone problem. If a syncing system for DL2 was written so that multiple DL2s can sync their databases together then writing a version of DL2 that runs on the iPhone/iTouch should be easier to manage.

One should not have to transfer that much data when syncing. Sure the initial sync might take a while, who cares, but once it's done later syncs should only take a few seconds. After all just how much data would you really change during a session?

I don't know what's use to manage the database in DL2 but the iPhone has SQLite as a standard part of the SDK. I would not expect a 5000 item database slowing SQLite down much.

BTW, there is now something like DL available for the iPhone, it's call StuffRadar. I would think that getting a sync-able version of DL on the phone would increase the bottom line although you might have to port the Windows, yuck.

Anyway, keep up the good work.

It is a matter of exporting to the web and then viewing via Safari--though, who knows, we may be developing something a little better. =)

Another option would be to export to tab delimited or excel format, then transfer those files over to your Touch/iPhone. I've got a detailed explanation of how one user got everything onto his iPhone. I'll try to dig that up and post it.

This script requires a little setup. It will create a seriestranslate.db file in Library/Scripts/Applications/Delicious Library 2. You can change the location if you like. Select the items you want to set series name for and run the script. Most likely, the first item in the series will either be blank or wrong. Correct the series name and then select the items and rerun. Subsequent items in the series should find the proper series name based on the value you used for the previous entries.

This algorithm makes assumptions that you will start low and go high. If you start at volume 9 and then go to 8, it'll get confused. But as long as you have volume 1, you should be ok for the most part. Also, if Amazon changes how they name the items, then it will also lose track and have to be corrected. The thing to remember is to rerun the script if you have corrections so that the separate DB can be kept up to date with your preferences. – Jerry, on September 05, 2008 17:18

-- Menu Title: [0], "Translate Amazon Name to Series"
-- Menu Keyboard Shortcut: command-option-1
-- Menu Path: [3], "Series Scripts"
-- Maintain a sqlite3 db to track Amazon returned titles and the series they are translated to. Then for future additions, guess the desired series based on previous entries.

-- Attempt to put the database in the scripts directory. do shell script seems to start in user's home.
set databasedir to "'Library/Scripts/Applications/Delicious Library 2/'"
set database to "seriestranslate.db"
set sqlcmd to "cd " & databasedir & "; sqlite3 " & database & " "

-- Create tables if they don't exist
do shell script sqlcmd & "'create table if not exists translate( dl2id text primary key, series text, amazonname text); create index if not exists amazonname_index on translate(amazonname desc);'"

tell first document of application "Delicious Library 2"
set selectedItems to selected media
set selectedItemsRef to a reference to selectedItems
repeat with mediaItem in selectedItemsRef
set itemId to id of mediaItem
set itemSeries to series of mediaItem
set itemAmazonName to name of mediaItem
if itemSeries is missing value or itemSeries is "" then
-- itemSeries doesn't exist so find a new one
set query to "select series from translate where amazonname < \"" & my sql_escape(itemAmazonName) & "\" order by amazonname desc limit 1;"
set seriesName to do shell script sqlcmd & quoted form of query
set query to "replace into translate (dl2id, series, amazonname) values (\"" & my sql_escape(itemId) & "\",\"" & my sql_escape(seriesName) & "\",\"" & my sql_escape(itemAmazonName) & "\");"
do shell script sqlcmd & quoted form of query
set series of mediaItem to seriesName
else
-- series name already exists so update existing record
-- we don't update name because it may have changed since we retrieved it from Amazon.
set query to "update translate set series = \"" & my sql_escape(itemSeries) & "\" where dl2id == \"" & my sql_escape(itemId) & "\";"
do shell script sqlcmd & quoted form of query
end if
end repeat
end tell

on sql_escape(sqltext)
set AppleScript's text item delimiters to "\""
set the item_list to every text item of sqltext
set AppleScript's text item delimiters to the "\"\""
set sqltext to the item_list as string
set AppleScript's text item delimiters to ""
return sqltext
end sql_escape

hmmm no it doesn't
at least not on a uk iPhone 3g 2.0.
am I missing something really obvious
or as I originally suggested is this just available in the US of something or other :)

We're working on that. Coming very soon! – Eric Suesz, on September 05, 2008 06:25

I just want to say that I would very much like an admin drop down to change the type of a topic.

just go to the site on your iPhone, same URL as in a regular browser. It automatically detects you're on an iPhone and shows the webapp.

ok is this just a USA thing?
I can export to mobile me site and it puts the files in 'sites'
Can't work out how to access from iPhone
refers to it on delicious site but no actual explaination
If we can buy and use your software in the uk could we perhaps be considered when something doesn't include us - better yet let us play with the new toys - oh and excellent beautiful software by the way - you should be proud of yourselves

W: your diagnosis is correct.

The app was in the system app dir, but being run by the 'media' user (a non-admin account which runs our hosts our shared household iTunes and iPhoto and now DL2 libraries).

Since that was the only user who would be running DL2 on that box, I just moved it to the user app dir and it updated from there without any error.

Thx

I'm seeing a universal binary when I download from:

http://delicious-monster.com/download

I've seen the Finder report this before -- the problem then was that the user has set permission so her /Applications folder wasn't writable by her, so our upgrade process ended up "gutting" her old version of the app, leaving an empty husk, and then installing itself on her desktop when it discovered it couldn't overwrite the version in /Applications.

Did you look on your Desktop for Delicious Library 2?

When she tried to launch the version in /Applications the Finder reported "there's no binary in here that runs on this computer" because that's the closest error message it had to "this is actually an empty husk."

Obviously, this is sub-optimal on my part -- updating is a tricky business, since we're dealing with different security configurations, and lots of people have changed permissions from the default.

-W

The same error occurred for me when publishing to my me.com website. It happens every time I publish- I've submitted a bug report with the error log.

Actually if I publish with select shelves it will work. But, when I add Itunes tv shows or Itunes music is when it locks up only.

Terry

Yes it did. It was showing up at http://homepage.mac.com/armandxp/deli...
I tried it using the two different templates but it keeps crashing. Were exactly do I go to copy the library so I can mail a copy of it to you? I just purchased this software in the past month, so I'm still a little new to it.

Thanks,

Terry