Skip to main content
Solved

Excel Migration - Error when updating custom field / custom page

  • December 6, 2021
  • 7 replies
  • 360 views
S
Sidekick (Partner)
Forum|alt.badge.img+4

Hello everyone, 

I’m trying to update a custom field on a standard logical unit (part catalog), but this custom field is issued from a custom page. 

My Custom field is “Sous-Catégorie”

 

And this custom field is linked to a custom page with two choices

 

Here are the settings from my excel migration :

 

 

 

I think it follows well the excel migration guideline. But I have an error when I want to update the custom fiel in Excel (by entering a value from the previous custom page)

 

 

 

An idea oh what’s wrong with this ? 

 

I’m able to update custom field with a simple text, but impossible to update a custom field linked to a custom LU or to a custom list (or enumeration ?!)

 

Wishing you a great day :)

Best answer by sfaure

Hi Technical Outlaws, finally, I got it ! 

When I created my migration task for my custom list of value, the column I entered was CF$_CATEGORIE. In fact, for a correct update, I need to enter the “DB” column : CF$_CATEGORIE_DB

With the following settings, my excel add in and update works fine !

The only question that remains (but I thinks it needs a new topic) is : How modify the name of a DB value when it’s a custom list ?

 

 

 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

S
Sidekick (Partner)
Forum|alt.badge.img+4
  • sfaure
  • Sidekick (Partner)
  • December 7, 2021

Any Suggestion ? :blush:

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

I believe you are missing the method list attribute setup against step 20 in your method list.

 

 

S
1 person likes this
  • S
    sfaure
S
Sidekick (Partner)
Forum|alt.badge.img+4
  • sfaure
  • Sidekick (Partner)
  • December 8, 2021

Hello Technical Outlaws,

Thanks for your answer.

You’re right, I missed this setup.

 

Now, it’s done :

 

But the error still exist when I want to update this custom field (from a custom LU!)…

 

 

 

 

 

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

When you manually select a value for the sous-catégorie custom field against a part, have a look at the part_catalog_cft, what is the actual value that you see in the sous-catégorie column of the CFT table?

 

The clue is there.

S
Sidekick (Partner)
Forum|alt.badge.img+4
  • sfaure
  • Sidekick (Partner)
  • December 15, 2021

 

Hi Technical Outlaws :) 

 

Not sure to understand your advice. 

I try to update with the CF$_SOUS_CATEGORIE_DB and not the CF$_SOUS_CATEGORIE, but same result…

 

 

 

 

If I manually select a value :

 

And If I look to my custom field and logical unit :

 

 

I admit I’m a little confused

S
Sidekick (Partner)
Forum|alt.badge.img+4
  • sfaure
  • Sidekick (Partner)
  • December 20, 2021

Hi Technical Outlaws, finally, I got it ! 

When I created my migration task for my custom list of value, the column I entered was CF$_CATEGORIE. In fact, for a correct update, I need to enter the “DB” column : CF$_CATEGORIE_DB

With the following settings, my excel add in and update works fine !

The only question that remains (but I thinks it needs a new topic) is : How modify the name of a DB value when it’s a custom list ?

 

 

 

 

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

Well done!  I knew you would figure out the answer eventually, you were this close.

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings