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

[Al Gebra]

As I mentioned in an earlier post the CSV maintainer (CSV stands for Comma-Separated Values) always tries to reflect the website at the time he is working on it. Collection CSVs are actually made to support collectors using collection managers to identify, verify and sort their files - and to burn them onto CD (or DVD) in the end. The naming convention is usually the name of the website, number of completed ("Final") CDs, and number of files included, like
'ColorClimax-CD01(Final)_5116.csv'.

Basics of such a CSV are file name, size and CRC. Most of the collection CSVs are extended (ECSV). That means they also contain information like paths and/or descriptions, like

0197a01.jpg,57803,91dd3c3b,\0197a_SG\,Erotic Ride

The order of the entries is important.

1. Filename (0197a01.jpg)
2. Size counted in bytes (57803)
3. CRC32 value in hexadecimal format - 32 bit Cyclic Redundancy Check (CRC), a sort of "fingerprint" (91dd3c3b)
4. Complete path for the file (\0197a_SG\). Collection managers need the back slashs ('\') to create folders automatically.
5. Optional comment (Erotic Ride)

The example above shows that the story title is defined as comment. In later CC-CD CSVs the story title is added to the path, and the comment field is left empty, like

cc74d01.jpg,200685,0DDF5C9A,\cc74d_CC - Weekend Affair\,

The status of a CSV being "Ongoing" is self-explanatory. If a CSV has reached the proper number of files so that a full CD can be filled it is named "Pre-Final". The CSV maintainer waits for possible changes on the website or for corrections from fellow collectors. After a month or so the CSV file is declared "Final" or "Finished", ready to burn. The CSV is now closed, and no changes will be made to it any further as a rule.

Sometimes CSVs are "Pre-Final-1": The CSV is still not 100% closed, and the maintainer changed something. Maybe he added a missing file, maybe renamed a folder, or maybe decided to move a folder to the next CD (that happend to ColorClimax-CD09).

In combination with a collection manager a CSV file allows you to check a series of files automatically. For example, you can verify that you have the entire set, and that all the files in the set are identical to the originals used to create the CSV. No more worries about getting resized, supposed "improved" or corrupt files. What's more, the checking software can generate a "wish list" of files you need. It is also possible to identify pics with "wrong" file names. If file size and CRC were not altered a collection manager will verify a random pic, say, "Alicyn_Sterling01.jpg", and rename it to "0197a01.jpg" according to the CSV.

Some useful tools:

• The!Checker aka PicCheck http://mitglied.lycos.de/vhorch/piccheck.htm
• Hunter http://broquard-ebooks.com/hunter/Default.htm
  
• fastCSV http://wdispatcher.tripod.com/
  
• CSV Workshop http://home.comcast.net/~brazilwares/

The first two tools are collection managers. They can make a CSV, and they can sort files according to CSVs.

fastCSV is a tool for making CSVs; it cannot sort files according to an ECSV. This tool is a command line tool and has no graphical user interface (GUI).

CSV Workshop is a tool for viewing CSVs and finding problems among ECSVs. This includes internal and external dupes, syntax errors and the like.

All tools mentioned above are designed for Window$. There are also tools available for other OSs as far as I know.

[fannatastic]

Originally Posted by Al Gebra

As I mentioned in an earlier post the CSV maintainer always tries to reflect the website at the time he is working on it...

Who is this CSV maintainer? Is his name an anagram of Al Barge?

[icu]

Update Post 142

B.2 CSV_Timeline Calculator V1.00 by icu ( Freeware )
A little Visual Basic Programm to calculate a Sequence of Magazines according to the Timeline



I think this could be a good Program for .M

[Al Gebra]

Originally Posted by fannatastic

Who is this CSV maintainer? Is his name an anagram of Al Barge?

I'm sorry, no.

[fannatastic]

Well, in that case I can say without fear of retribution that the CSV maintainer makes mistakes!

[fannatastic]

.P, 140a, CC, Lucky Fucker, 22, CC168.6,
.P, 140b, BC, Pleasure In Paris, 22, EX33.1,
.P, 140c, SG, Play With My Balls, 22, TS38.6,
.P, 140d, CC, Red Hot Hole, 22, RO76.4, Red-Hot Hole
.P, 140e, BC, Love American Style, 22, BC46.2, Making Love American Style
.P, 140g, AS, Anal Break, 22, AS60.1,
.P, 140h, SB, Liquid Lust, 22, SB45.2,
.P, 140i, SG, The Lust Boat, 22, RO75.4,
.P, 140j, CC, Sex Shop Special, 22, RO59.5, Sex-Shop Special
.P, 140x, CG, Horny Flat Mates, 18, RO14.2, Horny Flat-Mates


I think all mags from 1296a-140x have been identified.

[Rob4]

Originally Posted by fannatastic

I think all mags from 1296a-140x have been identified.

excellent! (thats my bad keanu reeves impression)

without me going back through all the posts has anyone given any thought how reprints/origianal printing can be incorporated into the data? i've noticed some in the 'comments' column but i'm not sure this is ideal.

would it not be better if these are placed in brackets immediately after the mag# reference?

eg P., 140b, BC, Pleasure in Paris, EX33.1 [R:EX10.2], etc...
eg P., 140b, BC, Pleasure in Paris, EX33.1 [OP:EX10.2], etc...
(this data is semi made up so ignore its accuracy)

R = Reprint
OP = Original Printing

or is everyone happy to have it in the comments?

[icu]

Originally Posted by fannatastic

.P, 140a, CC, Lucky Fucker, 22, CC168...

Thanks fannatastic, .P-List updated to 31

[fannatastic]

Originally Posted by Rob4

excellent! (thats my bad keanu reeves impression)

without me going back through all the posts has anyone given any thought how reprints/origianal printing can be incorporated into the data? i've noticed some in the 'comments' column but i'm not sure this is ideal.

would it not be better if these are placed in brackets immediately after the mag# reference?

eg P., 140b, BC, Pleasure in Paris, EX33.1 [R:EX10.2], etc...
eg P., 140b, BC, Pleasure in Paris, EX33.1 [OP:EX10.2], etc...
(this data is semi made up so ignore its accuracy)

R = Reprint
OP = Original Printing

or is everyone happy to have it in the comments?

Reprints will be mentioned elsewhere, not in .P lines.

Please see post 281 and the updated and important post 122

I will provide details of how mags, film and videos are linked together later today.

[fannatastic]

Before reading any further, please see post 122

The Shoot links the separate mag, film, video and other data lists together. Before discussing how the linking works, I will give more details about the Shoot itself.

In BentBastard's KKK database, the Shoot is a unique number for each shoot. This is fine, but the number is meaningless. It is impossible to deduce anything about the shoot from this number.

However, it is possible to give the Shoot a much more meaningful value, thanks largely to the foresight of CC when choosing series names and numbers for their films and videos.

At this point, it is worth looking at the number of different permutations of mag, film and video stories from the same shoot.

M, F, V
x, -, -, mag story only
-, x, -, film story only
-, -, x, video story only
x, x, -, mag & film stories
x, -, x, mag & video stories
-, x, x, film & video stories
x, x, x, mag & film & video stories

Mag, film and video series do not share the same numbers, e.g. Teenage Sex mags are 1-96, films are 701-762 and videos 776-795. Similarly for Blue Climax, Color Climax, Rodox, Pussycat, etc. This good planning by CC allows us to choose the following values for Shoot:

Shoot = original Magazine ID.Story Number if mag story exists, else
Shoot = original Film ID.Story Number if film story exists, else
Shoot = original Video ID.Story Number

As there are no conflicts between mag, film and video numbers, we can be sure that the Shoot will never be the same for two different shoots. It is critically important to have unique Shoot values and using the above method they will be unique.

The mag story has highest priority because there are more mag stories than film or video and all the website photostories are 'copied' from mag stories. Having defined the Shoot, let us see how the linking works by looking at an example.

The first story in Sex Bizarre 21 mag is Pissing About, reissued in Sex Bizarre 40 mag as A Pissy Trick. The corresponding films and videos are Color Climax 1345 (original film), Color Climax 310 (original video, second story) and Bestsellers 231 (reissue video, second story), all with the same story title of A Taste Of Piss.

Therefore, the Shoot is SB21.1 and appears in all the relevant Magazine Story, Film Story and Video Story lines. By reading the Shoot in the film story or video story lines, the corresponding mag story can be found immediately for this shoot.

To connect a film with a video when the mag story exists, read the Shoot in a Film.Story line and then search for this value in the Video.Story lines. A database or program could do this automatically to generate lists of corresponding mag, film and video stories.

In our example, the mag story exists and therefore the Shoot, Magazine Story ID and Magazine Story Original for SB21.1 are the same. However, as SB21.1 is the original we can leave the Magazine Story Original field blank. In the BS231.2 line, Video Story Original is CC310.2.

If there were no mag story, the Shoot would be CC1345.1. A Shoot the same as a film story ID means there is no mag story. No other searching is required to confirm this. Similarly, a Shoot the same as a video story ID means there is no mag story and no film story.

Note that in the .P lines, Original Mag.Story# is identical to Shoot. We do not need to spend any time changing all the lines that we have created to make them compatible with the Shoot concept!

I hope that this post has helped to make things clearer. Please ask if you have any questions.