Talend community forum / [resolved] creating a business component with TOS

aymen.bs · 2010-02-22 15:57:19

Tags: [business component, Cegid, connector, development, erp, Gforge, java]

Hello,
my question is: It's possible to create a business component with TOS?
for me,business component means something similar to a connector between Talend and an ERP or a CRM such as Cegid or Gforge.
It's very important to me to know the response.
THANKS FOR YOUR HELP.

aymen.bs · 2010-02-22 17:12:40

Can someone answer me,please

aymen.bs · 2010-02-23 12:14:25

After searching,i found that's possible to create a business connector with TOS.
the connector is between NetSuite (an american ERP) and an external application.
it's develloped by a Canadian company.

http://www.it-ration.ca/produits/connecteur

dhock · 2010-04-07 19:18:44

Hi,

I uploaded a tNetsuiteInput component today you may find useful. I have tNetsuiteOutput and others ready for upload as well.

http://www.talendforge.org/exchange/tos/extension_view.php?eid=280

I find them very useful.

Jason Sullivan · 2010-04-20 05:16:39

Hello dhock I have just downloaded the tNetsuiteInput component and would be interested in the other components.

Regards
Jason

edhancock · 2010-04-27 06:18:47

I would like the tNetSuiteOutput component also

Thanks
Ed

isidoror · 2010-05-07 11:09:58

Hi dhock,
I'm also interested in the tNetsuiteOutput component.
Also, when running tNestuiteImput I get this error:
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/log4j/Logger...
...
Regards,
Isidoro

shong · 2010-05-08 06:04:01

Hi All
I just notify this post to dhock, hope that he will receive the email and come back!

Best regards
Shong

dhock · 2010-05-08 17:09:19

hi all, I will try to get it posted by the end of the week. I need to take the dependency on log4j out.

dhock · 2010-05-18 21:49:16

Hi, I posted the tnetsuiteoutput component.

Note it requires the tnetsuiteinput

The NEW tnestuiteinput doesn't require log4j so please download.

Best practice is to create a context for the credentials and place the context values in the component settings.
If you have a sandbox account, create a qa context for it.

dhock · 2010-05-18 21:50:36

Note, I have 2 other components for list input/output for stuff like invoice items, addresses....

Problem is I don't like the design so I am hesitant to release in current form.

Triples · 2011-02-09 14:55:01

This post is for dhock. I am new to Talend and Netsuite. I am looking for solutions to integrate both and these components look like they would do the trick. The issue I am having is I am runing TOS 4.1.2, and these components appear only to work for 3.1 and 3.2. I tried installing them in 4.1.2 and they did not appear in the pallet.

Question is do you have updated components and any other comments you are willing to share?

Thanks

Michael

shong · 2011-02-11 02:34:57

Hi Michael
Can you confirm that these components only work for v3.1? If so, it should works also in v4.1.2. If the component works for v3.0, we need modify a little to make it work in v3.1 or higher.

Best regards
Shong

Triples · 2011-02-14 23:13:45

Shong,

Thanks for getting back to me. I got them to work in 3.1, not 4.x. Could you please modify them for 4.x, I would rather work with 4.x. Also, I am looking for the timout parameter. The components work 1 out of 10 times.... the other 9 times they get the following error. I don't have a proxy set up so that is not the issue...

thanks

Michael

java.net.ConnectException: Connection timed out: connect
Exception in component tNetsuiteInput_1
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.ConnectException: Connection timed out: connect
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:189)
at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:103)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.netsuite.webservices.platform_2009_2.NetSuiteBindingStub.search(NetSuiteBindingStub.java:9897)
at org.talend.netsuite.NetSuiteManagement.search(NetSuiteManagement.java:1109)
at org.talend.netsuite.NetSuiteManagement.search(NetSuiteManagement.java:788)
at netsuite_integration.ohl_sss_945_0_1.OHL_SSS_945.tNetsuiteInput_1Process(OHL_SSS_945.java:3074)
at netsuite_integration.ohl_sss_945_0_1.OHL_SSS_945$1.run(OHL_SSS_945.java:5545)

{http://xml.apache.org/axis/}hostname:mmelanson-PC

java.net.ConnectException: Connection timed out: connect
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.netsuite.webservices.platform_2009_2.NetSuiteBindingStub.search(NetSuiteBindingStub.java:9897)
at org.talend.netsuite.NetSuiteManagement.search(NetSuiteManagement.java:1109)
at org.talend.netsuite.NetSuiteManagement.search(NetSuiteManagement.java:788)
at netsuite_integration.ohl_sss_945_0_1.OHL_SSS_945.tNetsuiteInput_1Process(OHL_SSS_945.java:3074)
at netsuite_integration.ohl_sss_945_0_1.OHL_SSS_945$1.run(OHL_SSS_945.java:5545)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:189)
at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:103)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
... 14 more

shong · 2011-02-15 04:05:02

Hi

I got them to work in 3.1, not 4.x. Could you please modify them for 4.x,

I try to install the component in v412 and it appears in the palette(see my screenshot). Don't you?
I see there is not a timeout parameter in the component, however, tNetsuiteInput_1 is not a official component, it is shared by other users dhock on exchange, so we can't modify it. I will notify this post to dhock, hope he will return back to us!

Best regards
Shong

Uploaded Images

TripleS · 2011-02-15 16:37:28

Shong,

I can't get the component to load in 4.1. I did the same thing I did for 3.x I copied the extracted folder to

C:\talend\TOS-Win32-r53829-V4.2.0M2\plugins\org.talend.designer.components.localprovider_4.2.0.M2_r53829\components\

where talend is the install directory. I restarted Talend. In reading previous threads, I have checked the metadata log, this is all I have;

!SESSION 2011-02-15 10:11:13.308 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_23
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.talend.platform.logging 1 0 2011-02-15 10:13:18.294
!MESSAGE 2011-02-15 10:13:18,291 INFO org.talend.core.repository.model.ProxyRepositoryFactory - XXXXX@xxxxx.com logged on TALENDDEMOSJAVA

TripleS · 2011-02-16 23:12:38

I was able to resolve both issues.

First, it works on version TOS-Win32-r43983-V4.1.0M1 NOT TOS-Win32-r53829-V4.2.0M2..... very odd.

Second, the "timeout" is related to version of the axis.jar. You need to replace it with the latest version. This was a NetSuite issue, you can find information here

http://bit.ly/e6iGcg

bhash, if you would like to share more components, it would be greatly appreciated. Please contact me here....

Michael

JamWil · 2011-11-14 14:34:27

Hi dhock

I am not sure if you are still watching this thread, but I wondered if you could tell me if your tnetsuiteoutput component will be able to push a) Products (= Items of inventory), b) Invoices and invoice line items, and c) Custom Record Type records into Netsuite?

Thx
James

olivier.simard · 2011-11-23 21:18:43

Hi JamWil,

To answer your question: yes, it is possible to push InventoryItem record, Invoice record with line items and Custom record with tNetSuiteOutput.

Here is a print screen of those records being added/updated to NetSuite :
https://system.netsuite.com/core/media/media.nl?id=39392&c=427310&h=3834489c72f44e9a7b98

You can download the new tNetSuiteOuput version here : http://www.talendforge.org/exchange/index.php?eid=419&product=tos&action=view&nav=1,1,1

If you have any comments/questions, do not hesitate to contact me.

Last edited by olivier.simard (2011-11-23 21:22:46)

Announcement

Unanswered posts

#1 2010-02-22 15:57:19

[resolved] creating a business component with TOS

#2 2010-02-22 17:12:40

Re: [resolved] creating a business component with TOS

#3 2010-02-23 12:14:25

Re: [resolved] creating a business component with TOS

#4 2010-04-07 19:18:44

Re: [resolved] creating a business component with TOS

#5 2010-04-20 05:16:39

Re: [resolved] creating a business component with TOS

#6 2010-04-27 06:18:47

Re: [resolved] creating a business component with TOS

#7 2010-05-07 11:09:58

Re: [resolved] creating a business component with TOS

#8 2010-05-08 06:04:01

Re: [resolved] creating a business component with TOS

#9 2010-05-08 17:09:19

Re: [resolved] creating a business component with TOS

#10 2010-05-18 21:49:16

Re: [resolved] creating a business component with TOS

#11 2010-05-18 21:50:36

Re: [resolved] creating a business component with TOS

#12 2011-02-09 14:55:01

Re: [resolved] creating a business component with TOS

#13 2011-02-11 02:34:57

Re: [resolved] creating a business component with TOS

#14 2011-02-14 23:13:45

Re: [resolved] creating a business component with TOS

#15 2011-02-15 04:05:02

Re: [resolved] creating a business component with TOS

#16 2011-02-15 16:37:28

Re: [resolved] creating a business component with TOS

#17 2011-02-16 23:12:38

Re: [resolved] creating a business component with TOS

#18 2011-11-14 14:34:27

Re: [resolved] creating a business component with TOS

#19 2011-11-23 21:18:43

Re: [resolved] creating a business component with TOS

Board footer