Where are custom field data stored

[rlb_1314]

Hello everyone.

I would be very grateful if someone can tell me which dbf file stores the product custom field data? I am trying to automatically upload this info in the new store but I still haven't figured out where these data are stored. I tried product.dbf and several other files but no luck.

Thanks a lot.

[Bruce - PhosphorMedia]

Re: Where are custom field data stored

custom product feilds where not a standard feature of Merchant 4 (and why you are working on a MM4 site is another question).

So, first of all, we'd have to know what the authorship of the custom fields module is.

[Siamese-Dream.Com]

Re: Where are custom field data stored

custom product feilds where not a standard feature of Merchant 4 (and why you are working on a MM4 site is another question).

I thought there was a Merchant built in custom product field added to that later (compiled) releases of Merchant 4.X

I say this because I am pretty sure that the emporiumplus.com template data feed instructions say that they will export custom product fields, but ONLY if they are part of the built in Miva Merchant custom fields (i.e., NOT part of OUI or a third party custom product field).

[wcw]

Re: Where are custom field data stored

4x TDF does support 3 types: OpenUI, modified products.dbf, Miva's custom fields module (which came out with 4.23 but could be used all the way back to 4.14).

[Bruce - PhosphorMedia]

Re: Where are custom field data stored

I thought there was a Merchant built in custom product field added to that later (compiled) releases of Merchant 4.X

I say this because I am pretty sure that the emporiumplus.com template data feed instructions say that they will export custom product fields, but ONLY if they are part of the built in Miva Merchant custom fields (i.e., NOT part of OUI or a third party custom product field).

...yet another reason to not use MM4...who can remember what went in it.

[wcw]

Re: Where are custom field data stored

Some of us haven't reached senility yet. :-)

[rlb_1314]

Re: Where are custom field data stored

Thanks everyone for replying. We are using 4.12 and upgrading to 5.5. When data migration was done from the old store to the new (still temporary, not live) one, the custom field information was not transferred. That is why I am trying to find a way to extract this info from the old store and avoid manual insertion of these data for thousands of products.

If anyone has any idea how to approach this issue, will you please let me know?

Thanks again :)

[Keitho]

Re: Where are custom field data stored

Ok, so is there a way to export OUI custom customer fields? That's one of the last tasks I need to take care of before finalizing our upgrade to 5.5 (finally!).

[ILoveHostasaurus]

Re: Where are custom field data stored

Ok, so is there a way to export OUI custom customer fields? That's one of the last tasks I need to take care of before finalizing our upgrade to 5.5 (finally!).

I don't think there's a way to export them via the store admin because the OUI author never wrote a customer export module that would know about those fields. The actual custom customer field data is stored in a database called ouiccfld.dbf in the mivadata/Merchant2/00000001/oui/ directory. Unfortunately it will probably be keyed off the customer's internal miva merchant id number and not their username, but I don't know that for sure so it's worth checking. If it's based on username, you could just open the file in Excel probably and get the data out. If it's keyed off the customer id number, you'd need to get the customer info out of the customers.dbf file one directory up, get the custom data out of the ouiccfld.dbf file, and then merge the two based on the id field, possibly in Excel, maybe easier in MS Access.

[kayakbabe]

Re: Where are custom field data stored

I don't know where you'd find it... but I used to have a dbase editor. I think the newer versions of excel will let you open the dbase tables that 4 used... if so, you can get to the data.. you'll have to use the product ids, and then ids from the rows in the tables to cross correlate between the tables, but you can finagle the data directly out of the databases that way.

I imported everything into excell and then used the vlookup function to make my own new spreadsheet with the right columns.. (I then cut and pasted that into notepade and saved it into a txt file and then I could import it into a newer mysql based version of miva merchant). It was a pain in the bootie, but with a ton of products... it worked. Been years though.

I highly recommend you move to the newest version of miva.. it's way more flexible, more stable, runs faster, gets updated, gets bug fixes and is SUPPORTED.