Bug: export

sraul · April 20, 2021, 9:35am

Hi ksar,

I have a question regarding export module, I don’t know if it’s a bug or? When I go to “Export” and select “Stocks and location (warehouse) of products” and define fields to export. At the “save a profile” I try to save it and it says it is saved but it doesn’t show anywhere. When I return to step 2 there is no “Predefined Profile” to select. I’ll attach some pictures. Can you help me with this one. Thank you in advance!

ksar · April 20, 2021, 10:41am

Hello,

Better to post a public topic instead of private messages.

What is your dolibarr version ?

sraul · April 21, 2021, 5:56am

Hello,

It’s 13.0.2., but I think it’s some kind of a bug in my Dolibarr Version.

ksar · April 21, 2021, 7:28am

Hello,

Personally I tried what you have done and I get another issue :
When I tried to save the export profile, I get : Data too long for column ‘type’ at row 1

2021-04-21 09:17:35 DEBUG sql=INSERT INTO llx_export_model (label,type,field,fk_user,filter) VALUES ('test', 'stock_emplacement_product', 'e.rowid', 12, '')
2021-04-21 09:17:35 ERR DoliDBMysqli::query SQL Error message: DB_ERROR_1406 Data too long for column 'type' at row 1
2021-04-21 09:17:35 DEBUG ROLLBACK Transaction

For me, the field type is a varchar(20) :

It seems that in V14, this field is now a varchar(64) :

github.com

Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/tables/llx_export_model.sql#L27


-- along with this program. If not, see <https://www.gnu.org/licenses/>.
--
--
-- ===================================================================


create table llx_export_model
(
  	rowid		integer AUTO_INCREMENT PRIMARY KEY,
	fk_user		integer DEFAULT 0 NOT NULL,
  	label		varchar(50) NOT NULL,
  	type		varchar(64) NOT NULL,
  	field		text NOT NULL,
  	filter		text
  	
)ENGINE=innodb;

github.com

Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/migration/13.0.0-14.0.0.sql#L55


insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 6,'AC_EMAIL_IN','system','reception Email',NULL, 1, 4);


-- VMYSQL4.3 ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN montant double(24,8) NULL;
-- VPGSQL8.2 ALTER TABLE llx_accounting_bookkeeping ALTER COLUMN montant DROP NOT NULL;


UPDATE llx_c_country SET eec = 1 WHERE code IN ('AT','BE','BG','CY','CZ','DE','DK','EE','ES','FI','FR','GR','HR','NL','HU','IE','IM','IT','LT','LU','LV','MC','MT','PL','PT','RO','SE','SK','SI');




-- For v14


ALTER TABLE llx_export_model MODIFY COLUMN type varchar(64);


create table llx_accounting_groups_account
(
  rowid            integer AUTO_INCREMENT PRIMARY KEY,
  fk_accounting_account		INTEGER NOT NULL,
  fk_c_accounting_category	INTEGER NOT NULL
)ENGINE=innodb;




ALTER TABLE llx_oauth_token ADD COLUMN restricted_ips varchar(200);

When I changed to 64, it is working, and the profile is well displayed :

Try to do the same because on your screenshot your “type” seems to be truncated :
You have “stock_emplacement_pr” instead of “stock_emplacement_product”