SQL Power Software Forum

I try your solution and I'm looking for the data showed on your screenshot at http://www.sqlpower.ca/page/MatchMaker?slide=2

This data are not built in with your solution. When I can download this table?

Thanks a lot

This message was edited 1 time. Last update was at 2008-02-04 10:29:03

Hi nicolas,

Yes, you can download the translation tables, and it's very simple!

First, Click on the 'Translation Groups' table. Then you should see three buttons on the bottom of the right panel. One of them should say something like 'Get online list'. Click that, and the translation tables should be downloaded.

Please let us know if that doesn't work.

This message was edited 1 time. Last update was at 2008-05-25 07:06:53

Firstly, thank you for this wonderful product!

I can get to the spreadsheet directly at:

http://spreadsheets.google.com/pub?key=pIOfRi4wZwIh1eNPmWCRhPQ

When I try to import within the application, I get the following error:

java.lang.RuntimeException: Error could not generate translation words from google spreadsheet!
at ca.sqlpower.matchmaker.swingui.TranslateGroupsEditor.getOnlineTranslateGroup(Unknown Source)
at ca.sqlpower.matchmaker.swingui.TranslateGroupsEditor.access$400(Unknown Source)
at ca.sqlpower.matchmaker.swingui.TranslateGroupsEditor$2.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.<init>(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at com.google.gdata.client.http.HttpGDataRequest.execute(Unknown Source)
at com.google.gdata.client.http.GoogleGDataRequest.execute(Unknown Source)
at com.google.gdata.client.Service.getFeed(Unknown Source)
at com.google.gdata.client.Service.getFeed(Unknown Source)
at com.google.gdata.client.GoogleService.getFeed(Unknown Source)
at com.google.gdata.client.Service.getFeed(Unknown Source)
... 28 more

The key is here:

Caused by: java.net.ConnectException: Connection refused: connect

It looks like your web browser is able to connect to spreadsheets.google.com, but your Java runtime is not.

Do you have to connect to the web via an HTTP proxy? That's the most likely explanation for this.

If you do need to use a proxy, we can probably help you set up your Java runtime to use it. I don't know the steps off the top of my head, so let's confirm this is the problem before proceeding.

-Jonathan

Thanks. I configured Java to use the proxy server but I still get the same message.

Don't worry about it though. In looking at the list, it is doing the opposite of what I'm trying to accomplish.

Kind regards,
Chuck