Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

No semicolon in CSV...
 
Notifications
Clear all

No semicolon in CSV export

21 Posts
4 Users
0 Reactions
5,479 Views
(@robra81)
Posts: 106
Active Member
Topic starter
 
[#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 


 
Posted : 06 Apr 2023 17H10
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 06 Apr 2023 19H57
(@robra81)
Posts: 106
Active Member
Topic starter
 

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


 
Posted : 11 Apr 2023 9H02
(@robra81)
Posts: 106
Active Member
Topic starter
 

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...


 
Posted : 11 Apr 2023 10H53
(@robra81)
Posts: 106
Active Member
Topic starter
 

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.


 
Posted : 13 Jun 2023 8H55
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Any screenshot please ?


 
Posted : 13 Jun 2023 12H14
(@robra81)
Posts: 106
Active Member
Topic starter
 

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


 
Posted : 13 Jun 2023 14H26
 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.

 


 
Posted : 16 Oct 2023 11H18
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 16 Oct 2023 11H36
(@robra81)
Posts: 106
Active Member
Topic starter
 

Hello,

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

 

Nevertheless semicolon as separator will be removed after export.

 


 
Posted : 18 Oct 2023 10H06
jmmbb
(@jmmbb)
Posts: 561
Contributor
 

Hello,

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


 
Posted : 18 Oct 2023 13H15
 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.


 
Posted : 18 Oct 2023 13H32
(@robra81)
Posts: 106
Active Member
Topic starter
 

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

 

??


 
Posted : 18 Oct 2023 16H08
 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.


 
Posted : 24 Oct 2023 11H29
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 26 Oct 2023 10H57
 ADBA
(@adba)
Posts: 6
Active Member
 

Please find an export in attachments.

I have to open it and rename some key information. I can send you a raw file by email or private message but I didn't find the functionality.

 


 
Posted : 26 Oct 2023 11H48
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Strange...
Did you try to replace Separator with comma (,) ?


 
Posted : 26 Oct 2023 12H55
 ADBA
(@adba)
Posts: 6
Active Member
 

Yes and it works with comma but it's unusable because I can't just replace comma by semicolon (some data contains comma).


 
Posted : 26 Oct 2023 13H38
(@robra81)
Posts: 106
Active Member
Topic starter
 

Same here: when using comma columns are strange because data contains comma


 
Posted : 26 Oct 2023 14H08
 ADBA
(@adba)
Posts: 6
Active Member
 

Do you have any clue to check in "deep" parameters / conf' (php file or database) ?


 
Posted : 23 Nov 2023 14H04
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

No, no idea, and difficult to analyse as we cannot reproduce.


 
Posted : 28 Nov 2023 19H36
Share:

Scroll to Top