Why are you attempting to import the data back into the database? Exporting the data does not delete the data from your database file, so your data may already be present in your database.
1st it says: "Cust list" contained only enough data to update the first 2501 records.
Update indicates you are importing with the update matching records options. I don't understand why you would do this from a csv backup file. I could see saving a clone of your file and then importing with the add new records options. I believe you had 2501 records in your found set--which could be a small fraction of the total number of records in your table and that's what the error message is telling you.
Some data field values could not be recognized as valid dates.
Assuming this popped up immediately after your import, it means that some data was imported into a date field that FileMaker couldn't recognize as a date. You may have imported data from the wrong column of your csv file into this date field. If you enter find mode and type a ? into this date field, you can then find all records where an invalid date was imported.
"Gr business Acct." is defined to recognize a value, but does not appear on this layout. Use another layout to type a value.
You have a validation rule set on this field, but the field is not present on the current layout so you can't use this layout to fix the problem. "gr business Acct" may auto enter a value that it cannot correctly look up due to errors introduced when you tried to import from your csv file.
If I were you, I'd back up the database by making copies of the entire file. There are good reasons for exporting the data as a text file as an additional backup, but importing the data back into an empty copy (clone) of your file requires either a script to do it for you or a pretty decent knowledge of both FileMaker and the structure of your database.
You may want to read up on Import Records in FileMaker help and you may want to contact the MacGroomer developer for techincal assistance.
Well I never used a Mac before and I have always disliked the way they are. I am a PC guy and don't know how to use these darn computers. All I was told from a couple of people was to select "Export Files/Records" to make a copy as a back up. I would save it on an external hard drive. Then my MacGroomer program had a major malfunction and I had to reinstall it on the Mac. After doing so I tried importing records and it wouldnt allow me.
Also, I just tried inputting a ? in the "find" field and it wouldnt bring up any records. It says its an invalid entry. I am lost and confused of what to do now. Years of customer data are on the brink of being lost forever.
With MacGroomer open, select Manage | Database | Tables. How many tables are there in your file? When you exported data, did you export from all of them or just one table?
When you exported your data, did you first select "Show all records" from the records menu? If you didn't, your back up file will only contain part of the data from your original file.
If, after those checks, you are fairly confident that you did back up all your data, open FileMaker, select help and look up Import Records. This is a tool with a lot of options--so it helps to read up on all of them first. Then we can take a fresh try at importing your data and getting it into the correct spots.
I have the file open and it doesnt give me an option of Manage. I just tried deleting all the blank files it had and it gave me an error saying "this file is badly damaged. bla bla bla use recovery command or click resume to continue" and stuff like that.
Can you tell if this is a run time solution?
What do you see in the help menu?
Can you tell what version of FileMaker you are using?
How did you "reinstall" this system? It sounds like you need to delete this coy and reinstall it.
If this is a run time system, your only hope may be to locate the developer and get their assistance with your file.
No i cant. A bunch of mumbo jumbo on how to use the program. Its FileMakr Pro...I put the cd in and installed it...What im going to do is just get a new program for a PC and start over. I have most of my clients clipcards filled out and saved in storage so ill just have to manually input them 1 by 1 again. Going to take a while but its better then nothing. Thanks so much for your help man!