Regular Contributor.. PGH Regular Contributor..
Regular Contributor..
576 views

dataport - illegal characters

Jump to solution

Hello - hoping someone might have some ideas about an issue we are experiencing with DataPort.

When importing documents some are throwing the error:

Error retreiving the next object. Reasons to follow: ID: XX Uri: 0 Details: Illegal characters in path

We can't seem to find the illegal characters preventing the import however when we drag and drop it manually into HPECM it has no issues.

Any ideas? Thanks in advance.

0 Likes
1 Solution

Accepted Solutions
Highlighted
Sten28 Outstanding Contributor.
Outstanding Contributor.

Re: dataport - illegal characters

Jump to solution

I am going to cheat a bit here, and paste a comment of mine from a similar thread: How to add line break to notes field using import with dataport?

Excel adds in quotes when saving to Text when the cell contains a comma.

You must remove these quotes before running the file in DataPort, otherwise you may run into import issues.

The simplest way to do this is to open your text file in a text editor (e.g. Notepad++ or TextPad) and use Find/Replace to remove all quotes - see attached image for an example.

Because of the comma in your File Location, it will save in your import file with quotes, i.e.:

"O:\InfoMgt\Z\AAC11_11111-Kkkk,Yyyy-4444444-Vvvvvvvvvv_Eeeeee_Ssssssss_PTY_LTD-8888\training_contract-yyyy_kkkk-28tpi.pdf"

By saving your import file as Unicode Text, then using notepad++ to remove the quote marks, it should allow your import file to process without issue.

12 Replies
TRIMGuru Acclaimed Contributor.
Acclaimed Contributor.

Re: dataport - illegal characters

Jump to solution

Would it be possible to show the path to the electronic documents you seleted in Dataport along with the name of the file?

0 Likes
usmc1
New Member.

Re: dataport - illegal characters

Jump to solution
illegal spaces = spaces. Delete spacing in the file names
0 Likes
MichaelQ Super Contributor.
Super Contributor.

Re: dataport - illegal characters

Jump to solution
The path referred to is the location of the file and is most likely illegal
due to the filename. Investigate the filepath property of your import file.
Regular Contributor.. PGH Regular Contributor..
Regular Contributor..

Re: dataport - illegal characters

Jump to solution

I should note that during this import process - some files import successfully others do not.

We did some additional troubleshooting with no luck also:

  • Rerunning the import after eliminating dashes “-“ from the file title – error still there.
  • Then rerun import after eliminating underscores “_” from title – same error.
  • Even tried removing the “,.PDF” from the file title with same error present.
  • So all these three variables are eliminated as not being cause of error.
  • Tried renaming the file title completely (But keeping the .pdf file definition) and STILL got the same error.
0 Likes
Regular Contributor.. PGH Regular Contributor..
Regular Contributor..

Re: dataport - illegal characters

Jump to solution
I will get that as soon as possible and post it here. Thanks
0 Likes
Regular Contributor.. PGH Regular Contributor..
Regular Contributor..

Re: dataport - illegal characters

Jump to solution

here is an example of the file path and doc being imported that is failing

FILE PATH

O:\InfoMgt\Z\AAC11_11111-Kkkk,Yyyy-4444444-Vvvvvvvvvv_Eeeeee_Ssssssss_PTY_LTD-8888\training_contract-yyyy_kkkk-28tpi.pdf

FILE TITLE

training_contract-yyyy_kkkk-28tpi.pdf

 

 

0 Likes
TRIMGuru Acclaimed Contributor.
Acclaimed Contributor.

Re: dataport - illegal characters

Jump to solution

In your path example above, there is a comma in the path name, is that correct?

O:\InfoMgt\Z\AAC11_11111-Kkkk,Yyyy-4444444-Vvvvvvvvvv_Eeeeee_Ssssssss_PTY_LTD-8888\training_contract-yyyy_kkkk-28tpi.pdf

0 Likes
Regular Contributor.. PGH Regular Contributor..
Regular Contributor..

Re: dataport - illegal characters

Jump to solution
yes that's correct but oddly enough other documents from that same path (folder) imported successfully.
0 Likes
JasonIMEX Outstanding Contributor.
Outstanding Contributor.

Re: dataport - illegal characters

Jump to solution

If you are using a CSV file for the import commas in the file path are going to mess up the values. 

HP Records management suite specialists
www.imexwa.com.au
0 Likes
Regular Contributor.. PGH Regular Contributor..
Regular Contributor..

Re: dataport - illegal characters

Jump to solution
So using a CSV file would explain why some work and some don't? from the exact same file paths?
0 Likes
JasonIMEX Outstanding Contributor.
Outstanding Contributor.

Re: dataport - illegal characters

Jump to solution
No it wouldnt.. But having commas in the file path and trying to separate with commas is a possible issue.. Can you change it to a TAB separated instead maybe?
HP Records management suite specialists
www.imexwa.com.au
Highlighted
Sten28 Outstanding Contributor.
Outstanding Contributor.

Re: dataport - illegal characters

Jump to solution

I am going to cheat a bit here, and paste a comment of mine from a similar thread: How to add line break to notes field using import with dataport?

Excel adds in quotes when saving to Text when the cell contains a comma.

You must remove these quotes before running the file in DataPort, otherwise you may run into import issues.

The simplest way to do this is to open your text file in a text editor (e.g. Notepad++ or TextPad) and use Find/Replace to remove all quotes - see attached image for an example.

Because of the comma in your File Location, it will save in your import file with quotes, i.e.:

"O:\InfoMgt\Z\AAC11_11111-Kkkk,Yyyy-4444444-Vvvvvvvvvv_Eeeeee_Ssssssss_PTY_LTD-8888\training_contract-yyyy_kkkk-28tpi.pdf"

By saving your import file as Unicode Text, then using notepad++ to remove the quote marks, it should allow your import file to process without issue.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.