Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About rudym88

  • Rank

Profile Information

  • Title
    I.T. Director
  • Industry
  • Gender
  • Location
    All over the world
  • Interests
    Computers, networking, and solving difficult issues

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    Windows 7 64

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. rudym88

    Import best practice

    Good day gurus, As usual seeking some valuable advice. I am currently importing a price list, the source is a tab delimited files, I am doing a one-to-one import and all works perfected. Now the boss is requesting to be able to compare the last imported price with the previous import. What I was thinking was to create an additional table (e.g. import one, import two,) and adding a import date field in order to identify when the import was done. Then create a script to empty the second table, move the records from table one to table two and then importing the new data in table one. Can someone give me some ideas as I feel i am trying to reinvent the wheel Thanks Rudy
  2. Hi gurus, I'm seeking some advice on the best way to accomplish a task. I have a tables with about 110 fields, and i need users to be able to insert data into three fields at a later time via a popover. To accomplish this I am considering two options. Option 1 - place the fields in a popover and have the users populate them with the required data, in the pop over there would be two buttons one to close the popover which would also clear the entries and the other to commit and close the popover. Option 2 - Create global fields and place them on the popover where the users can enter the data and once a "Accept" button is pressed the data is committed and popover closed. The question would be, is using global fields to enter data on an existing record a good practice? Thanks Rudy
  3. rudym88

    DDR not working

    thanks for the reply, For this solution I am using FM Pro Advanced. I can't user 16 or 17 as the file is hosted on a Ver 14 server. Thanks
  4. rudym88

    DDR not working

    Goo day everyone, My apologies if I am posting in the wrong section. I am having an issue running DDR. First whenever I tried running DDR "HTMP" I would get a message that DDR was missing and required, after researching I created a DDR folder in c:\..extension\English\ folder. After creating the folder I stop getting the DDR missing error. Now I am able to enter a name for the DDR but as it runs I get the following message; "The file "summary.xsl" could not be found and is required to complete this operation "The file "Frames.xsl" could not be found and is required to complete this operation "The file "detail.xsl" could not be found and is required to complete this operation "The file "Toc.xsl" could not be found and is required to complete this operation It does create the individual files but empty. Thinking is my database I have tried creating a clean database but still get the same error. Any help is greatly appreciated. RudyM
  5. Hi all, I am sure this is a simple question for must of you, but for the life of me i have looked at different samples and cannot get it to work. I would like to create a new record from a popover. I started by creating a script with "New Record/Request" step. then i assigned the script to "OnObjectEnter" script trigger to the popover itself, the script does create the new record but the popover does not pop. What I am doing wrong. Yes, once i get this part to work i plan to add over actions e.g. what happens is "cancel" is press, or is the users closes the popover.
  6. Hi gurus, Need some advice, I am putting together a job tracking system for a print-shop and I am running into a dilemma where I need some advice. Our ERP is Sage 100, but unfortunately I have not been able to retrieve data from it using ODBC, it appears File Maker ODBC is not compatible with SAGE as I keep getting an error (it works fine from excel but not filemaker). I am currently exporting all the needed data to various CSV files and importing them into a single filmmaker database with a table for each CSV. some of this tables contain as much as 30K records. my issue is with speed. every time there is a lookup it sometime takes a few seconds. My question is, if I import the data to the main database would the lookup's be any faster. Thanks for any help
  7. rudym88

    Sage 100 ODBC

    Hi guys, I am trying to setup an external connection to Sage 100; From Windows I have configured the "System DSN" and it is able to connect and see 1129 tables. From Filemaker I am able to add the external data source without any issues. But when I go to Manage->Database and try to add table under data source I select the new data source and a popup asks me for a username and password but then it give me the following message "The ODBC data source you have selected is not supported" Can someone guide me on what it is I could be doing wrong.
  8. rudym88

    CVS file import

    Good day FM gurus, I am having an issue when importing a "CVS" file into FM. I am receiving a daily file from a PBX, this file is in "CSV", one of the columns contain the start or the call and is formatted "11/9/2016 7:17", but when I do an import into FM it imports its as "2016-11-10 07:44:24", yes the field is formatted as a timestamp. The only way I can get the import to work, is if I open the file in excel and save it at "xlsl" then it will import it as a time stamp. What am I doing wrong.
  9. rudym88


    Good morning, Having absolutely no knowledge on ODBC integration with Filemaker I am seeking help for the community gurus. I put together a database to keep track of printing jobs and so far its working fine for us. The issue I have now is that some of the data we enter in FM comes from out ERP (sage 200 4.3) and I would like to create a lookup that would retrieve this data via ODBC. We use filemaker server and FM 2013 for the end-users. I have the following questions. 1 - do I have to installed the Sage client on the server or do I have to have on each user? 2 - when I configure the ODBC do I configure it on each client or only on the server t retrieve the data from sage? Any pointers to ingrate with Sage would be greatly appreciated. Thanks in advance for your assistance. RudyM
  10. Good morning all, I am trying to insert two portals in a form but, I have followed other samples but for some reason I cant get it to work in my database, I am attaching a sample of what I am doing hopping a guru can tell me what I am doing wrong. In short I have a ticketing system and I want to be able to enter ticket status on one portal but at the same time be able to view the status history in a portal below. Thanks Rudy Portal.fmp12
  11. rudym88

    TimeStamp Calculation

    Thanks for the reply, how about if I want the minutes and seconds. Thanks Rudy
  12. Hello FL gurus, I am trying to create a calculation using the "Timestamp" function but can't get the result I need. I am hopping someone can guide me. I have three two fields and two buttons Start Time (button once press it enters the time in the field using "Set Field" and "Get (Get ( CurrentTimeStamp )" End Time (button once press it enters the time in the field using "Set Field" and "Get (Get ( CurrentTimeStamp )" I also have a calculation field (Start - End) with a result of "timestamp" is if possible to ger a result to show elapsed days and time e.g start 1/1/2016 1:00PM - end 1/1/2016 2:00PM I would like the result to be 0 day and 1 hour e.g start 1/1/2016 1:00PM - end 1/2/2016 2:00PM I would like the result to be 1 day and 1 hour or I am better using two fields one for time and one for date Thanks RudyM
  13. hi all,  I have 3 field (see attached for layout)  field 1 is a checkbox field 2 is a pull down field 3 is a date  field 2 and 3 are placed on top of field 1  the issue I have is the if I place a check on any of the option on field 1 I can no longer select field 2 or 3, if there a way around this?   Thanks RudyM
  14. rudym88

    Selective format

    Hi all. Hopping a guru can enlighten me. I have a field called "Service Performed" next to this field I have bottom with the below script. TextStyleAdd(TextSize(ticket::Service Performed" & "- " & Get (accountName) & "- " & "" & Get(currenthosttimestamp) & "Enter" ; 12 ); Bold) The basic idea is as users are typing and a new event needs to be entered a users would press the bottom and a time stamp with the username is inserted. It works find except the formatting. Now what I would like to happen is to either bold or change the color of the inserted line. but what I get is the entire field in bold. Is this possible. thanks RudyM
  15. rudym88

    Layout with data from multiple tables

    Thanks, It works like a charm

Important Information

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