nobobo
219 lines
6.5 KiB
INI
219 lines
6.5 KiB
INI
[ExcelToCsvWeOrder]
|
|
Title=Excel→CSV 処理（溶接加工向けデータ連携ツール）
|
|
001=ExcelToCsv_WeOrder(ExcelToCsvIni)
|
|
;001=ExcelToCsv_WeOrder(ExcelToCsvAlumiIni)
|
|
002=SFTPUpload(SFTPUploadIni)
|
|
003=Cleanup(CleanupAfterUploadIni)
|
|
|
|
[ExcelToCsvIni]
|
|
DaysToStartOffset=1
|
|
InFolderPath=C:\CSV\read
|
|
;InFolderPath=C:\CSV\溶接加工計画
|
|
;FileNamePattern=*生産計画*.xlsx
|
|
FileNamePattern=WE生産計画*.xlsx
|
|
ExcelSheetCheckItems=D2[or]D3,ライン|E2[or]E3,シフト|C5[or]D5,機種コード[or]コード|E5,仕向|F5,タクト|G5,日付
|
|
ExcelLineJudgeCol=D
|
|
ExcelDateRowMode=Fixed
|
|
ExcelDateRow=5
|
|
ExcelDateRowStartCol=H
|
|
ExcelDateRowEndValue=TOTAL
|
|
ExcelHiddenRowHandling=skip
|
|
ExcelDataStartRowJudgeCol=D
|
|
ExcelDataStartRowJudgeValues=コード,機種,機種コード,基本部番
|
|
ExcelDataEndJudgeCol=G
|
|
ExcelDataEndJudgeValue=
|
|
ExcelMcSeisanFukaJudgeCol=B
|
|
ExcelMcSeisanFukaJudgeValuePattern=*生産負荷*
|
|
ExcelAfWeCol=G
|
|
OutFolderPath=C:\CSV\溶接加工計画
|
|
CsvFileName=WeOrder
|
|
FileDtPrefix=yyyyMMdd-HHmmss_
|
|
FileDtSuffix=_yyyyMMdd_HHmmss
|
|
;CsvEncoding=UTF-8 With BOM
|
|
|
|
[ExcelToCsvAlumiIni]
|
|
DaysToStartOffset=1
|
|
InFolderPath=C:\CSV\溶接加工計画
|
|
FileNamePattern=*アルミ*.xlsx
|
|
ExcelSheetCheckItems=A3,YEAR|B3,MONTH|C3,ライン名|G4[or]K4,生産計画|A7[or]A8,部番|G7[or]G8,日付|G8[or]G9,刻印
|
|
ExcelLineJudgeCol=C
|
|
ExcelDateRowMode=Judge
|
|
ExcelDateRow=5
|
|
ExcelDateRowJudgeCol=G
|
|
ExcelDateRowJudgeValue=日付
|
|
ExcelDateRowStartCol=H
|
|
ExcelDateRowEndValue=TOTAL
|
|
ExcelHiddenRowHandling=skip
|
|
ExcelDataStartRowJudgeCol=D
|
|
ExcelDataStartRowJudgeValues=コード,機種,機種コード,基本部番
|
|
ExcelDataEndJudgeCol=G
|
|
ExcelDataEndJudgeValue=
|
|
ExcelMcSeisanFukaJudgeCol=B
|
|
ExcelMcSeisanFukaJudgeValuePattern=*生産負荷*
|
|
ExcelAfWeCol=G
|
|
OutFolderPath=C:\CSV\溶接加工計画
|
|
CsvFileName=WeOrder.csv
|
|
FileDtPrefix=yyyyMMdd-HHmmss_
|
|
FileDtSuffix=_yyyyMMdd_HHmmss
|
|
;CsvEncoding=UTF-8 With BOM
|
|
|
|
[SFTPUploadIni]
|
|
Host=10.22.6.10
|
|
Port=22
|
|
UserName=J0136167A
|
|
PrivateKeyFilePath=C:\keys\J0136167A.ppk
|
|
PassPhrase=
|
|
RemotePath=/Test/WE_PLAN
|
|
InFolderPath=C:\CSV\溶接加工計画
|
|
FileNamePatterns=*.csv
|
|
|
|
[CleanupAfterUploadIni]
|
|
FolderPath=C:\CSV\SFTPDL
|
|
MaxDays=90
|
|
MaxFileCount=100
|
|
|
|
[CsvToDbWeOrder]
|
|
Title=CSV→DB 処理
|
|
001=SFTPDownload(SFTPDownloadIni)
|
|
002=CsvToDb(CsvToDbIni)
|
|
003=Backup(BackupIni)
|
|
;003=SFTPDelete(SFTPDeleteIni)
|
|
004=
|
|
|
|
[SFTPDownloadIni]
|
|
Host=10.22.6.10
|
|
Port=22
|
|
UserName=J0136167A
|
|
PrivateKeyFilePath=C:\keys\J0136167A.ppk
|
|
PassPhrase={[SFTP]PassPhrase}
|
|
RemotePath=/Test/WE_PLAN
|
|
OutFolderPath=C:\CSV\SFTPDL
|
|
FileNamePatterns=*WeOder*.csv
|
|
|
|
[CsvToDbIni]
|
|
SqlFolderPath=SQL
|
|
DaysToStartOffset=1
|
|
CsvFileNamePatterns={[CSV]FileNamePatterns}
|
|
CsvFolderPath=C:\CSV\SFTPDL
|
|
;CsvEncoding=UTF-8 With BOM
|
|
DbProviderName=ポスグレ
|
|
DbConnectionString=Host=RL23091509;Port=5432;Database=vaptracedb;Username=postgres;Password=postgres
|
|
;DbConnectionString=Host=localhost;Port=5432;Database=postgres;Username=postgres;Password=sfsadmin
|
|
DeleteBeforeInsertSqlFiles=DeleteBeforeInsertWeOrder
|
|
InsertSqlFiles=InsertWeOrder
|
|
DupCheckSqlFiles=
|
|
|
|
[SFTPDeleteIni]
|
|
Host={[SFTP]Host}
|
|
Port={[SFTP]Port}
|
|
UserName={[SFTP]UserName}
|
|
PrivateKeyFilePath={[SFTP]PrivateKeyFilePath}
|
|
PassPhrase={[SFTP]PassPhrase}
|
|
RemotePath={[SFTP]RemotePath}
|
|
FileNamePatterns={[CSV]FileNamePatterns}
|
|
|
|
[BackupIni]
|
|
SourceFolderPath=C:\CSV\SFTPDL
|
|
DestinationFolderPath=C:\SFTPCSV\DL\Backup001
|
|
FileNamePatterns=*WeOrder*.csv
|
|
MaxDays=30
|
|
MaxFileCount=30
|
|
PrefixDtFormat=yyyy-MM-dd-HH-mm-ss_
|
|
SuffixDtFormat=_yyyyMMddHHmmss
|
|
[Logging]
|
|
LogLevel=Information
|
|
LogFilePath=Log\ExcelToCsvToDbLog.log
|
|
RollingInterval=Month
|
|
|
|
[SFTP]
|
|
Host=172.22.4.89
|
|
Port=22
|
|
UserName=noboru
|
|
PrivateKeyFilePath=C:\Users\jpa01378\id_rsa_dotnet
|
|
PassPhrase=uI14MRtLpR7iLxWvaTGFfw==
|
|
RemotePath=bbb
|
|
|
|
[CSV]
|
|
FileNamePatterns=*WeOrder*.csv
|
|
|
|
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
|
|
;[ExcelToCsvIniあああああ]
|
|
;Title=Excel→CSV 処理（溶接加工向けデータ連携ツール）
|
|
;DaysToStartOffset=1
|
|
;InFolder=C:\CSV\溶接加工計画
|
|
;InFileName=2023*_溶接加工計画.xlsx
|
|
;InFileName=*生産計画*.xlsx
|
|
;ExcelSheetCheckItems=2,5,ﾗｲﾝ|2,6,ｼﾌﾄ|5,3,機種コード|5,5,部番
|
|
;ExcelSheetCheckItems=D2[or]D1,ライン|E2[or]E1,シフト|D5,機種コード[or]コード|E5,仕向|F5,タクト|G5,日付
|
|
;ExcelLineJudgeCol=4
|
|
;ExcelDateRow=5
|
|
;ExcelHiddenRowHandling=skip
|
|
;ExcelDateRowStartCol=9
|
|
;ExcelDateRowStartCol=8
|
|
;ExcelDateRowEndValue=TOTAL
|
|
;ExcelDataStartRow=6
|
|
;ExcelDataEndJudgeCol=8
|
|
;ExcelDataEndJudgeCol=7
|
|
;ExcelDataEndJudgeValue=
|
|
;ExcelMcSeisanFukaRowJudgeCol=2
|
|
;ExcelMcSeisanFukaRowJudgeValues=MC生産負荷(2交替),ﾏﾙﾁ生産負荷(2交替)
|
|
;ExcelMcSeisanFukaRowJudgeValuePattern=*生産負荷*
|
|
;NameToIdListForLine=MC,57|MULTI,58|50号機,50|マルチ,58|RFS/A,901|T/T,902
|
|
;ExcelAfWeCol=8
|
|
;ExcelAfWeCol=7
|
|
;CsvTempFolder=C:\CSV\溶接加工計画
|
|
;CsvFileNameTactManagement=TactManagement.csv
|
|
;CsvFileNameWeOrder=WeOrder
|
|
;FileDtPrefix=yyyyMMdd-HHmmss_
|
|
;FileDtSuffix=_yyyyMMdd_HHmmss
|
|
;CsvEncoding=UTF-8 With BOM
|
|
;[CsvToDb]
|
|
;Title=CSV to DB 処理（溶接加工向けデータ連携ツール）
|
|
;DaysToStartOffset=2
|
|
;CsvFileNamePatterns=*TactManagement*.csv,*WeOrder*.csv
|
|
;CsvFileNamePatterns=*WeOrder*.csv
|
|
;CsvTempFolder=C:\CSV\DL
|
|
;CsvEncoding=UTF-8 With BOM
|
|
;DbProviderName=ポスグレ
|
|
;DbConnectionString=Host=localhost;Port=5432;Database=postgres;Username=postgres;Password=sfsadmin
|
|
;DbConnectionString=Host=localhost;Port=5432;Database=postgres;Username=postgres;Password=sfsadmin;ENCODING=SJIS
|
|
;DeleteBeforeInsertSqlFiles=,DeleteBeforeInsertWeOrder
|
|
;DeleteBeforeInsertSqlFiles=DeleteBeforeInsertWeOrder
|
|
;DeleteBeforeInsertSqlFiles=DELETE FROM vap.t_weorder WHERE we_product_date >= :START_DATE;
|
|
;InsertSqlFiles=InsertTactManagement,InsertWeOrder
|
|
;InsertSqlFiles=InsertWeOrder
|
|
;DupCheckSqlFiles=DupCheckTactManagement,
|
|
;DupCheckSqlFiles=
|
|
;ActionAfterDbRegist=BACKUP
|
|
;[Backup]
|
|
;SourceFolderPath=C:\CSV\DL
|
|
;DestinationFolderPath=C:\CSV\DL\Backup001
|
|
;FileNamePatterns=*TactManagement*.csv,*WeOrder*.csv
|
|
;FileNamePatterns=*WeOrder*.csv
|
|
;MaxDays=30
|
|
;MaxFileCount=30
|
|
;PrefixDtFormat=yyyy-MM-dd-HH-mm-ss_
|
|
;SuffixDtFormat=_yyyyMMddHHmmss
|
|
;[SFTP]
|
|
;Host=aaaaaaa
|
|
;Host=172.316.137 // 先週のアドレス！
|
|
;Host=172.23.86.69
|
|
;Port=5432
|
|
;Port=22
|
|
;UserName=aaaa
|
|
;UserName=noboru
|
|
;PrivateKeyFilePath=C:\Users\jpa01378\id_rsa_dotnetああああああ
|
|
;PrivateKeyFilePath=C:\Users\jpa01378\id_rsa_dotnet
|
|
;PassPhrase=bbbbb
|
|
;PassPhrase=uI14MRtLpR7iLxWvaTGFfw==
|
|
;RemotePath=bbb
|
|
;InFolderPath=C:\CSV\溶接加工計画
|
|
;OutFolderPath=C:\CSV\DL
|
|
;FileNamePatterns=*WeOrder*.csv
|
|
;ActionAfterSFTPDownload=DELETE
|
|
;ActionAfterSFTPUpload=CLEANUP(Cleanup)
|
|
;[Cleanup]
|
|
;FolderPath=C:\CSV\DL
|
|
;MaxDays=7
|
|
;MaxFileCount=100
|