Exporting water meter route from itron FCS to act!

[olivier.fortin]

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

[Dan Horn]

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? 

[Roy_Laudenslager]

I have to make an assumption here but it sounds like the addon created a custom table in the ACT! database for the route information. I'm also assuming that you are using the ACT! import to import to the route information. If that's the case, the ACT! import won;t import to the custom table. The addon company may provide a way to do the import. Another option would be to use OakMerge, a third party importer for ACT! that will import to custom tables.

[olivier.fortin]

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

[Dan Horn]

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.