I need to import data from an existing ERP MSSQL database into OFBiz.
So far I've only used the BSH connection to run scripts that include the
MSSQL jdbc to access the data. I'm looking for a different method than
BSH because it seems to encounter issues that I haven't been able to
resolve wi
I looked at
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
regarding legacydb and it seems like worthy alternative method. What's
great about BSH (when its working correctly) is that you can stop the
script at the command line and have it output results as operation
I get this error when trying to access
https://localhost:8443/webtools/control/view/ModelInduceFromDb:
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 126 in the jsp file:
/entity/ModelInduceFromDb.jsp
The method getValidatorsSize() is undefined
There were 5 or so issues with this file that were resolved.
getValidatorsSize() was changed to getValidators().size(). I'll create
a JIRA issue to resolve this issue.
On 01/14/2014 08:52 AM, Christian Carlow wrote:
I get this error when trying to access
https://localhost:8443/webtools/contr
I got the entitymodel.xml content to generate in the page source after
applying the patch from OFBIZ-5484 but the import included VIEWs. Does
anyone know how to import only the table data using this tool?
On 01/14/2014 08:57 AM, Christian Carlow wrote:
There were 5 or so issues with this file
Looks like getTableNames() of DatabaseUtil.java is responsible for
building the table name list according to:
String[] types = {"TABLE", "VIEW", "ALIAS", "SYNONYM"};
No parameter exist to control the table type to get so I guess there
isn't a way to prevent VIEWs from being imported as of right
Changing the type list to only include "TABLE" prevents the VIEWs from
being imported. Does anyone think its worth creating a JIRA issue to
control the database entity types (TABLES,VIEWS,etc.) to be imported
from the UI?
On 01/14/2014 09:55 AM, Christian Carlow wrote:
Looks like getTableName
Why not?
Jacques
On Tuesday, January 14, 2014 5:01 PM, christian.car...@gmail.com wrote
> Changing the type list to only include "TABLE" prevents the VIEWs from
> being imported. Does anyone think its worth creating a JIRA issue to
> control the database entity types (TABLES,VIEWS,etc.) to be im