Re: Fw: Error "file ... is not a progect database" after importing CSV file

"rickpricesiliconvalley" <[email protected]> Thu, 17 Sep 2009 14:40:36 -0000
Newsgroups gmane.comp.handhelds.palm.progect
Message-ID <[email protected]>
My guess is that the Progect database is not being written/read with the co=
rrect character set.

The problem is that the Palm database needs to be converted to Unicode insi=
de of Python, and you need to know the correct character set to use, I beli=
eve that the older code does not do this correctly.

Normally everything is fine, because most people use the Palm equivalent of=
 straight ASCII.

PDesk needs to be changed to use a PDB reading/writing library I wrote, it =
should then be able to do this correctly.

The problem is that I don't really have time to work on it, but I would be =
more than happy to help someone else do the changes.

Rick
--- In [email protected], Roger Walker <roger542@...> wrote:
>
> My first e-mail haven't appeared in group messages, so I am trying once m=
ore.
> R.
>=20
> --- On Fri, 8/28/09, Roger Walker <roger542@...> wrote:
>=20
>=20
> From: Roger Walker <roger542@...>
> Subject: Error "file ... is not a progect database" after importing CSV f=
ile
> To: [email protected]
> Date: Friday, August 28, 2009, 9:56 AM
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> Error "file ... is not a progect database" after importing CSV file with =
diacritics into PDESK.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Hello,
> I tried to import CSV file (TEST6E.CSV) with Czech diacritics into PDESK=
=20
> (version 0.8.4, OS Windows XP).
> After saving it as a PDK file, PDESK cannot open this file with error=20
> "file ... is not a progect database".
> Similar operation with CSV file without diacritics (TEST6F.CSV) was succe=
ssful.=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> TEST6E.CSV
> ---------------------------------------------------------------------
> "1";"task";"task note
> dal=C5=A1=C3=AD =C5=99=C3=A1dek";;;
> "2";"subtask";"subtask note";;;
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> TEST6F.CSV
> ---------------------------------------------------------------------
> "1";"task";"task note
> dalsi radek";;;
> "2";"subtask";"subtask note";;;
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> LOG.TXT (some parts omitted)
> ---------------------------------------------------------------------
> New Session started on Wed Aug 26 14:58:13 2009
> platform=C2=A0 : win32
> byteorder : little
> ---------------------------------------------------------------------
> PluginManager started
> Start in C:\Program Files\PDesk
> Now in C:\Program Files\PDesk\plugins
> got plugs : ['CSVInOut.py', 'HTMLInOut.py', 'MSProjectInOut.py', 'TextInO=
ut.py', 'TreepadInOut.py']
> imported <module 'CSVInOut' from 'C:\Program Files\PDesk\plugins\CSVInOut=
.pyo'> successfully
> imported <module 'HTMLInOut' from 'C:\Program Files\PDesk\plugins\HTMLInO=
ut.pyo'> successfully
> imported <module 'MSProjectInOut' from 'C:\Program Files\PDesk\plugins\MS=
ProjectInOut.pyo'> successfully
> imported <module 'TextInOut' from 'C:\Program Files\PDesk\plugins\TextInO=
ut.pyo'> successfully
> imported <module 'TreepadInOut' from 'C:\Program Files\PDesk\plugins\Tree=
padInOut.pyo'> successfully
> loaded plugins : [<class 'CSVInOut.CSVInOut'>, <class 'HTMLInOut.HTMLInOu=
t'>, <class 'MSProjectInOut.MSProjectInOut'>, <class 'TextInOut.TextInOut'>=
, <class 'TreepadInOut.TreepadInOut'>]
> Trying <class 'CSVInOut.CSVInOut'>
> Trying <class 'HTMLInOut.HTMLInOut'>
> Trying <class 'MSProjectInOut.MSProjectInOut'>
> Trying <class 'TextInOut.TextInOut'>
> Trying <class 'TreepadInOut.TreepadInOut'>
> returning output plugins : [<class 'CSVInOut.CSVInOut'>, <class 'HTMLInOu=
t.HTMLInOut'>, <class 'MSProjectInOut.MSProjectInOut'>, <class 'TextInOut.T=
extInOut'>, <class 'TreepadInOut.TreepadInOut'>]
> returning input plugins : [<class 'CSVInOut.CSVInOut'>, <class 'TextInOut=
.TextInOut'>]
> Listening on 127.0.0.1:9999
> Waiting for a request...
> Going to users ... directory : C:\Program Files\palmOne\...
> AppInfo : remaining len =3D 42
> Converter initialized for 2 to 2
> read last record, no ref block
> Fixed 0 errors during checkIntegrity
> AppInfo : remaining len =3D 42
> Converter initialized for 2 to 2
> read last record, no ref block
> Fixed 0 errors during checkIntegrity
> Traceback (most recent call last):
> =C2=A0 File "DetailsView.pyo", line 566, in OnIdle
> =C2=A0 File "Record.pyo", line 154, in __len__
> =C2=A0 File "RecordV023.pyo", line 120, in pack
> =C2=A0 File "encodings\cp1252.pyo", line 18, in encode
> UnicodeDecodeError: 'ascii' codec can't decode byte 0x9a in position 13: =
ordinal not in range(128)
> ...
> Traceback (most recent call last):
> =C2=A0 File "DetailsView.pyo", line 566, in OnIdle
> =C2=A0 File "Record.pyo", line 154, in __len__
> =C2=A0 File "RecordV023.pyo", line 120, in pack
> =C2=A0 File "encodings\cp1252.pyo", line 18, in encode
> UnicodeDecodeError: 'ascii' codec can't decode byte 0x9a in position 13: =
ordinal not in range(128)
> End date : Wed Aug 26 15:00:24 2009
> Session ended normally.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> I would be grateful for any help.
> With regards
> Roger
> Prague, Czech Republic
>=20
>=20
>=20
>=20
>=20=20=20=20=20=20=20
>=20
> [Non-text portions of this message have been removed]
>




------------------------------------


Remember to visit Polls, Files and Bookmarks sections at http://groups.yaho=
o.com/group/progect. You are welcome to vote, upload your files and submit =
bookmarks.Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/progect/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/progect/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected]=20
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/