Project

General

Profile

Actions

New Function #57

closed

[ADMIN] 상품 등록 관리/철도역관리 > 엑셀 업로드 (excel upload)

Added by Deca Park over 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
06/07/2023
Due date:
% Done:

0%

Estimated time:
Spent time:

Description

1.Target menu

  • 온라인몰 관리 > 상품 등록 관리 (product management
  • 스마트 오더 관리 > 상품 등록 관리 (product management)
  • 철도역 관리 > 철도역 관리 (station management)

2.Spec

  • refer to attached ppt

Files

Actions #2

Updated by Deca Park over 1 year ago

  • Subject changed from [ADMIN] 상품 등록 관리 > 엑셀 업로드 (excel upload) to [ADMIN] 상품 등록 관리/철도역관리 > 엑셀 업로드 (excel upload)
Actions #3

Updated by Toby Pham over 1 year ago

  • Status changed from New to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions #4

Updated by Deca Park over 1 year ago

[Test Issues]

1.온라인몰 관리 > 상품 등록 관리 (product management) 
  스마트 오더 관리 > 상품 등록 관리 (product management) 
  1) 상품 엑셀 업로드 modal
    a) append guide text like spec
      - 많은 양의 상품을 한꺼번에 수정/등록할 때, 엑셀을 업로드하여 일괄 등록할 수 있습니다.
      - 엑셀 양식은 '양식 다운' 버튼을 통해 다운로드할 수 있습니다.

2.철도역 관리 > 철도역 관리 (station management)
  1) 철도역 엑셀 업로드 modal
    a) append guide text like spec
      - 많은 양의 철도역을 한꺼번에 수정/등록할 때, 엑셀을 업로드하여 일괄 등록할 수 있습니다.
      - 엑셀 양식은 '양식 다운' 버튼을 통해 다운로드할 수 있습니다.
  2) excel file upload (attach file: 철도역등록_양식_20230610-1.xlsx)
    a) upload result
      - excel row count: 1060
      - real upload count: 888 (all data isn't created)

    b) check why all row is not uploaded and lets fix
      - station_lines: if can't find code value, set by NULL

Actions #5

Updated by Deca Park over 1 year ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Deca Park to Toby Pham
Actions #6

Updated by Toby Pham over 1 year ago

  • Status changed from Feedback to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions #7

Updated by Deca Park about 1 year ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Deca Park to Toby Pham

[Station excel upload]

1.logic
  1) station_code (DB: st_station)

  • 'S1000' was inserted mutlple times (no can't be over S1000)
Actions #8

Updated by Toby Pham about 1 year ago

  • Status changed from Feedback to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions #9

Updated by Deca Park about 1 year ago

[ADMIN] 철도역 관리 (station management)

1.철도역 엑셀 업로드 (excel upload)
  1) logic
    - when INSERT st_station, set smart_order_yn = 'N' (NEW)

Actions #10

Updated by Deca Park 8 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF