Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Toni

  • Rank
  • Birthday 04/27/1974

Profile Information

  • Gender
  • Location
  • Interests

FileMaker Experience

  • Skill Level
  • FM Application
    11 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Windows 7, Windows 10

Recent Profile Visitors

1,242 profile views
  1. GetSummary from two related tables

    The language is italian and albanian, both used (don't ask me why ). The menu is just a customized one, one can activate the standard with no problem. The files missing in relation are of no importance, can be ignored. The data is there to help with summaries, are not of great sensitivity, it's just a very small portion of the whole. I see what I can do to make an imitation of the database without the hassle this one carries. Thank you Lee
  2. GetSummary from two related tables

    Yes, sorry about that, the common mistake. Had in mind to change it but forgot. I am attaching the file with user: admin and no password. ComNuovo Clone Copy.zip
  3. GetSummary from two related tables

    Thank you Lee, so here I go with actual field names on the database: The database has 7 tables, but those at our interest are ComNuovo Inventari Raport_Ditor On ComNuovo table there is a summary field called Tot.Capi from where I want to get the summary when ordered by field=Rep. On Inventari table there is a summary field called TotaleCapi from where I want to get the summary when ordered by field=Rep. Both summary functions will be calculated on table Raport_Ditor where I have two fields Dalje_ComNuovo_Copy and Dalje_Inventar_Copy. On the Raport_Ditor I was planning to create the records by script, but they can be created manually by filling only Rep. field and Date field, the rest is calculated. The field that is used to relate the tables is Date_Rep. I am attaching the file.
  4. Hello guys I am really struggling to get this job done which seems pretty easy. I have two tables, let's call them Table A and Table B. On table A I have records of the product flow into the production chain (product goes from phase 1 to phase 2 and so on). On table B I have records which tracks the movements through export from Table A. So table A will give me the situation on every department of the chain production, while Table B will give me totals based on day or hours or month etc. I have created a third table, Table C, on which I want to get a day by day situation from the above tables. On table C I would want to get the summary from Table A and Table B. I have created a field on each table based on date and department which I use as relation from C to A and from C to B. While I can successfully get the summary from table B I can not understand how I can not get from A. The field from A gets the total of B instead of its own. Table A Table B Table C field1=department field1=department field1=date field2=product unit code field2=product unit field2=department field3=quantity product unit field3=quantity field3=getsummary tot department on A field4=date field4=date field4=getsummary tot department on B Table A and B may look the same, but in A the product unit exists only once changing its department every time as it moves forward showing where it is at that moment. On B, the product unit will have as many instances as many times it has moved, keeping track of its movements on every stage. Any idea what I might be doing wrong?
  5. Hello I am experiencing a strange issue with custom menu and CTRL+F keyboard shortcut when changing keyboard layout to albanian. The custom menu is basically a copy of the default menu with some items left out, not the view mode though. But when I press CTRL+F nothing happens. If instead I go to the view menu and click on find mode it switches to it and I can see the CTRL+F shortcut on the side of the menu. Also, if I first go to layout mode by pressing CTRL+L then it works by pressing CTRL+F but will not work back again. If instead I switch to the default menu, all works fine. Issue is verified on two PC, both with Windows 7 and FM11
  6. Well, I am not gonna revisit this script again in a long time and probably will forget the logic behind it . Having a field which will show the result of the calculation will help me remind about it.
  7. I think I am getting there. For the calculation of folder name, I used the formula suggested by @comment. Great tip Then searching and testing, after some time of both, managed to come with a script with send event in it which creates the folder from there. Script steps: set variable [$path; value:"D:\Docss\FileMaker\GestProduzione1\\"] # here "Table" is the table of FM and "Make_Folder_prev_month" is the name of the calculated field send event ["aevt"; "odoc"; "cmd.exe /C MKDIR " & Quote($path&Table::Make_Folder_prev_month)] One thing which I don't understand (and I hate it) is why I need to add a backslash at the end of the value of $path variable. Is the extra backslash to indicate end of the string? Shouldn't be enough a quotation mark? Thank you both for great input. Very happy with it.
  8. Thank you both, great contribution I chose to export it into a cmd or bat file because obviously I am not that good to figure it out by the send event :). I will try some more and let you know, it's late around here and will try it tomorrow
  9. Thanks Wim for your reply I tried it and it won't create the folder. See, this character is somehow inserted in the file. I can not see it when I open it with notepad, but when i try to execute it within cmd window it shows up. Even if try to execute the date.cmd file by double clicking it won't create the folder. Funny thing is that if I manually copy the content of the field from FM and paste it in the cmd window it will execute normally. This character is inserted during the export. I have defined the field, in the language option as unicode.
  10. Hello I am trying to automatically create subfolders in Windows which should be named year_month, like 2016_11, 2016_12 and so on. This will be done once the month has passed, probably around 10 to 15 of next month. For example, on the 15 of November 2016 a folder named 2016_10 has to be created. I have managed to create a calculated field which content is exactly what I need. Below is the calculated field: "md"&" "&( If ( Middle( Get ( CurrentDate );4;2)="01" ; (Middle ( Get ( CurrentDate );7;4)-1)&"_"&"12" ; Middle ( Get ( CurrentDate );7;4)&"_"&Right(0&(Middle( Get ( CurrentDate );4;2)-1);2))) Then, a script, exports this field content into a file "date.cmd" in the folder I need to and is set to automatically open it. So, what I expect is command line file which simply has as content "md 2016_10" and when executed it should create the folder. Thing is, it doesn't. When I open cmd and execute from there the created file, I see that there is a black square character preceding "md", thus cmd responds with " '■m' is not recognized as an internal or external command". I suppose that is some character added in export, during translation from field content of FM to the text file of windows. Any idea how to solve this?
  11. Import XML how to

    Thank you @comment for the sample. I will play a little bit and come back with some results if I can
  12. Import XML how to

    I didn't wanted to bother you guys with an attachment. It wood look like I am looking for you to do my work Since you asked, I am going to attach it. I deleted a great part of the file, because it is really big. If you open it in Excel you would have a better understanding of what the fields are. Thank you all for your replies. As I understand, first I need to learn the XSLT language, but I should understand the FMPXRESULT as well, right? To have a better idea, the XSLT is a file whihc tells FileMaker where to pick the fields from the XML, or it does transform the XML into another XML understandable for FileMaker? Is one XSLT file enough for many XML files, or would I need an XSLT for each of the XML files? 2015-01-11_Arbane1.zip
  13. Excuse for the rookie question, but I can't figure out how to import an XML file. I understand that it needs a xsl stylesheet. But how can it be built? Funny thing is that Excel can import the file, it detects that it does not have a scheme for it, but creates it on the fly. From excel I can import the data, but I don't like to go that route. So how can one built a xsl style sheet for filemaker? The xml file I want to import is in fact a tcx file of bicycle rides, and they are xml actually. Any help? I understand the question is a bit general, but any pointing to the right direction would be helpful.
  14. Yes comment, you are right, it worked. I did forgot to put filewin: at the begging of the calculation. what I finally did was: "filewin:/D:/Desktop/m"&Right (ComNuovo::Data Fattura;2)&ComNuovo::Fatt nr&"."&"txt" ComNuovo is the database, Data Fattura and Fatt nr are the two fields of the database which I use to name the file. Best regards, Toni
  15. Well it didn't, but now that I am thinking I didn't put "filewin:" in the variable calculation which probably caused the problem. I will try once more tomorrow. Thank you again.

Important Information

By using this site, you agree to our Terms of Use.