Better method of importing data from existing ERP database other than using BSH connection

[Christian Carlow-OFBizzer]

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)

[Christian Carlow-OFBizzer]

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)

[Christian Carlow-OFBizzer]

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)
>

[Christian Carlow-OFBizzer]

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)
>>
>

[Christian Carlow-OFBizzer]

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)
>>>
>>
>

[Christian Carlow-OFBizzer]

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)
>>>>
>>>
>>
>

[Christian Carlow-OFBizzer]

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)
>>>>>
>>>>
>>>
>>
>

[Jacques Le Roux]

Why not?

Jacques

On Tuesday, January 14, 2014 5:01 PM, [hidden email] 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)