app to sync contacts with google/outlook-csv....

i am trieng to make such an app.
i wrote a little testapp to get access to the contacts.db but i am not able to insert a row.

so i tried to insert data with SQLite Database Browser.
but it is not possible. when i trie to execute
INSERT INTO ABPerson (ROWID, First ,Last, Name) VALUES(4, 'hugo', 'boss', 'hugo boss')
i get: no such collation sequence: CHINESE_PINYIN

if i klick on "new record" in the database browser i get:
Error ading the record, make shure the table is selected.
If the table contain fields declared as NOT NULL please select EDIT -> PREFERENCES and adjust the the default value for new records to insert an empty string.

but this is also not possible.

grrrrrrrr

hmm, maybe it is some kind of codepage problem?
probably you try to write UTF-8 encoded and they expect GBK

i do not think that it is an encoding problem. in a few tables i am able to write.
i think it is anythink with relations between the tables.

i am not shure if it is the correct way to write directly to the database. perhaps writing to the phonebook is better with the sdk???

but i have never used the sdk, so i am not sure.

perhaps someone can use any SQLite browser and tell me the sql command to insert a contact correctly.

ok the sdk only provides correct designed buttons and access to hardwarebuttons, screen-rotation and so on.
but i can not find any class to access the contacts.
so the only way will be via sql statements. but i am not able to insert rows. i can make new tables, and write to them but it is not possible (for me) to write to the correct tables.

If you could give me a link for downloading this SQLite browser I would give it a try later on...

Google finds it all:
SQLite Database Browser

I didn't know which one to use Thx for the link.

The problem should be the collate (as the error already said). Unfortunately the program isn't working for me very well, I can't execute any queries...

Try the following:

Code:

ALTER TABLE `ABPerson` MODIFY `Name` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

INSERT INTO `ABPerson` (`ROWID`, `First`, `Last`, `Name`) VALUES (4, 'hugo', 'boss', 'hugo boss');

The first query changes the collate-part. This query has to be executed once!

Try it and please report back in if it worked... You should also try to use the DB with the phone again after the changes. I can't say if this change fucks up the whole contact manager

Error: near "MODIFY": syntax error

SQLite Query Language: ALTER TABLE

SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column, remove a column, or add or remove constraints from a table.

i use the sqlite command line tool

Hmm I think then the only possible solution is to delete the whole table and recreate it completely.

If you are in need of help then write again in this thread. Gotta go now

you mean like 'check if i can add tables' -> 'cant' -> 'read all contacts', 'overwrite tabe', 'write new table with backed up contacts'

delete table if you can (i am not able to) => create same table => try sql statement INSERT .....

if you are able to create ABPerson, ABPhone... so that it is possible to write to it youcan send me this contacts.db so that i am able to continue coding the app.

but we should test the "new" contacts.db with a few entrys on the phone to see if there are any problems with the new database.

seems like there is a problem with SQLlight and the M8
Google Translate
or ist that your post? '^^

found this:

Google Translate

Meizu M8 PC Suite synchronization source (non-official non-download)


To avoid unnecessary trouble, download not released, and are interested in can be developed with the stations to contact me.


can someone who is registered at bbs contact this person to get the source?

there is a topic about it. And the software look very good, but it's in chinese and we need a english version

we need the source

Originally Posted by BPM

we need the source

Still no app for this?