Extract & Write CSV

Discussions and Tech Support related to the iMacros Firefox Add-on, including the built-in Javascript scripting interface for playing .js files.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.

Extract & Write CSV

by Tamilselvan on Wed Oct 24, 2018 6:23 am

iMacros for firefox free 10.0.2.1450,
Windows 10 version 1803
Firefox 61.0.2 (32 Bit)

Please help anyone...

In looping I am accessing csv (JobCard-No.csv) file do somthing.

Code: Select all
SET !DATASOURCE "C:\\Users\\acer\\Documents\\iMacros\\Datasources\\JobCard-No.csv"



I get following statement each record in Looping.

Code: Select all
TAG POS=1 TYPE=SPAN ATTR=TXT:Data<SP>Entered<SP>Successfully!


sometime some record missed so the above statement not get (i.e.)"Entered Successfully". then loop will continue.

For identification I need to extract the each statement ("Entered Successfully " )and write in existing csv. (JobCard-No.csv) file in specified columns and each rows (i.e.) i need in 6th column.

Kindly help me.
Thanks You...
Tamilselvan
 
Posts: 67
Joined: Mon Mar 07, 2016 3:49 am

Re: Extract & Write CSV

by chivracq on Wed Oct 24, 2018 6:53 am

Tamilselvan wrote:
Code: Select all
iMacros for firefox free 10.0.2.1450,
Windows 10 version 1803
Firefox 61.0.2 (32 Bit)


Please help anyone...

In looping I am accessing csv (JobCard-No.csv) file do somthing.

Code: Select all
SET !DATASOURCE "C:\\Users\\acer\\Documents\\iMacros\\Datasources\\JobCard-No.csv"



I get following statement each record in Looping.

Code: Select all
TAG POS=1 TYPE=SPAN ATTR=TXT:Data<SP>Entered<SP>Successfully!


sometime some record missed so the above statement not get (i.e.)"Entered Successfully". then loop will continue.

For identification I need to extract the each statement ("Entered Successfully " )and write in existing csv. (JobCard-No.csv) file in specified columns and each rows (i.e.) i need in 6th column.

Kindly help me.
Thanks You...

You cannot indeed "directly" add a Column to an existing '.CSV' from iMacros...

One Option is to use some GoogleDoc that you then can access from your Macro in your Browser, in a second Tab for example.

Another Option is to "completely" recreate your '.CSV' with the 5 existing Cols + the new Col, with something like:
Code: Select all
SET !EXTRACT NULL
TAG POS=1 TYPE=SPAN ATTR=TXT:Data<SP>Entered<SP>Successfully! EXTRACT=TXT
SET Data_Success {{!EXTRACT}}

SET !EXTRACT {{!COL1}}[EXTRACT]{{!COL2}}[EXTRACT]{{!COL3}}[EXTRACT]{{!COL4}}[EXTRACT]{{!COL5}}[EXTRACT]{{Data_Success}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=*
- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...
- I usually don't even read the Question if that (required) Info is not mentioned...
- Script & URL usually help a lot for a more "educated" Help...
chivracq
 
Posts: 7714
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: Extract & Write CSV

by Tamilselvan on Wed Oct 24, 2018 7:29 am

Yes... Its working.... :D :D :D
Thank You so much....
Tamilselvan
 
Posts: 67
Joined: Mon Mar 07, 2016 3:49 am

Re: Extract & Write CSV

by chivracq on Wed Oct 24, 2018 7:41 am

Tamilselvan wrote:Yes... Its working.... :D :D :D
Thank You so much....

You're welcome...! :D
- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...
- I usually don't even read the Question if that (required) Info is not mentioned...
- Script & URL usually help a lot for a more "educated" Help...
chivracq
 
Posts: 7714
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)


Return to iMacros for Firefox

Who is online

Users browsing this forum: No registered users and 14 guests

-->