Forum

No semicolon in CSV...
 
Notifications
Retirer tout

No semicolon in CSV export

21 Posts
4 Utilisateurs
0 Reactions
5,432 Vu
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 
[#8853]

Hello,

I'm actually setting up a second instance of ProjeQtOr for testing and migration. Now I have the problem that when exporting components within new instance using ; as delimter the semicolon is missing within the export file. In the old instance it works.
I can't find the difference in both systems (I'm using a docker container which I copied from one PC to another with same but newly installed OS).

Any sugestion were I can search for the reason?

Thanks
Ronny 


 
Posté : 06/04/2023 5:10 pm
(@babynus)
Posts: 14952
Membre Admin
 

Check global parameters for definition of the separator for csv files.
(be sure to save the parameters)


 
Posté : 06/04/2023 7:57 pm
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 

In global parameters as well as in export window ; is set as separator. Nevertheless any separator is missing within export file.


 
Posté : 11/04/2023 9:02 am
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 

Another thing I observed: Changing delimiter to comma within export window is stored an reloaded again when trying another export. Changing it back to semicolon shows empty separator when opening export window for another export...


 
Posté : 11/04/2023 10:53 am
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 

Do you have any further suggestion regarding this issue? We want to use import and export but semicolon still doesn't work and when exporting using comma the columns are "jumping" around because comma seams not to be the same in each row.


 
Posté : 13/06/2023 8:55 am
(@babynus)
Posts: 14952
Membre Admin
 

Any screenshot please ?


 
Posté : 13/06/2023 12:14 pm
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 

Do you like screenshots from Excel? ProjeQtOr looks normal except for separator selection is empty after using semicolon.


 
Posté : 13/06/2023 2:26 pm
 ADBA
(@adba)
Posts: 6
Active Member
 

Hello,

I also encounter this problem of semicolon missing for all exports.

I was on 10.4.4 version and updated to 10.4.5. I even tried on 11.0.1 but the problem is still here.

Please find a screenshot in attachments to watch the results.

 


 
Posté : 16/10/2023 11:18 am
(@babynus)
Posts: 14952
Membre Admin
 

I guess you did not migrate as defined : just overwrite existing code.
So possibly you lost some global parameters.
Plea&se check all your global parameters, including CSV separator definition.


 
Posté : 16/10/2023 11:36 am
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 

Hello,

I don't think that's the problem since it seems to be correct:

 

Nevertheless semicolon as separator will be removed after export.

 


 
Posté : 18/10/2023 10:06 am
jmmbb
(@jmmbb)
Posts: 561
Noble Member
 

Hello,

i'm in V 11.0.1 and export works fine...


 
Posté : 18/10/2023 1:15 pm
 ADBA
(@adba)
Posts: 6
Active Member
 

We followed the update instructions :

  • Disconnect all connected users (via the administration screen) and possibly "close the application" 
  • Backup database (not mandatory, but this is always a good practice)
  • Download the archive projeqtorVx.y.z.zip of the new version on the web site 
  • Unzip the archive projeqtorVx.y.z.zip to the web directory of your PHP server (overwriting existing)
  • Run the application in your favorite browser using the URL http://yourserveur/projeqtor  
  • Log in with an administrator account (access is blocked for other users) 
  • Upon connection, the database will be automatically updated (this may take few minutes)

Global settings looks corrects and exports settings also but CSV exported is still without semicolons :

PS : We use 2 separate dockers instances of ProjeQtOr (Prod and PréProd) and both have the same issue.


 
Posté : 18/10/2023 1:32 pm
(@robra81)
Posts: 106
Estimable Member
Début du sujet
 

Maybe this could be a hint (a screenshot from within our docker container):

 

??


 
Posté : 18/10/2023 4:08 pm
 ADBA
(@adba)
Posts: 6
Active Member
 

Just to be clear, in our case, we updated one instance (Prod, where semicolons was not working for semicolons) in last version but it's still not working.

We also created a new instance (new database and new www directory) but we still have the semicolons problem for export.

Do you have any more suggestions ? We don't know what to do to start on a clean situation.


 
Posté : 24/10/2023 11:29 am
(@babynus)
Posts: 14952
Membre Admin
 

Can you please send a result file as tempalte ?
(raw export without opening it)


 
Posté : 26/10/2023 10:57 am
Page 1 / 2
Share:
Retour en haut