there are examples of imports
and different ways.
there is one that uses comma delimited files through PIO
then there is the datafile import.
you can then schedule the service to check a folder then import what it
finds and either move the file or change the extensions to something
like DONE.
==
Hi all!
I have existing data in Quickbooks, that I wish to extract and use for OFBiz. I
know this is going to take some time and a couple of steps, but I'd like to
eventually be able to import it in OFBiz without having to mess around with
files and ant commands.
Any tips, hints, pointers, lin
Hello Friends,
I was trying to import product information form excel to database using
ImportProductServices.java. I am using the same xls file given in the patch
(http://docs.ofbiz.org/display/OFBIZ/Import+Data+Using+Apache+POI+api).
It gives me the expected messages, but I do not see any data
t;;
>> > >> >> >>> HttpRequestFileUpload
>> uploadObject
>> =
>> > >> new
>> > >> >> >>> HttpRequestFileUpload();
>> > >> >> >>>
>> > >>
HttpRequestFileUpload
>> uploadObject
>> =
>> > >> new
>> > >> >> >>> HttpRequestFileUpload();
>> > >> >> >>>
>> > >> >> >>> uploadObject.setOverrideFilename(defaultFileName);
>
;> >> >>> uploadObject.doUpload(request);
> > >> >> >>>
> > >> >> >>> }catch(IOException e){
> > >> >> >>> Debug.logInfo("Image uplo
0) {
> >> >> >>> if
> >> >> >>> (categoryImageFileName.lastIndexOf(".")
> >> >> >>> > 0 && categoryImageFileName.lastIndexOf(".") <
> >> >> >>> categoryIm
// end of upload image
>>>>
>>>> Timestamp fromDate = UtilDateTime.nowTimestamp();
>>>> GenericDelegator delegator = (GenericDelegator)
>>>> request.getAttribute("delegator");
>&g
filenameToUse +=
>> >> >>>
>> >>
>> categoryImageFileName.substring(categoryImageFileName.lastIndexOf("."));
>> >> >>> } else {
>> >> >>>
acterEncoding);
> >> >>> }catch(Exception e){
> >> >>> System.out.println("Incoding
> >> Problem");
> >> >>>
+ filePathPrefix, defaultFileName);
>> >>> File file1 = new
>> >>> File(imageServerPath
>> >>> + "/" + filePathPrefix, filenameToUse);
>> >>> try {
>
rimaryKey("DataImportCategory",
>>> UtilMisc.toMap("productCategoryId", productCategoryId));
>>>
>>> if(DataImportCategoryList != null){
>>> String categoryId =
>>> DataImportCategoryList.get
file.renameTo(file1);
> >>> } catch(Exception e) {
> >>> e.printStackTrace();
> >>> }
> >>> }
> >>>
>> delegator.findByPrimaryKey("DataImportCategory",
>>> UtilMisc.toMap("productCategoryId", productCategoryId));
>>>
>>> if(DataImportCategoryList != null){
>>> String ca
ug.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.
ntCategoryId);
> 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.
and Update to ofbiz trunk after release 4.0 lets you pass a URL to the
service and it will import, size the images and put one for each size in
the correct folder.
you can see this work but going to the product content page and paste a
URL in the upload box
glad you found a solution.
Nalin Chand
;> 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
>>
>>
>
> --
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> Systems Integrator.
>
>
>
--
View this message in context:
http://n4.nabble.com/how-to-import-data-from-excel-sheet-tp160724p277368.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Ok the way to upload changes with out a form.
First understand that in the form way the image is uploaded into server
memory, from your desktop, then you read the data from the server memory
and put it into a file. This is a function of the webbrowser not ofbiz.
The problem is that a server can not
ImportCategory.set("primaryParentCategoryId",
> primaryParentCategoryId);
> newImportCategory.set("categoryName", categoryName.trim());
> newImportCategory.set("description", description);
> newImportCategory.set("longDescription",
images, that are displayed are stored physically at
/framework/images/webapp/images/catalog
/frameework/images/webapp/images/products/large
/framework/images/webapp/images/products/medium
/framework/images/webapp/images/products/small
/framework/images/webapp/images/products/additional
the last on
Date",
fromDate);
try {
delegator.create(newImportCategory);
Debug.logInfo("Successfully
imported category ["+productCategoryId+" from row no "+ i+1 +"].
I'm not sure of what you are looking for. If it's only that you are stuck because of foreign key constraints you may have a look at
https://localhost:8443/webtools/control/view/checkdb
Jacques
From: "salmant" <[EMAIL PROTECTED]>
Is there an easy way to import a xml data file into Ofbiz databas
I would suggest you look at the demo data for sequences
you may use the webtools imports and disable the FK's or use dummy ones
salmant sent the following on 5/30/2008 8:50 AM:
> Is there an easy way to import a xml data file into Ofbiz database
> which cares about foreign key constraints ?
>
Is there an easy way to import a xml data file into Ofbiz database
which cares about foreign key constraints ?
How to determine the order of xml entities-records in the import file ?
Thank you all for your replies
; Hope that helps.
>
> If you agree, I will review and put a link from
> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
>
> Jacques
>
>
--
View this message in context:
http://www.nabble.com/Import-Data-tp16087500p16211792.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
From: "Ritz123" <[EMAIL PROTECTED]>
I have mentioned a few things that I learned and thought would be useful to
others about Ofbiz entities and in general at ritesht.blogspot.com
Hope that helps.
If you agree, I will review and put a link from
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-
this message in context:
http://www.nabble.com/Import-Data-tp16087500p16184992.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
ip
> >
> > -Original Message-
> > From: Brajesh Patel [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, March 16, 2008 11:08 PM
> > To: user@ofbiz.apache.org
> > Subject: Re: Import Data
> >
> >
> > hi Grahame,
> >
> > In web
mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 11:08 PM
To: user@ofbiz.apache.org
Subject: Re: Import Data
hi Grahame,
In web tools there's a section for Entity XML Tools for
importing and exporting data from files. For importing data from files
you can use "XML Data Impo
to
do. For a one off, I think the Access tools are a better choice.
Quickbooks has a developers toolset that can help you.
Skip
-Original Message-
From: Brajesh Patel [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 11:08 PM
To: user@ofbiz.apache.org
Subject: Re: Import Data
hi
hi Grahame,
In web tools there's a section for Entity XML Tools for
importing and exporting data from files. For importing data from files
you can use "XML Data Import" option. Here you'll have to specify the
absolute path of the data file and check the options as per
your requirements (we'v
Hi,
Being a noob I am just wondering how to import existing data into the
application.
I have an existing product/pricelist, the sales guys are using Goldmine
and accounts are using Quickbooks.
Initially I want to be using the pricelist ASAP.
I have the svn trunk checked out and running.
Ma
33 matches
Mail list logo