ASP and Miva Merchant 4

[kavukattu]

I am using Miva Merchant 4, to host the inventory for my products. However I don't want to necessarily use Miva, but use ASP scripts to extract data from Miva's database.
Does anyone forsee problems if I do this?
Thanks,
Toby

 

[foxdev]

I don't see a problem extracting data from Merchant's dBaseIII-type DBF files. It's when you try to write data that could be an issue.

 

[kavukattu]

Thanks for replying so quickly.
I noticed that the Miva databases uses special indexing.
But what kind of issues will I run into if I attempt to update/edit the database via external scripts, in this case vb scripts in ASP pages?
Thanks,
Toby

 

[foxdev]

As you noticed, Miva uses its own indexes (MVX), so that would be one issue.

Another would be to ensure that the strict dBase III compatibility was maintained. For example, I use Visual FoxPro every day to analyze and report on my Merchant data, but I can't use it to make updates to the store data because VFP will convert the DBT memo files to its own format.

So you have to be completely sure that whatever you use to modify the DBFs won't change the memo field structure and won't unexpectedly change any bytes in the DBF header.

 

[kavukattu]

Thanks foxdev,
Toby