Jump to content

Josh Ormond

  • Content Count

  • Joined

  • Last visited

  • Days Won


Josh Ormond last won the day on February 4

Josh Ormond had the most liked content!

Community Reputation

110 Excellent

1 Follower

About Josh Ormond

  • Rank
    Director of Structural Entropy

Profile Information

  • Title
    Senior Developer, FileMaker Certified
  • Industry
  • Gender
  • Location
    Rochester, NY

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

18,249 profile views
  1. To use the functions with FileMaker Pro Advanced on your local machine, you also need to install the plugin on your local machine. The server install only allows the FileMaker Server Script Engine to use the functions. And there is a separate location if you are using the plugins with Custom Web Publishing.
  2. I would also start with FileMaker's Custom App Academy. In addition to the links @OlgerDiekstra posted. https://www.filemaker.com/learning/custom-app-academy/
  3. I have created a new topic, then wasn't sure if I sent it!!!!

    Do I assume it won't appear in the forum until it has been checked out??

    Or could it be still hanging around somewhere waiting for me to finish it??

  4. FileMaker is not a traditional backend/frontend architecture. As you mentioned, it's all included in a single file. However, you can separate the setup into multiple files. For example, data in one file, UI in another file. Also, using FileMaker Server to host the files is best practice. With that, users can connect remotely to the files using FileMaker's own network sharing protocol. There are some samples yes. If they are helpful to you will depend mainly on how complex of a solution you need. Inventory is typically complex. No way around that. https://www.filemaker.com/learning/custom-app-academy/ https://www.filemaker.com/custom-apps/resources/ You may find these resources helpful.
  5. If you are asking if you can have a FileMaker frontend with an Access backend, the short answer is no. If the data lives in MicroSoft SQL Server, MySQL, there is a way to do it. But it would involve some fiddling. If you need it run on a Mac, then Access is not an option. You either need something web based, or you need to rebuild it in FileMaker or something native to the OS.
  6. Josh Ormond

    XML Import

    It's one thing to ask for help learning or understanding something, in this example XML and stylesheets. That is a big piece of why the forum exists to help people learn. It is an entirely different thing, and somewhat inappropriate, to ask someone "build this for me". It's not what we are here for. If you wish to hire someone to do it for you, then have that discussion back-channel...and expect to be billed market rate.
  7. If it's not sensitive data, you can post a sample here, and we can help you figure out the problem, and possibly suggest how to address it.
  8. In your original post, you said you are splitting the file "into 2 .xls files". You are making a change, and then resaving them. If you are saving them as .xlsx or .xls files, you have committed a format change. This is where Excel is helping you. Even if you are resaving them as CSV, Excel is still post-processing the data. My point is, the problem is likely the data. Once you determine what exactly is malformed in the file, then you can begin to figure out how to deal with that. FileMaker handles CSV data really well, but that requires it to be true CSV and not pseudo-csv.
  9. The problem here is often the "format" of the CSV. If the data has a comma in it, the value needs to be surrounded by double quotes. If the csv is created by Excel, or was opened in Excel, sometimes it's tries to do some conversion for you. Sometimes that helps, sometimes not. So you really need to look at the csv itself.
  10. Security. One common use, store a password as a hash ( not MD5 anymore, its not secure enough ). When someone signs into a site, or file, or whatever, you hash what they typed in the same way as the stored password value. If they match, you let them in. If not, they didn't type the right password. There are ways to reverse engineer an MD5 hash, but is isn't typically done, especially in FileMaker. It's typically not worth the effort. It would be good for you to look at the difference between encryption and hashing and encryption. Here are some brief explanations ( others may clarify as needed ) encoding - transforming data into another format, typically publicly available so it's easy to reverse engineer or decode it. encryption - transforming data into another format, so only authorized parties can view and decode the data. hashing - a one-way transformation that can't be reverse engineered, ideally. Newer hashing algorithms are much better for this. Don't rely on MD5 for secure storage of data.
  11. 1. Does the file hold sensitive data? If it does, I would just caution against removing the password. 2. The feature you are looking for is the Auto-login feature under File Options.
  12. I don't believe you can decode the CryptDigest part. It's how hashes work. They are typically a one-way process.
  13. I'm with @comment on this. What are you trying to do? You can HexDecode the 'ENCRYPTED DIGEST' field, but not put another CryptDigest on it. So I'm not sure what you are trying to do. Reverse engineering an MD5 hash typically requires a hash table. Which you aren't creating. By their nature, it's not intended to be able to reverse engineer a hash.
  14. https://github.com/airmoi/FileMaker/ I haven't used it, but others have said this works.
  15. Absolutely. Virtual List, as is obvious, is my preferred approach.
  • Create New...

Important Information

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