ebs 报表导出 excle 有问号

Applies to:

Oracle Marketing - Version: 11.5.10.2 to 11.5.10.3 - Release: Unknown Release to 
Information in this document applies to any platform.
Checked for relevance 12-Sep-2011 and updated

Symptoms

Exporting entries generated from Marketing lists:
In responsibility Audience Workbench, you choose a list with entries, you click on the tab entries
and you click on the button EXPORT.

The Excel file is created but special characters of your language are transformed into '?'

The problem does not appear to be an Excel one because the same special characters are okay in other Excel files. But the problem is the same for every excel export.

What to do to get the correct characters?

Cause

Profile option FND_NATIVE_CLIENT_ENCODING incorrectly set.

Solution

Check the profile option "FND_NATIVE_CLIENT_ENCODING". It must be set to the appropriate value of your language character set:

eg. UTF8 for Slovenian characters.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25164132/viewspace-761186/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/25164132/viewspace-761186/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
您可以使用 AWS Management Console 或 AWS CLI 导出 Amazon Elastic Block Store (EBS) 卷的数据,并将其保存为 Excel 文件(.xlsx 格式)。这需要您安装 AWS Command Line Interface (CLI) 并创建一个 EC2 实例来运行导出命令。 以下是导出 EBS 卷数据的一些步骤: 1. 创建一个 EC2 实例并连接到该实例。 2. 安装 AWS CLI 并配置您的凭证。 3. 运行以下命令导出 EBS 卷数据并将其保存为 Excel 文件: `aws ec2 create-instance-export-task --instance-id <instance_id> --target-environment vmware --export-to-s3-task <S3 bucket and key> --format vmdk` `aws s3 cp s3://<S3 bucket and key>/<export_task_id>.vmdk - | aws ec2 import-snapshot --disk-container "Description=string,Format=vmdk,UserBucket={S3Bucket=<bucket_name>,S3Key=<S3 key>}"` `aws ec2 create-conversion-task --source-region <source_region> --source-disk "<snapshot_id>::<device_name>" --target-format vmdk --target-bucket <target_bucket> --target-prefix <prefix>` `aws s3 cp s3://<target_bucket>/<prefix>/<conversion_task_id>.vmdk - | aws ec2 create-image --name <image_name> --block-device-mappings "[{\"DeviceName\": \"<device_name>\", \"Ebs\":{\"SnapshotId\":\"<snapshot_id>\",\"VolumeSize\":<volume_size>,\"DeleteOnTermination\":true}}]" --virtualization-type hvm --description "<description>"` 4. 使用以下命令将 AMI 导出为 Excel 文件: `aws ec2 describe-images --image-ids <image_id> --query 'Images[*].[Name, BlockDeviceMappings[*].Ebs.VolumeId]' --output text | awk '{print $2}' | xargs -I {} sh -c 'aws ec2 create-snapshot --volume-id {} --description "Snapshot of {}" && echo "Created snapshot of {}"'` `aws ec2 describe-images --image-ids <image_id> --query 'Images[*].[Name, BlockDeviceMappings[*].Ebs.VolumeId]' --output text | awk '{print $2}' | xargs -I {} sh -c 'aws ec2 create-snapshot --volume-id {} --description "Snapshot of {}" && echo "Created snapshot of {}"'` `aws s3 cp s3://<S3 bucket>/<S3 key> - | sed 's/\t/,/g' > <output_file>.xlsx` 请注意,这只是一些基本步骤,您需要根据您的实际情况进行一些更改和调整。此外,这些命令可能会产生一些费用。请确保您已经了解了这些费用,并且您已经在 AWS 控制台上设置了适当的预算和限制。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值