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?
Jack Jenkins's Content
There have been 4 items by Jack Jenkins (Search limited from 19-April 23)
#2802 Updating and Importing new prices with DBUWin
Posted by
on 26 July 2010 - 11:25 AM
in
MOM & FOX Database Issues
#2799 Updating and Importing new prices with DBUWin
Posted by
on 26 July 2010 - 06:09 AM
in
MOM & FOX Database Issues
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.
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.
#2788 Updating and Importing new prices with DBUWin
Posted by
on 07 July 2010 - 11:13 AM
in
MOM & FOX Database Issues
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?
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?
#2783 Updating and Importing new prices with DBUWin
Posted by
on 05 July 2010 - 05:34 AM
in
MOM & FOX Database Issues
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.
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.
