[SOLVED] Importing CSV featuring values of 0

More
9 years 10 months ago - 9 years 9 months ago #51477 by agata
My client has a large hotel database in a spreadsheet and they're delighted they can import it into Flexicontent as it will save them a ton of time. Part of the data they wish to import is annual average temperatures from the hotels' locations, the problem is when that value is 0 the value is skipped. I tried putting it in "" and putting " in the Field Encloser Character but it still skips the 0. Any way around this? I'd rather not have to go article by article correcting this as there will be hundreds of hotels imported.
Thanks in advance for any assistance.
A
Last edit: 9 years 9 months ago by agata.

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

More
9 years 10 months ago #51481 by ggppdk
Hello

zero should be saved properly, if not then it is a bug

which field has problem with this
e.g. text field ?
e.g. any non-core field ? e.g. text/select/radio etc fields ??


-- 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...

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

More
9 years 10 months ago #51483 by agata
Yes, it's just a simple text field. If I go back to the article and put 0 in the field, it saves correctly. But while importing from CSV, it skips that value altogether.

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

More
9 years 10 months ago #51484 by ggppdk
Hello

ok will make a fix for this, with a quick look at the code, i did not find it, must run a test, but in case it should be easy to fix


-- 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...

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

More
9 years 10 months ago #51485 by agata
Thank you and looking forward to the fix.
Best,
A

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

More
9 years 10 months ago #51495 by ggppdk
Hello

tested and value zero is imported,

which FLEXIcontent version do you have ?


-- 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...

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.582 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline