vi-solutions
Software + Internet

Joomla 5 Notice

We are pleased to announce that as of October 14, 2025, all of our Joomla extensions are compatible with Joomla 6.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5 and 6!

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

Data export - date field integer instead of date type

More
4 days 17 hours ago #11926 by ot2sen
Data export - date field integer instead of date type was created by ot2sen
An export of data to CVS to excel changed the date field values from 01122025 to 1122025. Leading zero was removed from the CVS to Excel import.
But I can see it is read as {"Dato", Int64.Type}, and using the transform of the Datatype from Integer to Date solves the issue. {"Dato", type date},

Question is if the type is wrong in the data export from Visform or did I miss a setting of the field?

Cheers
Ole

More
4 days 16 hours ago #11927 by Administrator AV
Replied by Administrator AV on topic Data export - date field integer instead of date type
Dear Ole,

csv files do not contain any information about the data type.
They are simply text files in a specified format.

It is Excels import routine, that interprets the values and determins which Datatype is used for which column.

In Visforms fields of type date support three different date formats.

DD.MM.YYYY
MM/DD/YYYY
YYYY-MM-DD

Values for a date field are exported with exactly this format into CSV.
So in the csv file it would either be 01.12.2025, 12/01/2025 or 2025-12-01.
Excel determins for all three formats correctly, that the Datatype is a date.

So I really wonder, why your field values are without ./-
But if a date value is not formatted with ./-, then the value acually just is an integer with a leading zero.
And Excel will allways determine, that the Datatype is int64.

Which date format did you select for the field in question?
I need to know, so, that I can check into the export of exactly that format.

Regards,
Aicha
:idea: I recommend you the new and up-to-date documentation for Joomla 5:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 4.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 5:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 4.
Bitte immer nur 1 Frage pro Thema stellen :-).

More
4 days 15 hours ago #11928 by ot2sen
Replied by ot2sen on topic Data export - date field integer instead of date type
Thanks Aicha

Actually I can see in the CSV file that the values are correct 01.12.2025 as they are in the database and frontend.
No need to check further. It must an Excel data import issue I guess and can be solved by adding that extra transform step for type. :)
The following user(s) said Thank You: Administrator AV

Moderators: Administrator AV, Administrator IV
Powered by Kunena Forum

Visforms Subscription

Visforms Extensions

Useful extensions for Visforms which enable you to integrate your forms perfectly into your website and to perform special tasks which turn Visforms into much more than just a form generator.

Info