How does the CD info get into the POS? Unless the POS and the CD are from the same company, or two companies in cahoot, and it's some kind of garbled binary format intended to be completely useless... it's probably a flat-file text import. Comma-delimited is most popular, but there are other ways to do it. If you can get a look at the export file from the CD, the chances are pretty high that Excel can save a copy that duplicates the format.
The business about changes is an important issue that's often a pain in the ass. For example, I work with a web-based product that hosts online material for courses. Each course needs to have students enrolled in it. There's a procedure to import a list of students. But there's no automated way to get rid of students. So adding new students is OK (although it's stupid about some things--is it really a good idea to create two different accounts for the same email address? I personally don't think so.), but getting rid of ones who dropped the course remains a manual procedure.
|