Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

wvaibha
2012-01-10 14:51:07

Hi,

I downloaded and tried to use this component in Talend version 4.2.2 (http://www.talendforge.org/exchange/tos … 149#rev149). But it does not show up in the category after restarting talend. I have copied all the relevant files at suggested location in the forum.

Is is compatible to this updated version ?. If not how can i make it compatible to this version.

Thanks
Vaibhav

Nekloth
2010-08-06 15:02:42

The component seems fantastic but it doesn't work for me...

I put the login/password, the spreasheets key and the Sheet.

When launching, it stays in "Starting", and after 20 seconds, I've got a "AuthenticationException"... :-(

Any suggestion ?

Regards, Nekloth

MarcinK
2009-05-12 18:18:04

Hi Thomas,
I hope you are well.

Did you have a chance to make any progress?

Thanks,
Marcin K.

MarcinK
2009-03-23 15:20:08

Hi Thomas,
thanks for that.
I am following that because you are doing perfect work for Talend.
As far as I know only Business Objects with their Labs is offering google spreadsheet connector.
This makes Talend very competitive product on the market.

Looking forward to more news from you soon.

Kind regards,
Marcin K.

ThomasFriebel
2009-03-23 11:53:14

MarcinK wrote:

Thomas,
do you think it is possible for you to create an empty CSV file with headers only on the fly within Talend and upload it?
I found that this is the only was possible at the moment.

I think this will be the way to go, in order to create new worksheets. Though, I'd prefered a more sophisticated solution.

If not then maybe you can do without a creation of a new spreadsheet?
People could create them before, specify its name in component parameters and put data into it.
How about that?

Kind regards,
Marcin K.

You are driving me towards doing it. :-) I won't resist much longer, but give me some more days.

Regards,
Thomas

MarcinK
2009-03-19 15:28:22

Thomas,
do you think it is possible for you to create an empty CSV file with headers only on the fly within Talend and upload it?
I found that this is the only was possible at the moment.

If not then maybe you can do without a creation of a new spreadsheet?
People could create them before, specify its name in component parameters and put data into it.
How about that?

Kind regards,
Marcin K.

ThomasFriebel
2009-03-19 15:11:38

Hello Marci,

Sorry, but due to lack of time I did not even touch that component once.
I'm not quite sure, what your help could look like. If you could find a way, to create a sheet without having to upload row CSV-data that would be good. I haven't done so yet.

MarcinK
2009-03-19 14:28:44

Hi Thomas,
did you have a chance and spend some more time on google spreadsheets connectors?
do you need any help with it?

Kind regards,
Marcin K.

ThomasFriebel
2009-02-27 11:36:18

Thanks,

I will improve the component, for sure. And I'll have a deeper look into the Output-thing. But it'll take I while.

Bye Thomas

MarcinK
2009-02-24 12:33:31

Thomas,
thanks a lot for your new component. You did excellent work and you show that Talend rocks and offers features not available in any other ETL software.

I would suggest to be able to put start and finish (optional) corners with data from google spreadsheet. This would allow people to read data from tables inside spreadsheets and not only raw data.

I am also looking for first release of output component, even if it doesn't create a new spreadsheets at the beginning then it will be huge step forward for many people who use Talend as Business Intelligence component and Office 2.0.

Once again, thanks a lot for your hard work!

Kind regards,
Marcin K.

ThomasFriebel
2009-02-20 16:21:18

Ah, I was not aware of this forum post. I just released a component on Talend Exchange which is exactly what you seem to look for. tGSpreadsheetInput: extension:122

An output-pendant is not finished due to either the lack of documentation or functionality of the gdata-API; I could not find how to create a spreadsheet from ground. I can only append rows to existing worksheets, which is not what I would want to do with such a component.

mhirt
2008-11-27 20:01:17

Hello,

You can report a feature request on our bugtracker.


Thx

Ernst
2008-11-26 22:06:09

Maybe would be more straight forward to use the Java Client library:

http://code.google.com/apis/spreadsheets/code.html

For Perl there is no such thing as I understand

Ernst
2008-11-26 22:03:54

Hi

I was searching the page and forum for this as I expected it already to exist: is it possible to use the Google Docs APIs to make a Google Spreadsheets input and output connector?

This would be a great thing to deal with as data in Google Spreadsheets can be easily accessed by non experienced users with different rights, visualized and even used in widgets that can be added to the users iGoogle page.

The connectors should support authentication. (can be done by post request to: https://www.google.com/accounts/ClientLogin)

Input connector should be able to read from a spreadsheet by defining which spreadsheet and which cells to read. It would be nice if the connector would display the list of available spreadsheets for a configured account (GET http://spreadsheets.google.com/feeds/sp … ivate/full including the auth token). As well the support for structured queries would not be necessary in a first version but nice to have.

Output connector should use the same parameters and allow to replace, update, remove and append data.

Documentation can be found here: http://code.google.com/apis/spreadsheet … tocol.html

Would be nice to see something like this for Talend.

Thanks
Regards
Ernst

Board footer

Powered by FluxBB