Import Script problem

[The Big Bear]

Hi All

I think it was LaRetta that was kind enough to post this excellent import script on the forum. But I have two problems that I need some help with.

The first problem is that everytime the file is open and the import script is run then you must manually find the source file path regradless if the script shows the correct path. Once the source path is found manually then this part works until you close the file and reopen it again then you again have to find the source path manually.

The second problem is that on the import filed mapping dialog the source file does not find the correct file. If you check the box preform without the dialog box then no records are imported because the source side is on the menu file when it should be on the company name file.

I have spend at least four hours trying to figure out what I have done wrong.

would someone please review the attached file and give me your opinion on why these things are happening.

Thanks a lots

Lionel

import.zip

[LaRetta]

Nope, it wasn't my work at all. And I honestly have no idea why the scripting is set up as it is; it seems overly complex and unnecessary. But I will try to take a look in next few days if nobody else gets to it; I'm kinda busy through the holidays! :laugh2:

[Lee Smith]

Bear.

This questions should be posted as a Reply to the Thread where you got the Script. Provide me a link and I'll Merge it, or Reply to it with your question that you asked here, and let me know and I'll delete this Thread.

Lee

[The Big Bear]

Lee

http://fmforums.com/forum/showtopic.php?tid/212107/

Edited December 26, 2009 by Guest

[The Big Bear]

LaRetta

Sorry about the mess up. The file was posted by Bcooney. I appreciate you looking at the file. No hurry.

Thanks

Lionel

[bcooney]

Hello,

As the creator of the notorious Import demo, let me explain its purpose.

This demo was created in response to a user that was releasing a new version of a runtime. The source file name and its location was not necessarily known. So, the file is built to ask the user for the source file, and then imports its data into the "new" version.

BTW, the file that you've attached is NOT my demo--here's the link to my demo: http://fmforums.com/forum/showpost.php?post/344970/

[The Big Bear]

bcooney

I am sorry for the mistake. I also was looking for an import script to handle update files when I came across the tread. I have the highest regard for your answering our questions. Everytime that I see a file that your have posted, I am amazed at the knowledge that when in to them. I think your are the best Thanks for the link.

Lionel

Edited December 26, 2009 by Guest

[bcooney]

You're very kind, Lionel. Remember, I've been using FM since its first release...and believe me, I'm still learning. I just was a bit hurt by LaRetta thinking that my script was "overly complex and unnecessary." Thankfully, it really wasn't my script.

Edited December 27, 2009 by Guest

[LaRetta]

... just was a bit hurt by LaRetta thinking that my script was "overly complex and unnecessary."

Keep in mind that I was looking at 3 scripts (the first two twisted and broken) and I couldn't understand why three scripts were necessary (with a quick once-over). I didn't know it was work from you (or implied you) at all. If so, I would have known something was amiss.

I was not judging anyone else; only saying it seemed complex and I didn't have time to look at it properly (and I still don't).

[The Big Bear]

Barbara and LaRetta

I have a workable program because of your help. I think I have the "Autolocate and Verify Source file" script worked out but still have a question on the import script. When the import step is performed, the source table (right side) is the menu table and not the company name table. How do I get the source table to be the company name table without doing it manually.

When I check the box "Perform without dialog" then the company name is not imported because the source table is the menu table.

Thanks for the help

Lionel

[bcooney]

Oh, LaRetta, I wasn't really hurt. I've been known to write overly complex scripts!

[bcooney]

Lionel, you probably need to update the Import Script step. You must manually set the field mapping and both sides of the import dialog (source table and destination table).

The trick is that when you create the Import Script step, you must manually add the source file. You define the mapping, and then leave just a $var in the source file path, deleting the "hard-coded" source file that you inserted for the purpose of defining the script step.

[The Big Bear]

Barbara

Thanks so much for the help. That did the trick.

Thanks again.

One more question. You said that you use an progran installer, would you mind telling me which one as I am looking for a program installer. I would like to purchase one that has decent documemtation.

Thanks so much for the help

Lionel

[bcooney]

Lionel, are you distributing a runtime? That would be the only reason to have an installer, imho.I've used MacInstallerBuilder, but I think that he's no longer supporting the product. He doesn't return emails. It was an easy installer and cheap and allowed for a license agreement dialog. It was available for both platforms.

[The Big Bear]

Barbara

Hopefully I will be distrubing a welding program in 2010 that I have been working on for the past two years. So I was looking for a good program installer to help the installation process. Any other installer that you have heard of.

Lionel