save list to csv

droidman · May 6, 2011

I listed all the contacts i have on the phone on a list, now i wanted to save the list to CSV but i always get errors on the emulator.
Dim su As StringUtils
su.SaveCSV(File.DirRootExternal, "1.csv", ",", table)
i'm doin'g it like on the tutorial's you have, with savecsv and savecsv2 and none seems to work. is it a bug on the emulator?

agraham · May 6, 2011

Have you added an SD card to the emulator when you created it?

droidman · May 6, 2011

agraham said:
Have you added an SD card to the emulator when you created it?

yes mate it has a SD card mounted and on my mobile phone (htc magic) i get the same error:

Code:

An Error has ocurred in sub: main_savecontacts_click (B4A line: 80) su.SaveCSV(File.DirRootExternal, "1.csv", ",",list1) java.lang.ClassCastException java.lang.string Continue ?

agraham · May 6, 2011

Something in your list can't be converted to a String. Look in the Logs tag, unfiltered, and you may get more information from the stack trace there.

droidman · May 6, 2011

agraham said:
Something in your list can't be converted to a String. Look in the Logs tag, unfiltered, and you may get more information from the stack trace there.

i cant understand half of it, also i dont know how to copy those lines to past here... is that log saved anywhere?

agraham · May 6, 2011

It's not saved except on the device or emulator. You can take a screenshot of the IDE or right click on the Logs to copy lines to the clipboard.

droidman · May 6, 2011

agraham said:
It's not saved except on the device or emulator. You can take a screenshot of the IDE or right click on the Logs to copy lines to the clipboard.

great. here it is:

Code:

java.lang.ClassCastException: java.lang.String
   at anywheresoftware.b4a.objects.StringUtils.SaveCSV2(StringUtils.java:74)
   at
anywheresoftware.b4a.objects.StringUtils.SaveCSV(StringUtils.java:67)
   at contacts2.csv.droidman.main._savecontacts_click(main.java:277)
   at java.lang.reflect.Method.invokeNative(Native Method)
   at java.lang.reflect.Method.invoke(Method.java:507)
   at anywheresoftware.b4a.BA.raiseEvent2(BA.java:99)
   at anywheresoftware.b4a.BA.raiseEvent2(BA.java:89)
   at anywheresoftware.b4a.BA.raiseEvent(BA.java:85)
   at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:49)
   at android.view.View.performClick(View.java:2485)
   at android.view.View$PerformClick.run(View.java:9080)
   at android.os.Handler.handleCallback(Handler.java:587)
   at android.os.Handler.dispatchMessage(Handler.java:92)
   at android.os.Looper.loop(Looper.java:123)
   at android.app.ActivityThread.main(ActivityThread.java:3647)
   at java.lang.reflect.Method.invokeNative(Native Method)
   at java.lang.reflect.Method.invoke(Method.java:507)
   at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
   at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
   at dalvik.system.NativeStart.main(Native Method)
java.lang.ClassCastException: java.lang.String

this is just the last exception

droidman · May 6, 2011

and this one is on my htc magic

Code:

LogCat connected to: B4A-Bridge: HTC HTC Magic/Dream-##########
--------- beginning of /dev/log/system
--------- beginning of /dev/log/main
Connected to B4A-Bridge
Installing file.
PackageAdded: package:convert.kgm.droidman
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
** Activity (main) Resume **
main_savecontacts_click (B4A line: 80)
su.SaveCSV(File.DirRootExternal, "1.csv", ",", list1)
java.lang.ClassCastException: java.lang.String
   at anywheresoftware.b4a.objects.StringUtils.SaveCSV2(StringUtils.java:74)
   at anywheresoftware.b4a.objects.StringUtils.SaveCSV(StringUtils.java:67)
   at convert.kgm.droidman.main._savecontacts_click(main.java:277)
   at java.lang.reflect.Method.invokeNative(Native Method)
   at java.lang.reflect.Method.invoke(Method.java:507)
   at anywheresoftware.b4a.BA.raiseEvent2(BA.java:99)
   at anywheresoftware.b4a.BA.raiseEvent2(BA.java:89)
   at anywheresoftware.b4a.BA.raiseEvent(BA.java:85)
   at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:49)
   at android.view.View.performClick(View.java:2501)
   at android.view.View$PerformClick.run(View.java:9107)
   at android.os.Handler.handleCallback(Handler.java:587)
   at android.os.Handler.dispatchMessage(Handler.java:92)
   at android.os.Looper.loop(Looper.java:123)
   at android.app.ActivityThread.main(ActivityThread.java:3848)
   at java.lang.reflect.Method.invokeNative(Native Method)
   at java.lang.reflect.Method.invoke(Method.java:507)
   at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:841)
   at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:599)
   at dalvik.system.NativeStart.main(Native Method)
java.lang.ClassCastException: java.lang.String

agraham · May 6, 2011

It's erroring on this Java line I think

int colCount = ((String[])Table.Get(0)).length;

The only thing I can think of is you have not Initialized your List object.

agraham · May 6, 2011

I take that back, I was confusing two different Get methods. Are you sure you have only Strings in your List?

agraham · May 6, 2011

Ah! I guess you have not twigged that the entries in the List need to be String arrays for SaveCSV!

droidman · May 6, 2011

:sign0104:

agraham said:
I take that back, I was confusing two different Get methods. Are you sure you have only Strings in your List?

right now the list contains the person name and their e-mail.
if one of the variables is not a string i can always modify it to become a string right?

agraham · May 6, 2011

Look above, I bet that's the problem.

droidman · May 6, 2011

agraham said:
I take that back, I was confusing two different Get methods. Are you sure you have only Strings in your List?

agraham said:
Look above, I bet that's the problem.

i'm really not finding the problem.
do i have to make a FOR cicle and save each line or just call it
su.SaveCSV(File.DirDefaultExternal, "1.csv", ",", list1)

agraham · May 7, 2011

From the help for SaveCSV

Table - A List with arrays of strings as items. Each array represents a row. All arrays should be of the same length.

I suspect your list items are not arrays.

droidman · May 7, 2011

agraham said:
From the help for SaveCSV
I suspect your list items are not arrays.

ok mate so this is how i load the list:

Code:

For i = 0 To listOfContacts.Size - 1
        myContact = listOfContacts.Get(i)
        list1.Add(myContact.DisplayName)
        map1.Put(myContact.DisplayName, myContact)
    Next
    list1.Sort(True)
    For i = 0 To list1.Size - 1
                myContact = map1.Get(list1.Get(i))
                emails1 = myContact.GetEmails
      emails = emails1
                emails = emails.Replace ("{", "")
      emails = emails.Replace ("}", "")
      emails = emails.Replace ("=1", "")
      names = myContact.Name
                lvPersons.AddTwoLines(names,emails)

and then when i do this when the button is pressed to save:

Code:

su.SaveCSV(File.DirDefaultExternal, "1.csv", ",", list1)

i also tried

Code:

su.SaveCSV(File.DirDefaultExternal, "1.csv", ",", lvPersons)

it fails. do you find anything wrong with my code?
i'm just starting i have less than 4 days of basic4android.

agraham · May 7, 2011

droidman said:
do you find anything wrong with my code?

Yes, like I pointed out your list items are strings, not string arrays which is what SaveCSV expects.

list1.Add(myContact.DisplayName)

is adding a string as a list item.

You need to add a string array

list1.add(Array As String(myContact.DisplayName))

droidman · May 7, 2011

agraham said:
Yes, like I pointed out your list items are strings, not string arrays which is what SaveCSV expects.

list1.Add(myContact.DisplayName)

is adding a string as a list item.

You need to add a string array

list1.add(Array As String(myContact.DisplayName))

thanks for your help. I did that modification and now the program "explodes" at "list1.Sort(True)" probably because the emulator restarted and now it does not have the contacts i created before.
so this validation could be done in 2 ways i did know in vb and .net wich are checking if the list contains any ittems and then validating and the other one was the BAD way to do it that was "on error resume next"
wich by the way, is there any way to do that on basic4android ?

agraham · May 7, 2011

If the List is empty List.Size returns 0.

droidman · May 9, 2011

agraham said:
If the List is empty List.Size returns 0.

Hi mate i'm getting this error when trying to save

java.lang.ClassCastException: anywheresoftware.b4a.objects.ListViewWrapper$SimpleListView

any idea?

save list to csv

Member

Expert

Member

Expert

Member

Expert

Member

Member

Expert

Expert

Expert

Member

Expert

Member

Expert

Member

Expert

Member

Expert

Member

Similar Threads