Using DMT to create orders from multime CSV

Kinetic ERP
1

We have a customer that will be sending us orders in a CSV format. I found an example in another post, but the files were staticly named: DMT Multiple Loads at One Time
In the example it would specify a specific file name. Would the import process work with the get-childitem command to import multiple files. Each time this customer sends us files, they are named differently.
#DMT Automation Example 1

$DMTPath = “E:\Epicor\ERP11\LocalClients\KineticERPTest\DMT.exe”
$User = “UN”
$Pass = “PW”
$Source = Get-ChildItem “E:\IN*.csv”

#Load Data
Start-Process -Wait -FilePath $DMTPath -ArgumentList “-User $User -Pass $Pass -add -Import "Sales Order Combined” -Source $Source "

If it will not work this way. is there a way to just grab one file at a time and process it, then move the file to an archive folder and process the next one until no files are left?

2

I found that it would grab the first csv file when using the Get-ChildItem command. but it would not process the next one. Is there a way to have this process loop to where after it process the item, it then moves the file to another folder and then runs again until there is no more files left?

3

I took your script and enhanced it:

$DMTPath = "E:\Epicor\ERP11\LocalClients\KineticERPTest\DMT.exe"
$User = "UN"
$Pass = "PW"
$folderPath = "E:\"
$fileName = "IN*.csv"
$fileNames = Get-ChildItem -Path $folderPath $fileName

foreach ($file in $fileNames) {
	try {
		Start-Process -Wait -FilePath $DMTPath -ArgumentList "-User $User -Pass $Pass -add -Import ""Sales Order Combined"" -Source $file"
        if (!(Test-Path $folderPath\Archive -PathType Container)) {
            New-Item -ItemType Directory -Force -Path $folderPath\Archive
        }
        Move-Item -Path $file -Destination .\Archive
	}
	catch {
		Write-Output "$server - $($_.Exception.Message)"
	}
}

It will check for the existence of an Archive folder, create it if not. Run DMT for each file, then move it to the Archive.

2 Likes
4

This is the final script that we are using and so far it is successful.

dmt Automation Example 1

$DMTPath = “E:\Epicor\ERP11\LocalClients\KineticERP\DMT.exe”
$User = “Rockauto”
$Pass = “RockAuto”
$SourceFolder = "E:\Aftermarket\Rockauto\IN"
$ArchiveFolder = ‘E:\Aftermarket\Rockauto\IN\Archive’

Get a list of CSV files in the source folder

$SourceFiles = Get-ChildItem “$SourceFolder*.csv”

foreach ($SourceFile in $SourceFiles) {
# Load Data
Start-Process -Wait -FilePath $DMTPath -ArgumentList “-User $User -Pass $Pass -NoUI -add -Import "Sales Order Combined” -Source $SourceFile -NoCompleteLog"

# Move the processed file to the archive folder
Move-Item -Path $SourceFile.FullName -Destination $ArchiveFolder

}

1 Like