Field Matching doesn't work 100%

[Anatoli]

I have huge file, where various files will be imported, processed and then the records will be easy posted into company system.

Problem is, that FileMaker is not working correctly.

Matching names import is missing 50% of names.

Field names import is absolute joke.

FM 5.5v2, W2000, plenty of everything...

[Vaughan]

You wanna calm down, take a breather, then be a bit more specific...

[Anatoli]

The only chance was to align them manually.

And what more I can add?

I have screen shots so I will post them tomorrow.

And as I said, both methods are not working. The matching names link 50% of them.

Field names were just mess.

[Anatoli]

Screenshots: http://www.didi.cz/test/imag/fieldnames.gif and http://www.didi.cz/test/imag/matchingnames.gif

Bug as Mount Everest

[Vaughan]

Well, the names have to be *exactly* the same both sides for it to work. Some have underscores instead of spaces, they wont match. It could also be the colon is throwing things off.

It's not a terribly sophisticated system, I guess anything better would require AI and that's probably bring the hit rate to below 50%!

[Anatoli]

I didn't analyzed the system properly

[jasonwood]

Wouldn't it be nice if you could resize that "fancy small window FM is using for import"?

When things aren't in order, it can be a real pain to line things up when there are a lot of fields!

--

Jason Wood

HeyWoody.com

[Anatoli]

I couldn't agree more

[kennedy]

It would also be nice to have some other Field matching algs. For example, an alpha resort where it sorts all of both sides field names alphabetically... when your names are just a little different (spaces vs. underscores vs. nothing between words; all caps vs proper vs lowercase; abbreviated vs fully written out; etc.), you'll tend to end up just needing to rearrange up or down by one field in the majority of the cases.