Hi,
I think it was in relation to this former discussion in 2008 when we started with the origin set titles and converted them to chronological order.

We also spoke about the U... sets that time, but sorry I do not remember where. I am not sure, but I think it was something with a source CSV ?

Of course at the moment there is no .S Shoot info which to me should have preceeded .SA Shoot Actors. To complicate things, magazine stories, film stories, and official set images have and N to N relationship with shoots. For example: Stories such as "Teenage Photo Gallery", "Porno Album", "Color Climax Album" typically have images from multiple shoots. The loop "Sweet Memories" has footage from the magazine stories "Dice, Dicks And An Eager Cunt" and "Candle Delight". cc82x has images from Educating Tina and Maid In Heaven.

Up until know I had simply haddled these multiple shoot stories with comments, however I am currently in the process of restructuring my data. but I digress..

To answer your question a Shoot as I see it is a distinct entity from the magazines, films or image sets it appears in. Thus a .S and .SA listing is possible even though the magazine story is unknown. However this explanation is not entirely consistent with how fannatastic has set up .SA.

Map reference location
 

Might be an idea to put letters down the vertical axis of the ID contact sheet, i.e.:-

A
B
C
D
E

and put numbers along the horizontal axis :-


1 2 3 4 5 6 7

so models could be identified by grid square, for example, LATIN 3-D7 (meaning Latin sheet 3, fourth row down,seventh from the left).
Might make it a bit easier to keep track.
Could be used in addition to existing ident numbers and part names.


Using this system I think LATIN 2-D5 (Zoe 3) could be Michelle Monaghan.

on which sheet thread are you referring to?

i guess, the problem with your idea is that this board doesn't offer the tools to create such a layout. you need something like tables for this issue.

Sorry for entering this thread so late in the piece, but:
When designing a database where the potential primary key is not immutable, one should instead create a surrogate primary key field, e.g. numeric.

Benefit: other tables linking to this one can then rely upon that primary key field. Allows all model names/ID to be altered as/when desired. Also allows different models with the same name, i.e. "Tina" or whatever is not a very good choice for primary key. NB, would need additional info. to distinguish this "Tina" from another of the same name, e.g. photo/nationality/filmography/whatever.

Cost: slightly greater complication to data structure, as would have something like:

modelKey [primary key, numeric, unique]
ID [agreed best name at VEF]
...

A normalised database, as opposed to a simple CSV, would have a related table of model names/aliases, and the ID field would be a foreign key pointing to whichever was the agreed best name:

Models table:
modelKey [primary key, numeric, unique]
ID [foreign key, corresp. nameKey selected for this model, perhaps null if undecided?]
Nationality
...

Names table:
nameKey [primary key, numeric, unique]
modelKey [foreign key to Models table]
name [string]

"Aliases" would be a lookup query/join based on Names with corresp. modelKey as their FK.

Sorry, my SQL is getting rust through lack of use.

Late edit:
A Names table would, however, only be useful if other data were being associated with those individual names/aliases.

Hi,
I built a few (mag source based) test ID Sheets referring to the CSV .SA
The left sheet is ( due to a little more input ) an example for the kind of
floating layout to filter infos without the need to open some or all sheets.

I think this is a better way to prevent from double datas in the CSV .RA
with all its parts and it would make it easier and clear.


http://img219.imagevenue.com/loc950/..._123_950lo.jpg http://img226.imagevenue.com/loc18/t...1_123_18lo.jpg http://img254.imagevenue.com/loc355/..._123_355lo.jpg


I can offer to maintain CSV .SA.

An example for female + male Ids in one ID sheet

http://img134.imagevenue.com/loc192/..._123_192lo.jpg

.SA, AS61.3, F, 1, 'Myriam', Lynn Armitage, , ,
.SA, AS61.3, M, 1, , Jean-Pierre Armand, , , ,
.SA, AS61.3, M, 2, , Andre Kay, , , ,


VEF Scene Pairings ( Starting with the male ID, no Requests ) could be removed

Please do, icu, thanks! :)

When there are multiple females or males in a story, the first one to appear as viewed from left to right and top to bottom is 1.

* * * * * * * * * *

I think the .SA list is not that easy to find and the same applies to other CSV lists, such as .MS and .FS.

Thanks fannatastic :)


This is an example of a .SA visualization ( with some new entries ) for AS only after my first run...

Inside the sheets I sort each gender in a group by name and start printing from left with the females (in alphabetical order : F, M, T).

The backround switches from light green to light blue to separate the stories visual in groups.

I think it will be needed to split the ID sheet post and CSV du to the size that I am expecting.

I had to build the thumbs from serveral sources, they may differ to the originals - but I try my best ;)



http://img212.imagevenue.com/loc944/..._123_944lo.jpg http://img235.imagevenue.com/loc38/t...1_123_38lo.jpg http://img230.imagevenue.com/loc393/..._123_393lo.jpg
http://img208.imagevenue.com/loc232/..._123_232lo.jpg http://img125.imagevenue.com/loc247/..._123_247lo.jpg http://img248.imagevenue.com/loc165/..._123_165lo.jpg
http://img179.imagevenue.com/loc445/..._123_445lo.jpg http://img158.imagevenue.com/loc512/..._123_512lo.jpg http://img258.imagevenue.com/loc21/t...8_123_21lo.jpg
http://img217.imagevenue.com/loc892/..._123_892lo.jpg http://img158.imagevenue.com/loc370/..._123_370lo.jpg http://img135.imagevenue.com/loc100/..._123_100lo.jpg
http://img292.imagevenue.com/loc595/..._123_595lo.jpg http://img212.imagevenue.com/loc1013...123_1013lo.jpg http://img222.imagevenue.com/loc807/..._123_807lo.jpg
http://img158.imagevenue.com/loc30/t...5_123_30lo.jpg http://img21.imagevenue.com/loc472/t..._123_472lo.jpg

I added a few lines of the csv to this post as an example for a search similar to a scene pairing.
(1. 'search forum', 2. 'search this thread' with copied text from the CSV lines below.
Due to the structure of the forum the result appears most times at the top of the list)
_____________________________________________


Hi,
if you found to this post via a search function then you may also find some infos at the ID Sheets
to get a mag source or ID


...
.SA, AS68.1, F, 1, '?', Tiffany Storm, , , @iafd
.SA, AS68.1, M, 1, , Troy Tannier, , ,
.SA, AS68.1, M, 2, , Frank James, , ,
.SA, AS68.2, F, 1, 'Petra', ?, , ,
.SA, AS68.3, F, 1, '?', Christine Marlberg, , ,
.SA, AS68.3, M, 1, , Gerard Luig, , , ,@egafd
.SA, AS68.3, M, 2, , Rex Morrison, , ,

.SA, AS69.1, F, 1, '?', Ona Zee, , ,
.SA, AS69.1, M, 1, , Ray Victory, , ,
.SA, AS69.2, F, 1, 'Claudine', Helene Chevalier, , , @egafd
.SA, AS69.2, M, 1, , Alain L'yle, , ,
.SA, AS69.2, M, 2, , Constantin Acatrinei, , ,
.SA, AS69.3, F, 1, 'Magda', Molly O'Brien, , ,
.SA, AS69.3, F, 2, 'Renate', Biggi Mondi, , ,
.SA, AS69.3, M, 1, , Roy Hunter, , ,

.SA, AS70.1, F, 1, 'Theresa', Fallon, , ,
.SA, AS70.1, M, 1, , Blake Palmer, , ,
.SA, AS70.1, M, 2, , Scott Irish, , ,
.SA, AS70.2, F, 1, 'Jacqueline', Marie-Christine Covi, , ,
.SA, AS70.2, M, 1, , Yves Baillat, , ,
.SA, AS70.3, F, 1, 'Sylvie', Sophie Fibelle, , ,

.SA, AS71.1, F, 1, 'Nicole', Chantal Trobert, , ,
.SA, AS71.1, M, 1, , Christoph Clark, , ,
.SA, AS71.1, M, 2, , Andre Kay, , ,
.SA, AS71.2, F, 1, 'Patricia', 'Gabi', , , @egafd
.SA, AS71.2, M, 1, , Rally Van Essen, , , @iafd
.SA, AS71.3, F, 1, 'Mathilde', Astrid Pils, , ,
...