RIM 2.0 and import of Post Codes (Table 225) - Newbie

dlauwers

(New NAV Developer #-o )

Hi,

I am testing RIM 2.0 on NAV 4 to see how it works. Until know it worked great for creating a new company with some default setup. I can import customers via RIM (Excel sheet) with no problems.

I wanted to import the Postcodes from Belgium, so I Exported them from the demo database to Excel. List is complete and looking OK.

Then I imported it via RIM into my new database (running on SQL) and my new company (basic setup ,Hightech XML). The import itself works 100%, I can see the data in Migration Matrix form of the RIM. No records are invalid. When I try to apply the data, NAV runs over the records until 100% and then all records are checked as invalid. The error details of each records (>2000 rec) is: Error validating field "Code".

With the same procedure I can import records into the customer table, so is there something special about the Post Code table ? Are there other tables that RIM cannot import data in ?

I tried in on Native database, into the Demo company, tried it with import of XML, Excel. Tried an Export to excel from the demo company and a direct import without changing anything into a empty database, tried importing 1 record into Postcodes, nothing. Even manualy changing 1 record by typing into the fields in the Migration Matrix, no result.

Has anybody done this before, or can help we with this ? ](*,)

Thanks
Danny

Dneal

I am having this issue too. Did you ever get it figured out?

Dneal

Savatage

if you are copying the exact table from one company to another.

such as postcode - you can try copy & paste

Dneal

Actually I'm trying to import the postal codes from another application using Excel and RIM.

I get the same error when I try this:

Error validating field "Code".


I'm thinking I could just use a dataport if I can't figure this error out.

Dneal