Config file inclusion

[marco_puccetti]

Hello i need to know if the LOAD INLINE statement included in a config file are visible in the script at the reload process.

I have a table like this:

TAB:

LOAD * INLINE [

A, B

VAL1, VAL2

];

in the config file included with this statement $(include=../SETTINGS/config.txt);

but when i use this expression in the script: LET noRows = NoOfRows('TAB');

i get NULL.

Is it correct?

Thanks

Marco

[Peter_Cammaert]

It seems he already did try the latter.

See: Re: Config file inclusion

[rwunderlich]

Is your data getting auto concatenated with another table? Try adding

NOCONCATENATE before the LOAD.

-Rob

[Peter_Cammaert]

Exactly what I was trying to bring to the surface using a slow method: autodiscovery. See Re: Config file inclusion.

I guess it didn't work out...

[marco_puccetti]

I have made as you've said but the store fails because of the missing table error.

Marco

[Peter_Cammaert]

The STORE is an easy trick to detect a table that either isn't created or that is autoconcatenated to another table. QlikView has the annoying habit of autoconcatenating tables, even though you specify a new name for the last table.

This can happen all the time. Be careful with multiple tables that have a similar layout and are loaded in sequence.

Add NOCONCATENATE to the LOAD statement of table InstagramSites. See if that helps.

Peter

[marco_puccetti]

No is not concatenated.

Marco

[Peter_Cammaert]

If it isn't autoconcatenated, and the LOAD is executed as expected then a new table with the correct name should exist in your datamodel.

You can check whether the LOAD is executed by generating a document log file (enable Settings->Document Properties->General->Generate log file) and opening this log in notepad. Navigate to the location where you expect this LOAD to pop up, or post the log in this thread. That will give us an idea of what exactly is happening and what isn't.

Best,

Peter.

[marco_puccetti]

This is the log generated:

29/05/2015 11:07:22:      Azione avviata

29/05/2015 11:07:22:      QlikView Version:11.20.12742.0

29/05/2015 11:07:22:      CPU Target                    x64

29/05/2015 11:07:22:      Operating System              Windows 7 Professional Service Pack 1 (64 bit edition)

29/05/2015 11:07:22:      Wow64 mode                    Not using Wow64

29/05/2015 11:07:22:      MDAC Version                  6.1.7601.17514

29/05/2015 11:07:22:      MDAC Full Install Version     6.1.7601.17514

29/05/2015 11:07:22:      PreferredCompression          2

29/05/2015 11:07:22:      EnableParallelReload          1

29/05/2015 11:07:22:      ParallelizeQvdLoads           1

29/05/2015 11:07:22:      AutoSaveAfterReload           0

29/05/2015 11:07:22:      BackupBeforeReload            0

29/05/2015 11:07:22:      EnableFlushLog                0

29/05/2015 11:07:22:      SaveInfoWhenSavingFile        0

29/05/2015 11:07:22:      UserLogfileCharset            1200

29/05/2015 11:07:22:      OdbcLoginTimeout              -1

29/05/2015 11:07:22:      OdbcConnectionTimeout         -1

29/05/2015 11:07:22:      ScriptWantsDbWrite            false

29/05/2015 11:07:22:      ScriptWantsExe                false

29/05/2015 11:07:22:      LogFile CodePage Used:        1200

29/05/2015 11:07:22:       Reload Executed By INSURANCE\m.puccetti

29/05/2015 11:07:22:       Process Executing: QlikView Desktop

29/05/2015 11:07:22:       Process ID: 5956

29/05/2015 11:07:22: 0200  SET ThousandSep=','

29/05/2015 11:07:22: 0201  SET DecimalSep='.'

29/05/2015 11:07:22: 0202  SET MoneyThousandSep=','

29/05/2015 11:07:22: 0203  SET MoneyDecimalSep='.'

29/05/2015 11:07:22: 0204  SET MoneyFormat='£#,##0.00;-£#,##0.00'

29/05/2015 11:07:22: 0205  SET TimeFormat='hh:mm:ss'

29/05/2015 11:07:22: 0206  SET DateFormat='DD/MM/YYYY'

29/05/2015 11:07:22: 0207  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

29/05/2015 11:07:22: 0208  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

29/05/2015 11:07:22: 0209  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

29/05/2015 11:07:22: 0216  let vWorkingFolder = 'c:\QVSource\Temp\'

29/05/2015 11:07:22: 0015  let vQvdPath       = '..\QVD'

29/05/2015 11:07:22: 0020  let vQVSourceAppId = 'Social Media Analizer'

29/05/2015 11:07:22: 0021  set ErrorMode=1

29/05/2015 11:07:22: 0045  FacebookSites:

29/05/2015 11:07:22: 0046  LOAD * INLINE [

29/05/2015 11:07:22: 0047  page, Site

29/05/2015 11:07:22: 0048  276965569137896, Bancadinamica

29/05/2015 11:07:22: 0049  ]

29/05/2015 11:07:22:       2 campi trovati: page, Site, 1 linee recuperate

29/05/2015 11:07:22: 0056  let vNoDaysToGoBackOnInitialReload = 30

29/05/2015 11:07:22: 0063  let vNoDaysToGoBackOnSubsequentReloads = 30

29/05/2015 11:07:22: 0073  let vNoOfCommentsToLoadPerFeedItem = 10

29/05/2015 11:07:22: 0080  let vLoadCommentCountForFeedItems = 0

29/05/2015 11:07:22: 0087  let vLoadLikeCountForFeedItems = 1

29/05/2015 11:07:22: 0111  SentimentAPIs:

29/05/2015 11:07:22: 0112  LOAD * INLINE [

29/05/2015 11:07:22: 0113  SentimentAPI

29/05/2015 11:07:22: 0114  Random

29/05/2015 11:07:22: 0115  ]

29/05/2015 11:07:22:       1 campi trovati: SentimentAPI, 1 linee recuperate

29/05/2015 11:07:22: 0124  let vLocalTimeZone = 'UTC'

29/05/2015 11:07:22: 0129  TwitterSites:

29/05/2015 11:07:22: 0130  LOAD * INLINE [

29/05/2015 11:07:22: 0131  tpage, tSite

29/05/2015 11:07:22: 0132  276965569137896, Bancadinamica

29/05/2015 11:07:22: 0133  ]

29/05/2015 11:07:22:       2 campi trovati: tpage, tSite, 1 linee recuperate

29/05/2015 11:07:22: 0135  let vTokenEncrypted       = ''

29/05/2015 11:07:22: 0136  let vTokenSecretEncrypted = 'ToTl4J9%2fLaYChHFpUMGe6lPYvCQDoN0k0wRi43JU%2fbLOBTOGmfYbe1jg4KiY%2fyOJ'

29/05/2015 11:07:22: 0140  InstagramSites:

29/05/2015 11:07:22: 0141  LOAD * INLINE [

29/05/2015 11:07:22: 0142  tpage, tSite

29/05/2015 11:07:22: 0143  1111111111, Bancadinamica

29/05/2015 11:07:22: 0144  ]

29/05/2015 11:07:22:       2 campi trovati: tpage, tSite, 2 linee recuperate

29/05/2015 11:07:22: 0149  let vQVSourceBaseUrl = 'http://localhost:5555'

29/05/2015 11:07:22: 0155  let vUseAsyncWherePossible = 1

29/05/2015 11:07:22: 0156  let vAsyncSentiment = vUseAsyncWherePossible

29/05/2015 11:07:22: 0157  let vAsyncComments = vUseAsyncWherePossible

29/05/2015 11:07:22: 0167  let VEmailNotificationAddress = 'm.puccetti@tdnet.it'

29/05/2015 11:07:22: 0186  let vLoadPostersAndCommenterInfo = 0

29/05/2015 11:07:22: 0187  let vLoadPostersAndCommenterInfoAsync = vUseAsyncWherePossible

29/05/2015 11:07:22: 0193  let vColNeg = 'RGB(255, 0, 0)'

29/05/2015 11:07:22: 0194  let vColPos = 'RGB(0, 255, 0)'

29/05/2015 11:07:22: 0195  let vColNeu = 'RGB(0, 0, 255)'

29/05/2015 11:07:22: 0202  let vGetLatestData = 1

29/05/2015 11:07:22: 0209  let vClearCacheBeforeReload = 0

29/05/2015 11:07:22: 0215  let vDeleteTempTables = 1

29/05/2015 11:07:22: 0220  let vShowScrapSheets = 0

29/05/2015 11:07:22: 0226  let vIgnoreCache = 'false'

29/05/2015 11:07:22: 0234  let vLikeCountThreshold = 24

29/05/2015 11:07:22: 0237  let vCommentCountThreshold = 24

29/05/2015 11:07:22: 0217  let vCompany = PEEK('Company', 0, 'FacebookSites')

29/05/2015 11:07:22: 0219  let vtemp = Date(timestamp(now(1)) - vNoDaysToGoBackOnInitialReload)

29/05/2015 11:07:22: 0220  let vOldestFeedCreatedDateForInitialReload  = Date(vtemp, 'DD-MM-YYYY')

29/05/2015 11:07:22: 0221  let vOldestTweetCreatedDateForInitialReload = Date(vtemp, 'DD-MM-YYYY')

29/05/2015 11:07:22: 0222  let vtemp = Date(timestamp(now(1)) - vNoDaysToGoBackOnSubsequentReloads)

29/05/2015 11:07:22: 0223  let vOldestFeedCreatedDateForSubsequentReloads = Date(vtemp, 'DD-MM-YYYY')

29/05/2015 11:07:22: 0225  let vCompany = peek('Site', 0,'FacebookSites')

29/05/2015 11:07:22: 0226  let vTestvLocalTimeZone = ConvertToLocalTime(UTC(), 'UTC')

29/05/2015 11:07:22: 0239  LET vISRows = NoOfRows('InstagramSites')

29/05/2015 11:07:22: 0243  if (right(vTestvLocalTimeZone, 1) = '?') then

29/05/2015 11:07:22: 0254  let vToday = now(1)

29/05/2015 11:07:22: 0255  let vDay = day(vToday)

29/05/2015 11:07:22: 0256  let vYear = year(vToday)

29/05/2015 11:07:22: 0258  let vMonth = month(vToday)

29/05/2015 11:07:22: 0259  let vTodayAsDate = makedate(vYear, vMonth, vDay)

29/05/2015 11:07:22: 0260  let vLocalReloadTime = date(ConvertToLocalTime(gmt(), 'UTC'), 'DD/MM/YYYY hh:mm')

29/05/2015 11:07:22: 0274  sub sendEmail(subject, msg, to)

29/05/2015 11:07:22: 0288  let QVSource_log=''

29/05/2015 11:07:22: 0290  sub logQVSourceError(errorDetails, connectorName)

29/05/2015 11:07:22: 0307  sub doesFileExist(fileName)

29/05/2015 11:07:22: 0322  sub getItemsLeftToScore(qvdFileName, tableContainingCurrentData, idColName, encodedTextColName, textColName, sentimentColName)

29/05/2015 11:07:22: 0375  sub runSentiment(idColumnAlias, resultsColPrefix, sentimentEngine)

29/05/2015 11:07:22: 0457  sub CheckQVSourceStatus

29/05/2015 11:07:22: 0528  call CheckQVSourceStatus

29/05/2015 11:07:22: 0459    set errormode = 0

29/05/2015 11:07:22: 0461    QVSourceStatus:

29/05/2015 11:07:22: 0462        LOAD Version,

29/05/2015 11:07:22: 0463            SubField(Version, '.', 1) as Version_Major,

29/05/2015 11:07:22: 0464            SubField(Version, '.', 2) as Version_Minor,

29/05/2015 11:07:22: 0465            SubField(Version, '.', 3) as Version_Build,

29/05/2015 11:07:22: 0466            SubField(Version, '.', 4) as Version_Revision,

29/05/2015 11:07:22: 0467            ServerMode,

29/05/2015 11:07:22: 0468            Path,

29/05/2015 11:07:22: 0469            Licensed,

29/05/2015 11:07:22: 0470            LicenseExpires,

29/05/2015 11:07:22: 0471            IsLicensedAsServer

29/05/2015 11:07:22: 0472        FROM [http://localhost:5555/QVSource?format=xml] (XmlSimple, Table is [QVSource])

29/05/2015 11:07:26:         10 campi trovati: Version, Version_Major, Version_Minor, Version_Build, Version_Revision, ServerMode, Path, Licensed, LicenseExpires, IsLicensedAsServer, 1 linee recuperate

29/05/2015 11:07:26: 0474    if(ScriptError <> '') then  

29/05/2015 11:07:26: 0484    if(peek('Licensed', 0, 'QVSourceStatus') <> 'true') then

29/05/2015 11:07:26: 0494    if(peek('ServerMode', 0, 'QVSourceStatus') = 'true' and peek('IsLicensedAsServer', 0, 'QVSourceStatus') = 'false') then

29/05/2015 11:07:26: 0504    let currentVersionAsInt = (peek('Version_Major', 0, 'QVSourceStatus') * 1000) + (peek('Version_Minor', 0, 'QVSourceStatus') * 100) + (peek('Version_Build', 0, 'QVSourceStatus') * 10) + peek('Version_Revision', 0, 'QVSourceStatus')

29/05/2015 11:07:26: 0507    if(currentVersionAsInt < 1475) then

29/05/2015 11:07:26: 0513    QVSourceConnectorStatus:

29/05/2015 11:07:26: 0514        LOAD Name as ConnectorName,

29/05/2015 11:07:26: 0515            Version as ConnectorVersion,

29/05/2015 11:07:26: 0516            Licensed as ConnectorLicensed

29/05/2015 11:07:26: 0517        FROM [http://localhost:5555/QVSource?format=xml] (XmlSimple, Table is [QVSource/Connectors/Connector])

29/05/2015 11:07:26:         3 campi trovati: ConnectorName, ConnectorVersion, ConnectorLicensed, 46 linee recuperate

29/05/2015 11:07:26: 0524    set errormode = 1

29/05/2015 11:07:26: 0526  endsub

29/05/2015 11:07:26: 0865  let fb_pro_pages = '..\QVD\FB_Page.qvd'

29/05/2015 11:07:26: 0867  let size = filesize('..\QVD\FB_Page.qvd')

29/05/2015 11:07:26: 0869  if not isnull(size) then

29/05/2015 11:07:26: 0870    FB_Page:

29/05/2015 11:07:26: 0871     LOAD * FROM '..\QVD\FB_Page.qvd' (qvd)

29/05/2015 11:07:26:         17 campi trovati: page, Page_loaddatetime, Page_loaddate, Page_loadtimestamp, Page_page_id, Page_name, Page_picture, Page_link, Page_likes, Page_category, Page_website, Page_username, Page_founded, Page_company_overview, Page_mission, Page_products, Page_can_post, 1 linee recuperate

29/05/2015 11:07:26: 0872  end if

29/05/2015 11:07:26: 0874  if(vGetLatestData=1) then

29/05/2015 11:07:26: 0876    LET noRows = NoOfRows('FacebookSites')

29/05/2015 11:07:26: 0878    for i=0 to 1-1

29/05/2015 11:07:26: 0880      let page = peek('page', 0, 'FacebookSites')

29/05/2015 11:07:26: 0882      FB_Page:

29/05/2015 11:07:26: 0883       LOAD

29/05/2015 11:07:26: 0884     

29/05/2015 11:07:26: 0885     

29/05/2015 11:07:26: 0886     

29/05/2015 11:07:26: 0887       '276965569137896' as page,

29/05/2015 11:07:26: 0888     

29/05/2015 11:07:26: 0889       '29/05/2015 11:07:22' as Page_loaddatetime,

29/05/2015 11:07:26: 0890     

29/05/2015 11:07:26: 0891       '29/05/2015' as Page_loaddate,

29/05/2015 11:07:26: 0892       timestamp(now(1)) as Page_loadtimestamp,

29/05/2015 11:07:26: 0893     

29/05/2015 11:07:26: 0894     

29/05/2015 11:07:26: 0895     

29/05/2015 11:07:26: 0896       page_id as Page_page_id,

29/05/2015 11:07:26: 0897       name as Page_name,

29/05/2015 11:07:26: 0898       picture as Page_picture,

29/05/2015 11:07:26: 0899       link as Page_link,

29/05/2015 11:07:26: 0900       likes as Page_likes,

29/05/2015 11:07:26: 0901       category as Page_category,

29/05/2015 11:07:26: 0902       website as Page_website,

29/05/2015 11:07:26: 0903       username as Page_username,

29/05/2015 11:07:26: 0904       founded as Page_founded,

29/05/2015 11:07:26: 0905       company_overview as Page_company_overview,

29/05/2015 11:07:26: 0906       mission as Page_mission,

29/05/2015 11:07:26: 0907       products as Page_products,

29/05/2015 11:07:26: 0908       can_post as Page_can_post

29/05/2015 11:07:26: 0909       FROM

29/05/2015 11:07:26: 0910       [http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=Page&FacebookPageOrId=276965569137... Media Analizer]

29/05/2015 11:07:26: 0911       (qvx)

29/05/2015 11:07:30:           17 campi trovati: page, Page_loaddatetime, Page_loaddate, Page_loadtimestamp, Page_page_id, Page_name, Page_picture, Page_link, Page_likes, Page_category, Page_website, Page_username, Page_founded, Page_company_overview, Page_mission, Page_products, Page_can_post, 2 linee recuperate

29/05/2015 11:07:30: 0913      call logQVSourceError(scripterrordetails, 'FacebookPro\Page\276965569137896')

29/05/2015 11:07:30: 0292        if(not isnull(errorDetails)) then

29/05/2015 11:07:30: 0304      end sub

29/05/2015 11:07:30: 0915    next

29/05/2015 11:07:30: 0917    STORE FB_Page INTO '..\QVD\FB_Page.qvd'

29/05/2015 11:07:30: 0919  end if

29/05/2015 11:07:30: 0921  temp_pagesID:  

29/05/2015 11:07:30: 0922  load

29/05/2015 11:07:30: 0923   page,

29/05/2015 11:07:30: 0924   Page_page_id as page_id,

29/05/2015 11:07:30: 0925   sum(Page_likes)

29/05/2015 11:07:30: 0926  resident FB_Page

29/05/2015 11:07:30: 0927  group by page, Page_page_id

29/05/2015 11:07:30:       3 campi trovati: page, page_id, sum(Page_likes), 1 linee recuperate

29/05/2015 11:07:30: 0929  drop table FB_Page

29/05/2015 11:07:30: 0931  let fb_pro_feed = '..\QVD\FB_Feed.qvd'

29/05/2015 11:07:30: 0933  let size = filesize('..\QVD\FB_Feed.qvd')

29/05/2015 11:07:30: 0935  if isnull(size) then

29/05/2015 11:07:30: 0938    let vIsFirstTime = 0

29/05/2015 11:07:30: 0939  end if

29/05/2015 11:07:30: 0941  if(vGetLatestData=1) then

29/05/2015 11:07:30: 0943    LET noRows = NoOfRows('temp_pagesID')

29/05/2015 11:07:30: 0945    for i=0 to 1-1

29/05/2015 11:07:30: 0947      let page = peek('page', 0, 'temp_pagesID')

29/05/2015 11:07:30: 0948      let pageID = peek('page_id', 0, 'temp_pagesID')

29/05/2015 11:07:30: 0950      if(vIsFirstTime=1) then

29/05/2015 11:07:30: 0953        let loadUrl='http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=FeedItems&FacebookPageOrId=2769655... Media Analizer'

29/05/2015 11:07:30: 0954      endif

29/05/2015 11:07:30: 0956      FB_Feed:

29/05/2015 11:07:30: 0957       LOAD

29/05/2015 11:07:30: 0958       '29/05/2015 11:07:22' as FeedItem_loaddate,

29/05/2015 11:07:30: 0959       timestamp(now(1)) as FeedItem_loadtimestamp,

29/05/2015 11:07:30: 0960       '276965569137896' as page,

29/05/2015 11:07:30: 0961       feeditem_id as FeedItem_id,

29/05/2015 11:07:30: 0962       poster_id as Poster_id,

29/05/2015 11:07:30: 0963       if(poster_id = '276965569137896', 'Yes', 'No') as FeedItem_is_self_posted,

29/05/2015 11:07:30: 0964       from_name as FeedItem_from_name,

29/05/2015 11:07:30: 0965       from_category as FeedItem_from_category,

29/05/2015 11:07:30: 0966       type as FeedItem_UpdateType,

29/05/2015 11:07:30: 0967       message as FeedItem_message,

29/05/2015 11:07:30: 0968       message_urlEncoded as FeedItem_message_urlEncoded,

29/05/2015 11:07:30: 0969       comment_link as FeedItems_comment_link,

29/05/2015 11:07:30: 0970       like_link as FeedItems_like_link,

29/05/2015 11:07:30: 0971       picture as FeedItem_picture,

29/05/2015 11:07:30: 0972       link as FeedItem_link,

29/05/2015 11:07:30: 0973       source as FeedItem_source,

29/05/2015 11:07:30: 0974       name as FeedItem_name,

29/05/2015 11:07:30: 0975       caption as FeedItem_caption,

29/05/2015 11:07:30: 0976       description as FeedItem_description,

29/05/2015 11:07:30: 0977       icon as FeedItem_icon,

29/05/2015 11:07:30: 0978       created as FeedItem_created,

29/05/2015 11:07:30: 0979       updated as FeedItem_updated,

29/05/2015 11:07:30: 0980       object_id as FeedItem_object_id,

29/05/2015 11:07:30: 0981       has_likes as FeedItem_has_likes,

29/05/2015 11:07:30: 0982       has_at_least_this_many_likes as FeedItem_has_at_least_this_many_likes,

29/05/2015 11:07:30: 0983       if(has_at_least_this_many_likes <= 24, has_at_least_this_many_likes, '> 24') as FeedItem_likes_count_tmp,

29/05/2015 11:07:30: 0984       has_comments as FeedItem_has_comments,

29/05/2015 11:07:30: 0985       has_at_least_this_many_comments as FeedItem_has_at_least_this_many_comments,

29/05/2015 11:07:30: 0986       if(has_at_least_this_many_comments <= 24, has_at_least_this_many_comments, '> 24') as FeedItem_comments_count_tmp,

29/05/2015 11:07:30: 0987       shares_count as FeedItem_shares_count,

29/05/2015 11:07:30: 0988       from_id as FeedItem_from_id,

29/05/2015 11:07:30: 0989       status_type as FeedItem_status_type,

29/05/2015 11:07:30: 0990       to_id as FeedItem_to_id,

29/05/2015 11:07:30: 0991       to_name as FeedItem_to_name,

29/05/2015 11:07:30: 0992       to_category as FeedItem_to_category,

29/05/2015 11:07:30: 0993       story as FeedItem_story,

29/05/2015 11:07:30: 0994       application_name as FeedItem_application_name,

29/05/2015 11:07:30: 0995       application_namespace as FeedItem_application_namespace,

29/05/2015 11:07:30: 0996       application_id as FeedItem_application_id

29/05/2015 11:07:30: 0997       FROM

29/05/2015 11:07:30: 0998       [http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=FeedItems&FacebookPageOrId=2769655... Media Analizer]

29/05/2015 11:07:30: 0999       (qvx)

29/05/2015 11:07:31:           39 campi trovati: FeedItem_loaddate, FeedItem_loadtimestamp, page, FeedItem_id, Poster_id, FeedItem_is_self_posted, FeedItem_from_name, FeedItem_from_category, FeedItem_UpdateType, FeedItem_message, FeedItem_message_urlEncoded, FeedItems_comment_link, FeedItems_like_link, FeedItem_picture, FeedItem_link, FeedItem_source, FeedItem_name, FeedItem_caption, FeedItem_description, FeedItem_icon, FeedItem_created, FeedItem_updated, FeedItem_object_id, FeedItem_has_likes, FeedItem_has_at_least_this_many_likes, FeedItem_likes_count_tmp, FeedItem_has_comments, FeedItem_has_at_least_this_many_comments, FeedItem_comments_count_tmp, FeedItem_shares_count, FeedItem_from_id, FeedItem_status_type, FeedItem_to_id, FeedItem_to_name, FeedItem_to_category, FeedItem_story, FeedItem_application_name, FeedItem_application_namespace, FeedItem_application_id, 33 linee recuperate

29/05/2015 11:07:32: 1003    next

29/05/2015 11:07:32: 1005    let vParamsFile = 'c:\QVSource\Temp\Social Media Analizer' & '_FeedItemIdsToCountComments.txt'

29/05/2015 11:07:32: 1007    Params:

29/05/2015 11:07:32: 1008     LOAD distinct

29/05/2015 11:07:32: 1009        FeedItem_id as rowKey,

29/05/2015 11:07:32: 1010        FeedItem_id as ObjectId

29/05/2015 11:07:32: 1011     resident

29/05/2015 11:07:32: 1012     FB_Feed

29/05/2015 11:07:32: 1013     where FeedItem_has_at_least_this_many_comments > 24

29/05/2015 11:07:32:         2 campi trovati: rowKey, ObjectId, 0 linee recuperate

29/05/2015 11:07:32: 1015    store Params into 'c:\QVSource\Temp\Social Media Analizer_FeedItemIdsToCountComments.txt' (txt)

29/05/2015 11:07:32: 1017    let vCount = NoOfRows('Params')

29/05/2015 11:07:32: 1019    DROP table Params

29/05/2015 11:07:32: 1021    if (vCount > 0 and vLoadCommentCountForFeedItems = 1) then

29/05/2015 11:07:32: 1046      rename field FeedItem_comments_count_tmp to FeedItem_comments_count

29/05/2015 11:07:32: 1047    endif

29/05/2015 11:07:32: 1049    let vParamsFile = 'c:\QVSource\Temp\Social Media Analizer' & '_FeedItemIdsToCountLikes.txt'

29/05/2015 11:07:32: 1051    Params:

29/05/2015 11:07:32: 1052     LOAD distinct

29/05/2015 11:07:32: 1053        FeedItem_id as rowKey,

29/05/2015 11:07:32: 1054        FeedItem_id as ObjectId

29/05/2015 11:07:32: 1055     resident

29/05/2015 11:07:32: 1056     FB_Feed

29/05/2015 11:07:32: 1057     where FeedItem_has_at_least_this_many_likes > 24

29/05/2015 11:07:32:         2 campi trovati: rowKey, ObjectId, 4 linee recuperate

29/05/2015 11:07:32: 1059    store Params into 'c:\QVSource\Temp\Social Media Analizer_FeedItemIdsToCountLikes.txt' (txt)

29/05/2015 11:07:32: 1061    let vCount = NoOfRows('Params')

29/05/2015 11:07:32: 1063    DROP table Params

29/05/2015 11:07:32: 1065    if (vCount > 0 and vLoadLikeCountForFeedItems = 1) then

29/05/2015 11:07:32: 1067      trace 'About to check like count for 4 feed items asynchronously. Might take some time...'

29/05/2015 11:07:32: 1067      'About to check like count for 4 feed items asynchronously. Might take some time...'

29/05/2015 11:07:32: 1069      join (FB_Feed)

29/05/2015 11:07:32: 1070       LOAD

29/05/2015 11:07:32: 1071       rowKey as FeedItem_id,

29/05/2015 11:07:32: 1072       total_count as FeedItem_likes_count_aboveThresholdCount

29/05/2015 11:07:32: 1073       FROM 

29/05/2015 11:07:32: 1074       [http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=LikeCountForItem&appID=Social Media Analizer&processParamsAsync=c:\QVSource\Temp\Social Media Analizer_FeedItemIdsToCountLikes.txt]

29/05/2015 11:07:32: 1075       (qvx)

29/05/2015 11:07:32:           2 campi trovati: FeedItem_id, FeedItem_likes_count_aboveThresholdCount, 4 linee recuperate

29/05/2015 11:07:32:           Joining/Keeping

29/05/2015 11:07:32: 1077      FB_Feed2:

29/05/2015 11:07:32: 1078       load

29/05/2015 11:07:32: 1079       *,

29/05/2015 11:07:32: 1080       if(isnull(FeedItem_likes_count_aboveThresholdCount), FeedItem_likes_count_tmp, FeedItem_likes_count_aboveThresholdCount) as FeedItem_likes_count

29/05/2015 11:07:32: 1081       resident

29/05/2015 11:07:32: 1082       FB_Feed

29/05/2015 11:07:32:           41 campi trovati: FeedItem_id, FeedItem_loaddate, FeedItem_loadtimestamp, page, Poster_id, FeedItem_is_self_posted, FeedItem_from_name, FeedItem_from_category, FeedItem_UpdateType, FeedItem_message, FeedItem_message_urlEncoded, FeedItems_comment_link, FeedItems_like_link, FeedItem_picture, FeedItem_link, FeedItem_source, FeedItem_name, FeedItem_caption, FeedItem_description, FeedItem_icon, FeedItem_created, FeedItem_updated, FeedItem_object_id, FeedItem_has_likes, FeedItem_has_at_least_this_many_likes, FeedItem_likes_count_tmp, FeedItem_has_comments, FeedItem_has_at_least_this_many_comments, FeedItem_comments_count, FeedItem_shares_count, FeedItem_from_id, FeedItem_status_type, FeedItem_to_id, FeedItem_to_name, FeedItem_to_category, FeedItem_story, FeedItem_application_name, FeedItem_application_namespace, FeedItem_application_id, FeedItem_likes_count_aboveThresholdCount, FeedItem_likes_count, 33 linee recuperate

29/05/2015 11:07:32: 1084      drop table FB_Feed

29/05/2015 11:07:32: 1085      drop field FeedItem_likes_count_tmp

29/05/2015 11:07:32: 1086      drop field FeedItem_likes_count_aboveThresholdCount

29/05/2015 11:07:32: 1087      rename table FB_Feed2 to FB_Feed

29/05/2015 11:07:32: 1088    else

29/05/2015 11:07:32: 1097    trace 'Establishing number of feed items with comments to load in this run...'

29/05/2015 11:07:32: 1097    'Establishing number of feed items with comments to load in this run...'

29/05/2015 11:07:32: 1099    FB_FeedItemsWithCommentsLoadedInThisRun:

29/05/2015 11:07:32: 1100     load

29/05/2015 11:07:32: 1101     page as FB_FeedItemsLoadedInThisRun_page,

29/05/2015 11:07:32: 1102     FeedItem_id as FB_FeedItemsLoadedInThisRun_id

29/05/2015 11:07:32: 1103     resident

29/05/2015 11:07:32: 1104     FB_Feed

29/05/2015 11:07:32: 1105     where FeedItem_has_comments = 'True'

29/05/2015 11:07:32:         2 campi trovati: FB_FeedItemsLoadedInThisRun_page, FB_FeedItemsLoadedInThisRun_id, 3 linee recuperate

29/05/2015 11:07:32: 1107    if not isnull(size) then

29/05/2015 11:07:32: 1108      FB_Feed:

29/05/2015 11:07:32: 1109       LOAD * FROM '..\QVD\FB_Feed.qvd' (qvd)

29/05/2015 11:07:32: 1110       where not exists (FeedItem_id)

29/05/2015 11:07:32:           39 campi trovati: FeedItem_id, FeedItem_loaddate, FeedItem_loadtimestamp, page, Poster_id, FeedItem_is_self_posted, FeedItem_from_name, FeedItem_from_category, FeedItem_UpdateType, FeedItem_message, FeedItem_message_urlEncoded, FeedItems_comment_link, FeedItems_like_link, FeedItem_picture, FeedItem_link, FeedItem_source, FeedItem_name, FeedItem_caption, FeedItem_description, FeedItem_icon, FeedItem_created, FeedItem_updated, FeedItem_object_id, FeedItem_has_likes, FeedItem_has_at_least_this_many_likes, FeedItem_has_comments, FeedItem_has_at_least_this_many_comments, FeedItem_comments_count, FeedItem_shares_count, FeedItem_from_id, FeedItem_status_type, FeedItem_to_id, FeedItem_to_name, FeedItem_to_category, FeedItem_story, FeedItem_application_name, FeedItem_application_namespace, FeedItem_application_id, FeedItem_likes_count, 33 linee recuperate

29/05/2015 11:07:32: 1111    endif

29/05/2015 11:07:32: 1113    STORE FB_Feed INTO '..\QVD\FB_Feed.qvd'

29/05/2015 11:07:32: 1115  ELSE

29/05/2015 11:07:32: 1122  if vDeleteTempTables = 1 then

29/05/2015 11:07:32: 1123    drop table temp_pagesID

29/05/2015 11:07:32: 1124  endif

29/05/2015 11:07:32: 1127  let fb_pro_comments = '..\QVD\FB_Comments.qvd'

29/05/2015 11:07:32: 1129  let size = filesize('..\QVD\FB_Comments.qvd')

29/05/2015 11:07:32: 1131  if(vGetLatestData=1) then

29/05/2015 11:07:32: 1133    LET noRows = NoOfRows('FB_FeedItemsWithCommentsLoadedInThisRun')

29/05/2015 11:07:32: 1135    if vAsyncComments = 1 then

29/05/2015 11:07:32: 1137      let vParamsFile = 'c:\QVSource\Temp\Social Media Analizer' & '_FeedItems.txt'

29/05/2015 11:07:32: 1139      Params:

29/05/2015 11:07:32: 1140       LOAD

29/05/2015 11:07:32: 1141          FB_FeedItemsLoadedInThisRun_page as rowKey,

29/05/2015 11:07:32: 1142          FB_FeedItemsLoadedInThisRun_id as rowKey2,

29/05/2015 11:07:32: 1143          FB_FeedItemsLoadedInThisRun_id as ObjectId,

29/05/2015 11:07:32: 1144          '10' as MaxNumberOfItems

29/05/2015 11:07:32: 1145       resident

29/05/2015 11:07:32: 1146       FB_FeedItemsWithCommentsLoadedInThisRun

29/05/2015 11:07:32:           4 campi trovati: rowKey, rowKey2, ObjectId, MaxNumberOfItems, 3 linee recuperate

29/05/2015 11:07:32: 1148      store Params into 'c:\QVSource\Temp\Social Media Analizer_FeedItems.txt' (txt)

29/05/2015 11:07:32: 1150      if(NoOfRows('Params') > 0) then

29/05/2015 11:07:32: 1152        Trace 'About to extract comments and comment replies asynchronously...'

29/05/2015 11:07:32: 1152        'About to extract comments and comment replies asynchronously...'

29/05/2015 11:07:32: 1154        TempCommentAndReplies:

29/05/2015 11:07:32: 1155         LOAD

29/05/2015 11:07:32: 1156         '29/05/2015 11:07:22' as Comment_loaddate,

29/05/2015 11:07:32: 1157         rowKey as Comment_page,

29/05/2015 11:07:32: 1158         timestamp(now(1)) as Comment_loadtimestamp,

29/05/2015 11:07:32: 1159         rowKey2 as FeedItem_id,

29/05/2015 11:07:32: 1160         id as CommentsAndRepliesForItem_id,

29/05/2015 11:07:32: 1161         commentor_id as commentor_id,

29/05/2015 11:07:32: 1162         commentor_name as CommentsAndRepliesForItem_commentor_name,

29/05/2015 11:07:32: 1163         message as CommentsAndRepliesForItem_message,

29/05/2015 11:07:32: 1164         message_urlEncoded as CommentsAndRepliesForItem_message_urlEncoded,

29/05/2015 11:07:32: 1165         created_time as Comment_created,

29/05/2015 11:07:32: 1166         likes_count as CommentsAndRepliesForItem_likes_count,

29/05/2015 11:07:32: 1167         comment_count as CommentsAndRepliesForItem_comment_count,

29/05/2015 11:07:32: 1168         parent_id as CommentsAndRepliesForItem_parent_id,

29/05/2015 11:07:32: 1169         parent_commentor_id as CommentsAndRepliesForItem_parent_commentor_id,

29/05/2015 11:07:32: 1170         parent_commentor_name as CommentsAndRepliesForItem_parent_commentor_name,

29/05/2015 11:07:32: 1171         parent_message as CommentsAndRepliesForItem_parent_message,

29/05/2015 11:07:32: 1172         parent_message_urlEncoded as CommentsAndRepliesForItem_parent_message_urlEncoded,

29/05/2015 11:07:32: 1173         parent_created_time as CommentsAndRepliesForItem_parent_created_time,

29/05/2015 11:07:32: 1174         parent_likes_count as CommentsAndRepliesForItem_parent_likes_count

29/05/2015 11:07:32: 1175         FROM

29/05/2015 11:07:32: 1176         [http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=CommentsAndRepliesForItem&appID=So... Media Analizer&processParamsAsync=c:\QVSource\Temp\Social Media Analizer_FeedItems.txt&noCache=false]

29/05/2015 11:07:32: 1177         (qvx)

29/05/2015 11:07:33:             19 campi trovati: Comment_loaddate, Comment_page, Comment_loadtimestamp, FeedItem_id, CommentsAndRepliesForItem_id, commentor_id, CommentsAndRepliesForItem_commentor_name, CommentsAndRepliesForItem_message, CommentsAndRepliesForItem_message_urlEncoded, Comment_created, CommentsAndRepliesForItem_likes_count, CommentsAndRepliesForItem_comment_count, CommentsAndRepliesForItem_parent_id, CommentsAndRepliesForItem_parent_commentor_id, CommentsAndRepliesForItem_parent_commentor_name, CommentsAndRepliesForItem_parent_message, CommentsAndRepliesForItem_parent_message_urlEncoded, CommentsAndRepliesForItem_parent_created_time, CommentsAndRepliesForItem_parent_likes_count, 7 linee recuperate

29/05/2015 11:07:33: 1179      endif

29/05/2015 11:07:33: 1181      drop table Params

29/05/2015 11:07:33: 1183    else

29/05/2015 11:07:33: 1221    FB_Comments:

29/05/2015 11:07:33: 1222     LOAD

29/05/2015 11:07:33: 1223     Comment_loaddate,

29/05/2015 11:07:33: 1224     Comment_page,

29/05/2015 11:07:33: 1225     Comment_loadtimestamp,

29/05/2015 11:07:33: 1226     FeedItem_id,

29/05/2015 11:07:33: 1227     Comment_created,

29/05/2015 11:07:33: 1228     CommentsAndRepliesForItem_id as Comment_id,

29/05/2015 11:07:33: 1229     commentor_id as Commenter_id,

29/05/2015 11:07:33: 1230     CommentsAndRepliesForItem_commentor_name as Comment_user_name,

29/05/2015 11:07:33: 1231     CommentsAndRepliesForItem_message as Comment_message,

29/05/2015 11:07:33: 1232     CommentsAndRepliesForItem_message_urlEncoded as Comment_message_urlEncoded,

29/05/2015 11:07:33: 1233     CommentsAndRepliesForItem_likes_count as Comment_likes_count,

29/05/2015 11:07:33: 1234     CommentsAndRepliesForItem_comment_count as 'Comment_count',

29/05/2015 11:07:33: 1235     '' as 'InReplyToCommentId',

29/05/2015 11:07:33: 1236     'false' as Comment_isReplyToComment

29/05/2015 11:07:33: 1237     resident TempCommentAndReplies

29/05/2015 11:07:33: 1238     where CommentsAndRepliesForItem_parent_id = ''

29/05/2015 11:07:33:         14 campi trovati: Comment_loaddate, Comment_page, Comment_loadtimestamp, FeedItem_id, Comment_created, Comment_id, Commenter_id, Comment_user_name, Comment_message, Comment_message_urlEncoded, Comment_likes_count, Comment_count, InReplyToCommentId, Comment_isReplyToComment, 5 linee recuperate

29/05/2015 11:07:33: 1240    FB_Comments:

29/05/2015 11:07:33: 1241     LOAD

29/05/2015 11:07:33: 1242     Comment_loaddate,

29/05/2015 11:07:33: 1243     Comment_page,

29/05/2015 11:07:33: 1244     Comment_loadtimestamp,

29/05/2015 11:07:33: 1245     FeedItem_id,

29/05/2015 11:07:33: 1246     Comment_created,

29/05/2015 11:07:33: 1247     CommentsAndRepliesForItem_id as Comment_id,

29/05/2015 11:07:33: 1248     CommentsAndRepliesForItem_parent_commentor_id as Commenter_id,

29/05/2015 11:07:33: 1249     CommentsAndRepliesForItem_parent_commentor_name as Comment_user_name,

29/05/2015 11:07:33: 1250     CommentsAndRepliesForItem_parent_message as Comment_message,

29/05/2015 11:07:33: 1251     CommentsAndRepliesForItem_parent_message_urlEncoded as Comment_message_urlEncoded,

29/05/2015 11:07:33: 1252     CommentsAndRepliesForItem_parent_likes_count as Comment_likes_count,

29/05/2015 11:07:33: 1253     0 as 'Comment_count',

29/05/2015 11:07:33: 1254     CommentsAndRepliesForItem_parent_id as 'InReplyToCommentId',

29/05/2015 11:07:33: 1255     'true' as Comment_isReplyToComment

29/05/2015 11:07:33: 1256     resident TempCommentAndReplies

29/05/2015 11:07:33: 1257     where CommentsAndRepliesForItem_parent_id <> ''

29/05/2015 11:07:33:         14 campi trovati: Comment_loaddate, Comment_page, Comment_loadtimestamp, FeedItem_id, Comment_created, Comment_id, Commenter_id, Comment_user_name, Comment_message, Comment_message_urlEncoded, Comment_likes_count, Comment_count, InReplyToCommentId, Comment_isReplyToComment, 7 linee recuperate

29/05/2015 11:07:33: 1259    drop table TempCommentAndReplies

29/05/2015 11:07:33: 1263    if not isnull(size) then

29/05/2015 11:07:33: 1264      FB_Comments:

29/05/2015 11:07:33: 1265       LOAD * FROM '..\QVD\FB_Comments.qvd' (qvd)

29/05/2015 11:07:33: 1266       WHERE NOT EXISTS (Comment_id)

29/05/2015 11:07:33:           14 campi trovati: Comment_loaddate, Comment_page, Comment_loadtimestamp, FeedItem_id, Comment_created, Comment_id, Commenter_id, Comment_user_name, Comment_message, Comment_message_urlEncoded, Comment_likes_count, Comment_count, InReplyToCommentId, Comment_isReplyToComment, 7 linee recuperate

29/05/2015 11:07:33: 1267    endif

29/05/2015 11:07:33: 1269    let vSentimentTableNo = TableNumber('Sentiment')

29/05/2015 11:07:33: 1271    if not isnull(TableNumber('FB_Comments')) then

29/05/2015 11:07:33: 1272      STORE FB_Comments INTO '..\QVD\FB_Comments.qvd'

29/05/2015 11:07:33: 1273    endif

29/05/2015 11:07:33: 1277  end if

29/05/2015 11:07:33: 1279  if vDeleteTempTables = 1 then

29/05/2015 11:07:33: 1280    drop table FB_FeedItemsWithCommentsLoadedInThisRun

29/05/2015 11:07:33: 1281  endif

29/05/2015 11:07:33: 1283  let tw_pro_search = '..\QVD\TW_Search.qvd'

29/05/2015 11:07:33: 1285  let size = filesize('..\QVD\TW_Search.qvd')

29/05/2015 11:07:33: 1287  if not isnull(size) then

29/05/2015 11:07:33: 1288    TW_Search:

29/05/2015 11:07:33: 1289     LOAD * FROM '..\QVD\TW_Search.qvd' (qvd)

29/05/2015 11:07:33:         64 campi trovati: Search_id, Search_created_at, Search_created_at_timestamp, Search_created_at_date, Search_created_at_time, Search_text, Search_text_urlEncoded, Search_lang, Search_source, Search_truncated, Search_in_reply_to_screen_name, Search_in_reply_to_status_id, Search_in_reply_to_user_id, Search_retweet_count, Search_favorite_count, Search_retweeted, Search_favorited, Search_possibly_sensitive, Search_hashtag_count, Search_hash_tags, Search_first_hash_tag, Search_url_count, Search_expanded_urls, Search_first_expanded_url, Search_user_mentions_count, Search_user_mentions, Search_first_user_mention, Search_media_count, Search_media_expanded_urls, Search_first_media_expanded_url, Search_symbols_count, Search_symbols, Search_first_symbol, Search_media_photo_count, Search_media_photo_urls, Search_first_media_photo_url, Search_metadata_result_type, Search_metadata_iso_language_code, Search_user_id, Search_user_name, Search_user_screen_name, Search_user_location, Search_user_profile_image_url, Search_user_description, Search_user_url, Search_user_geo_enabled, Search_user_protected, Search_user_followers_count, Search_user_friends_count, Search_user_listed_count, Search_user_favourites_count, Search_user_statuses_count, Search_user_created_at, Search_user_user_created_at_timestamp, Search_user_user_created_at_date, Search_user_user_created_at_time, Search_user_utc_offset, Search_user_time_zone, Search_user_verified, Search_user_lang, Search_user_follow_request_sent, Search_user_is_translator, Search_user_following, Search_user_notifications, 98 linee recuperate

29/05/2015 11:07:33: 1290  end if

29/05/2015 11:07:33: 1292  if(vGetLatestData=1) then

29/05/2015 11:07:33: 1294    let noRows = NoOfRows('TwitterSites')

29/05/2015 11:07:33: 1296    for i=0 to 2-1

29/05/2015 11:07:33: 1298      let site = peek('tSite', 0, 'TwitterSites')

29/05/2015 11:07:33: 1299      let page = peek('tpage', 0, 'TwitterSites')

29/05/2015 11:07:33: 1301      TW_Search:

29/05/2015 11:07:33: 1302      LOAD

29/05/2015 11:07:33: 1303         

29/05/2015 11:07:33: 1304          id as Search_id,

29/05/2015 11:07:33: 1305       created_at as Search_created_at,

29/05/2015 11:07:33: 1306       timestamp#(mid(created_at, 9, 2) & '-' & mid(created_at, 5, 3) & '-' & mid(created_at, 27, 4) & ' ' & mid(created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as Search_created_at_timestamp,

29/05/2015 11:07:33: 1307       date#(mid(created_at, 9, 2) & '-' & mid(created_at, 5, 3) & '-' & mid(created_at, 27, 4), 'DD-MMM-YYYY') as Search_created_at_date,

29/05/2015 11:07:33: 1308     

29/05/2015 11:07:33: 1309       time#(mid(created_at, 12, 8), 'hh:mm:ss') as Search_created_at_time,

29/05/2015 11:07:33: 1310       text as Search_text,

29/05/2015 11:07:33: 1311       text_urlEncoded as Search_text_urlEncoded,

29/05/2015 11:07:33: 1312       lang as Search_lang,

29/05/2015 11:07:33: 1313       source as Search_source,

29/05/2015 11:07:33: 1314       truncated as Search_truncated,

29/05/2015 11:07:33: 1315       in_reply_to_screen_name as Search_in_reply_to_screen_name,

29/05/2015 11:07:33: 1316       in_reply_to_status_id as Search_in_reply_to_status_id,

29/05/2015 11:07:33: 1317       in_reply_to_user_id as Search_in_reply_to_user_id,

29/05/2015 11:07:33: 1318       retweet_count as Search_retweet_count,

29/05/2015 11:07:33: 1319       favorite_count as Search_favorite_count,

29/05/2015 11:07:33: 1320       retweeted as Search_retweeted,

29/05/2015 11:07:33: 1321       favorited as Search_favorited,

29/05/2015 11:07:33: 1322       possibly_sensitive as Search_possibly_sensitive,

29/05/2015 11:07:33: 1323       hashtag_count as Search_hashtag_count,

29/05/2015 11:07:33: 1324       hash_tags as Search_hash_tags,

29/05/2015 11:07:33: 1325       first_hash_tag as Search_first_hash_tag,

29/05/2015 11:07:33: 1326       url_count as Search_url_count,

29/05/2015 11:07:33: 1327       expanded_urls as Search_expanded_urls,

29/05/2015 11:07:33: 1328       first_expanded_url as Search_first_expanded_url,

29/05/2015 11:07:33: 1329       user_mentions_count as Search_user_mentions_count,

29/05/2015 11:07:33: 1330       user_mentions as Search_user_mentions,

29/05/2015 11:07:33: 1331       first_user_mention as Search_first_user_mention,

29/05/2015 11:07:33: 1332       media_count as Search_media_count,

29/05/2015 11:07:33: 1333       media_expanded_urls as Search_media_expanded_urls,

29/05/2015 11:07:33: 1334       first_media_expanded_url as Search_first_media_expanded_url,

29/05/2015 11:07:33: 1335       symbols_count as Search_symbols_count,

29/05/2015 11:07:33: 1336       symbols as Search_symbols,

29/05/2015 11:07:33: 1337       first_symbol as Search_first_symbol,

29/05/2015 11:07:33: 1338       media_photo_count as Search_media_photo_count,

29/05/2015 11:07:33: 1339       media_photo_urls as Search_media_photo_urls,

29/05/2015 11:07:33: 1340       first_media_photo_url as Search_first_media_photo_url,

29/05/2015 11:07:33: 1341       metadata_result_type as Search_metadata_result_type,

29/05/2015 11:07:33: 1342       metadata_iso_language_code as Search_metadata_iso_language_code,

29/05/2015 11:07:33: 1343       user_id as Search_user_id,

29/05/2015 11:07:33: 1344       user_name as Search_user_name,

29/05/2015 11:07:33: 1345       user_screen_name as Search_user_screen_name,

29/05/2015 11:07:33: 1346       user_location as Search_user_location,

29/05/2015 11:07:33: 1347       user_profile_image_url as Search_user_profile_image_url,

29/05/2015 11:07:33: 1348       user_description as Search_user_description,

29/05/2015 11:07:33: 1349       user_url as Search_user_url,

29/05/2015 11:07:33: 1350       user_geo_enabled as Search_user_geo_enabled,

29/05/2015 11:07:33: 1351       user_protected as Search_user_protected,

29/05/2015 11:07:33: 1352       user_followers_count as Search_user_followers_count,

29/05/2015 11:07:33: 1353       user_friends_count as Search_user_friends_count,

29/05/2015 11:07:33: 1354       user_listed_count as Search_user_listed_count,

29/05/2015 11:07:33: 1355       user_favourites_count as Search_user_favourites_count,

29/05/2015 11:07:33: 1356       user_statuses_count as Search_user_statuses_count,

29/05/2015 11:07:33: 1357       user_created_at as Search_user_created_at,

29/05/2015 11:07:33: 1358       timestamp#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4) & ' ' & mid(user_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as Search_user_user_created_at_timestamp,

29/05/2015 11:07:33: 1359       date#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4), 'DD-MMM-YYYY') as Search_user_user_created_at_date,

29/05/2015 11:07:33: 1360       time#(mid(user_created_at, 12, 8), 'hh:mm:ss') as Search_user_user_created_at_time,

29/05/2015 11:07:33: 1361       user_utc_offset as Search_user_utc_offset,

29/05/2015 11:07:33: 1362       user_time_zone as Search_user_time_zone,

29/05/2015 11:07:33: 1363       user_verified as Search_user_verified,

29/05/2015 11:07:33: 1364       user_lang as Search_user_lang,

29/05/2015 11:07:33: 1365       user_follow_request_sent as Search_user_follow_request_sent,

29/05/2015 11:07:33: 1366       user_is_translator as Search_user_is_translator,

29/05/2015 11:07:33: 1367       user_following as Search_user_following,

29/05/2015 11:07:33: 1368       user_notifications as Search_user_notifications

29/05/2015 11:07:33: 1369      FROM

29/05/2015 11:07:33: 1370        [http://localhost:5555/QVSource/TwitterConnectorV2/?table=Search&appID=Social Media Analizer&tokenEncrypted=&tokenSecretEncrypted=ToTl4J9%2fLaYChHFpUMGe6lPYvCQDoN0k0wRi43JU%2fbLOBTOGmfYbe1jg4KiY%2fyOJ&StartDate=29-04-2015&noCache=false&searchTerm=Bancadinamica](qvx)

29/05/2015 11:07:34:           64 campi trovati: Search_id, Search_created_at, Search_created_at_timestamp, Search_created_at_date, Search_created_at_time, Search_text, Search_text_urlEncoded, Search_lang, Search_source, Search_truncated, Search_in_reply_to_screen_name, Search_in_reply_to_status_id, Search_in_reply_to_user_id, Search_retweet_count, Search_favorite_count, Search_retweeted, Search_favorited, Search_possibly_sensitive, Search_hashtag_count, Search_hash_tags, Search_first_hash_tag, Search_url_count, Search_expanded_urls, Search_first_expanded_url, Search_user_mentions_count, Search_user_mentions, Search_first_user_mention, Search_media_count, Search_media_expanded_urls, Search_first_media_expanded_url, Search_symbols_count, Search_symbols, Search_first_symbol, Search_media_photo_count, Search_media_photo_urls, Search_first_media_photo_url, Search_metadata_result_type, Search_metadata_iso_language_code, Search_user_id, Search_user_name, Search_user_screen_name, Search_user_location, Search_user_profile_image_url, Search_user_description, Search_user_url, Search_user_geo_enabled, Search_user_protected, Search_user_followers_count, Search_user_friends_count, Search_user_listed_count, Search_user_favourites_count, Search_user_statuses_count, Search_user_created_at, Search_user_user_created_at_timestamp, Search_user_user_created_at_date, Search_user_user_created_at_time, Search_user_utc_offset, Search_user_time_zone, Search_user_verified, Search_user_lang, Search_user_follow_request_sent, Search_user_is_translator, Search_user_following, Search_user_notifications, 147 linee recuperate

29/05/2015 11:07:34: 1372      call logQVSourceError(scripterrordetails, 'Twitter\Page\Bancadinamica')

29/05/2015 11:07:34: 0292        if(not isnull(errorDetails)) then

29/05/2015 11:07:34: 0304      end sub

29/05/2015 11:07:34: 1374    next

29/05/2015 11:07:34: 1298      let site = peek('tSite', 1, 'TwitterSites')

29/05/2015 11:07:34: 1299      let page = peek('tpage', 1, 'TwitterSites')

29/05/2015 11:07:34: 1301      TW_Search:

29/05/2015 11:07:34: 1302      LOAD

29/05/2015 11:07:34: 1303         

29/05/2015 11:07:34: 1304          id as Search_id,

29/05/2015 11:07:34: 1305       created_at as Search_created_at,

29/05/2015 11:07:34: 1306       timestamp#(mid(created_at, 9, 2) & '-' & mid(created_at, 5, 3) & '-' & mid(created_at, 27, 4) & ' ' & mid(created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as Search_created_at_timestamp,

29/05/2015 11:07:34: 1307       date#(mid(created_at, 9, 2) & '-' & mid(created_at, 5, 3) & '-' & mid(created_at, 27, 4), 'DD-MMM-YYYY') as Search_created_at_date,

29/05/2015 11:07:34: 1308     

29/05/2015 11:07:34: 1309       time#(mid(created_at, 12, 8), 'hh:mm:ss') as Search_created_at_time,

29/05/2015 11:07:34: 1310       text as Search_text,

29/05/2015 11:07:34: 1311       text_urlEncoded as Search_text_urlEncoded,

29/05/2015 11:07:34: 1312       lang as Search_lang,

29/05/2015 11:07:34: 1313       source as Search_source,

29/05/2015 11:07:34: 1314       truncated as Search_truncated,

29/05/2015 11:07:34: 1315       in_reply_to_screen_name as Search_in_reply_to_screen_name,

29/05/2015 11:07:34: 1316       in_reply_to_status_id as Search_in_reply_to_status_id,

29/05/2015 11:07:34: 1317       in_reply_to_user_id as Search_in_reply_to_user_id,

29/05/2015 11:07:34: 1318       retweet_count as Search_retweet_count,

29/05/2015 11:07:34: 1319       favorite_count as Search_favorite_count,

29/05/2015 11:07:34: 1320       retweeted as Search_retweeted,

29/05/2015 11:07:34: 1321       favorited as Search_favorited,

29/05/2015 11:07:34: 1322       possibly_sensitive as Search_possibly_sensitive,

29/05/2015 11:07:34: 1323       hashtag_count as Search_hashtag_count,

29/05/2015 11:07:34: 1324       hash_tags as Search_hash_tags,

29/05/2015 11:07:34: 1325       first_hash_tag as Search_first_hash_tag,

29/05/2015 11:07:34: 1326       url_count as Search_url_count,

29/05/2015 11:07:34: 1327       expanded_urls as Search_expanded_urls,

29/05/2015 11:07:34: 1328       first_expanded_url as Search_first_expanded_url,

29/05/2015 11:07:34: 1329       user_mentions_count as Search_user_mentions_count,

29/05/2015 11:07:34: 1330       user_mentions as Search_user_mentions,

29/05/2015 11:07:34: 1331       first_user_mention as Search_first_user_mention,

29/05/2015 11:07:34: 1332       media_count as Search_media_count,

29/05/2015 11:07:34: 1333       media_expanded_urls as Search_media_expanded_urls,

29/05/2015 11:07:34: 1334       first_media_expanded_url as Search_first_media_expanded_url,

29/05/2015 11:07:34: 1335       symbols_count as Search_symbols_count,

29/05/2015 11:07:34: 1336       symbols as Search_symbols,

29/05/2015 11:07:34: 1337       first_symbol as Search_first_symbol,

29/05/2015 11:07:34: 1338       media_photo_count as Search_media_photo_count,

29/05/2015 11:07:34: 1339       media_photo_urls as Search_media_photo_urls,

29/05/2015 11:07:34: 1340       first_media_photo_url as Search_first_media_photo_url,

29/05/2015 11:07:34: 1341       metadata_result_type as Search_metadata_result_type,

29/05/2015 11:07:34: 1342       metadata_iso_language_code as Search_metadata_iso_language_code,

29/05/2015 11:07:34: 1343       user_id as Search_user_id,

29/05/2015 11:07:34: 1344       user_name as Search_user_name,

29/05/2015 11:07:34: 1345       user_screen_name as Search_user_screen_name,

29/05/2015 11:07:34: 1346       user_location as Search_user_location,

29/05/2015 11:07:34: 1347       user_profile_image_url as Search_user_profile_image_url,

29/05/2015 11:07:34: 1348       user_description as Search_user_description,

29/05/2015 11:07:34: 1349       user_url as Search_user_url,

29/05/2015 11:07:34: 1350       user_geo_enabled as Search_user_geo_enabled,

29/05/2015 11:07:34: 1351       user_protected as Search_user_protected,

29/05/2015 11:07:34: 1352       user_followers_count as Search_user_followers_count,

29/05/2015 11:07:34: 1353       user_friends_count as Search_user_friends_count,

29/05/2015 11:07:34: 1354       user_listed_count as Search_user_listed_count,

29/05/2015 11:07:34: 1355       user_favourites_count as Search_user_favourites_count,

29/05/2015 11:07:34: 1356       user_statuses_count as Search_user_statuses_count,

29/05/2015 11:07:34: 1357       user_created_at as Search_user_created_at,

29/05/2015 11:07:34: 1358       timestamp#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4) & ' ' & mid(user_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as Search_user_user_created_at_timestamp,

29/05/2015 11:07:34: 1359       date#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4), 'DD-MMM-YYYY') as Search_user_user_created_at_date,

29/05/2015 11:07:34: 1360       time#(mid(user_created_at, 12, 8), 'hh:mm:ss') as Search_user_user_created_at_time,

29/05/2015 11:07:34: 1361       user_utc_offset as Search_user_utc_offset,

29/05/2015 11:07:34: 1362       user_time_zone as Search_user_time_zone,

29/05/2015 11:07:34: 1363       user_verified as Search_user_verified,

29/05/2015 11:07:34: 1364       user_lang as Search_user_lang,

29/05/2015 11:07:34: 1365       user_follow_request_sent as Search_user_follow_request_sent,

29/05/2015 11:07:34: 1366       user_is_translator as Search_user_is_translator,

29/05/2015 11:07:34: 1367       user_following as Search_user_following,

29/05/2015 11:07:34: 1368       user_notifications as Search_user_notifications

29/05/2015 11:07:34: 1369      FROM

29/05/2015 11:07:34: 1370        [http://localhost:5555/QVSource/TwitterConnectorV2/?table=Search&appID=Social Media Analizer&tokenEncrypted=&tokenSecretEncrypted=ToTl4J9%2fLaYChHFpUMGe6lPYvCQDoN0k0wRi43JU%2fbLOBTOGmfYbe1jg4KiY%2fyOJ&StartDate=29-04-2015&noCache=false&searchTerm=Bancadinamica](qvx)

29/05/2015 11:07:34:           64 campi trovati: Search_id, Search_created_at, Search_created_at_timestamp, Search_created_at_date, Search_created_at_time, Search_text, Search_text_urlEncoded, Search_lang, Search_source, Search_truncated, Search_in_reply_to_screen_name, Search_in_reply_to_status_id, Search_in_reply_to_user_id, Search_retweet_count, Search_favorite_count, Search_retweeted, Search_favorited, Search_possibly_sensitive, Search_hashtag_count, Search_hash_tags, Search_first_hash_tag, Search_url_count, Search_expanded_urls, Search_first_expanded_url, Search_user_mentions_count, Search_user_mentions, Search_first_user_mention, Search_media_count, Search_media_expanded_urls, Search_first_media_expanded_url, Search_symbols_count, Search_symbols, Search_first_symbol, Search_media_photo_count, Search_media_photo_urls, Search_first_media_photo_url, Search_metadata_result_type, Search_metadata_iso_language_code, Search_user_id, Search_user_name, Search_user_screen_name, Search_user_location, Search_user_profile_image_url, Search_user_description, Search_user_url, Search_user_geo_enabled, Search_user_protected, Search_user_followers_count, Search_user_friends_count, Search_user_listed_count, Search_user_favourites_count, Search_user_statuses_count, Search_user_created_at, Search_user_user_created_at_timestamp, Search_user_user_created_at_date, Search_user_user_created_at_time, Search_user_utc_offset, Search_user_time_zone, Search_user_verified, Search_user_lang, Search_user_follow_request_sent, Search_user_is_translator, Search_user_following, Search_user_notifications, 196 linee recuperate

29/05/2015 11:07:34: 1372      call logQVSourceError(scripterrordetails, 'Twitter\Page\Bancadinamica')

29/05/2015 11:07:34: 0292        if(not isnull(errorDetails)) then

29/05/2015 11:07:34: 0304      end sub

29/05/2015 11:07:34: 1374    next

29/05/2015 11:07:34: 1376    STORE TW_Search INTO '..\QVD\TW_Search.qvd'

29/05/2015 11:07:34: 1378  end if

29/05/2015 11:07:34: 1380  let tw_pro_page = '..\QVD\TW_Page.qvd'

29/05/2015 11:07:34: 1382  let size = filesize('..\QVD\TW_Page.qvd')

29/05/2015 11:07:34: 1384  if not isnull(size) then

29/05/2015 11:07:34: 1385    TW_Page:

29/05/2015 11:07:34: 1386     LOAD * FROM '..\QVD\TW_Page.qvd' (qvd)

29/05/2015 11:07:34:         126 campi trovati: UserLookup_user_id, UserLookup_user_name, UserLookup_user_screen_name, UserLookup_user_location, UserLookup_user_profile_image_url, UserLookup_user_description, UserLookup_user_url, UserLookup_user_geo_enabled, UserLookup_user_protected, UserLookup_user_followers_count, UserLookup_user_friends_count, UserLookup_user_listed_count, UserLookup_user_favourites_count, UserLookup_user_statuses_count, UserLookup_user_created_at, UserLookup_user_user_created_at_timestamp, UserLookup_user_user_created_at_date, UserLookup_user_user_created_at_time, UserLookup_user_utc_offset, UserLookup_user_time_zone, UserLookup_user_verified, UserLookup_user_lang, UserLookup_user_follow_request_sent, UserLookup_user_is_translator, UserLookup_user_following, UserLookup_user_notifications, UserLookup_status_id, UserLookup_status_created_at, UserLookup_status_status_created_at_timestamp, UserLookup_status_status_created_at_date, UserLookup_status_status_created_at_time, UserLookup_status_text, UserLookup_status_lang, UserLookup_status_source, UserLookup_status_truncated, UserLookup_status_in_reply_to_screen_name, UserLookup_status_in_reply_to_status_id, UserLookup_status_in_reply_to_user_id, UserLookup_status_retweet_count, UserLookup_status_favorite_count, UserLookup_status_retweeted, UserLookup_status_favorited, UserLookup_status_possibly_sensitive, UserLookup_status_hashtag_count, UserLookup_status_hash_tags, UserLookup_status_first_hash_tag, UserLookup_status_url_count, UserLookup_status_expanded_urls, UserLookup_status_first_expanded_url, UserLookup_status_user_mentions_count, UserLookup_status_user_mentions, UserLookup_status_first_user_mention, UserLookup_status_media_count, UserLookup_status_media_expanded_urls, UserLookup_status_first_media_expanded_url, UserLookup_status_symbols_count, UserLookup_status_symbols, UserLookup_status_first_symbol, UserLookup_status_media_photo_count, UserLookup_status_media_photo_urls, UserLookup_status_first_media_photo_url, UserLookup_status_place_id, UserLookup_status_place_url, UserLookup_status_place_place_type, UserLookup_status_place_name, UserLookup_status_place_full_name, UserLookup_status_place_country_code, UserLookup_status_place_country, UserLookup_status_place_bounding_box_type, UserLookup_status_place_attributes, UserLookup_status_geo_type, UserLookup_status_geo_latitude, UserLookup_status_geo_longitude, UserLookup_status_coordinates_type, UserLookup_status_coordinates_latitude, UserLookup_status_coordinates_longitude, UserLookup_status_retweeted_status_id, UserLookup_status_retweeted_status_created_at, UserLookup_status_retweeted_status_status_retweeted_status_created_at_timestamp, UserLookup_status_retweeted_status_status_retweeted_status_created_at_date, UserLookup_status_retweeted_status_status_retweeted_status_created_at_time, UserLookup_status_retweeted_status_text, UserLookup_status_retweeted_status_lang, UserLookup_status_retweeted_status_source, UserLookup_status_retweeted_status_truncated, UserLookup_status_retweeted_status_in_reply_to_screen_name, UserLookup_status_retweeted_status_in_reply_to_status_id, UserLookup_status_retweeted_status_in_reply_to_user_id, UserLookup_status_retweeted_status_retweet_count, UserLookup_status_retweeted_status_favorite_count, UserLookup_status_retweeted_status_retweeted, UserLookup_status_retweeted_status_favorited, UserLookup_status_retweeted_status_possibly_sensitive, UserLookup_status_retweeted_status_hashtag_count, UserLookup_status_retweeted_status_hash_tags, UserLookup_status_retweeted_status_first_hash_tag, UserLookup_status_retweeted_status_url_count, UserLookup_status_retweeted_status_expanded_urls, UserLookup_status_retweeted_status_first_expanded_url, UserLookup_status_retweeted_status_user_mentions_count, UserLookup_status_retweeted_status_user_mentions, UserLookup_status_retweeted_status_first_user_mention, UserLookup_status_retweeted_status_media_count, UserLookup_status_retweeted_status_media_expanded_urls, UserLookup_status_retweeted_status_first_media_expanded_url, UserLookup_status_retweeted_status_symbols_count, UserLookup_status_retweeted_status_symbols, UserLookup_status_retweeted_status_first_symbol, UserLookup_status_retweeted_status_media_photo_count, UserLookup_status_retweeted_status_media_photo_urls, UserLookup_status_retweeted_status_first_media_photo_url, UserLookup_status_retweeted_status_place_id, UserLookup_status_retweeted_status_place_url, UserLookup_status_retweeted_status_place_place_type, UserLookup_status_retweeted_status_place_name, UserLookup_status_retweeted_status_place_full_name, UserLookup_status_retweeted_status_place_country_code, UserLookup_status_retweeted_status_place_country, UserLookup_status_retweeted_status_place_bounding_box_type, UserLookup_status_retweeted_status_place_attributes, UserLookup_status_retweeted_status_geo_type, UserLookup_status_retweeted_status_geo_latitude, UserLookup_status_retweeted_status_geo_longitude, UserLookup_status_retweeted_status_coordinates_type, UserLookup_status_retweeted_status_coordinates_latitude, UserLookup_status_retweeted_status_coordinates_longitude, 2 linee recuperate

29/05/2015 11:07:34: 1387  end if

29/05/2015 11:07:34: 1389  if(vGetLatestData=1) then

29/05/2015 11:07:34: 1391    let noRows = NoOfRows('TwitterSites')

29/05/2015 11:07:34: 1393    for i=0 to 2-1

29/05/2015 11:07:34: 1395      let site = peek('tSite', 0, 'TwitterSites')

29/05/2015 11:07:34: 1396      let page = peek('tpage', 0, 'TwitterSites')

29/05/2015 11:07:34: 1398      TW_Page:

29/05/2015 11:07:34: 1399      LOAD

29/05/2015 11:07:34: 1400         

29/05/2015 11:07:34: 1401          user_id as UserLookup_user_id,

29/05/2015 11:07:34: 1402       user_name as UserLookup_user_name,

29/05/2015 11:07:34: 1403       user_screen_name as UserLookup_user_screen_name,

29/05/2015 11:07:34: 1404       user_location as UserLookup_user_location,

29/05/2015 11:07:34: 1405       user_profile_image_url as UserLookup_user_profile_image_url,

29/05/2015 11:07:34: 1406       user_description as UserLookup_user_description,

29/05/2015 11:07:34: 1407       user_url as UserLookup_user_url,

29/05/2015 11:07:34: 1408       user_geo_enabled as UserLookup_user_geo_enabled,

29/05/2015 11:07:34: 1409       user_protected as UserLookup_user_protected,

29/05/2015 11:07:34: 1410       user_followers_count as UserLookup_user_followers_count,

29/05/2015 11:07:34: 1411       user_friends_count as UserLookup_user_friends_count,

29/05/2015 11:07:34: 1412       user_listed_count as UserLookup_user_listed_count,

29/05/2015 11:07:34: 1413       user_favourites_count as UserLookup_user_favourites_count,

29/05/2015 11:07:34: 1414       user_statuses_count as UserLookup_user_statuses_count,

29/05/2015 11:07:34: 1415       user_created_at as UserLookup_user_created_at,

29/05/2015 11:07:34: 1416       timestamp#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4) & ' ' & mid(user_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as UserLookup_user_user_created_at_timestamp,

29/05/2015 11:07:34: 1417       date#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4), 'DD-MMM-YYYY') as UserLookup_user_user_created_at_date,

29/05/2015 11:07:34: 1418       time#(mid(user_created_at, 12, 8), 'hh:mm:ss') as UserLookup_user_user_created_at_time,

29/05/2015 11:07:34: 1419       user_utc_offset as UserLookup_user_utc_offset,

29/05/2015 11:07:34: 1420       user_time_zone as UserLookup_user_time_zone,

29/05/2015 11:07:34: 1421       user_verified as UserLookup_user_verified,

29/05/2015 11:07:34: 1422       user_lang as UserLookup_user_lang,

29/05/2015 11:07:34: 1423       user_follow_request_sent as UserLookup_user_follow_request_sent,

29/05/2015 11:07:34: 1424       user_is_translator as UserLookup_user_is_translator,

29/05/2015 11:07:34: 1425       user_following as UserLookup_user_following,

29/05/2015 11:07:34: 1426       user_notifications as UserLookup_user_notifications,

29/05/2015 11:07:34: 1427       status_id as UserLookup_status_id,

29/05/2015 11:07:34: 1428       status_created_at as UserLookup_status_created_at,

29/05/2015 11:07:34: 1429       timestamp#(mid(status_created_at, 9, 2) & '-' & mid(status_created_at, 5, 3) & '-' & mid(status_created_at, 27, 4) & ' ' & mid(status_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as UserLookup_status_status_created_at_timestamp,

29/05/2015 11:07:34: 1430       date#(mid(status_created_at, 9, 2) & '-' & mid(status_created_at, 5, 3) & '-' & mid(status_created_at, 27, 4), 'DD-MMM-YYYY') as UserLookup_status_status_created_at_date,

29/05/2015 11:07:34: 1431       time#(mid(status_created_at, 12, 8), 'hh:mm:ss') as UserLookup_status_status_created_at_time,

29/05/2015 11:07:34: 1432       status_text as UserLookup_status_text,

29/05/2015 11:07:34: 1433       status_lang as UserLookup_status_lang,

29/05/2015 11:07:34: 1434       status_source as UserLookup_status_source,

29/05/2015 11:07:34: 1435       status_truncated as UserLookup_status_truncated,

29/05/2015 11:07:34: 1436       status_in_reply_to_screen_name as UserLookup_status_in_reply_to_screen_name,

29/05/2015 11:07:34: 1437       status_in_reply_to_status_id as UserLookup_status_in_reply_to_status_id,

29/05/2015 11:07:34: 1438       status_in_reply_to_user_id as UserLookup_status_in_reply_to_user_id,

29/05/2015 11:07:34: 1439       status_retweet_count as UserLookup_status_retweet_count,

29/05/2015 11:07:34: 1440       status_favorite_count as UserLookup_status_favorite_count,

29/05/2015 11:07:34: 1441       status_retweeted as UserLookup_status_retweeted,

29/05/2015 11:07:34: 1442       status_favorited as UserLookup_status_favorited,

29/05/2015 11:07:34: 1443       status_possibly_sensitive as UserLookup_status_possibly_sensitive,

29/05/2015 11:07:34: 1444       status_hashtag_count as UserLookup_status_hashtag_count,

29/05/2015 11:07:34: 1445       status_hash_tags as UserLookup_status_hash_tags,

29/05/2015 11:07:34: 1446       status_first_hash_tag as UserLookup_status_first_hash_tag,

29/05/2015 11:07:34: 1447       status_url_count as UserLookup_status_url_count,

29/05/2015 11:07:34: 1448       status_expanded_urls as UserLookup_status_expanded_urls,

29/05/2015 11:07:34: 1449       status_first_expanded_url as UserLookup_status_first_expanded_url,

29/05/2015 11:07:34: 1450       status_user_mentions_count as UserLookup_status_user_mentions_count,

29/05/2015 11:07:34: 1451       status_user_mentions as UserLookup_status_user_mentions,

29/05/2015 11:07:34: 1452       status_first_user_mention as UserLookup_status_first_user_mention,

29/05/2015 11:07:34: 1453       status_media_count as UserLookup_status_media_count,

29/05/2015 11:07:34: 1454       status_media_expanded_urls as UserLookup_status_media_expanded_urls,

29/05/2015 11:07:34: 1455       status_first_media_expanded_url as UserLookup_status_first_media_expanded_url,

29/05/2015 11:07:34: 1456       status_symbols_count as UserLookup_status_symbols_count,

29/05/2015 11:07:34: 1457       status_symbols as UserLookup_status_symbols,

29/05/2015 11:07:34: 1458       status_first_symbol as UserLookup_status_first_symbol,

29/05/2015 11:07:34: 1459       status_media_photo_count as UserLookup_status_media_photo_count,

29/05/2015 11:07:34: 1460       status_media_photo_urls as UserLookup_status_media_photo_urls,

29/05/2015 11:07:34: 1461       status_first_media_photo_url as UserLookup_status_first_media_photo_url,

29/05/2015 11:07:34: 1462       status_place_id as UserLookup_status_place_id,

29/05/2015 11:07:34: 1463       status_place_url as UserLookup_status_place_url,

29/05/2015 11:07:34: 1464       status_place_place_type as UserLookup_status_place_place_type,

29/05/2015 11:07:34: 1465       status_place_name as UserLookup_status_place_name,

29/05/2015 11:07:34: 1466       status_place_full_name as UserLookup_status_place_full_name,

29/05/2015 11:07:34: 1467       status_place_country_code as UserLookup_status_place_country_code,

29/05/2015 11:07:34: 1468       status_place_country as UserLookup_status_place_country,

29/05/2015 11:07:34: 1469       status_place_bounding_box_type as UserLookup_status_place_bounding_box_type,

29/05/2015 11:07:34: 1470       status_place_attributes as UserLookup_status_place_attributes,

29/05/2015 11:07:34: 1471       status_geo_type as UserLookup_status_geo_type,

29/05/2015 11:07:34: 1472       status_geo_latitude as UserLookup_status_geo_latitude,

29/05/2015 11:07:34: 1473       status_geo_longitude as UserLookup_status_geo_longitude,

29/05/2015 11:07:34: 1474       status_coordinates_type as UserLookup_status_coordinates_type,

29/05/2015 11:07:34: 1475       status_coordinates_latitude as UserLookup_status_coordinates_latitude,

29/05/2015 11:07:34: 1476       status_coordinates_longitude as UserLookup_status_coordinates_longitude,

29/05/2015 11:07:34: 1477       status_retweeted_status_id as UserLookup_status_retweeted_status_id,

29/05/2015 11:07:34: 1478       status_retweeted_status_created_at as UserLookup_status_retweeted_status_created_at,

29/05/2015 11:07:34: 1479       timestamp#(mid(status_retweeted_status_created_at, 9, 2) & '-' & mid(status_retweeted_status_created_at, 5, 3) & '-' & mid(status_retweeted_status_created_at, 27, 4) & ' ' & mid(status_retweeted_status_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as UserLookup_status_retweeted_status_status_retweeted_status_created_at_timestamp,

29/05/2015 11:07:34: 1480       date#(mid(status_retweeted_status_created_at, 9, 2) & '-' & mid(status_retweeted_status_created_at, 5, 3) & '-' & mid(status_retweeted_status_created_at, 27, 4), 'DD-MMM-YYYY') as UserLookup_status_retweeted_status_status_retweeted_status_created_at_date,

29/05/2015 11:07:34: 1481       time#(mid(status_retweeted_status_created_at, 12, 8), 'hh:mm:ss') as UserLookup_status_retweeted_status_status_retweeted_status_created_at_time,

29/05/2015 11:07:34: 1482       status_retweeted_status_text as UserLookup_status_retweeted_status_text,

29/05/2015 11:07:34: 1483       status_retweeted_status_lang as UserLookup_status_retweeted_status_lang,

29/05/2015 11:07:34: 1484       status_retweeted_status_source as UserLookup_status_retweeted_status_source,

29/05/2015 11:07:34: 1485       status_retweeted_status_truncated as UserLookup_status_retweeted_status_truncated,

29/05/2015 11:07:34: 1486       status_retweeted_status_in_reply_to_screen_name as UserLookup_status_retweeted_status_in_reply_to_screen_name,

29/05/2015 11:07:34: 1487       status_retweeted_status_in_reply_to_status_id as UserLookup_status_retweeted_status_in_reply_to_status_id,

29/05/2015 11:07:34: 1488       status_retweeted_status_in_reply_to_user_id as UserLookup_status_retweeted_status_in_reply_to_user_id,

29/05/2015 11:07:34: 1489       status_retweeted_status_retweet_count as UserLookup_status_retweeted_status_retweet_count,

29/05/2015 11:07:34: 1490       status_retweeted_status_favorite_count as UserLookup_status_retweeted_status_favorite_count,

29/05/2015 11:07:34: 1491       status_retweeted_status_retweeted as UserLookup_status_retweeted_status_retweeted,

29/05/2015 11:07:34: 1492       status_retweeted_status_favorited as UserLookup_status_retweeted_status_favorited,

29/05/2015 11:07:34: 1493       status_retweeted_status_possibly_sensitive as UserLookup_status_retweeted_status_possibly_sensitive,

29/05/2015 11:07:34: 1494       status_retweeted_status_hashtag_count as UserLookup_status_retweeted_status_hashtag_count,

29/05/2015 11:07:34: 1495       status_retweeted_status_hash_tags as UserLookup_status_retweeted_status_hash_tags,

29/05/2015 11:07:34: 1496       status_retweeted_status_first_hash_tag as UserLookup_status_retweeted_status_first_hash_tag,

29/05/2015 11:07:34: 1497       status_retweeted_status_url_count as UserLookup_status_retweeted_status_url_count,

29/05/2015 11:07:34: 1498       status_retweeted_status_expanded_urls as UserLookup_status_retweeted_status_expanded_urls,

29/05/2015 11:07:34: 1499       status_retweeted_status_first_expanded_url as UserLookup_status_retweeted_status_first_expanded_url,

29/05/2015 11:07:34: 1500       status_retweeted_status_user_mentions_count as UserLookup_status_retweeted_status_user_mentions_count,

29/05/2015 11:07:34: 1501       status_retweeted_status_user_mentions as UserLookup_status_retweeted_status_user_mentions,

29/05/2015 11:07:34: 1502       status_retweeted_status_first_user_mention as UserLookup_status_retweeted_status_first_user_mention,

29/05/2015 11:07:34: 1503       status_retweeted_status_media_count as UserLookup_status_retweeted_status_media_count,

29/05/2015 11:07:34: 1504       status_retweeted_status_media_expanded_urls as UserLookup_status_retweeted_status_media_expanded_urls,

29/05/2015 11:07:34: 1505       status_retweeted_status_first_media_expanded_url as UserLookup_status_retweeted_status_first_media_expanded_url,

29/05/2015 11:07:34: 1506       status_retweeted_status_symbols_count as UserLookup_status_retweeted_status_symbols_count,

29/05/2015 11:07:34: 1507       status_retweeted_status_symbols as UserLookup_status_retweeted_status_symbols,

29/05/2015 11:07:34: 1508       status_retweeted_status_first_symbol as UserLookup_status_retweeted_status_first_symbol,

29/05/2015 11:07:34: 1509       status_retweeted_status_media_photo_count as UserLookup_status_retweeted_status_media_photo_count,

29/05/2015 11:07:34: 1510       status_retweeted_status_media_photo_urls as UserLookup_status_retweeted_status_media_photo_urls,

29/05/2015 11:07:34: 1511       status_retweeted_status_first_media_photo_url as UserLookup_status_retweeted_status_first_media_photo_url,

29/05/2015 11:07:34: 1512       status_retweeted_status_place_id as UserLookup_status_retweeted_status_place_id,

29/05/2015 11:07:34: 1513       status_retweeted_status_place_url as UserLookup_status_retweeted_status_place_url,

29/05/2015 11:07:34: 1514       status_retweeted_status_place_place_type as UserLookup_status_retweeted_status_place_place_type,

29/05/2015 11:07:34: 1515       status_retweeted_status_place_name as UserLookup_status_retweeted_status_place_name,

29/05/2015 11:07:34: 1516       status_retweeted_status_place_full_name as UserLookup_status_retweeted_status_place_full_name,

29/05/2015 11:07:34: 1517       status_retweeted_status_place_country_code as UserLookup_status_retweeted_status_place_country_code,

29/05/2015 11:07:34: 1518       status_retweeted_status_place_country as UserLookup_status_retweeted_status_place_country,

29/05/2015 11:07:34: 1519       status_retweeted_status_place_bounding_box_type as UserLookup_status_retweeted_status_place_bounding_box_type,

29/05/2015 11:07:34: 1520       status_retweeted_status_place_attributes as UserLookup_status_retweeted_status_place_attributes,

29/05/2015 11:07:34: 1521       status_retweeted_status_geo_type as UserLookup_status_retweeted_status_geo_type,

29/05/2015 11:07:34: 1522       status_retweeted_status_geo_latitude as UserLookup_status_retweeted_status_geo_latitude,

29/05/2015 11:07:34: 1523       status_retweeted_status_geo_longitude as UserLookup_status_retweeted_status_geo_longitude,

29/05/2015 11:07:34: 1524       status_retweeted_status_coordinates_type as UserLookup_status_retweeted_status_coordinates_type,

29/05/2015 11:07:34: 1525       status_retweeted_status_coordinates_latitude as UserLookup_status_retweeted_status_coordinates_latitude,

29/05/2015 11:07:34: 1526       status_retweeted_status_coordinates_longitude as UserLookup_status_retweeted_status_coordinates_longitude

29/05/2015 11:07:34: 1527      FROM

29/05/2015 11:07:34: 1528        [http://localhost:5555/QVSource/TwitterConnectorV2/?table=UserLookup&appID=Social Media Analizer&tokenEncrypted=&tokenSecretEncrypted=ToTl4J9%2fLaYChHFpUMGe6lPYvCQDoN0k0wRi43JU%2fbLOBTOGmfYbe1jg4KiY%2fyOJ&userNames=Bancadinamica](qvx)

29/05/2015 11:07:35:           126 campi trovati: UserLookup_user_id, UserLookup_user_name, UserLookup_user_screen_name, UserLookup_user_location, UserLookup_user_profile_image_url, UserLookup_user_description, UserLookup_user_url, UserLookup_user_geo_enabled, UserLookup_user_protected, UserLookup_user_followers_count, UserLookup_user_friends_count, UserLookup_user_listed_count, UserLookup_user_favourites_count, UserLookup_user_statuses_count, UserLookup_user_created_at, UserLookup_user_user_created_at_timestamp, UserLookup_user_user_created_at_date, UserLookup_user_user_created_at_time, UserLookup_user_utc_offset, UserLookup_user_time_zone, UserLookup_user_verified, UserLookup_user_lang, UserLookup_user_follow_request_sent, UserLookup_user_is_translator, UserLookup_user_following, UserLookup_user_notifications, UserLookup_status_id, UserLookup_status_created_at, UserLookup_status_status_created_at_timestamp, UserLookup_status_status_created_at_date, UserLookup_status_status_created_at_time, UserLookup_status_text, UserLookup_status_lang, UserLookup_status_source, UserLookup_status_truncated, UserLookup_status_in_reply_to_screen_name, UserLookup_status_in_reply_to_status_id, UserLookup_status_in_reply_to_user_id, UserLookup_status_retweet_count, UserLookup_status_favorite_count, UserLookup_status_retweeted, UserLookup_status_favorited, UserLookup_status_possibly_sensitive, UserLookup_status_hashtag_count, UserLookup_status_hash_tags, UserLookup_status_first_hash_tag, UserLookup_status_url_count, UserLookup_status_expanded_urls, UserLookup_status_first_expanded_url, UserLookup_status_user_mentions_count, UserLookup_status_user_mentions, UserLookup_status_first_user_mention, UserLookup_status_media_count, UserLookup_status_media_expanded_urls, UserLookup_status_first_media_expanded_url, UserLookup_status_symbols_count, UserLookup_status_symbols, UserLookup_status_first_symbol, UserLookup_status_media_photo_count, UserLookup_status_media_photo_urls, UserLookup_status_first_media_photo_url, UserLookup_status_place_id, UserLookup_status_place_url, UserLookup_status_place_place_type, UserLookup_status_place_name, UserLookup_status_place_full_name, UserLookup_status_place_country_code, UserLookup_status_place_country, UserLookup_status_place_bounding_box_type, UserLookup_status_place_attributes, UserLookup_status_geo_type, UserLookup_status_geo_latitude, UserLookup_status_geo_longitude, UserLookup_status_coordinates_type, UserLookup_status_coordinates_latitude, UserLookup_status_coordinates_longitude, UserLookup_status_retweeted_status_id, UserLookup_status_retweeted_status_created_at, UserLookup_status_retweeted_status_status_retweeted_status_created_at_timestamp, UserLookup_status_retweeted_status_status_retweeted_status_created_at_date, UserLookup_status_retweeted_status_status_retweeted_status_created_at_time, UserLookup_status_retweeted_status_text, UserLookup_status_retweeted_status_lang, UserLookup_status_retweeted_status_source, UserLookup_status_retweeted_status_truncated, UserLookup_status_retweeted_status_in_reply_to_screen_name, UserLookup_status_retweeted_status_in_reply_to_status_id, UserLookup_status_retweeted_status_in_reply_to_user_id, UserLookup_status_retweeted_status_retweet_count, UserLookup_status_retweeted_status_favorite_count, UserLookup_status_retweeted_status_retweeted, UserLookup_status_retweeted_status_favorited, UserLookup_status_retweeted_status_possibly_sensitive, UserLookup_status_retweeted_status_hashtag_count, UserLookup_status_retweeted_status_hash_tags, UserLookup_status_retweeted_status_first_hash_tag, UserLookup_status_retweeted_status_url_count, UserLookup_status_retweeted_status_expanded_urls, UserLookup_status_retweeted_status_first_expanded_url, UserLookup_status_retweeted_status_user_mentions_count, UserLookup_status_retweeted_status_user_mentions, UserLookup_status_retweeted_status_first_user_mention, UserLookup_status_retweeted_status_media_count, UserLookup_status_retweeted_status_media_expanded_urls, UserLookup_status_retweeted_status_first_media_expanded_url, UserLookup_status_retweeted_status_symbols_count, UserLookup_status_retweeted_status_symbols, UserLookup_status_retweeted_status_first_symbol, UserLookup_status_retweeted_status_media_photo_count, UserLookup_status_retweeted_status_media_photo_urls, UserLookup_status_retweeted_status_first_media_photo_url, UserLookup_status_retweeted_status_place_id, UserLookup_status_retweeted_status_place_url, UserLookup_status_retweeted_status_place_place_type, UserLookup_status_retweeted_status_place_name, UserLookup_status_retweeted_status_place_full_name, UserLookup_status_retweeted_status_place_country_code, UserLookup_status_retweeted_status_place_country, UserLookup_status_retweeted_status_place_bounding_box_type, UserLookup_status_retweeted_status_place_attributes, UserLookup_status_retweeted_status_geo_type, UserLookup_status_retweeted_status_geo_latitude, UserLookup_status_retweeted_status_geo_longitude, UserLookup_status_retweeted_status_coordinates_type, UserLookup_status_retweeted_status_coordinates_latitude, UserLookup_status_retweeted_status_coordinates_longitude, 3 linee recuperate

29/05/2015 11:07:35: 1530      call logQVSourceError(ScriptErrorDetails, 'Twitter\Page\Bancadinamica')

29/05/2015 11:07:35: 0292        if(not isnull(errorDetails)) then

29/05/2015 11:07:35: 0304      end sub

29/05/2015 11:07:35: 1532    next

29/05/2015 11:07:35: 1395      let site = peek('tSite', 1, 'TwitterSites')

29/05/2015 11:07:35: 1396      let page = peek('tpage', 1, 'TwitterSites')

29/05/2015 11:07:35: 1398      TW_Page:

29/05/2015 11:07:35: 1399      LOAD

29/05/2015 11:07:35: 1400         

29/05/2015 11:07:35: 1401          user_id as UserLookup_user_id,

29/05/2015 11:07:35: 1402       user_name as UserLookup_user_name,

29/05/2015 11:07:35: 1403       user_screen_name as UserLookup_user_screen_name,

29/05/2015 11:07:35: 1404       user_location as UserLookup_user_location,

29/05/2015 11:07:35: 1405       user_profile_image_url as UserLookup_user_profile_image_url,

29/05/2015 11:07:35: 1406       user_description as UserLookup_user_description,

29/05/2015 11:07:35: 1407       user_url as UserLookup_user_url,

29/05/2015 11:07:35: 1408       user_geo_enabled as UserLookup_user_geo_enabled,

29/05/2015 11:07:35: 1409       user_protected as UserLookup_user_protected,

29/05/2015 11:07:35: 1410       user_followers_count as UserLookup_user_followers_count,

29/05/2015 11:07:35: 1411       user_friends_count as UserLookup_user_friends_count,

29/05/2015 11:07:35: 1412       user_listed_count as UserLookup_user_listed_count,

29/05/2015 11:07:35: 1413       user_favourites_count as UserLookup_user_favourites_count,

29/05/2015 11:07:35: 1414       user_statuses_count as UserLookup_user_statuses_count,

29/05/2015 11:07:35: 1415       user_created_at as UserLookup_user_created_at,

29/05/2015 11:07:35: 1416       timestamp#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4) & ' ' & mid(user_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as UserLookup_user_user_created_at_timestamp,

29/05/2015 11:07:35: 1417       date#(mid(user_created_at, 9, 2) & '-' & mid(user_created_at, 5, 3) & '-' & mid(user_created_at, 27, 4), 'DD-MMM-YYYY') as UserLookup_user_user_created_at_date,

29/05/2015 11:07:35: 1418       time#(mid(user_created_at, 12, 8), 'hh:mm:ss') as UserLookup_user_user_created_at_time,

29/05/2015 11:07:35: 1419       user_utc_offset as UserLookup_user_utc_offset,

29/05/2015 11:07:35: 1420       user_time_zone as UserLookup_user_time_zone,

29/05/2015 11:07:35: 1421       user_verified as UserLookup_user_verified,

29/05/2015 11:07:35: 1422       user_lang as UserLookup_user_lang,

29/05/2015 11:07:35: 1423       user_follow_request_sent as UserLookup_user_follow_request_sent,

29/05/2015 11:07:35: 1424       user_is_translator as UserLookup_user_is_translator,

29/05/2015 11:07:35: 1425       user_following as UserLookup_user_following,

29/05/2015 11:07:35: 1426       user_notifications as UserLookup_user_notifications,

29/05/2015 11:07:35: 1427       status_id as UserLookup_status_id,

29/05/2015 11:07:35: 1428       status_created_at as UserLookup_status_created_at,

29/05/2015 11:07:35: 1429       timestamp#(mid(status_created_at, 9, 2) & '-' & mid(status_created_at, 5, 3) & '-' & mid(status_created_at, 27, 4) & ' ' & mid(status_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as UserLookup_status_status_created_at_timestamp,

29/05/2015 11:07:35: 1430       date#(mid(status_created_at, 9, 2) & '-' & mid(status_created_at, 5, 3) & '-' & mid(status_created_at, 27, 4), 'DD-MMM-YYYY') as UserLookup_status_status_created_at_date,

29/05/2015 11:07:35: 1431       time#(mid(status_created_at, 12, 8), 'hh:mm:ss') as UserLookup_status_status_created_at_time,

29/05/2015 11:07:35: 1432       status_text as UserLookup_status_text,

29/05/2015 11:07:35: 1433       status_lang as UserLookup_status_lang,

29/05/2015 11:07:35: 1434       status_source as UserLookup_status_source,

29/05/2015 11:07:35: 1435       status_truncated as UserLookup_status_truncated,

29/05/2015 11:07:35: 1436       status_in_reply_to_screen_name as UserLookup_status_in_reply_to_screen_name,

29/05/2015 11:07:35: 1437       status_in_reply_to_status_id as UserLookup_status_in_reply_to_status_id,

29/05/2015 11:07:35: 1438       status_in_reply_to_user_id as UserLookup_status_in_reply_to_user_id,

29/05/2015 11:07:35: 1439       status_retweet_count as UserLookup_status_retweet_count,

29/05/2015 11:07:35: 1440       status_favorite_count as UserLookup_status_favorite_count,

29/05/2015 11:07:35: 1441       status_retweeted as UserLookup_status_retweeted,

29/05/2015 11:07:35: 1442       status_favorited as UserLookup_status_favorited,

29/05/2015 11:07:35: 1443       status_possibly_sensitive as UserLookup_status_possibly_sensitive,

29/05/2015 11:07:35: 1444       status_hashtag_count as UserLookup_status_hashtag_count,

29/05/2015 11:07:35: 1445       status_hash_tags as UserLookup_status_hash_tags,

29/05/2015 11:07:35: 1446       status_first_hash_tag as UserLookup_status_first_hash_tag,

29/05/2015 11:07:35: 1447       status_url_count as UserLookup_status_url_count,

29/05/2015 11:07:35: 1448       status_expanded_urls as UserLookup_status_expanded_urls,

29/05/2015 11:07:35: 1449       status_first_expanded_url as UserLookup_status_first_expanded_url,

29/05/2015 11:07:35: 1450       status_user_mentions_count as UserLookup_status_user_mentions_count,

29/05/2015 11:07:35: 1451       status_user_mentions as UserLookup_status_user_mentions,

29/05/2015 11:07:35: 1452       status_first_user_mention as UserLookup_status_first_user_mention,

29/05/2015 11:07:35: 1453       status_media_count as UserLookup_status_media_count,

29/05/2015 11:07:35: 1454       status_media_expanded_urls as UserLookup_status_media_expanded_urls,

29/05/2015 11:07:35: 1455       status_first_media_expanded_url as UserLookup_status_first_media_expanded_url,

29/05/2015 11:07:35: 1456       status_symbols_count as UserLookup_status_symbols_count,

29/05/2015 11:07:35: 1457       status_symbols as UserLookup_status_symbols,

29/05/2015 11:07:35: 1458       status_first_symbol as UserLookup_status_first_symbol,

29/05/2015 11:07:35: 1459       status_media_photo_count as UserLookup_status_media_photo_count,

29/05/2015 11:07:35: 1460       status_media_photo_urls as UserLookup_status_media_photo_urls,

29/05/2015 11:07:35: 1461       status_first_media_photo_url as UserLookup_status_first_media_photo_url,

29/05/2015 11:07:35: 1462       status_place_id as UserLookup_status_place_id,

29/05/2015 11:07:35: 1463       status_place_url as UserLookup_status_place_url,

29/05/2015 11:07:35: 1464       status_place_place_type as UserLookup_status_place_place_type,

29/05/2015 11:07:35: 1465       status_place_name as UserLookup_status_place_name,

29/05/2015 11:07:35: 1466       status_place_full_name as UserLookup_status_place_full_name,

29/05/2015 11:07:35: 1467       status_place_country_code as UserLookup_status_place_country_code,

29/05/2015 11:07:35: 1468       status_place_country as UserLookup_status_place_country,

29/05/2015 11:07:35: 1469       status_place_bounding_box_type as UserLookup_status_place_bounding_box_type,

29/05/2015 11:07:35: 1470       status_place_attributes as UserLookup_status_place_attributes,

29/05/2015 11:07:35: 1471       status_geo_type as UserLookup_status_geo_type,

29/05/2015 11:07:35: 1472       status_geo_latitude as UserLookup_status_geo_latitude,

29/05/2015 11:07:35: 1473       status_geo_longitude as UserLookup_status_geo_longitude,

29/05/2015 11:07:35: 1474       status_coordinates_type as UserLookup_status_coordinates_type,

29/05/2015 11:07:35: 1475       status_coordinates_latitude as UserLookup_status_coordinates_latitude,

29/05/2015 11:07:35: 1476       status_coordinates_longitude as UserLookup_status_coordinates_longitude,

29/05/2015 11:07:35: 1477       status_retweeted_status_id as UserLookup_status_retweeted_status_id,

29/05/2015 11:07:35: 1478       status_retweeted_status_created_at as UserLookup_status_retweeted_status_created_at,

29/05/2015 11:07:35: 1479       timestamp#(mid(status_retweeted_status_created_at, 9, 2) & '-' & mid(status_retweeted_status_created_at, 5, 3) & '-' & mid(status_retweeted_status_created_at, 27, 4) & ' ' & mid(status_retweeted_status_created_at, 12, 8), 'DD-MMM-YYYY hh:mm:ss') as UserLookup_status_retweeted_status_status_retweeted_status_created_at_timestamp,

29/05/2015 11:07:35: 1480       date#(mid(status_retweeted_status_created_at, 9, 2) & '-' & mid(status_retweeted_status_created_at, 5, 3) & '-' & mid(status_retweeted_status_created_at, 27, 4), 'DD-MMM-YYYY') as UserLookup_status_retweeted_status_status_retweeted_status_created_at_date,

29/05/2015 11:07:35: 1481       time#(mid(status_retweeted_status_created_at, 12, 8), 'hh:mm:ss') as UserLookup_status_retweeted_status_status_retweeted_status_created_at_time,

29/05/2015 11:07:35: 1482       status_retweeted_status_text as UserLookup_status_retweeted_status_text,

29/05/2015 11:07:35: 1483       status_retweeted_status_lang as UserLookup_status_retweeted_status_lang,

29/05/2015 11:07:35: 1484       status_retweeted_status_source as UserLookup_status_retweeted_status_source,

29/05/2015 11:07:35: 1485       status_retweeted_status_truncated as UserLookup_status_retweeted_status_truncated,

29/05/2015 11:07:35: 1486       status_retweeted_status_in_reply_to_screen_name as UserLookup_status_retweeted_status_in_reply_to_screen_name,

29/05/2015 11:07:35: 1487       status_retweeted_status_in_reply_to_status_id as UserLookup_status_retweeted_status_in_reply_to_status_id,

29/05/2015 11:07:35: 1488       status_retweeted_status_in_reply_to_user_id as UserLookup_status_retweeted_status_in_reply_to_user_id,

29/05/2015 11:07:35: 1489       status_retweeted_status_retweet_count as UserLookup_status_retweeted_status_retweet_count,

29/05/2015 11:07:35: 1490       status_retweeted_status_favorite_count as UserLookup_status_retweeted_status_favorite_count,

29/05/2015 11:07:35: 1491       status_retweeted_status_retweeted as UserLookup_status_retweeted_status_retweeted,

29/05/2015 11:07:35: 1492       status_retweeted_status_favorited as UserLookup_status_retweeted_status_favorited,

29/05/2015 11:07:35: 1493       status_retweeted_status_possibly_sensitive as UserLookup_status_retweeted_status_possibly_sensitive,

29/05/2015 11:07:35: 1494       status_retweeted_status_hashtag_count as UserLookup_status_retweeted_status_hashtag_count,

29/05/2015 11:07:35: 1495       status_retweeted_status_hash_tags as UserLookup_status_retweeted_status_hash_tags,

29/05/2015 11:07:35: 1496       status_retweeted_status_first_hash_tag as UserLookup_status_retweeted_status_first_hash_tag,

29/05/2015 11:07:35: 1497       status_retweeted_status_url_count as UserLookup_status_retweeted_status_url_count,

29/05/2015 11:07:35: 1498       status_retweeted_status_expanded_urls as UserLookup_status_retweeted_status_expanded_urls,

29/05/2015 11:07:35: 1499       status_retweeted_status_first_expanded_url as UserLookup_status_retweeted_status_first_expanded_url,

29/05/2015 11:07:35: 1500       status_retweeted_status_user_mentions_count as UserLookup_status_retweeted_status_user_mentions_count,

29/05/2015 11:07:35: 1501       status_retweeted_status_user_mentions as UserLookup_status_retweeted_status_user_mentions,

29/05/2015 11:07:35: 1502       status_retweeted_status_first_user_mention as UserLookup_status_retweeted_status_first_user_mention,

29/05/2015 11:07:35: 1503       status_retweeted_status_media_count as UserLookup_status_retweeted_status_media_count,

29/05/2015 11:07:35: 1504       status_retweeted_status_media_expanded_urls as UserLookup_status_retweeted_status_media_expanded_urls,

29/05/2015 11:07:35: 1505       status_retweeted_status_first_media_expanded_url as UserLookup_status_retweeted_status_first_media_expanded_url,

29/05/2015 11:07:35: 1506       status_retweeted_status_symbols_count as UserLookup_status_retweeted_status_symbols_count,

29/05/2015 11:07:35: 1507       status_retweeted_status_symbols as UserLookup_status_retweeted_status_symbols,

29/05/2015 11:07:35: 1508       status_retweeted_status_first_symbol as UserLookup_status_retweeted_status_first_symbol,

29/05/2015 11:07:35: 1509       status_retweeted_status_media_photo_count as UserLookup_status_retweeted_status_media_photo_count,

29/05/2015 11:07:35: 1510       status_retweeted_status_media_photo_urls as UserLookup_status_retweeted_status_media_photo_urls,

29/05/2015 11:07:35: 1511       status_retweeted_status_first_media_photo_url as UserLookup_status_retweeted_status_first_media_photo_url,

29/05/2015 11:07:35: 1512       status_retweeted_status_place_id as UserLookup_status_retweeted_status_place_id,

29/05/2015 11:07:35: 1513       status_retweeted_status_place_url as UserLookup_status_retweeted_status_place_url,

29/05/2015 11:07:35: 1514       status_retweeted_status_place_place_type as UserLookup_status_retweeted_status_place_place_type,

29/05/2015 11:07:35: 1515       status_retweeted_status_place_name as UserLookup_status_retweeted_status_place_name,

29/05/2015 11:07:35: 1516       status_retweeted_status_place_full_name as UserLookup_status_retweeted_status_place_full_name,

29/05/2015 11:07:35: 1517       status_retweeted_status_place_country_code as UserLookup_status_retweeted_status_place_country_code,

29/05/2015 11:07:35: 1518       status_retweeted_status_place_country as UserLookup_status_retweeted_status_place_country,

29/05/2015 11:07:35: 1519       status_retweeted_status_place_bounding_box_type as UserLookup_status_retweeted_status_place_bounding_box_type,

29/05/2015 11:07:35: 1520       status_retweeted_status_place_attributes as UserLookup_status_retweeted_status_place_attributes,

29/05/2015 11:07:35: 1521       status_retweeted_status_geo_type as UserLookup_status_retweeted_status_geo_type,

29/05/2015 11:07:35: 1522       status_retweeted_status_geo_latitude as UserLookup_status_retweeted_status_geo_latitude,

29/05/2015 11:07:35: 1523       status_retweeted_status_geo_longitude as UserLookup_status_retweeted_status_geo_longitude,

29/05/2015 11:07:35: 1524       status_retweeted_status_coordinates_type as UserLookup_status_retweeted_status_coordinates_type,

29/05/2015 11:07:35: 1525       status_retweeted_status_coordinates_latitude as UserLookup_status_retweeted_status_coordinates_latitude,

29/05/2015 11:07:35: 1526       status_retweeted_status_coordinates_longitude as UserLookup_status_retweeted_status_coordinates_longitude

29/05/2015 11:07:35: 1527      FROM

29/05/2015 11:07:35: 1528        [http://localhost:5555/QVSource/TwitterConnectorV2/?table=UserLookup&appID=Social Media Analizer&tokenEncrypted=&tokenSecretEncrypted=ToTl4J9%2fLaYChHFpUMGe6lPYvCQDoN0k0wRi43JU%2fbLOBTOGmfYbe1jg4KiY%2fyOJ&userNames=Bancadinamica](qvx)

29/05/2015 11:07:35:           126 campi trovati: UserLookup_user_id, UserLookup_user_name, UserLookup_user_screen_name, UserLookup_user_location, UserLookup_user_profile_image_url, UserLookup_user_description, UserLookup_user_url, UserLookup_user_geo_enabled, UserLookup_user_protected, UserLookup_user_followers_count, UserLookup_user_friends_count, UserLookup_user_listed_count, UserLookup_user_favourites_count, UserLookup_user_statuses_count, UserLookup_user_created_at, UserLookup_user_user_created_at_timestamp, UserLookup_user_user_created_at_date, UserLookup_user_user_created_at_time, UserLookup_user_utc_offset, UserLookup_user_time_zone, UserLookup_user_verified, UserLookup_user_lang, UserLookup_user_follow_request_sent, UserLookup_user_is_translator, UserLookup_user_following, UserLookup_user_notifications, UserLookup_status_id, UserLookup_status_created_at, UserLookup_status_status_created_at_timestamp, UserLookup_status_status_created_at_date, UserLookup_status_status_created_at_time, UserLookup_status_text, UserLookup_status_lang, UserLookup_status_source, UserLookup_status_truncated, UserLookup_status_in_reply_to_screen_name, UserLookup_status_in_reply_to_status_id, UserLookup_status_in_reply_to_user_id, UserLookup_status_retweet_count, UserLookup_status_favorite_count, UserLookup_status_retweeted, UserLookup_status_favorited, UserLookup_status_possibly_sensitive, UserLookup_status_hashtag_count, UserLookup_status_hash_tags, UserLookup_status_first_hash_tag, UserLookup_status_url_count, UserLookup_status_expanded_urls, UserLookup_status_first_expanded_url, UserLookup_status_user_mentions_count, UserLookup_status_user_mentions, UserLookup_status_first_user_mention, UserLookup_status_media_count, UserLookup_status_media_expanded_urls, UserLookup_status_first_media_expanded_url, UserLookup_status_symbols_count, UserLookup_status_symbols, UserLookup_status_first_symbol, UserLookup_status_media_photo_count, UserLookup_status_media_photo_urls, UserLookup_status_first_media_photo_url, UserLookup_status_place_id, UserLookup_status_place_url, UserLookup_status_place_place_type, UserLookup_status_place_name, UserLookup_status_place_full_name, UserLookup_status_place_country_code, UserLookup_status_place_country, UserLookup_status_place_bounding_box_type, UserLookup_status_place_attributes, UserLookup_status_geo_type, UserLookup_status_geo_latitude, UserLookup_status_geo_longitude, UserLookup_status_coordinates_type, UserLookup_status_coordinates_latitude, UserLookup_status_coordinates_longitude, UserLookup_status_retweeted_status_id, UserLookup_status_retweeted_status_created_at, UserLookup_status_retweeted_status_status_retweeted_status_created_at_timestamp, UserLookup_status_retweeted_status_status_retweeted_status_created_at_date, UserLookup_status_retweeted_status_status_retweeted_status_created_at_time, UserLookup_status_retweeted_status_text, UserLookup_status_retweeted_status_lang, UserLookup_status_retweeted_status_source, UserLookup_status_retweeted_status_truncated, UserLookup_status_retweeted_status_in_reply_to_screen_name, UserLookup_status_retweeted_status_in_reply_to_status_id, UserLookup_status_retweeted_status_in_reply_to_user_id, UserLookup_status_retweeted_status_retweet_count, UserLookup_status_retweeted_status_favorite_count, UserLookup_status_retweeted_status_retweeted, UserLookup_status_retweeted_status_favorited, UserLookup_status_retweeted_status_possibly_sensitive, UserLookup_status_retweeted_status_hashtag_count, UserLookup_status_retweeted_status_hash_tags, UserLookup_status_retweeted_status_first_hash_tag, UserLookup_status_retweeted_status_url_count, UserLookup_status_retweeted_status_expanded_urls, UserLookup_status_retweeted_status_first_expanded_url, UserLookup_status_retweeted_status_user_mentions_count, UserLookup_status_retweeted_status_user_mentions, UserLookup_status_retweeted_status_first_user_mention, UserLookup_status_retweeted_status_media_count, UserLookup_status_retweeted_status_media_expanded_urls, UserLookup_status_retweeted_status_first_media_expanded_url, UserLookup_status_retweeted_status_symbols_count, UserLookup_status_retweeted_status_symbols, UserLookup_status_retweeted_status_first_symbol, UserLookup_status_retweeted_status_media_photo_count, UserLookup_status_retweeted_status_media_photo_urls, UserLookup_status_retweeted_status_first_media_photo_url, UserLookup_status_retweeted_status_place_id, UserLookup_status_retweeted_status_place_url, UserLookup_status_retweeted_status_place_place_type, UserLookup_status_retweeted_status_place_name, UserLookup_status_retweeted_status_place_full_name, UserLookup_status_retweeted_status_place_country_code, UserLookup_status_retweeted_status_place_country, UserLookup_status_retweeted_status_place_bounding_box_type, UserLookup_status_retweeted_status_place_attributes, UserLookup_status_retweeted_status_geo_type, UserLookup_status_retweeted_status_geo_latitude, UserLookup_status_retweeted_status_geo_longitude, UserLookup_status_retweeted_status_coordinates_type, UserLookup_status_retweeted_status_coordinates_latitude, UserLookup_status_retweeted_status_coordinates_longitude, 4 linee recuperate

29/05/2015 11:07:35: 1530      call logQVSourceError(ScriptErrorDetails, 'Twitter\Page\Bancadinamica')

29/05/2015 11:07:35: 0292        if(not isnull(errorDetails)) then

29/05/2015 11:07:35: 0304      end sub

29/05/2015 11:07:35: 1532    next

29/05/2015 11:07:35: 1534    STORE TW_Page INTO '..\QVD\TW_Page.qvd'

29/05/2015 11:07:35: 1536  end if

29/05/2015 11:07:35: 1538  let inst_pro_media = '..\QVD\INST_Media.qvd'

29/05/2015 11:07:35: 1540  let size = filesize('..\QVD\INST_Media.qvd')

29/05/2015 11:07:35: 1542  if not isnull(size) then

29/05/2015 11:07:35: 1543    INST_Media:

29/05/2015 11:07:35: 1544     LOAD * FROM '..\QVD\INST_Media.qvd' (qvd)

29/05/2015 11:07:35:         52 campi trovati: MediaByTag_id, MediaByTag_min_tag_id, MediaByTag_max_tag_id, MediaByTag_type, MediaByTag_tags, MediaByTag_location_id, MediaByTag_location_name, MediaByTag_location_latitude, MediaByTag_location_longitude, MediaByTag_filter, MediaByTag_link, MediaByTag_created_time, MediaByTag_created_time_utc, MediaByTag_created_time_utc_qlik_timestamp, MediaByTag_created_time_utc_qlik_date, MediaByTag_comments_count, MediaByTag_likes_count, MediaByTag_caption_created_time, MediaByTag_caption_created_time_utc, MediaByTag_caption_created_time_utc_qlik_timestamp, MediaByTag_caption_created_time_utc_qlik_date, MediaByTag_caption_text, MediaByTag_caption_from_username, MediaByTag_caption_from_profile_picture, MediaByTag_caption_from_id, MediaByTag_caption_from_full_name, MediaByTag_caption_id, MediaByTag_images_low_resolution_url, MediaByTag_images_low_resolution_width, MediaByTag_images_low_resolution_height, MediaByTag_images_thumbnail_url, MediaByTag_images_thumbnail_width, MediaByTag_images_thumbnail_height, MediaByTag_images_standard_resolution_url, MediaByTag_images_standard_resolution_width, MediaByTag_images_standard_resolution_height, MediaByTag_videos_low_bandwidth_url, MediaByTag_videos_low_bandwidth_width, MediaByTag_videos_low_bandwidth_height, MediaByTag_videos_standard_resolution_url, MediaByTag_videos_standard_resolution_width, MediaByTag_videos_standard_resolution_height, MediaByTag_videos_low_resolution_url, MediaByTag_videos_low_resolution_width, MediaByTag_videos_low_resolution_height, MediaByTag_user_has_liked, MediaByTag_user_username, MediaByTag_user_profile_picture, MediaByTag_user_full_name, MediaByTag_user_id, MediaByTag_users_in_photo_count, MediaByTag_users_in_photo_user_ids, 14 linee recuperate

29/05/2015 11:07:35: 1545  end if

29/05/2015 11:07:35: 1547  if(vGetLatestData=1) then

29/05/2015 11:07:35: 1549    let noRows = NoOfRows('TwitterSites')

29/05/2015 11:07:35: 1551    for i=0 to 2-1

29/05/2015 11:07:35: 1553      let site = peek('tSite', 0, 'TwitterSites')

29/05/2015 11:07:35: 1554      let page = peek('tpage', 0, 'TwitterSites')

29/05/2015 11:07:35: 1556      INST_Media:

29/05/2015 11:07:35: 1557      LOAD

29/05/2015 11:07:35: 1558       id as MediaByTag_id,

29/05/2015 11:07:35: 1559       min_tag_id as MediaByTag_min_tag_id,

29/05/2015 11:07:35: 1560       max_tag_id as MediaByTag_max_tag_id,

29/05/2015 11:07:35: 1561       type as MediaByTag_type,

29/05/2015 11:07:35: 1562       tags as MediaByTag_tags,

29/05/2015 11:07:35: 1563       location_id as MediaByTag_location_id,

29/05/2015 11:07:35: 1564       location_name as MediaByTag_location_name,

29/05/2015 11:07:35: 1565       location_latitude as MediaByTag_location_latitude,

29/05/2015 11:07:35: 1566       location_longitude as MediaByTag_location_longitude,

29/05/2015 11:07:35: 1567       filter as MediaByTag_filter,

29/05/2015 11:07:35: 1568       link as MediaByTag_link,

29/05/2015 11:07:35: 1569       created_time as MediaByTag_created_time,

29/05/2015 11:07:35: 1570       created_time_utc as MediaByTag_created_time_utc,

29/05/2015 11:07:35: 1571       timestamp#(created_time_utc, 'DD-MM-YYYY hh:mm:ss') as MediaByTag_created_time_utc_qlik_timestamp,

29/05/2015 11:07:35: 1572       date#(left(created_time_utc, 10), 'DD-MM-YYYY') as MediaByTag_created_time_utc_qlik_date,

29/05/2015 11:07:35: 1573       comments_count as MediaByTag_comments_count,

29/05/2015 11:07:35: 1574       likes_count as MediaByTag_likes_count,

29/05/2015 11:07:35: 1575       caption_created_time as MediaByTag_caption_created_time,

29/05/2015 11:07:35: 1576       caption_created_time_utc as MediaByTag_caption_created_time_utc,

29/05/2015 11:07:35: 1577       timestamp#(caption_created_time_utc, 'DD-MM-YYYY hh:mm:ss') as MediaByTag_caption_created_time_utc_qlik_timestamp,

29/05/2015 11:07:35: 1578       date#(left(caption_created_time_utc, 10), 'DD-MM-YYYY') as MediaByTag_caption_created_time_utc_qlik_date,

29/05/2015 11:07:35: 1579       caption_text as MediaByTag_caption_text,

29/05/2015 11:07:35: 1580       caption_from_username as MediaByTag_caption_from_username,

29/05/2015 11:07:35: 1581       caption_from_profile_picture as MediaByTag_caption_from_profile_picture,

29/05/2015 11:07:35: 1582       caption_from_id as MediaByTag_caption_from_id,

29/05/2015 11:07:35: 1583       caption_from_full_name as MediaByTag_caption_from_full_name,

29/05/2015 11:07:35: 1584       caption_id as MediaByTag_caption_id,

29/05/2015 11:07:35: 1585       images_low_resolution_url as MediaByTag_images_low_resolution_url,

29/05/2015 11:07:35: 1586       images_low_resolution_width as MediaByTag_images_low_resolution_width,

29/05/2015 11:07:35: 1587       images_low_resolution_height as MediaByTag_images_low_resolution_height,

29/05/2015 11:07:35: 1588       images_thumbnail_url as MediaByTag_images_thumbnail_url,

29/05/2015 11:07:35: 1589       images_thumbnail_width as MediaByTag_images_thumbnail_width,

29/05/2015 11:07:35: 1590       images_thumbnail_height as MediaByTag_images_thumbnail_height,

29/05/2015 11:07:35: 1591       images_standard_resolution_url as MediaByTag_images_standard_resolution_url,

29/05/2015 11:07:35: 1592       images_standard_resolution_width as MediaByTag_images_standard_resolution_width,

29/05/2015 11:07:35: 1593       images_standard_resolution_height as MediaByTag_images_standard_resolution_height,

29/05/2015 11:07:35: 1594       videos_low_bandwidth_url as MediaByTag_videos_low_bandwidth_url,

29/05/2015 11:07:35: 1595       videos_low_bandwidth_width as MediaByTag_videos_low_bandwidth_width,

29/05/2015 11:07:35: 1596       videos_low_bandwidth_height as MediaByTag_videos_low_bandwidth_height,

29/05/2015 11:07:35: 1597       videos_standard_resolution_url as MediaByTag_videos_standard_resolution_url,

29/05/2015 11:07:35: 1598       videos_standard_resolution_width as MediaByTag_videos_standard_resolution_width,

29/05/2015 11:07:35: 1599       videos_standard_resolution_height as MediaByTag_videos_standard_resolution_height,

29/05/2015 11:07:35: 1600       videos_low_resolution_url as MediaByTag_videos_low_resolution_url,

29/05/2015 11:07:35: 1601       videos_low_resolution_width as MediaByTag_videos_low_resolution_width,

29/05/2015 11:07:35: 1602       videos_low_resolution_height as MediaByTag_videos_low_resolution_height,

29/05/2015 11:07:35: 1603       user_has_liked as MediaByTag_user_has_liked,

29/05/2015 11:07:35: 1604       user_username as MediaByTag_user_username,

29/05/2015 11:07:35: 1605       user_profile_picture as MediaByTag_user_profile_picture,

29/05/2015 11:07:35: 1606       user_full_name as MediaByTag_user_full_name,

29/05/2015 11:07:35: 1607       user_id as MediaByTag_user_id,

29/05/2015 11:07:35: 1608       users_in_photo_count as MediaByTag_users_in_photo_count,

29/05/2015 11:07:35: 1609       users_in_photo_user_ids as MediaByTag_users_in_photo_user_ids

29/05/2015 11:07:35: 1610      FROM

29/05/2015 11:07:35: 1611        [http://localhost:5555/QVSource/InstagramConnector/?table=MediaByTag&appID=Social Media Analizer&tag=Bancadinamica](qvx)

29/05/2015 11:07:36:           52 campi trovati: MediaByTag_id, MediaByTag_min_tag_id, MediaByTag_max_tag_id, MediaByTag_type, MediaByTag_tags, MediaByTag_location_id, MediaByTag_location_name, MediaByTag_location_latitude, MediaByTag_location_longitude, MediaByTag_filter, MediaByTag_link, MediaByTag_created_time, MediaByTag_created_time_utc, MediaByTag_created_time_utc_qlik_timestamp, MediaByTag_created_time_utc_qlik_date, MediaByTag_comments_count, MediaByTag_likes_count, MediaByTag_caption_created_time, MediaByTag_caption_created_time_utc, MediaByTag_caption_created_time_utc_qlik_timestamp, MediaByTag_caption_created_time_utc_qlik_date, MediaByTag_caption_text, MediaByTag_caption_from_username, MediaByTag_caption_from_profile_picture, MediaByTag_caption_from_id, MediaByTag_caption_from_full_name, MediaByTag_caption_id, MediaByTag_images_low_resolution_url, MediaByTag_images_low_resolution_width, MediaByTag_images_low_resolution_height, MediaByTag_images_thumbnail_url, MediaByTag_images_thumbnail_width, MediaByTag_images_thumbnail_height, MediaByTag_images_standard_resolution_url, MediaByTag_images_standard_resolution_width, MediaByTag_images_standard_resolution_height, MediaByTag_videos_low_bandwidth_url, MediaByTag_videos_low_bandwidth_width, MediaByTag_videos_low_bandwidth_height, MediaByTag_videos_standard_resolution_url, MediaByTag_videos_standard_resolution_width, MediaByTag_videos_standard_resolution_height, MediaByTag_videos_low_resolution_url, MediaByTag_videos_low_resolution_width, MediaByTag_videos_low_resolution_height, MediaByTag_user_has_liked, MediaByTag_user_username, MediaByTag_user_profile_picture, MediaByTag_user_full_name, MediaByTag_user_id, MediaByTag_users_in_photo_count, MediaByTag_users_in_photo_user_ids, 21 linee recuperate

29/05/2015 11:07:36: 1614      trace "Tw Follower Url: " & http://localhost:5555/QVSource/InstagramConnector/?table=MediaByTag&appID=$(vQVSourceAppId)&tag=$(si...)

29/05/2015 11:07:36: 1614      "Tw Follower Url: " & http://localhost:5555/QVSource/InstagramConnector/?table=MediaByTag&appID=$(vQVSourceAppId)&tag=$(si...)

29/05/2015 11:07:36: 1614    next

29/05/2015 11:07:36: 1553      let site = peek('tSite', 1, 'TwitterSites')

29/05/2015 11:07:36: 1554      let page = peek('tpage', 1, 'TwitterSites')

29/05/2015 11:07:36: 1556      INST_Media:

29/05/2015 11:07:36: 1557      LOAD

29/05/2015 11:07:36: 1558       id as MediaByTag_id,

29/05/2015 11:07:36: 1559       min_tag_id as MediaByTag_min_tag_id,

29/05/2015 11:07:36: 1560       max_tag_id as MediaByTag_max_tag_id,

29/05/2015 11:07:36: 1561       type as MediaByTag_type,

29/05/2015 11:07:36: 1562       tags as MediaByTag_tags,

29/05/2015 11:07:36: 1563       location_id as MediaByTag_location_id,

29/05/2015 11:07:36: 1564       location_name as MediaByTag_location_name,

29/05/2015 11:07:36: 1565       location_latitude as MediaByTag_location_latitude,

29/05/2015 11:07:36: 1566       location_longitude as MediaByTag_location_longitude,

29/05/2015 11:07:36: 1567       filter as MediaByTag_filter,

29/05/2015 11:07:36: 1568       link as MediaByTag_link,

29/05/2015 11:07:36: 1569       created_time as MediaByTag_created_time,

29/05/2015 11:07:36: 1570       created_time_utc as MediaByTag_created_time_utc,

29/05/2015 11:07:36: 1571       timestamp#(created_time_utc, 'DD-MM-YYYY hh:mm:ss') as MediaByTag_created_time_utc_qlik_timestamp,

29/05/2015 11:07:36: 1572       date#(left(created_time_utc, 10), 'DD-MM-YYYY') as MediaByTag_created_time_utc_qlik_date,

29/05/2015 11:07:36: 1573       comments_count as MediaByTag_comments_count,

29/05/2015 11:07:36: 1574       likes_count as MediaByTag_likes_count,

29/05/2015 11:07:36: 1575       caption_created_time as MediaByTag_caption_created_time,

29/05/2015 11:07:36: 1576       caption_created_time_utc as MediaByTag_caption_created_time_utc,

29/05/2015 11:07:36: 1577       timestamp#(caption_created_time_utc, 'DD-MM-YYYY hh:mm:ss') as MediaByTag_caption_created_time_utc_qlik_timestamp,

29/05/2015 11:07:36: 1578       date#(left(caption_created_time_utc, 10), 'DD-MM-YYYY') as MediaByTag_caption_created_time_utc_qlik_date,

29/05/2015 11:07:36: 1579       caption_text as MediaByTag_caption_text,

29/05/2015 11:07:36: 1580       caption_from_username as MediaByTag_caption_from_username,

29/05/2015 11:07:36: 1581       caption_from_profile_picture as MediaByTag_caption_from_profile_picture,

29/05/2015 11:07:36: 1582       caption_from_id as MediaByTag_caption_from_id,

29/05/2015 11:07:36: 1583       caption_from_full_name as MediaByTag_caption_from_full_name,

29/05/2015 11:07:36: 1584       caption_id as MediaByTag_caption_id,

29/05/2015 11:07:36: 1585       images_low_resolution_url as MediaByTag_images_low_resolution_url,

29/05/2015 11:07:36: 1586       images_low_resolution_width as MediaByTag_images_low_resolution_width,

29/05/2015 11:07:36: 1587       images_low_resolution_height as MediaByTag_images_low_resolution_height,

29/05/2015 11:07:36: 1588       images_thumbnail_url as MediaByTag_images_thumbnail_url,

29/05/2015 11:07:36: 1589       images_thumbnail_width as MediaByTag_images_thumbnail_width,

29/05/2015 11:07:36: 1590       images_thumbnail_height as MediaByTag_images_thumbnail_height,

29/05/2015 11:07:36: 1591       images_standard_resolution_url as MediaByTag_images_standard_resolution_url,

29/05/2015 11:07:36: 1592       images_standard_resolution_width as MediaByTag_images_standard_resolution_width,

29/05/2015 11:07:36: 1593       images_standard_resolution_height as MediaByTag_images_standard_resolution_height,

29/05/2015 11:07:36: 1594       videos_low_bandwidth_url as MediaByTag_videos_low_bandwidth_url,

29/05/2015 11:07:36: 1595       videos_low_bandwidth_width as MediaByTag_videos_low_bandwidth_width,

29/05/2015 11:07:36: 1596       videos_low_bandwidth_height as MediaByTag_videos_low_bandwidth_height,

29/05/2015 11:07:36: 1597       videos_standard_resolution_url as MediaByTag_videos_standard_resolution_url,

29/05/2015 11:07:36: 1598       videos_standard_resolution_width as MediaByTag_videos_standard_resolution_width,

29/05/2015 11:07:36: 1599       videos_standard_resolution_height as MediaByTag_videos_standard_resolution_height,

29/05/2015 11:07:36: 1600       videos_low_resolution_url as MediaByTag_videos_low_resolution_url,

29/05/2015 11:07:36: 1601       videos_low_resolution_width as MediaByTag_videos_low_resolution_width,

29/05/2015 11:07:36: 1602       videos_low_resolution_height as MediaByTag_videos_low_resolution_height,

29/05/2015 11:07:36: 1603       user_has_liked as MediaByTag_user_has_liked,

29/05/2015 11:07:36: 1604       user_username as MediaByTag_user_username,

29/05/2015 11:07:36: 1605       user_profile_picture as MediaByTag_user_profile_picture,

29/05/2015 11:07:36: 1606       user_full_name as MediaByTag_user_full_name,

29/05/2015 11:07:36: 1607       user_id as MediaByTag_user_id,

29/05/2015 11:07:36: 1608       users_in_photo_count as MediaByTag_users_in_photo_count,

29/05/2015 11:07:36: 1609       users_in_photo_user_ids as MediaByTag_users_in_photo_user_ids

29/05/2015 11:07:36: 1610      FROM

29/05/2015 11:07:36: 1611        [http://localhost:5555/QVSource/InstagramConnector/?table=MediaByTag&appID=Social Media Analizer&tag=Bancadinamica](qvx)

29/05/2015 11:07:36:           52 campi trovati: MediaByTag_id, MediaByTag_min_tag_id, MediaByTag_max_tag_id, MediaByTag_type, MediaByTag_tags, MediaByTag_location_id, MediaByTag_location_name, MediaByTag_location_latitude, MediaByTag_location_longitude, MediaByTag_filter, MediaByTag_link, MediaByTag_created_time, MediaByTag_created_time_utc, MediaByTag_created_time_utc_qlik_timestamp, MediaByTag_created_time_utc_qlik_date, MediaByTag_comments_count, MediaByTag_likes_count, MediaByTag_caption_created_time, MediaByTag_caption_created_time_utc, MediaByTag_caption_created_time_utc_qlik_timestamp, MediaByTag_caption_created_time_utc_qlik_date, MediaByTag_caption_text, MediaByTag_caption_from_username, MediaByTag_caption_from_profile_picture, MediaByTag_caption_from_id, MediaByTag_caption_from_full_name, MediaByTag_caption_id, MediaByTag_images_low_resolution_url, MediaByTag_images_low_resolution_width, MediaByTag_images_low_resolution_height, MediaByTag_images_thumbnail_url, MediaByTag_images_thumbnail_width, MediaByTag_images_thumbnail_height, MediaByTag_images_standard_resolution_url, MediaByTag_images_standard_resolution_width, MediaByTag_images_standard_resolution_height, MediaByTag_videos_low_bandwidth_url, MediaByTag_videos_low_bandwidth_width, MediaByTag_videos_low_bandwidth_height, MediaByTag_videos_standard_resolution_url, MediaByTag_videos_standard_resolution_width, MediaByTag_videos_standard_resolution_height, MediaByTag_videos_low_resolution_url, MediaByTag_videos_low_resolution_width, MediaByTag_videos_low_resolution_height, MediaByTag_user_has_liked, MediaByTag_user_username, MediaByTag_user_profile_picture, MediaByTag_user_full_name, MediaByTag_user_id, MediaByTag_users_in_photo_count, MediaByTag_users_in_photo_user_ids, 28 linee recuperate

29/05/2015 11:07:36: 1614      trace "Tw Follower Url: " & http://localhost:5555/QVSource/InstagramConnector/?table=MediaByTag&appID=$(vQVSourceAppId)&tag=$(si...)

29/05/2015 11:07:36: 1614      "Tw Follower Url: " & http://localhost:5555/QVSource/InstagramConnector/?table=MediaByTag&appID=$(vQVSourceAppId)&tag=$(si...)

29/05/2015 11:07:36: 1614    next

29/05/2015 11:07:36: 1616    STORE INST_Media INTO '..\QVD\INST_Media.qvd'

29/05/2015 11:07:36: 1619  end if

29/05/2015 11:07:36: 1621  let youtube_pro_media      = '..\QVD\YOUTUBE_Media.qvd'

29/05/2015 11:07:36: 1622  let youtube_pro_media_stat = '..\QVD\YOUTUBE_Media_stat.qvd'

29/05/2015 11:07:36: 1624  let size = filesize('..\QVD\YOUTUBE_Media.qvd')

29/05/2015 11:07:36: 1626  if not isnull(size) then

29/05/2015 11:07:36: 1627    YOUTUBE_Media:

29/05/2015 11:07:36: 1628     LOAD * FROM '..\QVD\YOUTUBE_Media.qvd' (qvd)

29/05/2015 11:07:36:         13 campi trovati: VideoSearch_kind, Video_id, VideoSearch_videoLink, VideoSearch_publishedAt, VideoSearch_publishedAt_qlik_timestamp, VideoSearch_publishedAt_qlik_date, VideoSearch_channelId, VideoSearch_channelLink, VideoSearch_channelTitle, VideoSearch_title, VideoSearch_description, VideoSearch_thumbnailDefaultUrl, VideoSearch_liveBroadcastContent, 90 linee recuperate

29/05/2015 11:07:36: 1629  end if

29/05/2015 11:07:36: 1631  let size = filesize('..\QVD\YOUTUBE_Media_stat.qvd')

29/05/2015 11:07:36: 1633  if not isnull(size) then

29/05/2015 11:07:36: 1634    YOUTUBE_Media_stat:

29/05/2015 11:07:36: 1635     LOAD * FROM '..\QVD\YOUTUBE_Media.qvd' (qvd)

29/05/2015 11:07:36:         13 campi trovati: VideoSearch_kind, Video_id, VideoSearch_videoLink, VideoSearch_publishedAt, VideoSearch_publishedAt_qlik_timestamp, VideoSearch_publishedAt_qlik_date, VideoSearch_channelId, VideoSearch_channelLink, VideoSearch_channelTitle, VideoSearch_title, VideoSearch_description, VideoSearch_thumbnailDefaultUrl, VideoSearch_liveBroadcastContent, 180 linee recuperate

29/05/2015 11:07:36: 1636  end if

29/05/2015 11:07:36: 1639  if(vGetLatestData=1) then

29/05/2015 11:07:36: 1641    let noRows = NoOfRows('TwitterSites')

29/05/2015 11:07:36: 1643    for i=0 to 2-1

29/05/2015 11:07:36: 1645      let site = peek('tSite', 0, 'TwitterSites')

29/05/2015 11:07:36: 1646      let page = peek('tpage', 0, 'TwitterSites')

29/05/2015 11:07:36: 1648      YOUTUBE_Media:

29/05/2015 11:07:36: 1649      LOAD

29/05/2015 11:07:36: 1650         kind as VideoSearch_kind,

29/05/2015 11:07:36: 1651       videoId as Video_id,

29/05/2015 11:07:36: 1652       videoLink as VideoSearch_videoLink,

29/05/2015 11:07:36: 1653       publishedAt as VideoSearch_publishedAt,

29/05/2015 11:07:36: 1654       timestamp#(left(publishedAt, 10) & ' ' & mid(publishedAt, 12, 8), 'YYYY-MM-DD hh:mm:ss') as VideoSearch_publishedAt_qlik_timestamp,

29/05/2015 11:07:36: 1655          Date(date#(left(publishedAt, 10), 'YYYY-MM-DD'),'DD-MM-YYYY') as VideoSearch_publishedAt_qlik_date,

29/05/2015 11:07:36: 1656       channelId as VideoSearch_channelId,

29/05/2015 11:07:36: 1657       channelLink as VideoSearch_channelLink,

29/05/2015 11:07:36: 1658       channelTitle as VideoSearch_channelTitle,

29/05/2015 11:07:36: 1659       title as VideoSearch_title,

29/05/2015 11:07:36: 1660       description as VideoSearch_description,

29/05/2015 11:07:36: 1661       thumbnailDefaultUrl as VideoSearch_thumbnailDefaultUrl,

29/05/2015 11:07:36: 1662       liveBroadcastContent as VideoSearch_liveBroadcastContent

29/05/2015 11:07:36: 1663      FROM

29/05/2015 11:07:36: 1664        [http://localhost:5555/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=Social Media Analizer&query=Bancadinamica](qvx)

29/05/2015 11:07:36: 1665        where VideoSearch_channelTitle=Bancadinamica

29/05/2015 11:07:37:           Errore: Campo non trovato - <VideoSearch_channelTitle>

29/05/2015 11:07:47: 1668      trace "YOUTUBE_Media: " & http://localhost:5555/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query=$...)

29/05/2015 11:07:47: 1668      "YOUTUBE_Media: " & http://localhost:5555/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query=$...)

29/05/2015 11:07:47: 1669    next

29/05/2015 11:07:47: 1645      let site = peek('tSite', 1, 'TwitterSites')

29/05/2015 11:07:47: 1646      let page = peek('tpage', 1, 'TwitterSites')

29/05/2015 11:07:48: 1648      YOUTUBE_Media:

29/05/2015 11:07:48: 1649      LOAD

29/05/2015 11:07:48: 1650         kind as VideoSearch_kind,

29/05/2015 11:07:48: 1651       videoId as Video_id,

29/05/2015 11:07:48: 1652       videoLink as VideoSearch_videoLink,

29/05/2015 11:07:48: 1653       publishedAt as VideoSearch_publishedAt,

29/05/2015 11:07:48: 1654       timestamp#(left(publishedAt, 10) & ' ' & mid(publishedAt, 12, 8), 'YYYY-MM-DD hh:mm:ss') as VideoSearch_publishedAt_qlik_timestamp,

29/05/2015 11:07:48: 1655          Date(date#(left(publishedAt, 10), 'YYYY-MM-DD'),'DD-MM-YYYY') as VideoSearch_publishedAt_qlik_date,

29/05/2015 11:07:48: 1656       channelId as VideoSearch_channelId,

29/05/2015 11:07:48: 1657       channelLink as VideoSearch_channelLink,

29/05/2015 11:07:48: 1658       channelTitle as VideoSearch_channelTitle,

29/05/2015 11:07:48: 1659       title as VideoSearch_title,

29/05/2015 11:07:48: 1660       description as VideoSearch_description,

29/05/2015 11:07:48: 1661       thumbnailDefaultUrl as VideoSearch_thumbnailDefaultUrl,

29/05/2015 11:07:48: 1662       liveBroadcastContent as VideoSearch_liveBroadcastContent

29/05/2015 11:07:48: 1663      FROM

29/05/2015 11:07:48: 1664        [http://localhost:5555/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=Social Media Analizer&query=Bancadinamica](qvx)

29/05/2015 11:07:48: 1665        where VideoSearch_channelTitle=Bancadinamica

29/05/2015 11:07:48:           Errore: Campo non trovato - <VideoSearch_channelTitle>

29/05/2015 11:07:49:           General Script Error

29/05/2015 11:07:49:           Esecuzione fallita

29/05/2015 11:07:49:      Azione conclusa

[Gabriel]

Hi,

Are you able post sample file? All that's left is investigate your data model as a whole.

Please post sample file

[marco_puccetti]

What do you mean for sample file, the log file?

Marco