agraham999

Wow...thanks so much...that was perfect. I'm in the process of consolidating all the data from multiple sources...distributors, the SAP database, etc... I was working in the SAP system here and was shocked at how painful it was compared to FMP...but I've been out of FM so long now I'm still getting my brain back into writing calcs...hopefully I can move us over to FMP12 and out of SAP as some point. Thanks again!

That worked great...however...any thought as to getting the city out since some have one word and some have two? BTW...I'm enjoying being back in FMP...and 12 is fantastic.

Yes that "-" dash is always there and yes the State is always 2 characters at the end. Thanks...I'll try this and let you know how it turns out.

Well it's been years since I touched Filemaker, as it just never came up, but now I'm working in it again and I am finding myself slowly getting back in. I have a problem with parsing data out of a field and I hope someone can help me out, as it may be a simple calculation...or it may not be. Anyway...I've got a field from a distributor that I believe is using SAP and they export this field in a garbage in/out format which comes into Filemaker as: GROCERYSTORENAME # 6345 - LOS ANGELES, CA sometimes it doesn't have the store number: GROCERY STORE NAME - BOSTON, MA What I want to do is extract the store name, city, and state...and of course I've got some fun characters occasionally in there like the pound and the dash. Can anyone help me in getting my brain around this stuff again?

Um...did I miss something in the documentation. I've got the server and web publisher running and configured...and I can go to the Instant Web Publishing page...but on Macs and Win I get a Javascript error 802 whe I try to open a database. Did I miss something? Thanks!

Thanks...I didn't think it would be a problem...but wasnt' sure.

Is there anything that might be a negative by hosting a database solution with FM Server Advanced (7) on a Mac (OS X Panther) to Windows users that would cause trouble or be a problem? I have a client that uses all Win machines...but I'd like to be able to program some Applescript features and for that I need a Mac to serve the database. Thanks!

I'm going to give it a spin, but it is possible I may just do this in XML...it seems this is the way FM is headed. Thanks guys.

I work on PCs and Macs...and I am not interested in an OS debate...but I will say that I did a marathon job where I worked two hard core weeks in OS X running FMP, Entourage, Word, AIM, Excel, iTunes, etc...and I never had the system crash once. In fact, in a year of X, I've had only one kernel panic and that's it. I hear XP doesn't crash often either...I have it but haven't used it yet. I've been lucky so far...I keep archived copies regularly...and not the same copies in case one may have become corrupt. But I hear your pain...it has happened to me a few times in the past.

I'd appreciate if anyone can tell me the simple way to do this... I really just want to pull an image through from the database record to a webpage...and of course I'm using my own designed page not FMPs awful templates. What would be the simple command just to link one image to one specific record? Appreciate the help.

I've been building FMP stuff for 10 years...but I've just begun doing the web-companion stuff. Yesterday we finally turned off my clients Exchange server (woo hoo) and moved the company database over to FMP in Outlook. Since Outlook can view an html page within it...the company rolodex points to the FMP server and hooks to it via Unlimited. Worked flawlessly!!! Chalk one up for FileMaker. My next task is connecting their website to FMP. I want to create some templates that allow the office folks to enter data into their database and it updates the site and they aren't required to know HTML...this would be useful for updating projects and employment information. I want it to look fantastic... Should I use CDML...or XML to do this? If XML...where is a good place to start learning it?

Here...I don't mind sharing: http://homepage.mac.com/agraham999/fmp.html Unfortunately Apple's site compresses the images a little...so you can't see them in their full glory. But you'll get the idea. I've developed new techniques for building expensive looking/high-res UI's with a very small footprint.

I'd live to hear your solution...I'm about to build a scheduler for a project...and I've been giving this same idea some thought...

If you viewed the Ethics question I posted earlier...I heard from the person who I strolled into his database...and he actually thanked me for shutting him down and then asked me some advice for protecting his DB. So all's well that ends well.

One of the two files is still up...the other is closed...hard to figure what is going on...it is possible the person doesn't check the DB every day or hasn't seen my message. I wrestled with this decision for some time...I checked their scripts to locate email addresses...I checked their layouts...I looked for their computer name on ebay in case it was their last name or screen name...I called a company where they purchsed an item to see if I could track them down...I dug through the whole thing to see if I could find any clues...but couldn't put anything conclusive together... So...I left a note and shut the door behind me. I figured that a person who has the setting to automatically log on to their database is just lazy...and knows their password...also this person had to use a password to set a password. It seemed the best way to be a good citizen. These types of questions are never easy to answer...but I did what I thought was best.