Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Don_Macaroni

  • Rank
    Pretty Pro
  • Birthday 08/19/1976

Profile Information

  • Gender

Recent Profile Visitors

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

  1. I have a customer that uses 4 stations and still uses FMP 11 (database was created in version 9, I believe somewhere around 2008)... They (still) do not want to spent 4x $299 to upgrade to the latest versions. One, because everything works, so why? Second, because in their view they use the database, not the app with all of it's features they don't use and never will. Adobe made Elements, basically a limited version of Photoshop. I still believe a non-layout version would be a great addition to the line up. It would sell like hot cakes and for sure be appreciated by developers and (small business) end-users alike... FileMaker Go for Desktop indeed sounds nice, did not thought of that before.
  2. What do you think about an affordable Filemaker Pro Layout-less license? I explain: As a developer, and small business owner, I often run into problems selling 4+ $299 Filemaker licenses on top of my developer fee. The $299 x 4+ equals big bucks for a small business. And 10 out of 10 times, the people working with my database, never go to Layout mode. I am suggesting an affordable layout-less license for small business office use. (You would still need a regular license to update the database) I am convinced fellow-developers run in to this as well. Please sign the petition to see if this can be accomplished. Official Petition to be sent to Filemaker Inc.
  3. I challenge anyone to decrypt this... Even with the verify weblink, which is not available normally, I think it will be hard to impossible. Just added a better hash which adds lower caps and numbers for more randomness. Oi23825l7455 oP47247E0887 VO957142K378 13739448P283 0f78772Ok163 https://fieldsmedia.com/verify/
  4. Maybe a little too enthusiastic with 'super secure', but thanks to the 'constructive' critics ;-) I was able to better the concept. Random string is checked for doubles prior to being calculated, added double letters to the sequence, made the hash longer and made the calculation more complex. SQ66450CB119 AM12264BR442 SD76146FA698 FA78819SW656 https://fieldsmedia.com/verify/ If you give away the key of your SSL certificate, hackers can decrypt it and your doomed. Same here, if the calculation and hash are known, it would be an easy game. Hackers will always go for easy pray first, and base their attacks on what's at stake (decrypting chair tags would not be one of them). In this case it is not an easy task discovering a 800+ string hash and calculation. In my opinion the concept of creating secure unique id sequences, as an alternative to 'open' sequentially numbered ones, is great and something to dive into. For example, lot of companies use sequential numbered barcodes as customer ids. This is easy to duplicate and the system will accept it as usual. If the system could check at id scan if a card is genuine or not, that would be great.
  5. Got some numbers here, generated in Filemaker with a different formula than described above... Y74173N355 G06493Y759 G31838W608 T91983H414 W03699M112 X80284G309 U89344M788 H41948W509 J07854R652 X41583B633 W71034X431 T63546G371 A21734J047 A40260U124 G06500Z626 Z70316G696 B44227R409 D95958K519 G37676K811 R64986D515 Y89980P698 E21673G203 J14951M324 H18747J139 C12631G989 N44233Y131 K76552V582 B25520M706 M47966M194 C54096P508 V45181A942 M54891C968 C46686K554 B59307H098 N44677W353 N94671M631 X41505C241 P31948S471 U14764P595 E45007M706 For the ones that want to reverse engineer it to see if it is easy or not, the numbers can be verified here. https://fieldsmedia.com/verify/ I programmed it with PHP, reverse engineering the string. Another fact is, by using a string longer than the 24 characters used (26 minus the I and O I took out for confusion), the chances are real that certain combinations/calculations are wrong, but result in the same letter. This can be avoided by using double letters instead of one. But as said, this was never intended to secure data from hackers. It is not a password, nor will it give access to the FBI's Area 51 documents. It is a way to generate unique ids that are virtually impossible, or at least very hard, to crack by the average Joe. Also, I have these programmed on an rfid card and they are not displayed in plain text on the card itself. So you would need an rfid reader as well... I think it is pretty need and very usable for its purpose. Hope it helps somebody with something, you can take this a long way and expand it greatly.
  6. The formula listed is an example of how to implement a long verification string. It is not a login or password, it is an alternative to using sequentially numbered unique ids. It is not meant to give access to anything, therefor your arguments are not valid (they are in their respective sence). As said, I used this method to number 100,000 cards, which belong to a proprietary system I own. To prevent my customer from ordering stock sequentially numbered cards cheap from another source, I invented this. For my customer to discover my formula and 'secret' string to make 100,000 numbers that work would be virtually impossible.
  7. Because you know the formula stated you can do so. It is up to the programmer to use a formula and verification sequence that is kept secret.
  8. I sure can... It makes proprietary cards. I implemented this twice. Once in a system where a hotel uses cards to identify pool chairs. I supplied a system and barcode cards. By using this method I forced the customer to buy my cards, because cards with a sequential numbering will not work. And second on a harbor entry system. The system is unmanned and uses rfid cards with my numbers. Prior to the system looking up the person id-ing himself, it checks if the card is one of the system (and not some random id-ed card you can buy anywhere. It has huge potential and a wide range of implementation. With the 108 digit sequence you make any id card proprietary and protects the vendor from the customer outsourcing elsewhere. Unless you know the 108 digit key, this can not be guessed. Not in a million years.
  9. To all interest in creating a virtually bullet proof Unique ID sequence and reverse checker. I designed this concept for use on rfid cards for an entry system. But it can be implemented with barcodes, as well as reverse checked with PHP in case of a web-based solution. This concept grown from a need to verify the ID on cards. If you have a unique ID of 12345, a person can create a badge with any numeric sequence. But what if you can, as an added security, verify if the sequence is valid? Came up with the following: 1 Global field with something like this "QYUMGZRIHGHMIQSCEBYCWYWLNIPBCEZZCYBZIKJTGLKWGECGJBBQHXVCJQUHAMGWCOCGIAZNYNNOIJLBOSRVDMRFAVNPCOWFGGXNATEUKNPW" (Needs to be 108 characters long, which is 99+9. This will be the verification string.) 1 Number field which receives "Right ( Random ; 9 )" with a script (eg. 937493814) 1 Text field which receives a calculation via a script: - Split the 9 numbers into 3 sequences (eg. 937 493 814) - For each of the 3 sequences you calculate the character position in the verification string by adding the the third number to the first two. (eg. 93+7 49+3 81+4) This will never be more than 108. - The result of the calculation above is used to look up the letter at the specific location in the global verification string. You will get 3 characters. (N X R) - Mix the letters into the numbers to get a beautiful sequence; result 937N493X814R. This number can be easily reverse engineered and checked for validness. The 108 long string can be used in PHP as a var and used to reverse engineer the unique id, and so check it. It can be even more secure by giving each 3 digit string its own 108 digit verification string. It can be expanded to be more secure and more complex, but the concept is great. I find this method to be fast and secure, adding more is overkill. I auto-generated 1000 of these sequences and had them program as the UID on rfid cards. Now when a user scans his rfid card, Filemaker first checks the sequence to see if the card is valid. Then checks photo stored, to image on the security camera. What I also did was avoid certain letters and numbers from appearing. For example capital O and 0 look alike, as well as capital I and 1. So in my verification strings I don't use them, this keeps the strings nicer. Only downside is if you loose the 108 digit string you are scr3wed. Anyone interested in a sample file let me know.
  10. Don't know if this is still relevant, but if you only need the UID of an rfid card than buy an HID RFID Reader on eBay ($20-$30). The unique 10 digit ID on each tag will be your reference in the DB. Make sure the scanner is HID so it works just like a keyboard (plug in and scan, id will display in Notepad). You then make a script which is triggered by the 'ENTER' of the reader (the rfid reader works just like a barcode scanner and adds an 'ENTER' after each scan). You don't have so safe anything on the rfid card it self, all is done in filemaker. I tried too many times to write back to the card but it is too complicated.
  11. Thanks for the replies... Would be a nice feature if Filemaker had a menu function that allows 'flip horizontal' and 'flip vertical', next to the 'Rotate' feature that is already there.
  12. For a solution I need to horizontally flip or mirror text. I have a card printer on which I print transparent stickers. These stickers will be mounted on the inside of a window, so in order to be read from the outside the text needs to be mirrored (or flipped, whatever term you prefer). I thought of making a "Reverse" script and use a custom made font that has all characters flipped (eg. http://abc-font.com/font.php?font=Arial Mirror). But this seems a little complex...
  13. Been 3 days now... almost turning kookooh here. I created an awesome bar database where paper pencils and notepads are now iPads. Drinks can be selected and customized, all works flawless. Up till the moment I need to print. This is a no go. I kind of got a LAN receipt printer working, 100% correctly on the Windows 8 computer that shares the database. The LAN printer came with "iPosCloud" and supposedly works on iPads, but iPosCloud probably hard coded something to make it work as there are no drivers available for this printer (PBM P-822D), not for OSX nor for iOS. The following issues I need to solve today... 1. Setting up a LAN printer (connect with a wire to a wireless router) and print to it. 2. Print from FileMaker Go 13 without every time having to select the print settings (this is soooo freaking annoying and somebody at FileMaker should be fired for this).
  14. I have a database with orders, and per order there can be added items... Database works fine and all, but now I need to print it and it doesn't seem to be possible (I seem to need 2 bodies). Here's a sample of how I need it: ORDER 12345 12345 Product A $99.25 23456 Product B $24.38 34567 Product C $48.78 98765 Module 1 $5.98 87654 Module 5 $2.77 76543 Module 9 $9.18 45678 Product D $15.93 56789 Product E $36.55 98765 Module 2 5.66 87654 Module 3 3.88 Here's a sample of how I get it: ORDER 12345 12345 Product A $99.25 23456 Product B $24.38 34567 Product C $48.78 98765 Module 1 $5.98 45678 Product D $15.93 56789 Product E $36.55 98765 Module 2 5.66 It does not show all related records, only the first one (because it's a summery). 'Products' and 'Modules' are 2 different tables. 'Modules' has a field which holds the unique id to 'Products'. As said, database and portal work fine... Just the report doesn't work. The report is done by "Sub-Summery when sorted by" in the database of 'Products', so the body holds the records from that database. So I need another body which shows the 'Modules' related to each 'Product'. Am I still clear? ;-)
  15. You can have the submit script fill in a '1' in a global number field (where that global field is normally '0')... then have 'conditional formatting' change an object color (eg. a large square in the background of the layout). When the order is seen, have them click a button that makes the global field '0' again, which changes the object back to normal. Filemaker updates itself in the sense that if a shared database is changed, it is changed on every computer...
  • Create New...

Important Information

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