Monger

The event log says "File Maker Server trial license has expired. Server will now shut down". So yes, it seems to be the trial. Weird that they would do that. It expires after 30 days anyway. Why punish within that trial? Many thanks for your responses.

Hey there, We have just installed Server 7 on a local PC and serve a db to three clients (PC and OSX). We are using a wireless apple network. The server seems to shut down regularly (every three hours or so) after sending a notificaiton to all clients saying "closing all files". Any suggestions? Thanks a bunch. Stephan

That did the trick. THanks, St.

hi, i need to do something seemingly simple but can't get it to work: I need to add text to a value and display it in a new field. The value is "123" and and sits in field A, and I want to add "-wh". So i created a text field B and added a calculation to it: B=A+"-wh". That's not working. Well, how is this done? Thanks, St.

With working my brian to the max and a lot of attempts I figured this out. Was actually really simple. THanks Terence.

So I guess my first instinct would be to make a second calculation field, with a substitute ( list ; paragraph symbol ; "," ) function, and export that instead. -Terence

Hi, Many thanks to those who can help wit this: I am exporting values which are later read into a MySQL database. I am using a checkbox field to enter different values to a field. THe import script needs to be able to distinguish seperate values by a comma but when I export the values are just seperated by a blank. Since some of the values are two workds, the import script would misinterpret these values even if it seperated values by these blanks. Is there a way to export this field and the corresponding values and seperate them by commas? Thanks a lot, Stephan

Sorry for the late reply. I had to leave town for a while. Anyway,- I tried to figure this expale out but with my time being very limited (I hope it's just that) I never got anywhere. I wanted to thank you for your help though. I decided to create just three tables (all wines, catalog, budles) and I got this to a point that allows me to few the info the way I need it, but I can't export it quite yet. Since Product ID and Wine ID are pulled into flieds through a relationship (and in the latter case into a portal), the export to a tab file ignors all the data that's not sitting in the same table. Well,- I guess this is trivial and I will figure it out eventually but if you have a hint for me, please drop me a line. Once your invoicing solution is ready I would love to take a look at it. Thanks again, Stephan

Hi, I guess this is trivial, but hey... I am trying to export data that is pulled into a table (A) from another table (: by look-ups. Other flieds are just pulled in as a related flield from table B. I need to now export this data from table A to an excel file. How can I do this? Since the data is not really sitting in this table the export to a tab delimited file does not work. Thanks, Stephan

Thank you Fenton! Fortunately my needs are not quite that complex: All we need is a database that allows us to output our products to a comma or tab separated file and upload that file to an order processing software (www.ordermotion.com) and our shopping cart software (www.monstercommerce.com). Since both those solutions have their independent databases, I would want my database to reduce its inventory whenever a part of our catalog is fed into the store (represented by those two databases on Monster Commerce and OrderMotion). If some wine is being sold but some is still in the warehouse, I will have to reduce the inventory to the actuals in our database before I do another upload of our inventory. But that should be fairly easy and could be done by hand. From what you are saying, I have come up with this database design and please tell me whether I am on the right track: Table A for all the wines. Product Name, Product ID (SKU Number) and Wine ID for each product. Table B for all the bundles. Prodcut Name, Product ID (SKU) for each bundle and Wine IDs are pulled into a portal. Table C for the catalog items. Product ID (SKU) and Product Name. The match fields are Prodcut Name and Product ID between all tables. Do I need a table D for the inventory or is there a simpler way? I tried to figure this out from the example you sent me, but I am not quite comprehending it yet,- I guess. Thanks again, Stephan

I have used FM for years as a simple storage solution but suddenly I have to deal with relationships and after two days of trying and reading I am nowhere. Here is what I need to do: I have a database containing about 300 different wines. Each different type of wine has a unique number, the "wine number" and a certain inventory. I am trying to put together a catalog in a separate table, that shows some of these wines. Where it get tricky, is that my boss wants to sell some of these wines bundled, - meaning he wants to offer something like a case of three. How do I set these tables up to where I can maintain an inventory count? Do I A. Create a separate record for each of these bundled products with their own unique ID? If so, the ID would have to be different from the "Wine Number" to be able to still do an inventory count, right? Would I then pull in the different wines (of the bundled product) as a portal? B. Can I just pull the different wines into a record in the product catalog by setting up a portal there? I tried that but failed at figuring out how to set up a relationship that makes sense. I guess this is not an option at all. C. Is there a smarter way of doing all this? Thanks for any help, Stephan

Here is my , I guess simple problem, in even simpler terms: Lets say farmer John wants to sell apples, oranges and pears on the Internet while keeping a accurate inventory count. So Johnny assigns numbers to each item. 1 for apple, 2 for pears... He keeps all his line items in a table. Then he realizes that he wants to sell baskets of mixed fruits as well. So now he is assigning basket ID's: A, B... Next he wants to create a table that contains all his catalogue items, meaning that part of his inventory that Farmer J really wants to put up on his site. For his catalog he wants to create a separate table, since he wants to somehow build a relationship between his basket ID's and his fruit ID's that allows his to list a basket in the catalogue, pull in all the data for the fruits (weight, color...), and deduct the fruits in the basket from the inventory. How is this done? I am guessing this is very basic but still, Famer John is not very smart. I actually created a separate table for the catalogu and created a = relationship between two records. Then i created a portal on the catalog page for the different fruit ID's of the baskets since I will need those for my inventory count (reduction, that is). Then I imploded. When I tried to create another match field relationship the fruit ID's didn't show up in the portal anymore. Any other field I could also not relate to the other table, meaning the data from one table would not show up in the match field of the other table. Should I read the manual of FMP7? Thanks, Stephan