0007883: Batch data input support for every transaction/entry window

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007883

Openbravo ERP

A. Platform

public

2009-02-28 05:48

2009-05-22 19:33

Reporter

fisher

Assigned To

iciordia

Priority

normal

Severity

major

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007883: Batch data input support for every transaction/entry window

Description

Currently the system support the initial data import via import template and temporary import table, but this functionality is limited to certain master and transaction data and is master and transaction data specific,not a universal batch data input solution.
Actually during daily ERP operation after go live, it is frequently requested by user to have batch data input support for most of the input transactions from plain text file or excel file. Also for testing the IT need tools to batch input data from the application(to enforce the application validation and back-end data updating logic) other than directly in the database

Steps To Reproduce

Proposed Solution

1.Implement a user data entry recording mechanism, have the recording saved as executable script, make the generated script modifiable.
2.In each entry transaction, Allow the user to record the entry transaction and save the recording as script, and make the necessary changes to the script( define the input file structure/field sequence/formatting; map the source fields to the target transaction fields,define default value, convert field value and some validation rules), allow the user to upload the data file and execute(online, background) the batch data input script. feedback the user the collected system messages during the batch data input execution.

Additional Information