× Help Forum English

[VIEWED] Import Events vom Excel-file

Inizio
Indietro
1
Avanti
Fine

delphin150
Autore della discussione
New Member

Di più

11 Anni 4 Ore fa - 10 Anni 11 Mesi fa #7609 da delphin150

[VIEWED] Import Events vom Excel-file è stato creato da delphin150

Hello together,

if have got many events to import into icagenda which are listed in an Excel-File.
Is it possilbe to import these events directly to icagenda?

If not, can import the evetns into the database?
What SQL-Statement do i have to use and wicht fields are requiered?

Many thanks for your help!

Kind Regards!

Ultima Modifica 10 Anni 11 Mesi fa da Lyr!C. Motivo: [VIEWED]

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

10 Anni 11 Mesi fa #7613 da Lyr!C

Risposta da Lyr!C al topic Import Events vom Excel-file

Hi!

Today, not yet a import/export system. This is planned for end of year.

Of course, if you know sql, you can create the SQL request to add the events.

All depends of which information you have in your excel file ?

What is required is title, alias, category and dates. But you can of course add value for other fields.

Cyril

Latest version : iCagenda 3.9.11
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Si prega Accedi o Crea un account a partecipare alla conversazione.

delphin150
Autore della discussione
New Member

Di più

10 Anni 11 Mesi fa #7625 da delphin150

Risposta da delphin150 al topic Import Events vom Excel-file

Hello,

thanks for the quick answer.

In the database I can find the attributes "id", "asset-id" and "ordering".
Do I have to fill this attributes, too?
Are they filled automatically?

Thanks for your help!

Kind regards

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

10 Anni 11 Mesi fa #7640 da Lyr!C

Risposta da Lyr!C al topic Import Events vom Excel-file

Hi!

If your database is empty, and AUTO_INCREMENT on 1, yes you have to give id a unique ascendant number (1, 2, 3, 4...)

About assert_id (used for user individual ACL permissions) set it to '0' (zero)

About ordering, the same as asset_id, set it to "0" (zero)

Hope this help!

Cyril

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

10 Anni 11 Mesi fa #7641 da Lyr!C

Risposta da Lyr!C al topic Import Events vom Excel-file

You have default value for columns in sql install file :

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `asset_id` INT(10) NOT NULL DEFAULT '0',
  `ordering` INT(11) NOT NULL,
  `state` TINYINT(1) NOT NULL DEFAULT '1',
  `approval` INT(11) NOT NULL DEFAULT '0',
  `checked_out` INT(11) NOT NULL,
  `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NOT NULL,
  `access` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `language` CHAR(7) NOT NULL,
  `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `created_by_alias` VARCHAR(255) NOT NULL,
  `created_by_email` VARCHAR(100) NOT NULL,
  `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` VARCHAR(255) NOT NULL,
  `catid` INT(11) NOT NULL,
  `image` VARCHAR(255) NOT NULL,
  `file` VARCHAR(255) NOT NULL,
  `displaytime` INT(10) NOT NULL DEFAULT '1',
  `weekdays` VARCHAR(255) NOT NULL,
  `daystime` VARCHAR(255) NOT NULL,
  `startdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `enddate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `period` TEXT(65535) NOT NULL,
  `dates` TEXT(65535) NOT NULL,
  `next` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `time` VARCHAR(255) NOT NULL,
  `place` VARCHAR(255) NOT NULL,
  `website` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `city` VARCHAR(255) NOT NULL,
  `country` VARCHAR(255) NOT NULL,
  `address` VARCHAR(255) NOT NULL,
  `coordinate` VARCHAR(255) NOT NULL,
  `lat` FLOAT( 20, 16 ) NOT NULL,
  `lng` FLOAT( 20, 16 ) NOT NULL,
  `desc` TEXT(65535) NOT NULL ,
  `metadesc` TEXT NOT NULL,
  `params` TEXT NOT NULL,