excel sheet implementation

[harish84]

i can read excel sheet but i am not able to store that values in mysql database

[BJ Freeman]

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

[harish84]

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.

[Ashish Vijaywargiya-5]

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

[Ashish Vijaywargiya-5]

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

[BJ Freeman]

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

[BJ Freeman]

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