Data import extension and data null

Previous topic

Developer

Next topic

Author	Message
SEBBANE Alexandre	Thursday 06 November 2008 8:03:21 pm How to import a content where sometime data dont exist to expose my problèm, let's try a little explanation : here is a article ( title, text , date1 , date2) the data to import are title1;bla bla bla; 12/12/206;13/12/2007 title2;bla bla bla2;;1/12/2007 title3;bla bla bla3; 2/12/206;10/12/2007 title4;bla bla bla4; 1/12/206;3/12/2007 title5;bla bla bla5; 7/12/206;22/12/2007 how can i do to import the content n°2. up to now, a data which is null is inserted with a value of 0 ( for a string ), 01/01/1970 for a date etc... thanks for your answers Paris, France
Grégory BECUE	Thursday 20 November 2008 9:44:05 am Hi Alexandre, What do you use to make your data importation ? You have a script or you use an extension import ? Because i use a specific script and if i don't have a value for a birthday, the field will be empty ! i don't have this problem.

Author

Message

SEBBANE Alexandre

Thursday 06 November 2008 8:03:21 pm

How to import a content where sometime data dont exist

to expose my problèm, let's try a little explanation :

here is a article ( title, text , date1 , date2)
the data to import are

title1;bla bla bla; 12/12/206;13/12/2007 
title2;bla bla bla2;;1/12/2007 
title3;bla bla bla3; 2/12/206;10/12/2007 
title4;bla bla bla4; 1/12/206;3/12/2007 
title5;bla bla bla5; 7/12/206;22/12/2007

how can i do to import the content n°2.

up to now, a data which is null is inserted with a value of 0 ( for a string ), 01/01/1970 for a date etc...

thanks for your answers

Paris, France

Grégory BECUE

Thursday 20 November 2008 9:44:05 am

Hi Alexandre,

What do you use to make your data importation ? You have a script or you use an extension import ?

Because i use a specific script and if i don't have a value for a birthday, the field will be empty ! i don't have this problem.

eZ debug

Timing:	Jan 18 2025 10:53:19
Script start
Timing:	Jan 18 2025 10:53:19
Module start 'layout'
Timing:	Jan 18 2025 10:53:19
Module start 'content'
Timing:	Jan 18 2025 10:53:20
Module end 'content'
Timing:	Jan 18 2025 10:53:20
Script end

Main resources:

Total runtime	0.9642 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	589.0547	152.6250
Module start 'layout'	0.0061	0.0045	741.6797	39.4453
Module start 'content'	0.0106	0.9519	781.1250	523.9219
Module end 'content'	0.9626	0.0016	1,305.0469	8.1563
Script end	0.9642		1,313.2031

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.3600	16	0.0002
Check MTime	0.0014	0.1473	16	0.0001
Mysql Total
Database connection	0.0006	0.0623	1	0.0006
Mysqli_queries	0.9109	94.4705	54	0.0169
Looping result	0.0006	0.0603	52	0.0000
Template Total	0.9222	95.6	2	0.4611
Template load	0.0023	0.2421	2	0.0012
Template processing	0.9199	95.4005	2	0.4599
Template load and register function	0.0001	0.0156	1	0.0001
states
state_id_array	0.0019	0.1936	1	0.0019
state_identifier_array	0.0016	0.1686	2	0.0008
Override
Cache load	0.0019	0.1993	16	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0859	2	0.0004
Fetch class attribute name	0.0017	0.1750	3	0.0006
XML
Image XML parsing	0.0037	0.3873	2	0.0019
class_abstraction
Instantiating content class attribute	0.0000	0.0009	3	0.0000
General
dbfile	0.0063	0.6508	16	0.0004
String conversion	0.0000	0.0012	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 11 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs