What is the best way to import a list of customers with their information into Navision (4.0 SP3)?
I need to check if they already exist first by their Business Name OR Phone so that no existing customers are overwritten.
RIM is out of the question - I've had problems and I don't trust it.
So a DATAPORT is what I would want to do but how do I check to see if they exist first by their Business Name OR Phone?
Thanks.
Half-empy or half-full how do you view your database?
Thanks.
0
Comments
The code shouldn't be too hard just search for any existing record and update as required or insert a new one.
Epimatic Corp.
http://www.epimatic.com
vCustNo
vCustName
vCustPhoneNo
Etc etc
If you were going to compare phone numbers, unless you are totally sure that all phone numbers are entered the same i would clean them up before comparing
(meaning) is it like xxx-xxx-xxxx or are some (xxx)xxx-xxxx, etc
you are also going to need a get or find
ex/
There is an autoreplace option you can set to "No" but I am assuming you are auto gererating new Customer Numbers so there is no way you know if they will match anything?????
http://www.BiloBeauty.com
http://www.autismspeaks.org
Wow that technique to clean up text strings with the double Delchr function calls in it is brilliant. Simple & functional...and I don't think i've ever seen that programming pattern before.
Very useful!
Epimatic Corp.
http://www.epimatic.com
as seen here http://www.mibuso.com/forum/viewtopic.php?t=14879
You'd be surprized how many code gems are out there in these posts. That's why I try to read them all, even if they don't apply to a need of mine. You never know what tip you will find.
http://www.BiloBeauty.com
http://www.autismspeaks.org
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
I almost forgot all those evenings I would relax with a glass of wine and a thorough read of the VAT codeunits.
Did you try codeunit 80? It's got a nice plot
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
#-o Thank you.
Thanks.