fonction import

ggppdk
Offline
Administrator

13 years 3 months ago #29855 by ggppdk

Replied by ggppdk on topic fonction import

Parsing algorithm is verified and it will work with any separators that does not appear inside the data, and i have provided a way of checking the result (the line that you have uncommitted prints the result of parsing of the first CSV record)

the updated version adds more options to the debugging, and more configuration options,

it has no bug fixes

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

micker
Offline
Administrator

13 years 3 months ago #29856 by micker

Replied by micker on topic fonction import

if you need better option you can use flexiimport
regards

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.

tonnick
Topic Author
Offline
Platinum Member

13 years 3 months ago #29857 by tonnick

Replied by tonnick on topic fonction import

ok will try new version tonight

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

tonnick
Topic Author
Offline
Platinum Member

13 years 3 months ago #29858 by tonnick

Replied by tonnick on topic fonction import

well, I already used flexi import in previous version.

But I would think that if there is integrated tool to do what I need, would be better to use it, instead of adding another component for same job

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

tonnick
Topic Author
Offline
Platinum Member

13 years 3 months ago #29887 by tonnick

Replied by tonnick on topic fonction import

ok I still have same issue. I put in bold 1 and 2 issues on csv file.

1. before all item, I have to add a separator to make it work.

2. I guess that something is wrong for weblinks, but I don't know what

"title";"text";"state";"type_of_product";"country";"world_regions";"legal_protection";"national_legislation";"external_link";"notes"
;"Atest4";;"3";"agricultural_product_and_foodstuff";"ES";"europe";"sui_generis";"[-addr-]=http://ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=1839!![-text-]=law";"[-addr-]=http://ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=1839!![-text-]=link";"notes test"
;"Atest5";;"3";"agricultural_product_and_foodstuff";"ES";"europe";"sui_generis";"[-addr-]=http://ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=1839!![-text-]=law";"[-addr-]=http://ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=1839!![-text-]=link";"notes test"

Do you have any idea about those 2 issues ?

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

ggppdk
Offline
Administrator

13 years 3 months ago #29888 by ggppdk

Replied by ggppdk on topic fonction import

I have just tested with your data with :

Field Separator: ;
Field Encloser Character: "
Item Separator: \n;

and they are parsed properly (note state column you have will be ignored)

Parsing result of the first 4 records (please click here to return previous page):

COLUMNS: title, text, state, type_of_product, country, world_regions, legal_protection, national_legislation, external_link, notes

Code:

RECORD no 1:
Array
(
    [type_id] => 1
    [language] => en-GB
    [catid] => 98
    [cid] => Array
        (
        )

    [vstate] => 2
    [state] => -4
    [title] => Atest4
    [text] => 
    [custom] => Array
        (
            [state] => Array
                (
                    [0] => 3
                )

            [type_of_product] => Array
                (
                    [0] => agricultural_product_and_foodstuff
                )

            [country] => Array
                (
                    [0] => ES
                )

            [world_regions] => Array
                (
                    [0] => europe
                )

            [legal_protection] => Array
                (
                    [0] => sui_generis
                )

            [national_legislation] => Array
                (
                    [0] => Array
                        (
                            [addr] => http://ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=1839
                            [text] => law
                        )

                )

            [external_link] => Array
                (
                    [0] => Array
                        (
                            [addr] => http://ec.europa.eu/agriculture/quality/door/registeredName.html?denominationId=1839
                            [text] => link
                        )

                )

            [notes] => Array
                (
                    [0] => notes test
                )

        )

)

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

tonnick
Topic Author
Offline
Platinum Member

13 years 3 months ago #29889 by tonnick

Replied by tonnick on topic fonction import

yes it is parsed, but

why do we have to add ; at the beginning of the item line ? once again, this is not a usual .csv

and

weblink are empty, without link or text.

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

ggppdk
Offline
Administrator

13 years 3 months ago #29890 by ggppdk

Replied by ggppdk on topic fonction import

you don't have to use
\n;

you can use
\n

in short, you can use any csv file format, just configure the parameters to reflect the format that you have in your CSV file:
e.g.
Field Separator: ;
Field Encloser Character: "
Item Separator: \n

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

tonnick
Topic Author
Offline
Platinum Member

13 years 3 months ago #29891 by tonnick

Replied by tonnick on topic fonction import

ok great with only /n it works !

the only pb remains with links. it parses, but, then, when I open my item, links and text are still empty. Did I miss something ?

and why state does not take in account the status ?

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

ggppdk
Offline
Administrator

13 years 3 months ago #29893 by ggppdk

Replied by ggppdk on topic fonction import

it does not use language, catid, cid, state column

(in r1526)
i have added
-- usage of language(e.g. en-GB), catid (main category id, e.g. 55), cid (secondary cats e.g. 47,11,83)
-- notifications off unmatched columns (probably this is what is happening in your case ???)

i ll add state column too

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