By Jhon Doe
I'm a beginner in FM, and i'm trying to develop a solution that allows me to import data from a csv file. I have two related tables Customer ("parent") and Alerts ("child"), each one has a primary key and the Alerts table has a foreign key to conect with the Customer table. I have to populated the alerts table from a cvs file that could have lots of records so I want to relate this new data to the right customers automatically when i import it, the new data does not have a field with the customer ID (primay key) only has its name. Could you please give me any advice with that?
Am I righting in thinking I can use a case statement to evaluate two fields and return an answer into a third field ie: Field A has the number 27 in it. Field B has the number 32 in it. Could the case statement look at the difference and put the difference in Field 3.The difference being 5?
I’m also trying to get this to do the math on data entry, so the figure in Field A is 27 but when the user enters the new figure in Field B (i.e 32), it looks at that difference between A and B, copies the difference of 5 to Field 3 and then also copies the figure 32 from Field B into Field A thereby updating Field A to the new value.
Help, suggestions or thoughts will be greatly appreciated.
I've attached two files. The first one is INVOICE, that is generated by every establishment when you purchase, and is in xml format.
The second one is XSLT file, that is provided by government fiscal institution and is used to "translate" xml.
PROBLEM DESCRIPTION: when I try to decode xml using attached xslt scheme on any online xml-converter website the output looks fine. BUT when importing to Filemaker, I receive an error: "XML parsing error: invalid document structure".
I would appreciate any help with the issue. Thanks.
Hi - I'm developing a business solution to be hosted on FM Server. It will be hosted on Soliant Cloud. This is my first time developing for Server. I read Steven and Wim's whitepaper on FM 16 security, which was very helpful.
In the past, when I've created upgrades to my solution, I've imported data from the previous version into the new one. Each update is a modified version of the previous file.
I read about the benefits of using File Access Protection. My solution is a single file solution so I can basically exclude any other file having access - except I'm not sure what impact that will have on import from previous versions. I assume both files will have the same ID - but not sure if that means that FM will see the older version as trusted or not.
By Rob Ross
I am not sure if I posted this in the correct place, so please forgive me if not.
I have: FM16 Pro Advanced (Have both Mac and Windows, but I use a Mac to develop), FM16 Server.
I am trying to have a drop down value list populate with information from two different tables. Let me explain:
I have a table called Products. this table contains information required for an individual product that we sell. Some of the fields inside the products table are: ID.pk, name, cost, price, etc..
I have a second table called Bundles. This table contains multiple items from the products table that become a single sellable bundled item. Some of the fields inside the bundle table are: ID.pk, name, BundleCost, BundlePrice, etc. As an example a product would be any one of these items (only one): Hamburger Patty, Lettuce, Pickle, Cheese. A Bundle would be called a Cheese Burger and it would be made up of several products like Hamburger patty, cheese, lettuce, pickle, etc.
I have sales people and they need to enter the items that they sell. I have a value list (drop down) that populates from the product name field. this is working perfectly, however I have two additional needs that I am struggling with.
1. Each product within the product table has a number field called (sold individually). i use it as a true / false field. 1 = true 0 = false. some of the products we carry can not be sold individually but are still products. Similarly you would not sell a piece of lettuce individually, but you would still need that product on a cheese burger. I need to populate the value list with products that have the "individual sale" field set to 1.
2. I want to include all bundle names within the bundles table in the value list as well.
A salesperson will click on the drop down and get presented with a list of all Products that contain a 1 in the "individual sale" field and all bundle names. Alternately I want to add some additional text in the value list to show a separator to delineate between products and bundles. This is optional at this point.
Any direction you can point me in would really help out. My initial thought process is to create a table that I can populate with all of the products that have the "individual sale" flag and all of the bundle names by looping through the table assigning everything to variables to be displayed. I think this is a lot of work and could be prone to errors.
thanks for your direction in advance.