[Rakesh Kumar]

Sir,

I want to import from excel file not converting excel to csv or tab delimited to a pdf form fields…… i have 5 column in excel of which one column in unique ID .. i want that when i enter unique id in pdf form it should show the corresponding data from excel .. i can keep both pdf form and excel file in same folder….

again . i don’t want excel file to be converted to csv or delimited.

Thanks

[Rakesh Kumar]

Thanks, it is now working for me.

also, i have sent 2 or 3 issue on your email.. plz check and let me know if its possible.

Thanks again.

[Rakesh Kumar]

Sir,

Attached is the video link  from downloading the file to testing it .. and error which console shows.

https://www.dropbox.com/s/pmpgu1bodg0d7f6/issue.avi?dl=0

Please have a look. Hope this would help to solve the issue.

Thanks

[Rakesh Kumar]

Thanks for the updated version… but this also not working………….

I will send you video of the same, if that would help in sorting out the issue.

Thanks

[Rakesh Kumar]

Sir,

Somehow your script is not working and throwing an error in console ,

ReferenceError: val is not defined
8:Field:Mouse Up

Thanks

[Rakesh Kumar]

@Bebarth

please check your email, the issue has been solved and i have sent you the working pdf file on your email.. plz check and let me to know if it can be improved.

thanks

[Rakesh Kumar]

Sir,

The script is not working as intended…. this script is highlighting the first 3 entry of an array after sorting it in ascending ….. however i want the first 3 smallest number in the array to be highlighted after sorting… ie. removing the duplicates in the array.

for ex –  original array = [8,3,4,2,2,2,3,5,6,4]   
            after sorting the array will be  = [2,2,2,3,3,4,4,5,6,8]
          so current script is highlighting  2,2,2  but my requirement is to highlight every entry which equal to 2,3,4  .

Hope i was able to explain.
Same for the greatest one.  it should highlight first 3 greatest number after sorting in descending order avoiding duplicates.

thanks.

[Rakesh Kumar]

Sir,

I want both comments , highlighted text  to be extracted.
@Berlin Sir,  i didnot remove the old js file.

Thanks

[Rakesh Kumar]

Yes, i did exactly the same, i am the getting menu also,, but when i click the menu the highlighted text  is shown in console, and after i copy your 2 line script to console and run it deletes all the pages except for first page of the original file and save it save As with just the content of the first page of the original file .

[Rakesh Kumar]

Sir,

This isn’t working,  when i run the script from the console it deletes all pages and left with first page of the document  .

[Rakesh Kumar]

Still no menu showing up under the edit menu

[Rakesh Kumar]

@Merlin

Sir,

I did the same , but still no menu is visible under Edit.

Thanks

[Rakesh Kumar]

The second script is a menu item, but i don’t know if it works for both pro and reader … I tested on pro .. it works on pro but not sure about reader ….. will be helpful if it works on both.

[Rakesh Kumar]

@Merlin

Sir,
I copied the script but the same is not showing in the acrobat pro

[Rakesh Kumar]

the second script in the text file gives us the highlighted text also  (plz check the text file i sent you the script after Thoms script it is a menu type option.  it gives me the highlighted , commented etc text.. but it prints the texts in the console…… plz check that script.  My requirement is exactly the same as given in that script but instead of printing in console it should be in pdf

[Rakesh Kumar]

Sir,

Request you to please edit the Mr. Thom’s script except for changing the export file as *.xls to *.pdf  and make it a standalone file and not as an attachment.

I want all the highlighted text, commented text  to be in the reports in the following format:

-Some Heading on top of page-

Page No.  –  Annotation type  –  Text1      (here annotation type is optional, i.e make it such a way that they can be commented out in script if necessary)
Page No.  –  Annotation type  – Text2
Page No.  –  Annotation Type – Text3
and so on….
doesnot matter if this is in single field or multiple field
Thanks

[Rakesh Kumar]

@Merlin 

Sir,
I want the comments report that works on acrobat pro as well,  in this tool it says only for acrobat Reader.

Thanks

[Rakesh Kumar]

the batch script i found at : https://acrobatusers.com/actions-exchange/        go to this page and select acrobat XI  and look for Create comment summary.
XI
and the other one i didnot remember as i had saved it a long ago.

[Rakesh Kumar]

Sir,

Attached is the batch script i found from Mr. Thom Parkers blog …. I need few changes in that.

1) the exported file should be in PDF format
2) it should not be in attachments. ,, the file which generates should be the actual file without summary (for now).
3) the format should be:

  -Some Heading –

Page No. – Type of annotation (this is optional) – Text1
Page No. – Type of annotation (optional)- Text2
and so on ..
also if possible some where in the page the time and date when the file is generated (this should i be able to hide / show according to my future requirement).

I have one other script i found on Adobe Acrobat official forum which does exactly which i want but it prints the data in console not in pdf. below is that script hope that also helps

Adobe script in after the thom’s script.

Thanks
@Bebarth

[Rakesh Kumar]

I got the solution to my issue on the AEM community  by radzmar and below is the script which solved my issue (incase someone else needs it). To get the context download my form which i shared in my original post.

form1.MSF.SF_Notable.SF1.RB :: enter – (JavaScript, client)  var oRows = Table1.resolveNodes (‘Row2. [Cell1 ne « -Select-« ]’), oNode, oItems, i, j, n, cValue; this.clearItems (); for (i = 0; i

• ’); n = 0;  if (oNode.Cell1.rawValue === « Example Other Member ») { cValue = oNode.Cell2.rawValue; } else { cValue = oNode.Cell1.rawValue; }  for (j = 0; j

[/list]

[Rakesh Kumar]

I have found a turnaround after looking for over 6 hours in the AEM Forum but still not found the full proof solution. Hope anyone answers ……. I personally messaged to the Top members / experts on that forum but no response (positive / negative).

[Rakesh Kumar]

I am talking about offline AEM Designer Forms

[Rakesh Kumar]

I have already posted this issue in that forum but with no luck ..

[Rakesh Kumar]

@bebarth no, its fine now i am now on this forum for more than 8 months, i am able to understand atleast the scripts, if i don’t i use the translator, so its fine …

many many thanks.

[Rakesh Kumar]

michel c.

Use this:

var t1 = this.getField (« Number1 »). valueAsString;
var t2 = this.getField (« Number2 »). valueAsString;

var t3 = t1 + « / » + t2;
this.getField (« Text1 »). value = simplify (t3); 

[Rakesh Kumar]

Awesome,  thanks bebarth sir, this is what i exactly wanted…… you are great.

Thanks again.

[Auteur]

Réponses