| Anonymous | Login | 2013-05-22 15:49 CEST | |
| Main | My View | View Issues | Change Log | Roadmap | Repositories |
| View Issue Details [ Jump to Notes ] [ Related Changesets ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
| 06623 | Bug reports | [All Projects] 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+ | ||||||||
| Target Version | Fixed in Version | ||||||||
| 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 | ||||||||
| I will donate to the project if issue is resolved within 48 hrs | No | ||||||||
| LimeSurvey build number | 120931 | ||||||||
| Browser | |||||||||
| Database & DB-Version | Mysql 5.3 | ||||||||
| Operating System (Server) | Windows XP | ||||||||
| Webserver software & version | XAMPP | ||||||||
| PHP Version | 5.3 | ||||||||
| Attached Files |  Survey_debug_test2 (1).txt [^] (27,232 bytes) 2012-10-01 19:09 [Show Content] [Hide Content]˙ū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
| ||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
 (20968)c_schmitz (administrator) 2012-10-02 09:30 |
There are several issues showing here: *The Datecreated field in the TSV contains an invalid date format *Datecreated should not be imported at all but ignored *The import routine does little to no error reporting if the import fails. |
 (20997)TMSWhite (developer) 2012-10-03 00:46 |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9622 [^] |
|
(20998) TMSWhite (developer) 2012-10-03 00:48 |
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. |
|
(21086) c_schmitz (administrator) 2012-10-05 15:26 |
New version 2.00+ build 121005 released. |
|
Notes |
| Related Changesets |
|||
|
LimeSurvey: master 49da6fb4
Timestamp: 2012-10-02 15:45:40 Author: TMSWhite Committer: Thomas White [ Details ] [ Diff ] |
Fixed issue 06623: imported tab delimited surveys are not visible | ||
| mod - application/helpers/admin/import_helper.php | [ Diff ] [ File ] | ||
| Related Changesets |
|
Issue History |
|||
| 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 |
|
Issue History |
| Copyright © 2000 - 2013 MantisBT Team |
 |