11-10-2009 05:17 AM
I want to update a yes/no field using a tab seperated .txt file in Act Premium 2009 (ver 11).
I regularly update fields in Act by deleting all data in a field (e.g last order date) and importing the new data using the merge option in the import wizard. This works fine with all text/date/number fields. However this doesn't seem to work with the a yes/no field. I'm using yes ="1" and no ="0" in my .txt file.
The default value for my yes/no field is set to "0" (a default value is required). Does this mean that the field always contains some data so you can't merge into it?
Getting very frustrated!
11-10-2009 07:52 AM
11-10-2009 08:01 AM - edited 11-10-2009 08:04 AM
thanks for the response. I did try "-1". It seems to me that because a yes/no field always contains some data it is impossible to update this field with an import - can anyone at Sage confirm if this is the case? there is a work around if you import 1/0 into a user field, make a look up and use the Replace Field command to update your y/n field but it's a bit of a faff!
I do wish act was a little more user friendly for those with database admin experience...
11-10-2009 09:49 AM
Unfortunately, ACT! can only update a field if it's empty - any field.
To update fields with data, you need an add-on like itImport
11-10-2009 02:35 PM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.