TI Import Control File Help

(0) Share

Report

Posted on by Community Member

I currently use Dynamics SL 2015 and I am trying to update some fields in Inventory Items using TI import. The control file I have changes cclassid and cGLClassid. However, our system has a system message pop up when these two fields are changed with a "Yes" or "No" button to press. How do I tell my control file to press the "Yes" button on a pop up system message?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Butch Adams 4,763 on at

Like (0)

Report
I'm on the finishing up side of a project of several hours of inventory work with TI. I didn't run into the popup even though changing the classid was one of the steps.

Were you using the simple or intelligent control file? I also wonder if you just used "InventoryItem" for the level indicator or "InventoryItem,Change"

Here is what one item in my .dta looked like:

"InventoryItem,Change",100002693-Pan ,100002693-Pan (185 Gallon Alum. Tank Brown Box-65L x 28W x 24H),QB,,,,,,,,,,,EXEMPT,AC,,,EA,EA,EA,"1,634.64",,,,,,,817.32,,,,,,,,,,,,,,,,,,,,,,,,,,,,,PP,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,R,F,,,,,E "CompanyDefaults,Change",WHSE1,SHELF1,SHELF1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm using an intelligent control file and I believe I am just using "InventoryItem" for the level indicator. This is from my control file:

call AliasConstant( "Level0", "InventoryItem" )

call AliasConstant( "Level1", "CompanyDefaults" )

Can I change the level indicator by updating Level0 to "InventoryItem, Change"?

Was this reply helpful? Yes No
Apps Mexico 1,090 on at

Like (0)

Report

In situations like that, I prefer the SQL way. Look with the sql profile all the validations that SL does when you change that fields and can create a store procedure to do that. I have created many stores for multiple process, on that way without issues.

Was this reply helpful? Yes No
Butch Adams 4,763 on at

Like (0)

Report

Yeah, replace the level0 stuff to the "InventoryItem,Change" like my example and see if that works for you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried changing it to "InventoryItem,Change" but received the same error messages. After some more searching I found a work around where I could edit my messages.csv file to not require that system message to be answered. I was able to run my import without any errors after that. I will just use that method going forward. Thanks for the help.

Was this reply helpful? Yes No