其他 匯入匯出 A&P 資料

本文由 黃sir 在 2014-07-17 發表於 "WebSAMS 討論區" 討論區

  1. 104285

    黃sir
    Expand Collapse
    Staff Member

    文章:
    180
    讚:
    0
    想問問獎懲的匯入匯出問題:

    匯入:
    我透過獎懲的匯入,得到一個 Excel,有以下欄位
    REG NO. SCHOOL YEAR ANP DATE ANP TYPE DESCRIPTION EVENT CODE LVL1 LVL2 LVL3 LVL4 LVL5 CONDUCT MARK STAFF CODE PRINT INDICATOR REPORT CARD PRINT SEQ AWARD FROM CODE AWARD CATEGORY CODE ANTECEDENCE ADDENDUM REMARKS ACTION TAKEN CODE ACTION TAKEN DATE FROM ACTION TAKEN DATE TO DETENTION CLASS INDICATOR SLP READABLE INDICATOR SLP REMARKS OTHER LANGUAGE OTHER ANTECEDENCE OTHER ADDENDUM OTHER DESCRIPTION

    我也看過「獎懲資料的規格表」,但因為當中沒有例子,很難嘗試,有沒有多一些 Example for Reference

    匯出:
    本想透過匯出查解如何進行匯入,但在匯出時,出現以下 error
    =========================================================
    Referer = https://websams.lkyms.edu.hk/jsp/menu.jsp

    javax.servlet.ServletException: No getter method available for property schoolSessionIdList for bean under name null at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471) at org.apache.jsp.S_0002dANP10_0002d01$jsp._jspService(S_0002dANP10_0002d01$jsp.java:1458) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:683) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:431) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:355) at org.apache.struts.action.ActionServlet.processActionForward(ActionServlet.java:1759) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1596) at websams.web.WSActionServlet.process(WSActionServlet.java:322) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at websams.util.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:236) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at websams.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:245) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) at java.lang.Thread.run(Thread.java:484)
    =========================================================

    請指教!
     
  2. 57484480

    潛行空間
    Expand Collapse

    文章:
    125
    讚:
    0
    你的想法很正確,只要能匯出 A&P ,便可以得到最現成及最貼近學校實況的 Example 了。
    正常情況下:獎懲資料 > 匯出,會有以下畫面。
    screenshot.4.jpg

    不過當你匯出時出現 error,便要先解決這問題。
    通常 error message 前都會附送錯誤理由和解決方法,跟據大段的 Java 看來,應該是漏了些東西,但沒明顯指出來。最好還是致電 網上校管系統求助台熱線
    3125 8510 查詢。
    screenshot.2.jpg

    以下是一些 獎懲資料 > 匯出 /匯入的經驗:
    1. 匯出檔案和匯入檔案的欄位並不相同
    2. 要分辨清楚數字格式 / 文字格式,0 / 空白 / 漏空 的分別
    3. 匯入後只會增新獎懲,不會修改WebSAMS原有獎懲
    4. 切記不要將原來匯出的檔案,修改後再匯入,否則獎懲紀錄會重複,WebSAMS 沒有整批刪除獎懲紀錄功能。做錯了一定後悔。
     
    #2 潛行空間, 2014-07-17