data base

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

data base

adnane

Hello

i m working in a small company in france,i m blocked face a problem,i creat my data base on using mysql.

 i m a new user of ofbiz,i don t know how could i import this
information from the data base at ofbiz,and i know that i should change
some thing on the entityengine.xml,could u please help me and show me
how could i importe information.


Adnane


Thnks
               
               
       
                                       



   
 
 
 
 
 
 
 
 
 
 
 
     
Reply | Threaded
Open this post in threaded view
|

Re: data base

BJ Freeman
start here
https://cwiki.apache.org/confluence/display/OFBIZ/Handling%20of%20External%20data

=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


adnane moslih sent the following on 2/24/2011 8:14 AM:

>
> Hello
>
> i m working in a small company in france,i m blocked face a problem,i creat my data base on using mysql.
>
>   i m a new user of ofbiz,i don t know how could i import this
> information from the data base at ofbiz,and i know that i should change
> some thing on the entityengine.xml,could u please help me and show me
> how could i importe information.
>
>
> Adnane
>
>
> Thnks
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>    

Reply | Threaded
Open this post in threaded view
|

RE: data base

hardik handa
In reply to this post by adnane
https://cwiki.apache.org/confluence/display/OFBIZ/Handling%20of%20External%20data
u could use this, if u still getting stuck contact again
CHEERS !!

-----Original Message-----
From: adnane moslih [mailto:[hidden email]]
Sent: 24 February 2011 PM 09:44
To: [hidden email]
Subject: data base


Hello

i m working in a small company in france,i m blocked face a problem,i creat my data base on using mysql.

 i m a new user of ofbiz,i don t know how could i import this
information from the data base at ofbiz,and i know that i should change
some thing on the entityengine.xml,could u please help me and show me
how could i importe information.


Adnane


Thnks





















::DISCLAIMER::
-----------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

-----------------------------------------------------------------------------------------------------------------------
Reply | Threaded
Open this post in threaded view
|

Re: data base

adnane
In reply to this post by adnane
Hello

Thns every body,but i want know how could i creat datasource in the file entityengine.xml because i notice that this file contain just the defenition of each data base and in the top of file,we precise wich data base we use,so,if i would like use mysql database,sould i change derby and put my sql or there is on other thing to do??

Thnks
Reply | Threaded
Open this post in threaded view
|

Re: data base

Erwan de FERRIERES
Le 25/02/2011 11:43, adnane a écrit :

>
> Hello
>
> Thns every body,but i want know how could i creat datasource in the file
> entityengine.xml because i notice that this file contain just the defenition
> of each data base and in the top of file,we precise wich data base we
> use,so,if i would like use mysql database,sould i change derby and put my
> sql or there is on other thing to do??
>
> Thnks

Configure your entityengine.xml file:
put the right definition for your mysql database, and choose for the
default delegator to use the modified datasource.

https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup

Cheers,
--
Erwan de FERRIERES
www.nereide.biz
Reply | Threaded
Open this post in threaded view
|

Re: data base

Mike Z
As I recall (I use postgres now), I had trouble getting multi-language
support to work properly in mysql until I made the following changes
to entityengine.xml.

The default config shows this:

            character-set="latin1"
            collate="latin1_general_cs"

I believe I had to change the above to:

            character-set="utf8"
            collate="utf8_general_ci"

When I did the above, I was able to support a multi-language
environment...i.e, write product info in multiple languages.
Something to think about.


On Fri, Feb 25, 2011 at 12:04 PM, Erwan de FERRIERES
<[hidden email]> wrote:

> Le 25/02/2011 11:43, adnane a écrit :
>>
>> Hello
>>
>> Thns every body,but i want know how could i creat datasource in the file
>> entityengine.xml because i notice that this file contain just the
>> defenition
>> of each data base and in the top of file,we precise wich data base we
>> use,so,if i would like use mysql database,sould i change derby and put my
>> sql or there is on other thing to do??
>>
>> Thnks
>
> Configure your entityengine.xml file:
> put the right definition for your mysql database, and choose for the default
> delegator to use the modified datasource.
>
> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>
> Cheers,
> --
> Erwan de FERRIERES
> www.nereide.biz
>
Reply | Threaded
Open this post in threaded view
|

[ANN]VTD-XML 2.10

anon_anon
In reply to this post by Erwan de FERRIERES
VTD-XML 2.10 is now released. It can be downloaded at
https://sourceforge.net/projects/vtd-xml/files/vtd-xml/ximpleware_2.10/.
This release includes a number of new features and enhancement.

* The core API of VTD-XML has been expanded. Users can now perform
cut/paste/insert on an empty element.
* This release also adds the support of deeper location cache support for
parsing and indexing. This feature is useful for application performance
tuning for
processing various XML documents.
* The java version also added support for processing zip and gzip files.
Direct processing of httpURL based XML is enhanced.
* Extended Java version now support Iso-8859-10~16 encoding.
* A full featured C++ port is released.
* C version of VTD-XML now make use of thread local storage to achieve
thread safety for multi-threaded application.
* There are also a number of bugs fixed. Special thanks to Jozef Aerts, John
Sillers, Chris Tornau and a number of other users for input and suggestions

Reply | Threaded
Open this post in threaded view
|

Re: data base

David E. Jones-2
In reply to this post by Mike Z

On a side note, the only reason this isn't the default in OFBiz is that if you use UTF-8 the size of each text column will be reduced to 1/3 of its specified size because each UTF-8 character requires 3 bytes in MySQL, and the size of a column in MySQL is in terms of bytes, and not in terms of characters. Every other DB in the world (that I'm aware of) uses characters for column size, MySQL is just weird.

-David


On Feb 25, 2011, at 1:51 PM, Mike wrote:

> As I recall (I use postgres now), I had trouble getting multi-language
> support to work properly in mysql until I made the following changes
> to entityengine.xml.
>
> The default config shows this:
>
>            character-set="latin1"
>            collate="latin1_general_cs"
>
> I believe I had to change the above to:
>
>            character-set="utf8"
>            collate="utf8_general_ci"
>
> When I did the above, I was able to support a multi-language
> environment...i.e, write product info in multiple languages.
> Something to think about.
>
>
> On Fri, Feb 25, 2011 at 12:04 PM, Erwan de FERRIERES
> <[hidden email]> wrote:
>> Le 25/02/2011 11:43, adnane a écrit :
>>>
>>> Hello
>>>
>>> Thns every body,but i want know how could i creat datasource in the file
>>> entityengine.xml because i notice that this file contain just the
>>> defenition
>>> of each data base and in the top of file,we precise wich data base we
>>> use,so,if i would like use mysql database,sould i change derby and put my
>>> sql or there is on other thing to do??
>>>
>>> Thnks
>>
>> Configure your entityengine.xml file:
>> put the right definition for your mysql database, and choose for the default
>> delegator to use the modified datasource.
>>
>> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>>
>> Cheers,
>> --
>> Erwan de FERRIERES
>> www.nereide.biz
>>

Reply | Threaded
Open this post in threaded view
|

Re: data base

Paul Foxworthy
Hi all,

From http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html:

"MySQL interprets length specifications in character column definitions in character units. (Before MySQL 4.1, column lengths were interpreted in bytes.)"

MySQL 4.1 production release was in 2004.

From http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html:

"utf8, a UTF-8 encoding of the Unicode character set using one to three bytes per character"

UTF-8 doesn't require three bytes per character. It has the tremendous virtue (at least if you happen to speak a language of Western Europe) that plain ASCII is already in UTF-8 format. You can store any Unicode character, and you only pay the price in increased storage size for the non-ASCII characters.

If that's the only problem, I humbly suggest the default encoding should be changed to UTF-8.

Cheers

Paul Foxworthy

David E Jones-4 wrote
On a side note, the only reason this isn't the default in OFBiz is that if you use UTF-8 the size of each text column will be reduced to 1/3 of its specified size because each UTF-8 character requires 3 bytes in MySQL, and the size of a column in MySQL is in terms of bytes, and not in terms of characters. Every other DB in the world (that I'm aware of) uses characters for column size, MySQL is just weird.

-David


On Feb 25, 2011, at 1:51 PM, Mike wrote:

> As I recall (I use postgres now), I had trouble getting multi-language
> support to work properly in mysql until I made the following changes
> to entityengine.xml.
>
> The default config shows this:
>
>            character-set="latin1"
>            collate="latin1_general_cs"
>
> I believe I had to change the above to:
>
>            character-set="utf8"
>            collate="utf8_general_ci"
>
> When I did the above, I was able to support a multi-language
> environment...i.e, write product info in multiple languages.
> Something to think about.
>
>
> On Fri, Feb 25, 2011 at 12:04 PM, Erwan de FERRIERES
> <erwan.de-ferrieres@nereide.fr> wrote:
>> Le 25/02/2011 11:43, adnane a écrit :
>>>
>>> Hello
>>>
>>> Thns every body,but i want know how could i creat datasource in the file
>>> entityengine.xml because i notice that this file contain just the
>>> defenition
>>> of each data base and in the top of file,we precise wich data base we
>>> use,so,if i would like use mysql database,sould i change derby and put my
>>> sql or there is on other thing to do??
>>>
>>> Thnks
>>
>> Configure your entityengine.xml file:
>> put the right definition for your mysql database, and choose for the default
>> delegator to use the modified datasource.
>>
>> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>>
>> Cheers,
>> --
>> Erwan de FERRIERES
>> www.nereide.biz
>>
--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
Reply | Threaded
Open this post in threaded view
|

Re: data base

David E. Jones-2

That's good to hear, I haven't looked into it or tested it for years (and have only had latin-using clients using MySQL in recent years). BTW, about UTF-8: the accepted standard has nothing to do with how MySQL used to support it, and in MySQL if you set the character set to unicode you'd get 3 bytes used for each character, even for ASCII characters. Yeah, it was really bad...

So, it's good to hear they changed that, I've been wondering when it would happen. I'll admit, I'm still not a fan of MySQL. If they would fix the issues with Timestamp millisecond resolution and a few transaction handling things they'd be on their way to being a useful database where you don't have to work around or ignore stuff on a daily basis.

Maybe it'll happen sooner or later. Working with MySQL has historically been a pain as they've been slow to move toward being a more enterprise app friendly database (as opposed to a LAMP stack component).

-David


On Feb 26, 2011, at 3:48 PM, Paul Foxworthy wrote:

> Hi all,
>
> From  http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html
> http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html :
>
> "MySQL interprets length specifications in character column definitions in
> character units. (Before MySQL 4.1, column lengths were interpreted in
> bytes.)"
>
> MySQL 4.1 production release was in 2004.
>
> From  http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html :
>
> "utf8, a UTF-8 encoding of the Unicode character set using one to three
> bytes per character"
>
> UTF-8 doesn't require three bytes per character. It has the tremendous
> virtue (at least if you happen to speak a language of Western Europe) that
> plain ASCII is already in UTF-8 format. You can store any Unicode character,
> and you only pay the price in increased storage size for the non-ASCII
> characters.
>
> If that's the only problem, I humbly suggest the default encoding should be
> changed to UTF-8.
>
> Cheers
>
> Paul Foxworthy
>
>
> David E Jones-4 wrote:
>>
>>
>> On a side note, the only reason this isn't the default in OFBiz is that if
>> you use UTF-8 the size of each text column will be reduced to 1/3 of its
>> specified size because each UTF-8 character requires 3 bytes in MySQL, and
>> the size of a column in MySQL is in terms of bytes, and not in terms of
>> characters. Every other DB in the world (that I'm aware of) uses
>> characters for column size, MySQL is just weird.
>>
>> -David
>>
>>
>> On Feb 25, 2011, at 1:51 PM, Mike wrote:
>>
>>> As I recall (I use postgres now), I had trouble getting multi-language
>>> support to work properly in mysql until I made the following changes
>>> to entityengine.xml.
>>>
>>> The default config shows this:
>>>
>>>           character-set="latin1"
>>>           collate="latin1_general_cs"
>>>
>>> I believe I had to change the above to:
>>>
>>>           character-set="utf8"
>>>           collate="utf8_general_ci"
>>>
>>> When I did the above, I was able to support a multi-language
>>> environment...i.e, write product info in multiple languages.
>>> Something to think about.
>>>
>>>
>>> On Fri, Feb 25, 2011 at 12:04 PM, Erwan de FERRIERES
>>> <[hidden email]> wrote:
>>>> Le 25/02/2011 11:43, adnane a écrit :
>>>>>
>>>>> Hello
>>>>>
>>>>> Thns every body,but i want know how could i creat datasource in the
>>>>> file
>>>>> entityengine.xml because i notice that this file contain just the
>>>>> defenition
>>>>> of each data base and in the top of file,we precise wich data base we
>>>>> use,so,if i would like use mysql database,sould i change derby and put
>>>>> my
>>>>> sql or there is on other thing to do??
>>>>>
>>>>> Thnks
>>>>
>>>> Configure your entityengine.xml file:
>>>> put the right definition for your mysql database, and choose for the
>>>> default
>>>> delegator to use the modified datasource.
>>>>
>>>> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>>>>
>>>> Cheers,
>>>> --
>>>> Erwan de FERRIERES
>>>> www.nereide.biz
>>>>
>>
>>
>>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/data-base-tp3323306p3326419.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Reply | Threaded
Open this post in threaded view
|

Re: data base

Mike Z
In reply to this post by Paul Foxworthy
>Adrian Crum Said: Feb 12
>By the way, the MySql timestamp issue has a workaround in OFBiz. If you change the timestamp field's sql-type to CHAR(30), the
>entity engine will convert timestamps from/to CHAR field types.

How about changing this default as well, fixing the mysql timestamp
issue as well?

On Sat, Feb 26, 2011 at 3:48 PM, Paul Foxworthy <[hidden email]> wrote:

> Hi all,
>
> From  http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html
> http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html :
>
> "MySQL interprets length specifications in character column definitions in
> character units. (Before MySQL 4.1, column lengths were interpreted in
> bytes.)"
>
> MySQL 4.1 production release was in 2004.
>
> From  http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html :
>
> "utf8, a UTF-8 encoding of the Unicode character set using one to three
> bytes per character"
>
> UTF-8 doesn't require three bytes per character. It has the tremendous
> virtue (at least if you happen to speak a language of Western Europe) that
> plain ASCII is already in UTF-8 format. You can store any Unicode character,
> and you only pay the price in increased storage size for the non-ASCII
> characters.
>
> If that's the only problem, I humbly suggest the default encoding should be
> changed to UTF-8.
>
> Cheers
>
> Paul Foxworthy
>
>
> David E Jones-4 wrote:
>>
>>
>> On a side note, the only reason this isn't the default in OFBiz is that if
>> you use UTF-8 the size of each text column will be reduced to 1/3 of its
>> specified size because each UTF-8 character requires 3 bytes in MySQL, and
>> the size of a column in MySQL is in terms of bytes, and not in terms of
>> characters. Every other DB in the world (that I'm aware of) uses
>> characters for column size, MySQL is just weird.
>>
>> -David
>>
>>
>> On Feb 25, 2011, at 1:51 PM, Mike wrote:
>>
>>> As I recall (I use postgres now), I had trouble getting multi-language
>>> support to work properly in mysql until I made the following changes
>>> to entityengine.xml.
>>>
>>> The default config shows this:
>>>
>>>            character-set="latin1"
>>>            collate="latin1_general_cs"
>>>
>>> I believe I had to change the above to:
>>>
>>>            character-set="utf8"
>>>            collate="utf8_general_ci"
>>>
>>> When I did the above, I was able to support a multi-language
>>> environment...i.e, write product info in multiple languages.
>>> Something to think about.
>>>
>>>
>>> On Fri, Feb 25, 2011 at 12:04 PM, Erwan de FERRIERES
>>> <[hidden email]> wrote:
>>>> Le 25/02/2011 11:43, adnane a écrit :
>>>>>
>>>>> Hello
>>>>>
>>>>> Thns every body,but i want know how could i creat datasource in the
>>>>> file
>>>>> entityengine.xml because i notice that this file contain just the
>>>>> defenition
>>>>> of each data base and in the top of file,we precise wich data base we
>>>>> use,so,if i would like use mysql database,sould i change derby and put
>>>>> my
>>>>> sql or there is on other thing to do??
>>>>>
>>>>> Thnks
>>>>
>>>> Configure your entityengine.xml file:
>>>> put the right definition for your mysql database, and choose for the
>>>> default
>>>> delegator to use the modified datasource.
>>>>
>>>> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>>>>
>>>> Cheers,
>>>> --
>>>> Erwan de FERRIERES
>>>> www.nereide.biz
>>>>
>>
>>
>>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/data-base-tp3323306p3326419.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>