AnsweredAssumed Answered

How do you use the Import Records script step with the current file?

Question asked by anothersmurf on Nov 19, 2018
Latest reply on Nov 20, 2018 by beverly

In my database, I have several scripts which use the Import Records script step to import data from one table of the database to another. It's pretty straightforward, works fine.

 

However... my database is named e.g. FileName 2018, and for next year, I'll clone the database and name the clone FileName 2019. When I open FileName 2019 and run a script with an Import Records step, it imports from FileName 2018, which is not what I want.

 

Is there a way to specify that I want to import records from "this database" (the one in which the script is running), regardless of its name?

 

(Someone will suggest setting a variable to get(filename) and making that my data source. That works, but if I need to change something, the left column of "Specify Import Order" is blank. So then I'm back to hard-coding the file name. Surprisingly, using a global variable doesn't help.)

Outcomes