Movie Data Base

[youngwombat]

I am new to this Filemaker

What I am trying to do is match up moies names and sort out who has what

One this is that file size is same for 90%

Where it get's tricky for me at least is that I put my name like this

The Fog (2053) How I put them

The Fog (2053) Mary Jones & Harry Fonder Mate number 1

Fog The 2053

To give you an idea I have created a File and put list from Ecell to each person

Fields are

Person 1 Person 2 Person 3

File Size 1 File Size 2 File Size 3

File Name 1 File Name 2 File Name 3

I am gettng frustrated as to the best way to go

Have 3 Find buttons for each person or just one and 3 page layouts for each person

Need you help

I am really looking to some how do a x to a box that then can be tracked

This is to allow me to in my dream list at least is When all done I end up with the abbility to

Look at person 1 list and it show me what is needed from person 2 and 3

Then do the same in reverse for others

I have tried to add file here but it gives me

Error You aren't permitted to upload this kind of file

Tried playing with advanced basic but will not let me upload file about 200 KB

rar file

[bcooney]

I don't understand the data that you're trying to store, and so I can't help yet with how you should structure this. However, "Person 1 Person 2 Person 3" is an indication that you should have a table of People, and that each person should have a record. Perhaps a table of Movies, and a related table of Actors?

Describe what you need, perhaps a sample report, and we'll go from there.

[youngwombat]

Thanks for your reply

3 people have movies on a drive of thier own with the following name and file size parametters

Person 1 got the move below somewhere else so different file size and this may apply to others on some movies not many

Have tried to talk them into a maming structure but each to his own

Person 1 even has movies (Little Red Fox, The 1999) = Can it be put ot left so end up with , The Little Red Fox (1999)

80% have same file size and name

Person 1 names them like this

100 Feet (2008) Famke Janssen.avi File size 733913088 **** Note different size

Perons 2

The Little Red Fox (1999)

10,000 BC----2008.avi File Size 734074880

Perons 3

The Little Red Fox (1999)

10,000 BC (2008) File Size 734074880

I created database with

3 text fields (Movie Name)

3 number fields (FiIe Size)

Is this correct or do I create 3 files the fourth been master and do a relationship ( Us newbies do complicate things) so thinkiing toe one file OK

WHat I did is used a directory list creator and put list to excell so I got colum for file size and one for name

I now have 3 lists one from each person

I am sticking to the one file this is best way to go....

I then imported these to the filemaker file so now have template with 6 fields accross screen

How do get list for each person nissing a movie from other Person or Person's

Can not get file to Attach to post

Why

Movie Database.fp7You aren't permitted to upload this kind of file

[youngwombat]

After doing some more reading I have come up with

Added more fields and wonder if heading the correct direction

1 field each called Person Mark X (Text Field)

1 Field each called Person Global (Global Field)

Found this script at Filemaker at this link to show you where I got it

I am stuck at how to make it look at 6 fields of data 3 of file size then what is left 3 of names Files for movie if or file size not matching

Or I am thinking one field has to look at 2 others so 1 has to look 2 3 then 2 look at 1 3 then 3 at 2 1

Or am I way off in my thoughts

Back to more reading ..........

These are the fields I created

Ron Movie NameTextIndexed

Phillip Movie NameText

Norm Movie NameTextIndexed

Norm Movie File SizeNumberIndexed

Ron Movie File SizeNumberIndexed

Phillip Movie File SizeNumberIndexed

Ron Mark XText

Norm Mark XText

Phillip Mark XText

Norm GlobalTextGlobal

Ron GlobalTextGlobal

Phillip GlobalTextGlobal

http://help.filemaker.com/app/answers/detail/a_id/3441/kw/count%20text%20fields/related/1

Show All Records

Sort Records [Restore, No Dialog] Sort by Client ID in Ascending order

Go to Record/Request/Page [First]

Replace Field Contents [No dialog, 'Mark', " "]

Loop

Set Field['Global','ClientID']

Go to Record/Request/Page [Next, Exit after last]

If ['Global = ClientID']

Set Field ['Mark', '"X"']

Else

Set Field ['Global','ClientID']

End If

End Loop

Perform Find [Restore]

Again tried to attatch file no luck

[youngwombat]

Thank to Moderator for help with attatchment

He said you zip the file I tried rar and FP7 would not load

Now loaded thank you

File at stage of

Fields created

Started a tag x script but not working still reading up on it

any help most appreciated

Once again thank you to moderator for quick reply

Movies Data Base 20011.zip

[efen]

I'm not sure what you actually want to do here. Does the attached help?

The file has conditional formatting to show a person's films but you don't list what version you are using...

Our Movies 2011_1.zip

[youngwombat]

I'm not sure what you actually want to do here. Does the attached help?

The file has conditional formatting to show a person's films but you don't list what version you are using...

VERSION 11 PRO

EFAN

Thanks for reply I did have that in Excel

Yes is shows who has each movie

What we have as stated above it 3 people 3 drives

We have each collected movies

Now person 1 has say 3,000

Person 2 2,167

Person 3 has 2045

What I am trying to do is show by mark x then I think is the way then omit mark X

This now shows movies Person 2 need to get from person 1

However once this is done there is 8 movies that person 2 has to give to person 1

As I am not good at the terms in filemaker I am doing my best

In short a layout script to show each person which movie

A They do not have and who has it

I just then send list to person 1 (Can I grab these movies from you please)

B Or a layout saying

Person 1 these are the movies you do not have from Peron 1 (Layout 1) Person 2 (Layout 2)and this is for each person till we end up 3 drives that have all the movies on them

As each person in the past named them their own way and saved them in thier own way otherwise I sit there and slowly x mark down page to show matches

You have done it to show what each person has

How do I show reverse and what each person needs to get from each other

Hope this makes it clear what I am trying to do

After more reading I think this is what it is called

OMIT MATCHING

OMIT on file size been equal for the 3 people

IF not too hard also

OMIT on name been simaller for the 3

Person 1 names them like this

10,000 BC (2008) Famke Janssen.avi File size 733913088

**** Note different size

Perons 2

The Little Red Fox (1999)

10,000 BC----2008.avi File Size 734074880

Perons 3

The Little Red Fox (1999)

10,000 BC (2008) File Size 734074880

[efen]

Where's the Excel file? There is only a text document in your attachment.

[youngwombat]

Apologies my mistake grabbed wrong file

Here is Excel file with the 3 sheet in it

Excel Demo Sheet 15-06-2011.zip

[youngwombat]

I found this script that I can not get my head around to match 3 fields if it can

Show All Records

Sort [Our Movies 2011::Ron Movie File Size, ascending, no dialog]

Go to Record [First]

Set Variable [$Value, Our Movies 2011::Ron Movie File Size]

Omit Record

Loop

..If [ Our Movies 2011::Ron Movie File Size = $Value ]

....Go to Record/Request [Next, Exit After Last]

..Else

....Set Variable [$Value, Our Movies 2011::Ron Movie File Size]

....Omit Record

..EndIf

..Exit Loop If [Our Movies 2011::Ron Movie File Size <= $value and Get ( RecordNumber ) = Get ( FoundCount )]

End Loop

I understand it will find duplicates in say Ron if I set it up

But HOW do I make it work so it finds the movie name in

RON NORM PHILLIP then X mark then omit them

This way I end up with the list of movies that each person is to share with others

Thus ending up with the 3 drives with matching movies

If by this being done I end up with say 200 movies that did not match because of unique names I maually put x mark and do another sort

By now end up with moveis that have to be shared

Once this done when script is run should end up all omited

So after this is acomplished I can track log additional movies added

[youngwombat]

I just had a thought

I am trying to omit as I see it a field (not RECORD)

As I look at my database I see that record 1 has

RON NORM PHILLIP

10,000 BC Movie (2008) Steven Strait.avi 10 Items or Less ------2006.avi 10 Items or Less (2006).avi

Record 2

100 Feet (2008) Famke Janssen.avi 10,000 BC (2008).avi 10,000 BC (2008).avi

Note that NORM and Phillip have 10,000 BC (2008).avi so it end up in record 2 of database

SO how do I omit fields not records if not how do remove duplicates

Has my limited knowlage of getting flilmaker to do what I want have me going about it the wrong way

Back to the book and video a friend lent me

So much to learn fast

[youngwombat]

Found this in an excel forum but no idea how to put to use

Only on the learning curve

They posted the following ..........................

Let me give a suggestion for those who want to find duplicates within the combination of columns!

Create a sort of “Hash column” with the “=CONCATENATE()” function and apply the conditional formatting to it.

For instance, if you have a spreadsheet with 20 columns and you want to find the rows with the same information in, lets say, columns A, K and X.

Go into the next column available (21st) in the first line and put the function “=CONCATENATE(A1,K1,X1)”. Drag it down and excel will create the same formula for all the other rows.

Apply the formatting and voilà! Duplicated rows about those columns!

Beyond me how to do this but is what I am trying to do

SHow duplicates

Omit duplicates

Print save list of moveies that each person does not have

[youngwombat]

After reading up on find duplicate and thinking a lot I changed the concept of database

I hope to have made it less complicated

What I did was create a script to find dulicates

It does this but does not mark original first record so that idea no good and does not give me counts for records

I then found that Match Count will give me a count of each records based on file size

I found a script that will give me exactly what I want but do not know how to make it work

If I understand the script it will match count and show records like so

File Size Movie Name Total Owner

100 egg 3 Harry

100 egg 3 Fred

100 egg 3 Bill

25 hen 2 Harry

25 hen 2 Fred

444 mouse 1 Bill

My thoughts are then do a sort omit

Omit the total's 3 because we all have the movie

Have to figure how to make it (If Total 3's have owner Harry Fred Bill OMIT)

Then do omit for 2's so I can give movie to person that does not have it

Then the 1' are then given to the 2 that do not have movie

Find attatched file

Matching Records(Calculation, Number result=Count(MyFileMatch::TextField)

(Found this script have to change field name to suit attatched file ??)

This calculation shows the total number of records having each value in the match field

This is exactly what I am after how to do it is antoher matter

Attatched File has a find duplicate script I found that find's dulicates OK but does not show count of first second and third matching record as count of 3 for Harry Bill and Fred

MOVIES FindDups v 1.0.zip