Hi All,
I have 2 problems both to do with imports in V11.
1. Importing product images. My client has 10,000 products with images how can they import them, en masse?
2. Importing comments against objects. My client wants to import the comments that the credit control team have against outstanding invoices, when they go live.
I can find no way to do this using import templates. Someone in the world has surely done this before.
Any help gratefully received
Brian King
Hello,
1. Esfahani answered a similar question (https://sagecity.na.sage.com/support_communities/sage_erp_x3/f/sage-x3-general-discussion-forum/102656/import-images-via-web-services):
1.1 Create your own import template (duplicate the standard and add the letter "Z" as a prefix, for example)
1.2 Specify a specific source/code to be executed and add the image path field as *1 in the template
1.3. Use the following code:
$ACTION
Case ACTION
When "IMPORT" : Gosub IMPORT
Endcase
Return
$IMPORT
Case IMPFIC
When "ITM" :
If GIMP(1)<>""
Openi GIMP(1)
Getseq 1,[M:ITM1]IMG
Openi
Endif
Endcase
Return
This is just an example. You can copy the images to the folder's tmp volume with the format <ITMREF.jpg> and replace GIMP(1) with filpath("tmp","","")+"\"+[F:ITM]ITMREF+".jpg" without having to specify the image path in the file to be imported.
---------
About 2.:
Comments are stored in the table ACLOB and are associated with the object + document id. You can extract the data and store it in a simple specific object for consultation (maybe add the invoice business partner to allow some filtering). If the invoices are going to be imported, then you can simply extract from the old database and map the records to the new documents.
Hello,
1. Esfahani answered a similar question (https://sagecity.na.sage.com/support_communities/sage_erp_x3/f/sage-x3-general-discussion-forum/102656/import-images-via-web-services):
1.1 Create your own import template (duplicate the standard and add the letter "Z" as a prefix, for example)
1.2 Specify a specific source/code to be executed and add the image path field as *1 in the template
1.3. Use the following code:
$ACTION
Case ACTION
When "IMPORT" : Gosub IMPORT
Endcase
Return
$IMPORT
Case IMPFIC
When "ITM" :
If GIMP(1)<>""
Openi GIMP(1)
Getseq 1,[M:ITM1]IMG
Openi
Endif
Endcase
Return
This is just an example. You can copy the images to the folder's tmp volume with the format <ITMREF.jpg> and replace GIMP(1) with filpath("tmp","","")+"\"+[F:ITM]ITMREF+".jpg" without having to specify the image path in the file to be imported.
---------
About 2.:
Comments are stored in the table ACLOB and are associated with the object + document id. You can extract the data and store it in a simple specific object for consultation (maybe add the invoice business partner to allow some filtering). If the invoices are going to be imported, then you can simply extract from the old database and map the records to the new documents.
