You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by harish84 <ha...@gmail.com> on 2009/04/08 19:58:05 UTC
excel sheet implementation
i can read excel sheet but i am not able to store that values in mysql
database
--
View this message in context: http://www.nabble.com/excel-sheet-implementation-tp22956266p22956266.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: excel sheet implementation
Posted by Ashish Vijaywargiya <as...@hotwaxmedia.com>.
Direct link to see the commits :
r663581
http://www.nabble.com/svn-commit%3A-r663581---in--ofbiz-trunk-specialpurpose-assetmaint%3A-build.xml-data-ScheduleUploadJob.xml-servicedef-services.xml-src-org-ofbiz-poi--src-org-ofbiz-poi-FileImportHelper.java-src-org-ofbiz-poi-FileImportService.java-td17668684.html#a17668684
r663627
http://www.nabble.com/svn-commit%3A-r663627---in--ofbiz-trunk%3A-applications-product-data--applications-product-servicedef--applications-product-src-org-ofbiz-product-spreadsheetimport--specialpurpose-assetmaint--specialpurpose-assetmaint-data--specialpurpose-assetmaint-servic...-td17671151.html#a17671151
--
Ashish
harish84 wrote:
> i am reading excel sheet using poi.i am getting all the values in console but
> when i use create method it gets stores in only one column.it should get
> store in corresponding columns.
>
>
Re: excel sheet implementation
Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
you can create map for the data that fits a service to do CRUD services.
This allows you to also update already existing data.
this also will use the associated EDA service realted to the services
you run
http://docs.ofbiz.org/display/OFBIZ/Using+excel+to+build+vars+and+map+methods+for+a+class+from+services+page.
harish84 sent the following on 4/9/2009 3:19 AM:
> i am reading excel sheet using poi.i am getting all the values in console but
> when i use create method it gets stores in only one column.it should get
> store in corresponding columns.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJ3dQZrP3NbaWWqE4RAhnMAJ9tGQ1G75HtqwHB4HmXCUuEBf4KrACgt5X3
iWb10xr1BDbycKPwZr1IbMo=
=b6u3
-----END PGP SIGNATURE-----
Re: excel sheet implementation
Posted by Ashish Vijaywargiya <as...@hotwaxmedia.com>.
Hello Harish,
Following commit notification will be your friend.
r663581 & r663627.
The how to steps are attached in the document available at jira issue
OFBIZ-1810. (https://issues.apache.org/jira/browse/OFBIZ-1810)
--
Ashish
harish84 wrote:
> i am reading excel sheet using poi.i am getting all the values in console but
> when i use create method it gets stores in only one column.it should get
> store in corresponding columns.
>
>
Re: excel sheet implementation
Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
here some other options
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
harish84 sent the following on 4/9/2009 3:19 AM:
> i am reading excel sheet using poi.i am getting all the values in console but
> when i use create method it gets stores in only one column.it should get
> store in corresponding columns.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJ3dR4rP3NbaWWqE4RAtIzAKCE4EVEKLQjyyqOT1B2v0Vdv98e0gCdET7y
6wXFGX8f3sjA2zx4DBL5tQs=
=k+4P
-----END PGP SIGNATURE-----
Re: excel sheet implementation
Posted by harish84 <ha...@gmail.com>.
i am reading excel sheet using poi.i am getting all the values in console but
when i use create method it gets stores in only one column.it should get
store in corresponding columns.
--
View this message in context: http://www.nabble.com/excel-sheet-implementation-tp22956266p22968125.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: excel sheet implementation
Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Can you explain in more detail like how are your reading the excel file?
harish84 sent the following on 4/8/2009 10:58 AM:
> i can read excel sheet but i am not able to store that values in mysql
> database
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJ3QMtrP3NbaWWqE4RAoATAJ0ZLnnvsMQkDVgheHUMo3PC2I/0UwCdGZKX
hJzu9O9yrD3zr21cXITE79k=
=gics
-----END PGP SIGNATURE-----