11/14/2022 0 Comments Filemaker pro hosting issues![]() ![]() You can also work with your developer to put validation in place, or even build an approval process by which new data is added to your system in phases, with raw data in one set of fields and confirmed data in another. Use the ! mark to find duplicates and use * characters for wildcard characters. What happens if his phone number changes? You’ll change one record, but not the other.ĭealing with bad data is a challenge and almost always requires the power of the human brain. If you’ve already created a record for, say, Uryas Forge, you won’t want to create a second record for him. In addition, duplicate data is a problem that plagues all databases everywhere. If you properly put people’s names in the first name and last name fields of a contact database, but your office assistant decides to enter nicknames and other random tidbits, your data will be compromised. Making sure that good data is entered into your database is vital. How do I ensure that the data I have in my database is “good” data? And then, at the end of the day, it turns out that there was no data loss-all the day’s data was entered with an incorrect date. It is common for someone to note a data loss and proceed to take all sorts of steps to recover the data (inadvertently destroying data in the process). It always seems to be the case that the only time you do not back up your data is the one time your hard disk fails.Īlso, make certain you have practiced recovering data (backing it up and then restoring it to disk). That way, no one has to remember to do anything. By far the best backup strategy is to use an automated procedure. If you’re not using FileMaker Server, you can make timestamped copies of your files and store them on CD or on another computer. FileMaker Server deployment best practices and backup routines are easy to learn. Go to Records, Show All Records to recall all the data in your table.īack up your data. Be sure that you haven’t simply altered your found set to exclude the records you’re looking for. FileMaker doesn’t have an undo function, so if you delete a record, it’s gone forever. A wide range of possible problems can affect your data, but the most dangerous is accidentally deleting a record.or worse yet, discovering that you had the wrong found set when performing a Delete All Records command. One of the most critical aspects of your database is what gives it its name: your data. I’ve noticed that I’m suddenly missing some data. The best advice we can offer both developers and users is to work together! When you run into problems, knowing your developer will be a great first step. Most of the trouble you’ll run into as a user will be with issues specific to your own database solutions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |