How expand the Description in Tables.

kiLL

Hi,

I have a Item list from my Client and I have a problem of the "Item description",bec. they are too long to insert to NAV Item Description. Is there a safe to Expand the LEght of Item Descrption in NAV with out affecting other module.Hope you can help me. THNKS

vaibhav_soul

kiLL wrote:

Hi,

I have a Item list from my Client and I have a problem of the "Item description",bec. they are too long to insert to NAV Item Description. Is there a safe to Expand the LEght of Item Descrption in NAV with out affecting other module.Hope you can help me. THNKS

In simple terms - "Never do it!"

It would lead to a series of miseries once you change the length.

kiLL

Ok, but you have any suggestion what I can do? THANKS

vaibhav_soul

I guess you would have to lessen the length of string before inserting to the maximum length that NAV accepts. So, you use COPYSTR or something before you try to insert/validate the item description.

kiLL

Ok, I think ,I have No choice but to cut the lenght :? , before Inserting in to NAV.THANKS very much for your suggestion.

ssingla

If the description is too lengthy, you can split it in 30 characters each for description and description 2 and then import. Excel can do splitting easily. For report you can use both together. You can also use Extended Text functionality.

The issue has been discussed on the forun many times. search and you might find the solution which works your way.

DenSter

What I would do is add a field with the right length and call it "Legacy Description". Just import the values in there, so you can always decide to change it up later, without having to redo the migration.

Then, as stated before, you can use the existing Description and Description 2 fields. For additional space you should really consider adding new fields.

Savatage

We import many lengthy Item descriptions for new items.

I create a variable in the dataport to accept the large name (mydescription) and then break it up to fit into Desc1 & 2
OnAfterImportRecord()

Item.Description := UPPERCASE(COPYSTR(mydescription, 1, 30));
Item."Description 2" := UPPERCASE(COPYSTR(mydescription,31,30));

*Uppercase Optional