AutoImport for Letterbox

L'import en masse pour les applications Maarch
Mass Import for Maarch Applications

AutoImport for Letterbox

Message par Alessandro » 18 Fév 2009, 12:51

Is it possible that I've missed the sql file for letterbox Autoimport?
I can't import file on letterbox, but I think I did something wrong.
Thank You.
Alessandro Campa
Alessandro
 
Message(s) : 17
Inscription : 11 Nov 2008, 15:21

Re: AutoImport for Letterbox

Message par Alessandro » 18 Fév 2009, 13:15

I've renamed OFFSET field in res_x letterbox table in OFFSET_DOC because I've had an error on Windows cmd, but Is not jet possible to import file into database.
I also tryed to modify mapping file, but I don't know how I can do it.
Thank you.
Alessandro Campa
Alessandro
 
Message(s) : 17
Inscription : 11 Nov 2008, 15:21

Re: AutoImport for Letterbox

Message par lgi » 18 Fév 2009, 13:25

Ciao Allessandro,

It is normal that you have difficulties, LetterBox is not adapted for AutoImport (for the moment).

But if you replace the parameters table by this, AutImport will work with LetterBox :
Code : Tout sélectionner
CREATE TABLE IF NOT EXISTS `parameters` (
  `KEY1` varchar(32) default NULL,
  `KEY2` varchar(32) default NULL,
  `KEY3` varchar(32) default NULL,
  `VALUE` varchar(32) NOT NULL default '0',
  `LIB_PARAM` varchar(128) NOT NULL default '',
  `id` varchar(50) default NULL,
  `param_value_char` varchar(50) default NULL,
  `param_value_int` int(8) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Se réveiller, c'est se mettre à la recherche du monde.
lgi
 
Message(s) : 113
Inscription : 12 Déc 2007, 18:58

Re: AutoImport for Letterbox

Message par Alessandro » 18 Fév 2009, 14:01

I've created the table parameters and now I've not any kind of error message, but there is a problem that I find in log.txt.
The importation process don't create the folder in DocServer.
<18-02-2009 - 13:46:03> Current target docserver location for import : 2009\02\00000000\
Alessandro
 
Message(s) : 17
Inscription : 11 Nov 2008, 15:21

Re: AutoImport for Letterbox

Message par Alessandro » 18 Fév 2009, 14:06

I've seen that the name of DocServer was not correct.
Now all is right..
Thank you very much.
Alessandro Campa
Alessandro
 
Message(s) : 17
Inscription : 11 Nov 2008, 15:21

Re: AutoImport for Letterbox

Message par Alessandro » 18 Fév 2009, 14:28

But now I don't have the work_batch_autoimport_id.
How can I import file more than one time a day?
I don't know how to modify the batch value.
Thank you.
Alessandro Campa
Alessandro
 
Message(s) : 17
Inscription : 11 Nov 2008, 15:21

Re: AutoImport for Letterbox

Message par lgi » 18 Fév 2009, 14:34

You have to launch this query on your database to create the work_batch_autoimport_id :

Code : Tout sélectionner
INSERT INTO `parameters` VALUES('0', '0', '0', '0', '', 'work_batch_autoimport_id', NULL, 1);
Se réveiller, c'est se mettre à la recherche du monde.
lgi
 
Message(s) : 113
Inscription : 12 Déc 2007, 18:58

Re: AutoImport for Letterbox

Message par Alessandro » 18 Fév 2009, 16:47

Now Autoimport works rightly.
But when I would like to record a new file from Letterbox I've found this error when I click on "Send to Validation" button:

- Error with the SQL request -

Error number1136 has just occurred :
Message : Column count doesn't match value count at row 1
Query :
INSERT INTO parameters VALUES ('CHRONO', '', '2009', '1', '')

I think that I've to modify a php file because I've modified the structure of a table into database...
Thanks a lot
Alessandro Campa
Alessandro
 
Message(s) : 17
Inscription : 11 Nov 2008, 15:21

Re: AutoImport for Letterbox

Message par jle » 23 Fév 2009, 09:35

Hello Alessandro,

AutoImport is not made exactly for Letterbox for now. With very few adaptations, it is possible to make it work though.
Future version of Letterbox will be autoimport-compliant.
LGI asked you to create more columns in parameters table. When doing an insert, your field list must match number et order of fields created.
Add null or '' values in the insert clause that makes the error.

When ok, you could write a tutorial in english in the howto? part of documentation, for the benefit of the community.

Regards,
JLE.
jle
 
Message(s) : 394
Inscription : 07 Jan 2008, 17:28
Localisation : Paris - France

Re: AutoImport for Letterbox

Message par Vanna » 31 Jan 2017, 13:02

The importation process don't create the folder in DocServer.
Vanna
 
Message(s) : 3
Inscription : 31 Jan 2017, 12:46

Suivant

Retour vers Maarch AutoImport

Qui est en ligne ?

Utilisateur(s) parcourant ce forum : Aucun utilisateur inscrit et 2 invité(s)