Harry

Hi Board! My FM solution has multiple clients running from FMS13. There is a script that the operator runs from a button that takes data from their screen and prints a label. If I want to have networked printers, how do i specify that printer within the script? If 3 operators have 3 separate FM clients and next to each is a networked printer, how do I get the print job from Operator 1 to print out on Printer 1, and Op2 out of P2 etc etc? If I make the script and it is called by the operator, won't it specify the printer that was originally specified in the script, rather than the one that the client is physically next to it? How do i approach solving this problem? Thanks, Harry

Yea, OK! Sorry... Months is my SUM table. I have a 'Works_Orders' table. I have a 'Products' table. I have a 'Jobs' table. Joined like this: Works_Orders::Stock_Code = Products:Stock_Code. Products:Job_Group_ID = Jobs:Job_Group_ID Products can share Job_Group_ID's so multiple Stock_Codes are made using the same set of Jobs (different colours, etc.) Job Groups have multiple Departments in them, with records formatted as: Job_Group_ID / Job_Number / Department / Time What I want to do, is in my Summary table (Months) Is show Count for the number of Works_Orders and the Sum of Time of those Works_Orders, *Per Department* I have the Count, which was easy. But I don't udnerstand how to specify the '...Per Department.' bit. I have Globals in my Summary table that i use to establish relationships to these other tables, such as 'Start_Date_Of_Month' and 'End_Date_Of_Month' and also department names 'CUTTING' and 'INSPECTION'. I can't link from my Summary (Months) table through Works_Orders, through Products and into the Jobs table, how do i 'carry' the Department through to the Summary table? I just don't get it.... Sorry for not being clear. I'm sure this is very simple if I can understand it.... Should I set Global fields of those Departments into the Products and Works_Order tables, so I can link each one to each one and then into the Summary table?

Yea, it is a network issue. It's in a factory amongst a jungle of 3phase 415v power routes. I was hoping there'd be some way to report on the connection status, then if that changes, run a connect to server script. OK, looks like the weekend will be spent on a cherry picker coiled in cat6. Thank you for making sure that isn't a waste of time! Harry!!

Hi Board! I have Server 13 and a client that keeps dropping the connection over wifi. I can't put a cable there and run directly over ethernet. Well, I could, but It's not really an option. Is there a way to get the client to reconnect when the connection is dropped? Harry

It's like i need to take the Shipping:Stock_Code field with me through the 'join' table of Orders.... Don't get it!

Hi Board! Here's a problem I have, that i just don't understand from a Schema point of view, on a basic level. I've tried to do this sort of thing before and failed, but now i really need to do it, so I've got to learn. Can you help me understand? What sort of relationship is this, that I need? How do i do it? I have four tables: A 'Months' table - summarises data by the month for display on an automatic Dashboard A 'Shipping' table - logs products going into boxes being packed. An 'Orders' table - order headers An 'Orders_Item' table - the order lines for above. The last three are giving me the aches.... (I'm only listing fields that are concerned with this issue) <Months Table> Year_Month <Shipping Table> Order_ID Stock_Code Time_Stamp Year_Month_c <Orders Table> Order_ID <Orders_Item Table> Order_ID Unit_Price Stock_Code Relationships: Months:Year_Month (e.g. 201501) = Shipping:Year_Month_c Shipping:Order_ID = Orders:Order_ID Orders:Order_ID = Orders_Item:Order_ID In Months table, I'd like a 'Total_Shipped_Price' field that gave me a Sum of all the 'Unit_Price's of each product that has been put into a box. ....This then shows on a graph on a dashboard that updates minute by minute, showing how much has been packed. (I have the dashboard showing forecast sales and actual entered sales per month. Now I want to show how much has been shipped out.) Of course, because there is no 'Stock_Code' in 'Orders' If I relate as per above then I lose connection to the line by line, stock code by stock code details. I have my 'Shipping' table and I cannot get a 'Unit_Price' per record. That's what i'm after. I can't figure it out and I know this is basic DB stuff. Can you point me in the right direction? What should i be reading about? Thanks!

Wim?! WIIIIIIIIMMMMMM!!! I made a new DSN on the server, using the same 64bit MySQL drivers, naming it 'DSN32bit' (etc. etc.) and it works. You did it, Sir! Bowing, bowing oh Great Leader.

I can see a 'Filemaker Script Error' in the Server Admin panel.

OK, I need some help with this after all..... I have the script - Go To Layout (Orders_FM) Show All Records Delete All Records [No Dialog] Import Records <Here's the SQL Script I built in FM> [sELECT `sage_SALES_ORDER`.`ACCOUNT_REF`, `sage_SALES_ORDER`.`DESPATCH_DATE`, `sage_SALES_ORDER`.`INVOICE_NET` FROM `sage_SALES_ORDER` WHERE `sage_SALES_ORDER`.`ORDER_DATE` >= '2014-01-06 00:00:00'] Exit Script. This is set in a Schedule to run every 5 mins. So - I'm on the Server with a copy of FMP open working on that script. Within the 'Manage Scripts' window, I can click on the Run button and the script works. But, when it runs on the schedule it only deletes all records and leaves the table blank, skipping over the SQL bit. I'm running it with full access privileges. Thanks for any advice you can give - this is my first server-side script Harry

Yes, that's what I meant. OK, great. Thanks again. I have logged on to our server and built an import SQL script and it's working perfectly, thank you! Cheers! Harry

Ahhh. OK ok! So when I am selecting the fields (Layout Mode|Add Field etc.) that is the server DSN? Is this 'Show/No Show' a bit of a bug type thing or is there a reason for it? Cheers and thanks again for your time. Harry

Fantastic, thank you for the clarity. I still don't get why i can't see the DSN's, though. I'm on a local Pro Advanced seat and I can see the DSN's, but while building that script, I can't. Where you say 'you don't see (it) because it is on the server.' has confused me a bit! My apologies. Harry

Hi WIm, Thanks for answering. I'm not sure what an ESS table is, so please excuse my ignorance; I may have misunderstood. The summarised calcs only work when exported to native FM tables, not when they are External. I showed that in a quick test I did, using duplicated table/field values from the External SQL. Presuming here that this script should be run server-side? I haven't done any scripting from the server yet. I have access to the SQL tables via the Relationship Graph and in Layout mode, but when I got to the script step 'Import Records' and then 'Specify a data source' the SQL ODBC connection isn't listed; should it be? Thanks again, Wim! Harry

Hello Board! I hope you're all well into the swing of 2015 by now! I have an External SQL Data source. There is an instance in my RG and I can duplicate it into other instances and read/write to it no problems. But, charting summarised calc fields from it doesn't work. If I import all of the records into a native Filemaker table, these summaries (Not Summary fields, but calc fields) do work. So I'm trying to find a way to automate/script this import. I do not want to go File|Export To|....zzzzz.... process every hour of every day. If I can build a script to do it, that'd be great. I can Copy All Records, but I can't paste them. I can set up an Export script step, but it wants me to specify an external data source to export and it's messy. Is there a better way? I will go to the SQL table instance, copy all records, go to my table instance, select all records, delete all current records then import the new updated set. Thanks! Harry

Happy New Year! I've got a Bar Chart, months along the bottom, money on the Y. It works well, it's built on automatic date building and summarising for a KPI dashboard type display in an office. I want to add another summary field, the first one is a 'Projected Sales' figure. The second one is an 'Actual Sales' figure, a third one will be 'Sent Sales'. Because i want to display the three bars on top of each other, rather than by the side, I was planning to build the first one and then cut/paste two on top, changing the colour and field for the Y. That way, the 'Projected' figure is in red, as Sales come in and are entered onto the computer system, they build up and the second field Bar grows in Orange over the top of the red bar. Then, as products are being shipped out, this links to the SOP_ITEMS table and builds the monetary total of what has actually been shipped. All the numbers are working from what I can see. Does that explain what I'm trying to achieve? My problem is that the second copied chart changes the size of the x dimension, so that when placed over the top and centered in edit mode, the Bar Chart on top is bigger than the one underneath. The labels are further in, the bars are different sizes. What am i doing wrong? I can't figure it out at all.... Is it something to do with the way i'm summarising the numbers from different sources? Or something simpler? Thanks and I hope you are all feeling good for the new year!

Brilliant, thank you very much Comment! Don't know why it was working before and now it's changed. But that's moot now it's fixed. Thank you. I had no idea the timestamps were all calculated differently like this, thanks. Harry

Actually, scratch that. It doesn't work if i try to set it to '22'. It does set the time correctly but not the date. The date is always 01/01/0001

Hi Board! I have a User Interface that allows scanning and registering and validation of loads of information. The last part of the script scoops up all the inputted data and then sets it as variables and then writes to a table. The last step is: Set Field [Job_Logging_Home::Timestamp_Scanned; Get (CurrentTime)] It has been working fine for weeks and then has stopped working. I've checked through and the data is being written, but the Timestamp is returning as 01/01/0001 01:01:01. The Client machine that is running the script has the data correctly set. If I add a 'Set Field [Job_lo.....::Timestamp; 22], for example, it writes to the table as 22. So somewhere along the line it is not Get(ting) the correct time. Can anyone help with some guidance of where i should look for this solution? Thanks, Harry

Perfect, thank you.

Just does not seem to work doing a 'From 500000' to '509999'. Some codes might be '501111-11' or '50EDA1-89' Can you offer some help with the Custom Function? I have only used one once, a long time ago; and it was pre-prepared. This is what i have: It's the MultiKey you linked to. Case ( Length ( Text ) > 1 ; FieldBeginsWith ( Left ( Text ; Length ( Text ) - 1 ) ) & "¶" & Text; Text ) Do I just write out the Field in those parenthesis for 'Text'? (i.e. Dashboard_MONTHS:Data_Search_Text) and then again for each of the Text occurances within that Case statement? Cheers,

Thanks Comment. Some of my stock codes are 501234-56 or 505432-12, so they're text fields. I'm not sure my GrtrTh/LessTh Global fields are working on those text fields.... could that be the case? If it is, I will need to look into these exploding multi keys!

Hi Board! I've read a couple of threads on this, but i'm not getting it.... I have a Months table, that calculates the months (36 records for historic charting). I have a joined table occurance, 'Products_Checked'. This lists all the products that have been checked, other details, and their date/timestamps. I want to chart a Count Per Month of Products Checked. But i want to only count certain products - namely with a stock code that starts with ' 50 '. I have a Global field in the Parent Months table that is my 'Search String' but if I put 50 into it, the graph doesn't work. If i remove the relationship for this search, then the Count works for all products. I have tried putting in 50*, which works for a search, but not for a graph. How do i put a wildcard search string into a relationship for this type of filtering? Thank you again and again. Harry

Sounds like exactly what i need for the entire system! I will look at this and start setting it up.... Thank you!

OK SOLVED! This has just cleared up a whole load of issues I was having, thank you so much everyone! I don't think I would have found it by myself. In the end, i built a script that sets all of the Global Fields i need in relationships as text strings. Then, I have another script that runs the Dashboards, you call the script and it opens a full size window, and starts swapping between three Dashboard screens i have setup. The start of this script calls my Global Script and it works completely. I've only had to set permissions to my Dashboard client to have execute rights on that script and it's done. Thanks again!!

I have no idea what the separation model is. I will search and find out, thank you. I have also not done any work with FM-to-FM external data sources, so i will need to experiment. I was hoping that sort of link would be handled by FM. The idea of reconnected all my TO's scares the bejesus out of me!! Thanks for your input.