I am very new to FM so any help appreciated. I have looked for the
answer around but cannot find anything...

The help in the trial gives some info about relative links, variables
and embedding - but I'm not finding it that easy to grasp how to tie
it all together and start

I have a directory of people each with a photo.
The photos have the file names "firstname lastname.jpeg"

Within my FM project I have the "firstname" and "lastname" fields but
am a bit stuck at how I can get the photos in the profiles of the 2000
people on my database!

If anyone can help I would be very grateful. I'm on a Mac and I think
that a lot of the object stuff is just for windows... I am sooo
completely new to this and am just trying the free trial.

Please help I would love to start making more progress with this
software.

Thanks

On Mar 25, 7:18 pm, m... (AT) londonstudent (DOT) co.uk wrote:
If you have all the pictures in a folder or in several folders, it's a
snap to get them in.

Along with the name fields you have, you will need a Container field
for the picture and a field to import the file name...

-fields you have:
firstname
lastname
-Fields you need:
picture
filename
editfilename

Then, go to File -> Import Records -> Folder...
- Click the Specify button
- Browse to the folder that contains the pictures
- If there are subfolders, select the checkbox "Include all enclosed
folders"
- FileType = Picture and movie files
- If you do not want to inflate your database with the actual
pictures, you can just reference them by checking the "Import only a
reference..."

You should see 4 source fields you will match up like:

Image -> picture
File Name -> filename
File Path -
Image Thumbnail -

You do not have to use all 4. If you want to, create fields for the
others.
Click import.

NOW - the name issues... pulling apart names can be Very Ugly and a
total Pain In The Rear!!! You never know how the name was input,
where spaces should be, etc... is a name always 2 words? What about
Mary Lou Smith? What if a middle initial was thrown in and may have
punctuation?

If your files are as you say = First Last.xxxx, (I assume your on a
Mac with a 4 character extension) then you set up (or change) your
existing fields to Calculation fields (text result). The calculations
you need are:

1) For editfilename:
Middle(File Name; 1; Length(File Name) - 5)

This strips off the 5 characters .jpeg

2) For firstname:
Leftwords(filename;1)

This strips out the First word (see the problem if the person has a 2
name first name?)

3) For lastname:
Rightwords(filename;1)

This strips out the Last word (see the problem if the person has a 2
or 3 name last name?)

If you file name is Paul Johnson.jpeg:
filename = Paul Johnson.jpeg
editfilename = Paul Johnson
firstname = Paul
lastname = Johnson

Yup, I think that should do it... Hope I was not too confusing! You
didn't state if you were on a Mac or PC, but the menus should be the
same. Remember, the name issue is a sticky one, just post back with
any other questions! Good Luck!

<matt (AT) londonstudent (DOT) co.uk> schreef in bericht
news:1174875522.350384.168510 (AT) l75g2000hse (DOT) googlegroups.com...
In your file you have two fields:
FirstName
LastName

Put all the pics in one folder. Say it is C:\MyPics
They are named: firstname lastname.jpeg
This will go wrong when two people have identical names, but here goes.
create a calculation, result as container <"image:/C:/MyPics/" & Firstname &
" " & LastName & ".jpeg">
See that all the \ are replaced by /
Put the container on your layout and you will see the pic.

Keep well, Ursus