Home / Library Software / Handy Library Manager / Tutorials: How to organize movie library?

Handy Library Manager  for Windows

Help, how to topics > Specialized Libraries > DVD, Video Tape, Blu-ray library, how to customize?


This topic explains:

  • How to change data field names in the library table?
  • How to manage dvd, blue-ray video tape library?
  • How to manage film archives?

Our databases in Handy Library Manager use data field names that support entries for the following items: books, magazines, dvds, video tapes, cds, serials, documents, ...

If you would like to organize specialized library with one type of items, we suggest to optimize the field names of the main inventory table. For example if you manage video tape archive library you would rather use the following data field names: DIRECTOR, RUNTIME, CAST, STUDIO, GENRE, MUSICBY, ...

Below we include explanations how you could quickly use our predefined field names file that will allow you to convert our Handy Library Manager (general library solution) to a specialized library (movie library solution).


LIBRARY:

Handy Library Manager:
regular data field names used in a main library catalog table

field position

name change is allowed

Video Tape, DVD Library:
new field names
(empty box: no name change)

IDNO 1 - -
TITLE 2 YES -
AUTHOR 3 YES DIRECTOR
TYPE 4 - -
COAUTHORS 5 YES CREATORS
PUBLISHER 6 YES STUDIO
PUBLISHED 7 YES RELEASED
PLACE 8 YES STAR
SERIES 9 YES -
EDITION 10 YES SEASON
CATEGORY 11 YES GENRE
LEVEL 12 YES RATING
FORMAT 13 YES MEDIATYPE
EDITOR 14 YES MUSICBY
ILLUSTRATOR 15 YES COUNTRY
PAGES 16 YES RUNNINGTIME
PHYSICAL 17 YES DETAILS
DEWEY 18 YES CATALOGNR
LCCN 19 YES USER_1
ISBN 20 YES USER_2
ISSN 21 YES USER_3
UPC_EAN 22 YES -
SUBJECT1 23 YES -
SUBJECT2 24 YES -
SUBJECT3 25 YES -
SUBJECTS 26 YES -
NOTES 27 YES -
SUMMARY 28 YES -
IMAGE 29 YES -
CUSTOM1 30 YES -
CUSTOM2 31 YES -
CUSTOM3 32 YES -
CUSTOM4 33 YES -
CUSTOM5 34 YES -
CUSTOM6 35 YES -
CUSTOM7 36 YES -
CUSTOM8 37 YES -
CUSTOM9 38 YES -
PRINT 39 - -

The above new field names are stored in the library-video-library-data-fields.fld file.

Click here to download: library-video-library-data-fields.fld. Save the file on your computer in any temporary folder. Remember the folder name.


movie library, customize data fields

Start Handy Library Manager.

Open the Options window. Click the Maintenance tab.

Click Change Field Names.


movie library, customize data fields

Select Library database.


movie library, customize data fields

Click Load From File.


movie library, customize data fields

Select library-video-library-data-fields.fld file.

Click Open.


movie library, customize data fields

New field names are displayed in the Current Field Names box.

Click Next.


movie library, customize data fields

Click Apply Changes.


movie library, main movie inventory window

Handy Movie Library, the main inventory table with sample movie entries and new field names.


movie library, check in check out transaction window

Handy Movie Library, the check in/out window with sample check out transaction.


movie library, inventory report sample

Handy Movie Library, inventory detailed sample report.


This is the list of additional data field names that you can consider when optimizing our Handy Library Manager for management of the Video Tape, DVD, and Blue-ray film library:

BUDGET
CAST, STARRING, SUPPORTING_ACTORS
AWARDS
RUNTIME
DISC_NUMBER
COUNTRY
PRODUCER
SCREENPLAY
BASEDON
CINEMATOGRAPHY
EDITED
DISTRIBUTED
BOXOFFICE, GROSS
PLOT
KEYWORDS
RATING, LEVEL
MEDIATYPE, FORMAT
SUBTITLES

Genre List:
Drama
Thriller
Crime
Musical
Comedy

Changing field names, rules:

  • No duplicate field names are allowed.
  • If the field name is already used in library main or copy tables you are not allowed to use this field name.
  • If you want to move the name to a different position you are allowed to do that. First you have to rename the field at the old position.

Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2018 · All Rights Reserved · PrimaSoft PC