Personalization, Customization and Productivity Tools

[paulsat]

I'm very in Mas90 visual integrator, and I'm attempting to
change the price of "DiscountMarkupPriceRate1" field in "IMB_PriceCode" table.
I'm getting the data from access file linked to MAS90 through ODBC,and assingning each field from access to its corresponding in MAS.After executing the job, it says : all records imported, and 0 invalid or skipped, but the problem, no new values are added or updated, and data remain same in Mas, I'm not sure what the problem is, I'll be glad if someone can help me in it,

BTW, Im able to create or update record in IM1_InventoryMasterFile, IM_04AliasItemNumber or other but IMB isnt working with me so far,

Thanks for any help

[Heather]

Welcome to the forum!

You might be trying to import into the wrong field. 

In VI, you'll see that there is Disc_Markup1 and also Disc_Mkup_Prcr1.  Try importing into the one you didn't already try & see if that works.

[BigLouie]

Try extracting the file with Access or Excel. It is possible that you did import but the data was imported in such a way that it does not show up as expected.  Also take a look at the log file and see what data it imported.

[paulsat]

Thank you for the welcome and the quick response.

I changed Disc_Markup1 to Disc_Mkup_Prcr1, but still no changes,

after checking the detail log as requested by BigLouie,

the only imported record is Price_Code_Rec  (the imported data is "2"  wich I kept it as is after extracting to Access or excel)

Validation Type is "Expression" , Validation Result is "Yes"

no other fields are imported but says skipped 0,  

so not sure what is happening,  

Thank you

[BShockley]

What version are you running?

[Heather]

And what's on the Records tab of your import job?

[paulsat]

I’m running MAS 90 (Version 4.30.0.17)

[BigLouie]

It sounds as if you did not setup the Records tab correctly. You only brought in part of the record as a result.

[paulsat]

Yes , I havent set up the Record tab, and not sure how to do it,

is there any way to find out how and what to set up, any manual or link ?

Thank you for all your helps

[Heather]

Because this one file stores multiple types of data which have different requirements, you have to tell VI how to identify your data.  You probably just look at your spreadsheet and know that a line is an Item Price Record or an Item Customer Price Record because of the 1 or 2 in column A.  But VI doesn't know that (even though you may be importing that column into the price code record field).  So you have to tell VI this and you do that on the Records Tab.

I suggest you open Import Maintenance & click on the help button in the lower right.  On the pop-up menu, Select Record Types to Import should be one of the options.  Click on that & read through it and the examples. 

You can also search the forums or check for a KB article.  But no, I don't happen to have any links.