04-12-2010 10:08 PM
I am Using ACT! by Sage Premium 2009 (11.0) Version 22.214.171.124, Hotfix 1 and trying to import data and getting ?? random ?? fields that do not import.
I have exported all records from ACT to fix another import issue I created earlier.
I can import the data (12K records) and it updates most of them ok.
It however misses some fields on some records.
Because I am importing the ID/Status as one of the fields I do see in the history that the IDstutus has recieved the new data but it is not shown in the record.
i.e. the history shows: Field ID/Status changed from "" to "1. Customer"
This is happenening on multiple fieilds on hundreds of records.
The mapping is picked up by the field names automatically as it is an exact export of the data prior to the change that I am trying to fix.
I have reduced the number of records in the CSV down to 3000 from 12000 and I have seen some missing fields restored, but as you would imagin I dont know if they all are being fixed.
Is this a know issue ?, is thier a certain number of records that import more reliably ? ie Max 1000 ata time ??
04-14-2010 01:37 PM
Can you find any patterns in either the values that are not importing and/or the target records to which the import in aiming?
Have you searched the knowledgebase at Help.Act.com? There are numerous differing things somewhat similar in the KB articles...