Why not? Jacques
On Tuesday, January 14, 2014 5:01 PM, [email protected] 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 imported > from the UI? > > On 01/14/2014 09:55 AM, Christian Carlow wrote: >> 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 now. >> >> On 01/14/2014 09:41 AM, Christian Carlow wrote: >>> 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 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/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 for the type ModelField >>>>> >>>>> >>>>> On 01/14/2014 08:17 AM, Christian Carlow wrote: >>>>>> 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 operations are performed which makes debugging easier. >>>>>> >>>>>> On 01/14/2014 08:05 AM, Christian Carlow wrote: >>>>>>> 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 without a server restart >>>>>>> which makes import script development much more time consuming. >>>>>>> >>>>>>> Does anyone know of a better environment where the MSSQL jdbc can >>>>>>> be used to access external data while still having access to the >>>>>>> OFBiz environment like BSH? >>>>>>> >>>>>>> I got the idea for using BSH from this webpage which is a bit out >>>>>>> of date: >>>>>>> http://www.opensourcestrategies.com/ofbiz/entities_services.php >>>>>>> (A Word About BeanShell section)
