Welcome Guest, Login
Image
RSS RSS

Navigation


Quick Search
»



Page History: Creating Constant Values for a Data Translation Module CSV Spec

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: Tue, 29 Dec 2015 10:09


A constant value can be added to a CSV Spec in the Data Translation Module for importing data into CAREWare. An example would be the provider domain. A CSV Spec may be setup for a specific provider domain. Once the constant value is added, this field will not have to be entered in the import file. The value will be added to the PDI Template, even if that field does not exist in the import file being translated by the Data Translation Module.

Image

  1. Right click on an open spot in the bottom of the list of mapped fields.
  2. Click Add Mapping.
  3. Click the drop down arrow for Match Type.
  4. Select Constant Value.
  5. In the text field, enter a value for the constant value.
  6. Select the PDI Template field you want to map that value to from the list of template fields.
  7. Click Save.

The new mapping will be added to the list without a source file position or source file header, since this field will be added in addition to the columns in the import file.

Image

Click here to download these instructions.

Back to Data Translation Module

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.

© 1998- Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.