2ninerniner2

Howdy, Personally, this is how I look at it: Pro = End User Advanced = Developer Cheers! Lyle

1. FM access away from office: If this is "all" that is required, there is no need to go the "web" route (let alone with Joomla!, LOL!); simply use the Remote Access functionality of FM. They will require separate copies of FM on any laptop they intend to use, or FileMaker GO for any iOS device (iPhone, iPad). Anywhere that they would be able to access the web, they will be able to access FM Remote. Two really quick ways to accomplish this: 1) "Expose" their current location of their FM installation (FM Server or individual computer that is sharing the FM file on their internal network) to the "outside world". Do a search on this forum and others for "port forwarding". 2) Host their current FM file(s) with a third party hosting provider, such as Triple 8 Networks or Point in Space; I have used both but prefer Triple 8 because of their control panel and other hosting capabilities (this is where I have the FM / eFront "mashup" hosted). If your client has no problem with their data being hosted off-site, then this is by far the easiest and most efficient way to get "mobile" ASAP ... shouldn't take more than 15 minutes - set up the account - upload the FM file(s) - you're done! ... start accessing your FM data from anywhere on the web using FM's "Open Remote" or using FM GO 2. ODBC For the Mac, use the ODBC manger/drivers from Actual Technologies, LLC. They are not free, but the price is reasonable. On the PC side, make sure you use the MySQL 3.51 ODBC driver and NOT the current one (5.xx) to connect Joomla! (or any other MySQL source) and also make sure you are setting up a SYSTEM DNS and NOT a User one (both Mac and PC). Additionally, on the Mac, when setting up a ODBC connection, make sure: - use the Actual Open Source Databases driver from the list provided - MySQL as the "type" of database - on the "Connection" page, click "Advanced Options" and enter /Applications/MAMP/tmp/mysql/mysql.sock in the "Socket" field ... IF you are using MAMP as your local web server (if you are using something else, you will have to find (and then enter) the path to the mysql.sock file yourself )

Henry, In what way do you want to integrate Joomla! and FM? Using ODBC, you can easily have 2-way communication between FM and the Joomla! MySQL database. Use the Joomla! tables in your FM solution as you would native FM tables. I have done this in testing with Joomla! and in production with eFront, a similarly-structured PHP/MySQL script. Some more info on how you and your client see this integration will help Lee - the way I read it, being someone who has installed well over 300 Joomla! sites and as noted above, integrated Joomla! with FM, the initial location of the post was correct ... he's looking at using Joomla! as an External Data Source for FileMaker Cheers! Lyle

Have you checked out LightSpeed? http://www.lightspeedretail.com/ They have Developer API that may help you with your customization.

In an attempt to narrow the source, have you done any sort of analysis of the variables you mention? You state that this is happening on FMSA 9 thru 11; so, is it happening more on one version than the others? Mac and PC; same thing. Browser "flavour"; again, the same. I would suggest you begin tracking these variables to see if a pattern emerges :)

Click the icon in the upper left, under the wi-fi signal bar ... this will take you to the Files/Windows screen. Click the close icons for each file (upper left, white X, red background) "Getting Started" and "Welcome to FileMaker Go". Then click the Files button (centre top) to go the the FMG "Main Screen". Check the FM site for the PDF on how to connect to your FM databases on your iMac. http://www.filemaker.com/products/filemaker-go/resources.html

This is what loads when you first visit the site ... It is also generated when I click the "View New Content" link.

Yep, me too.

Never mind ... it's simply a matter of checking the "Auto-refresh Grid" check box ... in Alpha Five v11 :)

Codeus ... +1 Lack of native container upload (especially now with the new container functionality) and printing/PDF generation are the two primary reasons I am now looking elsewhere since finding out these were not addressed in 12. However, I am not that naive to realize why there were not, and more than likely, never will be provided directly from FMI; doing so would negatively impact sales for the desktop products.

Howdy, I have a portal that contains two fields from a MySQL database via ODBC. What I would like to achieve is that these fields "auto-update" when the underlying data changes in the ODBC datasource. As it is now, I have to manually call the "Refresh Window" function, and do so via a button/script ("Update") that uses the Refresh Window script step with both "flush" options selected. I have tried using this in a script trigger for the OnModify for the portal and also for the fields themselves. No luck; still have to click the "Update" button to have the new values display. Is this possible to do "auto-magically" :-) Cheers! Lyle

Not sure how to go about doing that ... I got our IT folks to set that up for me :)

Howdy, I just successfully tried this, from a Win 7 Home Premium machine running FMPA 11v3, to connect to and open a file on a remote host (commercial FM hosting). This is what I used for the link: fmp7://my_hosting_account_URL/filename.fp7 Works like a charm Are you able to Open Remote "manually" from FM outside your office?

I see exactly what you are trying to accomplish and it looks as though all you have to do is adjust your calc to set the initial match to "1", as it is shown in the first 10 rows, and then increment from that point. In other words, adjust the starting point. As I am far from a "pro" in this area, that is easier said than done so I can't really provide a sample ... but I know what you are trying to do :)

Howdy Matthew, If you haven't already, perhaps take a look at these two FM Go docs, one ( I can't recall which ) gives the ipad screen dimensions, among a lot of very useful info. http://www.filemaker...development.pdf http://www.filemaker...r_go_121_en.pdf Additionally, one should use separate layouts for the iPad; that way, you can tailor them specifically to the dimensions and contraints of that platform. These would be separate and apart from your current "desktop" screen and print layouts. It's easy to detect and switch to the desired device with a script attached to the File > File Options > When opening this file ... > Perform Script: "Startup Script with IWP and Device Switch" (in my example). Here is what I am using (not the "cleanest", but it works (note that the first "test" is for Web Only account privileges (custom one I set up) - folks with those can only access via IWP) Startup Script with IWP and Device Switch Allow User Abort [ Off ] Freeze Window If [ Position ( Get ( AccountPrivilegeSetName );"Web Only";1;1)>0 ] Go to Layout [ “Menu Web” (cn_etr3_1) ] Else If [ PatternCount(Get ( ApplicationVersion );"iPad") ] Go to Layout [ “Menu iPad” (cn_etr3_1) ] Else If [ PatternCount(Get ( ApplicationVersion );"Go") ] Go to Layout [ “Menu iPhone” (cn_etr3_1) ] Else Go to Layout [ “Menu” (cn_etr3_1) ] Show/Hide Status Area [ Hide ] [Lock] Allow Toolbars [ Off ] Show/Hide Text Ruler[ Hide ] Adjust Window [ Maximize ] Enter Browse Mode Show All Records End If End If This first tests if the user has "Web Only" privileges and if so, then goes to the Menu layout designed for use with IWP. After that, it looks to see if the app version has iPad in it ... if it does, the to the Menu layout designed to fit the iPad; note that all navigation from this menu are to iPad-specific layouts. If it doesn't contain iPad and it contains Go, then it goes to the Menu layout designed for the iPhone / iPod touch; again, with layouts designed to fit the iPhone. If none of these are "true", then it goes the the "regular" desktop version of the Menu layout and does a few other chores. Hope this helps Cheers! Lyle

@Ocean West - yes, what you describe is it exactly, except they can choose only one "template" per "checkout" @comment - the "Add New Batch" script in your example worked perfectly! ... thank you so very much for your "analogy" ... mind you, I am now going to have to have a beer or three to "compensate" for transposing your example terms for my own! LOL

:) Actually, in this particular case, the "analogy" does work, so let's just say that this IS an Invoicing app In your example, the Relationships are "pretty much" what I have, and as expected, a script will be required to copy the values from the Invoice (Recipes) to the Checkout (Batches).

Howdy, I have held out posting here, hoping to come up with the answer myself, but I am finding that I am going around in circles! Could someone please nudge me in the correct direction? Although this is not an "Invoicing" solution, the analogy works and is one that many are familiar with. The Scenario: - User creates pre-populated invoices in advance, using any number of available products, and places them on the invoice is a particular sequence. - Each product may appear on any invoice, but only once. - Each invoice is unique and once created, is not able to be modified; if changes are required, a new invoice is created with the modifications. So far, so good Now comes the "fun" part ... using these invoices ... this is where I am "stuck" For this example, let's call this the "Checkout" phase: - new Checkout record created - Customer selected from Customer list - Clerk selected from Clerk list - Pre-populated Invoice selected from Pre-populated Invoice list - "voila" ... there are all the "Line Items" from that particular invoice and in the correct sequence - now it's just entering the "quantity" for each line item What I am thinking (and I know that's a dangerous thing!) is that when the Pre-populated Invoice is selected from the list, a script will be run to copy the line items from the selected invoice to the line items in the "checkout lines" table. If so, i think I can muddle through creating that script (if not, I'll be back ) But I was wondering if there may be a way to do this through a relationship some how, or perhaps a different "structure" altogether. Thanks in advance! Lyle

I guess I am not getting what the issue is that you are having. The reports and screen layouts that I design on Windows, look and print just fine on the Mac, bold, italics and all One project I am working on now has a mix of Arial, Helvetica and Verdana; same thing; look and print fine on either platform. I am not clear on what you mean by "fake" bold and italic.

OMG! You mean it's NOT Veranda?!?! LOL ( I had always thought that too! ) Helvetica seems to play well on both, but as LaRetta says, Verdana is what most use, myself included. I also design on Windows, but one still has to check on the Mac, especially for descenders and overall width; looks fine and dandy on Windows, but can be cut off on the bottom and/or ends on the Mac.

Saamme withh FF 9.0.1 oon thh Maac However, it works just fine in Safari and Chrome on the Mac ... OS X 10.7.2

Yes, the day they came out! ... I had this issue as well with 11.0v3. Just thought that I would highlight the fact the upgrading to the latest version fixes the issue.

The Upgrade to FMP / FMPA 11.0v4 addresses this issue http://forums.filemaker.com/posts/bc3653a873

Hi David, I see that this is an older, unanswered post, but I had something similar occur yesterday and I came across this post while searching to see if there were others with this issue; guess so Here is my scenario: During my dev process, I always work on a copy of the previous build. If I make a lot of changes to the file, I will close it, duplicate it in Finder, rename it and then start working on that file. No problems until yesterday when I figured it would be good time to see how things are going to act on the iPad. Well that's odd, I can't log in; get the exact message you have in your title! what the ... Now I am CERTAIN that I had an earlier built open in the iPad so I tried that one ... yep, opened no problem. So I kept going forward until I got to one that wouldn't open. I spent the better part of the day comparing the security, privilege sets, sharing settings ... anything I could think of! No luck. Same thing happened when I tried to "open remote"the files using another FMPro 11install on the network; one build would, the next build wouldn't! This is no good! I was just about to post here looking for any help I could find, when for some reason, I recalled something I read a long time ago about "Save a Copy As ... > compacted copy (smaller)". Did that, and I could now open remotely again! What the heck?!?!? It should be noted that these files were able to be opened on either computer on the network natively, just that they could not be opened remotely from another computer, remotely being served with FMSA 11 or the iPad. After saving compacted, all was fine again. Any ideas as to why this happened(s)?

oops! ... changed the wrong "1" to "2" after pasting a copy of the first one :idot: