ODBC not appear

Progettouno asked on May 29, 2019

Hello, we d’like to buy your pivot system.
We download trial, and try with ODBC this is a result in server:

___ocsv2___2.7.5/2.213
+mag_categoria,+mag_articolo,-mag_art_progpf,+mag_calzata,+mag_descri,+mag_descr_colore,+mag_numerazione,+mag_num,+mag_int,+mag_parco,+mag_omogeneo,+mag_art_fornitore,+mag_fornitore,+mag_un_misura,-mag_misure,+mag_cat,+mag_tipo,+mag_raggr,+mag_rettile,-mag_proc_prod,-mag_proc_prod_aggr,-mag_aliq_iva,-mag_prezzo_vend,-mag_ult_prez_acq,-mag_val_giac,-mag_prez_pond,-mag_costo_lifo,d+mag_data_carico,d+mag_data_scarico,-mag_sco_min,-mag_giacenza,-mag_ordinato,-mag_canc_pmp,-mag_canc_carico,-mag_giac_fin,-mag_pr_un_giac,-mag_esist_ult_canc,+mag_note,+mag_ubiold,-mag_prez_accoppiati,+mag_mig_cod,+mag_mig_col,-mag_qta_1,-mag_val_1,-mag_qta_2,-mag_val_2,-mag_qta_3,-mag_val_3,-mag_qta_4,-mag_val_4,-mag_qta_5,-mag_val_5,-mag_qta_6,-mag_val_6,-mag_qta_7,-mag_val_7,-mag_qta_8,-mag_val_8,-mag_qta_9,-mag_val_9,-mag_qta_10,-mag_val_10,-mag_qta_11,-mag_val_11,-mag_qta_12,-mag_val_12,+mag_immagine,-mag_div_bolle,+mag_filo_cod,+mag_filo_col,+mag_linea,-mag_multi_liv,+mag_colsuola_pel,-mag_prev_prez_acq,-mag_repfab,-mag_coeffconv,-mag_costo_std,+mag_conv_matrif,-mag_movim,-mag_fabb,-mag_impegn,-mag_ddt,-mag_buonop,+mag_fasepar,+mag_col_fornitore,+mag_cod_old,-mag_lunghezza,-mag_larghezza,-mag_altezza,-mag_peso,+mag_nomencla,-mag_appr_gg,-mag_appr_mm,-mag_appr_aa,+mag_ubi,+mag_matsemi,-mag_lottosmi,+mag_nome_scient,+mag_origine,+mag_conv_comp,-mag_composiz,-mag_scorta_min,-mag_doc_cites,-mag_lancio_gg,-mag_lancio_mm,-mag_lancio_aa,-mag_duplcons,+mag_semilav,+mag_creabar,+mag_dessintprod,-mag_fine_ind,+mag_utdtappr,-mag_matstrut,+mag_desetic,+mag_stgins,-mag_is_lama,-mag_ctrlscorta,-mag_mat_vend,-mag_semil_gesmat,-mag_lav_nofsca,+mag_tipoprod,+mag_codorig,-mag_scardoclav,-mag_data_obso,-mag_prez_inven,-mag_detass,-mag_perc_costcom,+mag_col_fornitorenew,+mag_forma_cod,+mag_forma_calz,+mag_setcom,-mag_obsoleto,-mag_desclib,-mag_fordatacons,-mag_fordatarien,-mag_temporaneo,-mag_nocostopf,-mag_bollelav,+mag_dablav,-mag_dismesso,-mag_col_abozzo
007,ACETF00540 01001,0,00,ETICHETTA PERSONALIZZATA ROSSI, , , , , , , ,43000024,PA,0, , , ET, ,4,0,0,0,1.6,0,0,0,,,0,0,0,0,0,0,0,0, , ,0, , ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, ,0, , , ,0, ,0,0,0,1.6, ,0,0,0,0,0, , ,ACETF0054001001 ,0,0,0,0, ,0,0,0, , ,0, , , ,0,0,0,0,0,0,0, , , ,0, ,0, , ,0,0,0,0,0, , ,0,0,0,0,0, , , , ,0,0,0,0,0,0,0, ,0,0
^0,ACETF00650 01001,0,^0,ETICHETTA PM AVORIO ,^0,^0,^0,^0,^0,^0,^0,43000002,PZ,0,^0,^0,^0,^0,4,0,0,0,0.133,0,0,0,,,0,1950,0,0,0,1950,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.133,^0,0,0,0,0,0,^0,^0,ACETF0065001001 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACETF00650 01002,0,^0,ETICHETTA PM NERA ,^0,^0,^0,^0,^0,^0,^0,^1,^1,0,^0,^0,^0,^0,4,0,0,0,0.0955,0,0,0,,,0,4220,0,0,0,4220,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.0955,^0,0,0,0,0,0,^0,^0,ACETF0065001002 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACETF00650 02001,0,^0,ETICHETTA TESSUTO ROSSIGNOL AV,^0,^0,^0,^0,^0,^0,^0,^1,^1,0,^0,^0,^0,^0,4,0,0,0,0.196,0,0,0,,,0,4925,0,0,0,4925,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.196,^0,0,0,0,0,0,^0,^0,ACETF0065002001 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACLAF00776 01001,0,^0,LACCIO COTONE ROVINATO 245S-CT,COL. 56 GRIGIO ,^0,^0,^0,^0,^0,^0,43000001,^0,0,^0,^0, LA,^0,4,0,0,0,0.37,0,0,0,,,0,72,0,0,0,72,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.37,^0,0,0,0,0,0,^0,^0,ACLAF0077601001 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACLAF00776 01002,0,^0,^4,COL. 66 BIANCO ,^0,^0,^0,^0,^0,^0,^2,^0,0,^0,^0,^1,^0,4,0,0,0,0.37,0,0,0,,,0,0,0,0,0,0,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.37,^0,0,0,0,0,0,^0,^0,ACLAF0077601002 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACLAF00776 01003,0,^0,^4,COL. 51 NERO ,^0,^0,^0,^0,^0,^0,^2,^0,0,^0,^0,^1,^0,4,0,0,0,0.37,0,0,0,,,0,216,0,0,0,216,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.37,^0,0,0,0,0,0,^0,^0,ACLAF0077601003 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACLAF00776 01004,0,^0,^4,COL. 65 ROSA ,^0,^0,^0,^0,^0,^0,^2,^0,0,^0,^0,^1,^0,4,0,0,0,0.37,0,0,0,,,0,0,0,0,0,0,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.37,^0,0,0,0,0,0,^0,^0,ACLAF0077601004 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACLAF00776 01005,0,^0,^4,COL. 175 GIALLO FLUO ,^0,^0,^0,^0,^0,^0,^2,^0,0,^0,^0,^1,^0,4,0,0,0,0.37,0,0,0,,,0,0,0,0,0,0,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.37,^0,0,0,0,0,0,^0,^0,ACLAF0077601005 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0
^0,ACLAF00776 01006,0,^0,^4,COL. 53 VERDE MILITARE ,^0,^0,^0,^0,^0,^0,^2,^0,0,^0,^0,^1,^0,4,0,0,0,0.37,0,0,0,,,0,0,0,0,0,0,0,0,^0,^0,0,^0,^0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,^0,0,^0,^0,^0,0,^0,0,0,0,0.37,^0,0,0,0,0,0,^0,^0,ACLAF0077601006 ,0,0,0,0,^0,0,0,0,^0,^0,0,^0,^0,^0,0,0,0,0,0,0,0,^0,^0,^0,0,^0,0,^0,^0,0,0,0,0,0,^0,^0,0,0,0,0,0,^0,^0,^0,^0,0,0,0,0,0,0,0,^0,0,0

When we show:
We see grid with only MAG_CATEGORIA 007 and nothing (see demopng in Attach files)
Thankyou

Attachments:
demo.png

2 answers

Public
Progettouno May 29, 2019

We also attach client/server

Attachments:
pivot.zip

Public
Vera Didenko Flexmonster May 30, 2019

Hello, Progettouno,
 
Thank you for reaching out to us.
 
We would like to point out that in Flexmonster when data is loaded and shown on the grid, a default slice is set. The slice defines which part of the data needs to be displayed. 
 
Here are some ways you can change which data is shown on the grid:
 
1) Click on the Fields icon. A window will appear where the slice can be configured.
    Here is a guide for more details
2) The default slice can also be configured by specifying the slice object in the report.
     For example: 

"dataSource": {
"filename": "http://www.flexmonster.com/download/data.csv"
},
"slice": {
"rows": [
{
"uniqueName": "Category",
}
],
"columns": [
{
"uniqueName": "[Measures]"
},
{
"uniqueName": "Color"
}
],
"measures": [
{
"uniqueName": "Price",
"aggregation": "sum",
"active": true
},
{
"uniqueName": "Discount",
"aggregation": "min",
"active": true
}
]
}

More details about the slice object can be found in our Slice guide.
 
Please let us know if this helps.
 
We are looking forward to hearing from you.
 
Feel free to contact us in case of any further questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer