Regenerating Description in Matrix

Jul 06, 2005 1 Replies

Michael,

I have used and still use the EMS MS SQL Import tool and it has the ability to Append / Edit records. In fact that is why I got this tool because of its ability to do this but also many other things. You can also update using the QS Import tool by unchecking 'Treat duplicate records as errors' the only thing is it completely over writes the entire record so you have to import everything back into the record. i.e. ILC, Description, Price, Cost, Inventory, Onhand, Matrix Member.....basically any field that has a value in it, otherwise it gets erased.

Rob

"Michael Rusli (gordonMax Australia)" wrote in message news:BEF1CCAD.4289% snipped-for-privacy@gordonmax.com.au...

Hi,



Several earlier post mentioned a QS Import or EMS MS SQL Import utility for importing .xls data into RMS. It seems that these two utilities can only Insert new records but not Append / Edit records. Is there any utility that will allow me to do this. I need to change some dimensions in the matrix and I need the Descriotion to be regenerated. This can easily be done in Excel. Any help is most appreciated.



Michael


Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required