Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajorhave not tried2009-02-28 05:482009-05-22 19:33
ReporterfisherView Statuspublic 
Assigned Toiciordia 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

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

DescriptionCurrently 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
Proposed Solution1.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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks feature request 0004117 closedpjuvara Data import improvements 

-  Notes
pjuvara (reporter)
2009-03-03 19:23

Please notice that release 2.50 provides a full set of REST web services that allow you to import any transaction.

This is not exactly what you are asking for since it is not easy to use for end users but it is a step forward.

- Issue History
Date Modified Username Field Change
2009-02-28 05:48 fisher New Issue
2009-02-28 05:48 fisher Assigned To => rafaroda
2009-03-03 12:25 rafaroda Assigned To rafaroda => pjuvara
2009-03-03 19:22 pjuvara Status new => acknowledged
2009-03-03 19:22 pjuvara Relationship added blocks 0004117
2009-03-03 19:23 pjuvara Note Added: 0014338
2009-05-22 19:33 pjuvara Assigned To pjuvara => iciordia

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker