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 |
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 > > > > > > > > > > > > > > > > > > > > |
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. ----------------------------------------------------------------------------------------------------------------------- |
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 |
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 |
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 > |
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 |
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 >> |
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
--
Coherent Software Australia Pty Ltd http://www.coherentsoftware.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ |
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. |
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. > |
Free forum by Nabble | Edit this page |