Hi,
Just starting to play with Dabo App Wizard.
Does anyone know how to make this work on dbase or VFP files directly?
I know that files can be imported to SQLLite but some of these files are
associated with spatial data in ESRI Shapefiles (that is, I can't change
them).
Essentially Shapefiles store all their attribute data in Dbase III
format. External packages can readily access these files IF they don't
change the file structure, field names or change the code page. I can
access these files via VFP, at a pinch, if I want to manipulate the data
in a way the GIS package does not allow.
As an introductory trial I was looking at making a simple
point-open-edit dbase file editor. Just a simple file browser/editor to
replace VFP on Ubuntu.
It seems the AppWizard (a) does not support xbase files, and (b) the
resulting applications are hard wired.
The dGrid control looks promising but I need a way of
seeing/querying/editing the dbase files, so I am pushed back to the need
for an OS independent driver/odbc.
Johnf had indicated that several modules exist to allow python to access
dbase files but I have not found any that allow editing (the only one he
actually pointed to allowed importation into Postgre).
The functionality for this simple program would be...
(1) File/Open option to select an existing dbase/VFP file
(2) This data to be presented in a grid (dGrid looks OK).
- the user should be able to browse through this dataset in a
continuous manner rather than in screen-sized chunks.
- ULTIMATELY if a dbase/VFP index exists, the user should be
able to seek() for a particular indexed item and if a memo
field exists the user should be able to see this in an
edit field.
(3) Data to be able to be directly edited in the grid.
(4) To be code-page aware (should respect the file's CP).
(5) Filter/Queries and Separate Editing Tabs as in the AppWizard is OK.
Anyone got some code that does something similar. Any ideas how I should
start with this type of project? As I asked yesterday is their any extra
sample applications people are willing to share that illustrate the
appropriate concepts to achieve this task.
--
Cheers Simon
Simon Cropper
Principal Consultant
Botanicus Australia Pty Ltd
PO Box 160, Sunshine, VIC
W: www.botanicusaustralia.com.au
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
