Toni

Hello I am having an issue with SMTP send email script step. The email sent is one hour ahead. FM server is version 16.0.4.406. The SMTP server is not in my possession, but I made a test of sending an email by logging to it from web and the time is correct. I tried it by setting gmail SMTP with my account and the time is still not correct. So I suspect this is a FM server issue. The FM server runs on a Windows Server 2012 which is installed on an ESXi. Both times on Windows Server and on ESXi are correct. Even stranger is the fact that if I use data viewer in FM Advanced with variable to watch Get (CurrentHostTimestamp) it shows the correct time. Any idea what the issue might be?

Yes comment, that can be used too, but it would still involve a find on Table_A since the update matching records works on current found set. Beside, who knows, maybe in future it will not be needed to update the imported records because of possible editing of the records.

Hello I have a database which imports data from a csv file. This csv file is generated by a machine usually every day. But it does not delete previous data, it just generates the whole data it has on the same file (overwriting it). Obviously I don't want duplicated records in my database. The first solution was to actually delete the whole records and re-import them, but this wasn't the preferred solution. So I thought of a second solution which I would like to share for any advice. I created a second table, Table_B with same fields as in first table Table_A. Then added a relation between the two tables where Table_A::field_a = Table_B::field_a. Then created a calculation field in Table_B which is equal to Table_A::field_a (Table_B::field_related = Table_A::field_a). The import has two steps, first I import from csv into Table_B then I perform a find where Table_B::field_related is empty and then I import what is found in Table_B into Table_A. I remember I have read time ago, in this forum I believe, a similar solution with related tables but different approach. Can not find that post. Do you think this is a good approach or can something be done differently?

That is worth a good laugh for hours. I found it out myself while you posted it, and it hurt cause age has definitely caught up with me 🤣

Hello I am experiencing a strange issue with the Inspector. It will not show field options, changing a field from edit box to Pop Up Menu for example. I am attaching a picture of what I see. I am working on FM 16.04 at the moment and the file is hosted on a server. I updated the server a couple of days ago to 16.04. I tried to connect with FM 17, still same result. I created a file locally, still same issue. I created a new user in Windows 7 and logged in to it with same issue again. What could be happening?

Hello I have a situation where I need the page to be set at A5. The output of the report should be on A5. But the printed document should be two of the same page on an A4. It should be two pages per sheet, or two copies on an A4. Any idea how to accomplish this within FileMaker?

Thanks Steve Hopefully I can solve it the way you did. Will come back and let you know with results.

Hello I am having trouble on printing a layout on a dot matrix printer Epson FX-890 with FileMaker16. The database runs on a server. The page is setup in "Letter" format but FileMaker interprets the width smaller than 216mm resulting in starting a new page. In preview mode it shows the truncated page (sth like 140mm x 279mm), if I change the paper format to "Letter fanfold" it shows correctly in Preview but still prints as if the width is 140mm. I tried various drivers for the printer to no successful result. The same layout printed correctly before on FileMaker11 on the same computer, the only difference is that FileMaker11 didn't run from server. Computer runs on Windows7 x86. My guess is it is a problem of how FileMaker interacts with printer drivers. Anyone else has had trouble as described? Any possible solution? Thank you

Hello, I am struggling to make a send event work and I am running out of ideas so a bit of help is needed I have a script which will create a file on the desktop and then email it. After it is created I want the file deleted. Here are the steps of the script which deal with this need: The first one will create the path and filename to be created and then emailed Set Variable [$file; Value: "filewin:"&Get ( DesktopPath )&Substitute( GetAsText ( Get ( CurrentDate ));"/";"")&"_Report.pdf"] The second one will create a variable to be used in cmd as parameter for the del command Set Variable [$filedelete; Value: Replace ( Substitute( $file;"/";"\\");0;9;"")] The last one is the send event step Send Event ["aevt"; "odoc"; "cmd.exe del " &Quote($filedelete)] Unfortunately this will not do the delete, I see the cmd window with path positioned on local desktop which I have moved on disk D ( D:\Desktop>). Using data viewer I can see the value of $filedelete variable is correct, if I copy that value and paste it into cmd window the command will execute correctly. What am I missing? Maybe I need to send the execute command after the line is send (like pressing enter from keyboard if you run the command from cmd)?

I am still on FM11, but as you're asking I am planning in near future to upgrade at 16. Have delayed it because of the not so funny experience when upgrading from FM5 to FM7. Reading documentation about moving from .fp7 to .fmp12 and it sounds smother than from the previous I had at the time.

Thank you both, didn't know these were called audit I had a look at those audit solutions and are very useful so I will definitely give a try on those. I have some sort of things like those already in place. Anyway, I was thinking more on the line on keeping track of the changes to the database made by myself. So I will also try a solution of building a table for this very purpose. I develop for two customers who are in the manufacturer business and they come with every sort of idea every other week so it is becoming increasingly hard to remember why I created one field or one script. The nature of manufacturing is very flexible and changes in lot of aspects, like line of productions, models, etc. so the database has to adapt fast and needs to be tracked. There are even things which are temporary because they are related to a specific product which might be in place for three months for example.

Calendar View File I created this solution because I wanted to have each day as a record. The purpose of it, is assigning working days (business days) an incremental number so that number can be used in other related tables on which is required to calculate working days. It has two main scripts, the firsts populates the year. After year is populated, than holiday days are assigned manually but you can add script at your needs. I left it manually so you can be flexible with it. Where I live is not uncommon to have to work even if it might be a holiday, so every company has different needs. After holidays have been assigned, there is a second script which will define the incremental number of working days. On the holidays this number is equal to the number the nearest next working day has. For example, if 28 and 29 of November are holidays the working day for those will be 282 the same as that on 30 November. This helps in cases someone assigns a job that starts on holiday and calculate the end date of that job. Any idea or contribution to make it better is welcomed. Thank you, Toni Submitter Toni Submitted 02/22/2018 Category Samples FM Version 12

Hello With small to big changes made as often as customer requires and age hitting hard on me , I've come to think about noting somewhere these changes, keeping a log file of them. I think some of you might already have in place such practices. So, what are your best methods in keeping track of what has been done through the years? Thank you, Toni

So you have no problems with that? I do click on one of the fields first, that's a given. Starting to wonder if it is a keyboard related issue or Microsoft Windows