CSV List - The definitive KK Photo Story, Magazine Story & Film Story data

[icu]

Originally Posted by Rob4

... in the meantime i'll edit the model id page manually as its easy to keep up with...

I try to get the Editor running well for .P, before I add .A to the same Script.
I think that needs a few days and some practical use on the Thread with it.

[retro man]

attempt №2 - update for post #90
TC - Transexual Climax
correction of some misprints and addition Original Mag (without story numbering)
http://rapidshare.com/files/133837021/TC.rar
used new version of the CSV-editor

[Rob4]

Originally Posted by icu

I wouldn't delete this field now, beause I think we got another use for it.

how about using the extra fields in .A for location of shoot and/or nationality if known.

both these are useful for ids as photoshoot location is usually the same as the models nationality and models often do shoots with other models of their own nationality. this info can be used to narrow down searches...

[fannatastic]

Originally Posted by Rob4

are we all agreed the 'special action' field can be deleted?

No, I think it is important to keep this field. I have changed the name from Special Action to Sex Action. Please see revised post #103 for details.

If you do not like Sex Action or any other field and you do not want to provide any data, then please leave the field blank. Other people will find the data useful.
_______________________

@All

If you agree that the new thread should be called CC data in CSV format, then I will create the new thread myself with that name in the next few days.

There is no need to move any messages from this thread to CC data in CSV format. It is better to start afresh.

Suggested posts for CC data in CSV format:

#1 = Introduction, objective of thread, CSV formats (by fannatastic)
#2 = Tools and links (by icu)
#3 = .A data (by Rob4)
#4 = .P data (by icu)

Data in posts #2 and #3 could be posted in full as one long list, in chronological order. If the posts get too long, then we could replace the lists with links to rapidshare files. However, I think rapidshare should not be used at first, because there are sometimes problems with downloading for non-members.

Errors and additions could be posted by anyone after #3. Once the data lists have been amended, "errors & additions" posts should be deleted to reduce clutter. Other data posts for mags, films, videos, etc. would be added later.

Is this acceptable?

[Rob4]

looks ok to me.

i agree we should avoid using rapidshare as long as possible - i'd rather even try splitting posts first if they become too long

[fannatastic]

Originally Posted by Rob4

how about using the extra fields in .A for location of shoot and/or nationality if known.

both these are useful for ids as photoshoot location is usually the same as the models nationality and models often do shoots with other models of their own nationality. this info can be used to narrow down searches...

Rob4 is right to say that photoshoot location and model nationality are important and should be recorded, but I think that .A lines should not be the source location for these pieces of data. (More about this later.)

The .A lines could be used for the suspected nationality of an unknown actress. For example, if the shoot is in Paris then French? could be added to the Comments field. However, this is optional.

[retro man]

Update for post #89 - SB - Sex Bizarre
correction of some misprints and addition Original Mag (without story numbering)

http://rapidshare.com/files/133866739/SB.rar

used new version of the CSV-editor

[fannatastic]

Originally Posted by retro man

Update for post #89 - SB - Sex Bizarre
correction of some misprints and addition Original Mag (without story numbering)

http://rapidshare.com/files/133866739/SB.rar

used new version of the CSV-editor

Thanks retro man.

I think rapidshare is not necessary for these updates.
Please paste all the data in the message box.

[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?

[icu]

Originally Posted by fannatastic

...Is this acceptable?

Hi, I'm on again.
I agree, perhaps it could be useful to reserve a Place in one of the Top-Posts for all following VB-Scripts, Setups and Helpfiles als Download Links. I looks fine to give the members some free Support and free Tools. He is able to check his Benefit at once without skipping and searching between Threads. I am coding about nearly 30 years and could show only a little of the possible power. I don't want to confuse you all with special Programming-Technics.

I think we can do a lot here if we solve the Start-Problems with different Windows-Versions.