Has anyone successfully used the SYNCDETAILS Rule in a Migration Job?
I made the header fields in my file the same what shows in to “Column Name” in File Mapping but when I unpack the file I get Column “xxxx” does not exist.
I am using a csv with double quotes as the Column Embrace and would expect this to apply to the headings as well.
Question
Data Migration SYNCDETAILS Rule
+1
+22CherylLaus wrote:
Has anyone successfully used the SYNCDETAILS Rule in a Migration Job?
I made the header fields in my file the same what shows in to “Column Name” in File Mapping but when I unpack the file I get Column “xxxx” does not exist.
I am using a csv with double quotes as the Column Embrace and would expect this to apply to the headings as well.
Hi
Check if you have the Rule value as MATCH for the SYNCDETAILS rule?. If you have it, remove it and load the file again and unpack to see which column was not mapped properly.
Cheers!
Damith
+1I found out the issue was the utility creating the file puts double quotes around the fields in the header line - as I would expect since it’s just a csv file.
It appears the SYNCDETAILS does not remove the column embrace around the header fields like it does the data fields. I had to manually “correct” the header line and it worked once the double quotes were removed.
So we’ve decided not to use SYNCDETAILS and go with the sequencing of fields instead.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.