CiviCRM Community Forums (archive)

I'm importing some 300 member records, using the Contact ID from an earlier import. I've cleaned the data well and get clearance on step 3 of the member import process (no rows reporting errors), but when I do the final step, the system produces a non-recoverable error, with this message:

One of parameters (value: 0) is not of the type Timestamp

Any suggestions for troubleshooting?

Thanks in advance.

HI - you haven't listed the fields you are mapping to - i always recommend filling out a contact with all the fields - then exporting them with all fields so you can check that you are importing the right data type etc to the right field.

Hi Peter,

I'm mapping to Contact ID, to match contacts earlier imported, as well as these Membership fields:

  * Membership Start Date
  * Membership Expiration Date
  * Join Date
  * Membership Type

as well as these custom data fields:

  * Membership Notes (text)
  * Magazine Subscription (yes or no)
  * Three fields for three past years of past check numbers (integer)
  * Three fields for three past years of check amounts (money)
  * Three fields for three past years of transaction dates (date)

We need to keep these past three years of data as a non-profit.

When I run the import, it imports one member for the regular membership fields, using the Contact ID to pull in the name and link it to the contact. But all of the custom data fields for this one member are blank, and no other members are imported. So I know it's somewhere in the custom data fields.

I read on another forum post that blank values for custom data fields will generate this same error warning (though this was supposed to be fixed in an earlier version), so I filled blank cells of the CSV with zeros, and placed a 1991 date for the empty date fields.

I plan to try importing all fields *without* the custom data to rule out other possibilities, but I was wondering if others had any insight into this problem. Any help would be greatly appreciated.

At any rate, I left out the past three year date and the Yes/No field, and I was able to import all of the members except two, so I think I scored a victory of sorts. I'd still like to get those dates and the yes/no in the database though, without having to retype.

Well, that victory was short-lived. I was able to import 304 of the records, but none of them had the correct dates for the given Membership date fields. I found some hard returns in the custom "Memberhship Notes" field (text) of the CSV file, but even after eliminating them, I'm getting the same problem. I'm matching up the fields correctly, I'm just have some problem with the import reading the data wrong.

Have you done this? If you have you will know if it requires 0/1 or Yes/No

Peter,

Thanks for responding so quickly. No, I haven't done it yet, but that's my next step. I see the wisdom of your suggestion.

Are you importing the Contacts http://drupal.demo.civicrm.org/civicrm/import?reset=1 and then importing the Memberships separately via http://drupal.demo.civicrm.org/civicrm/member/import?reset=1?

Yes, I first imported Contacts, then exported back out to grab the Contact IDs. Copied those over to the Membership import CSV after matching line-by-line by name across the Contact export and Membership import files. This process, by the way, isn't covered in most of the documentation that I've seen.

Have you read the chapter in the Manual - http://en.flossmanuals.net/CiviCRM/ContactsAddingAndImporting

Yep. Great manual, but it doesn't cover importing memberships, only contacts.

It sounds like you may be sidestepping the core functions of CiviMember and CiviContribute if you are importing the following as Custom Data

* Three fields for three past years of past check numbers (integer)
  * Three fields for three past years of check amounts (money)
  * Three fields for three past years of transaction dates (date)

I know that the Membership module's core functions track amounts, check numbers, and dates, but I thought these functions covered only currents years. If that's untrue, it's not at all clear to me how to import *past* years of this data into the core function. If you've got any suggestions, I'd be very grateful for your advice.

BTW, I teach technical communication at the university level and would be willing to contribute to the online documentation after I've worked through this process. So if you help me out, I'll feed the results back to the community.

Thanks.

I've been having the same problem as honeyl: I can import contacts (custom fields and all) but then when I import memberships through CiviMember everything looks fine until I click "Import Now >>" on Step 3 of 4.

At that point the aforementioned  screen appears:


Sorry. A non-recoverable error has occurred.

One of parameters (value: 0) is not of the type Timestamp

Return to home page.


I've discovered that the first contact always gets their member info correctly imported, and if I try again it will be imported again, but it never works for any of the others no matter how many I try to import at once. I checked and this even happens if I only try to upload one member at a time - I get the error message but that member's info gets added nonetheless.

As it stands I'm prepared to just enter everyone manually because it might actually take less time, as this first happened a month ago, and I waited for the new Civi release to see if it would be resolved but to no avail.

Any help will be muchly appreciated, thanks
Craig

can you reproduce this error on demo. If so can you please give us steps to reproduce it and also attach a small version of the csv file you used to do so

thanx

lobo

can u do your import with a minimal set of just the core fields and see if its still an issue? that way we can isolate it to core field or custom field issues

also seems like there might be an issue with some of your date formats (from the osbscure error message), so i would take another look at the dates

lobo