Vendor Modifier - Mass Upload

(0) Share

Report

Posted on by Community Member

We are currently attempting a mass Vendor ID change, so I crated a comma delimited spreadsheet with the current vendor ID in the first column and the new Vendor ID in the second. The issue I'm running into is that a lot of the current Vendor IDs have commas in them (most of our Vendor IDs are Last Name, First Initial). So when I go to validate my spreadsheet, the system is picking up the last name as the current ID and the first initial as the new ID, and therefore unable to find the vendor in the system. Is there any way around this, or how do I set up my spreadsheet so the system picks up the correct fields? TIY!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

HeatherD 425 on at

Like (0)

Report
Copy link

Link copied!

Shannon,

I believe that this is why the manual for PSTL recommends using a tab delimited rather than a comma delimited file. I would recommend making a smaller tab delimited file and testing it out in your test database.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I created a tab delimited spreadsheet as well, but when I went to import and validate the file I got a message saying "you can import only CSV files"

Was this reply helpful? Yes No
HeatherD 425 on at

Like (0)

Report
Copy link

Link copied!

So sorry, I last used Employee and that allowed/recommended tab - I now see Vendor is comma.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

I believe you need to put quotes around the text with a comma in it. It would look like "Last Name, First Name".

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I tried using the quotes - unfortunately, that didn't work either.

Thanks for all the help though!

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Wow,

I tried several different options, and none of them worked. There's got to be a way, but it escapes me. Please let us know if you find an answer. It seems like it should be straightforward with quotes like every other comma delimited data file; but no, this one is 'special'.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I never did come up with a solution - just changed each ID manually

Was this reply helpful? Yes No
Joshua A. Ortiz 5 on at

Like (0)

Report
Copy link

Link copied!

we are currently going through this exact scenario with several hundred vendor id's. Has anyone found a solution to this problem?

Was this reply helpful? Yes No