Cb Juice doesn't import a field

12 years 2 weeks ago #194207 by d4rkcloud
Cb Juice doesn't import a field was created 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:

Please Log in to join the conversation.

12 years 2 weeks ago #194208 by jciconsult
Replied by jciconsult on topic Re: Cb Juice doesn't import a field
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.

Please Log in to join the conversation.

12 years 2 weeks ago #194209 by d4rkcloud
Replied by d4rkcloud on topic Re: Cb Juice doesn't import a field
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:

Please Log in to join the conversation.

12 years 2 weeks ago #194210 by jciconsult
Replied by jciconsult on topic Re: Cb Juice doesn't import a field
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

Please Log in to join the conversation.

12 years 2 weeks ago #194211 by d4rkcloud
Replied by d4rkcloud on topic Re: Cb Juice doesn't import a field
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:

Please Log in to join the conversation.

12 years 2 weeks ago #194217 by jciconsult
Replied by jciconsult on topic Re: Cb Juice doesn't import a field
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

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.182 seconds

Facebook Twitter LinkedIn