Hard Code Import Template Values

SOLVED

Hello! I was wondering if there is a way to hard code values for import templates so that we do not have to provide those values that remain constant. An example would be if the job ID in a sales order import template is always "100," when I import the template, I do not have to provide the job ID and the import template process will populate the job ID as "100" itself. 

Thank you in advance for your assistance! 

  • 0
    verified answer
    Hi muser, I think you may be able to use transcription to do this (setup / usage / importsexports / transcribe import)

    Basically you define the transcription table number (a number you make up to identify the record), local code (the "100", though note you don't need the quotes in the screen) and the external code (the "") .

    Next you go to the import template, and on the field you are trying to default, scroll over to the TABLE field and enter the transcription table number you created in the first step.

    If you're lucky enough and you don't have multiple tables to import into, then you can put all these fields at the end of your import definition and then don't include those fields in your import they will default without having blank columns in your import file. If this is your situation and want more info let me know.

    If you have problems let me know what particular challenges you are having and perhaps a screengrab of your import templates Header and Fields.

    Hope that helps