Find & Store Items in Excel
Forum rules
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
-
- Posts: 129
- Joined: Mon Mar 07, 2016 10:49 am
Find & Store Items in Excel
FCIM:
Windows 10
Firefox : Version 55.0.3 (32-bit)
Add on: iMacros for Firefox 9.0.3
iMacros 30-Day Evaluation: iMacros Browser (x86) Version 11.5.498.2403
Hi,
Kindly anyone help. I have csv file using it to find out items from web to store separate columns in excel file.
Csv File :
FTO No.
TN2906015_220617FTO_509442
TN2906015_230617FTO_510116
TN2906015_230617FTO_512338
.
.
.
Find out items from web. Store separate columns in excel file
Windows 10
Firefox : Version 55.0.3 (32-bit)
Add on: iMacros for Firefox 9.0.3
iMacros 30-Day Evaluation: iMacros Browser (x86) Version 11.5.498.2403
Hi,
Kindly anyone help. I have csv file using it to find out items from web to store separate columns in excel file.
Csv File :
FTO No.
TN2906015_220617FTO_509442
TN2906015_230617FTO_510116
TN2906015_230617FTO_512338
.
.
.
Find out items from web. Store separate columns in excel file
Re: Find & Store Items in Excel
The "M" in "FCIM" stands for "Missing", you mean "FCI"...Tamilselvan wrote:FCIM:Hi,Code: Select all
Windows 10 Firefox : Version 55.0.3 (32-bit) Add on: iMacros for Firefox 9.0.3 iMacros 30-Day Evaluation: iMacros Browser (x86) Version 11.5.498.2403
Kindly anyone help. I have csv file using it to find out items from web to store separate columns in excel file.
Csv File :Find out items from web. Store separate columns in excel fileCode: Select all
FTO No. TN2906015_220617FTO_509442 TN2906015_230617FTO_510116 TN2906015_230617FTO_512338 . . .
Hum, iMB v11.5 is already 1.5 years old with v12.0 released already 7 months ago, you must have had more than 30 days to "try" the Software I would think, ah-ah...!
Hum, good, you don't use your usual "Please do the needful." for once in this Thread, which sounds very commanding, I don't react to those Threads of yours anymore...
But hum, yeah, what is the Pb...? No Script posted, you don't sound like you've tried anything, and to be honest, I don't even understand your "Scenario" exactly, especially the "... I have csv file using it to find out items from web..." as your '.CSV' File looks empty (apart from the Header), but anyway it sounds otherwise like a typical Data Extraction Scenario.
=> Yep, perfect Usecase for iMacros...! Perfectly documented in the Wiki, and many-many Threads/Examples to find on the Forum if you encounter any Difficulty(ies)...
We even have a dedicated Sub-Forum about only 'Data Extraction'...!, where you could even have opened your Thread actually..., but OK, no need to duplicate, the 'General' Forum is always OK if you have any "Doubt"... => Glad to help you if you encounter any Pb, but nobody is going to write your Script I'm afraid...
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
-
- Posts: 129
- Joined: Mon Mar 07, 2016 10:49 am
Re: Find & Store Items in Excel
Sorry for "commanding words" please don't mistake me.
I have extracted the values. How to store the values in output file in specified columns.
TAG POS=4 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT
SET !VAR1 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=5 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT
SET !VAR2 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=6 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT
SET !VAR3 {{!EXTRACT}}
I have extracted the values. How to store the values in output file in specified columns.
TAG POS=4 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT
SET !VAR1 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=5 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT
SET !VAR2 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=6 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT
SET !VAR3 {{!EXTRACT}}
Re: Find & Store Items in Excel
Yeah, well, I don't know what corresponds to 'POS=4/5/6', simply extract your Fields in the same order that you want the Data in the 'SAVEAS'...Tamilselvan wrote:Sorry for "commanding words" please don't mistake me.
I have extracted the values. How to store the values in output file in specified columns.
Code: Select all
TAG POS=4 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT SET !VAR1 {{!EXTRACT}} SET !EXTRACT NULL TAG POS=5 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT SET !VAR2 {{!EXTRACT}} SET !EXTRACT NULL TAG POS=6 TYPE=TD ATTR=ALIGN:left EXTRACT=TXT SET !VAR3 {{!EXTRACT}}
If you do 3 Extracts, you will get 3 Columns... And if you need those 3 Extracts in a different order or in different Cols than 'Col_1/2/3', then you can "manipulate" the Content of the '!EXTRACT' Var before doing the 'SAVEAS' if you don't like the "Default" Content...
=> For example if you want your 3 Extracts in 'Col_1/5/4' in this order:
Code: Select all
SET !EXTRACT {{!VAR1}}[EXTRACT][EXTRACT][EXTRACT]{{!VAR3}}[EXTRACT]{{!VAR2}}
SAVEAS TYPE=EXTRACT ...
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
-
- Posts: 129
- Joined: Mon Mar 07, 2016 10:49 am
Re: Find & Store Items in Excel
Officially I went out. I couldn't reply to get further . I will be back in a week. Please grand me.
Re: Find & Store Items in Excel
OK...Tamilselvan wrote:Officially I went out. I couldn't reply to get further . I will be back in a week. Please grand me.
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...