-
Notifications
You must be signed in to change notification settings - Fork 2
/
__BFX_Dump_Data.bat
65 lines (46 loc) · 3.67 KB
/
__BFX_Dump_Data.bat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
REM ScriptFolder is where the scripts are located
SET Company=VDK
Set ScriptFolder=%~dp0
Call "%ScriptFolder%Setup.bat"
Set CompanyFolder=C:\Users\PaulM\OneDrive - TIME MANUFACTURING COMPANY\EpicorImplementation\Z_Temp
Set CompanyPW=%PW%
Call "%ScriptFolder%Setup_Prod.bat"
Set OutputFolder=C:\Users\PaulM\OneDrive - TIME MANUFACTURING COMPANY\EpicorImplementation\7_BFX\15_DataDumps\Prod_%SUBFILENAME%
MkDir "%OutputFolder%"
echo %OutputFolder%
REM timeout /t 30
Set Company=BFX
Set Prog=Supplier_SUP_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=BillOfOperations_ENG_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=GLAccount_FIN_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=Parts_Mfg_NoRevision
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=SalesOrderCombined_SLS_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=Part_INV_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=PartPlant_INV_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=PartWarehouse_INV_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=PartRevision_INV_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=PartCombined_INV_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
Set Prog=BillOfMaterials_ENG_DMT
%DMT_Program% -ConfigValue=%ConfigValue% -User=DMT_%Company% -pass=%PW% -DisableUpdateService -NoUI -Export -BAQ="%Prog%" -Target="%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
"%ScriptFolder%csv2xlsx.exe" --colsep "," --infile "%OutputFolder%\%Prog%_%SUBFILENAME%.csv"
timeout /t 30