Import script works but not my new fields

[jeffw]

Hi everyone. Have an import records script that I have edited, but the new fields data are not showing up and I cannot figure out why. This import is importing from a clone database. The data is in the clone (I have verified that) and it is on the layout in the script. But the data in the new fields I added never gets from the clone to the main database.

I was wondering does the order of the fields in the script mean anything? I have attached screenshots. Thanks for your help!

[bcooney]

By definition a "clone" is a copy of the database without records. I realize that you use the word "clone" to refer to a "copy".

It seems that your import path is not being set. If you run this script with debugger on, you can see the value in $$FRP. If there is no $$FRP, it points to a problem with the Set Variable script step.

So, when do you set gT_FilePath_Import? Is it really a globally stored field?

Also, I believe that your Set Variable $$ERROR step is not in the correct place. It will capture a successful Commit every time.

Finally, I don't see the need for $$vars. Why not use $vars?