Contents

require 'nexus/nexus_ar'

db_connection AppConfig.connections[:nexusdb]

import(:nexus_import) do	
	importing :User do
		force_upcase
		identity_by :USERID
		columns :full_name => none
				#:userid => write_to(:USERID),
				#:email => :EMAIL,
				
	end
	
	##FIX: no puede ser LineItem pq hay varios documentos -> LineOrder
	importing :LineItems do
		force_upcase	
		identity_by :PARAM1
		columns :id => :PARAM1,
			:product_id => :CODART,
			:price => :PRCMONEDA,
			:quantity => :UNIDADES,
			:order_id => lookup(	:write_to => :IDPEDV, 
														#:table => :Order, 
														:key => :PARAM1, 
														:value => :IDPEDV)
			
	end

	importing :Order do
		force_upcase
		identity_by :PARAM1
		columns :userid => lookup(	:write_to => :CODCLI, 
																:table => :User, :key => :USERID, 
																:value => :CODCLI),
						:tax_amount  => none,
						:item_total  => none,
						:ip_address  => none,
						:created_at  => none,
						:item_total  => none,
						:reference   => :REFERENCIA,
						:status      => none,
						:ship_amount => none,
						:total       => none,
						:updated_at  => none,
						:ship_method => none,
						:id          => none,
						:number      => :PARAM1,
						:special_instructions => :OBSERVACIONES
	end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
jcangas-datagateway-1.2.2	lib/datagateway/jobs/nexus_import.rb