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/