× Help Forum English

[VIEWED] Import Events vom Excel-file

Début
Précédent
1
Suivant
Fin

delphin150
Auteur du sujet
Nouveau membre

Plus d'informations

il y a 10 ans 7 mois - il y a 10 ans 6 mois #7609 par delphin150

[VIEWED] Import Events vom Excel-file a été créé par 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!

Dernière édition: il y a 10 ans 6 mois par Lyr!C. Raison: [VIEWED]

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 10 ans 7 mois #7613 par Lyr!C

Réponse de Lyr!C sur le sujet 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.8
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) .

Connexion ou Créer un compte pour participer à la conversation.

delphin150
Auteur du sujet
Nouveau membre

Plus d'informations

il y a 10 ans 7 mois #7625 par delphin150

Réponse de delphin150 sur le sujet 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

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 10 ans 6 mois #7640 par Lyr!C

Réponse de Lyr!C sur le sujet 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

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 10 ans 6 mois #7641 par Lyr!C

Réponse de Lyr!C sur le sujet 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,