Cb Juice doesn't import a field

7 years 4 months ago #194207 by d4rkcloud
Hi guys,


i created a csv with some fields, everythins is all right, except for a date field...
In attachments the files of an user exported and the file to import.


Thank you all, guys! :lol:
7 years 4 months ago #194208 by jciconsult
You probably worked with the field in a spreadsheet. The field must be formatted to suit the date specification on your server and in mysql. Usually dashes are involved. Try exporting the field to see what your server wants but look at it using a text editor NOT EXCEL or LibreOffice.
7 years 4 months ago #194209 by d4rkcloud
ok, maybe i understood it.
In the original file the years are "75", in the import files are "1975".
What should i change in the field to fix it?


Thanks very much for the answer! :lol:
7 years 4 months ago #194210 by jciconsult
Date fields are stored in an internal representation. You must supply the dates as text so they can be interpreted correctly. On output in reports, you can do what you wish in terms of formatting.
The following user(s) said Thank You: d4rkcloud
7 years 4 months ago #194211 by d4rkcloud
ok, what should i do to have a reports or to have the data like a test?

Sorry, but i'm a real jackass... :whistle:
7 years 4 months ago #194217 by jciconsult
Make a CB list and use that to display the date associated with the user using a menu item.
To see how it is store, just do a save of your cb data using the cbjuice save option
Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.381 seconds
Facebook Twitter Google LinkedIn