[fannatastic]

Here are some details of various CC data to be provided in the new CC data in CSV format thread.

It is important to understand the concept of the shoot, as used by BentBastard in his KKK database. An example should make this clear. If a mag story also appeared on film and video, then all three stories are from the same shoot, with the same actors and the same action in the same location.

The proposed CC data are listed below. The categories identified so far are as follows:

Actor (not CC-specific)
Shoot
Shoot Actor
Magazine
Magazine Story
Film
Film Story
Video
Video Story
Photoset Story (on CC website)
Rodox.com Story
Rodox.com Teaser

Missing categories include:

Movie Story (on CC website)

_____________________________________

Fields in green contain "original" or "unique" data.
Fields in blue or purple contain data copied from elsewhere, generally used to link different categories together, especially Shoot.
Type is always the first field and indicates the type of data in the rest of the line.

Magazine contains general data about a magazine. Magazine Story contains data about a particular story in a magazine. There are always these two categories, even if the magazine has only one story. Similarly for films and videos.

It is likely that there will be a separate CSV file for each category.
_____________________________________

Actor
Type
Gender
Name
AKA (Also Known As)
Date of birth
Country of birth
Links
Comments

Notes
Type: .A
Gender: single-letter code for gender, F = female or M = male or S = shemale
Name: professional / porn name of actor that we here at VEF think is the best. If the professional name is unknown, a Shoot Actor Alias should be used (see .SA Shoot Actor below). If actor is unnamed in all of his or her shoots, an ID based on the earliest Shoot ID should be used (please see .SA again).
AKA: other porn name(s) by which actor is known, with multiple names separated by ;
Date of birth: format is D Mon Year, where D = number of day in month
Country of birth: three letter upper-case code for country (exact code to be agreed)
Links: website link(s), with multiple links separated by ;
_____________________________________

Shoot
Type
Shoot
Title
Location
Females
Males
Shemales
Comments

Notes
Type: .S
Shoot: original Magazine Story ID, or original Film Story ID if no mag, or original Video Story ID if no mag or film
Title: original Magazine Story Title, or original Film Story Title if no mag, or original Video Story Title if no mag or film, provided for user convenience only.
Females: number of females in sex action
Males: number of females in sex action
Shemales: number of females in sex action
Comments: could include distinctive properties of the shoot that help to identify it, e.g. furniture, wall posters, paintings, gadgets, buildings, scenery, modes of transport, etc. However, features relating to actors, such as physical appearance and clothing, must not be listed here.
_____________________________________

Shoot Actor
Type
Shoot
Gender
Number
Alias
Name
Sex Action
Links
Comments

Notes
Type: .SA
Gender: single-letter code for gender, F = female or M = male or S = shemale
Number: number of female/male/shemale in shoot. 1 for first, 2 for second, etc.
Alias: alias name given to actor in this shoot, enclosed by single-quote character (ASCII character 39 decimal), e.g. 'Barbara'
Name: porn name of actor, copied from Actor Name (in .A Actor list)
Sex Action: codes for sex action performed by actor with semi-colon separator, e.g. A;DP
Links: website link(s), with multiple links separated by ;
Comments: could include distinctive features relating to this actor that help with identification, such as physical appearance and clothing.
_____________________________________

Magazine
Type
ID
Title
Issue
Date
Pages
Size
Comments

Notes
Type: .M
ID: two-letter code followed by number (e.g. BS13)
Title: full name and number (e.g. Teenage Bestsellers 13)
Issue: number of issue, 1 for original, 2 or more for reprints with later dates
Date: format is Day Mon Year, where Mon is first three letters of month, e.g. Jan
Pages: number of pages including the covers
Size: one-letter code, as follows:
P = pocket, less than 15 x 21 cm (half S or half M or half L)
S = small, 15 x 21 cm (A5)
M = medium, between small and large
L = large, 17 x 24 cm
X = extra large, more than 17 x 24 cm
_____________________________________

Magazine Story
Type
ID
Title
Original
Shoot
Cover
Pages
Pics
Languages
Comments

Notes
Type: .MS
ID: format is Magazine ID.Story Number
Title: story title exactly as printed in mag
Original: if story is a reissue this is the original Magazine Story ID, else blank
Shoot: same as ID if this is an original mag story
Cover: 1 if story shown on front cover, 2 if on back cover, 3 if on page 3 or inside title page. Use semi-colon separator if more than one number, e.g. 1;2
Pages: number of pages in story, excluding the covers
Pics: number of unique pics in story, excluding the covers. Double-page and inset photos count as one pic each
Languages: text languages used in story. Use first letter only with semi-colon separator in same order from top to bottom as in mag, e.g. E;G;F;S
_____________________________________

Film
Type
ID
Title
Issue
Date
Length
Comments

Notes
Type: .F
ID: two-letter code followed by number (e.g. HC526)
Title: full name and number (e.g. Danish Hard-Core 526)
Length: of film in metres
_____________________________________

Film Story
Type
ID
Title
Original
Shoot
Cover
Length
Audio
Subtitles
Comments

Notes
Type: .FS
ID: format is Film ID.Story Number (Film ID.1 for most films)
Title: story title exactly as printed on cover
Original: if story is a reissue this is the original Film Story ID, else blank
Shoot: same as ID if no mag story for this shoot
Cover: 1 if story shown on front cover, 2 if on back cover
Length: of story in minutes:seconds
Audio: language options. Use first letter only or - for silent with semi-colon separator
Subtitles: language options (Is this field necessary?)
_____________________________________

Video
Type
ID
Title
Issue
Date
Length
Comments

Notes
Type: .V
Video: two-letter code followed by number (e.g. BS231)
Title: full name and number (e.g. Color Climax Bestsellers 231)
Length: of video in minutes
_____________________________________

Video Story
Type
ID
Title
Original
Shoot
Cover
Length
Audio
Subtitles
Comments

Notes
Type: .VS
ID: format is Video ID.Story Number
Title: story title exactly as printed on cover
Original: if story is a reissue this is the original Video Story ID, else blank
Shoot: same as ID if no mag story and no film story for this shoot
Cover: 1 if story shown on front cover, 2 if on back cover
Length: of story in minutes:seconds
Audio: language options. Use first letter only with semi-colon separator
Subtitles: language options (Is this field necessary?)
_____________________________________

Photoset Story
Type
ID
Title
Pics
Shoot
Comments

Notes
Type: .PS
ID: photoset code on CC website (e.g. 140x)
Title: story title as shown on website
Pics: number of unique pics in photoset
Shoot: original Magazine Story ID
_____________________________________

Rodox.com Story
Type
ID
Pics
Title
Shoot/Mag Story ID
Comments

Notes
Type: .RS
ID: photoset code on Rodox.com website
Pics: number of unique pics in photoset
Title: mag story title
Shoot/Mag Story ID: usually this is the original Magazine Story ID and therefore identical to Shoot, but if the story has been scanned from a reprint mag this is the reprint Mag Story ID
_____________________________________

Rodox.com Teaser
Type
Link
Title
Shoot/Mag Story ID
Comments

Notes
Type: .RT
Link: webpage link to teaser photoset
Title: mag story title
Shoot/Mag Story ID: usually this is the original Magazine Story ID and therefore identical to Shoot, but if the story has been scanned from a reprint mag this is the reprint Mag Story ID
_____________________________________

A possible addition to each category is Keywords where key words or tags can be written, to help with searching. Alternatively key words could be placed in the Comments field.

I hope this makes some sense. If not, I could provide more info.

Any comments?