bulk editing in spreasheet style

I haven't done it and I don't think I'd recommend it, but you may be able to create a link between MS Access and RMS data tables.

Be very, very careful if you attempt this.

If it works, tell us about it.

Tom

Hi Philip,

We can offer a custom solution for your requirement. If you are interested please contact me.

Regards, Manick ERP Soluti> I'm looking for an add-on which would give me the ability to edit a bulk

Hi Philip,

In the RR Store and HQ Utility Utility access the option called wizards. Then go to task 210. There you can select to make items inactive and use the option called Filter. In the filter you can define the supplier and the category etc... and thus bring up a list that you can change based on what you are asking here.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = = = = "Philip Gass - Creative Gardens -" wrote in message news: snipped-for-privacy@TK2MSFTNGP03.phx.gbl...

Hi Phillip...NitroSell offers something called the Product Attribute Manager (PAM)...this will enable you to use filters, copy/past and string functions to make mas edits to your item table. We use it for our web store solution, but it has general utility...you can even create new fields for storing data that RMS does not have (such as Brand name, Theme group, season, etc.) and these fields can automatically be parsed into RMS reports so that you can filter and sort by these novel fields.

Regards, Todd Jensen NitroSell

It does work. I use it frequently. Table links in access are great. However, it's not perfect because sometimes you want to see and modify multiple linked tables at the same time. DepartmentID, CategoryID, SupplierID, etc are not much help when modifying the Item table.

I always backup first and do these changes after hours - just in case.

Maybe a real SQL/MSDE guru can tell us what the risks are from the standpoint of RMS error checking. I assume MS Access would prevent data input that is not compatible with the table structures. It seems like this would be a pretty easy add-in to develop, maybe even in an Access environment. Heck - why not make a whole new manager front-end in Access that can do a variety of tasks? I don't really know what I am talking about, but it sure sounds good! :)

It does work. I use it frequently. Table links in access are great. However, it's not perfect because sometimes you want to see and modify multiple linked tables at the same time. DepartmentID, CategoryID, SupplierID, etc are not much help when modifying the Item table.

I always backup first and do these changes after hours - just in case.

Maybe a real SQL/MSDE guru can tell us what the risks are from the standpoint of RMS error checking. I assume MS Access would prevent data input that is not compatible with the table structures. It seems like this would be a pretty easy add-in to develop, maybe even in an Access environment. Heck - why not make a whole new manager front-end in Access that can do a variety of tasks? I don't really know what I am talking about, but it sure sounds good! :)

It does work. I use it frequently. Table links in access are great. However, it's not perfect because sometimes you want to see and modify multiple linked tables at the same time. DepartmentID, CategoryID, SupplierID, etc are not much help when modifying the Item table.

I always backup first and do these changes after hours - just in case.

Maybe a real SQL/MSDE guru can tell us what the risks are from the standpoint of RMS error checking. I assume MS Access would prevent data input that is not compatible with the table structures. It seems like this would be a pretty easy add-in to develop, maybe even in an Access environment. Heck - why not make a whole new manager front-end in Access that can do a variety of tasks? I don't really know what I am talking about, but it sure sounds good! :)

It's confusing because RMS had all of it's logic embedded in the application, including data integrity.

Item.SupplierID Must have a matching record of Supplier.ID Must have a matching record in SuppierList matching SupplierList.ItemID and SupplierList.SupplierID

If you pop open the Item table in access and change the SupplierID field, YOU are responsible for validating that the ID you have used is valid and thata row has been entered in SupplierList.

The database relationships are not well documented, so it's very easy to overlook checks that are being performed or logic that is being enforced when changes are made through the application.

Glenn Adams Tiber Creek C> Can someone tell me in lay terms what "business rules" means with

That's a great example. It seems like while the application might crash if it encounters a problem as described, the database itself would not be corrupted. At least you would be afforded the opportunity to correct the mistake and move forward without data loss.

What I would be more concerned about is what happens when RMS encounters an inconsistency. They key would be to remember what you did so you can ascertain potential reasons for the crash and go back to fix the data.

In an Access environment, it's pretty easy to copy a table, so going back to a pre-crash table isn't too hard.

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:%23Uf$Q$ snipped-for-privacy@TK2MSFTNGP02.phx.gbl...

This is why the PAM is so great all of the data is indexed properly, the departments and categories are there and you can use it to re- assign D/Cs to the items. It's linked to the SQL database directly so there is no harm in using it outside of the limited GUI that RMS has. Try it out...trial copy runs for 30 days.

Regards, Todd

What is the url?

Todd is right. PAM is the bomb-diggity. I use it all the time!! You can mass change everything. KEWL.

Mickie

Where can I find PAM?

Hi Danny...according to your URL you are with Mickie's place...in tha case you are already running the NitroSell web store...you should already have this in your Programs directory...if you don't have it installed on your machine you just need to install it. You can call oour office or open a support ticket for assistance with this if you need it.

Regards, Todd

Sorry Danny...misread the link on your posting...call me at: (619)

Thanks for the kind sentiment Mickie!

Regards, Todd