RE: Exporting Database to Excel to Update Descriptions and Pricing and then Import back to Database
In the Administrator (or sql manager) run this query:
"SELECT ID, Description from Item" (You can also do this from the inventory report with the ItemLookupCode and Description, but this how I do it) Then click File, Export and save that CSV file.
If you have Excel installed, double click on that csv file and it will open in Excel. Add a new column "C" and enter the new description. I would recommend not to use ' or " in the description or you will have to change around the script on the next step. You can search on how to do that.
Now in column D enter this:
="UPDATE Item Set Description = '" &C1&"' Where ID = "&A1&";" (Adjust C1, A1 to the column/row you are using). This will hardcode the command and grab the data from the new description cell and the item id cell. When you hit enter it should show something like this:
Update Item Set Description = 'Here is my new description' Where ID = 12345;
If so, copy/paste that to all of the other rows. Finally, copy all of those rows and paste into the RMS manager as a new query (it will show as a bunch of queries) and run it. I would recommend a database backup first.
Again, if you have ' or " in your description, You can search on how to adjust the script to account for those. If you dont it will mess up your query.
