1

I am trying to write a custom FoxPro XBase database driver for Unix via Perl. I am currently able to perform CRUD on my .dbf and .cdx indices. The point of sale software my store uses has a FoxPro based file system. The master plan behind the idea is to have a proxy between the POS and my Magento web store. Allowing real time updates between the brick and mortar store and the ecommerce solution.

My question is fairly simple and straight forward. Whats the best way to dump my .cdx file contents so i can quickly look at the indices on the .dbf file. I am currently using XBases indexdump, but this is a slow and tedious process. The dump can be platform independent and can be purchasable software if needed. I am trying to accomplish this picture from MSDN

enter image description here

stuartd
  • 70,509
  • 14
  • 132
  • 163
jejernig
  • 319
  • 2
  • 8

1 Answers1

1

This from MSDN might help - it's not really a documented or discussed thing though, as someone is doing what you're doing there is no need to ever delve into the CDX structure.

Alan B
  • 4,086
  • 24
  • 33
  • As far as i have found because we are on a unix box inserting into the dbf directly via XBase and not through ODBC. If you were to go through the ODBC connection it handles indexing everything for you. – jejernig Jun 13 '12 at 17:49
  • Also - Visual FoxPro is not just DBF/CDX/FPT files, there's also a database container which can have stored procedures and triggers and the like. – Alan B Jun 14 '12 at 13:59