Promotional Products Software for Distributors and Suppliers

Sales & Support

Log in

Home

back to list

Create multiple folders for all customers - 01/07/2008

Reference: Customer Database
Type: Tips & Advice
Release: 3.3.004

Issue:

Create multiple folders for a list of customers

Details:

From the command prompt you can run the following command in the folder where you want the new folder(s) to be created... MD Where is either the customer name or account code (account code is easier) Do a data export from PromoServe of all customer account codes and in Excel use the CONCATENATE function to have a column that includes the MD command before the account code e.g. MD CUS001 MD CUS002 MD CUS003 Copy all of those cell contents. Start > Run > type 'cmd' In the command prompt make sure you are in the folder where the folders need to be located. Type CD\ to go straight back the C:\ Then type cd to move up a folder e.g. cd customers Will go to... C:\customers\ Then simply paste in the content of the cells from your spreadsheet. http://articles.techrepublic.com.com/5100-10878_11-5587598.html