J2ME: read and show CSV-files

T

Tobias Wendorff

Hi there,

I'm into JAVA programming for some days only, but I've read
many tutorials and documents. It's very great, but my cell-phone
(it's a Siemens S65) can't view all the multi-media things :-(

I would like to read the content of a CSV-file and print it out
on the screen. I don't care, it's embedded in the midlet or
on the mobile itself. I know how to handle this :)

The CSV looks like this:
surname;firstname;street
Doe;John;nobody knows

I would like to see this on the mobile:
Firstname: John
Surname: Doe
Street: nobody knows

Does anybody have an example for this? I don't want a finished
code - but of course, I wouldn't say no :)

Best regards,
Tobias
 
J

Jeff Higgins

Tobias said:
Hi there,

I'm into JAVA programming for some days only, but I've read
many tutorials and documents. It's very great, but my cell-phone
(it's a Siemens S65) can't view all the multi-media things :-(

I would like to read the content of a CSV-file and print it out
on the screen. I don't care, it's embedded in the midlet or
on the mobile itself. I know how to handle this :)

The CSV looks like this:
surname;firstname;street
Doe;John;nobody knows

I would like to see this on the mobile:
Firstname: John
Surname: Doe
Street: nobody knows

Does anybody have an example for this? I don't want a finished
code - but of course, I wouldn't say no :)

Best regards,
Tobias
Click to expand...

Commented stuff I'm not real sure about.

//Connection c =Connector.open(file://records.dat);
//DataInputStream dis = new DataInputStream(c.openInputStream());
//String data = dis.readUTF();

String[] records = data.split("\n");
String[] fields = new String[3];
for(int i=0;i<records.length;i++)
{
fields = records.split(";");
}

//Form.append("Firstname: " + fields[1]);
//Form.append("Surname: " + fields[0]);
//Form.append("Street: " + fields[2]);
 
J

Jeff Higgins

Jeff said:
Tobias said:
Hi there,

I'm into JAVA programming for some days only, but I've read
many tutorials and documents. It's very great, but my cell-phone
(it's a Siemens S65) can't view all the multi-media things :-(

I would like to read the content of a CSV-file and print it out
on the screen. I don't care, it's embedded in the midlet or
on the mobile itself. I know how to handle this :)

The CSV looks like this:
surname;firstname;street
Doe;John;nobody knows

I would like to see this on the mobile:
Firstname: John
Surname: Doe
Street: nobody knows

Does anybody have an example for this? I don't want a finished
code - but of course, I wouldn't say no :)

Best regards,
Tobias
Click to expand...

Commented stuff I'm not real sure about.

//Connection c =Connector.open(file://records.dat);
//DataInputStream dis = new DataInputStream(c.openInputStream());
//String data = dis.readUTF();

String[] records = data.split("\n");
String[] fields = new String[3];
for(int i=0;i<records.length;i++)
{
fields = records.split(";");
}

//Form.append("Firstname: " + fields[1]);
//Form.append("Surname: " + fields[0]);
//Form.append("Street: " + fields[2]);
Click to expand...


Oops! no String.split method!

import java.util.Vector;

public class testString
{
public static void main(String[] args)
{
String data =
"Doe;John;Bywater Road" +
"\n" +
"Atkins;Rae Dawn;Tinpan Alley" +
"\n" +
"Phillips;Michelle;Bright Boulevard";

String[] records = split(data, "\n");

for(int ri = 0; ri < records.length; ri++)
{
String[] fields = split(records[ri], ";");
System.out.println("Firstname: " + fields[1]);
System.out.println("Surname: " + fields[0]);
System.out.println("Street: " + fields[2] + "\n");
}
}

// Split method from Substance
//
<http://forum.java.sun.com/thread.jspa?threadID=646861&messageID=3809007>

static private String[] split(String original, String separator)
{
Vector nodes = new Vector();
int index = original.indexOf(separator);
while(index>=0)
{
nodes.addElement( original.substring(0, index) );
original = original.substring(index+separator.length());
index = original.indexOf(separator);
}
nodes.addElement( original );
String[] result = new String[ nodes.size() ];
if( nodes.size()>0 )
{
for(int loop=0; loop<nodes.size(); loop++)
result[loop] = (String)nodes.elementAt(loop);
}
return result;
}
}
 
J

Jeff Higgins

Another split method - no Vector

public class testString
{
public static void main(String[] args)
{
String data =
"Doe;John;Bywater Road" +
"\n" +
"Atkins;Rae Dawn;Tinpan Alley" +
"\n" +
"Phillips;Michelle;Bright Boulevard";

String[] records = split2(data, "\n");

for(int ri = 0; ri < records.length; ri++)
{
String[] fields = split2(records[ri], ";");
System.out.println("Firstname: " + fields[1]);
System.out.println("Surname: " + fields[0]);
System.out.println("Street: " + fields[2] + "\n");
}
}

// Split method from Jorma Ikonen
//
<http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=41&t=001519>


static String[] split(String splitStr, String delimiter){

/** Note, delimiter can't be regex-type of argument as
* in orginal J2SE implementation!!!*/
int dLen = delimiter.length();
int p1 = 0;
int cnt = 0;

if (splitStr.length() == 0){
String[] excepStr = new String[1];
excepStr[0] = "";
return excepStr;
}

if (dLen == 0){
String[] excepStr = new String[splitStr.length()+1];
excepStr[0] = "";
for (int i = 0; i<excepStr.length-1; i++){
excepStr[i+1] = String.valueOf(splitStr.charAt(i));
}
return excepStr;
}

p1 = splitStr.indexOf(delimiter, p1);
while (p1 != -1){
cnt++;
p1 = p1 + dLen;
p1 = splitStr.indexOf(delimiter, p1);
}

String[] tmp = new String[cnt + 1];
p1 = 0;
int p2 = 0;
for (int i = 0; i<tmp.length; i++){
p2 = splitStr.indexOf(delimiter, p2);
if (p2 == -1){
tmp = splitStr.substring(p1);
}else{
tmp = splitStr.substring(p1, p2);
}
p1 = p2 + dLen;
p2 = p2 + dLen;
}
cnt = 0;

for (int i = tmp.length-1; i>-1; i--){
if(tmp.length() > 0){
break;
} else{
cnt++;
}
}
String[] result = new String[tmp.length-cnt];
for (int i = 0; i<result.length; i++){
result = tmp;
}
return result;

}
}
 
T

Tobias Wendorff

Hi Jeff,

I'm getting this in J2ME:

java.lang.InstantiationException: Class not a MIDlet
at com.sun.midp.midlet.MIDletState.createMIDlet(+66)
at com.sun.midp.midlet.Selector.run(+22)

How can I fix it?

Best,
Tobias
 
J

Jeff Higgins

Tobias said:
Hi Jeff,

I'm getting this in J2ME:

java.lang.InstantiationException: Class not a MIDlet
at com.sun.midp.midlet.MIDletState.createMIDlet(+66)
at com.sun.midp.midlet.Selector.run(+22)

How can I fix it?

Best,
Tobias
Click to expand...

Hi Tobias,
First let me thank you for providing me the
impetus for looking at J2ME, your OP was the
first that I've examined it - having fun!

I don't know - have you extended the MIDlet class?

Here's what I have so far - please don't use this
as a good example.



import java.io.IOException;
import java.io.InputStream;
import java.util.Vector;

import javax.microedition.io.ConnectionNotFoundException;
import javax.microedition.lcdui.Command;
import javax.microedition.lcdui.CommandListener;
import javax.microedition.lcdui.Display;
import javax.microedition.lcdui.Displayable;
import javax.microedition.lcdui.Form;
import javax.microedition.lcdui.Item;
import javax.microedition.lcdui.ItemCommandListener;
import javax.microedition.lcdui.StringItem;
import javax.microedition.midlet.MIDlet;
import javax.microedition.midlet.MIDletStateChangeException;


public class ReadDisplayFile extends MIDlet
implements CommandListener, ItemCommandListener{
private Form mMainForm;
private Command cmNext =
new Command("Next", Command.SCREEN, 1);
private Command cmExit =
new Command("Exit", Command.EXIT, 1);
private Command cmDial =
new Command("Dial", Command.ITEM, 1);
private StringItem siFirstname =
new StringItem(null,null);
private StringItem siSurname =
new StringItem(null,null);
private StringItem siStreet =
new StringItem(null,null);
private StringItem siPhone =
new StringItem(null,null);
private int nextRecord = 0;
private int recordCount = 0;
private String[][] records;

public ReadDisplayFile() {
records = splitFile();
mMainForm = new Form("Phonebook");
siFirstname.setText("Firstname: " +
records[nextRecord][1] + "\n");
siSurname.setText("Surname: " +
records[nextRecord][0] + "\n");
siStreet.setText("Street: " +
records[nextRecord][2] + "\n");
siPhone.setText("Phone: " +
records[nextRecord][3] + "\n");
siPhone.addCommand(cmDial);
siPhone.setItemCommandListener(this);

nextRecord++;

mMainForm.append(siFirstname);
mMainForm.append(siSurname);
mMainForm.append(siStreet);
mMainForm.append(siPhone);

mMainForm.addCommand(cmNext);
mMainForm.addCommand(cmExit);
mMainForm.setCommandListener(this);
}

protected void destroyApp(boolean arg0)
throws MIDletStateChangeException {}

protected void pauseApp() {}

protected void startApp()
throws MIDletStateChangeException {
Display.getDisplay(this).setCurrent(mMainForm);
}

public void commandAction(Command c, Displayable arg1)
{
if (c == cmNext)
{
if(nextRecord <= recordCount)
{
siFirstname.setText("Firstname: " +
records[nextRecord][1] + "\n");
siSurname.setText("Surname: " +
records[nextRecord][0] + "\n");
siStreet.setText("Street: " +
records[nextRecord][2] + "\n");
siPhone.setText("Phone: " +
records[nextRecord][3] + "\n");
nextRecord++;
}
else
{
nextRecord = 0;
siFirstname.setText("Firstname: " +
records[nextRecord][1] + "\n");
siSurname.setText("Surname: " +
records[nextRecord][0] + "\n");
siStreet.setText("Street: " +
records[nextRecord][2] + "\n");
siPhone.setText("Phone: " +
records[nextRecord][3] + "\n");
nextRecord++;
}
}
else if (c == cmExit)
{
notifyDestroyed();
}
}

private String[][] splitFile()
{
InputStream is =
getClass().getResourceAsStream("records.txt");
try
{
StringBuffer sb = new StringBuffer();
int chr = 0;
while ((chr = is.read()) != -1)
{
sb.append((char) chr);
}
is.close();
String[] data = split(sb.toString(),"\r\n");
String[][] records = new String[data.length][4];
for(int recordIndex = 0;
recordIndex < data.length;
recordIndex++)
{
for(int fieldIndex = 0;
fieldIndex < 4;
fieldIndex++)
{
records[recordIndex] = split(data[recordIndex],";");
}
recordCount = recordIndex;
}
return records;
}
catch (IOException e)
{
System.err.print(e.toString());
}
return null;
}

static private String[] split(String original, String separator)
{
Vector nodes = new Vector();
int index = original.indexOf(separator);
while(index>=0)
{
nodes.addElement( original.substring(0, index) );
original = original.substring(index+separator.length());
index = original.indexOf(separator);
}
nodes.addElement( original );
String[] result = new String[ nodes.size() ];
if( nodes.size()>0 )
{
for(int loop=0; loop<nodes.size(); loop++)
result[loop] = (String)nodes.elementAt(loop);
}
return result;
}

public void commandAction(Command c, Item arg1) {

if(c == cmDial)
{
try {
platformRequest("tel:<1-(555)555-5555>");
} catch (ConnectionNotFoundException e) {
e.printStackTrace();
}
}

}
}
 
J

Jeff Higgins

Another thing you can check is if you are throwing an exception from
your constructor - in my code I'm reading the CSV file in the
constructor
via splitFile() method. If I don't place the CSV file in the jar, or
If I
put it in the wrong place I get a similar exception.

sending this via Google Groups cause my news server is acting up.
Again. :-(

JH
 
T

Tobias Wendorff

Hi Jeff,

Jeff Higgins wrote:

Code: 
Thanks, it's working fine here!

This part:

InputStream is = getClass().getResourceAsStream("records.txt");

is reading "records.txt" from RES-directory or from the JAR
directly. How can I make it loading from the web or a directory?

Normally, this code should work (I'm using it in another app):

String file = "file:///root1/records.txt";
StreamConnection sc = (StreamConnection)Connector.open(file);
InputStream is = sc.openInputStream();

or

String file = "file:///root1/records.txt";
InputConnection sc = (InputConnection)Connector.open(url);
InputStream is = sc.openInputStream();


.... but both don't work :-(

Best,
Tobias
 
J

Jeff Higgins

Tobias said:
Hi Jeff,

Jeff Higgins wrote:

Code: 
Thanks, it's working fine here!

This part:

InputStream is = getClass().getResourceAsStream("records.txt");

is reading "records.txt" from RES-directory or from the JAR
directly. How can I make it loading from the web or a directory?

Normally, this code should work (I'm using it in another app):

String file = "file:///root1/records.txt";
StreamConnection sc = (StreamConnection)Connector.open(file);
InputStream is = sc.openInputStream();

or

String file = "file:///root1/records.txt";
InputConnection sc = (InputConnection)Connector.open(url);
InputStream is = sc.openInputStream();


... but both don't work :-(

Best,
Tobias[/QUOTE]

I'm not sure. I haven't got that far yet. But maybe these
articles can be of some help.

<http://developers.sun.com/techtopics/mobility/midp/articles/network/>

<http://today.java.net/pub/a/today/2007/03/29/working-with-java-me-fileconnection-on-physical-devices.html>

<http://developers.sun.com/techtopics/mobility/midp/articles/midp2network/>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I train a neural network by reading different csv files 0
J2ME 3
Python and CSV files 0
csv read clean up and write out to csv 2
Grouping on and exporting to csv files 1
Software j2me to read gps coordinations 0
Processing large CSV files - how to maximise throughput? 11
Some help in refining this regex for CSV files 2

Members online

No members online now.
Total: 26 (members: 0, guests: 26)
Robots: 304

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,007
Latest member
obedient dusk

Latest Threads

Top