fonction import

More
12 years 1 month ago #29837 by tonnick
Replied by tonnick on topic fonction import
ok just to be sure, In the exemple you provide, there is no \n

then could you provide the csv used in order to parse, maybe there is some difference somewhere

thx in advance

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

More
12 years 1 month ago #29838 by ggppdk
Replied by ggppdk on topic fonction import
what do you mean there is no \n ???

\n is the newline character like \t is the unprintable horizontal tab character


-- 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
12 years 1 month ago #29840 by ggppdk
Replied by ggppdk on topic fonction import
Usually "normal" csv files have \n (new line) for record separator and \t (tab) or ; or , for column separator,

our CSV parameters give you full flexibility to use custom (even multi-character) separators


-- 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
12 years 1 month ago #29842 by tonnick
Replied by tonnick on topic fonction import
well here is the exemple on flexicontent


CSV example Format:
title ~~ text ~~ textfield3 ~~ emailfield6 ~~ weblinkfld8 ~~ single_value_field22 ~~ multi_value_field24
~~ title 1 ~~ description 1 ~~ textfield3 value ~~ [-email-]=usera@somedomain.com!![-text-]=usera ~~ www.somedomaina.com ~~ f22_valuea ~~ f24_value01%%f24_value02%%f24_value03
~~ title 2 ~~ description 2 ~~ textfield3 value ~~ [-email-]=userb@somedomain.com!![-text-]=userb ~~ www.somedomainb.com ~~ f22_valuea ~~ f24_value04%%f24_value05%%f24_value06
~~ title 3 ~~ description 3 ~~ textfield3 value ~~ [-email-]=userc@somedomain.com!![-text-]=userc ~~ www.somedomainc.com ~~ f22_valuea ~~ f24_value07%%f24_value08%%f24_value09
~~ title 4 ~~ description 4 ~~ textfield3 value ~~ userd@somedomain.com ~~ [-addr-]=www.somedomaind.com!![-text-]=somedomainD ~~ f22_valuea ~~ f24_value10%%f24_value11%%f24_value12
~~ title 5 ~~ description 5 ~~ textfield3 value ~~ usere@somedomain.com ~~ [-addr-]=www.somedomaine.com!![-text-]=somedomainE ~~ f22_valuea ~~ f24_value13%%f24_value14%%f24_value15

I don't see any /n

And anyway, if I use same syntax, it works, but it I don't put ~~ before each title item it does not work. for exemple :

title ~~ text ~~ textfield3 ~~ emailfield6 ~~ weblinkfld8 ~~ single_value_field22 ~~ multi_value_field24
title 1 ~~ description 1 ~~ textfield3 value ~~ [-email-]=usera@somedomain.com!![-text-]=usera ~~ www.somedomaina.com ~~ f22_valuea ~~ f24_value01%%f24_value02%%f24_value03
title 2 ~~ description 2 ~~ textfield3 value ~~ [-email-]=userb@somedomain.com!![-text-]=userb ~~ www.somedomainb.com ~~ f22_valuea ~~ f24_value04%%f24_value05%%f24_value06
title 3 ~~ description 3 ~~ textfield3 value ~~ [-email-]=userc@somedomain.com!![-text-]=userc ~~ www.somedomainc.com ~~ f22_valuea ~~ f24_value07%%f24_value08%%f24_value09
title 4 ~~ description 4 ~~ textfield3 value ~~ userd@somedomain.com ~~ [-addr-]=www.somedomaind.com!![-text-]=somedomainD ~~ f22_valuea ~~ f24_value10%%f24_value11%%f24_value12
title 5 ~~ description 5 ~~ textfield3 value ~~ usere@somedomain.com ~~ [-addr-]=www.somedomaine.com!![-text-]=somedomainE ~~ f22_valuea ~~ f24_value13%%f24_value14%%f24_value15

is NOT working


This why I opened this topic, to be simple, can we make it work on that way ?!

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

More
12 years 1 month ago #29846 by ggppdk
Replied by ggppdk on topic fonction import
\n
\t
etc are special characters
e.g. when there is line change it is the character \n (unix) or \r\n (windows)

i have tested parsing and it works with any separator not appearing inside the data, and i have taken time to add more parameters and debugging help in the files i provided, if you want you can use them now, or wait for a complete build, but there is nο bug in the import procedure


-- 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
12 years 1 month ago #29847 by tonnick
Replied by tonnick on topic fonction import
ok then I'll try this new version and will try to import once again the second block.

thx for your support !

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.401 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