Server W2k3, Sugar 4.2.9c, Apache, from bitrock install, most current versions of everything.

We're importing data from Act. The Act version is 2000. The data was exported to a .csv and it's all stored as text.

There are about 10,000 custom fields - ok, it just feels like that many - about 100 custom fields. Most are either dates or checkboxes.

The dates are stored as strings, format of 12/31/05. When I run the import I get data, but it's not what I expect. For example, a date that is stored in the csv as 03/01/06 displays in the record as 01/01/2000.

For the checkboxes, the data is text format as no, No, or NO; or as yes, Yes, or YES. My custom fields are boolean (checkboxes). I can go through and massage the import file to do a substitution of 0 for no and 1 for yes, but I'm looking for a way to just make the import work.

Alternatively, even though the import option for ACT says it's the 2003 version, is that import backwards compatible to something as old as 2000?

Any suggestions on either? I think the date problem is more pressing since I *can* massage the data for the checkboxes if I have to.

TIA,
LP