I want to extract and sort data in other PDF files ...

Apr 22, 2020

Copy link to clipboard

Copied

Perhaps this is a basic question about an array.  

 

And I'm sorry, this is a question to all that how to write code as an answer.  

I have no experience writing code for arrays. 

 

I have read various descriptions about arrays, but I am not sure how to realize it with PDF in front of me.

 

====

 

I would like to know the following cases.
The First PDF file has fields with the following contents.

 

This is a list of equipment maintenance replacement parts.
Parts to be replaced are lined up at regular intervals.

 

Actually, there are more items both vertically and horizontally, but it is like this when simplified.  There are over 100 pages.

 

From left to right ("Field Name")

Time Unit / Cumulative Time / Implementation Date / Part Name / Selling Price

 

"TU1"     "CT1"     "ID1"     "PN1"     "SP1"
"TU2"     "CT2"     "ID2"     "PN2"     "SP2"
"TU3"     "CT3"     "ID3"     "PN3"     "SP3"
"TU4"     "CT4"     "ID4"     "PN4"     "SP4"
"TU5"     "CT5"     "ID5"     "PN5"     "SP5"
"TU6"     "CT6"     "ID6"     "PN6"     "SP6"
"TU7"     "CT7"     "ID7"     "PN7"     "SP7"
"TU8"     "CT8"     "ID8"     "PN8"     "SP8"
"TU9"     "CT9"     "ID9"     "PN9"     "SP9"
"TU10"   "CT10"   "ID10"   "PN10"    "SP10"
"TU11"   "CT11"   "ID11"    "PN11"    "SP11"

"TU1000"   "CT1000"   "ID1000"    "PN1000"    "SP1000"

 

This field will increase in the future.

 

As the Implementation Date, the date of the result calculated by JavaScript based on the cumulative time is entered.  Actually, there are other fields such as start date.

 

So, the data is arranged as follows.  In short, it is like Excel with a beautifully designed background.  Actually I wanted to make it in Excel, but for several reasons I'm making it directly in PDF.

 

<3000>     <3000>    <day1>  <name1> <price1>
<3000>     <6000>    <day2>  <name1> <price1>
<3000>     <9000>    <day3>  <name1> <price1>
<3000>   <12000>    <day4>  <name1> <price1>
<3000>   <15000>    <day5>  <name1> <price1>
<3000>   <18000>    <day6>  <name1> <price1>
<3000>   <21000>    <day7>  <name1> <price1>
<3000>   <24000>    <day8>  <name1> <price1>
<3000>   <27000>    <day9>  <name1> <price1>
<3000>   <30000>   <day10> <name1> <price1>
<3000>   <33000>   <day11> <name1> <price1>
<3000>   <36000>   <day12> <name1> <price1>

 

<6000>     <6000>   <day2>   <name2> <price2>
<6000>   <12000>   <day4>   <name2> <price2>
<6000>   <18000>   <day6>   <name2> <price2>
<6000>   <24000>   <day8>   <name2> <price2>
<6000>   <30000>   <day10> <name2> <price2>
<6000>   <36000>   <day12> <name2> <price2>

 

<12000>  <12000>  <day4> <name3> <price3>
<12000>  <24000>  <day8> <name3> <price3>
<12000>  <36000>  <day12> <name3> <price3>

 

<36000>  <36000>  <day12> <name4> <price4>

 

I want to extract the data from here to another individual PDF file.  

Specifically, for each cumulative time lined up vertically in the second field from the left.  I think it's probably simple code, but I'm not sure.

 

For example, for another PDF file that exports cumulative <36000> hours of data,

 

<36000> <day12>  //The 36000th hour comes on <Day12>

 

<3000>    <name1>   <price1>  //The parts that must be replaced on that day are:
<6000>    <name2>   <price2>
<12000>  <name3>   <price3>
<36000>  <name4>   <price4>

 

And I would like to fit in the following fields placed in the <36000> hour PDF file

 

"H1"     "D1"

 

"T1"     "N1"     "P1"
"T2"     "N2"     "P2"
"T3"     "N3"     "P3"
"T4"     "N4"     "P4"
"T5"     "N5"     "P5"
"T6"     "N6"     "P6"
"T7"     "N7"     "P7"
"T8"     "N8"     "P8"
"T9"     "N9"     "P9"
"T10"   "N10"   "P10"
"T11"   "N11"    "P11"

 

I don't know how to write this.
I don't even know where to write it.

 

Sorry for the really basic question.
Thanking you in advance.

I answered this early on, and you did not even acknowledge the answer. The more you ask, the more I am convinced this is the right answer. Use Excel instead. Overcome those unspecified reasons you mentioned, and consider functionality more important than a pretty background.

TOPICS
Acrobat SDK and JavaScript, Create PDFs, PDF forms

Views

313

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

I want to extract and sort data in other PDF files ...

Apr 22, 2020

Copy link to clipboard

Copied

Perhaps this is a basic question about an array.  

 

And I'm sorry, this is a question to all that how to write code as an answer.  

I have no experience writing code for arrays. 

 

I have read various descriptions about arrays, but I am not sure how to realize it with PDF in front of me.

 

====

 

I would like to know the following cases.
The First PDF file has fields with the following contents.

 

This is a list of equipment maintenance replacement parts.
Parts to be replaced are lined up at regular intervals.

 

Actually, there are more items both vertically and horizontally, but it is like this when simplified.  There are over 100 pages.

 

From left to right ("Field Name")

Time Unit / Cumulative Time / Implementation Date / Part Name / Selling Price

 

"TU1"     "CT1"     "ID1"     "PN1"     "SP1"
"TU2"     "CT2"     "ID2"     "PN2"     "SP2"
"TU3"     "CT3"     "ID3"     "PN3"     "SP3"
"TU4"     "CT4"     "ID4"     "PN4"     "SP4"
"TU5"     "CT5"     "ID5"     "PN5"     "SP5"
"TU6"     "CT6"     "ID6"     "PN6"     "SP6"
"TU7"     "CT7"     "ID7"     "PN7"     "SP7"
"TU8"     "CT8"     "ID8"     "PN8"     "SP8"
"TU9"     "CT9"     "ID9"     "PN9"     "SP9"
"TU10"   "CT10"   "ID10"   "PN10"    "SP10"
"TU11"   "CT11"   "ID11"    "PN11"    "SP11"

"TU1000"   "CT1000"   "ID1000"    "PN1000"    "SP1000"

 

This field will increase in the future.

 

As the Implementation Date, the date of the result calculated by JavaScript based on the cumulative time is entered.  Actually, there are other fields such as start date.

 

So, the data is arranged as follows.  In short, it is like Excel with a beautifully designed background.  Actually I wanted to make it in Excel, but for several reasons I'm making it directly in PDF.

 

<3000>     <3000>    <day1>  <name1> <price1>
<3000>     <6000>    <day2>  <name1> <price1>
<3000>     <9000>    <day3>  <name1> <price1>
<3000>   <12000>    <day4>  <name1> <price1>
<3000>   <15000>    <day5>  <name1> <price1>
<3000>   <18000>    <day6>  <name1> <price1>
<3000>   <21000>    <day7>  <name1> <price1>
<3000>   <24000>    <day8>  <name1> <price1>
<3000>   <27000>    <day9>  <name1> <price1>
<3000>   <30000>   <day10> <name1> <price1>
<3000>   <33000>   <day11> <name1> <price1>
<3000>   <36000>   <day12> <name1> <price1>

 

<6000>     <6000>   <day2>   <name2> <price2>
<6000>   <12000>   <day4>   <name2> <price2>
<6000>   <18000>   <day6>   <name2> <price2>
<6000>   <24000>   <day8>   <name2> <price2>
<6000>   <30000>   <day10> <name2> <price2>
<6000>   <36000>   <day12> <name2> <price2>

 

<12000>  <12000>  <day4> <name3> <price3>
<12000>  <24000>  <day8> <name3> <price3>
<12000>  <36000>  <day12> <name3> <price3>

 

<36000>  <36000>  <day12> <name4> <price4>

 

I want to extract the data from here to another individual PDF file.  

Specifically, for each cumulative time lined up vertically in the second field from the left.  I think it's probably simple code, but I'm not sure.

 

For example, for another PDF file that exports cumulative <36000> hours of data,

 

<36000> <day12>  //The 36000th hour comes on <Day12>

 

<3000>    <name1>   <price1>  //The parts that must be replaced on that day are:
<6000>    <name2>   <price2>
<12000>  <name3>   <price3>
<36000>  <name4>   <price4>

 

And I would like to fit in the following fields placed in the <36000> hour PDF file

 

"H1"     "D1"

 

"T1"     "N1"     "P1"
"T2"     "N2"     "P2"
"T3"     "N3"     "P3"
"T4"     "N4"     "P4"
"T5"     "N5"     "P5"
"T6"     "N6"     "P6"
"T7"     "N7"     "P7"
"T8"     "N8"     "P8"
"T9"     "N9"     "P9"
"T10"   "N10"   "P10"
"T11"   "N11"    "P11"

 

I don't know how to write this.
I don't even know where to write it.

 

Sorry for the really basic question.
Thanking you in advance.

I answered this early on, and you did not even acknowledge the answer. The more you ask, the more I am convinced this is the right answer. Use Excel instead. Overcome those unspecified reasons you mentioned, and consider functionality more important than a pretty background.

TOPICS
Acrobat SDK and JavaScript, Create PDFs, PDF forms

Views

314

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Apr 22, 2020 0
Apr 23, 2020

Copy link to clipboard

Copied

A warning: 100 pages? Each with 100 forms? You will have to type in and choose the options for each of the 10,000 form fields. But if you do that, you will have a PDF with far too many fields. This will collapse and be unusable after all that work. PDF is not a spreadsheet. I recommend you go back to Excel. PDF is great for a frozen view (uneditable, unchangable) of a spreadsheet at one moment.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 23, 2020 1
Apr 23, 2020

Copy link to clipboard

Copied

How many fields can I use?

If I know it, split the original PDF.

Currently, about 2700 fields are actually used.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 23, 2020 0
Apr 23, 2020

Copy link to clipboard

Copied

There is no hard limit. But any talk of numbers in thousands of fields shows a big problem coming. Even if it performed OK, do you really want to visit and change 2700 fields each time a correction is needed? Form fields are designed for filling forms - ordinary forms, where people type in their info. Not for simulating spreadsheets or creating complex games (to give two examples).

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 23, 2020 0
Apr 23, 2020

Copy link to clipboard

Copied

OK. Thank you for your advice.

Split the PDF to reduce the fields extremely.

 

But please, I want the answer to my first question.

Thank you.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 23, 2020 0
Apr 23, 2020

Copy link to clipboard

Copied

Your first question seems to be a long and detailed question which would be a lot of work to answer, to do something I have advised against. You state it would be simple code, but that seems to be just a wish... In fact, sorry, I couldn't even work out what was the question, there was a long discussion, and you said you were not able to do something. I don't think you want to hear from me any more GIVE UP THIS IDEA so I will try to be quiet now.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 23, 2020 0
Apr 23, 2020

Copy link to clipboard

Copied

Don't get me wrong.
And if you are offended, please forgive me.

 

Your advice was very helpful to me.
I am grateful.

 

I am going to make a fix according to youe advice.
Specifically, the original file may be divided for each model.

 

But I also want to know it for future study.
Please understand it.  m(_ _)m

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 23, 2020 0
Apr 27, 2020

Copy link to clipboard

Copied

To solve your first problem you will need to write an automation script. This is something I do quite a lot. To know the feasibility and difficulty of the specific task you want, will require you to write a simple and concise explanation. But it seems this should be possible, but require a not-small amount of work. You can read about this type of scripting here:

https://www.pdfscripting.com/public/Automating-Acrobat.cfm

https://www.pdfscripting.com/public/Form-Data-Handling.cfm

 

If you are not up to this task, I would suggest hiring a consultant.  I would be happy to help you with this task.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 27, 2020 0
May 04, 2020

Copy link to clipboard

Copied

I apologize first. I hadn't visited this site for a few days.

Because I gave up on getting the answer at here.

 

I am a Japanese living in China for work.

And I didn't know the page you introduced to me.

 

As you know, foreigners who live in China like us cannot "search" overseas sites from China because of China's internet regulations.  Only Chinese sites can be searched here.

 

I have a contract with a major VPN provider, but in reality it can only be used for sending and receiving Gmail.  I have contracted with 3 VPN companies for a year in the past, but all their advertising were lie.  Because they are always losing the competition with the Chinese government.  In short, I can't always get a VPN connection. When I can't connect to VPN, I can't log in with my Gmail address, so I can't write a comment like this also.  

 

In any case, even if I want to study JavaScript programming for PDF, I am not able to find decent explanations or materials, so I am at a loss.  I don't know why, but I can't find anywhere in Japanese documents about PDF JavaScript.  I don't even know what I can and cannot do with PDF.

 

Anyway thank you for your reply. 
I would like to read all the pages you introduced first.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 04, 2020 0
May 05, 2020

Copy link to clipboard

Copied

I answered this early on, and you did not even acknowledge the answer. The more you ask, the more I am convinced this is the right answer. Use Excel instead. Overcome those unspecified reasons you mentioned, and consider functionality more important than a pretty background.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 05, 2020 0
bao1 LATEST
May 07, 2020

Copy link to clipboard

Copied

Thank you for your reply. 

 

I will follow your advice.
Unfortunately, Excel is not available here in China.

 

I'm the only foreigner to use Excel around me.
Many Chinese have stopped using the Microsoft office since copyright management in China became strict.

 

The Chinese people around me use a variety of free spreadsheets and are not unified.
And in most of them Excel macro doesn't work.

 

I've already downloaded WPS Office and are looking into what functions are available.

 

Anyway, thank you for your advice.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 07, 2020 0