Project

General

Profile

Feature #3766

Fitur Import Material Master Data

Added by haykal haykal 2 months ago. Updated 10 days ago.

Status:
User Test
Priority:
High
Assignee:
haykal haykal
Start date:
08/04/2025
Due date:
08/07/2025 (about 2 months late)
% Done:

0%

Estimated time:
Spent time:
10.00 h

Description

Dear Developer,

Minta tolong dibuatkan fitur untk upload Material Master Data. Untk SMENU dan SMENUTXT nya sudah ada. Menunya sudah aku aktifin tapi pas diklik belum kebuka apa-apa

MenuID: PFILOUPMDMATERIAL
Tabel Material Master Data: PMDMAT0001

Menu Path: Logistic & Service > Master Data > Import Master Data > Import Material Master Data
Port: https://tulisan-dev.minovais.com/
DB: MinovaES_Tulisan_Dev (103.153.60.89)

Terimakasih.

Files

Template Import PMDMAT0001 Tulisan.xlsx (9.17 KB) Template Import PMDMAT0001 Tulisan.xlsx haykal haykal, 09/24/2025 02:25 PM
clipboard-202509292315-h2fqi.png (129 KB) clipboard-202509292315-h2fqi.png M Azid Wahyudi, 09/29/2025 11:15 PM
#1

Updated by Kezia Pawitra Yulianti 2 months ago

  • Due date set to 08/07/2025
  • Status changed from New to Assigned
  • Assignee changed from Kezia Pawitra Yulianti to M Azid Wahyudi
  • Priority changed from Normal to High
#2

Updated by haykal haykal 2 months ago

Dear Developer,

Jadi yg diupload ini selain mengisi tabel PMDMAT0001, juga mengisi tabel PMDMAT0004 (menggenerate row).

Untk setiap MaterialID tlg di PMDMAT0004 digenerate 6 row (untk Warehouse 0001, 0002, 0003, 0004, 0005, 0006) dengan stock 0.

Ini sudah pernah didevelop Mbak Yomma ketika save Material Master Data di UI (referensi Redmine #3719)

Terimakasih.

#4

Updated by M Azid Wahyudi 15 days ago

  • Status changed from Assigned to QA Test
  • Assignee changed from M Azid Wahyudi to haykal haykal

dear haykal , udah bisa di test ya sekalian dengan validasi2 yang kita diskusi

di sini validasi ada :
1. externalID tidak boleh kosong
2. externalID tidak boleh sama di excel maupun Mat0001
3. field tipe data decimal dan int tidak boleh kosong dan juga tidak boleh input string { "MAP", "Weight", "UnitWeight", "Length", "Wide", "Height", "UnitDimension" };

sekenario upload :
tidak hanya upload ke Mat0001 tapi juga upload ke Mat0004 jadi untuk ini flow uploadnya ke 2 table

package :
UI (Pages, view dan controller)

settingan Smenu

sp :
UploadInsertMat004 // untuk upload mat0004

CREATE SEQUENCE dbo.Seq_PM_ID
START WITH 1
INCREMENT BY 1;

membuat sequence untuk kebutuhan mat0004

dll :
C:\Users\Azid\Documents\AZID\sourceCode\Client\TULISAN\API2 Update\API2\MinovaES\MinovaIS.MinovaES.Web.Api.V.1\bin\
MinovaIS.MinovaES.Web.Api.V.1
MinovaIS.MinovaES.Data.Element
MinovaIS.MinovaES.HR.SysData

makasih

#5

Updated by haykal haykal 14 days ago

  • Status changed from QA Test to Revise
  • Assignee changed from haykal haykal to M Azid Wahyudi

Sorry Jid, kyknya ada satu lagi deh yg perlu dikasih validasi di Simulate.

Yaitu field Price. Field Price 'kan isinya wajib angka dan gakboleh dikosongin.

Tapi kalo misalnya nambahin ini effortnya gede dan menurut analisa lu kl ini dikosongin gakada masalah ketika insert to table yaudah gapapa gakusah dikerjain.

Terimakasih.

#6

Updated by M Azid Wahyudi 11 days ago

  • Status changed from Revise to QA Test
  • Assignee changed from M Azid Wahyudi to haykal haykal

dear haykal , udah bisa di test ya tambahannya

package : package sebelumnya udah akomodir yang baru

makasih

#7

Updated by haykal haykal 11 days ago

  • Status changed from QA Test to Deploy
  • Assignee changed from haykal haykal to M Azid Wahyudi

Udh Ok.

Nanti malem minta tolong di-deploy ke Prod ya...

Port: https://tulisan.minovais.com/
DB: MinovaES_Tulisan_Prod (103.153.60.89)

Terimakasih.

#8

Updated by M Azid Wahyudi 11 days ago

dear haykal, udah di deploy ya

makasih

#9

Updated by haykal haykal 10 days ago

  • Status changed from Deploy to User Test

Also available in: Atom PDF