Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

victorialine's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Hiya, I do get private topic responses in my email. Thanks. Re: the scope of the project, I wanted to find out if there were any in the Nashville area before posting all the details. I do have a few replies and will be following up with them. THANKS!!
  2. I'm looking to find a FMP developer in the Nashville area for a project. It is a CRM system, that also manages journal subscriptions and event registrations. If you are interested, please respond by private message. Many thanks, Cin
  3. I have some questions, and this seems to be the closest topic. 1. So if a file is on a server, and I need to make a small change - you are saying that it is best to NOT make that change on the server? 2. Is there a difference between making a change to a script vs. creating an additional field vs. just putting an existing field on a layout vs altering relationships? 3. If I have already done some of the ''verboten" things, I suppose the thing for me to do is to check to be sure that my db is not already corrupted? If so, can someone point me in the direction of how to check that? I'm sure it has been discussed. 4. It appears that what is being recommended as best practice is: a. make the changes when no one is modifying the data on the db b. download the current db c. make the changes (test, etc) d. upload new db to server. Now, all this seems to be a lot to do when just making a small modification - AND I agree that not having a corrupt db is worth the trouble, I'm just wanting to be sure that I have my hands around WHEN I need to do it, and what the correct PROCESS is. THANKS, Cin
  4. I'm using FM 8.03 and the database is on a server. I have two tables joined: people and address. If do a search for the city with records from the Address table (in other words, not relying on the related table), all is fine. When I do a seach for city from the people layout, I'll get the correct entries, BUT ALSO I'll get some incorrect entries. For instance, when I search for first name beginning with P, and in London, I'll get some people from Glasgow, Birmingham, and various other cities. But when I did a test field using the Address table, then all was fine - so it has something to do with the linking between tables. This works the same whether it is a manual search or with a script. Thoughts? As always, all assistance is much appreciated.
  5. I love it when I respond to my own posts!!! I hope this helps others out there: Ok, I finally have it all working. Here are a few things I learned in doing this, that I have not seen published anywhere else (it may be out there, but I did not come across it – AND this is what I had to do – this may not be the same for all servers and all programs. I’m using GoLive to do the webpages and FXForge to do the php). while it is possible for the website to be hosted on one server, and the db hosted on another – the php pages that deal with the db must be on the db server, not the regular site server. Knowing that would have saved me loads of time!! The server that has the db will have space for you to put your php pages. But I had to know the host address, the web address, and the folder structure that was already there, to know where to load my pages up. Oh, and I had to know the logon and password to FTP to it. The computer where the php/html codes are being written has the FX file (as downloaded) (as opposed to it being a part of what is on the server already). There are two things to note about it: a. the FX folder should be upload to the website along with the HTML pages. b. you have to go into the FX folder to put in your IP address and the port that the db is on. The file to do that is server_data.php and you place it at $serverIP = '123.456.78.910'; (with of course your numbers in there) That is how the web page knows where to find the db. 4. then the php pages that I put up HAD to be in the ‘web_pages’ folder – now, I don’t know if this was the particular server or not, but I can say that you can’t just put the pages anywhere, you really do have to get them in the right place. So, all that info would have saved me several hours – so I hope that it is of use to someone else out there. The only other thing that I have stumbled across that was not obvious is about FXForge. When you open then file, there is an extension that you have to place in the extensions folder (the FXForge extension folder, that is). IF you do not do so, when you go to save the file that you create with the wizard, you get a question mark in the field name. SO – other than that, it looks like FXForge is going to be awesome. Now that I have all the players talking, I just have to learn about the different ways to program it all, but I think that that will be the least of my worries. And I can already say, it would have taken me foooorrreeeeeevvvvver to learn php AND how to put it all together. It really helped that I knew that the coding was good, it was something else that was off. So if you are a beginner like me, and you are thinking of learning php, please do it the easy way. Thanks FMWebschool!!!!
  6. I'm new to FX.php and just started with FXForge, and I’m not able to get a page that works. Here is what I’m using: Adobe GoLive v.7.0.2 (from Adobe CS) Mac – OS 10.4.7 FM 8.3 FXForge v.3 The db that I’m using is hosted at an FM server. I also have a copy of it on my computer. I have unstuffed the extension and put it in the FXForge Extension folder. Then I have run the wizard, and followed along with the video on FMWebschool site. I end up with an GoLive page, but I don’t think that there is any link between that page and the database. The page has the graphics from the template and shows the table for the info from db, but no info shows up. A few questions: Am I able to test the page I create with FXForge, and have it all work on my computer before uploading it to the internet? Do I have do load fx.php (or anything else) on my computer to be able to test it locally before uploading to the internet? (if yes, can you please point me in the direction of good resources for that – as I recall from earlier research, it was not as easy as it seems) How does the page that FXForge generated know where to look for the db – I put the name of the db in the wizard, but that doesn’t tell it where it IS – especially if it is hosted?? Many thanks, Cin
  7. Can you post the database so that we can see what you have done and how you have it set up? Thanks, Vic
  8. After these questions were answered, I spoke with John May, of PointInSpace via private email with some further questions. I am posting those questions and answers for the benefit of the forum. Thanks a MILLION you guys for answering my questions. You guys ROCK! QUESTION: Ok, a few more things that I'm still not clear on: You say FX.php is simply a class for PHP that helps with accessing FileMaker via its XML interface. (And just so that you know, I deal with the database, but someone else is the web mistress) OK, so I have no experience with accessing FM via the XML interface.... Is there anything that I need to do with respect to the programming of FM to be able to have it feed the website? Does the database just need to be uploaded on to the server and it's ready to go? ANSWER: You need to enable the fmxml extended privilege set. The FX.php instructions, I believe, cover this. Otherwise, this is certainly something we provide instruction on to our clients. QUESTION: Then if we had this set up, in order to change the data that shows up on the internet pages, we would just change the data in FM? ANSWER: Correct. QUESTION: Also, I understand the 30 day trial - the thing is that we are not close to going live with the new site (waiting on branding/new logo design work). However, I'm in the position of convincing others in the business that this is the way forward. What I'd like to have is two things: 1. a short trial so that I can demo the use of it for the other people at the company, and 2. I don't know if it's possible to get some 'canned code' to be able to have the data show up on a web page... For demo purposes. Would that be possible? ANSWER: We do not offer demo accounts, sorry, nor do we have any canned code. For the first, I would suggest joining the FileMaker Solutions Alliance to get a developer copy of FileMaker Server Advanced, which would let you develop/demo locally without needing a service like ours. You can get this with the lowest membership level, and it is limited to 3 IPs accessing it. For canned code, I'd suggest checking out fmwebschool.com. QUESTION: So then - on sort of another topic with respect to FM and servers: If we had the full database (client data/registrations/marketing info etc.) on the server - in order to access it, would it be VIA the FM application? Or via a web browser? What do I have to do to access it? ANSWER: You can access databases running on a server like ours via any/all of the following: FileMaker Network Sharing (logging in with a local copy of FileMaker) Instant Web Publishing XML/XSLT Custom Web Publishing FX.php Lasso QUESTION: Does it work the same as when I have the db on my computer (with, of course, the exception that I have to be online to access it)? ANSWER: Yes - exactly the same. QUESTION: It is easy to upload/download the database? Is it like uploading/downloading things to a website (via FTP)? ANSWER: Yes, we offer our Database Manager, which allows you to use FTP to upload/download your database without our intervention. QUESTION: With the db on the server, am I still able to deal with programming issues while it's there, or do I have to upload the newly programmed db? ANSWER: You can edit the live database on the server - no need to make changes locally + upload. QUESTION: One more question: you said: You can access databases running on a server like ours via any/all of the following: FileMaker Network Sharing (logging in with a local copy of FileMaker) Instant Web Publishing XML/XSLT Custom Web Publishing FX.php Lasso What is the difference between using FX.PHP and XML/XSLT Custom Web Publishing? I thought that using FX.PHP was using the custom web publishing - now I'm not sure if I need to go back to the drawing board to research this. Would XML/XSLT would that be something that we would use to do the web pages that I mentioned - or would it just be for us to access our database oursleves? (am crawling back over to google now....) ANSWER: XML/XSLT is another way of publishing your databases to the web, like FX.php or Lasso. I would highly suggest against it though, as it is very complicated, and not particularly flexible, and there isn't a lot of documentation available out there on such. THANKS JOHN!!!
  9. OK, I have done some research on using FMP and PHP and FX – but I still have some questions that I cannot find the answers to. I’ll set up what I understand and what my questions are, and I completely appreciate any assistance that anyone can give (to either correcting anything that I misunderstood, or answering a questions). So, what I am going to use this for is a website for a company that does conferences and training courses. We want people to be able to search for courses by city, date, or subject matter. To do this, we are going to need a webpage that gets the info from FMP. Here are things that I do understand: the db has to be loaded on a server that is able to “serve out” FMP databases to the web pages. For the server to be able to do that, it has to have FMP Server and PHP....and preferably FX:PHP. PHP is the language on the webpage that says “hey, go look for this data from a database and bring it back to me” - as opposed to being simply what is written in HTML. the best way for PHP to talk with FMP is for the server to have FX:PHP. so then the webpage goes and gets the data (city/name of course, whatever was requested) and returns the data to the webpage for the user. (and in fact, if the user were to look at the source code, they would see HTML, not PHP) it’s a pain in the rump to set up your own server, and for something like this (couple of web pages, versus, say, a university site with lots of dynamic pages), and therefore it’s advisable to use a outside server, such as Point In Space (don’t have to maintain server, don’t have to get FMP Server, load PHP, FX etc. etc. etc.). OK, so that is what I think I understand. (please feel free to correct me if I'm wrong on any of that) So, now for my questions: the server has to have PHP and FX on it? The web mistress does not have to have PHP and/or FX on her computer? the web mistress needs to know how to WRITE the PHP bits of code on the webpage in with the other HTML code on there? That is just the same as learning any other language (HTML, XHTML, etc.) is there a way to “test drive” the FMP data on a web page to see if it is what we want to do, without signing up for a server agreement? Is the PHP and FX bits of code that the web mistress would write the same? Is the difference between PHP and FX just on the server, or is it a different code on the web page? are there security issues with doing this? Can this db be the same one that holds all the client data, or should they be separate databases for security reasons? can the server that hosts FMP be different from the server that hosts the main website? Any reason to have them the same or have them different? in terms of performing the search of the database (ex: show me all courses in Chicago, show me all courses in September) - can you point me in the direction of some good resources on how to code the webpage to perform that search. (I have looked at some PHP books, but was not sure when I was looking at them that they were exactly what I needed).... I’m sure that I’ll have to read around about this, but a good shove in the right direction would be most welcome. is there any problem with writing the page with PHP/FX using GoLive or Dreamweaver? Many thanks, Vic
  10. I tried it as you sent it and I could do the search by hitting "enter" (as opposed to "return"). On one computer, it was the "Function" and "Return" key, and the other, there was an "enter" key.
  11. OK, that was WAAAAAAAAYYYY too easy. Thanks a mil for saving what's left of my sanity. ~Cin
  12. OK, this has to be simple, but I can't figure it out. I want the user to be able to scroll through the records in the Form view, using a "next" button, and a "previous" button. There does not seem to be a script step that makes that happen. (of course, there is the little book thing that we use on the left hand side, but I don't want to use that) I'm able to get it to work as long as the records are sequential, using a global field, and a find.... but that doesn't work when there is a break in the numbers. Any hints? Thanks, Cin
  13. Steve, Thanks for your reply. I suppose it would be possible to do it as a script and run it from FM. One thing is that I have to be able to run it in a PC and a Mac environment. Also, apparently it is a function of MS Word that I can run the mail merge FROM Word, and locate the FM database as the data source. And now that I think about it, I'm not sure how I would tell Word which contacts to get. I certainly would not want to grab a the WHOLE database. Hummm, maybe I should try and post on a good MS Word BB. Anybody know good BBs to post on? OR does anyone have experience running the MM from MS Word?: Thanks, Cin
  14. I want to do a data merge in MS word using FM file (created with FM8) as the data source. Word is supposed to be able to bring in filemaker data under choose data source. The problem is that when I go to CHOOSE the filemaker file, all of them are greyed out as if word can't recognize them. I have tried this with Mac OS X Tiger using Word 2004 and Windows XP using MS Word 2002. Any ideas? Thanks, Cin
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.