[Resolved] User custom field export/import.

[Author]

Posts

[benC-15]

Tell us what you are trying to do?
We wanted to import user data. One custom field that we want to populate has a date field type. When we tried to import, the date 2022/01/01 or other date format is not acceptable. So we exported the user data to see the value of that custom field in date. It turns out that the value is in timestamp. What can we do to make the date format acceptable? It would be hard for us to convert the date to timestamp first before importing.

Is there any documentation that you are following?

Is there a similar example that we can see?

What is the link to your site?

[Minesh]

Hello. Thank you for contacting the Toolset support.

What if before you import you should change the date to timestamp and use the newly added timestamp column to import the date value:
=> hidden link

[benC-15]

Hi,

Is there a simpler way for this? I mean if we can possibly import with a date format and not in timestamp format.

[Minesh]

No, the thing is that when you create a custom date field using the Toolset Types plugin, the custom date field value is stored as Unix Timestamp to the database. That is why you will have to import the equivalent Unix Timestamp value for your date column.

[Minesh]

Please check the following Doc:
=> https://toolset.com/course-lesson/import-content-csv-importer-plugin/#importing-date-fields