Login

Screenshots for the Koha manual

New screenshots | All screenshots | Full test results | Manuals (wip)
en de el es fr hi zh_Hant

Image details

addcsv-sql (#1439) ✅ Validated

Job

No job planned.

Difficulty

Medium

Spec (updated on Thu Dec 4 15:48:34 2025)

describe("tools/csvprofiles/addcsv-sql", function () {
    const languages = ['en', 'es-ES', 'fr-FR', 'de-DE', 'el-GR', 'hi', 'zh-Hant-TW'];
    languages.forEach((lang) => {
        describe(`in ${lang}`, () => {
            beforeEach(function(){
                // Skip if 'en' test failed
                if (Cypress.env("EN_TEST_FAILED")) {
                    this.skip();
                }
                /* FIXME - Invalid step   */
                cy.login();
                /* No specific padding defined */
                cy.set_cookie_lang(lang);
            });

            it("addcsv-sql", function () {
                cy.visit("/cgi-bin/koha/tools/csv-profiles.pl?op=add_form");
                cy.waitForPageLoad();
                cy.get("#profile").type("Simple export");
                cy.get("#type").select("SQL", {force: true});
                cy.get("#used_for_sql").select("export_basket", {force: true});
                cy.get("#sql_content").type("Title=biblio.title|Author=biblio.author|Year=biblio.copyrightdate");
                cy.get("main").click();
                cy.get("main").should('be.visible').screenshot("addcsv-sql");
            });
        });
    });
    afterEach(function () {
        Cypress.env('PADDING_BEFORE_SCREENSHOT', undefined);
        // Set EN_TEST_FAILED if the 'en' test failed
        if (this.currentTest.parent.title.includes('in en') && this.currentTest.state === 'failed') {
            Cypress.env("EN_TEST_FAILED", true);
        }
    });
});

Spec data

Page

csv-profiles.pl?op=add_form

Interface

staff

Element selector

main

Missing selector

N

setup

 

workflow

type #profile=Simple export
select #type=SQL
select #used_for_sql=export_basket
type #sql_content=Title=biblio.title|Author=biblio.author|Year=biblio.copyrightdate
click main

teardown


    

Notes

We must type some information in the form
Profile name: Simple export
Profile type (select): SQL
Usage (select): Basket export in acquisitions
Profile SQL fields: Title=biblio.title|Author=biblio.author|Year=biblio.copyrightdate


Look like click can't be used with <select> element, this will be a problem in many forms. The error says we should use cy.select() instead. I don't know if we can do that in the spec data section.

Additional KTD data

Thumbnails


Current Thumbnail old
New Thumbnail new
New (de)
New (el)
New (es)
New (fr)
New (hi)
New (zh_Hant)

Current

New (updated on Thu Dec 4 22:35:22 2025)

New (de)

New (el)

New (es)

New (fr)

New (hi)

New (zh_Hant)

2025-12-01 12:15:14 +0000

2025-06-04 23:45:01 +0000

2025-06-03 14:30:03 +0000

2025-06-03 14:15:03 +0000

2025-06-03 11:30:03 +0000

2025-06-03 11:15:03 +0000

2025-06-03 10:15:02 +0000

2025-06-03 08:15:01 +0000

2025-06-03 08:00:03 +0000

2025-06-02 15:00:01 +0000

2025-06-02 13:30:03 +0000

2025-05-22 16:45:01 +0000

2025-12-04 22:45:02 +0000

2025-12-01 12:15:14 +0000

Old screenshot