Skip to content


Excel Source Columns not available on Pre Tasks as Variables

Jothikrishnan Narasimmaraj asked 4 years ago
I have a map to create Projects from Excel Source, but eConnect fails if Contract status is not Estimate(but GP allows to create Project with Contract Open). So, I have to update the status to 4 through SQL on Pre Map and then update back to 1 Post Map Run. But Contract No from Source Excel is not available as Variable to use in the pre map task. Please help.
Jothikrishnan Narasimmaraj replied 4 years ago

Never mind. I noticed that it is available on Run Before Document Task, but just not on Run Before Map task. I think I can manage with it. Reason I asked is, previously map was just for one contract and I had it hard coded on the pre map task, now contract number coming from Source file, so I had to change it.

Lorren Zemke answered 4 years ago
To truly answer the question, the Source data is never available on a Pre-Map Task because SmartConnect has not read the data at that point.
Once it has read the data, it’s available for a Pre-Map SQL Validation or on any document task.
Once the map is complete, post map tasks, the data again, is not available.
Jothikrishnan Narasimmaraj replied 4 years ago

Thank you Lorren. Got it. Truly appreciate your response.

If you would like to submit an answer or comment, please sign in to the eOne portal.