Results 1 to 5 of 5

Thread: making lists from OCD database

  1. #1

    Smile making lists from OCD database

    Out of about 3000 entries in OCD I want to make up a list of some of the items -for selling, in fact.
    Want to use Composer, Title, Label, number fields and then to add a price. Want to just do a copy and paste from OCD if poss.Can anyone help on this?I tried the export to HTML but is cumbersome and not the simple one line affair I want.I don't want to have to type in all the items if I can do it more easily.Any help would be appreciated. Brian

  2. #2
    Join Date
    Oct 2006
    Location
    Posts
    304

    Default

    If you have some way of selecting the items you want to sell, as through an advanced query, and highlighting them you can use Export to Plain Text. You can select which fields you want to be included, what delimiter you want to use between fields. The file this creates can be easily imported into a spreadsheet for any further processing you might want. In fact, one option you might want is to export the entire database (just the fields you want, of course), import the file into a spreadsheet and do your selecting and pricing there.

  3. #3

    Default

    Thanks for your help. If I export contents of fields, do I lose the original data on OCD, or does it copy? Brian

  4. #4

    Default

    Further to my reply.Not sure what "an advanced query" is.Basically I want to have all the OCD in track view,in say composer order and then select a record and move contents of some fields from that record into another list or even another new db called Sale discs.
    EG. Wagner Norwegian Radio orch Wagner: Sym in C Major 4233 2824 in OCD
    now want to copy these fields.

  5. #5
    Join Date
    Oct 2006
    Location
    Posts
    304

    Default

    1) When you export, it just exports a copy. You have to select the fields you want to be exported (for example, the track times might not be important for your sales list).

    2) Advanced query is actually Query -> Advanced search and allows you to select a sub-set of your database (for example, all cds with baroque compositions - if you entered baroque in the genre or sub-genre field say).

    3) Here's what I think you want to do. Click on Entire Collection in the Content Tree (left column). Choose View - View - Tracks. Choose which columns/fields you need to have to make your selection (these need not be the fields you want to export). Sort by clicking on whichever column head is appropriate. If you have used Group to indicate composition and want the tracks sorted by composer and then composition and then movement within a cd, you would sort in reverse order: first sort on title, then on track title, then on group title, and then on composer. Highlight each track you want to export (I suspect this may take some time). Then Database -> Import and export -> Export to plain text. Make sure the radio button at the bottom selects Export selected items only. Next>. Then select the fields you want to export (these need not be the ones you had in the track view). And here's where you might hit a snag; it looks as if Group is not an exportable field (anything you can do about this, Andrei?). Next>. Enter (or browse for) a filename; choose the sort order for the exported file (need not be the same as in the tracks view) and make some formatting options. Next>. It then gives you a preview of how the the first 16 items will appear in the export file. Next>. Here's your last chance to back out. If you are happy - Finish and then go find your file and bring it into what ever program (word processor, spreadsheet, etc.) you want. Or go <Back to change something or Cancel to quit altogether. This should give you a file with each track on a single line. OCD gives you lots of options - that's what makes the process a litttle complex - on exporting your data.

    Remember, nothing you do during export will change the data in OCD so feel free to experiment with different formats for the output. One thing you might want to do right after you have highlighted the things you want to export is to mark them in some way. Here's what I do: right click -> properties to get bulk edit, then find a field you never use (I use single/b side on the General tab, but you might want to put something - for sale, for example - in the keywords field of the Notes tab). Then click OK. Then if you need the selection again, you can do Query -> Advanced search -> Tracks tab and set up your criteria, Add to list and then search.

    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •