New Ribbon
翻倍效率工作術–詢問度破表的Office職人技500+ iOS 11+iPhone 8 / 8Plus / X / iPad 完全活用術:225個超進化技巧攻略 翻倍效率工作術:不會就太可惜的Excel+Power BI 大數據視覺圖表設計與分析 會做簡報就會製作跨平台 App:Smart Apps Creator 3 超神開發術 快快樂樂學威力導演15 - 影片/MV剪輯活用情報特蒐 Excel 2016高效實用範例必修16課-善用資料圖表 x 函數巨集的精算達人 中老年人愛用APP全收錄(第二版)<適用iOS+Android雙系統手機及平板 中老年人快樂學拍照、攝影 生活科技應用網路概論(第二版) 中老年人快樂學電腦(Windows 10+Office 2016) 中老年人快樂學Facebook+LINE 翻倍效率工作術:不會就太可惜的Google超極限應用(第二版) 翻倍效率工作術:不會就太可惜的Excel必學圖表 翻倍效率工作術:不會就太可惜的Excel必學函數

 

  空氣品質即時監測及網路微資料庫

小王

小王
更新時間:2017/11/25 下午 10:42:07

 

老師你好
有2個問題
第1.
有關空氣品質即時監測,原始程式執行後不論選擇任何縣市,站位皆是全部出現的狀態。
也就是縣市並沒有只反應自己縣市內的站位。
請問這是正常的嗎?

第2.
最新的使用說明已參考 http://blog.e-happy.com.tw/?p=8113
試了十幾次一直無法發佈網路微資料庫。
會出現 denied: Account disabled. 此訊息。
請問為何會如此?
畫面附件已寄到您的信箱。
環境 win10 64

小王

小王
更新時間:2017/11/26 下午 02:43:49

 

老師你好


有關於發佈網路微資料庫部份
後來更新 customtinywebdb.zip
同書本 app.yaml  範例

接著會出現如下訊息

C:\customtinywebdb\appinventordb>gcloud app deploy
Services to deploy:

descriptor:      [C:\customtinywebdb\appinventordb\app.yaml]
source:          [C:\customtinywebdb\appinventordb]
target project:  [tinywebdb2017-chen]
target service:  [default]
target version:  [20171126t143336]
target url:      [https://tinywebdb2017-chen.appspot.com]


Do you want to continue (Y/n)?  y

Beginning deployment of service [default]...
Some files were skipped. Pass `--verbosity=info` to see which ones.
You may also view the gcloud log file, found at
[C:\Users\ffs\AppData\Roaming\gcloud\logs\2017.11.26\14.33.34.494000.log].
#============================================================#
#= Uploading 4 files to Google Cloud Storage                =#
#============================================================#
File upload done.
ERROR: gcloud crashed (UnicodeDecodeError): 'utf8' codec can't decode byte 0xbd in position 6: invalid start byte

If you would like to report this issue, please run the following command:
  gcloud feedback

To check gcloud for common problems, please run the following command:
  gcloud info --run-diagnostics

小王

小王
更新時間:2017/11/26 下午 02:45:24

 

這是  
C:\Users\ffs\AppData\Roaming\gcloud\logs\2017.11.26\14.33.34.494000.log  的內容


2017-11-26 14:33:34,497 DEBUG    root            Loaded Command Group: ['gcloud', 'app']
2017-11-26 14:33:34,707 DEBUG    root            Loaded Command Group: ['gcloud', 'app', 'deploy']
2017-11-26 14:33:34,710 DEBUG    root            Running [gcloud.app.deploy] with arguments: []
2017-11-26 14:33:34,732 DEBUG    root            No staging command found for runtime [python27] and environment [STANDARD].
2017-11-26 14:33:34,732 DEBUG    root            API endpoint: [https://appengine.googleapis.com/], API version: [v1]
2017-11-26 14:33:36,516 INFO     ___FILE_ONLY___ Services to deploy:


2017-11-26 14:33:36,519 INFO     ___FILE_ONLY___ descriptor:      [C:\customtinywebdb\appinventordb\app.yaml]
source:          [C:\customtinywebdb\appinventordb]
target project:  [tinywebdb2017-chen]
target service:  [default]
target version:  [20171126t143336]
target url:      [https://tinywebdb2017-chen.appspot.com]



2017-11-26 14:33:39,967 DEBUG    root            No bucket specified, retrieving default bucket.
2017-11-26 14:33:39,971 DEBUG    root            Using bucket [gs://staging.tinywebdb2017-chen.appspot.com].
2017-11-26 14:33:40,200 INFO     ___FILE_ONLY___ Beginning deployment of service [default]...

2017-11-26 14:33:40,206 INFO     root            Ignoring file [.DS_Store]: File matches ignore regex.
2017-11-26 14:33:40,211 INFO     root            Ignoring file [main.pyc]: File matches ignore regex.
2017-11-26 14:33:40,213 INFO     ___FILE_ONLY___ Some files were skipped. Pass `--verbosity=info` to see which ones.

2017-11-26 14:33:40,213 INFO     ___FILE_ONLY___ You may also view the gcloud log file, found at
[C:\Users\ffs\AppData\Roaming\gcloud\logs\2017.11.26\14.33.34.494000.log].

2017-11-26 14:33:40,223 DEBUG    root            Could not call git with args ('config', '--get-regexp', 'remote\\.(.*)\\.url'): [Error 2] 系統找不到指定的檔案。
2017-11-26 14:33:40,223 INFO     root            Could not find any remote repositories associated with [C:\customtinywebdb\appinventordb]. Cloud diagnostic tools may not be able to display the correct source code for this deployment.
2017-11-26 14:33:40,638 DEBUG    root            Skipping upload of [index.html]
2017-11-26 14:33:40,638 DEBUG    root            Skipping upload of [main.py]
2017-11-26 14:33:40,638 DEBUG    root            Skipping upload of [index.yaml]
2017-11-26 14:33:40,638 DEBUG    root            Skipping upload of [images/customLogo.gif]
2017-11-26 14:33:40,638 DEBUG    root            Skipping upload of [app.yaml]
2017-11-26 14:33:40,638 DEBUG    root            Skipping upload of [app - 複製.yaml]
2017-11-26 14:33:40,640 INFO     root            Incremental upload skipped 100.0% of data
2017-11-26 14:33:40,640 DEBUG    root            Uploading 0 files to Google Cloud Storage
2017-11-26 14:33:40,640 DEBUG    root            Using [16] threads
2017-11-26 14:33:40,641 INFO     ___FILE_ONLY___ #============================================================#

2017-11-26 14:33:40,641 INFO     ___FILE_ONLY___ #= Uploading 0 files to Google Cloud Storage                =#

2017-11-26 14:33:40,642 INFO     ___FILE_ONLY___ #
2017-11-26 14:33:40,647 INFO     ___FILE_ONLY___ ============================================================
2017-11-26 14:33:40,648 INFO     ___FILE_ONLY___ #

2017-11-26 14:33:40,648 INFO     ___FILE_ONLY___ File upload done.

2017-11-26 14:33:40,648 INFO     root            Manifest: [{'index.html': {'sourceUrl': 'https://storage.googleapis.com/staging.tinywebdb2017-chen.appspot.com/20ceef1792b898c79d2461d9a7cb4c104d466ec3', 'sha1Sum': '20ceef1792b898c79d2461d9a7cb4c104d466ec3'}, 'main.py': {'sourceUrl': 'https://storage.googleapis.com/staging.tinywebdb2017-chen.appspot.com/316034727c9a567a038192dfbd0d3b0626cab374', 'sha1Sum': '316034727c9a567a038192dfbd0d3b0626cab374'}, 'index.yaml': {'sourceUrl': 'https://storage.googleapis.com/staging.tinywebdb2017-chen.appspot.com/8fb781087acb69e32b284109213ae6c361f4bb05', 'sha1Sum': '8fb781087acb69e32b284109213ae6c361f4bb05'}, 'images/customLogo.gif': {'sourceUrl': 'https://storage.googleapis.com/staging.tinywebdb2017-chen.appspot.com/9f33b4ba1da7155c181f4b5e4626a15fd2db45b8', 'sha1Sum': '9f33b4ba1da7155c181f4b5e4626a15fd2db45b8'}, 'app.yaml': {'sourceUrl': 'https://storage.googleapis.com/staging.tinywebdb2017-chen.appspot.com/355174e8b6fa9c37f4df48dde0f07c59353d668d', 'sha1Sum': '355174e8b6fa9c37f4df48dde0f07c59353d668d'}, 'app - \xbd\xc6\xbbs.yaml': {'sourceUrl': 'https://storage.googleapis.com/staging.tinywebdb2017-chen.appspot.com/9f526580101a93e947b1851cf0b4ccff219d7f41', 'sha1Sum': '9f526580101a93e947b1851cf0b4ccff219d7f41'}}]
2017-11-26 14:33:40,653 DEBUG    root            Converted YAML to JSON: "{
  "handlers": [
    {
      "securityLevel": "SECURE_OPTIONAL",
      "staticFiles": {
        "path": "images/\\1",
        "uploadPathRegex": "images/.*"
      },
      "urlRegex": "/images/(.*)"
    },
    {
      "script": {
        "scriptPath": "main.app"
      },
      "securityLevel": "SECURE_OPTIONAL",
      "urlRegex": ".*"
    }
  ],
  "libraries": [
    {
      "name": "django",
      "version": "1.2"
    }
  ],
  "runtime": "python27",
  "runtimeApiVersion": "1",
  "threadsafe": true
}"
2017-11-26 14:33:40,654 DEBUG    root            'utf8' codec can't decode byte 0xbd in position 6: invalid start byte
Traceback (most recent call last):
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\calliope\cli.py", line 789, in Execute
    resources = calliope_command.Run(cli=self, args=args)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\calliope\backend.py", line 756, in Run
    resources = command_instance.Run(args)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\surface\app\deploy.py", line 65, in Run
    parallel_build=False)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\command_lib\app\deploy_util.py", line 587, in RunDeploy
    flex_image_build_option=flex_image_build_option)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\command_lib\app\deploy_util.py", line 395, in Deploy
    extra_config_settings)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\api_lib\app\appengine_api_client.py", line 164, in DeployService
    service_config, manifest, version_id, build, extra_config_settings)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\api_lib\app\appengine_api_client.py", line 599, in _CreateVersionResource
    json_version_resource)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\bin\..\lib\third_party\apitools\base\py\encoding.py", line 133, in PyValueToMessage
    return JsonToMessage(message_type, json.dumps(value))
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\bundledpython\lib\json\__init__.py", line 244, in dumps
    return _default_encoder.encode(obj)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\bundledpython\lib\json\encoder.py", line 207, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\bundledpython\lib\json\encoder.py", line 270, in iterencode
    return _iterencode(o, 0)
UnicodeDecodeError: 'utf8' codec can't decode byte 0xbd in position 6: invalid start byte
2017-11-26 14:33:40,655 ERROR    ___FILE_ONLY___ BEGIN CRASH STACKTRACE
Traceback (most recent call last):
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\gcloud_main.py", line 147, in main
    gcloud_cli.Execute()
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\calliope\cli.py", line 815, in Execute
    self._HandleAllErrors(exc, command_path_string, specified_arg_names)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\calliope\cli.py", line 853, in _HandleAllErrors
    exceptions.HandleError(exc, command_path_string, self.__known_error_handler)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\calliope\cli.py", line 789, in Execute
    resources = calliope_command.Run(cli=self, args=args)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\calliope\backend.py", line 756, in Run
    resources = command_instance.Run(args)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\surface\app\deploy.py", line 65, in Run
    parallel_build=False)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\command_lib\app\deploy_util.py", line 587, in RunDeploy
    flex_image_build_option=flex_image_build_option)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\command_lib\app\deploy_util.py", line 395, in Deploy
    extra_config_settings)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\api_lib\app\appengine_api_client.py", line 164, in DeployService
    service_config, manifest, version_id, build, extra_config_settings)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\lib\googlecloudsdk\api_lib\app\appengine_api_client.py", line 599, in _CreateVersionResource
    json_version_resource)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\bin\..\lib\third_party\apitools\base\py\encoding.py", line 133, in PyValueToMessage
    return JsonToMessage(message_type, json.dumps(value))
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\bundledpython\lib\json\__init__.py", line 244, in dumps
    return _default_encoder.encode(obj)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\bundledpython\lib\json\encoder.py", line 207, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "C:\Users\ffs\AppData\Local\Google\Cloud SDK\google-cloud-sdk\platform\bundledpython\lib\json\encoder.py", line 270, in iterencode
    return _iterencode(o, 0)
UnicodeDecodeError: 'utf8' codec can't decode byte 0xbd in position 6: invalid start byte
2017-11-26 14:33:40,657 ERROR    root            gcloud crashed (UnicodeDecodeError): 'utf8' codec can't decode byte 0xbd in position 6: invalid start byte
2017-11-26 14:33:40,668 INFO     ___FILE_ONLY___
If you would like to report this issue, please run the following command:

2017-11-26 14:33:40,671 INFO     ___FILE_ONLY___   gcloud feedback

2017-11-26 14:33:40,673 INFO     ___FILE_ONLY___
To check gcloud for common problems, please run the following command:

2017-11-26 14:33:40,674 INFO     ___FILE_ONLY___   gcloud info --run-diagnostics

2017-11-26 14:33:40,684 DEBUG    root            Metrics reporting process started...

小王

小王
更新時間:2017/11/26 下午 03:36:20

 

老師你好

發佈網路微資料庫 最後會出現下列訊息

C:\customtinywebdb\appinventordb>gcloud app deploy
Services to deploy:

descriptor:      [C:\customtinywebdb\appinventordb\app.yaml]
source:          [C:\customtinywebdb\appinventordb]
target project:  [neon-implement-187207]
target service:  [default]
target version:  [20171126t153319]
target url:      [https://neon-implement-187207.appspot.com]


Do you want to continue (Y/n)?  y

Beginning deployment of service [default]...
Some files were skipped. Pass `--verbosity=info` to see which ones.
You may also view the gcloud log file, found at
[C:\Users\ffs\AppData\Roaming\gcloud\logs\2017.11.26\15.33.17.482000.log].
#============================================================#
#= Uploading 6 files to Google Cloud Storage                =#
#==================================================================================================================================================================================================================#
File upload done.
ERROR: gcloud crashed (UnicodeDecodeError): 'utf8' codec can't decode byte 0xbd in position 6: invalid start byte

If you would like to report this issue, please run the following command:
  gcloud feedback

To check gcloud for common problems, please run the following command:
  gcloud info --run-diagnostics

C:\customtinywebdb\appinventordb>

小王

小王
更新時間:2017/11/26 下午 06:45:17

 

老師
       謝謝你的協助,問題克服了。^^




 

 

Re:空氣品質即時監測及網路微資料庫

請輸入姓名。

已超出字元數目的最大值。


請輸入電子郵件。

格式無效。


請輸入內容。