Steven,

I haven't imported parts in a long time but back when, I did not use Excel, I used Access

Also, have  NOTEPAD++ or similar TEXT editor handy

Access can take much longer to setup for the import but results of its CSV creation are superior to Excel's

Practice using the DEMO company, export the parts (select 10), change 2 parts then import. check your results

This is to get the bugs out of the process ( illegal characters, file formatting issues, etc)

******************

IMPORTANT

******************

Back up your company before you try importing.

This stuff is old school,  and might take a few tries to get right, especially as the column titles do not export

Here is an export example from the DEMO company

/U,"ARRANG-AN","ANNIVERSARY ARRANGMENT","","","each","","",,"ARRANG",-2,0.00,0.00,,,,,,,,,,,,,,,,,,,,,,,,,,,""

/U,"ARRANG-BTHDY","BIRTHDAY ARRANGMENT","","","each","","",,"ARRANG",7,45.00,0.00,,,,,,,,,,,,,,,,,,,,,,,,,,,""

/U,"ARRANG-CTPC","CENTER PIECE - CARNATION","","","each","","",,"ARRANG",31,45.40,0.00,,,,,,,,,,,,,,,,,,,,,,,,,,,""

/U,"ARRANG-SPRG","SPRING ARRANGEMENT","","","each","","",,"ARRANG",10,40.00,0.00,,68.00,65.00,63.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,""

/U,"ARRANG-WDNG","LARGE WEDDING ARRANGMENT","","","each","","",,"ARRANG",10,78.26,0.00,,,,,,,,,,,,,,,,,,,,,,,,,,,""

I use the "/U" prefix and it works fine but it is the "/R" prefix that doesn't seem to work for me. It says my file is invalid when it was valid when it used "/U" prefix. What am I doing wrong?

You need to enter the actual parts:

Renaming a record. Enter the “renaming” prefix, original ID, and new ID. In the record below, the part ID “SHORTS” is changed to “SHORTS-BLUE”

/RENAME,SHORTS,SHORTS-BLUE<cr><lf>

As I said that is what I have been doing and it is NOT working

don't know if your still working on this but I just renamed the 1st five parts in DEMO with this:

Make sure to STRIP all other data away from the file except the PartID and NewPartID

/R,"ARRANG-AN","ARRANG-AN2014"

/R,"ARRANG-BTHDY","ARRANG-BTHDY2015"

/R,"ARRANG-CTPC","ARRANG-CTPC2016"

/R,"ARRANG-SPRG","ARRANG-SPRG2017"

/R,"ARRANG-WDNG","ARRANG-WDNG2018"

NOTICE the quotations around the data

This returns the changes back:

/R,"ARRANG-AN2014","ARRANG-AN"

/R,"ARRANG-BTHDY2015","ARRANG-BTHDY"

/R,"ARRANG-CTPC2016","ARRANG-CTPC"

/R,"ARRANG-SPRG2017","ARRANG-SPRG"

/R,"ARRANG-WDNG2018","ARRANG-WDNG"

If you are still having issues after reviewing the responses from Janice and Vince above, then I would suggest calling customer support at 800-447-5700 to open a case with a support analyst.  They can review your current information and the import file to see what else may be the problem.