Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Converting large Excel Database to rms

 
deny winarto
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi..
I'm fairly new at j2me.. I got a question regarding database handling in j2me..

I'm working on a map application that would display the shortest route between one 'node' to another 'node' in a map..
And this routing procedure works based on Floyd Algorithm, and this algorithm uses a HUGE node matrix database that i've made in Excel
The spreadsheet consists of 1044 x 1044 vertices.. The file size is around 3.9 MB (in .xlsm format)

So my question is, is it possible to fit in such large data into a j2me application?
If it's possible with rms, is there anyway to convert from excel format to rms?
If it's not can anyone suggest me another way to use this database in J2me?
Btw If possible i want to make this application offline..

thanks.

 
Ashley Burton
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I don't know if this is what you need, but it would be more efficient to convert your excel data to csv.
You can do it automatically with jexcelapi - http://jexcelapi.sourceforge.net/.
Woking with csv stream may be much easier.


Ash

 
deny winarto
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I ended up making it in 1044 .txt files, each with 1044 data.. :p
thanks anyway for reply
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic