10-05-2017 05:29 AM
Hi evreyone!
Got a bug here,
I'm exporting a .dat file that contains my route and water meter reading.
I'm importing this file with an addons that manage my route, but the readings dont appear in my custum readings table..
I will be lucky if any user of itron FCS system are using act like me on this forum!
Thank you
10-05-2017 08:01 AM
Hi Oliver,
I cannot say i have seen this done before, however has it worked in the past via the addon? or is their anyway to export the file into a compatible format that Act would be able to import the data into?
10-05-2017 09:35 AM
10-05-2017 10:09 AM
I use topline designer to import to my custom table.
It handle .csv, or other database file.
Previously i added a lot of data from csv file it's works fine.
But here im stuck with my .dat file that contain my water meter reading information, adresse, unit of measure etc..
The dat file look like that
FHDN N 001000004000004000004N 000020 RHD01VICT01NN00000004000000000000000400040004000000NY0004000400040000000400000004000000040000 10052017NYA 0000 N CUS01VICT010019307-00-6512-8-000-0 200 Francois Bourgeois 0N 1 MTR01VICT01001000000000001000IA 49014967 000000000001000000010000000003NN NNWL0000 M3 N RDG01VICT01EAU L000099000R00000100000000000000010052017085945S000000000000USystem Ad000000500R 00000010000000000000 RFF01VICT0172012340 ERT 0000000000.0000000070000000000000000000000000000 0000N CUS01VICT010019205-99-4894-0-000-0 435 De la Jacques Cartier 0N 1 MTR01VICT01001000000000001000IA 49014972 000000000002000000020000000003NN NNWL0000 M3 N RDG01VICT01EAU L000099000R00000100000000000000010052017085945S000000000000USystem Ad000000500R 00000010000000000000 RFF01VICT0172028406 ERT 0000000000.0000000070000000000000000000000000000 0000N CUS01VICT010019306-12-8531-3-000-0 1001 PIERRE-ROUX EST 0N 1 MTR01VICT01001000000000001000IA 49014966 000000000003000000030000000003NN NNWL0000 M3 N RDG01VICT01EAU L000099000R00000100000000000000010052017085945S000000000000USystem Ad000000500R 00000010000000000000 RFF01VICT0172028400 ERT 0000000000.0000000070000000000000000000000000000 0000N CUS01VICT010019205-12-6607-7-000-0 707 Boulevard Pierre-Roux E 0N 1 MTR01VICT01001000000000001000IA 49015007 000000000004000000040000000003NN NNWL0000 M3 N RDG01VICT01EAU L000099000R00000100000000000000010052017085945S000000000000USystem Ad000000600R 00000010000000000000 RFF01VICT0172028422 ERT 0000000000.0000000070000000000000000000000000000 0000N RTR01VICT01NN00000004000000000000000400040004000000NY0004000400040000000400000004000000040000 10052017NYA 0000 N FTRN N 001000004000004000004N 000020
10-09-2017 01:18 AM
Unless there is an addon available that can import the .DAT file into Act. It maybe easier to look at converting the .DAT into .CSV/.XLS(X)
A google search gives these results.