FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC: Converting string ID's to numeric ID's

Converting string ID's to numeric ID's 7 months 5 days ago #3496

  • Jonas Boudewijns
  • Jonas Boudewijns's Avatar Topic Author
  • Offline
  • Posts: 3
Hey Flowheater team,

I.m back with another little challenge that i need some advice or help with.

I'm converting a database of our client to one of our own databases, but they used some different parameters as the ones we can use.

Their account ID's are strings like C4F7C7CE-A4E0-DD11-9930-000C29CF5199, while the column we want to enter them into are numeric with a limit of 11. Normally i'd enter an auto ID here, but the catch is that some of their ID's are in the database multiple times for the same client with different addresses. These ID's need to stay the same. Therefore i don't think auto ID will do.

I guess a .net heater could do the trick, but i'm not a hero when it comes to .net, or maybe there's an even easier solution that i'm completely overlooking, so i wanted to know your take on this.

Thanks in advance for the help!

Please Log in or Create an account to join the conversation.

Converting string ID's to numeric ID's 7 months 5 days ago #3497

  • Jonas Boudewijns
  • Jonas Boudewijns's Avatar Topic Author
  • Offline
  • Posts: 3
I think i found the answer to my own question. I didn.t know that when you change the auto-id to group change with auto detect that it would allow you to connect with the read field. Bit of an oversight on my part.

This can be considered solved!

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2019 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en