I'm having some really basic issues with the Data Connector Import functionaity. One issue revolves around expressions, and the other is a general use case problem.
1. How do you escape new lines / tabs in an import expression for a text field like comment? I've tried multiple methods and all I end up with are \t and \n in the output between my column names. Here's the expression and test results:
2. How can I skip and report on rows during the import process based on field comparisons to stored information?
For example, I'm writing an import to update Computer status (Retired / Disposed) based on a CSV that contains the Computer Name, Serial Number, etc. I want to compare the Serial Number provided in the import CSV to the one in Altiris for the Computer Name. If they do not match, i want to skip importing that row and generate a log message indicating the mismatch.
Thanks for any help,
John