Ticket #15129

import時のCSVデータの置き換え機能
오픈 날짜: 2009-02-18 20:27 마지막 업데이트: 2009-09-27 20:02

Reporter:
(Anonymous)
소유자:
Status:
Open [Owner assigned]
Component:
(None)
MileStone:
Priority:
5 - Medium
Severity:
5 - Medium
Resolution:
Accepted
File:
None

Details

登録するCSVデータに対して、DBに挿入前に条件に合致したデータのみ置き換えを行う機能

たとえば、
1,aaa,bbb,true
2,ccc,ddd,false
3,eee,fff,true

のときに

<import ....>
<match columnIndex="3" match="true" value="1"/>
<match columnIndex="3" match="false" value="0"/>
</import>

みたいに書くとDBには
1,aaa,bbb,1
2,ccc,ddd,0
3,eee,fff,1

としてインサートされる。match属性には正規表現が使えるとなお良し

Ticket History (2/2 Histories)

2009-09-27 20:02 Updated by: murakamin
  • Resolution Update from None to Accepted
  • 소유자 Update from (None) to murakamin
  • Milestone Update from (None) to 0.1.6 (closed)
2009-11-09 09:01 Updated by: None

Attachment File List

No attachments

Edit

You are not logged in. I you are not logged in, your comment will be treated as an anonymous post. » Login