View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06623 | Bug reports | Import/Export | public | 2012-10-01 19:09 | 2012-10-05 15:26 |
| Reporter | TMSWhite | Assigned To | TMSWhite | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00+ | ||||
| Summary | 06623: imported tab delimited surveys are not visible | ||||
| Description | LS 2.0 says that the file loads correctly, but when you try to go to the survey (or list it), it is not found. When you run the Check Data Integrity function, you see that there are questions, attributes, groups, and language settings that can be deleted because there is no matching surveyid - where the missing surveyid is the one listed in the URL immediately after importing the survey. So, it appears that everything loads correctly, but the new survey id is not written to the database. | ||||
| Steps To Reproduce | Import attached survey | ||||
| Tags | No tags attached. | ||||
| Attached Files | Survey_debug_test2 (1).txt (27,232 bytes)
��c l a s s t y p e / s c a l e n a m e r e l e v a n c e t e x t h e l p l a n g u a g e v a l i d a t i o n m a n d a t o r y o t h e r d e f a u l t s a m e _ d e f a u l t a l l o w e d _ f i l e t y p e s a l p h a s o r t a n s w e r _ w i d t h a r r a y _ f i l t e r a r r a y _ f i l t e r _ e x c l u d e a s s e s s m e n t _ v a l u e c a t e g o r y _ s e p a r a t o r d i s p l a y _ c o l u m n s d i s p l a y _ r o w s d r o p d o w n _ d a t e s _ y e a r _ m i n d r o p d o w n _ d a t e s d r o p d o w n _ d a t e s _ y e a r _ m a x d r o p d o w n _ p r e f i x d r o p d o w n _ p r e p o s t f i x d r o p d o w n _ s e p a r a t o r s d r o p d o w n _ s i z e d u a l s c a l e _ h e a d e r A d u a l s c a l e _ h e a d e r B e m _ v a l i d a t i o n _ q _ t i p e m _ v a l i d a t i o n _ q e m _ v a l i d a t i o n _ s q e m _ v a l i d a t i o n _ s q _ t i p e q u a l s _ n u m _ v a l u e e x c l u d e _ a l l _ o t h e r s e x c l u d e _ a l l _ o t h e r s _ a u t o h i d d e n h i d e _ t i p i n p u t _ b o x e s l o c a t i o n _ c i t y l o c a t i o n _ c o u n t r y l o c a t i o n _ d e f a u l t c o o r d i n a t e s l o c a t i o n _ m a p h e i g h t l o c a t i o n _ m a p s e r v i c e l o c a t i o n _ m a p w i d t h l o c a t i o n _ m a p z o o m l o c a t i o n _ n o d e f a u l t f r o m i p l o c a t i o n _ p o s t a l l o c a t i o n _ s t a t e m a x _ a n s w e r s m a x _ f i l e s i z e m a x _ n u m _ o f _ f i l e s m a x _ n u m _ v a l u e m a x _ n u m _ v a l u e _ n m a x i m u m _ c h a r s m i n _ a n s w e r s m i n _ n u m _ o f _ f i l e s m i n _ n u m _ v a l u e m i n _ n u m _ v a l u e _ n m u l t i f l e x i b l e _ c h e c k b o x m u l t i f l e x i b l e _ m a x m u l t i f l e x i b l e _ m i n m u l t i f l e x i b l e _ s t e p n u m _ v a l u e _ i n t _ o n l y n u m b e r s _ o n l y o t h e r _ c o m m e n t _ m a n d a t o r y o t h e r _ n u m b e r s _ o n l y o t h e r _ r e p l a c e _ t e x t p a g e _ b r e a k p r e f i x p u b l i c _ s t a t i s t i c s r a n d o m _ g r o u p r a n d o m _ o r d e r r e v e r s e s c a l e _ e x p o r t s h o w _ c o m m e n t s h o w _ g r a n d _ t o t a l s h o w _ t i t l e s h o w _ t o t a l s s l i d e r _ a c c u r a c y s l i d e r _ d e f a u l t s l i d e r _ l a y o u t s l i d e r _ m a x s l i d e r _ m i d d l e s t a r t s l i d e r _ m i n s l i d e r _ r a t i n g s l i d e r _ s e p a r a t o r s l i d e r _ s h o w m i n m a x s u f f i x t e x t _ i n p u t _ w i d t h t i m e _ l i m i t _ a c t i o n t i m e _ l i m i t _ c o u n t d o w n _ m e s s a g e t i m e _ l i m i t _ d i s a b l e _ n e x t t i m e _ l i m i t _ d i s a b l e _ p r e v t i m e _ l i m i t _ m e s s a g e t i m e _ l i m i t _ m e s s a g e _ d e l a y t i m e _ l i m i t _ m e s s a g e _ s t y l e t i m e _ l i m i t _ t i m e r _ s t y l e t i m e _ l i m i t _ w a r n i n g _ 2 _ d i s p l a y _ t i m e t i m e _ l i m i t _ w a r n i n g _ 2 _ m e s s a g e t i m e _ l i m i t _ w a r n i n g _ 2 _ s t y l e t i m e _ l i m i t _ w a r n i n g _ 2 t i m e _ l i m i t _ w a r n i n g t i m e _ l i m i t t i m e _ l i m i t _ w a r n i n g _ d i s p l a y _ t i m e t i m e _ l i m i t _ w a r n i n g _ m e s s a g e t i m e _ l i m i t _ w a r n i n g _ s t y l e u s e _ d r o p d o w n
S s i d 8 6 8 9 3 3
S o w n e r _ i d 1
S a d m i n O l i v e r B o w n
S a c t i v e N
S a d m i n e m a i l o l l i e @ i c a r u s . n u
S a n o n y m i z e d N
S f o r m a t G
S s a v e t i m i n g s N
S t e m p l a t e d e f a u l t
S l a n g u a g e e n
S d a t e s t a m p N
S u s e c o o k i e N
S a l l o w r e g i s t e r N
S a l l o w s a v e Y
S a u t o n u m b e r _ s t a r t 0
S a u t o r e d i r e c t N
S a l l o w p r e v N
S p r i n t a n s w e r s N
S i p a d d r N
S r e f u r l N
S d a t e c r e a t e d 2 5 / 0 9 / 2 0 1 2
S p u b l i c s t a t i s t i c s N
S p u b l i c g r a p h s N
S l i s t p u b l i c N
S h t m l e m a i l Y
S s e n d c o n f i r m a t i o n Y
S t o k e n a n s w e r s p e r s i s t e n c e N
S a s s e s s m e n t s N
S u s e c a p t c h a D
S u s e t o k e n s N
S b o u n c e _ e m a i l o l l i e @ i c a r u s . n u
S a t t r i b u t e d e s c r i p t i o n s a : 0 : { }
S t o k e n l e n g t h 1 5
S s h o w x q u e s t i o n s Y
S s h o w g r o u p i n f o B
S s h o w n o a n s w e r Y
S s h o w q n u m c o d e X
S b o u n c e p r o c e s s i n g N
S s h o w w e l c o m e Y
S s h o w p r o g r e s s Y
S a l l o w j u m p s N
S n a v i g a t i o n d e l a y 0
S n o k e y b o a r d N
S a l l o w e d i t a f t e r c o m p l e t i o n N
S L s u r v e y l s _ t i t l e A S u r v e y e n
S L s u r v e y l s _ d e s c r i p t i o n D e s c r i p t i o n e n
S L s u r v e y l s _ w e l c o m e t e x t W e l c o m e e n
S L s u r v e y l s _ e m a i l _ i n v i t e _ s u b j I n v i t a t i o n t o p a r t i c i p a t e i n a s u r v e y e n
S L s u r v e y l s _ e m a i l _ i n v i t e " D e a r { F I R S T N A M E } , y o u h a v e b e e n i n v i t e d t o p a r t i c i p a t e i n a s u r v e y . T h e s u r v e y i s t i t l e d : " " { S U R V E Y N A M E } " " " " { S U R V E Y D E S C R I P T I O N } " " T o p a r t i c i p a t e , p l e a s e c l i c k o n t h e l i n k b e l o w . S i n c e r e l y , { A D M I N N A M E } ( { A D M I N E M A I L } ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - C l i c k h e r e t o d o t h e s u r v e y : { S U R V E Y U R L } I f y o u d o n o t w a n t t o p a r t i c i p a t e i n t h i s s u r v e y a n d d o n ' t w a n t t o r e c e i v e a n y m o r e i n v i t a t i o n s p l e a s e c l i c k t h e f o l l o w i n g l i n k : { O P T O U T U R L } I f y o u a r e b l a c k l i s t e d b u t w a n t t o p a r t i c i p a t e i n t h i s s u r v e y a n d w a n t t o r e c e i v e i n v i t a t i o n s p l e a s e c l i c k t h e f o l l o w i n g l i n k : { O P T I N U R L } " e n
S L s u r v e y l s _ e m a i l _ r e m i n d _ s u b j R e m i n d e r t o p a r t i c i p a t e i n a s u r v e y e n
S L s u r v e y l s _ e m a i l _ r e m i n d " D e a r { F I R S T N A M E } , R e c e n t l y w e i n v i t e d y o u t o p a r t i c i p a t e i n a s u r v e y . W e n o t e t h a t y o u h a v e n o t y e t c o m p l e t e d t h e s u r v e y , a n d w i s h t o r e m i n d y o u t h a t t h e s u r v e y i s s t i l l a v a i l a b l e s h o u l d y o u w i s h t o t a k e p a r t . T h e s u r v e y i s t i t l e d : " " { S U R V E Y N A M E } " " " " { S U R V E Y D E S C R I P T I O N } " " T o p a r t i c i p a t e , p l e a s e c l i c k o n t h e l i n k b e l o w . S i n c e r e l y , { A D M I N N A M E } ( { A D M I N E M A I L } ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - C l i c k h e r e t o d o t h e s u r v e y : { S U R V E Y U R L } I f y o u d o n o t w a n t t o p a r t i c i p a t e i n t h i s s u r v e y a n d d o n ' t w a n t t o r e c e i v e a n y m o r e i n v i t a t i o n s p l e a s e c l i c k t h e f o l l o w i n g l i n k : { O P T O U T U R L } " e n
S L s u r v e y l s _ e m a i l _ r e g i s t e r _ s u b j S u r v e y r e g i s t r a t i o n c o n f i r m a t i o n e n
S L s u r v e y l s _ e m a i l _ r e g i s t e r " D e a r { F I R S T N A M E } , Y o u , o r s o m e o n e u s i n g y o u r e m a i l a d d r e s s , h a v e r e g i s t e r e d t o p a r t i c i p a t e i n a n o n l i n e s u r v e y t i t l e d { S U R V E Y N A M E } . T o c o m p l e t e t h i s s u r v e y , c l i c k o n t h e f o l l o w i n g U R L : { S U R V E Y U R L } I f y o u h a v e a n y q u e s t i o n s a b o u t t h i s s u r v e y , o r i f y o u d i d n o t r e g i s t e r t o p a r t i c i p a t e a n d b e l i e v e t h i s e m a i l i s i n e r r o r , p l e a s e c o n t a c t { A D M I N N A M E } a t { A D M I N E M A I L } . " e n
S L s u r v e y l s _ e m a i l _ c o n f i r m _ s u b j C o n f i r m a t i o n o f y o u r p a r t i c i p a t i o n i n o u r s u r v e y e n
S L s u r v e y l s _ e m a i l _ c o n f i r m " D e a r { F I R S T N A M E } , t h i s e m a i l i s t o c o n f i r m t h a t y o u h a v e c o m p l e t e d t h e s u r v e y t i t l e d { S U R V E Y N A M E } a n d y o u r r e s p o n s e h a s b e e n s a v e d . T h a n k y o u f o r p a r t i c i p a t i n g . I f y o u h a v e a n y f u r t h e r q u e s t i o n s a b o u t t h i s e m a i l , p l e a s e c o n t a c t { A D M I N N A M E } o n { A D M I N E M A I L } . S i n c e r e l y , { A D M I N N A M E } " e n
S L s u r v e y l s _ d a t e f o r m a t 1 e n
S L s u r v e y l s _ a t t r i b u t e c a p t i o n s a : 0 : { } e n
S L e m a i l _ a d m i n _ n o t i f i c a t i o n _ s u b j R e s p o n s e s u b m i s s i o n f o r s u r v e y { S U R V E Y N A M E } e n
S L e m a i l _ a d m i n _ n o t i f i c a t i o n " H e l l o , A n e w r e s p o n s e w a s s u b m i t t e d f o r y o u r s u r v e y ' { S U R V E Y N A M E } ' . C l i c k t h e f o l l o w i n g l i n k t o r e l o a d t h e s u r v e y : { R E L O A D U R L } C l i c k t h e f o l l o w i n g l i n k t o s e e t h e i n d i v i d u a l r e s p o n s e : { V I E W R E S P O N S E U R L } C l i c k t h e f o l l o w i n g l i n k t o e d i t t h e i n d i v i d u a l r e s p o n s e : { E D I T R E S P O N S E U R L } V i e w s t a t i s t i c s b y c l i c k i n g h e r e : { S T A T I S T I C S U R L } " e n
S L e m a i l _ a d m i n _ r e s p o n s e s _ s u b j R e s p o n s e s u b m i s s i o n f o r s u r v e y { S U R V E Y N A M E } w i t h r e s u l t s e n
S L e m a i l _ a d m i n _ r e s p o n s e s " H e l l o , A n e w r e s p o n s e w a s s u b m i t t e d f o r y o u r s u r v e y ' { S U R V E Y N A M E } ' . C l i c k t h e f o l l o w i n g l i n k t o r e l o a d t h e s u r v e y : { R E L O A D U R L } C l i c k t h e f o l l o w i n g l i n k t o s e e t h e i n d i v i d u a l r e s p o n s e : { V I E W R E S P O N S E U R L } C l i c k t h e f o l l o w i n g l i n k t o e d i t t h e i n d i v i d u a l r e s p o n s e : { E D I T R E S P O N S E U R L } V i e w s t a t i s t i c s b y c l i c k i n g h e r e : { S T A T I S T I C S U R L } T h e f o l l o w i n g a n s w e r s w e r e g i v e n b y t h e p a r t i c i p a n t : { A N S W E R T A B L E } " e n
S L s u r v e y l s _ n u m b e r f o r m a t 0 e n
G M Y Q U E S T I O N G R O U P 1 e n
Q 5 q 1 1 q 1 e n N 1
Q 5 q 2 1 q 2 e n N 1
Q 5 q 3 1 q 3 e n N 1
Q 5 q 4 1 q 4 e n N 1
Q 5 q 5 1 q 5 e n N 1
Q 5 q 6 1 q 6 e n N 1
Q T q 7 1 A d d i t i o n a l c o m m e n t s . e n N 1 1 | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 120931 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | Mysql 5.3 | ||||
| Server OS (if known) | Windows XP | ||||
| Webserver software & version (if known) | XAMPP | ||||
| PHP Version | 5.3 | ||||
 |
There are several issues showing here: The Datecreated field in the TSV contains an invalid date format |
 |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9622 |
|
|
The patch fixes the most pressing problem. Better validation is desirable, and although it could be implemented now, it may make sense to wait for 2.1 since the Question Objects code contains all of the needed validation tables/arrays. |
|
|
New version 2.00+ build 121005 released. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-10-01 19:09 | TMSWhite | New Issue | |
| 2012-10-01 19:09 | TMSWhite | File Added: Survey_debug_test2 (1).txt | |
| 2012-10-02 09:28 | c_schmitz | Assigned To | => c_schmitz |
| 2012-10-02 09:28 | c_schmitz | Status | new => assigned |
| 2012-10-02 09:30 | c_schmitz | Note Added: 20968 | |
| 2012-10-03 00:46 | TMSWhite | Changeset attached | => LimeSurvey master 49da6fb4 |
| 2012-10-03 00:46 | TMSWhite | Note Added: 20997 | |
| 2012-10-03 00:46 | TMSWhite | Assigned To | c_schmitz => TMSWhite |
| 2012-10-03 00:46 | TMSWhite | Resolution | open => fixed |
| 2012-10-03 00:48 | TMSWhite | Note Added: 20998 | |
| 2012-10-03 00:48 | TMSWhite | Status | assigned => resolved |
| 2012-10-05 15:26 | c_schmitz | Note Added: 21086 | |
| 2012-10-05 15:26 | c_schmitz | Status | resolved => closed |
