mx4px

Once I've got a jar loaded, is there a way to list its classes, etc. so I know what I can do with it?

Thanks again for all the help - the problem turned out to be a namespace declaration in that top element. For some reason the FMP "msdso_elem.xslt" didn't care about that, but the one I wrote did.

Here y'go...thanks for the help. testXSL.zip

Sorry...I was just posting a sample. The XML document does in fact continue, containing 9799 items (or rather sections). Thought a single example might suffice : But it is properly terminated at the end. Note that this document does import if I use the generic msdso_elem.xsl stylesheet which comes with FMP, so I'm thinking the basic XML is OK. The problem with using that is that it only picks up the "parent" elements (4 fields for each record: classification, marketing_copy, media, and managed_data. I need to get the stuff under those elements.

Given this XML... <?xml version="1.0" encoding="ISO-8859-1"?> AB:123456 AB ALPHA BETA 123456 FUNK FUNKINESS MEDINA FUNKY COLD MEDINA AB 123456 FUNKY COLD MEDINA AB 123456 FUNKY COLD MEDINA WITH 14 SILVER SPARKLY THINGAMAJIGS This is the best Medina you've ever experienced. Really redefines the concept of Medina in all its funkiness. FUNKYCOLD.JPG http://www.example.com/images/FUNKYCOLD.JPG http://www.example.com/images/thumbs/FUNKYCOLD.JPG FUNKYHOT.JPG http://www.example.com/images/FUNKYHOT.JPG http://www.example.com/images/thumbs/FUNKYHOT.JPG User Guide FUNKYGUIDE.PDF http://www.example.com/pdf/FUNKYGUIDE.PDF Quick Specs FUNKYSPECS.PDF http://www.example.com/pdf/FUNKYSPECS.PDF N/A N/A $39.95 29% true N/A N/A 21% N/A N/A $99.95 $89.95 true $69.95 $59.95 $49.95 true $29.95 ZIP:008999 ZIP ZIPPADYDOODAH 0089999 SLIPPERS SLIPPERS FOR YOUR FEET GLASS GLASS SLIPPERS ...is there a reason this XSL won't work? Getting "invalid document structure errors"... <?xml version="1.0" encoding="UTF-8"?> 0

UPDATE! We're now looking for a FULL TIME Junior Developer/Support Specialist. Please fill out the application form if you're interested. This is a full time position. Telecommuting is OK, but the closer you are to southern New Hampshire, the easier some things will be...we do meet on a regular basis. You should have Proven record of providing outstanding (not merely great) customer service. Be prepared to tell us how you became a client's hero. Minimum of 3 years developing FileMaker solutions. Samples we can download would be appreciated. Solid understanding of basic business IT infrastructure (networking, Active Directory, etc.). Note that we love Macs, but 99.9% of our client systems are Windows-based, and some of your support duties will involve troubleshooting in this area rather than in FMP. FileMaker Certification preferred. If you don't have it, show that you have been working toward it (yes, there may be a test). Familiarity with PHP, HTML, CSS, Javascript, Ajax a very strong plus. Also helpful: Strong ability to adapt to new systems, other development styles, and "moving target" priorities. Tendencies toward OCD. Only partially joking...life balance is important, but if you can sleep easily while a client has a problem, you might not be right for this position. Experience with clients in the retail sector, and an understanding of why that's different from experience with almost anything else. Experience with non-profits is great, but not particularly useful here. Salary commensurate with experience, benefits available, etc...you know that part. Please don't call or email...we're hiring because we're already very busy!! We'll definitely contact you if what you say below suggests we have more to talk about! Once again, the application is here.

Reliable Softworks, FBA members led by FM 8/9/10 Certified Developer Andy Frazier and MBA Mike Baron, is getting a little nuts. We're going to need some help. This will start off on a contract basis, part time. It will eventually grow to a full time position (maybe more than one...). Naturally telecommuting is great (I do it every day), but the closer you are to New Hampshire, well, the easier some things will be!! FM Certification definitely preferred. PHP, CSS, & JavaScript very helpful. Experience in for-profit area, particularly retail, very helpful. XML experience a plus. To apply, please complete this application form. PLEASE don't call or email about this (did I mention we're getting a little nuts?) We will contact you if it seems we have things to talk about!!

I'm thinking that it's not grabbing FileMaker.php properly, so it doesn't know what a new "FileMaker()" is. How are the permissions on FileMaker.php? Does "Everyone" have at least "read" access? This has bitten me before when hosting on OSX - if you paste the FileMaker.php file into your web directory, it won't have the right permissions by default; you have to set them. You'll want to do that on the FileMaker directory, too.

Mission “Provide the best Customer experience” Fundamental Principles: • Honesty • Respect for other’s property • Respect for people Basic Function: Manage and administer the Company’s technology equipment and related software by interfacing with users and suppliers, performing special project tasks to improve systems and processes in various segments of the company, and being totally responsible for data, network, internet, phones, wireless communication, and website. In addition, this Associate is responsible for procedural documentation, user support, and report customization for FileMaker Pro – based POS system. Skills/Experience required: • “Positive attitude”, listening skills, patience, motivation, and organizational skills • Ability to prioritize and complete multiple tasks on schedule • Customer orientation with “solutions” and “new ideas” • MINIMUM 2 YEARS EXPERIENCE IN CORPORATE ENVIRONMENT FOR NETWORK ADMINISTRATION • Good working knowledge of FileMaker Pro 9 (client & server) software a strong plus • Experience includes proven track record to “get projects done” • Pre employment screening process required (drug screen, reference check, and criminal background check) Goals and objectives: • Evaluate network and software for performance and relevance to needs • Support approximately 50 users in 5 locations on an established network as a “one person department” with limited support from “key associates” in remote locations • Must be available for “data/network/phone issues” which cause business interruption during store operating hours which are 7 days a week. • Perform adds/changes/deletes for users of pc’s, email, point of sale software, and IP based phone system • Become the “go-to expert” on all technology systems: PC’s, printers, servers, network equipment, IP phones, firewalls, and security cameras • Participate as a member of the Company Management Team in regular staff meetings • Maintain a documented list of outstanding items in progress • Purchase, configure, and maintain IT equipment • Establish system documentation, mission critical backup plan, and contacts list with procedures • Develop and maintain internal use “website” for company information • Maintain Company website for marketing and customers • Ability to write specifications for software enhancements to our point of sale system • Documentation of our “company processes”, identifying weak elements, and offering detailed cost effective solutions • Perform whatever tasks are required to meet company objectives Please Contact Mike Baron: mike@baronsmajorbrands.com or 603-520-0469

Sorry, Mr. Vodka. Just looked at it and it said it was updated in July of '06. Didn't mean to steal your thunder!

Name & Parameters: [color:red][big] MagicDates ( range ) [/big] Description: This one gives you FM-Find Friendly date ranges based on User-Friendly input. Works great with the "range" specified as a script parameter. The ranges you can use are: Today Yesterday Tomorrow ThisWeek LastWeek NextWeek ThisMonth LastMonth NextMonth ThisYTD LastYTD NextYTD ThisYear LastYear NextYear ThisQuarter LastQuarter NextQuarter So, say you had a script that put you in Find mode. You could set up a series of buttons on a "Find" layout, each of which ran a script called "SetDate," with the date range options as script parameters. The script could look like this: SetField: DateField;MagicDates(Get(ScriptParameter)) Perform Find Special thanks to Excelisys and the Business Tracker for the brilliantly simple way of calculating quarters!! Sample Input: MagicDates("LastYTD") Results: 1/1/2006...8/17/2006 Recursive: no Formula: Case( range="Today";Get(CurrentDate); range="Yesterday";Get(CurrentDate)-1; range="Tomorrow";Get(CurrentDate)+1; range="ThisWeek";Get(CurrentDate)-DayOfWeek(Get(CurrentDate))+1&"..."&Get(CurrentDate)+(7-DayOfWeek(Get(CurrentDate))); range="LastWeek";Get(CurrentDate)-DayOfWeek(Get(CurrentDate))-6&"..."&Get(CurrentDate)-DayOfWeek(Get(CurrentDate)); range="NextWeek";Let(sunday=Get(CurrentDate)+(8-DayOfWeek(Get(CurrentDate)));sunday&"..."&sunday+7); range="ThisMonth";Let(firstday=Date(Month(Get(CurrentDate));1;Year(Get(CurrentDate)));firstday&"..."&Date(Month(firstday)+1;0;Year(firstday))); range="LastMonth";Let(lastday=Date(Month(Get(CurrentDate));0;Year(Get(CurrentDate))); Date(Month(lastday);1;Year(lastday))&"..."&lastday); range="NextMonth";Let(firstday=Date(Month(Get(CurrentDate))+1;0;Year(Get(CurrentDate)))+1;firstday&"..."&Date(Month(firstday)+1;0;Year(firstday))); range="ThisYTD";Date(1;1;Year(Get(CurrentDate)))&"..."&Get(CurrentDate); range="LastYTD";Date(1;1;Year(Get(CurrentDate))-1)&"..."&Date(Month(Get(CurrentDate));Day(Get(CurrentDate));Year(Get(CurrentDate))-1); range="NextYTD";Date(1;1;Year(Get(CurrentDate))+1)&"..."& Date(Month(Get(CurrentDate));Day(Get(CurrentDate));Year(Get(CurrentDate))+1); range="ThisYear";Date(1;1;Year(Get(CurrentDate)))&"..."&Date(12;31;Year(Get(CurrentDate))); range="LastYear";Date(1;1;Year(Get(CurrentDate))-1)&"..."&Date(12;31;Year(Get(CurrentDate))-1); range="NextYear";Date(1;1;Year(Get(CurrentDate))+1)&"..."&Date(12;31;Year(Get(CurrentDate))+1); range="ThisQuarter";Let ( xMod = Case ( Mod ( Month ( Get ( CurrentDate ) ) ; 3 ) = 0 ; 3; Mod ( Month ( Get ( CurrentDate ) ) ; 3 ) ) ; Date ( Month ( Get ( CurrentDate ) ) - xMod + 1; 1 ; Year ( Get ( CurrentDate ) ) ) &"..."&Get(CurrentDate)); range="LastQuarter";Let ( xMod = Case ( Mod ( Month ( Get ( CurrentDate ) ) ; 3 ) = 0 ; 3; Mod ( Month ( Get ( CurrentDate ) ) ; 3 ) ) ;Date ( Month ( Get ( CurrentDate ) ) - xMod - 2 ; 1 ; Year ( Get ( CurrentDate ) ) )&"..."&Date ( Month ( Get ( CurrentDate ) ) - xMod + 1 ; 1 ; Year ( Get ( CurrentDate ) ) ) - 1 ); range="NextQuarter";Let ( xMod = Case ( Mod ( Month ( Get ( CurrentDate ) ) ; 3 ) = 0 ; 3; Mod ( Month ( Get ( CurrentDate ) ) ; 3 ) ) ;Date ( Month ( Get ( CurrentDate ) ) - xMod + 4 ; 1 ; Year ( Get ( CurrentDate ) ) )& "..."&Date ( Month ( Get ( CurrentDate ) ) - xMod + 7 ; 1 ; Year ( Get ( CurrentDate ) ) ) - 1 ) ) Required Functions: Author(s): mx4px Date: 08/17/07 Credits: Andy Frazier, Excelisys Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

Naturally, Mr. Smith - there is nothing new under the sun!! Also, as I mentioned, the "technique" wasn't mine...it was FMI's; I just modified it slightly to make it available as a CF in case someone needed it that way. The function you referenced (http://www.briandunning.com/cf/22) is indeed something I hadn't seen - but then again it was posted a month after I posted this. Plus it requires two other functions - this one's self-contained. Like all things free, though - use it if you like, don't if you don't!! 'Nuff said.

Genx, the cf you referenced from Brian's site accomplishes something different...that one will take 123.45 and give you "US$123.45." Mine will take 123.45 and give you "one hundred twenty three dollars and forty-five cents". The point of mine is to give you the amount in WORDS, like you'd see in the text area of a check.

One small correction on that..."certification is good for one year". That's not quite right - according to the certification FAQ on FMI's website: "There is no expiration date to the certification title you receive. You may, however, be certified on a technology that is outdated if FileMaker, Inc. releases a new technology version and its associated exam. Keeping your certification current is highly recommended. FileMaker, at its discretion, may offer certification for one version back."

Assuming that there are no TCP port restrictions, and the identifier & passcode are properly set up, can anyone think of any condition which would result in the following error message in trying to connect to FMSA from the web config console? "Access to the specified FileMaker Server is restricted. Verify that this Publishing Engine is enabled in the FileMaker Server Administration Tool or specify an alternate server." I've set these things up many times & never had this message. I'm stumped. I'm getting this when trying to set up WPE on IIS and on OS X/Apache (2 potential test servers in the same subnet...note that FMP has no trouble connecting to either of them).

Just a smidge off-topic, but if you really want to have some fun with FM and VBScript, grab this: Script Kit Enjoy! There are about 2200 scripts that do everything from create, populate, and print Word docs to adding/deleting users from an Active Directory. I got these from the MS Script Repository, imported them from Access into FMP (via ODBC), and wrote up a little something to run them.

Name & Parameters: [color:red][big] AmountText ( amount ) [/big] Description: Not quite mine, just adapted from a formula posted on the FMP website. Returns the check-style text line given a dollar amount in a number field referenced by the "amount" parameter. As posted, only works with US Currency, but I'm sure it can be modified for anything. Sample Input: 123.45 Results: One Hundred Twenty Three Dollars and Forty Five cents Recursive: no Formula: Choose(Int(Mod(amount;10^12) / 10^11); ""; "One Hundred "; "Two Hundred "; "Three Hundred "; "Four Hundred "; "Five Hundred "; "Six Hundred "; "Seven Hundred "; "Eight Hundred "; "Nine Hundred ") & If(Int(Mod(amount;10^11) / 10^10) = 1; Choose(Int(Mod(amount;10^10) / 10^9); "Ten "; "Eleven "; "Twelve "; "Thirteen "; "Fourteen "; "Fifteen "; "Sixteen "; "Seventeen "; "Eighteen "; "Nineteen "); Choose(Int(Mod(amount;10^11) / 10^10); ""; ""; "Twenty "; "Thirty "; "Forty "; "Fifty "; "Sixty "; "Seventy "; "Eighty "; "Ninety ") & Choose(Int(Mod(amount;10^10) / 10^9); ""; "One "; "Two "; "Three "; "Four "; "Five "; "Six "; "Seven "; "Eight "; "Nine ")) & Case(Int(Mod(amount;10^12)/10^9) and Int(Mod(amount;10^9) / 10^3); "Billion, "; Int(Mod(amount;10^12)/10^9);"Billion ";"") & Choose(Int(Mod(amount;10^9) / 10^8); ""; "One Hundred "; "Two Hundred "; "Three Hundred "; "Four Hundred "; "Five Hundred "; "Six Hundred "; "Seven Hundred "; "Eight Hundred "; "Nine Hundred ") & If(Int(Mod(amount;10^8) / 10^7) = 1; Choose(Int(Mod(amount;10^7) / 10^6); "Ten "; "Eleven "; "Twelve "; "Thirteen "; "Fourteen "; "Fifteen "; "Sixteen "; "Seventeen "; "Eighteen "; "Nineteen "); Choose(Int(Mod(amount;10^8) / 10^7); ""; ""; "Twenty "; "Thirty "; "Forty "; "Fifty "; "Sixty "; "Seventy "; "Eighty "; "Ninety ") & Choose(Int(Mod(amount;10^7) / 10^6); ""; "One "; "Two "; "Three "; "Four "; "Five "; "Six "; "Seven "; "Eight "; "Nine ")) & Case(Int(Mod(amount;10^9)/10^6) and Int(Mod(amount;10^6) / 10^3); "Million, "; Int(Mod(amount;10^9)/10^6);"Million ";"") & Choose(Int(Mod(amount;10^6) / 10^5); ""; "One Hundred "; "Two Hundred "; "Three Hundred "; "Four Hundred "; "Five Hundred "; "Six Hundred "; "Seven Hundred "; "Eight Hundred "; "Nine Hundred ") & If(Int(Mod(amount;10^5) / 10^4) = 1; Choose(Int(Mod(amount;10^4) / 10^3); "Ten "; "Eleven "; "Twelve "; "Thirteen "; "Fourteen "; "Fifteen "; "Sixteen "; "Seventeen "; "Eighteen "; "Nineteen "); Choose(Int(Mod(amount;10^5) / 10^4); ""; ""; "Twenty "; "Thirty "; "Forty "; "Fifty "; "Sixty "; "Seventy "; "Eighty "; "Ninety ") & Choose(Int(Mod(amount;10^4) / 10^3); ""; "One "; "Two "; "Three "; "Four "; "Five "; "Six "; "Seven "; "Eight "; "Nine ")) & Case(Int(Mod(amount;10^6)/10^3) and Int(Mod(amount;10^3) / 10^0); "Thousand, "; Int(Mod(amount;10^6)/10^3);"Thousand ";"") & Choose(Int(Mod(amount;10^3) / 100); ""; "One Hundred "; "Two Hundred "; "Three Hundred "; "Four Hundred "; "Five Hundred "; "Six Hundred "; "Seven Hundred "; "Eight Hundred "; "Nine Hundred ") & If(Int(Mod(amount;100) / 10) = 1; Choose(Int(Mod(amount;10)); "Ten "; "Eleven "; "Twelve "; "Thirteen "; "Fourteen "; "Fifteen "; "Sixteen "; "Seventeen "; "Eighteen "; "Nineteen "); Choose(Int(Mod(amount;100) / 10); ""; ""; "Twenty "; "Thirty "; "Forty "; "Fifty "; "Sixty "; "Seventy "; "Eighty "; "Ninety ") & Choose(Int(Mod(amount;10)); ""; "One "; "Two "; "Three "; "Four "; "Five "; "Six "; "Seven "; "Eight "; "Nine ")) & Case(Int(amount) > 1; "Dollars"; Int(amount) = 1; "Dollar"; "") & If(Mod(amount; 1) and Int(amount);" and ";"") & If(Mod(Int(amount*10); 10) = 1; Choose(Mod(Int(amount*100); 10); "Ten "; "Eleven "; "Twelve "; "Thirteen "; "Fourteen "; "Fifteen "; "Sixteen "; "Seventeen "; "Eighteen "; "Nineteen "); Choose(Mod(Int(amount*10); 10); ""; ""; "Twenty "; "Thirty "; "Forty "; "Fifty "; "Sixty "; "Seventy "; "Eighty "; "Ninety ") & Choose(Mod(Int(amount*100); 10); ""; "One "; "Two "; "Three "; "Four "; "Five "; "Six "; "Seven "; "Eight "; "Nine ")) & Case(Mod(amount; 1) > .01; "cents"; Mod(amount; 1) = .01; "cent";"") Required Functions: Author(s) mx4px Date: 06/09/06 Credits: www.filemaker.com & Andy Frazier Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify. AmountTextSample.zip

Sure, I do that all the time.