The CSV file and the CSV Import script shown below demonstrate how to import custom fields of various types.
CSV file:
Name,Category,UserUDF,URLUDF,MultiListUDF,TaskUDF,IntegerUDF,ListUDF,DateUDF,FloadUDF,StringUDF,MemoUDF "Products","Folder","jsmith;pdagley;slaw","http://www.trackstudio.com - TrackStudio", "multiListValue3;multiListValue4","#2;#4;#5","54","listValue2","12/16/05 3:38 PM", "5.6","stringUdf value","memo UDF value" "Customer Support","Folder","cparmenter;smanske","http://localhost:8888/TrackStudio - local TrackStudio instance", "multiListValue1;multiListValue2;multiListValue4","#15;#16;#18;#22;#23","33","listValue2","12/30/05 3:40 PM", "43.6","str val2","memval2"
CSV Import script:
Map taskMap = new HashMap(); String locale = sc.getUser().getLocale(); DateFormatter df = new DateFormatter(sc.getUser().getTimezone(), locale); taskMap.put(CSVImport.TASK_NAME, inputMap.get("Name")); taskMap.put(CSVImport.TASK_CATEGORY_ID, CSVImport.findCategoryIdByName((String) inputMap.get("Category"))); Map udfMap = new HashMap(); if (inputMap.get("MemoUDF") != null) udfMap.put("MemoUDF", inputMap.get("MemoUDF")); if (inputMap.get("DateUDF") != null && !inputMap.get("DateUDF").equals("")) udfMap.put("DateUDF", sc.getUser().getDateFormatter().parse( df.parseToCalendar((String)inputMap.get("DateUDF")))); if (inputMap.get("FloadUDF") != null) udfMap.put("FloadUDF", inputMap.get("FloadUDF")); if (inputMap.get("IntegerUDF") != null) udfMap.put("IntegerUDF", inputMap.get("IntegerUDF")); if (inputMap.get("StringUDF") != null) udfMap.put("StringUDF", inputMap.get("StringUDF")); if (inputMap.get("ListUDF") != null) udfMap.put("ListUDF", inputMap.get("ListUDF")); if (inputMap.get("MultiListUDF") != null) udfMap.put("MultiListUDF", inputMap.get("MultiListUDF")); if (inputMap.get("TaskUDF") != null) udfMap.put("TaskUDF", inputMap.get("TaskUDF")); if (inputMap.get("UserUDF") != null) udfMap.put("UserUDF", inputMap.get("UserUDF")); if (inputMap.get("URLUDF") != null) udfMap.put("URLUDF",inputMap.get("URLUDF")); taskMap.put(CSVImport.TASK_UDF_MAP, udfMap); return taskMap;
Copyright (c) 2002-2006. All rights reserved.
|