Save results to CSV

[Enigma 78]

Ok this is the way i always do this, but somehow today it is failing.

Very weird.

 

I scrape 2 elements on a site and add these to 2 different lists.

Let's call this listA and listB.

Now i want to save them to CSV.

So i select "Save to file" and add listA and listB and put a comma in between.

 

Result: it does NOT add the comma in the CSV file and put list B under list A.

In other words it makes 1 big list under each other, instead of near each other comma separated.

 

So instead of:

 

word1,word2

 

it shows:

 

word1

word2

 

See screenshot attached.

[MiriamMB 63]

Ok this is the way i always do this, but somehow today it is failing.

Very weird.

 

I scrape 2 elements on a site and add these to 2 different lists.

Let's call this listA and listB.

Now i want to save them to CSV.

So i select "Save to file" and add listA and listB and put a comma in between.

 

Result: it does NOT add the comma in the CSV file and put list B under list A.

In other words it makes 1 big list under each other, instead of near each other comma separated.

 

So instead of:

 

word1,word2

 

it shows:

 

word1

word2

 

See screenshot attached.

 

That way does not work. Are you sure that's the way you've always done it?

 

You would have to put each list item in a table cell, and increment the rows.

[Enigma 78]

That way does not work. Are you sure that's the way you've always done it?

 

You would have to put each list item in a table cell, and increment the rows.

 

Check Seth's video here and you see exactly how i do it:

 

http://vimeo.com/7891497

 

(starts at 4:33)

[MiriamMB 63]

Check Seth's video here and you see exactly how i do it:

 

http://vimeo.com/7891497

 

(starts at 4:33)

 

Yea, that is an old tutorial and the method has changed since adding the tables part of UBot Studio. Did you say you've always done this in the New version of UBot?

[Enigma 78]

Yea, that is an old tutorial and the method has changed since adding the tables part of UBot Studio. Did you say you've always done this in the New version of UBot?

 

Last week i finished a bot this way i guess.

Will check it again.

 

So how is the new procedure going?

 

Is there a new video tutorial about how to save to CSV?

[MiriamMB 63]

Last week i finished a bot this way i guess.

Will check it again.

 

So how is the new procedure going?

 

Is there a new video tutorial about how to save to CSV?

 

 

Yes, it's Tutorial 14, the tables Tutorial.

[Enigma 78]

Yes, it's Tutorial 14, the tables Tutorial.

 

Thanks Lilly.

Will check it out.

[DjProg 3]

I had to make this yesterday, here is how I did it :

 

For me it just make a CSV with the format :

 

URL,Scrapped-categories

 

But off course you can do it to make :

 

elementofpage1,elementofpage2

 

SO THE SCRIPT IS :

- Get element1 and put in variable

- Get element 2 and put in variable

- Concatenate variables containing element1 and element2 in a list with a comma in between

- Save the list to a file (which will end up being CSV as you added the commas). This part is not in the screenshot but it's simply a "save to file"

 

Cheers,

[Abyssus 0]

Ok this is the way i always do this, but somehow today it is failing.

Very weird.

 

I scrape 2 elements on a site and add these to 2 different lists.

Let's call this listA and listB.

Now i want to save them to CSV.

So i select "Save to file" and add listA and listB and put a comma in between.

 

Result: it does NOT add the comma in the CSV file and put list B under list A.

In other words it makes 1 big list under each other, instead of near each other comma separated.

 

So instead of:

 

word1,word2

 

it shows:

 

word1

word2

 

See screenshot attached.

 

One way you can do it is load your data into lists (each list will become a table column). Save each list to file for debugging purposes. Then using the Variable Command, set_list_position and set_table_cell and Flow Command loop, load each table column with your lists one cell at a time.

 

Thats how I did it, but I sure wish there was a pre-existing function that made it easier to do this.

[botbie 0]

hi aby,

Could you attach up with the sample of bot here?

 

Thank you.