Import csv character problem or XML

S

sigster

Active Member
Licensed User
Longtime User
Hi I am try to find out how to import XML into database
did search the forum but did not see a sample

I have csv file I download and it work well with DBUtils.InsertMaps but then I have character problem the file I import I need to download the file so I can not fix the file before I download

Regards
Sigster
 
Sort by date Sort by votes

Yafuhenk

Active Member
Licensed User
Longtime User
Is it possible to upload the csv file so that some of us can have a look to see if the character problem you talk about can be solved?
 
Upvote 0
S

sigster

Active Member
Licensed User
Longtime User
Thanks YAFUHENK

This is the file


Regards
Sigster
 

Attachments

  • Bpost.txt
    88 bytes · Views: 253
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
Your file is encoded with Windows-1252 character set.
You can properly read the string with:
B4X: 
   Dim tr As TextReader
   tr.Initialize2(File.OpenInput(File.DirAssets, "bpost.txt"), "Windows-1252")
   Log(tr.ReadAll)
   tr.Close

StringUtils.LoadCSV only works with UTF8 files. If you want to use it you will need to first write the string to a temporary file with File.WriteString.
 
Upvote 0
S

sigster

Active Member
Licensed User
Longtime User
Thanks this works well

B4X: 
    Dim tr As TextReader
tr.Initialize2(File.OpenInput(File.DirAssets, "bpost.txt"), "Windows-1252")
Log(tr.ReadAll)
tr.Close

Regards
Sigster
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Import a TIN Model from a LandXML file crashes
Replies
6
Views
1K
Terradrones
M
  • Article
Android Example Import a CSV Text File Into a Newly Created SQLite Table
Replies
2
Views
3K
Mariano Ismael Castro
J
  • Question
Android Question Download and read .csv
Replies
16
Views
4K
johnmie
  • Locked
  • Article
B4A Library [B4X] BCTextEngine / BBCodeView - Text engine + BBCode parser + Rich Text View
7 8 9
Replies
165
Views
106K
Erel
  • Question
Android Question Import CSV
Replies
6
Views
3K
LA3QMA
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…