osCommerce Data Exchange

osCommerce Data Synchronizer or osCommerce Product Data Exchange (oscdatsync or oscprodatex)
Tasklist

FS#345 - Initial ideas

Attached to Project: osCommerce Data Exchange
Opened by Mario A. Valdez-Ramirez (mvaldez) - Wednesday, 27 June 2007, 03:39 GMT-6
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Wednesday, 27 June 2007, 03:40 GMT-6
Task Type Idea
Category Backend / Core
Status Assigned
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity High
Priority High
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 0
Private No

Details

Capabilities:

Synchronize between data repositories.
Bidirectional or unidirectional.
Unidirectional works like import or export.
Data sources:
CSV files (with arbitrary separator).
OSCommerce stores.
OpenOffice files.
ODBC sources.
This task depends upon

Comment by Mario A. Valdez-Ramirez (mvaldez) - Wednesday, 27 June 2007, 03:40 GMT-6
Use case: Synchronize two repositories

1. User selects data source.
The system displays the options available: CSV file and OSCommerce store.
The system displays the required metadata to retrieve the data: for CSV files the filename, for osCommerce stores the connection settings.
The system reads the selected data source and checks its format. The format is arbitrary, not user defined.
The system displays a preview of the data source.
The user confirms the data is correct.

2. User selects data target.
The system displays the options available: CSV file and OSCommerce store.
The system displays the required metadata to retrieve the data: for CSV files the filename, for osCommerce stores the connection settings.

3. User selects synchronization options.
The system displays the options available (in checkboxes): update target values, add missing records in target, delete target records not in source.

4. User runs a test synchronization.
The system do the synchronization without writing anything.
The system display a before and after chart, marking the updated records.

5. User runs the synchronization.
The system do the synchronization and write the result to the target.

8. User review the synchronization result summary.
The system displays a summary of the records changed or any error condition.

Loading...