Reg: Agile automation

Hello All,

Anyone know about “Automation file uploading process or kit” how to create that and how its working on there. i was read the “Agile Import and Export” Case study but i don’t get the idea. that is like a theory, but i need some examples.

Anyone interested please advice.

Advance thanks  to all members and angels.

Maddy

No Files Were Attached
Add Comment
6 Answer(s)

Maddy,

Just a quick query to understand this problem. So are you trying to import items or attachments. If you can describe the problem.

Arif Agile Angel Answered on March 12, 2018.

Hi Arif,

Its attachments. To uploaded in ECO more the 50 Items.

Thanks for your interest.
Maddy

on March 12, 2018.
Add Comment

Okay in that case you can do the following:

1. Have all your attachment dumped into a folder.
2. Prepare the index file as follow:
CHANGE,ECO-XXXX,,C:/Path1/Path2/File1.xlsx,FILE,,
3. Save this index file with any name e.g. Change_Upload_Index.txt
4. Open File Load Utility, you can open from either Java/Web-client but preferred is Java-client.
5. Typical screenshot of the same is below: 
You can follow along that
6. Click OK and file upload should complete

Some Key
1. Index File Creation : CHANGE ( Primary Key word), ECOXXXX(Your change number), , (Secondary key word should be kept as blank), File-Path(Path of the file on your machine) ,”Description”(You can keep it as blank)
2. Ensure that file path has “/” instead of “\” this is one of the common mistakes once does.

After Every upload that you do three files are generated:

XXX_Summary,XXX_Log, XXX_BAD,XXX_LOADED ( Here XXX is nothing but your index file name) . So you can refer to the _BAD files or _LOG files to see and verify for errors.

Regards,
Arif

Arif Agile Angel Answered on March 12, 2018.

Hi Arif,

Thanks for advice,

can you please provide any example index file (.txt).

Thanks,
Maddy

on March 13, 2018.

Madan i am not seeing any option to add attachment. You can modify CHANGE,ECO-XXXX,,C:/Path1/Path2/File1.xlsx,FILE,,
and save it as a text file to continue with work.

on March 19, 2018.
Add Comment

Please share any example inder file

Gurmeet Agile User Answered on May 1, 2018.
Add Comment

Hi Gurmeet,

Just copy and paste the index into any text file and save as “Somenamx.txt”

Sample Index file for a change :
CHANGE,ECO-XXXX,,C:/Path1/Path2/File1.xlsx,FILE,,

Regards,
Arif

Arif Agile Angel Answered on May 1, 2018.

Can you share any dummy collection of files for File load activity ,I will make them index and do experiment in my demo environment

on May 2, 2018.
Add Comment

Hi Arif

Can you share any dummy collection of files for File load activity ,I will make them index and do experiment in my demo environment

Gurmeet Agile User Answered on May 2, 2018.
Add Comment

Hi Gurmeet,

I don’t have dummy files however you can use any kind of .xls, .pdf or .doc file that you have in your desktop and use it in lower environment for testing. It doesn’t need to be a specific file for testing.

I have attached here one Index file, in this file you can mention the path to any dummy file present in your desktop and try it out. The index of the file should be changed as shown below :

ITEM,740-041967,,C:/Users/arifkhan/Desktop/Sample1.pdf,FILE,

Save this in the Index-final.txt and then upload. Hope it helps.

Regards,
Arif

Arif Agile Angel Answered on May 2, 2018.

Ok Arif ,

I also got stuck in one urgent issue as follow

We are generating report for one change  which is connected with another through relationship…we are generating report on release date basis..but we are not getting all records but while not selecting relationship…we are getting all data

we have made search like this

The advanced search should be setup in the following way:

Changes -> <source subclass>  “Relationship Search”  Changes -> <related change subclass>
Criteria: Relationships.<related change subclass>.Cover Page. Released Date <date criteria>…but its showing data

on May 2, 2018.

Hi Arif

What other object can use for attachment…like for item and change we used to write ITEM and CHANGE in index file and leaving 2nd column blank…what we should write for other object and what is the Syntax for other object in index file

on May 8, 2018.
Add Comment

Your Answer

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