|
|
|
![]() |
Meet Our Girls | Register | FAQ | Members List | Calendar | Mark Forums Read |
![]() |
|
Thread Tools | Display Modes |
![]() |
#31 | |
Former Staff
Join Date: Jan 2008
Posts: 2,132
Thanks: 4,787
Thanked 18,275 Times in 1,784 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() 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. Quote:
__________________
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. |
|
![]() |
![]() |
The Following 2 Users Say Thank You to icu For This Useful Post: |
![]() |
#32 | |
Vintage Member
Join Date: Jun 2007
Posts: 184
Thanks: 198
Thanked 2,088 Times in 104 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() Quote:
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. |
|
![]() |
![]() |
![]() |
#33 |
Member
Join Date: Oct 2008
Posts: 19
Thanks: 427
Thanked 44 Times in 22 Posts
![]() ![]() ![]() ![]() |
![]() 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. Last edited by 12860491; 04-01-2010 at 05:23 PM.. |
![]() |
![]() |
![]() |
#34 |
no remorse.
Join Date: Nov 2008
Location: relocated to lurkerland.
Posts: 8,986
Thanks: 28,010
Thanked 69,176 Times in 8,194 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() 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. |
![]() |
![]() |
The Following User Says Thank You to hos For This Useful Post: |
![]() |
#35 | |
Vintage Idiot
Join Date: Feb 2012
Location: Dildo Baggins' backyard
Posts: 15,514
Thanks: 171,154
Thanked 181,339 Times in 15,351 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() Quote:
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. Last edited by effCup; 02-19-2012 at 02:59 AM.. Reason: Clarification. |
|
![]() |
![]() |
The Following 2 Users Say Thank You to effCup For This Useful Post: |
![]() |
#36 |
Former Staff
Join Date: Jan 2008
Posts: 2,132
Thanks: 4,787
Thanked 18,275 Times in 1,784 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() 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. ![]() ![]() ![]() I can offer to maintain CSV .SA.
__________________
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. |
![]() |
![]() |
The Following 5 Users Say Thank You to icu For This Useful Post: |
![]() |
#37 |
Former Staff
Join Date: Jan 2008
Posts: 2,132
Thanks: 4,787
Thanked 18,275 Times in 1,784 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() An example for female + male Ids in one ID sheet
![]() .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
__________________
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. |
![]() |
![]() |
The Following 5 Users Say Thank You to icu For This Useful Post: |
![]() |
#38 | |
Veteran Member
Join Date: Jan 2007
Location: Treasure Island
Posts: 1,257
Thanks: 624
Thanked 10,309 Times in 1,094 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() Quote:
![]() 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. |
|
![]() |
![]() |
![]() |
#39 |
Former Staff
Join Date: Jan 2008
Posts: 2,132
Thanks: 4,787
Thanked 18,275 Times in 1,784 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() 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 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
__________________
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. |
![]() |
![]() |
The Following 5 Users Say Thank You to icu For This Useful Post: |
![]() |
#40 |
Former Staff
Join Date: Jan 2008
Posts: 2,132
Thanks: 4,787
Thanked 18,275 Times in 1,784 Posts
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() 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, , , ...
__________________
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. . To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts. |
![]() |
![]() |
The Following 4 Users Say Thank You to icu For This Useful Post: |
![]() |
Thread Tools | |
Display Modes | |
|
|