Announcement

Collapse
No announcement yet.

Where are custom field data stored

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Where are custom field data stored

    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.

    #2
    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.
    Bruce Golub
    Phosphor Media - "Your Success is our Business"

    Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
    phosphormedia.com

    Comment


      #3
      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).
      Mark Romero
      ~~~~~~~~

      Comment


        #4
        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).
        Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
        Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
        Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
        Facebook http://www.facebook.com/EmporiumPlus
        Twitter http://twitter.com/emporiumplus

        Comment


          #5
          Re: Where are custom field data stored

          Originally posted by Siamese-Dream.Com View Post
          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.
          Bruce Golub
          Phosphor Media - "Your Success is our Business"

          Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
          phosphormedia.com

          Comment


            #6
            Re: Where are custom field data stored

            Some of us haven't reached senility yet. :-)
            Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
            Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
            Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
            Facebook http://www.facebook.com/EmporiumPlus
            Twitter http://twitter.com/emporiumplus

            Comment


              #7
              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 :)

              Comment


                #8
                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!).
                Keith Oratz
                PrepareSmart, LLC - Emergency Preparedness Supplies and Professional Grade Search and Rescue Gear
                www.preparesmart.com

                Comment


                  #9
                  Re: Where are custom field data stored

                  Originally posted by Keitho View Post
                  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.
                  David Hubbard
                  CIO
                  Miva
                  [email protected]
                  http://www.miva.com

                  Comment


                    #10
                    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.

                    Comment

                    Working...
                    X