Format Excel doc to USP

Excel Macro to convert csv file to usp format

I have found a macro that I received some time ago that is a macro for Excel. When you run this macro it will format the Excel page into a format that can be uploaded to ServiceDesk.

First you will need to upload the macro. You can get it here csv_to_usp_macro

Then what I do is to open the sheet. When you open you can see what the Excel format should be. You want to put he table name in the first cell, then the column heading in a separate cell for each heading. Then finally you add the data in the correct column.

Once you have all the data that you want in the sheet you will need to edit the macro. Click tools, macro, then pick the macro.

You want to edit the macro so that you can set the "save to" location. This will save you from writing over data that you have already saved. Edit the line (Const cstrCallReqExport As String = "c:\usp_contact_to_load.csv") it's line 3.

After you have changed the save to location close the edit screen and run the macro. You will see a pop up that lets you know where the file was saved and that it is done.

You can then look at the file to make sure it is in the correct format. I always open with Word (this let you see it as it formated.)

Then once you have verified that it is correct. Then you can run your deref, pdm_load -f, or pdm_userload -f

Your done.