Jump to content

Jonas Mächler

Members
  • Posts

    6
  • Joined

  • Last visited

Jonas Mächler's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. thank you very much for the idea, very nice one with that global field. But I've convinced myself to create a third table..
  2. and what if it isn't a 1:n relationship, but a m:n? (Full explanation of my problem in my post)
  3. Hello Time-Experts my problem is as follows: I have one table with invoices I payed. They are for services in e certain time-period, let's say from February till October, on one invoice-record, In the second table there are my Customers. They worked with me for other time-periods, let's say, one from January till March, one from March till September and one from September till December. Now how can I calculate the intersection-times? I'd like to see my original invoice with a portal where I have listed all those customers which will pay a part of the invoice. Something like this: ------ Invoice A | Service from 02/01/11 till 10/31/11 | (273 days) | 1'000 $ PORTAL: - Customer 1 | between 01/01/11 and 03/31/11 | (059 days) | 216.10 $ - Customer 2 | between 04/01/11 and 09/30/11 | (183 days) | 670.35 $ - Customer 3 | between 10/01/11 and 12/31/11 | (031 days) | 113.55 $ ------ Everything is clear, except how i could calculate the duration of "time intersection" I have all the data (dates) I need in these two tables, so i don't see why i would need a third one.. does anybody have any experience with such a problem?
  4. Hello together I have a FM-script running as a schedule on my FM-Server and it's producing "errors" such as the beloved 401 NoRecordsFound (which imho is no error) so it's consequently spamming my Server Event Log. As ErrorCapture is not compatible with the server environment, does anybody have an idea how to prevent this from happening? (My script is going to run hourly and is checking 24 tables for journal entries to process them into the journal-table... so, it matters otherwise it's going to be a LOT of entries)
  5. Oh.... It would have been too nice... I was already suspicious, because I've never read about somebody interacting between FM and SOAP like this, now I know why... But a local php will help. I'd say to call that field "HTTP-Request" is a bit exaggerated by our dear friends @ FileMaker's But thank's Comment you've helped me saving a lot of time!!
  6. I have the same problem there, a happy note saying but as you see from the Message, I'm trying to use it with a HTTP-Request (which is tested and working!) and I'm not using any Plug-Ins (I'm against it ) But Filemaker doesn't even try to connect to the Server provided in the HTTP-Request. Has anyone ever had success with such a HTTP-Request?? Or am I getting something completely wrong? (I am trying to send a SOAP-(HTML)-Request to a webservice from which the response is transformed with a existing xslt and imported to FM)
×
×
  • Create New...

Important Information

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