Filtered by category ecommerce-g2, 1 - 10 of 20 Postings (
all,
summary)
Created by OpenACS community, last modified by Gustaf Neumann 07 Jun 2017, at 11:02 AM
Status
pre-release (part of the ecommerce-g2 project)
Introduction
There is little consistency between packages for uploading data. Most packages do not offer an import feature. The current practice is to use the database import features directly. This also means creating small scripts or using intermediate applications to manipulate the data prior to import, and using shell commands to get the data into the right security context and location. Mistakes in the import usually have to be corrected with hand-written sql updates. A data importer likely needs to have admin level access and unix level competency, which is beyond the usual skill set required to manage a website application. A bulk-upload package would standardize and ease barriers to setting up and managing OpenACS packages.
Vision Statement
A package that provides standardized UI and import services for bulk uploading data (tables and lists) into existing tables of other packages
Requirements
- provide import modes
- insert rows with new keys only
- update where rows already exist
- report any unchanged rows?
- ignore or error if importing a field not found in tables or specified sets
- import to multiple tables from the same upload
- option to print or log ignored or rejected rows/fields
- use the status_bar feature, that tells when a file is uploaded, and when it is being processed (helps in cases where connection times out)
- Use this framework to create a UI for managing ACS reference data ( en:acs-reference ) --importing, updating, editing, reporting. (for en:ecommerce-g2 )
Implementation Notes
see also: https://web.archive.org/web/20071007211200/http://jongriffin.com/articles/openacs-relevancy/
Exsiting ecommerce bulk upload of custom fields represents the most flexible at this point, because it handles inserts and updates, and builds the sql as well as uses the xql query files: https://raw.githubusercontent.com/openacs/ecommerce/master/www/admin/products/extras-upload-2.tcl
Perhaps a dumbed-down spreadsheet data model would work well, to allow for tables of most any number of columns or rows without having to create/expose code that modifies db tables.
DAVEB: In addition to any generic storage of imported data, I think it would be useful to support importing into specific storage tables. The easiest, best examples are the content repository, or dynamic types defined tables and views. There are Tcl apis to insert/update these tables and it makes sense to support this as well.
Don Baccus has other implementations which complement this and may provide an overall development path for a preliminary general bulk upload.
Feature requests
Created by Gustaf Neumann, last modified by Gustaf Neumann 10 Apr 2017, at 09:44 AM
Package Specification Summary for Package: cl-custom
| Summary: |
|
| Description: |
This package is unknown (not available at this site) |
| Maturity: |
0 |
| This package depends on: |
None |
| Packages that depend on cl-custom: |
None |
| Package parameters: |
None
|
Bug Tracker Summary for Package: cl-custom
There is no package with the name "cl-custom" known to bug-tracker.
Code Metrics Summary for Package: cl-custom
| # Tcl Procs |
0 |
| # Tcl Lines |
0 |
| # Tcl Blank Lines |
1 |
| # Tcl Comment Lines |
0 |
| # Automated Tests |
0 |
| # Stored Procedures |
PG: 0 ORA: 0 |
| # SQL Lines |
PG: 0 (blank 1 comments 0)
ORA: 0 (blank 1 comments 0) |
| # ADP pages |
0 |
| # ADP lines |
0 |
| # Include pages (cl-custom/lib/) |
0 |
| # Documentation pages |
0
|
| # Documentation lines |
0 |
| Browse Source |
Not installed |
| Github Repository: |
https://github.com/openacs/cl-custom/tree/oacs-5-10
|
Created by OpenACS community, last modified by Gustaf Neumann 14 Nov 2014, at 07:39 PM
Package Specification Summary for Package: accounts-finance
| Summary: |
Finance package provides limited set of tools for long-term debts, fixed assets, forecasting. |
| Description: |
Finance package provides some tools for long-term debts, fixed assets, capital, stock holding, dividends, forecasting and reporting. Integrates with general-ledger etc. |
| Maturity: |
Immature |
| This package depends on: |
acs-datetime q-forms spreadsheet |
| Packages that depend on accounts-finance: |
None |
| Package parameters: |
- auxiliary: AuxiliaryColumnNames
- A space delimited list of column names allowed for alternate resource costs or system inputs and outputs in PRETTI P2 and P3 tables. Column 'name' and 'type' are reserved. (default ghg ggwp co2e cde coal oil ng gt nuke hydro solar wind cement eru cers rec km airkm, type string, scope instance)
- auxiliary: AuxiliaryColumnsNameMaxLength
- Limits the maximum column name length of auxiliary resource cost calculations used in PRETTI P2 and P3 tables. 0 means no auxiliary columns calculated (except any declared in AuxiliaryColumnNames parameter. Column 'name' and 'type' are reserved. (default 4, type number, scope instance)
- constraints: TableRowsMax
- Limits the maximum row size of any table. 0 is no limit. (default 0, type number, scope instance)
- processes: ScheduledProcsAllowed
- A space delimited list of procs allowed to be scheduled in package instance (default acc_fin::pie_file_create_from_table acc_fin::cobbler_file_create_from_table, type string, scope instance)
|
Bug Tracker Summary for Package: accounts-finance
There is no package with the name "accounts-finance" known to bug-tracker.
Code Metrics Summary for Package: accounts-finance
| # Tcl Procs |
0 |
| # Tcl Lines |
0 |
| # Tcl Blank Lines |
1 |
| # Tcl Comment Lines |
0 |
| # Automated Tests |
0 |
| # Stored Procedures |
PG: 0 ORA: 0 |
| # SQL Lines |
PG: 0 (blank 1 comments 0)
ORA: 0 (blank 1 comments 0) |
| # ADP pages |
0 |
| # ADP lines |
0 |
| # Include pages (accounts-finance/lib/) |
0 |
| # Documentation pages |
0
|
| # Documentation lines |
0 |
| Browse Source |
Not installed |
| Github Repository: |
https://github.com/openacs/accounts-finance/tree/oacs-5-10
|
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 12:30 PM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 11:53 AM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 09:00 AM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add feature requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 09:00 AM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 08:59 AM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 08:58 AM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
add requests here
Created by OpenACS community, last modified by Gustaf Neumann 12 Sep 2013, at 08:58 AM
Status
pre-release
Introduction
Part of the ecommerce-g2 project
Feature requests
