fonction import

tonnick
Topic Author
Offline
Platinum Member

12 years 1 month 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

12 years 1 month 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
                )

        )

)

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

tonnick
Topic Author
Offline
Platinum Member

12 years 1 month 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

12 years 1 month 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

12 years 1 month 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

12 years 1 month 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.