Hi,
I am trying to import the phone log into a view with unique Numbers Dialed and consolidate the information in 1 document per dialled number:
Excel:
=====
NumberDialled Date Hour Duration Cost
35929355132 2006-11-29 12:09:26 00:00:27 0.10
35929355132 2006-11-29 16:06:49 00:00:19 0.10
35929355132 2006-11-30 09:30:20 00:00:36 0.12
<br/>
Notes DB:
========
NumberDialled: 35929355132
Date (Multiple values): 2006-11-29, 2006-11-29, 2006-11-30
Hour (Multiple values): 12:09:26; 16:06:49; 09:30:20
Duration (Multiple values): 00:00:27; 00:00:19; 00:00:36
Cost (Multiple values): 0.10; 0.10; 0.12
Total: 0.32
NoOfCalls: 3
The problem is that the view is not updated after each imported line and new documents are created instead of updating the existing.
Any idea for a workarround?
Cheers,
Puhn