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.

Import CROn
 
Notifications
Clear all

Import CROn

21 Posts
2 Users
0 Reactions
10.1 K Views
(@durou-c)
Posts: 468
Contributor
Topic starter
 
[#4159]

Is it possible to import automatically some documents ?


 
Posted : 02 Mar 2017 14H00
(@babynus)
Posts: 14952
Member Admin
 

Yes.
Define the import deirectory in golbal parameters.
Put your import files in this folder.
But sure CRON is running (see administration screen)


 
Posted : 02 Mar 2017 18H57
(@durou-c)
Posts: 468
Contributor
Topic starter
 

doesnt work.
I put a pdf files on my create directory, and i received this message:

Import ERROR : file HY16105500A-BLOC MOTEUR.PDF imported with errors [ Number of 'HY16105500A-BLOC MOTEUR.PDF' imported : ]

show the log error:

ProjeQtOr

body{font-family:Verdana,Arial,Tahoma,sans-serif;font-size:8pt;}
table{width:100%;border-collapse:collapse;border:1px;}
.messageData{font-size:90%;padding:1px 5px 1px 5px;border:1px solid #AAAAAA;vertical-align:top;background-color:#FFFFFF;}
.messageHeader{border:1px solid #AAAAAA;text-align:center;font-weight:bold;background:#DDDDDD;color:#505050;}.messageERROR{color:red;font-weight:bold;}.messageOK{color:green;}.messageWARNING{color:black;}

ERROR - File Type not recognized
Import aborted
Contact your administrator


 
Posted : 02 Mar 2017 19H12
(@durou-c)
Posts: 468
Contributor
Topic starter
 

Ok I have just read the manual, we only can import CSV and XLSX files !!!

it is not possible to import automatically pdf in document folder ?


 
Posted : 02 Mar 2017 19H28
(@babynus)
Posts: 14952
Member Admin
 

No, not directly.

You must create csv (or xlsx) file that will describe the document (its meta-data) and may include version (that includes file) with possibly link to file you want to include.
You'll find more information in changlog for V6.1


 
Posted : 02 Mar 2017 23H31
(@durou-c)
Posts: 468
Contributor
Topic starter
 

tks, what's changlog for V6.1, where i can find it ?


 
Posted : 03 Mar 2017 10H57
(@babynus)
Posts: 14952
Member Admin
(@durou-c)
Posts: 468
Contributor
Topic starter
 

there is some mistake:

Import ERROR : file MPHY16105217A-Hublot.pdf imported with 1 errors [ Number of 'MPHY16105217A-Hublot.pdf' imported : 0 ]
Import INVALID : file Document_20170303_101500.csv imported with 1 control errors [ Number of 'Document' imported : 0 ]


 
Posted : 03 Mar 2017 12H18
(@babynus)
Posts: 14952
Member Admin
 

1) imported file (pdf) should not be on smae folder (possibly you can store it is a sub-folder)
2) Control error should be logged in log file...


 
Posted : 03 Mar 2017 12H22
(@durou-c)
Posts: 468
Contributor
Topic starter
 

Log files error of csv


 
Posted : 03 Mar 2017 12H24
(@durou-c)
Posts: 468
Contributor
Topic starter
 

log file error of pdf file


 
Posted : 03 Mar 2017 12H28
(@babynus)
Posts: 14952
Member Admin
 

1) Remove pdf file from import directory
2) Locatrion (emplacement) should reference an existing directory defined in projeqtor (tyry and export document list in csv format to get an exemple)


 
Posted : 03 Mar 2017 12H35
(@durou-c)
Posts: 468
Contributor
Topic starter
 

document is created on data base, but the pdf file is not transfert and not linked ...

Import ERROR : file MPHY16105217A-Hublot.pdf imported with errors [ Number of 'MPHY16105217A-Hublot.pdf' imported : ]
Import OK : file Document_20170303_105000.csv imported with no error [ Number of 'Document' imported : 1 ]


 
Posted : 03 Mar 2017 12H53
(@durou-c)
Posts: 468
Contributor
Topic starter
 

It's ok.
import new document: OK
linked pdf files: OK
automatic moved pdf files on good place: ok

I show the document on projeqtor, with the link. But when I click on preview or dowload I show this message...


 
Posted : 03 Mar 2017 14H21
(@babynus)
Posts: 14952
Member Admin
 

Can you try with another file to check this one is not corrupted ?
For instance, try with a text file...
Maybe you transfered file to server as text instead of binary mode.


 
Posted : 03 Mar 2017 14H24
(@durou-c)
Posts: 468
Contributor
Topic starter
 

I try with test.txt file, it's import, database and file... but when I open or preview it, it's open but empty.

but when I go directly on folder /home/projeqtor/documents/Produits/plans/mécanique/ i find it and when I open it it's ok the txt file is full of the good text (like pdf also)
I thinf sotfware Projeqtor cannot read/preview import file !


 
Posted : 03 Mar 2017 16H35
(@durou-c)
Posts: 468
Contributor
Topic starter
 

How can i transfert file in binary mode?


 
Posted : 03 Mar 2017 17H25
(@durou-c)
Posts: 468
Contributor
Topic starter
 

When I try to open it, on the window of acrobat it's write 0 octet...
!!!
but when i go directly on the upload file folder, it's 172Ko...

what's wrong ?


 
Posted : 03 Mar 2017 18H10
(@durou-c)
Posts: 468
Contributor
Topic starter
 

an other point is "Projeqtor" during automatic import add (-A) at the end of the file... (see picture attached)

but on the file folder file name is MPHY16105217A-Hublot.PDF.181


 
Posted : 03 Mar 2017 18H13
(@durou-c)
Posts: 468
Contributor
Topic starter
 

ok, it's works but i must to enter the size in octets on taille de fichier(Version de document)...

it's not easy to find the size and enter the size of file for each file, if i have 50 lines on my csv, i must to enter the 50 size ... not so simple !!!


 
Posted : 03 Mar 2017 18H49
(@babynus)
Posts: 14952
Member Admin
 

Ticket #2593 recorded to improve import (recalculate file size insted of requesting it)


 
Posted : 04 Mar 2017 19H45
Share:

Scroll to Top