Jump to content


Photo

Updating and Importing new prices with DBUWin


  • Please log in to reply
5 replies to this topic

#1 Jack Jenkins

Jack Jenkins

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 05 July 2010 - 05:34 AM

Hi all,

Just started at a company utilizing MOM 5.4, and just so happen to start right during the time the company is changing all of their prices. I am familiar (somewhat) with DBUWin, and have successfully exported the Price.dbf file into Access, updated the prices, then exported to excel.

From there, I used DBUWin to "zap" the price table, then append from the excel sheet. The crazy thing is it worked, kind of.

The problem is, though all of the prices ARE populated when you check in the product descriptions, the prices aren't displaying AT ALL when you enter an order.

I am in a real time crunch, and am greatly appreciative of any support.

Thank you.

#2 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 07 July 2010 - 07:00 AM

Hi all,

Just started at a company utilizing MOM 5.4, and just so happen to start right during the time the company is changing all of their prices. I am familiar (somewhat) with DBUWin, and have successfully exported the Price.dbf file into Access, updated the prices, then exported to excel.

From there, I used DBUWin to "zap" the price table, then append from the excel sheet. The crazy thing is it worked, kind of.

The problem is, though all of the prices ARE populated when you check in the product descriptions, the prices aren't displaying AT ALL when you enter an order.

I am in a real time crunch, and am greatly appreciative of any support.

Thank you.


dbuwin is powerful and if you don't understand the system 100%, it is best to work with a backup of MOM to test your results out on.

Have you tried getting everyone out of MOM, deleting all .cdx (database indexes) in the MOMWIN folder, and then having one user log back into MOM (it will auto-recreate the new index files) and then do a full re-index of MOM in Exclusive User mode?
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#3 Jack Jenkins

Jack Jenkins

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 07 July 2010 - 11:13 AM

Of course I am working in a test environment, that goes without saying (one should hope). Thank you though for the concern, I completely understand your viewpoint.

I did completely re-index MOM, to no avail. However, I did not attempt to delete .CDX files. Can you give me more details on that procedure?

Also, as far as "exclusive" user goes, do you mean the only user logged on? or is there an "exclusive" (or power) user account?

#4 Jack Jenkins

Jack Jenkins

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 26 July 2010 - 06:09 AM

More information - Hopefully this helps someone.

When doing a mass price update, there needs to be a table created with the price, quantity, and part number laid out in a vertical format:

SD12 ....... .8500 ....... 5
SD12 ....... .8000 ...... 10
SD12 ....... .7500 ....... 15 , and so on

I just created this in excel.

Then using Access, import both the PRICE table from MOM and the new price worksheet from Excel. Make an update query, then link the two tables via part number and update the quantity and price on the PRICE table.

Then to the problem I was having - someone tell me if there is a better way to do this - I then export to a .CSV with no text qualifiers, and open dbuwin. Open PRICE table, zap, and append from your .CSV.

Have tested both mass price change AND removing mass bad emails - hope this helps.

#5 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 26 July 2010 - 07:01 AM

Of course I am working in a test environment, that goes without saying (one should hope). Thank you though for the concern, I completely understand your viewpoint.

I did completely re-index MOM, to no avail. However, I did not attempt to delete .CDX files. Can you give me more details on that procedure?

Also, as far as "exclusive" user goes, do you mean the only user logged on? or is there an "exclusive" (or power) user account?


Hello again Jack,

Glad you aren't experimenting on live data. What apparantly is common sense to you has been proven to be "not-so-common" with most others.

To better explain what I suggested before:
You would get every user out of MOM.
Then, navigate to your MOM directory from within Explorer (or My Computer) and delete all .cdx files from the directory.
Then have a MOM user with MOM Admin priviledges log into MOM, but keep everyone else out.
MOM will re-build the index files.
When done re-building, have that one MOM Admin re-index the system with everyone out of MOM. That will allow for an exclusive reindex.

Still not sure if that will do the trick, but it certainly would be my first step.
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#6 Jack Jenkins

Jack Jenkins

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 26 July 2010 - 11:25 AM

After I typed that, I realized that not many people who should, do take testing into consideration. Again, thank you for your concern.

Also, I feel like an idiot, I should have known what you were talking about (regarding the Admin/Exclusive user). It just isn't referenced the same here, so I thought there may have been something missing.

That aside, I didn't have to re-index or delete .CDX files within MOM when I used the other method I posted last. What do you think? Is that the best way to accomplish what I am doing?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users