+13I am using FME to update (Insert mode) an existing Google Fusion table. My FME Workspace runs successfully with no errors and shows that it writes the features. However, the Google Fusion table shows no edits or features inserted. Any ideas? My Google Fusion writer has the credentials of the owner of the Google Fusion table so permissions should not be an issue.
Thanks,
Sasha
+2Hi @sashalockamy,
I believe the issue you are experiencing has to do with the Google Fusion Table Writer Parameters. Since you are writing to an existing table, you will have to set the Drop Existing Table parameter to Yes.
According to the Google Fusion Table Writer Documentation, Drop Existing Table should be used "if the table exists by this name, it should be dropped and recreated before any features are written to it. This option is only valid when creating a new table."
Alternatively, you can achieve a similar result by setting the Truncate Existing Table parameter to yes - "If the table exists by this name, it should be truncated before any features are written to it. This option will result in an empty table if combined with UPDATE or DELETE mode."
After you change the Writer parameters, run the workspace and open the Google Fusion Table or refresh the page and you should see the changes.
Hope this helps.
- Chris
+13Hi @sashalockamy,
I believe the issue you are experiencing has to do with the Google Fusion Table Writer Parameters. Since you are writing to an existing table, you will have to set the Drop Existing Table parameter to Yes.
According to the Google Fusion Table Writer Documentation, Drop Existing Table should be used "if the table exists by this name, it should be dropped and recreated before any features are written to it. This option is only valid when creating a new table."
Alternatively, you can achieve a similar result by setting the Truncate Existing Table parameter to yes - "If the table exists by this name, it should be truncated before any features are written to it. This option will result in an empty table if combined with UPDATE or DELETE mode."
After you change the Writer parameters, run the workspace and open the Google Fusion Table or refresh the page and you should see the changes.
Hope this helps.
- Chris
Thank you @ChrisAtSafe!
So, is it not possible to update the existing table with new records when writing to Google Fusion Tables? Sounds like you are suggesting this and that I will need to create a new or overwrite it completely.
-Sasha
+13Thank you @ChrisAtSafe!
So, is it not possible to update the existing table with new records when writing to Google Fusion Tables? Sounds like you are suggesting this and that I will need to create a new or overwrite it completely.
-Sasha
