Generic Adaptor
How to upload images to TOTECS using the Generic adaptor's Product Images data export when the image file path is set as a URL?
Within the Connector, when using a Generic adaptor to upload images to the TOTECS Ecommerce system using a Products data export, how can the images be uploaded if the file path is set as a URL?
For example, in Readysell's system, for it's images API endpoint, the each image record is returned as an ESDproductimages object such as json object:
{
"keyImageID": "138147-0",
"keyProductID": "138147",
"imageFullFilePath": " https://*******.example.com/api/product/523668/image",
"imageFileName": "523668",
"imageFileExtension": ".png"
}
The problem is the URI does not contain imagefile extension so when images is imported to TOTECS we using generic adaptor we obtain following error:
Product image: image. could not be exported since its file extension is not jpg, gif or png.
Trying to add file extension in URL as as parameter of the uRL such as concatenation of "?1="keyImageID,imageFileExtension)
We obtain error:
Product image: image?1=144701-0.png Unable to read and resize image. Error: Illegal characters in path
Is there a way to upload those url images in TOTECS?
Unable to import product description data from a CSV file into SQUIZZ connector dataset.
SQUIZZ Connector is throwing an error message when importing product description data into connector dataset from a CSV file. "File could not be parsed. "
Querying attribute data from another connector using HTTP-Ecommerce Standard Document
One connector is querying attributes data from another connector application using HTTP-Ecommerce Standard Document. The data export of attribute data is failing Here are the settings: An adaptor from connector application located in Server A query make model data. A dedicated generic adaptor queries the Make Model database application via an ODBC link. Following export are configured for attributes data: -Attribute profile -Attribute profile attributes -Attribute profile product values Other configured exports are: -Maker model mapping attribute -Maker model attribute -Makers -Maker models - Maker model mapping An adaptor from connector application located in server B query the above adaptor (server A) using HTTP-Ecommerce Standard Document In this adaptor, we have set up the Endpoint “product_attributes” against export Attribute profile. This export fails with following log: Connector B Unable to export Export Product Attributes data since an unexpected error occurred. Adaptor Name: Make Model Adaptor Error: Object reference not set to an instance of an object. There is no Error log in server A Question: How should we configure the attributes data export?
What are the recommended data export settings to be able to connect the Generic adaptor to the TOTECS Make/Model Parts Database application?
Within the Connector if a Generic adaptor is to be used to export data from the TOTECS Make/Model Parts Database application's MySQL database, what are the settings and field mappings that need to be set for each of the Make/Model data exports?
How to export products from a Data Set that are active or are product combination parents with the Generic adaptor
A question was asked if there's the ability to configure the Generic adaptor's Products data export to export Product records from a Data Set that are active, or are marked as inactive but set as the parent product of a combination. This typically occurs when inventoried products are exported from an accounting/ERP system and imported into a Data Set that contains parent combination products that don't exist in the accounting/ERP.
How is the total tax determined when an invoice is imported into TOTECS through a generic adapter?
When creating a customer accounts record invoices export in the Connectors generic adapter, how is the total tax on the invoice determined when it is imported into TOTECS?
Error when exporting multiple images for the same product via Generic Adapter
If a Generic adaptor within the Connector has a Product Images data export configured to upload product images to a TOTECS project,
when multiple images are being located for the same product the connector is giving me an error saying that i have multiple entries for the same "product ID".
How do I configure the Connector to allow both images to be uploaded for the same product?
keyImageID, keyProductID, Description, title, imageFullFilePath
BZ-1000, 2687, Contact Juggling Ball, Contact Juggling Ball, C:UsershackrDesktopImage_syncExportimgBZ-1000.png
BZ-1000A, 2687, Contact Juggling Ball, Contact Juggling Ball, C:UsershackrDesktopImage_syncExportimgBZ-1000A.png
Field lengths sending data via Generic Adapter
Hi,
Is there any documentation on maximum field lengths for data sent via the generic adapter?
Currently the routine will fail if a field length is too long, with the following error message:
"Adaptor Name: NHTB-Generic Error: An error occurred whilst trying to upload the data. Error message: "
There is no detail to the error message. I can't find any field lengths documented in the Standards Documentation.
Timeout issue with images
On the occasional item i am receiving the following error:
Adaptor key: Image_sync Key Product ID:1690 Full image path: C:\Image_sync\Exportimg\GM-0390.png Error: The request was aborted: The request was canceled.
The image is the same size/format as others which were successfully uploaded i can manually upload the image too.
When i run it alone i receive:
This error may have been generated due to the data export taking a long time to complete. Technical Error: This request operation sent to net.pipe://localhost/squizzconnector did not receive a reply within the configured timeout (00:01:00). The time allotted to this operation may have been a portion of a longer timeout. This may be because the service is still processing the operation or because the service was unable to send a reply message. Please consider increasing the operation timeout (by casting the channel/proxy to IContextChannel and setting the OperationTimeout property) and ensure that the service is able to connect to the client.
I'm not sure as why only a few images are getting this error, when they're mostly the same size and are all the same format?
What are the illegal characters that cannot be set within the filePath data field of a Generic adaptor's Product Image data export
Can you please advise if there are any other illegal characters I need to allow for, other than the following?
Tilde (~)
Number sign (#)
Percent (%)
Ampersand (&)
Asterisk (*)
Braces ({ })
Backslash ()
Colon (:)
Angle brackets (< >)
Question mark (?)
Slash (/)
Plus sign (+)
Pipe (|)
Quotation mark (")
Thanks,
Natalie.
What is the data field that sets the outstanding balance for an invoice record in the Generic Adapter's Customer Account Record Invoices data export?
When configuring the Customer Account Record Invoices data export for a Generic adaptor within the Connector, which data field is used to display the outstanding invoice balance to denote how much is still left to pay for the invoices?
Using network share directory with generic adapter
I have set up a successful image sync test using the generic adapter on the computer that hosts the adapter, i did so by placing an image and CSV in a single folder and running the connector. Our image database is hosted on a network share because it is to big for the host and my plan was to change the file path for the images to the network share and keep the CSV in a directory on the adapter host, however doing so causes the following error:
Skipping importing an image within the Product Image data export from the Generic1 Adaptor adaptor since its file could not be found.
I have tried hosting the files on different network drives and given "everyone" read/write access to the directory as well as "users" as suggested in the generic adapter instructions. I can connect to all the directories using the user that the adapter is run on and the image path successfully opens when put into a browser but i still cannot get it reading from the network share. Any advice on what could be wrong?
Image sync using Generic adapter
I'm looking at syncing our images folder with our totecs website using the generic adapter and a CSV ,i was wondering two things:
1. Can i get an outline of the steps involved to get an image sync operational?
2. Is there an example CSV so i can see how the data is formatted for each of the ESD fields?
Generic Adapter not exporting product data to TOTECS
I'm having an issue exporting Product data via the generic adapter to a TOTECS project. The Product Export completes with no errors, however the new product cannot be found in the TOTECS project. We have a Generic Adapter connected to a MS-SQL database. When setting up the Products Export, we mapped three fields: keyProductID, Product Code, and Barcode. The 'Test Export Query' correctly displays the data we want.
Is there something obvious I'm missing, such as not including some mandatory fields? I have a look through the docs at https://www.squizz.com/docs/connector/Adaptor-Generic-(version-1).html