iOS - Project 開發過程有用資訊

1. iOS 31 Days 教學網站, 相當不錯. 
2. Example Program - Web Service Call + Process JSON + Show on the TableView 
3. Differences Between XCode Project
4. Pass Data between View Controller
5. Objective-C declared @property attributes (nonatomic, copy, strong, weak) 
6. How to dismiss keyboard when user tap other area outside textfield? 

VMPlayer 7.1 is not working on Ubuntu 15.04 x64 Desktop

今天剛裝了 VMPlayer 7.1, 結果不能 run, 底下是在網路上找到的 solution.

Source URL: http://askubuntu.com/questions/614525/15-04-vmware-player

sudo -s 

curl http://pastie.org/pastes/9934018/download -o /tmp/vmnet-3.19.patch

cd /usr/lib/vmware/modules/source
tar -xf vmnet.tar
patch -p0 -i /tmp/vmnet-3.19.patch
mv vmnet.tar vmnet.tar.SAVED
tar -cf vmnet.tar vmnet-only
rm -r vmnet-only
vmware-modconfig --console --install-all

Ubuntu 15.04 Installation & Setup

• Download Ubuntu 15.04 x64 Desktop 
• Make Start up USB 
• Install  
• Software Update
• Install Chinese Language
• Ubuntu 15.04 is using fcitx. Here is the page about how to setup the Chinese IME for fcitx. 
• For 注音 IME, it cannot commit the word which you inputted when you switch the IME mode. Here is the answer.

• 11 Things To Do After Installing Ubuntu 15.04
• Top Things To Do After Installing Ubuntu 15.04 (Good one)
• Install Google Chrome
• Install Ubuntu restricted extras
• Install Teamviewer 32-bit (64-bit has problem on Ubuntu) 
• Install Pidgin
• Install Skype
• Install pidgin-skype
• Install Filezilla FTP Client
• 最近一直出現 "ttf-mscorefonts-installer" install 不完整, 底下指令解決問題.
  
  sudo apt-get install --reinstall ttf-mscorefonts-installer
• Install Samba and Samba Client
• Install Oracle Java
• Install GIMP
• Install WinFF
• Install KStar (Astronomy)
• Install RAR, 7Zip
• Install SweetHome3D, but not work.  Download the version with java run-time, it works now.
• Install Dia (Graphic, like Visio)
• Install Stellarium (Astronomy) 
• Install K3b (CD/DVD Burn)
• Install SMPlayer (MPlayer Frontend)
• Install Krusader (2 Panel File Manager)
• Install HPIL for HP LaserJet P1006
•  

How to write a text field in MS SQL server to file

最近做ㄧ些 EDI 的東西,由 SQL Server 直接產生 X12 的檔案, 存在 SQL Server 裏. 因為這些檔案必須寫出來變成 Text File, 所以在網路上找方法.

參考網址: https://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/

這個網址上的 Function 可以 Work, 但是有些 SP 在 SQL 中, Default 是被 Disable 掉的, 所以請參考其他兩篇 Post, 去 Enable ㄧ些 System 的 SP.

http://blog.barksoftware.com/2015/05/the-execute-permission-was-denied-on.html

http://blog.barksoftware.com/2015/05/sql-server-enable-xpcmdshell-using.html

另外, 這個 Function 有一個嚴重的問題, 當使用 cursor 去呼叫這個 Function 寫出檔案, 超過 255 個檔案時, 就會 Error 了.  不過現在沒時間去找問題, 將就用吧.

Update: 5/14/2015
這個東西不能將就使用, 我在 SQL 2005 上, 寫出去 Unicode 的 Text File 有問題. 他就好像早期 VB 裡面使用 Unicode 那樣, 寫出去的 File 都是 ASCII + 00.  這個東西還是放棄吧.

SQL SERVER – Enable xp_cmdshell using sp_configure

MS SQL Server 因為安全考量, Default Disable 掉了 xp_cmdshell stored procedure.

參考網址: http://blog.sqlauthority.com/2007/04/26/sql-server-enable-xp_cmdshell-using-sp_configure/

底下是 Enable 的方法

---- To allow advanced options to be changed.
EXEC sp_configure ‘show advanced options’, 1
GO
—- To update the currently configured value for advanced options.
RECONFIGURE
GO
—- To enable the feature.
EXEC sp_configure ‘xp_cmdshell’, 1
GO
—- To update the currently configured value for this feature.
RECONFIGURE
GO

The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

有些與 File 操作有關的 SP 因為安全考量, Default 被 Disable 掉, 底下是 Solution.

參考網址: http://hardimodi.blogspot.com/2013/03/the-execute-permission-was-denied-on.htm

use [master]
GO
GRANT EXECUTE ON [sys].[sp_OASetProperty] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAMethod] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAGetErrorInfo] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OADestroy] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAStop] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OACreate] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAGetProperty] TO [public]
GO
sp_configure 'show advanced options', 1
GO
reconfigure
go

exec sp_configure
go
exec sp_configure 'Ole Automation Procedures', 1
-- Configuration option 'Ole Automation Procedures' changed from 0 to 1. Run the RECONFIGURE statement to install.
go
reconfigure
go

iOS - First Project

Project 目標:

把 Mobile App 當做前台, User Input 一些與 Shipment 有關的 Number, Submit 之後, Call 我提供的 Web Service, 傳回 Status in JSON format, 然後把 Data Show 到手機Front-end.

System Diagram:

Reference Resource:

• Android Restful Webservice Tutorial – How to call RESTful webservice in Android
  http://programmerguru.com/android-tutorial/android-restful-webservice-tutorial-how-to-call-restful-webservice-in-android-part-3/

Android - First Project

Project 目標:

把 Mobile App 當做前台, User Input 一些與 Shipment 有關的 Number, Submit 之後, Call 我提供的 Web Service, 傳回 Status in JSON format, 然後把 Data Show 到手機Front-end.

System Diagram:

Reference Resource:

• Android Restful Webservice Tutorial – How to call RESTful webservice in Android
  http://programmerguru.com/android-tutorial/android-restful-webservice-tutorial-how-to-call-restful-webservice-in-android-part-3/

iOS Development Resource

iOS Dev Center
https://developer.apple.com/devcenter/ios/index.action

Consuming a RESTful Web Service from iOS
https://spring.io/guides/gs/consuming-rest-ios/

iOS Learning - 起步, 環境設定.

如果想要執行 iOS 環境在 PC 上, 請參考下列資料

Link: https://www.youtube.com/watch?v=G-r8CvCnen4
OSX Yosemite 10.10 Retail VMware Image
Google Drive: http://goo.gl/lGzYpB (Full)
Google Drive: http://goo.gl/zYTJtM (3 part)
M.e.d.i.a.fire: http://goo.gl/ge6hVs
T.o.r.r.e.n.t Link: http://goo.gl/fDnjsf (Full)

Optimize Mac OS X 10.10 Yosemite Faster on VMware (Download Link)
http://youtu.be/JYegaG2sSfk

How to Install Bootloader EFI Mac OS on Vmware (Download Links)
http://youtu.be/pHEgz-Ek62c

Enabling Intel VT-X and AMD-V Virtualization in BIOS VMware
http://youtu.be/CbthSKoVF-U

Mac OS X 10.10 Yosemite on AMD Processors on VirtualBox and VMware (Niresh Version 2)
http://youtu.be/CrpOjgBFMF0

Winrar: http://goo.gl/SUs8T1
Vmware Player: http://goo.gl/QCJ5q1
Unlock All 1.3: http://goo.gl/8CECUK

Fix Google drive limit of download: http://youtu.be/p6KnsHtu5-I
Fix Rar File Corrputed :http://youtu.be/xeHdtRdVdgA

請注意, 如果到 VMWare 網站 Download 最新的 VMPlayer, 可能不 Work. 我就是碰到這種狀況, 後來改用早一點版本的 VMPlayer 才 Ok.

另外, 關於 VMWare 的 Unlocker, 請到下列網站去找, 有比較新的版本, 但是這個網站要 Register 之後才可以 Download. 

http://www.insanelymac.com/forum/files/file/339-unlocker/

以上的環境, 我在 Windows 7 x64 上測試過, 一切都很 Ok, 沒有問題. 另外在 Ubuntu 14.04 上也測過, 但是可能因為 RAM 不夠的關係, Performance 相當不好. 

Mac 環境弄好後, 請依照下列 link 進行 XCode 安裝, 然後就可以開始 iOS 的 Development 了.

https://developer.apple.com/library/ios/referencelibrary/GettingStarted/RoadMapiOS/index.html#//apple_ref/doc/uid/TP40011343