OUI Custom Product Fields

[morditech.com]

I am looking for the file that stores the actual data for the OUI Custom Product Fields. I found the data base that stores the Custom Product Field Names but no luck with the actual data that belongs to these custom Fields.
This is a Miva Merchant 4.24 Store.
Any help would be appreciated.

[DesignExtend-MSI]

Look under mivadata/Merchant2/00000001/oui/

[morditech.com]

Thanks for the reply but we checked all of the data files in mivadata/Merchant2/00000001/oui and in mivadata/Merchant2/00000001 to no avail. Unless there is some serious data encryption or compression we didn?t find anything that looked like the data that should be in the fields.

[Vic - WolfPaw Computers]

mivadata/Merchant2/0000000/oui/ouicpfld.dbf

[morditech.com]

mivadata/Merchant2/0000000/oui/ouicpfld.dbf seems to contain only the custom product field names but not the actual data that goes into those custom fields.

[burcham]

does anyone know the answer to this?

like morditech.com i've looked everywhere I know to look at can't find that data. mivadata/Merchant2/0000000/oui/ouicpfld.dbf is the field names, but not the data.

i used OpenMaintence to identify databases that have a large number of records, but none of them contained the custom product data.

thanks. -burcham

[Mike521w]

Did anyone ever find the answer to this?

[morditech.com]

My client ended up upgrading to Miva 5 before I found a resolution, sorry.

[tbogus]

hmmm... I used to know. I spent the better part of October '05 looking for that database - yes - it was that hard.

Even if you find the database, it probably won't help you that much. If it's like the current - which I think it is - the default 'miva way' of sorting customers is in a vertical format, compared to a single record with several custom field columns!

Tim.

P.s. I'll see if I can find the file - it's documented somewhere...

[Mike521w]

thanks :) I spent a lotta time digging around for them the other day too, I can't believe there's a table that has the field names but no obvious table containing the data! talk about frustrating

[Mike521w]

just want to refresh this topic and see if anyone has a solution yet. I'm still searching myself

[inwall]

It's "sort of" in the oui/langmemos.dbf

I can see why everyone seems to advise against using the languages option. Take a look at this dbf and WTF.

Now that I've found it....if you can figure out the other relationships, lemme know!

[inwall]

So the relationship is between langmemos.dbf > langstrings.dbf > then only by prodname (not code) in your regular prod.dbf

Then, you have to "discover" which of your custom product field ID's correspond to the id # in Field #3 of langmemos.

From there you can query away, but you'll find ALL your changes that you've done to each of your items....I believe that every time you "update" an item, you'll create a record in there. if I can figure out how to only use the highest count of each of the prodnames, I'm gold.

[tbogus]

There are a few developers out there that made an export script to export OUI custom fields...

This is one I found on a quick bookmark search: http://mvmonster.com/orders_dflt/more_information.php?product_id=8,