SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;-€ #.##0,00';
SET TimeFormat='h.mm.ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY h.mm.ss[.fff]';
SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';
SET DayNames='lun;mar;mer;gio;ven;sab;dom';
SECTION ACCESS;
Access:
LOAD ACCESS,
USERID,
PASSWORD
FROM
..\Basedati\ACCESS2.xlsx
(ooxml, embedded labels, table is Foglio6);
SECTION APPLICATION;
Directory;
LOAD USERID,
SH01,
SH02,
SH03,
SH04,
SH05,
SH06,
SH07,
SH08,
SH09
FROM
..\Basedati\ACCESS2.xlsx
(ooxml, embedded labels, table is Foglio5);
CDC:
LOAD USERID,
CDC
FROM
..\Basedati\ACCESS2.xlsx
(ooxml, embedded labels, table is Foglio2);
LEFT JOIN(CDC)
LOAD USERID,
SL
FROM
..\Basedati\ACCESS2.xlsx
(ooxml, embedded labels, table is Foglio3);
LEFT JOIN(CDC)
LOAD USERID,
Venditore as VENDITORE
FROM
..\Basedati\ACCESS2.xlsx
(ooxml, embedded labels, table is Foglio1);
/*----------------------------------------------------------------------------------------------------------------*/
Basefull:
LOAD Err,
Default,
if(isnull(CDC),'-',CDC) as CDC,
if(IsNull(Cliente),'-',Cliente)as Cliente,
if(IsNull(Commessa),'-', Commessa)as Commessa,
if(IsNull(Agente),'-', Agente) as VENDITORE,
DocEntry,
TipoVend,
TipoComm,
if(IsNull(SL),'-', SL)as SL,
Categoria,
Tipo,
CodConto,
Conto,
Documento,
NDoc,
date(DataComp,'DD.MM.YYYY')as DataComp,
year(DataComp) as Anno,
month(DataComp) as Mese,
if ("Tipo"='Ricavi',[Imp]) as ImpRicavi,
if ("Tipo"='Costi',[Imp]) as ImpCosti,
DataDoc,
CodBP,
[Business Partner],
Descrizione,
DocOrigine,
Società,
NumRif1,
NRigaDoc1,
Fatturabile1,
Rimborsabile1,
if(isnull(Risorsa1),'-',Risorsa1) as Risorsa,
Quantità,
CostoHStd,
ImpEff,
CostoHStdEff,
TipoSL,
CodArt,
Ricavi,
Costi
FROM
[..\Basedati\Storico\*.xlsx]
/**/
(ooxml, embedded labels)where CodArt <> 'CONS' and DocOrigine <> 'PianoFatt' and (CDC)<> 'PERSONALE';
join(Basefull)
LOAD #,
Società,
DocEntry,
if(isnull(CDC),'-',CDC) as CDC,
TipoVend,
if(IsNull(Venditore),'-', Venditore) as VENDITORE,
if(IsNull(Comm),'-', Comm)as Commessa,
TipoComm,
if(IsNull(ClienteComm),'-',ClienteComm)as Cliente,
TipoSL,
if(IsNull(SL),'-', SL)as SL,
CatSL,
Tipo,
TipoDoc,
NDoc,
DataDoc,
CodBP,
NomeBP,
NumRif,
NRigaDoc,
CodArt,
Descr,
Fatturabile,
Rimborsabile,
if(isnull(Risorsa),'-',Risorsa) as Risorsa,
DocOrigine,
date(DataComp,'DD.MM.YYYY')as DataComp,
year(DataComp) as Anno,
month(DataComp) as Mese,
Quantità,
if ("Tipo"='Ricavi',[Imp]) as ImpRicavi,
if ("Tipo"='Costi',[Imp]) as ImpCosti,
CostoHStd,
CodConto,
NomeConto,
ImpEff,
CostoHStdEff
FROM
[..\Basedati\BaseDati\basedati.qvd]
/**/
(qvd)where CodArt <> 'CONS' and DocOrigine <> 'PianoFatt' and (CDC)<> 'PERSONALE';What is the last line of the CDC script on Personal? Are they folders or files? / Cosa fa l'ultima riga dello script CDC su Personale?Sono cartelle o file?
