Developer forum

Hi Nuno,

Just to clarify, before answering "how can we address the top issues":

When you write "developing an Integration Provider", does that mean that you will be coding your own provider that inherits from ours? Or do you just mean "building a new set of jobs via UI"?

Is your source file CSV or XML?

As for "creating a chain of jobs": Yes, you can. If you are using Ecom Provider we implicitly know the order of importing. So you may have one job containing import of products, groups, manufactures etc, and they will automatically be imported in proper order.

Though, if you want to split into several jobs, you may do so as well. You may call the jobrunner once, with multiple jobs to be executed. They will be executed in the order that you put them. You may use the URL builder to create the URL for executing multiple jobs.

Let me have a comment on the above.

Regards /Snedker

Hi Snedker,

We are developing our own (source) provider. We get data from a webservice that converts the ws methods into temporary tables.

Chain of imports

We are using a single Data Integration Job, so if the Ecom Provider knows what to do, that's great!

If you need, I can provide you with a link so you can give it a look.

So how about the "related" data (manufacturers, tax groups) without corresponding ID's, what's the best way to do that?

Nuno

PS: If you perform lookup on another column than the "real" key column (using isKey), you should make sure that there's no duplicate content on the given key. If multiple rows apply the value of the key, all of these will be updated.

Good morning.

Where are the job files located?

Marco

Hi Marco,

They are located in the files archive, in the folder files/integration/jobs/

Regards, Jonas

Hi Snedker and Jonas,

We will try to adapt the provider. Thanks for the important info. If we run into any other complications, we will bug you again :P

Regards,

Nuno

Hello.

I'm still having trouble with this and am not sure how to fix it, so here are some extra details, see if you can think of anything.

In our ISource I have (among other fields) the equivalent of the ProductNumber and ProductLanguageId in the EcomProducts. There are no keys in the source schema, but I am filtering the source by number and language, so to get only distinct values.

In the job mapping I am only mapping as table keys the ProductNumber, ProductLanguageId and ProductVariantId. When I run the job I get this error:

Job Failed with the following message: Failed to move data from temporary table [dbo.EcomProductsTempTableForBulkImport] to main table [dbo.EcomProducts]. Exception message: Violation of PRIMARY KEY constraint 'EcomProducts$PrimaryKey'. Cannot insert duplicate key in object 'dbo.EcomProducts'. The duplicate key value is (PROD1, LANG1, ).

Any Ideas on how to get around it in order to update/create the data already in the system?

Marco.

Hi Jonas and Morten,

Any ideas on Marco's problem? We are a bit stuck 

Nuno

Hey Marco (and Nuno)

Which provider are you using as your destination?

It sounds like it is probably the Dynamicweb Provider.

when using the dynamicweb provider, the ProductID is NOT generated automatically, if it is not included in the mapping, and you will get an error similar to the one you describe here.

The simplest solution is to map your ProductNumber to the ProductID column as well - as long as the productNumber is unique for each row, it should work just fine.

If that is not your problem, please let me know, and I'll see what else I can think of.

Regards, Jonas

Morning.

The problem has been solved. It was a mix of bugs in our source and mapping configuration. We are using the Ecom Provider, by the way.

Thanks for the help.

Marco