Developer forum

Forum » Integration » Assortments with integration

Assortments with integration

E-mail notifications
Anders Ebdrup
Reply
Posted on 02/03/2015 09:58:18

Hi DW,

 

I have an issue regarding handling assortments with an integration solution, because users are imported from the ERP system and so are the assortments, but the assortments require a reference to the UserID, which is only handled in DW and not in the ERP system, where the assortments are setup.

Is there a way to handle this without having to write my own DestinationProvider?

 

Best regards, Anders


Replies

 
Nicolai Høeg Pedersen
Posted on 02/03/2015 17:04:35
Reply

Hi Anders

Currently not. You could export to a custom table which users have access to which assortments and run a piece of code that would map the right IDs when a URL are called or by adding a step to your integration pipeline...

Nicolai

 
Jonas Krarup Dam
Posted on 03/03/2015 08:42:52
Reply
This post has been marked as an answer

Hi Anders (and Nicolai),

That is not entirely true - if you use the EcomProvider as destination, the EcomAssortmentPermissions table has a "virtual" column called "AssortmentPermissionUserNumber", which can be used instead of the userID column.

If you need this column to be added to the DynamicwebProvider as well, we can probably be convinced that this is a good idea.

/Jonas

Votes for this answer: 1
 
Nicolai Høeg Pedersen
Posted on 03/03/2015 08:49:00
Reply

Anders - I was hacked by evil Chinese hackers, the reason for my wrong answer. I NEVER make mistakes...!

 
Anders Ebdrup
Posted on 03/03/2015 09:01:03
Reply

Hi Jonas,

 

Thank you, that will be a very nice add-on to the current functionality, thank you agian! :-)

And Nicolai: sure thing, I know exactly what you mean! smiley

 

Best regards, Anders

 
Anders Ebdrup
Posted on 11/04/2015 14:02:38
Reply

Hi Jonas,

 

Did you have the time to implement this feature in the DynamicwebProvider as well? Or when can we expect this to work?

 

Best regards, Anders

 
Jonas Krarup Dam
Posted on 13/04/2015 08:27:08
Reply

Hi Anders,

It is currently planned for the 8.7 release, and it is not done yet.

If you are sitting around and waiting for it, I can probably push it into an upcomming hotfix, as it is not a major change.

 

/Jonas

 
Anders Ebdrup
Posted on 13/04/2015 09:08:11
Reply

Hi Jonas,

 

It would be great as we are working on a solution which should be ready for August.

 

Best regards, Anders

 
Jonas Krarup Dam
Posted on 13/04/2015 09:47:08
Reply

Hey,

I've added it to our sprint that starts today, so it'll be done within the next two weeks, and it will be included in the next hotfix after the item is done.

Judging by the rate we're usually putting out hotfixes, that means that it should be out within the next 2-3 weeks.

/Jonas

 
Anders Ebdrup
Posted on 27/04/2015 13:55:15
Reply

Hi Jonas,

 

Is this released yet? And this virtual column: "AssortmentPermissionUserNumber" is it the customer number that "can be passed" to this column or the user name?

 

Best regards, Anders

 
Dmitriy Benyuk
Posted on 27/04/2015 16:15:19
Reply

Hi Anders,

This was already developed in the TFS item #16887 and is available in Dynamicweb 8.6.1.5.
The new virtual column in Dynamicweb provider called "AssortmentPermissionUserNumber" is the user customer number.

Regards, Dmitrij

 
Anders Ebdrup
Posted on 27/04/2015 20:41:28
Reply

Hi Dmitrij,

 

Thank you for a quick reponse, though not the most obvious name for the customer number when think of the database.

 

Best regards, Anders

 
Nicolai Høeg Pedersen
Posted on 27/04/2015 21:47:08
Reply

Hi Anders

No it is not good naming - we saw it on sprint review today and sent it back for renaming... What happens when hotfix happens too fast...

BR Nicolai

 
Anders Ebdrup
Posted on 27/04/2015 22:04:35
Reply

Sounds good!  In which version will it be changed and what will the new name of the column be?

 
Anders Ebdrup
Posted on 19/05/2015 20:51:37
Reply

Hi,

 

Is there any news about the changed name of the column?

 

Best regards, Anders

 
Jonas Krarup Dam
Posted on 20/05/2015 10:11:02
Reply

Thank you for keeping track of us.

I had let this one slip through the cracks - but no more!

The field will be named "EcomAssortmentPermissionCustomerNumber", and it will be out in the next hotfix.

/Jonas

 

You must be logged in to post in the forum