[SOLVED] dynamically process tables

[hueskye]

hi;
I am making a blog articles poster.
generally it is supposed to have login data for multiple blogs in one file.
with processing tables i can make it login for first account, than i would like it to go to "add article", and here comes the trick part.

i have data for article posting in separate xlsx files for each blog in a project's subdirectory.

now i would like to get list of those files, and somehow set them to the varible, so let's say i have 6 files in the directory, they are named as 1.xlsx, 2.xlsx 3.xlsx...., zenno gets their path and name, and than processes the first file , adding articles. whent it's done, i get back to login, zenn logs to another blog, posts from file 2.xlsx and so on.

I had an idea that i will use a table and table processing, and in the file path of the table i will specify something like {-Project.Directory-}\articles\{-Variable.FileName-} but actually it seems i cant use variables to determine files name.

Does anybody has an idea how i can solve my project?
best regards
Kamil

 

[rostonix]

You have to use bind to file action: http://zennolab.com/discussion/show...-example-actions&p=37478&viewfull=1#post37478

 

[hueskye]

Thanx for the suggestion.
I have implemented it and it works just fine until a moment.
I dont have any idea why, but it seems my table which is meant to load data dynamically (robocza table) seems to be unable to get its name from a variable.

i am trying to figure this out for like 5 hours by now.
Could anybody tell me what am I doing wrong?
Посмотреть вложение multi.zip

 

[strongrobby]

Did you Move it ?

Thanx for the suggestion.
I have implemented it and it works just fine until a moment.
I dont have any idea why, but it seems my table which is meant to load data dynamically (robocza table) seems to be unable to get its name from a variable.

i am trying to figure this out for like 5 hours by now.
Could anybody tell me what am I doing wrong?
Посмотреть вложение 3434

You need to use the Table > Bind To file

http://gyazo.com/9048f4db982578b6188bebcf76270ac5

Won't work...

 

[rostonix]

You cant use variables in tables settings: http://gyazo.com/632c46d26e7cd3cf034763e2e6718c98.png?1364809076
You leave path blank and use tables - Bind to file action in order to use variables in path (see my link in previous post)

 

[hueskye]

almost here

alright, so due to your suggestions i have made a bind table to file.

when i run debug it processes perfectly through the first blog, posts and publishes.

Than it logs int another blog, yet without any problems.

however i get error when it wants to publish on another blog- seems like it cant process the data bound to the table with articles content.

any ideas where the problem might be?
Посмотреть вложение multi2.zip

 

[rostonix]

Archive doesn't have all required tables for execution.

 

[hueskye]

what do you mean by archive?
the directory on my hard drive?

 

[bigcajones]

No the multi2.zip attachment you put on here. That archive. :p

 

[hueskye]

Посмотреть вложение multi3.zip
okay, now i got that;
So i have created 2 test accounts on my blogs, and now i have uploaded all files i have in my ddirectory on my hard drive.
So again, any ideas what could be wrong?

 

[rostonix]

You need to set this counter again to 0 before you start with other blog: http://gyazo.com/4cb47283a71b17f9637a36f65f20cfcf.png?1364837069
Set counter to 0 before steps where you input login + password)

 

[hueskye]

Thanx guys, now stuff works for 2 blogs

when i tried running it for 3 i got another error
i upload for the last time and hope you reply me what's wrong, since i know i am really irritating
Посмотреть вложение multi4.zip