In Agile PLM 9.2.2.4, I am trying to use FileLoad Function but getting following Error.

Below Import file I have created for Uploading file in DMR attachment.
ITEM, DMR167254, 00, file://YY022002/Share/Agile_Hammerhead/Agile_Hammerhead/Hammerhead%20Windchil%20PDF/452212876680_110m_1_approved.pdf FILE, Ring_Check

But I got below errors.

Row #1:ITEM|DMR16725400|00|file://YY022002/Share/Agile_Hammerhead/Agile_Hammerhead/Hammerhead%20Windchil%20PDF/452212876680_110m_1_approved.pdf|FILE|RING_FILE|20/06/2016
Number of fields provided is less than the minimum required.

or 

Row #1:ITEM,DMR16725400,00,file://YY022002/Share/Agile_Hammerhead/Agile_Hammerhead/Hammerhead%20Windchil%20PDF/452212876680_110m_1_approved.pdf,FILE,RING_FILE,20/06/2016
The attribute Name-Value separator was not found or the attribute value is empty.

Please support me so that I can upload file using FILELOAD Function.

Add Comment
3 Answer(s)

Are you using file load on the web client or javaclient

I see issues where you use pipe ‘|’ as separator in one row and comma ‘,’ elsewhere depending on what you have set a the separator character for file load will see it as a single string or a series of separated strings.

Agile Angel Answered on June 20, 2016.
Add Comment

Based on the error messages, you are having issues with your delimiters. Make sure that you are consistent in what you use as a delimiter, and that it is specified when you run FileLoad. Comma is the default for the field delimiter, but since it is commonly used in file names and description, I normally use the pipe. But you must tell FileLoad what you are using, as it will not auto-detect. And make sure that you do not have any of the default delimiter values (Attribute Name-Value Separator, for example) in your record because it *will* cause problems when it sees them. You can also leave the “%20” stuff out of the file name, just put a blank in there, FileLoad won’t care.
 And as Adrian said, which version of FileLoad you are using can also affect how it works (the Java client version is much better than the web client version). Find and read the Import Export Guide chapter on FileLoad if you have not yet done so.

Agile Angel Answered on June 20, 2016.
Add Comment

By default an index file for Fileload should contain in each row 6 values separetad by an attribute delimiter (which is a parameter in Fileload interface): ObjectType, PrimaryKey, SecondaryKey, Path/Filename, AttachType, Description.
In case you need to to populate additional attributes, you need to continue the row with pairs of attribute name and attribute value which are separated by different delimiter from the delimiter used for the rest of the Index row (= is the default attribute name-value separator).
For example, a row should look like:
ITEM|DMR16725400|00|file://YY022002/Share/Agile_Hammerhead/Agile_Hammerhead/Hammerhead%20Windchil%20PDF/452212876680_110m_1_approved.pdf|FILE|RING_FILE|Date01=20/06/2016

Agile Angel Answered on June 20, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.