最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

I can't process an xlsx file after importing it via a blob attribute en Genexus 18 - Stack Overflow

programmeradmin1浏览0评论

We have a project in Genexus 15 web, c# where we upload an xlsx file and then process it to import that data and it works without problems. We migrated the project and the processes where we use blob type attributes to import data stopped working.

Can someone give us an idea if we have to modify something in Gx 18 to be able to migrate these processes?

&Archivo is an blob attribute &filepath is an varchar attribute

We have a project in Genexus 15 web, c# where we upload an xlsx file and then process it to import that data and it works without problems. We migrated the project and the processes where we use blob type attributes to import data stopped working.

Can someone give us an idea if we have to modify something in Gx 18 to be able to migrate these processes?

&Archivo is an blob attribute &filepath is an varchar attribute

Share asked Feb 10 at 16:44 Falchini Cesar AdolfoFalchini Cesar Adolfo 334 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 1

This is due to security improvements since GX 17 u4

Instead of :

&RDEP_XLS.Open(&filepath)

Try this:

&File.Source = &filepath //&File: File datatype, &FilePath: Blob datatype
&RDEP_XLS.Open(&File.GetURI()) //&RDEP_XLS: ExcelDocument datatype
发布评论

评论列表(0)

  1. 暂无评论
ok 不同模板 switch ($forum['model']) { /*case '0': include _include(APP_PATH . 'view/htm/read.htm'); break;*/ default: include _include(theme_load('read', $fid)); break; } } break; case '10': // 主题外链 / thread external link http_location(htmlspecialchars_decode(trim($thread['description']))); break; case '11': // 单页 / single page $attachlist = array(); $imagelist = array(); $thread['filelist'] = array(); $threadlist = NULL; $thread['files'] > 0 and list($attachlist, $imagelist, $thread['filelist']) = well_attach_find_by_tid($tid); $data = data_read_cache($tid); empty($data) and message(-1, lang('data_malformation')); $tidlist = $forum['threads'] ? page_find_by_fid($fid, $page, $pagesize) : NULL; if ($tidlist) { $tidarr = arrlist_values($tidlist, 'tid'); $threadlist = well_thread_find($tidarr, $pagesize); // 按之前tidlist排序 $threadlist = array2_sort_key($threadlist, $tidlist, 'tid'); } $allowpost = forum_access_user($fid, $gid, 'allowpost'); $allowupdate = forum_access_mod($fid, $gid, 'allowupdate'); $allowdelete = forum_access_mod($fid, $gid, 'allowdelete'); $access = array('allowpost' => $allowpost, 'allowupdate' => $allowupdate, 'allowdelete' => $allowdelete); $header['title'] = $thread['subject']; $header['mobile_link'] = $thread['url']; $header['keywords'] = $thread['keyword'] ? $thread['keyword'] : $thread['subject']; $header['description'] = $thread['description'] ? $thread['description'] : $thread['brief']; $_SESSION['fid'] = $fid; if ($ajax) { empty($conf['api_on']) and message(0, lang('closed')); $apilist['header'] = $header; $apilist['extra'] = $extra; $apilist['access'] = $access; $apilist['thread'] = well_thread_safe_info($thread); $apilist['thread_data'] = $data; $apilist['forum'] = $forum; $apilist['imagelist'] = $imagelist; $apilist['filelist'] = $thread['filelist']; $apilist['threadlist'] = $threadlist; message(0, $apilist); } else { include _include(theme_load('single_page', $fid)); } break; default: message(-1, lang('data_malformation')); break; } ?>