I want to import microsoft excel file into ebase.

[Pankaj Yergude]

Hi,
I want to import microsoft excel file into ebase.Please let me know how can i implements in ebase.

Regards,
Pankaj

[Joost]

Depends on when and where you want to do something with the data, but you could use:

• - a sql import script to periodically load the data into a table;
  - Apache POI to work with the Excel format in combination with a servlet, jsp or custom function/resource;
  - first export from Excel to XML and use the XML import resource.

[Pankaj Yergude]

Hi,
Thanks for your help can u tell me in brief description, In my project form i have one filed to import excel file and excel data stored in my project database having same field, Please let me know.

Regards,
Pankaj

[AJDulk]

In order to help more information is needed:

• - What is your chosen solution? (SQL import, Apache POI, Export to XML and import the XML)

If SQL import then we need to know:

• - What infrastructure are you using for your database tier (Oracle, Microsoft SQL, Derby, ...)

Also helpful would be what you have actually tried and the problems you came across trying them.

Regards,
Antony[/list]

[Pankaj Yergude]

Hi,

I chosen Export to XML and i am facing problem in first export from Excel to XML. I used Mysql database.

I created sample page in that one field is their and when i click on the button then browse the client excel sheet those client excel sheet data i want how to store on my database, but my problems is i have don't have any idea about how to browse the client excel sheet and stored into database table client data.

Regards,
Pankaj

[Joost]

I chosen Export to XML and i am facing problem in first export from Excel to XML.

MS Excel has a "save as" option. Select XML and hit save?

You may now use the XML file with a XML File adapter.
http://portal.ebasetech.com/cp/doc/xmlr ... c178151740

how to browse the client excel sheet

If you mean the data in the XML file you have to map the XML to a table field.
http://portal.ebasetech.com/cp/doc/field_mappings.htm

If you mean to browse files in a folder you need to do a directory listing using the osfiles function.
http://portal.ebasetech.com/cp/doc/scri ... c193607007

and stored into database table client data.

Map the table to a database as well and store the selected rows.

But maybe Apache POI would be more suited to your situation. It is more work, but hence more flexible too.

[Pankaj Yergude]

Hi,
Thanks for your help Can u please tell me How can i use Apache POI in my application, please give a brief description.

Regards,
Pankaj

[ehmd]

Hi,
Thanks for your help Can u please tell me How can i use Apache POI in my application, please give a brief description.

Regards,
Pankaj

You will probably need to write your own Custom Resource in java to be able to access the Excel Spreadsheet.

Custom Resource information in Ebase is available at http://portal.ebasetech.com/cp/doc/Work ... ources.htm

Apache POI libraries are available at http://poi.apache.org/spreadsheet/index.html


Regards,


Mark

[Wai]

Are you still looking for a solution to this?

We have a custom resource that will read and write from a CSV file. You can save your Excel file as CSV and read this into an Ebase table.

Let me know if this is useful to you.

[t4nu]

Hi,
Is this custom resource can be used by other user of ebase of just certain user who has fulfill the criteria?
Id just that has fulfill the criteria, may I know what the criteria is?
Thanks for the answer.

Are you still looking for a solution to this?

We have a custom resource that will read and write from a CSV file. You can save your Excel file as CSV and read this into an Ebase table.

Let me know if this is useful to you.

[AJDulk]

This is now delivered automatically with new Ebase systems.

See the following:
http://dev-docs.verj.io/ufs/doc/Resources_Summary.htm
http://dev-docs.verj.io/ufs/doc/Working ... ources.htm
http://dev-docs.verj.io/forum/viewtopic.php?p=2170

[t4nu]

Thank you very much for the info.
It really help me a lot, especially the 3rd link.

This is now delivered automatically with new Ebase systems.

See the following:
http://dev-docs.verj.io/ufs/doc/Resources_Summary.htm
http://dev-docs.verj.io/ufs/doc/Working ... ources.htm
http://dev-docs.verj.io/forum/viewtopic.php?p=2170