SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Where is the translation tables for Address Standardization?  XML
Forum Index » SQL Power DQguru Discussion
Author Message
nicolas


Joined: 2008-02-03 16:50:49
Messages: 1
Offline

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
Jeff
SQL Power Developer
[Avatar]

Joined: 2007-06-27 18:31:33
Messages: 410
Offline

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-02-04 10:29:03


-Jeff
ofaniel


Joined: 2008-05-25 07:04:23
Messages: 2
Offline

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

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

Jonathan
SQL Power Developer

Joined: 2007-01-08 15:10:32
Messages: 873
Offline

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
ofaniel


Joined: 2008-05-25 07:04:23
Messages: 2
Offline

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
 
Forum Index » SQL Power DQguru Discussion
Go to:   
Powered by JForum 2.1.8 © JForum Team