pigslow

Do you have your ODBC connector set up to use the administrative user name and password?

I had the opposite problem...from MySQL to filemaker. I found a check box on the Advanced tab for the ODBC driver setup. "Allow big results" I found by checking this, you can import more records. I don't know if that helps but there it is.

I am not sure it this is where the problem lies but let me explain. My filemaker 7 server is running on 2003 server at a remote location. Their network uses a workgroup to share files. I have another 2003 server at my location that I want to have files transfered over via a VPN. We have a domain in my location. I found a zip utility that names the zip file as a timestamp. Using the Microsoft scheduler I execute a batch file that starts the zip utility to create the zip file of my filemaker backup. The next batch file is then executed by the scheduler to copy that zipped file to my local server. The last batch file then executed to move the origonal file to a safe location on the remote filemaker server so it does not get picked up on the following days transfer. If I use Microsoft remote desktop connection all of these scripts work when executed manually. If I stay connected to the remote server and just let the scheduler execute the batch files it works that way too. If I log off from my remote connection the scheduler executes all 3 batch files at the designated time but the file transfer from the remote to local server does not happen. What am I missing?

I think I have some corruption in my DB and I want to try Exporting out and importing into a clone. I have 3 questions. On the Export I plan on exporting to a .mer file should I check the use checkbox that says "Apply current layouts data formating to exported data"? On the Import should I use the checkbox that does the autoenter functions? Is there anything else that I need to be aware of?

This "ID" that I am doing the find on is a primary in another table. The data is imported into this filemaker table weekly from a CSV file. That CSV file always has duplicates in it. The file is generated from a MySQL database. The MySQL database contains logs of how many times these records are used. Each log represents a weeks worth of access of those records. The CSV file contains all of the weekly logs from inception of the database to the current date, so the file grows weekly.

I have a script that does a find then does a couple of constrains to omit some of the found records to get the records I really want. The last constrain Omits ! on the key id for the records. I run this once a week and it has been fine for about 6 weeks. For some reason it it finding records that are not really duplicates and is omitting them. The only thing that was done was that we removed a large portion of the records that were not being used. Would this have possibly created a problem with the ID that can not be seen on the surface? Is there another way to omit duplicates?

Did you try using the "All Users" folder? That is something that they all have in common. You could create a folder there for your file or just use all users/desktop and it would appear on the users desktop. cluttering a desktop is never a good thing but it is an option. c:documents and settingsall usersdesktop

That worked great. Thank you very much for your help.

This Sample file is a slice if the records being imported into this Filemaker table. I find that if I change the field type to text. Do the import (which does allow the data to fill that column). Run a script to change the dates from yyyy-mm-dd to mm-dd-yyyy. Then change the field type back to date. Everything is fine...until next time I have to do this. Sample.txt

This database is 1.8 GB. It is too big to try and attach. A cloned copy is 4MB. Even that seems to be a bit large to post here.

When you say it didn't work, what did it do? What did it not Do? Are all of the dates the same format as 2001/3/14? I thought these records already existed? The calculation does work. The import of the 80,000 records does work. What does not work is this date field while bringing in these 80,000 records. I think that is because there are about 20 records that have nothing in this date field. Would that stop the entire column from coming in?

I went through all of the records and noticed there are about 20 records that have no entry in this field. Would that make this not work as a date field since it will bring them in as a text field?

Ok I take that back. It worked on a small test import of only 5 records. When I tried to do it for the entire file which was over 80,000 records just that one field did not work again. Is there a limitation or would it do this if for some reason there is one of the 80k records that is formatted differently?

Thanks for all of your help. I was stupid but finally bumped into the problem. I went to layout mode, date format, numeric seperator. Changed that from "/" to "-" and it comes in just fine. Thanks again for your attention. I need all the help I can get at times.

I see a difference in the format that I did not notice. Instead of having "/" it has "-" I changed the character in the substitute but I just get a ? in the field after the import.