FileMaker Pro Developer: Portland, OR

[Jeff Hough-2]

Pre1.com LLC, the developer of SmartPublisher, an integrated publishing
system for newspapers and magazines, has an immediate opening for an
intermediate-level FileMaker developer to join our development team (not
a contract assignment). A desired candidate should be passionate about
delivering top-notch FileMaker based database solutions, interested in
working in a team environment, and willing to push their limits to learn.

Pre1 is one of thirty FileMaker Business Alliance Platinum Members with
a team of three FileMaker 8 Certified developers. We offer a competitive
salary with vacation plan and benefits. Compensation will be based on
experience.

Strong candidates must have the following:
- Four-year college degree or equivalent work experience.
- Two years or more of experience developing databases in FileMaker
version 7 or higher.
- Comfortable developing and deploying large multi-user solutions.
- Excellent troubleshooting and diagnostic skills.
- Experience working in a professional atmosphere.
- Self-motivated team player.
- Good verbal and writtnen communication skills.
- Experience working on both Macintosh and Windows platforms.
- Familiarity with SQL and database modeling concepts.
- Strong attention to detail.

Other desired experience/background:
- FileMaker 7 or 8 Certification.
- Vertical market or shrink-wrap solution design experience a plus.
- Experience with sales CRM, accounting, and/or business dynamics.
- Experience designing dynamic publishing solutions using FileMaker Pro
and Xtags.
- Strong skills in User Interface Design.
- Experience with FileMaker plug-ins.
- Experience with QuarkXpress/InDesign.

To apply, please e-mail your resume/work history and compensation
expectations to [hidden email]. Please include the job title in the subject
line. Candidates will be asked to provide or demonstrate samples of
their work. Professional references are required.

--

Jeff Hough * 503.288.7500 * www.pre1.com
Director of Development
Certified FileMaker 7/8 Developer

[Bill Wallace-2]

Our school has a filemaker database that that teachers use for lunch  
count at our school. I have an account for teachers that opens  
automatically when the teachers open the database. I have the  
privileges set so the teachers cannot delete files. Yet when I log on  
using the teachers account, you can delete files. I would appreciate  
any suggestions as to why that would happen.

Thanks,

Bill Wallace
Librarian
Manzano Day School
Albuquerque, NM

[hidden email]

[Chuck_LBLP]

Are your records deleted by a script? Check if it is running under full privileges regardless of account privileges.

Chuck

FileMaker Pro Discussions <[hidden email]> writes:

>Our school has a filemaker database that that teachers use for lunch  
>count at our school. I have an account for teachers that opens  
>automatically when the teachers open the database. I have the  
>privileges set so the teachers cannot delete files. Yet when I log on  
>using the teachers account, you can delete files. I would appreciate  
>any suggestions as to why that would happen.
>
>Thanks,
>
>Bill Wallace
>Librarian
>Manzano Day School
>Albuquerque, NM
>
>[hidden email]

[Flora, Charlene]

Bill,

Would you mind indicating what version of Filemaker you are using and
operating system?

Thanks

Charlene

-----Original Message-----
From: FileMaker Pro Discussions [mailto:[hidden email]]
On Behalf Of Bill Wallace
Sent: Wednesday, December 12, 2007 1:06 PM
To: [hidden email]
Subject: Account Privileges

Our school has a filemaker database that that teachers use for lunch  
count at our school. I have an account for teachers that opens  
automatically when the teachers open the database. I have the  
privileges set so the teachers cannot delete files. Yet when I log on  
using the teachers account, you can delete files. I would appreciate  
any suggestions as to why that would happen.

Thanks,

Bill Wallace
Librarian
Manzano Day School
Albuquerque, NM

[hidden email]

[Bill Wallace-2]

Sorry about not including the version. I am using filemaker 8.5 on  
Macbook using Leopard.
On Dec 12, 2007, at 12:25 PM, Flora, Charlene wrote:

> Bill,
>
> Would you mind indicating what version of Filemaker you are using and
> operating system?
>
> Thanks
>
> Charlene
>
> -----Original Message-----
> From: FileMaker Pro Discussions [mailto:FMPRO-
> [hidden email]]
> On Behalf Of Bill Wallace
> Sent: Wednesday, December 12, 2007 1:06 PM
> To: [hidden email]
> Subject: Account Privileges
>
> Our school has a filemaker database that that teachers use for lunch
> count at our school. I have an account for teachers that opens
> automatically when the teachers open the database. I have the
> privileges set so the teachers cannot delete files. Yet when I log on
> using the teachers account, you can delete files. I would appreciate
> any suggestions as to why that would happen.
>
> Thanks,
>
> Bill Wallace
> Librarian
> Manzano Day School
> Albuquerque, NM
>
> [hidden email]

[Sue-13]

We are having trouble setting our Filemaker Server (9.0)
to do automatic backups to an external hard drive.

It works fine to save to the drive the server is on,
but when we try to set up a second backup to an
external drive, the Server Admin refuses to
accept as valid any filepath we set up to the
external drive.

We have tried various methods of identifying the
correct filepath through filemaker and other
software, but none are accepted by the Server
admin as valid.

Any idea what we are doing wrong, or is it
not possible to use the Server backup function
to save to an external hard drive?

Thanks,

Sue

[Steve Cassidy]

On 13/12/07 17:55, "Sue" <[hidden email]> wrote:

> Any idea what we are doing wrong, or is it
> not possible to use the Server backup function
> to save to an external hard drive?

It is possible (Mac); I've just got it working for a client.

It seems that permissions are a common problem. The fmsadmin group must have
read access to the whole filepath as well as read/write access to the actual
folder.

Once I'd got that set up -- as specified in either the getting started guide
or the help guide -- everything worked fine.

Steve

[Sue-13]

Thanks, Steve!!

On Dec 13, 2007, at 11:04 AM, Steve Cassidy wrote:

> On 13/12/07 17:55, "Sue" <[hidden email]> wrote:
>
>> Any idea what we are doing wrong, or is it
>> not possible to use the Server backup function
>> to save to an external hard drive?
>
> It is possible (Mac); I've just got it working for a client.
>
> It seems that permissions are a common problem. The fmsadmin group  
> must have
> read access to the whole filepath as well as read/write access to  
> the actual
> folder.
>
> Once I'd got that set up -- as specified in either the getting  
> started guide
> or the help guide -- everything worked fine.
>
> Steve

[Richard S. Russell]

I'm working with a small non-profit outfit. It has 5 Macs, all  
running some flavor of Mac OS 10.4 (Tiger).

Computer A is dedicated to hosting the database files. It's funning  
FMPA 9.0.3. Computers B, C, D, and E are on the desks of the staff  
members and run regular FMP 9.0.3.

On Computer A I ginned up a script (subsequently attached to a  
button) that would export a tab-delimited text file to my desktop. It  
worked fine. I then went to try it on Computer B, logged in as a  
guest. It didn't work fine. I got an error message saying it couldn't  
write the file to the disk. Possible reasons included "disk full",  
"disk locked", and a couple of other false conditions.

I suspect it has something to do with the syntax I used in setting  
the filepath for the exported file in the "Export File" script step.  
The following statements worked OK on Computer A but not Computer B:
   file:../Desktop/Donors.tab
   file:../../Desktop/Donors.tab
This one worked on Computer A but put the output file in the FMP  
application folder:
   file:Donors.tab

What I'm looking for is a generic syntax that will put the output  
file onto the local Desktop of the current user. Any advice?

And, in general, is there anyplace I can read up on filepaths in more  
detail than the FMP documentation provides? As a longtime Mac user, I  
find the subject pretty opaque, tho I understand they're old hat in  
the Windows world.

[Fenton Jones]

On Dec 13, 2007, at 12:31 PM, Richard S. Russell wrote:

> What I'm looking for is a generic syntax that will put the output  
> file onto the local Desktop of the current user.

You're overlooking a newish function (came out in 8 I believe), Get  
(DesktopPath)

"filemac:" & Get (DesktopPath) & "file name.ext"

It will work cross-platform with the addition of a test:

Let ( [
prfx = Case ( Abs ( Get (SystemPlatform)) = 1; "filemac:"; "filewin:" );
DT = Get (DesktopPath)
];

prfx & DT & "file name.ext"
)


Fenton Jones
FileMaker Development
1728 Meade Ave
San Diego, CA 92116
619-692-1529
http://fentonjones.com

[Richard S. Russell]

On 2007 Dec 13, at 15:17, Fenton Jones wrote:

> On Dec 13, 2007, at 12:31 PM, Richard S. Russell wrote:
>
>> What I'm looking for is a generic syntax that will put the output  
>> file onto the local Desktop of the current user.
>
> You're overlooking a newish function (came out in 8 I believe), Get  
> (DesktopPath)
>
> "filemac:" & Get (DesktopPath) & "file name.ext"
>
> It will work cross-platform with the addition of a test:
>
> Let ( [
> prfx = Case ( Abs ( Get (SystemPlatform)) = 1; "filemac:";  
> "filewin:" );
> DT = Get (DesktopPath)
> ];
>
> prfx & DT & "file name.ext"
> )

Wow, talk about a fast, explicit response. This list is great!

Thank you, Fenton!

[Bill Wallace-2]

Some javascript/style in this post has been disabled (why?)

We are in the middle of our annual science fair at school and we have run up against a sorting problem. When I go to run ribbon labels that have the student's name and table number, the sort will not sort all of the table numbers correctly. The number are like a1, a2...a10, a11, a12. The sort will sort all the table number correct by letter, but the following numbers are not sorted numerically. Is a way to sort the numbers so the numbers following the letter are in numerical order.
Thanks,Bill Wallace

Bill Wallace

Librarian

Manzano Day School

Albuquerque, NM  87104

School email - [hidden email]

[David McQueen]

Some javascript/style in this post has been disabled (why?)

Create 2 calculated fields:

Table Letter = Left(TableNumber, 1) - That gets the letter part alone - it is a text calc

Table Number = Subsitute (TableNumber; Table Letter; "") and make that a number calc

Then sort by:

Table Letter

Table Number

I think that will do it.  IF table number will not express as a number you may have to add GetAsNumber function in there.

HTH

Dave McQueen

We are in the middle of our annual science fair at school and we have run up against a sorting problem. When I go to run ribbon labels that have the student's name and table number, the sort will not sort all of the table numbers correctly. The number are like a1, a2...a10, a11, a12. The sort will sort all the table number correct by letter, but the following numbers are not sorted numerically. Is a way to sort the numbers so the numbers following the letter are in numerical order.
Thanks,Bill Wallace

Bill Wallace

Librarian

Manzano Day School

Albuquerque, NM  87104

School email - [hidden email]

-- 

David A. McQueen
LICHEN Software
Barrie, ON, Canada
705-720-9022
705-728-2289
www.lichen-software.com

[Beverly Voth-2]

On 04/22/08 4:37 PM, "Bill Wallace" <[hidden email]> wrote in whole or in
part:

>
> We are in the middle of our annual science fair at school and we have run up
> against a sorting problem. When I go to run ribbon labels that have the
> student's name and table number, the sort will not sort all of the table
> numbers correctly. The number are like a1, a2...a10, a11, a12. The sort will
> sort all the table number correct by letter, but the following numbers are not
> sorted numerically. Is a way to sort the numbers so the numbers following the
> letter are in numerical order.
> Thanks,Bill Wallace


Yes, you need TWO fields, one alphabetic, one numeric. Make both sort.
--
Beverly Voth                       Tier3 Data & Web Services Group, LLC
606-864-0041                            http://www.tier3web.com/xml.htm

               Web Design & Hosting * Apple: ACN & ADC
   Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance
    Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
   Over 14 years experience integrating databases and the internet!

[Ron68]

Some javascript/style in this post has been disabled (why?)

Or instead of entering A1 enter A01, etc, for all single digit numbers

Ron

 

---

From: FileMaker Pro Discussions [mailto:[hidden email]] On Behalf Of Bill Wallace
Sent: Tuesday, April 22, 2008 4:38 PM
To: [hidden email]
Subject: Sorting Numbers

 

 

We are in the middle of our annual science fair at school and we have run up against a sorting problem. When I go to run ribbon labels that have the student's name and table number, the sort will not sort all of the table numbers correctly. The number are like a1, a2...a10, a11, a12. The sort will sort all the table number correct by letter, but the following numbers are not sorted numerically. Is a way to sort the numbers so the numbers following the letter are in numerical order.

 

Thanks,

Bill Wallace

 

Bill Wallace

Librarian

Manzano Day School

Albuquerque, NM  87104

School email - [hidden email]

 

[dwdc]

On Apr 22, 2008, at 2:02 PM, Beverly Voth wrote:

>> We are in the middle of our annual science fair at school and we  
>> have run up
>> against a sorting problem. When I go to run ribbon labels that  
>> have the
>> student's name and table number, the sort will not sort all of the  
>> table
>> numbers correctly. The number are like a1, a2...a10, a11, a12. The  
>> sort will
>> sort all the table number correct by letter, but the following  
>> numbers are not
>> sorted numerically. Is a way to sort the numbers so the numbers  
>> following the
>> letter are in numerical order.
>> Thanks,Bill Wallace
>
>
> Yes, you need TWO fields, one alphabetic, one numeric. Make both sort.

Just for fun. Define one field:

SerialSort - (Calculation, Number Result) =

Let([

a=theSerialAlphaField;
b=Position("abcdefghijklmnopqrstuvwxyz"; Left(a;1); 1; 1);
c=GetAsNumber("1" & Right("00" & b; 2) & Right("000000000" & Middle
(a; 2; 20); 9))
];
c)

This calculation assumes that the first character will always be a  
single alpha character and the remaining of the serial number will be  
digits not equaling or exceed 1000,000,000.

Hope this helps!!!

Don Wieland
D W   D a t a   C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
[hidden email]
Direct Line - [phone]

Integrated data solutions to fit your business needs.

[Beverly Voth-2]

On 04/22/08 5:37 PM, "Don Wieland" <[hidden email]> wrote in whole
or in part:

> On Apr 22, 2008, at 2:02 PM, Beverly Voth wrote:
>
>>> We are in the middle of our annual science fair at school and we
>>> have run up
>>> against a sorting problem. When I go to run ribbon labels that
>>> have the
>>> student's name and table number, the sort will not sort all of the
>>> table
>>> numbers correctly. The number are like a1, a2...a10, a11, a12. The
>>> sort will
>>> sort all the table number correct by letter, but the following
>>> numbers are not
>>> sorted numerically. Is a way to sort the numbers so the numbers
>>> following the
>>> letter are in numerical order.
>>> Thanks,Bill Wallace
>>
>>
>> Yes, you need TWO fields, one alphabetic, one numeric. Make both sort.
>
> Just for fun. Define one field:
>
> SerialSort - (Calculation, Number Result) =
>
> Let([
>
> a=theSerialAlphaField;
> b=Position("abcdefghijklmnopqrstuvwxyz"; Left(a;1); 1; 1);
> c=GetAsNumber("1" & Right("00" & b; 2) & Right("000000000" & Middle
> (a; 2; 20); 9))
> ];
> c)
>
> This calculation assumes that the first character will always be a
> single alpha character and the remaining of the serial number will be
> digits not equaling or exceed 1000,000,000.
>
> Hope this helps!!!

Ah, yep! I just wanted to make sure that everyone knows that "numbers"
inside of "text" do NOT sort numerically. Ergo the two fields, or
"padding-with-zeros" trick that Don so graciously described.

Assumption is that the "alpha" will always be ONE character and the "number"
will always be less than "1000,000,000". Ergo the two fields, in my
approach. Keep 'em separate and don't worry about it, sort by both, of
course. :D
--
Beverly Voth                       Tier3 Data & Web Services Group, LLC
606-864-0041                            http://www.tier3web.com/xml.htm

               Web Design & Hosting * Apple: ACN & ADC
   Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance
    Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
   Over 14 years experience integrating databases and the internet!

[Ron68]

Not to nit pick, but in ASCII, in any given position, a numeric will sort in
front of an alpha character.
The problem is in the positions.
If you can guarantee, for instance, a 3 character field, it is possible,
(and a quick fix in the stated situation) to insert a zero in front of a
single digit to make what is a 3 character text field: the whole field will
then sort correctly.

However, for any general design these should indeed be two separate fields,
handled as described in any of the preceeding messages.

Pedantic, huh?

Ron

Ah, yep! I just wanted to make sure that everyone knows that "numbers"
inside of "text" do NOT sort numerically. Ergo the two fields, or
"padding-with-zeros" trick that Don so graciously described.

Assumption is that the "alpha" will always be ONE character and the "number"
will always be less than "1000,000,000". Ergo the two fields, in my
approach. Keep 'em separate and don't worry about it, sort by both, of
course. :D
--
Beverly Voth                       Tier3 Data & Web Services Group, LLC
606-864-0041                            http://www.tier3web.com/xml.htm

               Web Design & Hosting * Apple: ACN & ADC
   Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance
    Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
   Over 14 years experience integrating databases and the internet!

[Lombardia44]

I knew that the upgrade to fmp7 wasn't painless.

And, in fact, I am experiencing a lot of new things to learn and a whole new
set of techniquest to discover and apply to make the relation work.

I made some progress but I am stuck in what seems a trivial prolem.

I have a QUOTATIONS database with over 25.000 quotations, and I created a
table with over 6500 authors, with names and dates and bios. this one was
previously a separated file and now is a table inside the quotations file.

now... the quotation table has an AUTHOR_ID  and the BIOS table has an
AUTHOR ID.

In the BIOS layout I wanna see a portal where, for a given author, all his
quotations are listed.

But linking the two fields thru a relation doesn't work... and it's an
headache, since all other relations are running smoothly.

What am I missing.

Any help will be utmostly appreciated... and any time you need a
quotations... drop me a line

TIA



MoneyMaker
_____________
Fmp7 on Windows Vista



------------------------------------------------------------
The only real mistake is the one from which we learn nothing.
John Enoch Powell (1912 - 1998)

Failure is the condiment that gives success its flavor.
Truman Capote (1924 - 1985)

It's always helpful to learn from your mistakes because then your mistakes
seem worthwhile.
Garry Marshall (1934 - )

The will to persevere is often the difference between failure and success.
David Sarnoff

When I'm working on a problem, I never think about beauty. I think only how
to solve the problem. But when I have finished, if the solution is not
beautiful, I know it is wrong.
Richard Buckminster Fuller (1895 - 1983)

Success is never final, failure is never fatal, it's courage that counts.
Robert Schuller (1874 - 1965)

Le meilleur remède pour tous les problèmes, c'est la patience.
Platone (428 b.C. - 347 b.C.)

The difference between failure and success is doing a thing nearly right and
doing a thing exactly right.
Edward Simmons

and...
Every solution breeds new problems.
Arthur Bloch (1948 - ), "Murphy's Laws"
------------------------------------------------------------

[Beverly Voth-2]

On 04/22/08 6:24 PM, "Ron Carr" <[hidden email]> wrote in whole or in
part:

> Not to nit pick, but in ASCII, in any given position, a numeric will sort in
> front of an alpha character.
> The problem is in the positions.
> If you can guarantee, for instance, a 3 character field, it is possible,
> (and a quick fix in the stated situation) to insert a zero in front of a
> single digit to make what is a 3 character text field: the whole field will
> then sort correctly.

Right, because it then becomes "ASCII text", right? :)

    a00001
    a00002
    a10000
    a20000

I agree, but for sake of sanity, make your TEXT as TEXT and your NUMBERS as
NUMBERS and sort correctly they will (bad Yoda quote).

Beverly
 

> However, for any general design these should indeed be two separate fields,
> handled as described in any of the preceeding messages.
>
> Pedantic, huh?
>
> Ron
>
> Ah, yep! I just wanted to make sure that everyone knows that "numbers"
> inside of "text" do NOT sort numerically. Ergo the two fields, or
> "padding-with-zeros" trick that Don so graciously described.
>
> Assumption is that the "alpha" will always be ONE character and the "number"
> will always be less than "1000,000,000". Ergo the two fields, in my
> approach. Keep 'em separate and don't worry about it, sort by both, of
> course. :D