Kettle

Kettle - Spoon Release Candidate 1 - 4.0.0

Llibreries previes a instalar de OOOR

sudo apt-get install rubygems

$ sudo gem install ooor
Successfully installed activesupport-2.3.8
Successfully installed activeresource-2.3.8
Successfully installed ooor-1.3.2
3 gems installed
Installing ri documentation for activesupport-2.3.8...
Installing ri documentation for activeresource-2.3.8...
Installing ri documentation for ooor-1.3.2...
Installing RDoc documentation for activesupport-2.3.8...
Installing RDoc documentation for activeresource-2.3.8...
Installing RDoc documentation for ooor-1.3.2...

Ens descarreguem Terminatoor:

1. Copiem el directori terminatooor a plugins/steps/ dins del nostre kettle: plugins/steps/terminatooor/
2. Copiem el fitxer jruby-complete-ooor.jar dins de libext/ del nostre kettle

Si volem tenir instal·lat la terminal de Ruby per a proves:

sudo apt-get install irb

Ens descarreguem la versió 1.2.1. No fem ús de la versió 1.3.x degut a un bug intern de JRuby. Tampoc ens instalarem la versió 2 (s'ha redisenyat completament)

Descomprimim i copiem els fitxers a:

• jruby-ooor.jar → kettle4.1/libext
• La resta de fitxers → kettle4.1/plugins/steps/terminatooor

Executar la transformació per terminal:

./pan.sh -file /home/resteve/Escriptori/terminatoor/partner.ktr

• Spoon is a graphical user interface that allows you to design transformations and jobs that can be run with the Kettle tools Pan and Kitchen.
• Pan is a data transformation engine that is capable of performing a multitude of functions such as reading, manipulating and writing data to and from various data sources.
• Kitchen is a program that can execute jobs designed by Spoon in XML or in a database repository. Usually jobs are scheduled in batch mode to be run automatically at regular intervals.

Consultar API de OOOR i Introducing OOOR – OpenObject On Rails

Exemple de Partner

partner = ResPartner.find(:first, :domain => [['code_mfweb','=',code_id]])

puts "PARTNER"
puts partner

if partner
	partner.name = name
	partner.vat = vat
	partner.vat_mf = vat_mf
	partner.save
else
	partner = ResPartner.new(
		:name => name,
		:code_mfweb => code_id,
		:vat => vat,
		:vat_mf => vat_mf
	)
	partner.save
end

partner_id = partner.id

# CONTACT =====================
contact = ResPartnerAddress.find(:first, :domain => [['partner_id','=',partner_id]])

if contact
	contact.name = name
	contact.street = street_value
	contact.zip = zip
	contact.city = city_value
	contact.phone = phone
	contact.mobile = mobile
	contact.email = email
	contact.save
else
	contact = ResPartnerAddress.new(
		:partner_id => partner_id, 
		:name => name,
		:street => street_value,
		:zip => zip,
		:city => city_value,
		:phone => phone,
		:mobile => mobile,
		:email => mail
	)
	contact.save
end