Jump to content

Anyone having this problem?


RonMc
 Share

This topic is 7513 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I just registered and am a new user -- I hope this is a place to ask questions among other FM Pro users.

I am having a problem when importing from one FM Pro database to another. The problem doesn't happen a lot, but causes us grief from time to time. We have a large number of FM Pro databases on a FM Pro Server. When we create an invoice, we run a script that imports information from another FM Pro database to the "invoice" database. Occasionaly information ends up in the wrong fields. We get descriptive information in a pricing field, for example. It is usually the same two fields that have the problem.

Anyone know of this problem?

Link to comment
Share on other sites

I have had very similar frustrating problems with both importing and exporting. I won't go on, but some of the problems we experienced were really erratic. I posed the question to several discussion groups to which I belong without receiving any responses.

The only solution we came up with after many days of trial and error was to not use import/export to do the job. We ended up creating scripts to copy field values to globals and then populate fields in a receiving database. This is a much safer solution and works 100% of the time with 100% accuracy.

Hope this helps.

Link to comment
Share on other sites

Sometimes the lack of response is due to a lack of information. wink.gif

Are you using a script to import? More than one script? Are you using an intermediate file? Have fields been added to either file between runs of an import script?

Properly used, import should be completely reliable. -bd

Link to comment
Share on other sites

Thank you for all of your comments. It is not a matter of having added new fields. The databases are pretty stable. We generate hundereds of invoices each week, importing data from one database to the other in each case via a single script. One a couple of invoices per week, the data from one field appears to import into the wrong field. Thereafter we can continue on without a problem. There is no "intermediate file" but perhaps I should consider it.

If there are any other comments, I would appreciate it.

Link to comment
Share on other sites

This is a mutli-user system running on a Macintosh based Filemaker Server. The database that the data is coming from during the import is open and in use by many workstations. The database that the data is going into is accessible to many, but in reality there is only one person who really uses it or has it open. I guess it is possible that mutliple people could have it open when the errors occur, but it is unlikely.

Link to comment
Share on other sites

It's a good thought. You'd think that record locking might cause one or more records to be omitted from the export, but why would fields be scrambled, especially the same two.

I'd almost guess something else is going on here. It like a description over the phone of a patient with a headache. When you see that patient in person, he has a 20d nail sticking out of the back of his head that wasn't mentioned! wink.gif -bd

Link to comment
Share on other sites

This topic is 7513 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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