Study about webtools there is one data import facility study that and use it for your requirements.
With regards, S K Pradeep kumar, On Thu, Nov 12, 2009 at 8:05 PM, su2 <[email protected]> wrote: > > Hi Pradeep, > > Sorry still little confuse. How am I going to use DemoProduct.xml file? I > understood the file I can have all my required data there, but after that > what should I be doing in order to insert the data in entities? > > Thank you. > Shuchi - > > S K Pradeep kumar wrote: > > > > you can find the xml filse in the data folder in all the application/* > > module , to create the new products use DemoProduct.xml file. > > > > With regards, > > S K Pradeep kumar, > > > > > > > > On Thu, Nov 12, 2009 at 7:12 PM, su2 <[email protected]> wrote: > > > >> > >> Hi Pradeep, > >> > >> Thanks for your response. > >> > >> Sorry I am new to ofbiz. But I am not sure where to define the entity > >> names > >> and the entity-field names where I want to insert the data(as all the > >> information like price and others for the product is not stored in only > >> 'Product' entity, I need to insert the data in multiple entities)? > >> > >> Do I have to specify in XML? Do you have any sample xml file? I want to > >> insert data for new products > >> > >> Also, I see entity "DataImportProduct". What is that for? > >> > >> Once again thank you for the help. > >> > >> Shuchi- > >> > >> > >> S K Pradeep kumar wrote: > >> > > >> > Hi shuchi, > >> > > >> > Convert your .cvs to xml and use webtools entity import. > >> > > >> > With regards, > >> > S K Pradeep kumar, > >> > > >> > > >> > > >> > On Thu, Nov 12, 2009 at 12:52 AM, su2 <[email protected]> wrote: > >> > > >> >> > >> >> Hi Jacques, > >> >> > >> >> I want to insert all the excel data into the database. I looked at > >> >> viewdatafile screen, and looked like, using that I can not insert all > >> my > >> >> excel data into database tables. > >> >> > >> >> > >> >> Jacques Le Roux wrote: > >> >> > > >> >> > I'd use CSV with > >> https://localhost:8443/webtools/control/viewdatafile > >> . > >> >> I > >> >> > let you find more on this ML archives... > >> >> > > >> >> > Jacques > >> >> > > >> >> > From: "su2" <[email protected]> > >> >> >> > >> >> >> Hi Nalin, > >> >> >> > >> >> >> We have similar requirement where we want to upload/import all the > >> >> >> product > >> >> >> information from excel sheet. > >> >> >> > >> >> >> I would really appreciate if you could tell me, how we can achieve > >> >> that. > >> >> >> > >> >> >> Thank you. > >> >> >> Shuchi- > >> >> >> > >> >> >> Nalin Chandra wrote: > >> >> >>> > >> >> >>> Hi All > >> >> >>> > >> >> >>> I want to import the product related data from excel sheet. I did > >> it > >> >> but > >> >> >>> i > >> >> >>> have one problem in this. > >> >> >>> I excel sheet i have absolute path of image now i want to upload > >> the > >> >> >>> image > >> >> >>> from that absolute path to our application as well store the > >> relative > >> >> >>> path > >> >> >>> in data base as we did in product content section. > >> >> >>> i am able to store the relative path in database but image in not > >> >> >>> uploading in the required folder. > >> >> >>> > >> >> >>> Main problem is that here i am not using any html form. > >> >> >>> > >> >> >>> i paste the code below for it > >> >> >>> > >> >> >>> public static String uploadCategory(HttpServletRequest request, > >> >> >>> HttpServletResponse response) { > >> >> >>> > >> >> >>> try > >> >> >>> { > >> >> >>> String filename = "D:/category.xls"; > >> >> >>> WorkbookSettings ws = new WorkbookSettings(); > >> >> >>> ws.setLocale(new Locale("en", "EN")); > >> >> >>> Workbook workbook = Workbook.getWorkbook(new > >> >> >>> File(filename),ws); > >> >> >>> Sheet s = workbook.getSheet(0); > >> >> >>> readCategoryDataSheet(s, request); > >> >> >>> workbook.close(); > >> >> >>> } > >> >> >>> catch (IOException e) > >> >> >>> { > >> >> >>> e.printStackTrace(); > >> >> >>> } > >> >> >>> catch (BiffException e) > >> >> >>> { > >> >> >>> e.printStackTrace(); > >> >> >>> } > >> >> >>> > >> >> >>> return "success"; > >> >> >>> } > >> >> >>> > >> >> >>> private static void readCategoryDataSheet(Sheet s, > >> >> >>> HttpServletRequest > >> >> >>> request) > >> >> >>> { > >> >> >>> Cell rowData[] = null; > >> >> >>> int successCount = 0; > >> >> >>> int failCount = 0; > >> >> >>> int rows = s.getRows(); > >> >> >>> int column = s.getColumns(); > >> >> >>> String productCategoryId = ""; > >> >> >>> String productCategoryTypeId = ""; > >> >> >>> String primaryParentCategoryId = ""; > >> >> >>> String categoryName = ""; > >> >> >>> String description = ""; > >> >> >>> String longDescription = ""; > >> >> >>> String categoryImageUrl = ""; > >> >> >>> String linkOneImageUrl = ""; > >> >> >>> String prodCatalogId = ""; > >> >> >>> String prodCatalogCategoryTypeId = ""; > >> >> >>> String sequenceNum = ""; > >> >> >>> > >> >> >>> for (int i = 1; i < rows; i++) { > >> >> >>> rowData = s.getRow(i); > >> >> >>> if (rowData[0].getContents().length() != > >> 0) > >> { > >> >> >>> for (int j = 0; j < column; j++) > { > >> >> >>> switch (j) { > >> >> >>> case 0: > >> >> >>> productCategoryId > >> = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 1: > >> >> >>> > >> productCategoryTypeId > >> >> = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 2: > >> >> >>> > >> >> primaryParentCategoryId > >> >> >>> = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 3: > >> >> >>> categoryName = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 4: > >> >> >>> description = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 5: > >> >> >>> longDescription = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 6: > >> >> >>> categoryImageUrl > = > >> >> >>> rowData[j].getContents(); > >> >> >>> case 7: > >> >> >>> linkOneImageUrl = > >> >> >>> rowData[j].getContents(); > >> >> >>> default: > >> >> >>> break; > >> >> >>> } > >> >> >>> } > >> >> >>> } > >> >> >>> String imageFilenameFormat = > >> >> >>> UtilProperties.getPropertyValue("catalog", > >> "image.filename.format"); > >> >> >>> String imageServerPath = > >> >> >>> UtilProperties.getPropertyValue("catalog", "image.server.path"); > >> >> >>> String imageUrlPrefix = > >> >> >>> UtilProperties.getPropertyValue("catalog", "image.url.prefix"); > >> >> >>> > >> >> >>> > >> >> >>> // upload image > >> >> >>> FlexibleStringExpander filenameExpander = > >> new > >> >> >>> FlexibleStringExpander(imageFilenameFormat); > >> >> >>> String catImageUrl = ""; > >> >> >>> String linkImageUrl = ""; > >> >> >>> if(categoryImageUrl != null && > >> >> >>> categoryImageUrl.length() > 0){ > >> >> >>> Object forLock = new Object(); > >> >> >>> String contentType = null; > >> >> >>> String categoryImageLocation = > >> >> >>> filenameExpander.expandString(UtilMisc.toMap("location", > >> >> "categories", > >> >> >>> "type", "category", "id", productCategoryId)); > >> >> >>> String filePathPrefix = ""; > >> >> >>> String filenameToUse = > >> >> >>> categoryImageLocation; > >> >> >>> if > >> >> (categoryImageLocation.lastIndexOf("/") > >> >> >>> != > >> >> >>> -1) { > >> >> >>> filePathPrefix = > >> >> >>> categoryImageLocation.substring(0, > >> >> >>> categoryImageLocation.lastIndexOf("/") > >> >> >>> + 1); // adding 1 to include the trailing slash > >> >> >>> filenameToUse = > >> >> >>> > >> >> > categoryImageLocation.substring(categoryImageLocation.lastIndexOf("/") > >> >> + > >> >> >>> 1); > >> >> >>> } > >> >> >>> > >> >> >>> int i1; > >> >> >>> if (contentType != null && (i1 = > >> >> >>> contentType.indexOf("boundary=")) != -1) { > >> >> >>> contentType = > >> >> contentType.substring(i1 > >> >> + > >> >> >>> 9); > >> >> >>> contentType = "--" + contentType; > >> >> >>> } > >> >> >>> > >> >> >>> String defaultFileName = > filenameToUse > >> + > >> >> >>> "_temp"; > >> >> >>> HttpRequestFileUpload uploadObject = > >> new > >> >> >>> HttpRequestFileUpload(); > >> >> >>> > >> >> >>> uploadObject.setOverrideFilename(defaultFileName); > >> >> >>> > >> uploadObject.setSavePath(imageServerPath > >> >> + > >> >> >>> "/" > >> >> >>> + filePathPrefix); > >> >> >>> try{ > >> >> >>> uploadObject.doUpload(request); > >> >> >>> > >> >> >>> }catch(IOException e){ > >> >> >>> Debug.logInfo("Image uploading > >> failure", > >> >> >>> module); > >> >> >>> } > >> >> >>> String categoryImageFileName = > >> >> >>> uploadObject.getFilename(); > >> >> >>> > >> >> >>> if (categoryImageFileName != null && > >> >> >>> categoryImageFileName.length() > 0) { > >> >> >>> if > >> >> >>> (categoryImageFileName.lastIndexOf(".") > >> >> >>> > 0 && categoryImageFileName.lastIndexOf(".") < > >> >> >>> categoryImageFileName.length()) { > >> >> >>> filenameToUse += > >> >> >>> > >> >> > >> categoryImageFileName.substring(categoryImageFileName.lastIndexOf(".")); > >> >> >>> } else { > >> >> >>> filenameToUse += ".jpg"; > >> >> >>> } > >> >> >>> try{ > >> >> >>> String characterEncoding = > >> >> >>> request.getCharacterEncoding(); > >> >> >>> catImageUrl = imageUrlPrefix + > "/" > >> + > >> >> >>> filePathPrefix + java.net.URLEncoder.encode(filenameToUse, > >> >> >>> characterEncoding); > >> >> >>> }catch(Exception e){ > >> >> >>> System.out.println("Incoding > >> >> Problem"); > >> >> >>> } > >> >> >>> > >> >> >>> try { > >> >> >>> File file = new > >> >> File(imageServerPath > >> >> >>> + > >> >> >>> "/" + filePathPrefix, defaultFileName); > >> >> >>> File file1 = new > >> >> >>> File(imageServerPath > >> >> >>> + "/" + filePathPrefix, filenameToUse); > >> >> >>> try { > >> >> >>> file1.delete(); > >> >> >>> } catch(Exception e) { > >> >> >>> System.out.println("error > >> >> >>> deleting > >> >> >>> existing file (not neccessarily a problem)"); > >> >> >>> } > >> >> >>> file.renameTo(file1); > >> >> >>> } catch(Exception e) { > >> >> >>> e.printStackTrace(); > >> >> >>> } > >> >> >>> } > >> >> >>> } > >> >> >>> > >> >> >>> // end of upload image > >> >> >>> > >> >> >>> Timestamp fromDate = UtilDateTime.nowTimestamp(); > >> >> >>> GenericDelegator delegator = (GenericDelegator) > >> >> >>> request.getAttribute("delegator"); > >> >> >>> try { > >> >> >>> GenericValue DataImportCategoryList = > >> >> >>> delegator.findByPrimaryKey("DataImportCategory", > >> >> >>> UtilMisc.toMap("productCategoryId", productCategoryId)); > >> >> >>> > >> >> >>> if(DataImportCategoryList != null){ > >> >> >>> String categoryId = > >> >> >>> DataImportCategoryList.getString("productCategoryId"); > >> >> >>> if(categoryId.equals(productCategoryId)){ > >> >> >>> failCount++; > >> >> >>> } > >> >> >>> }else { > >> >> >>> GenericValue newImportCategory = > >> >> >>> delegator.makeValue("DataImportCategory", null); > >> >> >>> > >> >> >>> newImportCategory.set("productCategoryId", > >> >> >>> productCategoryId.trim()); > >> >> >>> if(productCategoryTypeId != null && > >> >> >>> productCategoryTypeId.length() > >> >> >>> > 0){ > >> >> >>> newImportCategory.set("productCategoryTypeId", > >> >> >>> productCategoryTypeId.trim()); > >> >> >>> } else { > >> >> >>> > >> >> >>> newImportCategory.set("productCategoryTypeId", > >> "CATALOG_CATEGORY"); > >> >> >>> } > >> >> >>> if(primaryParentCategoryId != null && > >> >> >>> primaryParentCategoryId.length() > 0) > >> >> >>> newImportCategory.set("primaryParentCategoryId", > >> >> >>> primaryParentCategoryId); > >> >> >>> newImportCategory.set("categoryName", > >> categoryName.trim()); > >> >> >>> newImportCategory.set("description", description); > >> >> >>> newImportCategory.set("longDescription", > longDescription); > >> >> >>> newImportCategory.set("categoryImageUrl", catImageUrl); > >> >> >>> newImportCategory.set("linkOneImageUrl", linkImageUrl); > >> >> >>> > >> newImportCategory.set("fromDate", > >> >> >>> fromDate); > >> >> >>> try { > >> >> >>> > >> >> >>> delegator.create(newImportCategory); > >> >> >>> > >> Debug.logInfo("Successfully > >> >> >>> imported category ["+productCategoryId+" from row no "+ i+1 > +"].", > >> >> >>> module); > >> >> >>> successCount++; > >> >> >>> } catch > >> (GenericEntityException > >> >> e) > >> >> >>> { > >> >> >>> > >> >> >>> Debug.logWarning(e.getMessage(), > >> >> >>> module); > >> >> >>> } > >> >> >>> > >> >> >>> } > >> >> >>> } catch(GenericEntityException e) { > >> >> >>> Debug.logError("Exception occured :"+e.getMessage(), > >> module); > >> >> >>> } > >> >> >>> } > >> >> >>> > >> >> >>> } > >> >> >>> > >> >> >>> > >> >> >>> it create the temp file in corresponding directory but there is > no > >> >> >>> actual > >> >> >>> image at that path. > >> >> >>> > >> >> >>> So any one have any idea regarding this please suggest me. > >> >> >>> > >> >> >>> > >> >> >>> Thanks. > >> >> >>> > >> >> >>> Nalin Chandra > >> >> >>> > >> >> >> > >> >> >> -- > >> >> >> View this message in context: > >> >> >> > >> >> > >> > http://n4.nabble.com/how-to-import-data-from-excel-sheet-tp160724p585955.html > >> >> >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> >> >> > >> >> > > >> >> > > >> >> > > >> >> > >> >> -- > >> >> View this message in context: > >> >> > >> > http://n4.nabble.com/how-to-import-data-from-excel-sheet-tp160724p586989.html > >> >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> >> > >> > > >> > > >> > >> -- > >> View this message in context: > >> > http://n4.nabble.com/how-to-import-data-from-excel-sheet-tp160724p620283.html > >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> > > > > > > -- > View this message in context: > http://n4.nabble.com/how-to-import-data-from-excel-sheet-tp160724p620305.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
