Home
Login
Sign Up
Profile Options
Tools
Edit Profile
Manage all aspects of your profile here including demographics, emails, notification settings, etc...
Change Password
Begin the password change process
Email Subscriptions
Manage your opt-in/opt-out email subscriptions
View Profile
View your profile - what other's see
Sign-out
Sign out of this community
1-800-819-1190
Contact support line
Smart Connect
Connect with others and manage various member options
View QR Code
View your profile QR Code - Connect and or share your contact information
Tour Page
Take an interactive tour of this page
Knowledge Base
Visit the knowledge base for more info
Insights
Member reporting and analysis
Terms of Use
Cookies
Privacy Policy
Contact Us
Help
 
 

Site Menu

Forum | Message
Load Item Text Using SQL Insert and update
Sam Haidar *MUGA
BC:

Question:

Article:

Load Item Text Using SQL Insert and update

Categorized as:

master data
M3
Test Category Technical

This maybe a bit confusing, please hang in there. I am trying to migrate Item Master records from one M3 to another. Lots of those records have text. So, I loaded the Header text in MSYTXH and text lines in MSYTXL based on the last TXID on those tables. Lastly, I updated the MITMAS/MMTXID accordingly in the Item Master for each Item number. The problem I am having is when I open the Item in MMS001, it shows that it has text (Paper Clip on the text icon) but I also see an Exclamation Mark  Read more...on the Action menu. When I open text, it is empty. When I step out of text, the Paper clip is gone. When I check the tables after that, MMTXID is 0, MSYTXH record is gone and MSYTXL are still there.  Show less...
Delivered Read
master data
M3
Test Category Technical
Group: *MUGA
2
36
Latest msg: Jeremy, Thank you for your response. I didn't know that there is an API for Text. I was looking under MMS200MI. I am doing most of the Text Load us... from Sam Haidar, on 02/21/2025

Comments (2) (Descending Chronological Order)
There are no comments at this time, be the first to comment

Sam Haidar
BC:
Jeremy, Thank you for your response. I didn't know that there is an API for Text. I was looking under MMS200MI. I am doing most of the Text Load using SQL Inserts. But 10 minutes before I opened your response, I figured out what the problem is. It was a stupid typo where I was loading MSYTXH with company 001 and MSYTXL with company 100. Sorry for wasting everyone's time. Appreciate your help.
Jeremy Bull
BC:
Sam, I've run into the same issue but I still can't tell you exactly what the fix is. I believe it's something along the lines of you trying to inherit a TXID that was copied from another environment, but by opening the text block in the new environment, M3 is generating a new TXID anyway (or resetting it to 0 as you haven't actually created any input to save). Attached are my instructions for doing what you're after. If I were you, I would be generating fresh TXIDs in the new environment,  Read more...tying those to the MMS001 records, then loading text. Show less...
M3 API to add text to MMS001.docx
2

Online