11/25/2024 9:23:36 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general SalesLogix import and data migration topics. View the code of conduct for posting guidelines.
|
|
|
|
7.2 Import Wizard - using VBScript file
Posted: 30 Aug 07 9:18 PM
|
I am having some fun trying to learn about the new features in the IW. Actually, maybe fun is not the right word.
I wrote a function to format phone numbers in Australian format - eg
Function FormatPhone(PhoneNo)
'perform formatting here
FormatPhone = "(02) 1234 5678" (or whatever)
End Function
And created a VBS file that includes this function. Next I ticked the 'Load VBScript file for custom functions" option and selected the file, to link it into my import.
Then in my field mapping, I try to use the function on my source phone numbers (MAINPHONE) by selecting the source phone number as the 'Import data field', Conversion Function is VBScript and resulting value is
VBScript(MAINPHONE, FormatPhone).
Is this right? It is odd, because it appears to partially work - my function strips out spaces/hyphens etc and this bit works. But it then adds in commas and spaces and this bit does not - so all phone numbers are coming through as nnnnnnnnnn.
I have tested the function in a VBScript editor and in the 'Import Script Editor' using the source data and it works fine there.
Not sure what to do next? Anyone else experiencing unexpected behaviour like this?
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|