Imported date not working for fields

2 weeks 5 hours ago #78764 by grabit
Hi,

I have a field where I import a date.

After the import I can see clearly the date on my items but I am not able to use the date in a filter. No date are visible in the range.

If I save the items again then the dates are taken in the filter.

Why? and how can I avoid that?

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

1 week 6 days ago #78777 by grabit
What I don't understand is that in the item I can see the imported date but it won't be used for filtering unless I save the item again.

I also created a second date field with an automatic creation from the first one and the creation is working well but still no filtering.

Recreating the search index doesn't help.

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

1 week 6 days ago #78780 by micker
flexicontent version please ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

1 week 6 days ago #78781 by grabit
3.3.5

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

1 week 5 days ago #78797 by ggppdk
Hello

i think i have found , but i need to spend some more time

it will not work depending on date format

filering, will only work if format with format
YYYY-mm-dd


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

1 week 3 days ago #78807 by grabit
As it will never be displayed (Only used for filtering) I don’t care the format.

When do you think you will have the solution? I need that urgently as they have to vote during their next “virtual” congress.

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

1 week 2 days ago #78809 by ggppdk
Hello

the item form submission the current format is converted to
YYYY-mm-dd

For this to work, your import file needs to have date formats in
YYYY-mm-dd

To use a solution now i do not see a solution , something else other than re-doing the import


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

1 week 2 days ago #78812 by ggppdk
Hello

If load - save fixes the CSV import and you need this now you could try it if you do not have too many items.

I am looking into
- adding code to check format during CSV import,
- and for existing imported data doing something via "Search re-indexing" task


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

5 days 14 hours ago #78817 by ggppdk
Hello

i have made an updated version that will update / fix the filtering values via
Updating "Basic Search index". If you have not worked out this by now, then you can use the new version


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.