avaya_process_skill_data.int

version "1";
object 'PARM' "parms" {
	parms = {
		{
			name        = "archiveDir",
			default     = "/var/opt/DI/dl-dataroot/IMPdata/archive/avaya/skills",
			testdefault = "/var/opt/DI/dl-dataroot/IMPdata/archive/avaya/skills"
		},
		{
			name        = "sourceDir",
			default     = "/mnt/avaya/skills",
			testdefault = "/mnt/avaya/skills"
		},
		{
			name        = "buildDir",
			default     = "/var/opt/DI/dl-dataroot/IMPdata/temp/build/avaya/skills",
			testdefault = "/var/opt/DI/dl-dataroot/IMPdata/temp/build/avaya/skills"
		}
	}
};

object 'TSKL' "Main" {
	contents = {
		`Avaya Skill ETL`
	}
};

object 'TASK' "Avaya Skill ETL" {
	inputs    = {
		`Directory-1-DIR`
	},
	output    = `Execrows-1-EXR`,
	processes = {
		`arch-CAL`,
		`filename-SRT`,
		`nix-CAL`
	}
};

object 'INPT' "Directory-1-DIR" {
	//+ coordinatex = `33`,
	//+ coordinatey = `8`,
	input_type  = `directory`,
	starnames   = { `*.csv`, `*.txt` },
	directory   = `$sourceDir`
};

object 'PROC' "arch-CAL" {
	//+ coordinatex = `333`,
	//+ coordinatey = `8`,
	process_type = `calc`,
	input        = `nix-CAL`,
	calcs        = {
		{
			name  = `archFile`,
			value = `concat("$(buildDir)","/",nixFile,".bz2")`
		},
		{
			name  = `perlInput`,
			value = `concat("$buildDir","/",Filename)`
		}
	}
};

object 'PROC' "filename-SRT" {
	//+ coordinatex = `133`,
	//+ coordinatey = `8`,
	process_type = `sort`,
	input        = `Directory-1-DIR`,
	sort_columns = { `Modified Date`, `Filename` }
};

object 'PROC' "nix-CAL" {
	//+ coordinatex = `233`,
	//+ coordinatey = `8`,
	process_type = `calc`,
	input        = `filename-SRT`,
	calcs        = {
		{
			name   = `nixPath`,
			value  = `replace(Path," ", "\\ ")`,
			update = `true`
		},
		{
			name  = `nixFile`,
			value = `replace(Filename," ", "\\ ")`
		}
	}
};

object 'OUTP' "Execrows-1-EXR" {
	//+ coordinatex = `433`,
	//+ coordinatey = `8`,
	output_type = `execrows`,
	input       = `arch-CAL`,
	commands    = {
		`mv $$nixPath $buildDir/`,
		`perl avaya_summary_skill_parse.pl "$$(perlInput)"`,
		`bzip2 $buildDir/$$nixFile`,
		`mv $$archFile $archiveDir/`
	}
};