PumperNickel

Import to Prophet

This process enables importing data files into Prophet via PumperNickel 
1. Select Import Type
2. Prepare import file Save the file as csv, ready for import
3. Load import file
  Server File Directory
File Name
      or
  Local File
4. Check import file
5. Import data via FT  DT  OLEDB  Ghost 
File imported ok, 34 lines - 1 header, 20 to updated, 14 new.
or
File failed check, 34 lines, - 1 header, 20 to update, 7 new, 6 bad
Line 32, Stock code KLUNK does not exist in Prophet
Line 12, Currency code YEN does not exist in Prophet
Line 31, Our cost price must be between 0 and 9999.99, not -1.00
Line 3, Effective date can not be interpreted :45/32/2009:
Line 4, Not enough columns in row
Line 9, Their part code is longer than 16 characters: 2309j209jc20jcslj9js4fw4
No importing performed
Raw XML