Сообщений в теме: 5

[PowerUser]

Коллеги, пытаюсь импортировать данные из csv-файла, сделанного консольной утилитой relog из blg-файла Perfomance Logs and Alerts (Tools -> External Monitors -> Import Data, файл формата Win2k perfomance monitor). При импорте ругань на одну колонку данных в файле: is not a valid floating point value

Собственно вот сам файл:
"(PDH-CSV 4.0) (Russian Daylight Time)(-240)","\\SIBERIA\ISA Server Firewall Packet Engine\Packets/sec","\\SIBERIA\ISA Server Firewall Packet Engine\Bytes/sec"
"09/29/2008 13:32:19.989"," "," "
"09/29/2008 13:32:34.989","516.00303302852262","471049.41960859683"
"09/29/2008 13:32:49.990","1640.4573896177069","1524158.0332384387"
"09/29/2008 13:33:04.990","2120.5491967306261","1986899.5354511954"
"09/29/2008 13:33:19.990","2436.0545309643571","2273813.5925099226"
"09/29/2008 13:33:34.991","3235.4499296854256","3032377.7841059123"
"09/29/2008 13:33:49.991","2909.4727911890373","2728991.3532308321"
"09/29/2008 13:34:04.992","3100.7388171410848","2910499.0415054089"
"09/29/2008 13:34:19.992","2936.8760120919769","2744190.7613262814"
"09/29/2008 13:34:34.993","3882.8625764736694","3640517.4364391277"
"09/29/2008 13:34:49.993","2116.8146297093035","1989184.6729815397"
"09/29/2008 13:35:04.994","2896.3465801995567","2702500.7410060503"
"09/29/2008 13:35:19.994","4262.2910668386803","3985742.8367059748"
"09/29/2008 13:35:34.995","2366.376636667293"," "
"09/29/2008 13:35:49.995","2523.4567899617527","2361561.3881872133"
"09/29/2008 13:36:04.996","3308.7884491599798","3098697.0479036989"
"09/29/2008 13:36:19.996","2905.279751303065","2722079.4749375065"
"09/29/2008 13:36:34.997","2628.5024696980181","2470067.9851352251"
"09/29/2008 13:36:49.997","2718.7630665902711","2546998.1688053743"
"09/29/2008 13:37:04.998","3323.7089654131441","3096859.9623706895"
"09/29/2008 13:37:19.998","3682.322802323315","3449036.4538419191"
"09/29/2008 13:37:34.999","2565.5899977607437","2398057.3108791392"
"09/29/2008 13:37:49.999","3483.6958644583578","3265295.1313998555"
"09/29/2008 13:38:05.000","2876.0140878990819","2705755.9737268519"
"09/29/2008 13:38:20.000","2597.4392452693842","2434223.4024628061"
"09/29/2008 13:38:35.001","2451.5852912092942","2300808.3628548244"
"09/29/2008 13:38:50.001","1843.636811309209","1726822.2844283343"
"09/29/2008 13:39:05.002","1435.6006660507467","1350315.5474520286"
"09/29/2008 13:39:20.002","950.9880928949932","886482.62254962977"
"09/29/2008 13:39:35.002","288.7079035133836","271411.69365584408"
"09/29/2008 13:39:50.003","73.460228829084684","69767.352461867238"


А вот ошибки, возникшие при импорте:

Failed to import data from line : 09/29/2008 13:32:34.989","516.00303302852262","471049.41960859683. (Internal:'516.00303302852262' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:32:49.990","1640.4573896177069","1524158.0332384387. (Internal:'1640.4573896177069' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:33:04.990","2120.5491967306261","1986899.5354511954. (Internal:'2120.5491967306261' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:33:19.990","2436.0545309643571","2273813.5925099226. (Internal:'2436.0545309643571' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:33:34.991","3235.4499296854256","3032377.7841059123. (Internal:'3235.4499296854256' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:33:49.991","2909.4727911890373","2728991.3532308321. (Internal:'2909.4727911890373' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:34:04.992","3100.7388171410848","2910499.0415054089. (Internal:'3100.7388171410848' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:34:19.992","2936.8760120919769","2744190.7613262814. (Internal:'2936.8760120919769' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:34:34.993","3882.8625764736694","3640517.4364391277. (Internal:'3882.8625764736694' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:34:49.993","2116.8146297093035","1989184.6729815397. (Internal:'2116.8146297093035' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:35:04.994","2896.3465801995567","2702500.7410060503. (Internal:'2896.3465801995567' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:35:19.994","4262.2910668386803","3985742.8367059748. (Internal:'4262.2910668386803' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:35:34.995","2366.376636667293"," . (Internal:'2366.376636667293' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:35:49.995","2523.4567899617527","2361561.3881872133. (Internal:'2523.4567899617527' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:36:04.996","3308.7884491599798","3098697.0479036989. (Internal:'3308.7884491599798' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:36:19.996","2905.279751303065","2722079.4749375065. (Internal:'2905.279751303065' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:36:34.997","2628.5024696980181","2470067.9851352251. (Internal:'2628.5024696980181' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:36:49.997","2718.7630665902711","2546998.1688053743. (Internal:'2718.7630665902711' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:37:04.998","3323.7089654131441","3096859.9623706895. (Internal:'3323.7089654131441' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:37:19.998","3682.322802323315","3449036.4538419191. (Internal:'3682.322802323315' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:37:34.999","2565.5899977607437","2398057.3108791392. (Internal:'2565.5899977607437' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:37:49.999","3483.6958644583578","3265295.1313998555. (Internal:'3483.6958644583578' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:38:05.000","2876.0140878990819","2705755.9737268519. (Internal:'2876.0140878990819' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:38:20.000","2597.4392452693842","2434223.4024628061. (Internal:'2597.4392452693842' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:38:35.001","2451.5852912092942","2300808.3628548244. (Internal:'2451.5852912092942' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:38:50.001","1843.636811309209","1726822.2844283343. (Internal:'1843.636811309209' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:39:05.002","1435.6006660507467","1350315.5474520286. (Internal:'1435.6006660507467' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:39:20.002","950.9880928949932","886482.62254962977. (Internal:'950.9880928949932' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:39:35.002","288.7079035133836","271411.69365584408. (Internal:'288.7079035133836' is not a valid floating point value)
Failed to import data from line : 09/29/2008 13:39:50.003","73.460228829084684","69767.352461867238. (Internal:'73.460228829084684' is not a valid floating point value)


Никак я не пойму, почему значение в этой колонке является неправильным 8-/
PS: Использую LoadRunner 9.1

[mangazey]

Никак я не пойму, почему значение в этой колонке является неправильным

Есть подозрение на слишком больше количество цифр после запятой.

Попробуй оставить пару цифр после запятой (точки) и посмотреть - пройдет ли импорт.
Если да, то проблема решена. Если нет - будем копать дальше.

[PowerUser]

Никак я не пойму, почему значение в этой колонке является неправильным

Есть подозрение на слишком больше количество цифр после запятой.

Попробуй оставить пару цифр после запятой (точки) и посмотреть - пройдет ли импорт.
Если да, то проблема решена. Если нет - будем копать дальше.

округлил значения до 3 цифр после точки, однако ничего не поменялось, ругается так же.

[Dmitry_NJ]

Никак я не пойму, почему значение в этой колонке является неправильным 8-/

Попробуйте поменять Regional Settings на машине (на которой делаете импорт) на English (United States). Либо оставьте ваши русские сеттинги и попробуйте заменить десятичную точку запятой для чисел во втором и третьем столбцах.

[PowerUser]

Никак я не пойму, почему значение в этой колонке является неправильным 8-/

Попробуйте поменять Regional Settings на машине (на которой делаете импорт) на English (United States). Либо оставьте ваши русские сеттинги и попробуйте заменить десятичную точку запятой для чисел во втором и третьем столбцах.

Попробовал оба варианта: вначале заменил точки на запятые, затем поменял на машине с LoadRunner "Региональные параметры" -> "Языковые стандарты и форматы" на Английский (США), на всякий случай перезагрузил систему. В обоих случаях результат одинаковый.
На машине с Loadunner установлена система Windows Server 2003 R2 SE Service Pack 2 Russian Edition, на машине со счетчиками - Windows Server 2003 EE Service Pack 2 English Edition

[PowerUser]

Разобрался. Достаточно в Advanced Settings использовать Use Custom Settings и установить требуемые разделители вручную.