thierry.be

Hi all, I don't know if this is the appropiate thread but i didn't know where to put it else. I have a projectdatatbase. I am looking for a browser based calendar solution that can be synchronised with my database. Requirements. * Browser based * Drag and drop * Able to display different records from different databases. * Easy to use * Different views possible (per project/ per user/ per client/per vendor) Does anyone know if there is such a product available on the market? Hope someone can help me, Thx, Thierry

Hi all, I have problems configuring the Web server connector: Whenever I type http://localhost/FMpro?config my browser doesn't find a thing. My Filemaker databases are open and shared. Web Companion is set to use port 591 What am i doing wrong? Any suggestions are welcome. I have tried specifying port 591 in the server settings of my mac osx server, In the tab web service, is this necessary? when I start WSC by doubleclicking StartFMWSC.command. It innitialises FMWSC and then immediatly logs out. It says it initialyses FMWSC with following setting : port :8888 backlog : 50 etc. Yet I have specified another port? I am getting a little frustrated...... Hope someone can help, Thanks anyway, Thierry In de attachement log file i get error.txt

Hi Jef, I finally found some time to test your example, but unfortunality i do not get it to work. grrrrrr ;-) As a already mentioned i am just starting to experiment with CDML so these are probably simple problems/questions: 1. It seems to work better when i use , like you say port 591, why is this, why can't I use other ports? 2. When I make the index page as the home page, and i click 'messages' I get the message message.html not found, but messages not found is in the right directory. (in the directory 'WEB'|) 3. When I make the message .html page as the home page and i click new topic the famous mac.wheel keeps on spinning. I presume this has something to do with the fact that i have no contact database yet 4. If i create a contact database is the name relevant, are the field important, ... ? Hope you can help me sort this out, Thanks in advance, Thierry

Hi Jef, The second download works just fine. I will give it a try and let you know how it works out. Thanks for your help

Hi all, I am experimenting a bit with CDML. Now I have created a website with fill in forms, and all that works fine. Now I'd like to add a discussion forum to my website. Has anyone done this with CDML, if so can I find templates/ examples on how to do this? Hope someone can help me, Thx anyway Thierry

Hi all , Question: I have a list view Each record in that list view has a portal in it. Each portal has 7 rows Each row in the portal has 5 fields all these field are radiobuttons (yes-no) and each record in the portal row has also 5 date fields On this radiobuttons I put a button (script ) containing the following (I have 5 of them): if field (portal::radiobutton) = "yes" set field (portal::radiobutton) = no set (field) (portal::date) = current date else set field (portal::radiobutton)no set field (portal::date) = "" No the script works just fine exept it always 'refreshes' the window. So it takes like 2 seconds. Is there a way to avoid this . So it becomes faster. hope you understand teh problem and someone can help me Thx, Thierry

Hi all, This really is a newbie question. We have a filemaker database running At a certain point we decided to put the database on the web , so we got Filemaker unlimited. No I was able to get the database online using instant publishing, but then the buttons in the database do not work. So i realized we need custom web publishing, presuming that the buttons do work this way. Now I have no knowledge of HTML, and even lesser knowledge of CDML. So the manual is a bit complex for me. Can anyone explain me what minimum steps I have to take to get my Database on the net, with my buttons working....... Thx in advance Thierry

Hi all, I am having the following problem. Have a number of files. Lets say I open file A. From there i go to file B. No there i have a portal with records from file C. I have button in the portal that directs you to the child (= file C). (the script is something like : Go to related record perfom external script (this external script , enters browse mode and opens the right layout) toggle window (hide) No I want to hide file B, when leaving file B. So far so good. When I push the button in the portal row, file B, gets hidden and the file C appears BUT for one breave moment it shows file A ! Hope you can still follow, and hope someone knows an easy way to avoid this, cause I have this issue in a lot of layouts. Thanks anyway, Thierry

Yep, This is works.... How simple it is sometimes, thanks for your help LiveOak. Thierry

Hmmm, Types are like functions. ( DTP, product photgraphy, creative design, application photography,....) So when I do a search for DTP, i should get a list of all DTP'ers. One vendor can do more functions, one vendor can be DTP and creative design for instance. So I am looking for a way to - perform a search easily. A search on type, if I search on DTP i should get a list af all DTP'ers - be able to select the different types, from the complete list of types. So in vendor i should be able to selct all the types that vendor is and when there are new types created they should appear in the list,... Hope this claryfies the situation, Thx,.. Thierry

Hi, Have a (beginners) question. I have a database file 'vendors' and another one 'types' One vendor can be more types and one type can have more vendor. What I am looking for is the following, When you go to vendor, the aim is to see all the types that exist and then just click in a check box if which types the vendor belongs to. So if i am not mistaking i will need 3 files, : vendor- join- (this table has the primary keys of the other two) types I am not sure how to accomplish this, in which file i do this best , any ideas are welcome, Thanks, Thierry ++++++++++++ 1+1 =1

Hi, In the previous subjects, I have read that portals aren't always the best things to put on a report, yet i have a report containing 3 portals with 0 to 20 rows. Now the only thing I want to do is to keep the portals together when I print them. So if the 3 portals fit on one page. I d like to print them on one page. If not i want the first to be printed on the first page and then the others on the second. So i want portals not to be cut in half. Is there a way to do this? Hope someone can help me,... Thanks, Thierry

Thanks Keith, I will have a look, yet this is all very new to me,... If I understand correctly only pictures, sounds and videos can be put in a container, but what about pdf, doc, etc. Again if someone can help me with PHP please do i found some scripts for uploading files: http://www.php.net/manual/en/features.file-upload.php yet i have no idea of how to do this. Keep in mind I am relativly new to all of this, so a lot of explanation (even if it seems logic to you) is very much appreciated. I can make a basis database (instant web puplishing). Yet I don't have experience with, CDML & PHP. Useful tips welcome, Thanks again, Thierry

Hi, I am relatively new to Filemaker but I think I can help you. But there are probably better (read faster ways to implement this) I would say you make a field - current date - teller - calculation field : current date & "-" & teller Everytime you create a new record , just make a script that checks the the date of the last record. If it is the same then today add teller with one of not set teller to 01 Hope this works, Thierry

Garry, Thank you for your reply, yet PHP seems difficult and I don't know for sure PHP can help me accomplish my goal. I have been looking on the internet on some PHP sites, And I came accross some manuals, but none of them combines Filemaker with PHP. With the exception of iViking. FX.php??? So I have no idea of how to start making this. Second problem is that people told me that you cannot use a container field on a webbased database. - Could you explain (in easy words) how to combine PHP with Filemaker. - Are you sure the following can be accomplished. Attach a word document to a record in Filemaker database. Through a Web browser download the file, make changes and upload the word file and attach it to the same record. Hope you can enlighten me, Thanks anyway, Thierry

Hello, Yes,yes , I am going to ask a question that is already been asked before, yet for a beginner like me I wasn't able to find a complete answer. When you make a simple browser based FM database, and you want users to be able to download / upload files (Word, pdf, indesign, photoshop) this seems quite difficult to accomplish. - I have read that FM alone can't provide this - But 'Total upload' from Direct Dual limited provides an easy solutions, but this is for Windows users only. - Other solutions where use ASP, Webstar, and other web server programs. But unfortunately I have no experience what so ever with either of these. Is there anyone that has accomplished this? Knows what the easiest way of accomplishing this is? Can help me , How do I link Filemaker with ASP, what code do I write in ASP etc. ? Hope somebody can help me, Thanks anyway, Thierry

Hello, This is a general question and perhaps a filemaker forum isn't the best place to ask for this kind of information, but I tried to find some information on the internet, and I was overwellemed by products so I can use some experienced advice. I am looking for a database that -tracks approval flow -does filetracking But before I start making this in Filemaker i want to check if perhaps there are other more convenient ways of doing this. I will give an example of the kind of info that should be tracked in the database. eg. Suppose: - You make a document in indesign, you send it to a customer, - He/ approves and sends you back the file. -Later you send this file to a translator who translates the file, - Again he send his back, - Then you send it to the client again - He checks and sends his disapproval. - You send it to the layout office - The make corrections -You send it to the client He approves The question: -Is Filemaker a good way of tracking the lastest whereabouts of a file (=locations & approval) - Are there better Databases/Products to track this Hope someone can help me ? Thanks anyway Thierry

This works just fine, Thanks you, Thierry

Hi, I am looking for a solution for the following problem: - I have three fields. date revised date freeze Freeze can have value yes or no. In the layout the user cannot edit 'date' Case 1: Freeze = no If the user changes the value of revised date, the value of date should also change. Case 2 Freeze = yes Whenever the user changes the value of revised date, the date should remain the same. Does anyone have an idea of how to implement this? Hope someone can help me , Thanks, anyway.

Does anyone has experience in synchronising filemaker pro with fasttrack schedule? Cause i tried and I still have some problems,... Thanks in advance

Andy, I tried your solution and of course it works, so again, thank you for your help, Thierry

Hello everybody, I have a portal question: I am making a database for this particular question 3 tables are important: 1. Table items : 1 item consist of different vendorjobs (relation 1-n) 2. Table vendorjobs : here we have the name of the job, start date, end date, etc 3. Table Vendor : 1 vendor can do more vendorjobs (1-n) What I have now. In the table items I have a portal with all the vendorjobs in it. The name of the job, the dates and the vendorname. The vendorname is actually a value list with all the vendors in. (linked with vendors) What I want to do is : I want to add a field called vendor function in the table vendor. This field also comes in the portal. in the client table. Now instead of showing a value list with alll vendors, I first want to select a function in a function value list. If lets say I have a function 'translator'. Then when I select translator in the portal, the value list of vendors should change and give only vendors that are translatoors. Is this possible? If yes can anybody explain a bit how this is usually done,.... Thanks anyway. [ March 20, 2002, 07:35 AM: Message edited by: thierry.be ]

Indeed it works, Thanks for your help, Rather young and not so advanced man,..... Thierry [ March 15, 2002, 06:14 AM: Message edited by: thierry.be ]

Hello, I have a question, I am making a database with an invoice system. Users should be able to change the invoice, but at a certain moment (when they push a button or when something else happens) The invoice should be frozen, people shouldn't be allowed to change it nomore. What is the best (easiest) way to do this? Should I just direct them to another layout where no fields can be changed or are there better ways to do that? Hope someone can help me, Thanks anyway, Greetings, Thierry

Rigsby, Thanks for your help, it was extremely usefull to me, I think I will get there, yet I have some questions: 1. In the item table a seperate id is necessary right? The combination of the foreign keys (job and client) aren't unique for item? 2. If you mark invoice Y how can print only those on an invoice in other words, how can I select, view and print this on an invoice? 3. To what tables should the invoice DB be linked. Should it only be linked with items or would it be better to link it with jobs and clients? 4. How do you merge and split keys? Is this a calculation field ? Hope you (or someone else) can clarify this Thanks again greetings, Thierry [ March 06, 2002, 07:44 AM: Message edited by: thierry.be ]