The google spreadsheet import not updating prefab
			
	
						10 years 6 months ago				#630
		by Zoltrix
	
	
		
			
	
			
			 		
													
	
				The google spreadsheet import not updating prefab was created by Zoltrix			
			
				Hello, I was using the google spreadsheet import (replace) function and it worked fine. However recently it does not update the prefab and just says "Language Source was up to date" in the log, while the google spreadsheet is different. I tried merging, replacing, merging from app to google but nothing makes it pull the new data from google drive.			
					Please Log in or Create an account to join the conversation.
			
	
						10 years 6 months ago				#631
		by Frank
	
	
		
			
					
Are you
  Give I2L 
	5 stars!
Are you
  Please lets us know how to improve it!
					
	
			
			 		
													
	
				Replied by Frank on topic The google spreadsheet import not updating prefab			
			
				Hi,
I have seen that before. Please check the time stamp in the spreadsheet file on the google drive.
What happens is that sometimes changes in the spreadsheet doesn't modify the "modified date" property, so the plugin checks the spreadsheet and sees that there is nothing new to download as the timestamp matches the one it last downloads.
On the WebService I have some code to overcome that issue by using some extended services from google that are able to get more accurate time. However, using those services have a lower daily use limit so it wont be a good idea for when you have lot of players contacting google. So that section of the code is commented out.
The workaround for that issue I have been using so far, is that whenever that happens (which fortunately is rarely) I just open the spreadsheet, make a few modification, close it, open it again, revert those modification, and then I verify that the modified date has changed. After that, the game is able to download the new updates.
Please, check to see if that's your case. If not, I will try reproducing that issue.
Thanks,
Frank
							I have seen that before. Please check the time stamp in the spreadsheet file on the google drive.
What happens is that sometimes changes in the spreadsheet doesn't modify the "modified date" property, so the plugin checks the spreadsheet and sees that there is nothing new to download as the timestamp matches the one it last downloads.
On the WebService I have some code to overcome that issue by using some extended services from google that are able to get more accurate time. However, using those services have a lower daily use limit so it wont be a good idea for when you have lot of players contacting google. So that section of the code is commented out.
The workaround for that issue I have been using so far, is that whenever that happens (which fortunately is rarely) I just open the spreadsheet, make a few modification, close it, open it again, revert those modification, and then I verify that the modified date has changed. After that, the game is able to download the new updates.
Please, check to see if that's your case. If not, I will try reproducing that issue.
Thanks,
Frank
Are you
Are you
To get the betas as soon as they are ready, 
	check this out
				Please Log in or Create an account to join the conversation.
			
	
						10 years 6 months ago				#632
		by Zoltrix
	
	
		
			
	
			
			 		
													
	
				Replied by Zoltrix on topic The google spreadsheet import not updating prefab			
			
				Hey Frank,
thanks for the quick reply!
Yeah I tried to use the web service url with my spreadsheet key manually and i was getting " " as a response which is why i was getting "up to date message".
I followed your advice and verified that the spreadsheet revision list updated and the timestamp changed. However I still get the " " instead of the spreadsheet data...
What is that I can uncomment to pull the data with more accurate time? I can comment it back then. The game is not going to pull translations in real time anyway. Just some dev usage...
					thanks for the quick reply!
Yeah I tried to use the web service url with my spreadsheet key manually and i was getting " " as a response which is why i was getting "up to date message".
I followed your advice and verified that the spreadsheet revision list updated and the timestamp changed. However I still get the " " instead of the spreadsheet data...
What is that I can uncomment to pull the data with more accurate time? I can comment it back then. The game is not going to pull translations in real time anyway. Just some dev usage...
Please Log in or Create an account to join the conversation.
			
	
						10 years 6 months ago		 -  10 years 6 months ago		#633
		by GLeBaTi
	
	
		
			
	
	
			 		
													
	
				Replied by GLeBaTi on topic The google spreadsheet import not updating prefab			
			
				Hello Today, faced with the same problem. Maybe something has changed in scripts.google.com. Solutions are not found until export tables from googledocs as CVS and imported it into I2 (local)
					Keys,Type,Desc,Russian (Russia) [ru-RU],English (United States)
_static_login_bnLogin,Text,,Логин,Login
_static_price,Text,,Цена,Price
		Last edit: 10 years 6 months ago  by GLeBaTi.			
			Please Log in or Create an account to join the conversation.
			
	
						10 years 6 months ago				#635
		by Zoltrix
	
	
		
			
	
			
			 		
													
	
				Replied by Zoltrix on topic The google spreadsheet import not updating prefab			
			
				I can't really use CSV export because I have categories and google ignores those.
Fred, what can be done to fix this? A web service change?
					Fred, what can be done to fix this? A web service change?
Please Log in or Create an account to join the conversation.
			
	
						10 years 6 months ago				#636
		by dchau_hh
	
	
		
			
	
			
			 		
													
	
				Replied by dchau_hh on topic The google spreadsheet import not updating prefab			
			
				I'm having this problem as well now.			
					Please Log in or Create an account to join the conversation.
		Time to create page: 0.202 seconds